Discussion

6
Replies
420
Views
Close popover
Sudheer Somisetty (SSomisetty)
Coforge DPA Pvt Ltd
Sudheer Somisetty
Coforge DPA Pvt Ltd
AU
SSomisetty Member since 2010 6 posts
Coforge DPA Pvt Ltd
Posted: February 19, 2016
Last activity: April 6, 2018
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.

System Administration Upgrades
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Discussion, please write a new Discussion.