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
