Hi All,
I get this Error Intermittently while trying to Execute the Report in interactive and Save Mode.
Let me Breif, We have this replication job in our System, Which replicate data in our Data Mart, So we Kill the Connections made from the Cognos till replication is compleated.
So when we Run the Report From cognos Post the Repolication Job from the Same Briowser which was open for some time from the replication start, it Gives a "Connection Failure Message" For 1-8 Minutes.
Please see the Log File error:
148.171.29.41:9915 7824 2011-03-07 02:04:25.844 -7 FBA890C2267C9780F5018DB3FC1969BEC49253EF l4yCqhlwy29922M42GvlyyCG2j2slw4G4syjldl8 l4yCqhlwy29922M42GvlyyCG2j2slw4G4syjldl8 11556 RSVP 878 3 Audit.RTUsage.RSVP Execute ReportView ReportService /content/folder[@name='Balance Sheet Accounts Reconciliation Status Reports']/folder[@name='Reports']/folder[@name='Reconciliation Status Report']/reportView[@name='001 Reconciliation Status Report Native Currency_EMEA_AXP_MU'] Failure RSV-SRV-0066 A soap fault has been returned. RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-9'.
UDA-SQL-0564 [Microsoft OLE DB Provider for SQL Server]Deferred prepare could not be completed.
UDA-SQL-0564 [Microsoft OLE DB Provider for SQL Server]The SELECT permission was denied on the object 'Reconciliation_Month_Dimension', database 'Report_DataMart_New', schema 'dbo'. (SQLSTATE=42000, SQLERRORCODE=229)
RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-9'.
UDA-SQL-0564 [Microsoft OLE DB Provider for SQL Server]Deferred prepare could not be completed.
UDA-SQL-0564 [Microsoft OLE DB Provider for SQL Server]The SELECT permission was denied on the object 'Reconciliation_Month_Dimension', database 'Report_DataMart_New', schema 'dbo'. (SQLSTATE=42000, SQLERRORCODE=229)
<parameters><item name="model"><![CDATA[Balance Sheet Accounts Reconciliation Status Reports]]></item><item name="storeID"><![CDATA[i1DB66B59275C42E5B3A321BE0054F9CA]]></item></parameters>
148.171.29.41:9915 1176 2011-03-07 02:04:25.938 -7 FBA890C2267C9780F5018DB3FC1969BEC49253EF vMwwhwwvCGCq2GCqG2s42qqh99s8GCqdy8d44GMG 0 Thread-6873 DISP 732 2 Audit.Other.dispatcher.DISP.com.cognos.pogo.handlers.engine.ServiceLookupHandler Request Failure <messages><message><messageString>Client Error</messageString></message></messages> http://developer.cognos.com/schemas/reportService/1.absolute
148.171.29.41:9915 1176 2011-03-07 02:04:25.954 -7
I am expecting this is Like Lock is not released on DB so the Reports Fail.
But this is somethins which we see intermittent.
Can you Please throw some light y is this happening?
Check your permissions on the database. It appears to me that you're not allowed to query this table.
Ask your dba-er to logon to the database with the same credentials as Cognos and then do a
"select * from Reconciliation_Month_Dimension. I bet this will
return the same error. You're most likely not granted select permissions on this table/database