Hi,
My cognos model has stored procedure, It has 4 optional and one manadatory parameter. Model has cube as well which is Model.
So the parameter input will be member unique name. when i exeucte the stored proecudere from database it works fine. But when i validate from report or model it throws below error. Please throw some light on this. Thanks
Did Datasource test from model and works fine.
UDA-SQL-0564 [Microsoft SQL Server Native Client 10.0]Syntax error, permission violation, or other nonspecific error (SQLSTATE=42000, SQLERRORCODE=0)
RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-121'.
UDA-SQL-0564 [Microsoft SQL Server Native Client 10.0]Syntax error, permission violation, or other nonspecific error (SQLSTATE=42000, SQLERRORCODE=0)
Resolving the problem
Workaround
Ensure all Controller users out of the system. Reboot Controller application server.
Long-term Fix:
Optimise the Cognos 8 BI reporting service environment, by:
Ensure that Controller product is upgraded to latest release, to take advantage of memory leak fixes, such as those described inside IBM Technotes #1347915, 1367340 & 1365078.
Afterwards, if the problem persists, follow the advice inside separate IBM Technote articles #1341779, 1021723 & 1032429.