Question

1
Replies
346
Views
PradeepPydi Member since 2017 204 posts
Anthem
Posted: 2 years ago
Last activity: 2 years ago
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 Low-Code App Development Upgrades SR Exists
Moderation Team has archived post
Share this page LinkedIn