We are trying to upgrade Pega platform from 8.8.3 to 24.1.3.

During upgrade we are facing issue with sql executions related to views , earlier we faced issue with Stored procedure and we executed upgrade with elevated DB user and stored procedure got executed successfully.

Now issue with views with the same elevated user. Please find the stack trace below, we are in k8s environment.

[java] Exception in thread "main" java.lang.RuntimeException: Error during execution of upgrade on platform oracledate using schemas SYSTEM, SYSTEM, SYSTEM      [java]     at com.pega.pegarules.data.ddl.SchemaGenerator.main(SchemaGenerator.java:1500)      [java] Caused by: com.pega.pegarules.data.ddl.DatabaseException: java.sql.SQLException: ORA-31603: object "MVIEW_EVALUATIONS" of type VIEW not found in schema "SYSTEM"      [java] ORA-06512: at "SYS.DBMS_METADATA", line 6731      [java] ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105      [java] ORA-06512: at "SYS.DBMS_METADATA", line 6718      [java] ORA-06512: at "SYS.DBMS_METADATA", line 9734      [java] ORA-06512: at line 1      [java]       [java]     at com.pega.pegarules.data.ddl.SchemaManager.<init>(SchemaManager.java:430)      [java]     at com.pega.pegarules.data.ddl.SchemaManager.<init>(SchemaManager.java:471)      [java]     at com.pega.pegarules.data.ddl.SchemaGenerator.getSchemaManagerFromConnection(SchemaGenerator.java:249)      [java]     at com.pega.pegarules.data.ddl.SchemaGenerator.getSchemaManagerFromConnection(SchemaGenerator.java:225)      [java]     at com.pega.pegarules.data.ddl.SchemaGenerator.generateUpgradeDDL(SchemaGenerator.java:578)      [java]     at com.pega.pegarules.data.ddl.SchemaGenerator.main(SchemaGenerator.java:1371)      [java] Caused by: java.sql.SQLException: ORA-31603: object "MVIEW_EVALUATIONS" of type VIEW not found in schema "SYSTEM"      [java] ORA-06512: at "SYS.DBMS_METADATA", line 6731      [java] ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105      [java] ORA-06512: at "SYS.DBMS_METADATA", line 6718      [java] ORA-06512: at "SYS.DBMS_METADATA", line 9734      [java] ORA-06512: at line 1      [java]       [java]     at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:526)      [java]     at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:462)      [java]     at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104)      [java]     at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:553)      [java]     at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)      [java]     at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655)      [java]     at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:270)      [java]     at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:91)      [java]     at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:970)      [java]     at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1020)      [java]     at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1176)      [java]     at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3671)      [java]     at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1426)      [java]     at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3718)      [java]     at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1167)      [java]     at com.pega.pegarules.data.ddl.JDBCIntrospector.readObjectBodies(JDBCIntrospector.java:2031)      [java]     at com.pega.pegarules.data.ddl.JDBCIntrospector.readViews(JDBCIntrospector.java:498)      [java]     at com.pega.pegarules.data.ddl.JDBCIntrospector.createDatabaseJaxbObjectByIntrospection(JDBCIntrospector.java:119)      [java]     at com.pega.pegarules.data.ddl.SchemaManager.createDomDocumentFromDbIntrospection(SchemaManager.java:2041)      [java]     at com.pega.pegarules.data.ddl.SchemaManager.<init>(SchemaManager.java:426)      [java]     ... 5 more      [java] Caused by: Error : 31603, Position : 7, Sql = select dbms_metadata.get_ddl('VIEW',:1 ,:2 ) as def from dual, OriginalSql = select dbms_metadata.get_ddl('VIEW',?,?) as def from dual, Error Msg = ORA-31603: object "MVIEW_EVALUATIONS" of type VIEW not found in schema "SYSTEM"      [java] ORA-06512: at "SYS.DBMS_METADATA", line 6731      [java] ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105      [java] ORA-06512: at "SYS.DBMS_METADATA", line 6718      [java] ORA-06512: at "SYS.DBMS_METADATA", line 9734      [java] ORA-06512: at line 1      [java]       [java]     at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:530)      [java]     ... 24 more [java] Exception in thread "main" java.lang.RuntimeException: Error during execution of upgrade on platform oracledate using schemas SYSTEM, SYSTEM, SYSTEM      [java]     at com.pega.pegarules.data.ddl.SchemaGenerator.main(SchemaGenerator.java:1500)      [java] Caused by: com.pega.pegarules.data.ddl.DatabaseException: java.sql.SQLException: ORA-31603: object "MVIEW_EVALUATIONS" of type VIEW not found in schema "SYSTEM"      [java] ORA-06512: at "SYS.DBMS_METADATA", line 6731      [java] ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105      [java] ORA-06512: at "SYS.DBMS_METADATA", line 6718      [java] ORA-06512: at "SYS.DBMS_METADATA", line 9734      [java] ORA-06512: at line 1      [java]       [java]     at com.pega.pegarules.data.ddl.SchemaManager.<init>(SchemaManager.java:430)      [java]     at com.pega.pegarules.data.ddl.SchemaManager.<init>(SchemaManager.java:471)      [java]     at com.pega.pegarules.data.ddl.SchemaGenerator.getSchemaManagerFromConnection(SchemaGenerator.java:249)