Question

1
Replies
1131
Views
NareshKommuri Member since 2014 3 posts
Evoke Technologies
Posted: November 27, 2017
Last activity: November 28, 2017
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***
Data Integration
Moderation Team has archived post
Share this page LinkedIn