SYMPTOM:
When a user executes reports using Strategy Developer 9.x, the following error message is encountered:
Error: SQL Generation Complete
QueryEngine encountered error: Fetch failed. Error type: Odbc error. Odbc operation attempted: SQLFetch. SQL0905N Unsuccessful execution due to resource limit being exceeded. Resource name = ASUTIME, limit = 000000000009 CPU seconds (000000115020 service units) derived from SYSIBM .DSNRLSTT1. SQLSTATE=57014
Error in Process method of Component: QueryEngineServer, Project 24, Job 192, Error Code= -2147212544.
CAUSE:
This is a database error. For detailed explanations of the error, go to:
http://publib.boulder.ibm.com/infocenter/db2help/index.jsp?topic=/com.ibm.db2.udb.doc/core/rsql0900.htm
This error is related to the setting for SQL_Max_Rows. If SQL_Max_Rows is set to a value other than unlimited, the error will occur.
For more information concerning SQL_Max_Rows, refer to the following Strategy Knowledge Base document:
KB5300-7XX-0483 - How is the 'Number of Report Result Rows' setting in the Strategy Intelligence Server implemented at the ODBC level?
WORKAROUND:
Strategy is unable to troubleshoot this database related error. As a workaround, disable the SQL_Max_Rows by setting it to unlimited.
Make the following adjustments after logging into Strategy Developer 9.x as the administrator:
Right-click on a project name and go to Project Configuration -> Governing and do the following:
