Discussion

3
Replies
202
Views
PrakashKaragi Member since 2011 5 posts
PEGA
Posted: November 19, 2015
Last activity: April 6, 2018
Closed

Data upgrade has failed upgrade from 5.5 to 7.1

I see below error snippet from the log file provided

INFO: CREATE TABLE PSTRDBA.PC_ASSIGN_WORKLIST

[java] Oct 28, 2015 5:32:42 AM com.pega.pegarules.install.SQLLoader writeMessage
[java] WARNING: Failed to execute SQL in file udb00210.sql
[java] Oct 28, 2015 5:32:42 AM com.pega.pegarules.install.SQLLoader writeMessage
[java] WARNING: Statement: create table PSTRDBA.pc_assign_worklist
[java] (
[java] pxApplication VARCHAR(32),
[java] pxAssignedOperatorID VARCHAR(128),
[java] pxAssignedOrg VARCHAR(32),
[java] pxAssignedOrgDiv VARCHAR(32),
[java] pxAssignedOrgUnit VARCHAR(32),
[java] pxAssignedUserName VARCHAR(128),
[java] pxCreateDateTime TIMESTAMP,
[java] pxCreateOpName VARCHAR(128),
[java] pxCreateOperator VARCHAR(128),
[java] pxCreateSystemID VARCHAR(32),
[java] pxDeadlineExecute TIMESTAMP,
[java] pxDeadlineTime TIMESTAMP,
[java] pxFlowInsKey VARCHAR(255),
[java] pxFlowName VARCHAR(64),
[java] pxGoalExecute TIMESTAMP,
[java] pxGoalTime TIMESTAMP,
[java] pxInsName VARCHAR(128),
[java] pxLateTime TIMESTAMP,
[java] pxObjClass VARCHAR(96),
[java] pxRefObjectClass VARCHAR(64),
[java] pxRefObjectInsName VARCHAR(64),
[java] pxRefObjectKey VARCHAR(255),
[java] pxRefQueueKey VARCHAR(255),
[java] pxServiceLevelName VARCHAR(64),
[java] pxSystemFlow VARCHAR(5),
[java] pxTaskLabel VARCHAR(128),
[java] pxTaskName VARCHAR(32),
[java] pxTimeFlowStarted TIMESTAMP,
[java] pxUpdateDateTime TIMESTAMP,
[java] pxUpdateOpName VARCHAR(128),
[java] pxUpdateOperator VARCHAR(128),
[java] pxUpdateSystemID VARCHAR(32),
[java] pxUrgency DECIMAL(18),
[java] pxUrgencyAssign DECIMAL(18),
[java] pxWorkGroup VARCHAR(64),
[java] pyActionTime TIMESTAMP,
[java] pyAssignmentStatus VARCHAR(32),
[java] pyEffortActual DECIMAL(18),
[java] pyErrorAssignment VARCHAR(8),
[java] pyErrorMessage VARCHAR(128),
[java] pyErrorStep VARCHAR(32),
[java] pyFlowInError VARCHAR(64),
[java] pyFlowType VARCHAR(64),
[java] pyInstructions VARCHAR(255),
[java] pyInterestPageClass VARCHAR(96),
[java] pyLabel VARCHAR(64),
[java] pyProcessOnNode VARCHAR(64),
[java] pyResolutionCost DECIMAL(18),
[java] pxStageLabel VARCHAR(128),
[java] pxStageID VARCHAR(32),
[java] pzInsKey VARCHAR(255) NOT NULL,
[java] pzPVStream BLOB(5M)
[java] )
[java] com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-601, SQLSTATE=42710, SQLERRMC=PSTRDBA.PC_ASSIGN_WORKLIST;TABLE, DRIVER=3.64.133
[java] at com.ibm.db2.jcc.am.bd.a(bd.java:679)
[java] at com.ibm.db2.jcc.am.bd.a(bd.java:60)
[java] at com.ibm.db2.jcc.am.bd.a(bd.java:127)
[java] at com.ibm.db2.jcc.am.io.c(io.java:2706)
[java] at com.ibm.db2.jcc.am.io.d(io.java:2694)
[java] at com.ibm.db2.jcc.am.io.b(io.java:2077)
[java] at com.ibm.db2.jcc.t4.ab.i(ab.java:226)
[java] at com.ibm.db2.jcc.t4.ab.c(ab.java:48)
[java] at com.ibm.db2.jcc.t4.p.b(p.java:38)
[java] at com.ibm.db2.jcc.t4.qb.h(qb.java:114)
[java] at com.ibm.db2.jcc.am.io.fb(io.java:2072)
[java] at com.ibm.db2.jcc.am.io.a(io.java:3227)
[java] at com.ibm.db2.jcc.am.io.e(io.java:1066)
[java] at com.ibm.db2.jcc.am.io.execute(io.java:1049)
[java] at com.pega.pegarules.install.SQLLoader.main(SQLLoader.java:298)
[java] Oct 28, 2015 5:32:42 AM com.pega.pegarules.install.SQLLoader writeMessage
[java] INFO:
[java] ********************************************************************************
[java]
[java] Encountered a SQL Exception, clean schema before running again.
[java]
[java] ********************************************************************************

BUILD FAILED
/smartpaas-backup/vol1/TK-312743/114665_Pega716/scripts/setupDatabase.xml:1667: Java returned: 1

Total time: 36 seconds

Error Code: DB2 SQL Error: SQLCODE=-601, SQLSTATE=42710, SQLERRMC=PSTRDBA.PC_ASSIGN_WORKLIST;TABLE

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Low-Code App Development Upgrades
Moderation Team has archived post
Share this page LinkedIn