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 May 4, 2017 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.