Question

4
Replies
317
Views
Anandh Palanisamy Member since 2013 62 posts
Ford Motor Company
Posted: 4 years ago
Last activity: 4 years ago
Closed

Upgrade fails from 6.2 sp2 to 7.2

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.

Low-Code App Development Upgrades
Moderation Team has archived post
Share this page LinkedIn