Question

1
Replies
356
Views
Close popover
Pradeep Chowdary Pydi (PradeepPydi)
Anthem
Senior PEGA DEVOPS and Cloud Administrator
Anthem
IN
PradeepPydi Member since 2017 215 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 Support Case Exists
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.