Please Help with this Error

[richiearora]

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?

[sir_jeroen]

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