Discussion
QBE
AU
Last activity: 6 Apr 2018 19:26 EDT
Data Only Update failing from 7.1.9 to 7.2.0
Data Only Update is failing from 7.1.9 to 7.2.0 with below exception. Database being used is MSSQL.
Note: We are also having CPMFS 7.14 in our system.
Steps Followed:
1) Migrated Rules from 7.1.9 Rules to new Schema 720 Rules - Success
2) Updated Rules in New Schema 720 Rules - Success
3) Run Rule Schema Object Generation (Migrate Script) - success
4) Update Data Only True - Failed with below exception.
[java] Feb 19, 2016 3:46:21 PM com.pega.pegarules.internal.bootstrap.PRBootstrap
[java] SEVERE: Problem during method invocation (main)
[java] com.pega.pegarules.pub.database.DatabaseException: Database-General Calling getDataUniqueID 8114 S0005 Error converting data type varchar to datetime.
[java] DatabaseException caused by prior exception: com.microsoft.sqlserver.jdbc.SQLServerException: Error converting data type varchar to datetime.
[java] | SQL Code: 8114 | SQL State: S0005
[java]
[java] From: (unknown)
[java] Caused by SQL Problems.
[java] Problem #1, SQLState S0005, Error code 8114: com.microsoft.sqlserver.jdbc.SQLServerException: Error converting data type varchar to datetime.
[java] at com.pega.pegarules.data.internal.access.DatabaseImpl.getDataUniqueID(DatabaseImpl.java:8105)
[java] at com.pega.pegarules.deploy.internal.util.InstalledHotFixMgmtImpl.saveMLDataRollbackInformation(InstalledHotFixMgmtImpl.java:383)
[java] at com.pega.pegarules.deploy.internal.archive.commands.NonRuleResolvedRollbackStateSaver.saveMLRollbackInfo(NonRuleResolvedRollbackStateSaver.java:128)
[java] at com.pega.pegarules.deploy.internal.archive.commands.NonRuleResolvedRollbackStateSaver.finish(NonRuleResolvedRollbackStateSaver.java:135)
[java] at com.pega.pegarules.deploy.internal.archive.importer.DataUpgrader.afterDeploy(DataUpgrader.java:53)
[java] at com.pega.pegarules.deploy.internal.archive.importer.AppBundleHandler.deploy(AppBundleHandler.java:97)
[java] at com.pega.pegarules.deploy.internal.archive.importer.DataUpgrader.runUpgrade(DataUpgrader.java:66)
[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(NativeMethodAccessorImpl.java:62)
[java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[java] at java.lang.reflect.Method.invoke(Method.java:497)
[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: Error converting data type varchar to datetime.
[java] at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
[java] at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)
[java] at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404)
[java] at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)
[java] at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
[java] at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
[java] at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
[java] at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
[java] at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:332)
[java] at com.pega.pegarules.data.internal.access.DatabasePreparedStatementImpl.execute(DatabasePreparedStatementImpl.java:582)
[java] at com.pega.pegarules.data.internal.access.mssql.SQLGeneratorMssql.getDataUniqueID(SQLGeneratorMssql.java:922)
[java] at com.pega.pegarules.data.internal.access.DatabaseImpl.getDataUniqueID(DatabaseImpl.java:8091)
[java] ... 16 more
[java]
[java] Feb 19, 2016 3:46:21 PM com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega
[java] SEVERE: Problem during method invocation (main)
[java] com.pega.pegarules.pub.database.DatabaseException: Database-General Calling getDataUniqueID 8114 S0005 Error converting data type varchar to datetime.
[java] DatabaseException caused by prior exception: com.microsoft.sqlserver.jdbc.SQLServerException: Error converting data type varchar to datetime.
[java] | SQL Code: 8114 | SQL State: S0005
[java]
[java] From: (unknown)
[java] Caused by SQL Problems.
[java] Problem #1, SQLState S0005, Error code 8114: com.microsoft.sqlserver.jdbc.SQLServerException: Error converting data type varchar to datetime.
[java] at com.pega.pegarules.data.internal.access.DatabaseImpl.getDataUniqueID(DatabaseImpl.java:8105)
[java] at com.pega.pegarules.deploy.internal.util.InstalledHotFixMgmtImpl.saveMLDataRollbackInformation(InstalledHotFixMgmtImpl.java:383)
[java] at com.pega.pegarules.deploy.internal.archive.commands.NonRuleResolvedRollbackStateSaver.saveMLRollbackInfo(NonRuleResolvedRollbackStateSaver.java:128)
[java] at com.pega.pegarules.deploy.internal.archive.commands.NonRuleResolvedRollbackStateSaver.finish(NonRuleResolvedRollbackStateSaver.java:135)
[java] at com.pega.pegarules.deploy.internal.archive.importer.DataUpgrader.afterDeploy(DataUpgrader.java:53)
[java] at com.pega.pegarules.deploy.internal.archive.importer.AppBundleHandler.deploy(AppBundleHandler.java:97)
[java] at com.pega.pegarules.deploy.internal.archive.importer.DataUpgrader.runUpgrade(DataUpgrader.java:66)
[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(NativeMethodAccessorImpl.java:62)
[java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[java] at java.lang.reflect.Method.invoke(Method.java:497)
[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: Error converting data type varchar to datetime.
[java] at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
[java] at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)
[java] at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404)
[java] 2016-02-19 15:46:21,441 [ main] [ ] [ ] (access.mssql.SQLGeneratorMssql) ERROR - Unable to execute {call pega719_data.sppc_data_uniqueid_withouttran (?, ?, ?, ? ,? )} S0005:8114
[java] com.microsoft.sqlserver.jdbc.SQLServerException: Error converting data type varchar to datetime.
[java] at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)
[java] at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
[java] at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
[java] at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
[java] at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
[java] at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
[java] at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:332)
[java] at com.pega.pegarules.data.internal.access.DatabasePreparedStatementImpl.execute(DatabasePreparedStatementImpl.java:582)
[java] at com.pega.pegarules.data.internal.access.mssql.SQLGeneratorMssql.getDataUniqueID(SQLGeneratorMssql.java:922)
[java] at com.pega.pegarules.data.internal.access.DatabaseImpl.getDataUniqueID(DatabaseImpl.java:8091)
[java] ... 16 more
[java]
[java] Exception in thread "main" java.lang.RuntimeException: Problem during method invocation (main)
[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:279)
[java] at com.pega.pegarules.pub.PegaRULES.main(PegaRULES.java:85)
[java] Caused by: com.pega.pegarules.pub.database.DatabaseException: Database-General Calling getDataUniqueID 8114 S0005 Error converting data type varchar to datetime.
[java] at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)
[java] DatabaseException caused by prior exception: com.microsoft.sqlserver.jdbc.SQLServerException: Error converting data type varchar to datetime.
[java] | SQL Code: 8114 | SQL State: S0005
[java]
[java] From: (unknown)
[java] Caused by SQL Problems.
[java] Problem #1, SQLState S0005, Error code 8114: com.microsoft.sqlserver.jdbc.SQLServerException: Error converting data type varchar to datetime.
[java] at com.pega.pegarules.data.internal.access.DatabaseImpl.getDataUniqueID(DatabaseImpl.java:8105)
[java] at com.pega.pegarules.deploy.internal.util.InstalledHotFixMgmtImpl.saveMLDataRollbackInformation(InstalledHotFixMgmtImpl.java:383)
[java] at com.pega.pegarules.deploy.internal.archive.commands.NonRuleResolvedRollbackStateSaver.saveMLRollbackInfo(NonRuleResolvedRollbackStateSaver.java:128)
[java] at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404)
[java] at com.pega.pegarules.deploy.internal.archive.commands.NonRuleResolvedRollbackStateSaver.finish(NonRuleResolvedRollbackStateSaver.java:135)
[java] at com.pega.pegarules.deploy.internal.archive.importer.DataUpgrader.afterDeploy(DataUpgrader.java:53)
[java] at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)
[java] at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
[java] at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
[java] at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
[java] at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
[java] at com.pega.pegarules.deploy.internal.archive.importer.AppBundleHandler.deploy(AppBundleHandler.java:97)
[java] at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:332)
[java] at com.pega.pegarules.deploy.internal.archive.importer.DataUpgrader.runUpgrade(DataUpgrader.java:66)
[java] at com.pega.pegarules.data.internal.access.DatabasePreparedStatementImpl.execute(DatabasePreparedStatementImpl.java:582)
[java] at com.pega.pegarules.deploy.external.util.UpgradeUtil.main(UpgradeUtil.java:73)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[java] at com.pega.pegarules.data.internal.access.mssql.SQLGeneratorMssql.getDataUniqueID(SQLGeneratorMssql.java:922)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
[java] at com.pega.pegarules.data.internal.access.DatabaseImpl.getDataUniqueID(DatabaseImpl.java:8091)
[java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[java] at java.lang.reflect.Method.invoke(Method.java:497)
[java] at com.pega.pegarules.deploy.internal.util.InstalledHotFixMgmtImpl.saveMLDataRollbackInformation(InstalledHotFixMgmtImpl.java:383)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:370)
[java] at com.pega.pegarules.deploy.internal.archive.commands.NonRuleResolvedRollbackStateSaver.saveMLRollbackInfo(NonRuleResolvedRollbackStateSaver.java:128)
[java] at com.pega.pegarules.deploy.internal.archive.commands.NonRuleResolvedRollbackStateSaver.finish(NonRuleResolvedRollbackStateSaver.java:135)
[java] at com.pega.pegarules.deploy.internal.archive.importer.DataUpgrader.afterDeploy(DataUpgrader.java:53)
[java] at com.pega.pegarules.deploy.internal.archive.importer.AppBundleHandler.deploy(AppBundleHandler.java:97)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:411)
[java] at com.pega.pegarules.deploy.internal.archive.importer.DataUpgrader.runUpgrade(DataUpgrader.java:66)
[java] at com.pega.pegarules.deploy.external.util.UpgradeUtil.main(UpgradeUtil.java:73)
[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:224)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:273)
[java] ... 1 more
[java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
[java] Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Error converting data type varchar to datetime.
[java] at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
[java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[java] at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)
[java] at java.lang.reflect.Method.invoke(Method.java:497)
[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.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404)
[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:273)
[java] at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)
[java] at com.pega.pegarules.pub.PegaRULES.main(PegaRULES.java:85)
[java] at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
[java] at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
[java] at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
[java] at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
[java] at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:332)
[java] at com.pega.pegarules.data.internal.access.DatabasePreparedStatementImpl.execute(DatabasePreparedStatementImpl.java:582)
[java] at com.pega.pegarules.data.internal.access.mssql.SQLGeneratorMssql.getDataUniqueID(SQLGeneratorMssql.java:922)
[java] at com.pega.pegarules.data.internal.access.DatabaseImpl.getDataUniqueID(DatabaseImpl.java:8091)
[java] ... 16 more
[java] 2016-02-19 15:46:21,441 [ main] [ ] [ ] (access.mssql.SQLGeneratorMssql)
BUILD FAILED
C:\pega\pega72update\scripts\setupDatabase.xml:2235: Java returned: 1
Total time: 7 minutes 11 seconds
Exiting with Error
**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.
QBE
AU
Hi Sumeet,
Issue was that we have run a script in Additional Scripts folder, which is only meant for the Mutli tenant system which was a mistake by one of us. With out running the script we are able to complete the update successfully.
Sudheer
Updated: 28 Mar 2016 23:29 EDT
Wipro
IN
We are working on 7.1.9 now and planning to update to 7.2. We are on split schema and we are planning for out-of-place update. I got confused when I am going through the Pega72_UpdateGuide and Pega72_UpgradeGuide. What are the sequence of steps for the update? My current understanding through command-line is (in the same order)
- Create new schema
- Execute Migrate.bat (seems like it is creating only few tables in new rules schema)
- Execute Update.bat/update.sh for new new rules schema
- Execute Update.bat/update.sh for data schema
Please correct me if any change in above sequence.
Accenture Technology Services
IN
Bhanu- I believe you still have to to do the data schema object generation between the upgrade steps as you are creating new rule schema.
Pegasystems Inc.
IN
All your steps are right. After upgrade.bat please run the generate Ruleschema objects step. If you are already using the Pega 7.1.9 split schema then you can simply use IUA wizard to perform an in place update.