Retour
-
Titre
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
Connexion requise
Vous devez être connecté et disposer d'un contrat de maintenance en cours pour afficher les articles de la base de connaissances avancés.