(Incorrect syntax near the keyword 'SELECT'.)) Database Error: error number=156" When Creating a PPM Database via DBSetup.bat

(Doc ID 2311765.1)

Last updated on OCTOBER 09, 2017

Applies to:

Primavera P6 Professional Project Management - Version 16.2.10.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to create a PPM database via DBSetup.bat on SQL Server, the following error occurs:

ERROR

"RuntimeException: Error in Create the SQL Server tablespaces for P6 PPM: RuntimeException (Error in Run SQL Script sspm_init_db.sql: DatabaseToolException (Incorrect syntax near the keyword 'SELECT'.))
Database Error: error number=156"

In the dbsetup.log, the following error is visible:

java.lang.RuntimeException: Error in Create the SQL Server tablespaces for P6 PPM : RuntimeException (Error in Run SQL Script ssppm_init_db.sql : DatabaseTool Exception (Incorrect syntax near the keyword 'SELECT'.)) "

DEV [INFO] : Calling operator SetSqlServerAdminConnectStringTransOp
DEV [INFO] : Connection for class SYSUSER in page (config_ss_db) from page (config_ss_db) = sa/password1@sqlserver:localhost:1433:SELECT
DEV [INFO] : Calling initializer SetSSPrivPubuserSelectOption
DEV [INFO] : Calling initializer InitializeSSUsersPage
DEV [INFO] : TRANSITION: configure_ss_users -> pm_install_options
DEV [INFO] : Calling validator SSDatabasePrivPubUsersValid
DEV [INFO] : Privuser privuser already exists.
DEV [INFO] : Database test Connetion privuser/privuser@sqlserver:localhost:1433:master

DEV [INFO] : Create script job with connect string = sa/password1@sqlserver:localhost:1433:SELECT, script = ssppm_create_users.sql
[ERROR] [2017-09-27 12:08:41] Incorrect syntax near the keyword 'SELECT'.
[ERROR] [2017-09-27 12:08:41] Database Error: error number=156
[ERROR] [2017-09-27 12:08:41] Error Message: Incorrect syntax near the keyword 'SELECT'.
java.lang.RuntimeException: Error in Create the SQL Server tablespaces for P6 PPM : RuntimeException (Error in Run SQL Script ssppm_init_db.sql : DatabaseTool Exception (Incorrect syntax near the keyword 'SELECT'.))


STEPS

The issue can be reproduced at will with the following steps:

1. Run DBSetup.bat.

2. Enter SQL authentication credentials.  Example:  sa\<password>.

3. During database creation, set DatabaseName equal to SELECT.

4. Observe the reported error.

Cause

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 hundreds of Community platforms