Support Article
We are getting SQLServerException: Must declare the scalar error
SA-28646
Summary
While install PEGA7.2.1 with data base "Micro Soft SQL server 2012", the user noticed the following error.
SQLServerException: Must declare the scalar variable "@firstdayOfWeek".
see the error screen shot and logs.
Error Messages
java] Exception in thread "main" com.pega.pegarules.install.SQLLoaderException: Error executing SQL statements
[java] at com.pega.pegarules.install.SQLLoader.load(SQLLoader.java:80)
[java] at com.pega.pegarules.install.SQLLoader.main(SQLLoader.java:65)
[java] Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Must declare the scalar variable "@firstdayOfWeek".
[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.SQLLoaderInternal.readAndExecuteSQLStatements(SQLLoaderInternal.java:151)
[java] at com.pega.pegarules.install.SQLLoaderInternal.load(SQLLoaderInternal.java:110)
[java] at com.pega.pegarules.install.SQLLoader.loadInner(SQLLoader.java:98)
[java] at com.pega.pegarules.install.SQLLoader.load(SQLLoader.java:77)
[java] ... 1 more
Steps to Reproduce
- Configure MS SQL Server 2012
- Install PRPC 7.2.1
Root Cause
Customer has configured a collation in MS-SQL which causes stored procedure content to be case sensitive.
Resolution
Advised customer to update MS-SQL to use different collation.
Published October 7, 2016 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.