Question

4
Replies
318
Views
Close popover
Anandh Palanisamy (Anandh Palanisamy)
Ford Motor Company

Ford Motor Company
US
Anandh Palanisamy Member since 2013 62 posts
Ford Motor Company
Posted: August 9, 2016
Last activity: April 6, 2018
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.

System Administration Upgrades
Moderation Team has archived post