Support Article

Upgrade to Pega 7.2.2 fails in Remove Invalid Settings task

SA-36630

Summary



Upgrading from PRPC 6.3 SP1 to Pega 7.2.2 split schema.

Migrated the rules to new schema and attempting to upgrade the rules schema is failing.


Error Messages



[pega:removequeueinstance] com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-551, SQLSTATE=42501, SQLERRMC=FPEDPEG1;DELETE;PER7.PR_DATA, DRIVER=4.19.26
[pega:removequeueinstance] at com.ibm.db2.jcc.am.kd.a(Unknown Source)
[pega:removequeueinstance] at com.ibm.db2.jcc.am.kd.a(Unknown Source)
[pega:removequeueinstance] at com.ibm.db2.jcc.am.kd.a(Unknown Source)
[pega:removequeueinstance] at com.ibm.db2.jcc.am.fp.c(Unknown Source)
[pega:removequeueinstance] at com.ibm.db2.jcc.am.fp.d(Unknown Source)
[pega:removequeueinstance] at com.ibm.db2.jcc.am.fp.b(Unknown Source)
[pega:removequeueinstance] at com.ibm.db2.jcc.t4.bb.i(Unknown Source)
[pega:removequeueinstance] at com.ibm.db2.jcc.t4.bb.c(Unknown Source)
[pega:removequeueinstance] at com.ibm.db2.jcc.t4.p.b(Unknown Source)
[pega:removequeueinstance] at com.ibm.db2.jcc.t4.vb.h(Unknown Source)
[pega:removequeueinstance] at com.ibm.db2.jcc.am.fp.jb(Unknown Source)
[pega:removequeueinstance] at com.ibm.db2.jcc.am.fp.a(Unknown Source)
[pega:removequeueinstance] at com.ibm.db2.jcc.am.fp.e(Unknown Source)
[pega:removequeueinstance] at com.ibm.db2.jcc.am.fp.execute(Unknown Source)
[pega:removequeueinstance] at com.pega.pegarules.util.anttasks.RemoveQueueInstance.execute(RemoveQueueInstance.java:111)
[pega:removequeueinstance] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:292)
[pega:removequeueinstance] at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
[pega:removequeueinstance] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:56)
[pega:removequeueinstance] at java.lang.reflect.Method.invoke(Method.java:620)
[pega:removequeueinstance] at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtil


Steps to Reproduce



Attempt to upgrade to split schema.


Root Cause



A defect or configuration issue in the operating environment.

Operator running the upgrade does not have privileges to delete from the table.

Resolution



Make the following change to the operating environment:

Grant privileges to delete from specified table and resume the upgrade.

Published April 17, 2017 - Updated May 4, 2017

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.