Hi Team,

We are running into Invalid object name reference errors during the Database separation from rules to work database.

Error Message
ERROR - Not returning connection 47 for database "pega_work" to the pool as it previously encountered the following error
User ID: (unknown)
Last SQL: {call PEGA_DATA.sppr_purge_table (?,?,?)}
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'PEGA_DATA.pr_log_reportstats'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1655)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:440)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:385)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7505)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2445)

Database Separation pertains to separation/moving over WORK related tables to another database for DB high availability and easy maintenance purposes.

***Edited by Moderator Marissa to update SR Details***