Print Page - An error occurred while performing operation 'sqlPrepareWithOptions' status='-56

Title: An error occurred while performing operation 'sqlPrepareWithOptions' status='-56
Post by: sateesh tata on 22 Apr 2015 04:18:13 AM

Hi,
Any one please help on this issue.
UDA-SQL-0115 Inappropriate SQL request.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]Statement(s) could not be prepared. (SQLSTATE=42000, SQLERRORCODE=8180)UDA-SQL-0564 [Microsoft OLE DB Provider for SQL Server]Invalid object name 'DW_TAB_MARKET'.
no where we have a table DW_TAB_MARKET.

Title: Re: An error occurred while performing operation 'sqlPrepareWithOptions' status='-56
Post by: Virgin on 22 Apr 2015 07:23:33 AM

In your element of your report, you have one element in your request where you use function (case when ... then ... else ... end; if...then...else...) and it's this element which is probleme.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos Administration => Topic started by: sateesh tata on 22 Apr 2015 04:18:13 AM