Question

1
Replies
351
Views
Close popover
Pradeep Chowdary Pydi (PradeepPydi)
Anthem
Senior PEGA DEVOPS and Cloud Administrator
Anthem
IN
PradeepPydi Member since 2017 206 posts
Anthem
Posted: September 4, 2018
Last activity: October 10, 2018
Closed

Invalid object name reference errors during the DB separation.

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***

Low-Code App Development System Administration Data Integration Upgrades SR Exists
Moderation Team has archived post