Return
-
Title
PeopleSoft Component raise error over migration after the STAT 5.7.4 upgrade. -
Description
PeopleSoft Components are not getting migrated after the STAT 5.7.4 upgrade. The error in the log as below:
ERROR [QuartzWorkerThread-3] -com.ibm.db2.jcc.am.SqlIntegrityConstraintViolationException:
DB2 SQL Error: SQLCODE=-407, SQLSTATE=23502, SQLERRMC=FLUIDMODE, DRIVER=3.64.106
...ERROR [QuartzWorkerThread-3] - offending select_sql: SELECT PNLGRPNAME, MARKET, VERSION, ACTIONS, DESCR, ADDSRCHRECNAME, SEARCHRECNAME, SEARCHPNLNAME, LOADLOC, SAVELOC, DISABLESAVE, OBJECTOWNERID, LASTUPDDTTM, LASTUPDOPRID, PRIMARYACTION, DFLTACTION, DFLTSRCHTYPE, DEFERPROC, EXPENTRYPROC, REQSECURESSL, INCLNAVIGATION, FORCESEARCH, ALLOWACTMODESEL, PNLNAVFLAGS, TBARBTNS, SHOWTBAR, ADDLINKMSGSET, ADDLINKMSGNUM, SRCHLINKMSGSET, SRCHLINKMSGNUM, SRCHTEXTMSGSET, SRCHTEXTMSGNUM, WSRPCOMPLIANT FROM ST_PSPNLGRPDEFN_8L WHERE SD_CD = 'HR' AND CSR_ID = 2951 AND SWAT_ID = 2 AND PS_DATABASE = 'HRISPR1' AND PNLGRPNAME = 'RUN_TAX810IL-NC' AND MARKET = 'USA'ERROR [QuartzWorkerThread-3] - offending insert_sql: INSERT INTO PSPNLGRPDEFN (PNLGRPNAME, MARKET, VERSION, ACTIONS, DESCR, ADDSRCHRECNAME, SEARCHRECNAME, SEARCHPNLNAME, LOADLOC, SAVELOC, DISABLESAVE, OBJECTOWNERID, LASTUPDDTTM, LASTUPDOPRID, PRIMARYACTION, DFLTACTION, DFLTSRCHTYPE, DEFERPROC, EXPENTRYPROC, REQSECURESSL, INCLNAVIGATION, FORCESEARCH, ALLOWACTMODESEL, PNLNAVFLAGS, TBARBTNS, SHOWTBAR, ADDLINKMSGSET, ADDLINKMSGNUM, SRCHLINKMSGSET, SRCHLINKMSGNUM, SRCHTEXTMSGSET, SRCHTEXTMSGNUM, WSRPCOMPLIANT) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)ERROR [STDERR] (QuartzWorkerThread-3) com.ibm.db2.jcc.am.SqlIntegrityConstraintViolationException:DB2 SQL Error: SQLCODE=-407, SQLSTATE=23502, SQLERRMC=FLUIDMODE, DRIVER=3.64.106
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.