This problem happens on z/OS®. When I run a query with an OR clause that should return
a lot of results, such as the following,
'/Employee[.//Degree/@Degree = "MBA" OR .//Job/@JobCategory = "Manager"]'
I get this exception:
com.ibm.mm.sdk.common.DKUsageError: DGL5050A: SQL error executing query.
XQPE query: /Employee[.//Degree/@Degree = "MBA" OR .//Job/@JobCategory = "Manager"].
Return code: 7015. Reason code: 0. Extended return code: -904. Extended
reason code: 0.;
ICM7015: During an SQL operation in the library server, an unexpected error occurred.
For details on the error, refer to the database document. (SERVER RC) : 7015 at com.ibm.mm.sdk.server.DKResultSetCursorICM.throwSQLException(DKResultSetCursorICM.java:1072) at com.ibm.mm.sdk.server.DKResultSetCursorICM.prepareAndExecuteSp(DKResultSetCursorICM.java:893) at com.ibm.mm.sdk.server.DKResultSetCursorICM.prepareAndExecuteSp(DKResultSetCurso rICM.java:768)
at com.ibm.mm.sdk.server.DKResultSetCursorICM.open(DKResultSetCursorICM.java:1159)
at com.ibm.mm.sdk.server.DKResultSetCursorICM.Init(DKResultSetCursorICM.java:221)
at com.ibm.mm.sdk.server.DKResultSetCursorICM.(DKResultSetCursorICM.java:122)
at com.ibm.mm.sdk.server.DKDatastoreICM.execute(DKDatastoreICM.java:4718)
at com.ibm.mm.sdk.server.DKDatastoreICM.evaluate(DKDatastoreICM.java:4313)
The library server log, ICMSERVER.log shows this error:
sqlca.sqlcode-904
< DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE. REASON 00C90084, TYPE OF RESOURCE 00000230, AND RESOURCE NAME 4K >
< DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE >
< DSNT415I SQLERRP = DSNXRSOR SQL PROCEDURE DETECTING ERROR >
< DSNT416I SQLERRD = -115 13172746 0 13231826 -959250432 0 SQL DIAGNOSTIC INFORMATION
[{"Product":{"code":"SSRS7Z","label":"IBM Content Manager Enterprise Edition"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"--","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.3","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSLQWS","label":"Content Manager for z\/OS"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"DB2 Information Integrator for Content","Platform":[{"code":"","label":""}],"Version":"8.3","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSRS7Z","label":"IBM Content Manager Enterprise Edition"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":null,"Platform":[{"code":"","label":""}],"Version":"8.3","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.