Hi,

We are upgrading our application from Pega 6.2sp2 into Pega 7.2, after we successfuly splited the schema tabls(Rules and Data). While running the upgrade.bat getting the below error,

[java] 2016-08-09 13:47:01,825 [ main] [ ] [ ] (l.access.MigrateSQLChangeProxy) INFO - Migrated 0 instances of Data-Admin-Product
[java] Aug 09, 2016 1:47:02 PM com.pega.pegarules.internal.bootstrap.PRBootstrap
[java] SEVERE: Problem during method invocation (main)
[java] com.pega.pegarules.pub.database.DatabaseException: Database-General Invalid object name 'Rules.XXXX'. 208 S0002 Invalid object name 'Rules.XXX'.
[java] DatabaseException caused by prior exception: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'Rules.XXX'.
[java] | SQL Code: 208 | SQL State: S0002
[java]
[java] From: (unknown)
[java] Caused by SQL Problems.
[java] Problem #1, SQLState S0002, Error code 208: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'Rules.XXX'.
[java] at com.pega.pegarules.deploy.internal.archive.importer.ImporterDataModelImpl.getCountOfClassInTable(ImporterDataModelImpl.java:432)
[java] at com.pega.pegarules.deploy.internal.archive.importer.TableMigratorImpl.determineAndMigrateChanges(TableMigratorImpl.java:57)
[java] at com.pega.pegarules.deploy.internal.archive.importer.UpgradeBaseArchiveImporter.beforeLoad(UpgradeBaseArchiveImporter.java:72)
[java] at com.pega.pegarules.deploy.internal.archive.importer.ArchiveImporterAbstract.importArchive(ArchiveImporterAbstract.java:38)
[java] at com.pega.pegarules.deploy.internal.archive.importer.Upgrader.handleArchive(Upgrader.java:150)
[java] at com.pega.pegarules.deploy.internal.archive.importer.AppBundleHandler.deploy(AppBundleHandler.java:90)
[java] at com.pega.pegarules.deploy.internal.archive.importer.Upgrader.runUpgrade(Upgrader.java:57)
[java] at com.pega.pegarules.deploy.external.util.UpgradeUtil.main(UpgradeUtil.java:73)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
[java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
[java] at java.lang.reflect.Method.invoke(Unknown Source)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:370)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:411)
[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:224)
[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:273)
[java] at com.pega.pegarules.pub.PegaRULES.main(PegaRULES.java:85)
[java] Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'Rules.XXXX.
[java] at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
[java] at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)
[java] at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:390)
[java] at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340)
[java] at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
[java] at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
[java] at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
[java] at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
[java] at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:283)
[java] at com.pega.pegarules.data.internal.access.DatabasePreparedStatementImpl.executeQuery(DatabasePreparedStatementImpl.java:411)
[java] at com.pega.pegarules.deploy.internal.archive.importer.ImporterDataModelImpl.getCountOfClassInTable(ImporterDataModelImpl.java:428)
[java] ... 16 more
[java]
[java] Aug 09, 2016 1:47:02 PM com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega
[java] SEVERE: Problem during method invocation (main)
[java] com.pega.pegarules.pub.database.DatabaseException: Database-General Invalid object name 'Rules.XXX'. 208 S0002 Invalid object name 'Rules.XXK'.
[java] DatabaseException caused by prior exception: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'Rules.XXX'.
[java] | SQL Code: 208 | SQL State: S0002
[java]
[java] From: (unknown)
[java] Caused by SQL Problems.
[java] Problem #1, SQLState S0002, Error code 208: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'Rules.XXXX'.
[java] at com.pega.pegarules.deploy.internal.archive.importer.ImporterDataModelImpl.getCountOfClassInTable(ImporterDataModelImpl.java:432)
[java] at com.pega.pegarules.deploy.internal.archive.importer.TableMigratorImpl.determineAndMigrateChanges(TableMigratorImpl.java:57)
[java] at com.pega.pegarules.deploy.internal.archive.importer.UpgradeBaseArchiveImporter.beforeLoad(UpgradeBaseArchiveImporter.java:72)
[java] at com.pega.pegarules.deploy.internal.archive.importer.ArchiveImporterAbstract.importArchive(ArchiveImporterAbstract.java:38)
[java] 2016-08-09 13:47:01,872 [ main] [ ] [ ] (l.access.ConnectionManagerImpl) ERROR - Not returning connection 1 for database "pegarules" to the pool as it previously encountered the following error
[java] at com.pega.pegarules.deploy.internal.archive.importer.Upgrader.handleArchive(Upgrader.java:150)
[java] User ID: (unknown)
[java] Last SQL: select count(*) as "count" from Rules.XXX where pxObjClass = 'XXXX'
[java] at com.pega.pegarules.deploy.internal.archive.importer.AppBundleHandler.deploy(AppBundleHandler.java:90)
[java] com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'Rules.XXXX'.

Did anyone faced this issue and how its been resolved?

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.