Discussion

2
Replies
172
Views
brahm Member since 2015 1 post
PEGA
Posted: July 14, 2015
Last activity: April 6, 2018
Closed

Getting the error in rule upgrade from 6.1Sp2 to 7.1.8:SQLServerException: Cannot assign a default value to a local variable.

I am facing problem in upgrading a customer application from PRPC6.1SP2 to Pega7.1ML8, While performing rules upgrade, encountered "SQLServerException: Cannot assign a default value to a local variable".

Below is the stack trace:

[java] INFO: CREATE PROCEDURE RULESSCHEMA.SPPR_DEFRAGMENT_TABLE

[java] Jul 13, 2015 3:55:37 AM com.pega.pegarules.install.SQLLoader writeException
[java] WARNING: Failed to execute SQL in file mssql00590.sql
[java] com.microsoft.sqlserver.jdbc.SQLServerException: Cannot assign a default value to a local variable.
[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.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:792)
[java] at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:689)
[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.SQLServerStatement.execute(SQLServerStatement.java:662)
[java] at com.pega.pegarules.install.SQLLoader.main(SQLLoader.java:266)

**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