Cube Failed - Need help quick

[meeecog]

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

[bus_pass_man]

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

[meeecog]

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..

[meeecog]

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