Question
Capgemini
Capgemini
IN
Capgemini
Posted: Nov 27, 2017
Last activity: Nov 28, 2017
Last activity: 28 Nov 2017 11:35 EST
Closed
SQLState 57014, Error code -952: com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -952, SQLSTATE: 57014, SQLERRMC: null
SQLState 57014, Error code -952: com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -952, SQLSTATE: 57014, SQLERRMC: null
Query:
SQL: SELECT "PC0".PYWORKID AS "pyWorkID" , "PC0".PXURGENCY AS "pxUrgency" , "PC0".CASEPRODUCT AS "CaseProduct" , "PC0".CASETYPE AS "CaseType" , "PC0".CASESUBTYPE AS "CaseSubType" , "PC0".CASESUBSUBTYPE AS "CaseSubSubType" , "PC0".PYSTATUSWORK AS "pyStatusWork" , "PC0".WORKCREATEDATETIME AS "WorkCreateDateTime" , "PC0".ORIGCHANNEL AS "OrigChannel" , "PC0".PXREFOBJECTKEY AS "pxRefObjectKey" , "PC0".PXOBJCLASS AS "pxObjClass" , "PC0".CSCEXPIRYDATE AS "CSCExpiryDate" , "PC0".REOPENCOUNT AS "ReopenCount" , "PC0".CLIENTLASTNAME AS "ClientLastName" , "PC0".CLIENTNAME AS "ClientName" , "PC0".PYLABEL AS "pyLabel" , "PC0".PZINSKEY AS "pzInsKey" FROM RXRF.PCV4_ASSIGNMENTWB_SUMMARY_XCS0 "PC0" WHERE ( "PC0".PXASSIGNEDOPERATORID = ? AND "PC0".CASEPRODUCT = ? AND "PC0".CASETYPE = ? AND "PC0".CASESUBTYPE = ? ) AND "PC0".pxObjClass = ?
SQL Inserts: <XCS0CardsCreditBusinessWB> <116> <17> <1749> <Data-Assignment-WBSummary-XCS0>
This works fine in Non-Prod Environments and throwing error in Production
PFA Log File
Can Any one suggest on this?
***Edited by Moderator Marissa to update categories***
Posted: 7 years ago
PEGA
Pegasystems Inc.
US
This is a timeout. The problem may stem from the table/indexes needing to be reorged and stats run. The fact that it works in non-prod is probably a data quantity thing. Check indexes and get an explain plan using the query and the substitution values.
BTW no attachment?