Discussion

6
Replies
416
Views
Sudheer_Incessant Member since 2010 6 posts
Incessant Technologies Pvt Ltd
Posted: 4 years ago
Last activity: 4 years 6 months ago
Closed

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.

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