"DB2 SQL error: SQLCODE: -952, SQLSTATE: 57014, SQLERRMC: null" During Normal WebCenterContent (Formerly UCM) Operations

(Doc ID 1299706.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle WebCenter Content - Version 10.1.3.3.0 to 11.1.1.4.0 [Release 10gR3 to 11g]
Information in this document applies to any platform.
Checked for Currency 28-MAY-2013

Symptoms

UCM performs an action that requires data from the DB2 database and instead of DB2 providing the data, the following exception is thrown in the UCM logs:

Event generated by user '<some user>' at host '<machinename>'.
Unable to execute service GET_DATARESULTSET and function createResultSetSQL.
(System Error: Unable to create result set for query <some sql query syntax>. DB2 SQL error: SQLCODE: -952, SQLSTATE: 57014, SQLERRMC: null com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -952, SQLSTATE: 57014, SQLERRMC: null [ Details ]

An error has occurred. The stack trace below shows more information.

!csUserEventMessage,<some user>,<machinename>!$!csServiceDataException,GET_DATARESULTSET,createResultSetSQL!$!csSystemError,\!csDbUnableToCreateResultSet\,<some sql query syntax>. !$DB2 SQL error: SQLCODE: -952\, SQLSTATE: 57014\, SQLERRMC: null!syExceptionType2,com.ibm.db2.jcc.b.SqlException,DB2 SQL error: SQLCODE: -952\, SQLSTATE: 57014\, SQLERRMC: null
intradoc.common.ServiceException: !csServiceDataException,GET_DATARESULTSET,createResultSetSQL!$!csSystemError,\!csDbUnableToCreateResultSet\,<some sql query syntax>, \!$DB2 SQL error: SQLCODE: -952\\\, SQLSTATE: 57014\\\, SQLERRMC: null
at intradoc.server.ServiceRequestImplementor.buildServiceException(ServiceRequestImplementor.java:1760)
at intradoc.server.Service.buildServiceException(Service.java:1997)
at intradoc.server.Service.createServiceExceptionEx(Service.java:1991)
at intradoc.server.Service.createServiceException(Service.java:1986)
at intradoc.server.ServiceRequestImplementor.handleActionException(ServiceRequestImplementor.java:1460)
at intradoc.server.ServiceRequestImplementor.doAction(ServiceRequestImplementor.java:1427)
at intradoc.server.Service.doAction(Service.java:452)
at intradoc.server.ServiceRequestImplementor.doActions(ServiceRequestImplementor.java:1201)
at intradoc.server.Service.doActions(Service.java:447)
at intradoc.server.ServiceRequestImplementor.executeActions(ServiceRequestImplementor.java:1121)
at intradoc.server.Service.executeActions(Service.java:433)
at intradoc.server.ServiceRequestImplementor.doRequest(ServiceRequestImplementor.java:635)
at intradoc.server.Service.doRequest(Service.java:1707)
at intradoc.server.ServiceManager.processCommand(ServiceManager.java:359)
at intradoc.server.IdcServerThread.run(IdcServerThread.java:197)
Caused by: intradoc.data.DataException: !csDbUnableToCreateResultSet,<some sql query syntax>, !$DB2 SQL error: SQLCODE: -952\, SQLSTATE: 57014\, SQLERRMC: null
at intradoc.jdbc.JdbcWorkspace.handleSQLException(JdbcWorkspace.java:2371)
at intradoc.jdbc.JdbcWorkspace.createResultSetSQL(JdbcWorkspace.java:806)
at intradoc.server.Service.createResultSetSQL(Service.java:3259)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:64)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:615)
at intradoc.common.IdcMethodHolder.invokeMethod(ClassHelperUtils.java:617)
at intradoc.common.ClassHelperUtils.executeMethodEx(ClassHelperUtils.java:279)
at intradoc.common.ClassHelperUtils.executeMethod(ClassHelperUtils.java:264)
at intradoc.server.Service.doCodeEx(Service.java:507)
at intradoc.server.Service.doCode(Service.java:472)
at intradoc.server.ServiceRequestImplementor.doAction(ServiceRequestImplementor.java:1360)
... 9 more
Caused by: com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -952, SQLSTATE: 57014, SQLERRMC: null
at com.ibm.db2.jcc.b.hh.b(hh.java:3071)
at com.ibm.db2.jcc.b.hh.a(hh.java:3054)
at com.ibm.db2.jcc.a.db.a(db.java:728)
at com.ibm.db2.jcc.a.db.m(db.java:717)
at com.ibm.db2.jcc.a.db.i(db.java:244)
at com.ibm.db2.jcc.a.db.c(db.java:53)
at com.ibm.db2.jcc.a.t.c(t.java:46)
at com.ibm.db2.jcc.a.sb.g(sb.java:154)
at com.ibm.db2.jcc.b.qh.o(qh.java:1230)
at com.ibm.db2.jcc.b.qh.a(qh.java:1893)
at com.ibm.db2.jcc.b.qh.a(qh.java:478)
at com.ibm.db2.jcc.b.qh.executeQuery(qh.java:462)
at intradoc.jdbc.JdbcWorkspace.createResultSetSQL(JdbcWorkspace.java:786)
... 20 more

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms