My Oracle Support Banner

Error 'Must declare the scalar variable "@DayOfweek"' When Attempting to Initialize the Background Jobs in SQL Server (Doc ID 2585651.1)

Last updated on FEBRUARY 15, 2023

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 18.8 and later
Information in this document applies to any platform.

Symptoms

After restoring a P6 database to a new SQL Server instance, users receive the alert The database has not been configured to run background jobs at P6 Professional login.  Attempting to execute the command to initialize the jobs (exec initialize_background_procs) fails with the following error.

Msg 137, Level 15, State 2, Procedure INITIALIZE_BACKGROUND_PROCS, Line 42
Must declare the scalar variable "@DayOfweek".
Msg 137, Level 15, State 2, Procedure INITIALIZE_BACKGROUND_PROCS, Line 44
Must declare the scalar variable "@DayOfweek".

In addition, attempting to validate the database schema using the <current P6 version>\database\dbsetup.bat tool fails with the following error:

SQLServerException: SET LANGUAGE failed because 'english' is not an official language name or language alias on this SQL Server.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.