Hi,

We are upgrading pega 23.1 to 24.2.2, seeing this error during the upgrade though upgrade status shows completed. Please let us know how to resolve it. 

INFO AntScriptWrapper -      [java] 2025-07-23 17:39:49,235 [gaRULES-ShutDownTask] [  STANDARD] [                    ] [                    ] (      etier.impl.EngineStartup) INFO    - Task : class com.pega.pegarules.session.internal.engineinterface.shutdown.shutdowntasks.RuleUsageSnapshotTask completed executing. INFO AntScriptWrapper -      [java] 2025-07-23 17:39:49,440 [gaRULES-ShutDownTask] [  STANDARD] [                    ] [                    ] (      etier.impl.EngineStartup) INFO    - Task : class com.pega.pegarules.session.internal.engineinterface.shutdown.shutdowntasks.JobSchedulerShutdownTask completed executing. INFO AntScriptWrapper -      [java] 2025-07-23 17:39:49,859 [gaRULES-ShutDownTask] [  STANDARD] [                    ] [                    ] (                AgentExecution) ERROR   - Queue Manager encountered problem checking for orphaned queue items in System-Queue-ServiceLevel-Monitoring class INFO AntScriptWrapper -      [java] com.pega.pegarules.pub.database.DatabaseException: Database-General There was a problem getting a list      90442000    ORA-00904: "PYITEMSTATUS": invalid identifier INFO AntScriptWrapper -      [java] INFO AntScriptWrapper -      [java] DatabaseException caused by prior exception: java.sql.SQLSyntaxErrorException: ORA-00904: "PYITEMSTATUS": invalid identifier INFO AntScriptWrapper -      [java] INFO AntScriptWrapper -      [java]  | SQL Code: 904 | SQL State: 42000 INFO AntScriptWrapper -      [java] INFO AntScriptWrapper -      [java]     at com.pega.pegarules.data.internal.access.ExceptionInformation.createAppropriateExceptionDueToDBFailure(ExceptionInformation.java:400) ~[prprivate-data.jar:8.24.52-349] INFO AntScriptWrapper -      [java]     at com.pega.pegarules.data.internal.access.ExceptionInformation.createExceptionDueToDBFailure(ExceptionInformation.java:379) ~[prprivate-data.jar:8.24.52-349] INFO AntScriptWrapper -      [java]     at com.pega.pegarules.data.internal.access.Lister.convertSqlExceptionToDatabaseException(Lister.java:616) ~[prprivate-data.jar:8.24.52-349] INFO AntScriptWrapper -      [java]     at com.pega.pegarules.data.internal.access.Lister.listWithResultPackager(Lister.java:418) ~[prprivate-data.jar:8.24.52-349] INFO AntScriptWrapper -      [java]     at com.pega.pegarules.data.internal.access.Lister.list(Lister.java:193) ~[prprivate-data.jar:8.24.52-349] INFO AntScriptWrapper -      [java]     at com.pega.pegarules.data.internal.access.DBQueryExecutor.executeRDB(DBQueryExecutor.java:126) ~[prprivate-data.jar:8.24.52-349] INFO AntScriptWrapper -      [java]     at com.pega.pegarules.data.internal.access.DBQueryExecutor.executeRDB(DBQueryExecutor.java:73) ~[prprivate-data.jar:8.24.52-349] INFO AntScriptWrapper -      [java]     at com.pega.pegarules.data.internal.access.DatabaseImpl.executeRDB(DatabaseImpl.java:3236) ~[prprivate-data.jar:8.24.52-349] INFO AntScriptWrapper -      [java]     at com.pega.pegarules.data.internal.access.DatabaseImpl.executeRDB(DatabaseImpl.java:3216) ~[prprivate-data.jar:8.24.52-349] INFO AntScriptWrapper -      [java]     at com.pega.pegarules.session.internal.async.agent.OrphanedItemsCleaner.cleanOrphanedItems(OrphanedItemsCleaner.java:50) ~[prprivate-session.jar:8.24.52-349] INFO AntScriptWrapper -      [java]     at com.pega.pegarules.session.internal.async.agent.OrphanedItemsCleaner.lambda$cleanOrphanedItems$0(OrphanedItemsCleaner.java:41) ~[prprivate-session.jar:8.24.52-349] INFO AntScriptWrapper -      [java]     at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183) ~[?:?] INFO AntScriptWrapper -      [java]     at java.base/java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:179) ~[?:?] INFO AntScriptWrapper -      [java]     at java.base/java.util.HashMap$KeySpliterator.forEachRemaining(HashMap.java:1707) ~[?:?] INFO AntScriptWrapper -      [java]     at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:509) ~[?:?] INFO AntScriptWrapper -      [java]     at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:499) ~[?:?] INFO AntScriptWrapper -      [java]     at java.base/java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150) ~[?:?] INFO AntScriptWrapper -      [java]     at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173) ~[?:?] INFO AntScriptWrapper -      [java]     at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234) ~[?:?] INFO AntScriptWrapper -      [java]     at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:596) ~[?:?] INFO AntScriptWrapper -      [java]     at com.pega.pegarules.session.internal.async.agent.OrphanedItemsCleaner.lambda$cleanOrphanedItems$1(OrphanedItemsCleaner.java:40) ~[prprivate-session.jar:8.24.52-349] INFO AntScriptWrapper -      [java]     at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183) ~[?:?] INFO AntScriptWrapper -      [java]     at java.base/java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:179) ~[?:?] INFO AntScriptWrapper -      [java]     at java.base/java.util.Collections$2.tryAdvance(Collections.java:4853) ~[?:?] INFO AntScriptWrapper -      [java]     at java.base/java.util.Collections$2.forEachRemaining(Collections.java:4861) ~[?:?] INFO AntScriptWrapper -      [java]     at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:509) ~[?:?] INFO AntScriptWrapper -      [java]     at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:499) ~[?:?] INFO AntScriptWrapper -      [java]     at java.base/java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150) ~[?:?] INFO AntScriptWrapper -      [java]     at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173) ~[?:?] INFO AntScriptWrapper -      [java]     at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234) ~[?:?] INFO AntScriptWrapper -      [java]     at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:596) ~[?:?] INFO AntScriptWrapper -      [java]     at com.pega.pegarules.session.internal.async.agent.OrphanedItemsCleaner.cleanOrphanedItems(OrphanedItemsCleaner.java:37) ~[prprivate-session.jar:8.24.52-349] INFO AntScriptWrapper -      [java]     at com.pega.pegarules.session.internal.async.Agent.cleanOrphanedItems(Agent.java:2072) ~[prprivate-session.jar:8.24.52-349] INFO AntScriptWrapper -      [java]     at com.pega.pegarules.session.internal.async.Agent.lambda$cleanOrphanedItems$1(Agent.java:2061) ~[prprivate-session.jar:8.24.52-349] INFO AntScriptWrapper -      [java]     at com.pega.pegarules.session.internal.PRSessionProviderImpl.performTargetActionWithLock(PRSessionProviderImpl.java:1379) ~[prprivate-session.jar:8.24.52-349] INFO AntScriptWrapper -      [java]     at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:1122) ~[prprivate-session.jar:8.24.52-349] INFO AntScriptWrapper -      [java]     at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:1003) ~[prprivate-session.jar:8.24.52-349] INFO AntScriptWrapper -      [java]     at com.pega.pegarules.session.internal.PRSessionProviderImplForModules.doWithRequestorLocked(PRSessionProviderImplForModules.java:83) ~[prprivate-session.jar:8.24.52-349] INFO AntScriptWrapper -      [java]     at com.pega.pegarules.session.internal.async.Agent.cleanOrphanedItems(Agent.java:2052) ~[prprivate-session.jar:8.24.52-349] INFO AntScriptWrapper -      [java]     at com.pega.pegarules.session.internal.async.Agent.stop(Agent.java:2003) ~[prprivate-session.jar:8.24.52-349] INFO AntScriptWrapper -      [java]     at com.pega.pegarules.session.internal.engineinterface.shutdown.shutdowntasks.AgentsShutdownTask.exec(AgentsShutdownTask.java:44) ~[prprivate-session.jar:8.24.52-349] INFO AntScriptWrapper -      [java]     at com.pega.pegarules.session.internal.engineinterface.shutdown.shutdowntasks.IParallelShutdownTask.run(IParallelShutdownTask.java:43) ~[prprivate-session.jar:8.24.52-349] INFO AntScriptWrapper -      [java]     at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539) ~[?:?] INFO AntScriptWrapper -      [java]     at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) ~[?:?] INFO AntScriptWrapper -      [java]     at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) ~[?:?] INFO AntScriptWrapper -      [java]     at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) ~[?:?] INFO AntScriptWrapper -      [java]     at java.base/java.lang.Thread.run(Thread.java:842) [?:?] INFO AntScriptWrapper -      [java] Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: "PYITEMSTATUS": invalid identifier INFO AntScriptWrapper -      [java] INFO AntScriptWrapper -      [java]     at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:628) ~[ojdbc8.jar: Proprietary information hidden.0] INFO AntScriptWrapper -      [java]     at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:562) ~[ojdbc8.jar: Proprietary information hidden.0] INFO AntScriptWrapper -      [java]     at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1145) ~[ojdbc8.jar: Proprietary information hidden.0] INFO AntScriptWrapper -      [java]     at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:726) ~[ojdbc8.jar: Proprietary information hidden.0] INFO AntScriptWrapper -      [java]     at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:291) ~[ojdbc8.jar: Proprietary information hidden.0] INFO AntScriptWrapper -      [java]     at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:492) ~[ojdbc8.jar: Proprietary information hidden.0] INFO AntScriptWrapper -      [java]     at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:148) ~[ojdbc8.jar: Proprietary information hidden.0] INFO AntScriptWrapper -      [java]     at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1038) ~[ojdbc8.jar: Proprietary information hidden.0] INFO AntScriptWrapper -      [java]     at oracle.jdbc.driver.OracleStatement.executeSQLStatement(OracleStatement.java:1507) ~[ojdbc8.jar: Proprietary information hidden.0] INFO AntScriptWrapper -      [java]     at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1287) ~[ojdbc8.jar: Proprietary information hidden.0] INFO AntScriptWrapper -      [java]     at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3735) ~[ojdbc8.jar: Proprietary information hidden.0] INFO AntScriptWrapper -      [java]     at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3933) ~[ojdbc8.jar: Proprietary information hidden.0] INFO AntScriptWrapper -      [java]     at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1010) ~[ojdbc8.jar: Proprietary information hidden.0] INFO AntScriptWrapper -      [java]     at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44) ~[HikariCP-java7-2.4.13.jar:?] INFO AntScriptWrapper -      [java]     at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java) ~[HikariCP-java7-2.4.13.jar:?] INFO AntScriptWrapper -      [java]     at com.pega.pegarules.data.internal.store.DatabasePreparedStatementImpl.execute(DatabasePreparedStatementImpl.java:532) ~[prprivate-data.jar:8.24.52-349] INFO AntScriptWrapper -      [java]     at com.pega.pegarules.data.internal.access.Lister.listWithResultPackager(Lister.java:398) ~[prprivate-data.jar:8.24.52-349] INFO AntScriptWrapper -      [java]     ... 43 more INFO AntScriptWrapper -      [java] Caused by: oracle.jdbc.OracleDatabaseException: ORA-00904: "PYITEMSTATUS": invalid identifier INFO AntScriptWrapper -      [java] INFO AntScriptWrapper -      [java]     at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:632) ~[ojdbc8.jar: Proprietary information hidden.0] INFO AntScriptWrapper -      [java]     at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:562) ~[ojdbc8.jar: Proprietary information hidden.0] INFO AntScriptWrapper -      [java]     at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1145) ~[ojdbc8.jar: Proprietary information hidden.0] INFO AntScriptWrapper -      [java]     at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:726) ~[ojdbc8.jar: Proprietary information hidden.0] INFO AntScriptWrapper -      [java]     at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:291) ~[ojdbc8.jar: Proprietary information hidden.0] INFO AntScriptWrapper -      [java]     at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:492) ~[ojdbc8.jar: Proprietary information hidden.0] INFO AntScriptWrapper -      [java]     at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:148) ~[ojdbc8.jar: Proprietary information hidden.0] INFO AntScriptWrapper -      [java]     at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1038) ~[ojdbc8.jar: Proprietary information hidden.0] INFO AntScriptWrapper -      [java]     at oracle.jdbc.driver.OracleStatement.executeSQLStatement(OracleStatement.java:1507) ~[ojdbc8.jar: Proprietary information hidden.0] INFO AntScriptWrapper -      [java]     at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1287) ~[ojdbc8.jar: Proprietary information hidden.0] INFO AntScriptWrapper -      [java]     at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3735) ~[ojdbc8.jar: Proprietary information hidden.0] INFO AntScriptWrapper -      [java]     at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3933) ~[ojdbc8.jar: Proprietary information hidden.0] INFO AntScriptWrapper -      [java]     at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1010) ~[ojdbc8.jar: Proprietary information hidden.0] INFO AntScriptWrapper -      [java]     at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44) ~[HikariCP-java7-2.4.13.jar:?] INFO AntScriptWrapper -      [java]     at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java) ~[HikariCP-java7-2.4.13.jar:?] INFO AntScriptWrapper -      [java]     at com.pega.pegarules.data.internal.store.DatabasePreparedStatementImpl.execute(DatabasePreparedStatementImpl.java:532) ~[prprivate-data.jar:8.24.52-349] INFO AntScriptWrapper -      [java]     at com.pega.pegarules.data.internal.access.Lister.listWithResultPackager(Lister.java:398) ~[prprivate-data.jar:8.24.52-349] INFO AntScriptWrapper -      [java]     ... 43 more INFO AntScriptWrapper -      [java] 2025-07-23 17:39:50,081 [gaRULES-ShutDownTask] [  STANDARD] [                    ] [                    ] (      etier.impl.EngineStartup) INFO    - Task : class com.pega.pegarules.session.internal.engineinterface.shutdown.shutdowntasks.AgentsShutdownTask completed executing. INFO AntScriptWrapper -      [java] 2025-07-23 17:39:50,085 [rp.bankofamerica.com] [  STANDARD] [                    ] [                    ] (                   SystemPulse) INFO    - System Pulse module shutdown  

Thank you

Veni