Hello Team
We are using Cognos 10.2.1 . DB2 database.
Using report studio reports as data sources in the Transformer . We are able to build 2 yrs worth of data in DEV environment (Remote Server)..but with the same FM , reports and cube model we are not able to build in SIT ( Remote server).
When we check data in DEV and SIT counts are the same ( Employee count etc) ..
Here is the Error
RQP-DEF-0177 An error occurred while performing operation 'sqlOpenResult' status='-9'.
UDA-SQL-0107 A general exception has occurred during the operation "AOpen".
[IBM][CLI Driver][DB2] SQL0904N Unsuccessful execution caused by an unavailable resource. Reason code: "00C90305", type of resource: "00000100", and resource name: "WORKDQK1". SQLSTATE=57011
Any help .
Thanks
The error is coming from db2 so the first place to start might be with that.
Here's info about SQL0904N
https://www.ibm.com/support/knowledgecenter/SSEPGG_9.8.0/com.ibm.db2.luw.messages.sql.doc/doc/msql00904n.html
I think this is the reason code
https://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/com.ibm.db2z10.doc.codes/src/tpc/00c90305.html
Thanks. We will check on the database ..I will try to run the report SQL outside cognos ..if that gives us data , we assume we are in good shape..
We are able to resolve by creating separate reports for each year ( 1 for 2013 and 1 for 2014) - This way it will have required space to read and build cube for each report.
Thx