Error: "Incorrect Syntax Near the Keyword 'ON'" When Attempting to Create a Database Using Dbsetup.bat

(Doc ID 2328870.1)

Last updated on DECEMBER 15, 2017

Applies to:

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

Symptoms

When attempting to create a P6 database using dbsetup.bat with SQL Server the following error is observed:

Runtime Exception: Error in Create the SQL Server tablespaces for P6 PPM: RuntimeException (Error in Run SQL Script ssppm_init_db.sql : DatabaseToolException (Incorrect syntax near the keyword 'ON'.)) (Error in Create the SQL Server tablespaces for P6 PPM : RuntimeException (Error in Run SQL Script ssppm_init_db.sql : DatabaseToolException (Incorrect syntax near the keyword 'ON'.)))

 

The DatabaseSetup.log contains the following error:

[ERROR] [2017-09-12 12:18:41] Incorrect syntax near the keyword 'ON'.
[ERROR] [2017-09-12 12:18:41] Database Error: error number=156
[ERROR] [2017-09-12 12:18:41] Error Message: Incorrect syntax near the keyword 'ON'.
[WARN] [2017-09-12 12:18:41] [USER] Could not complete because the job "Run SQL Script ssppm_init_db.sql" failed.
com.primavera.database.tools.DatabaseToolException: Incorrect syntax near the keyword 'ON'.



Steps to Duplicate:

  1. Launch dbsetup.bat.
  2. Select 'Install a new database'.
  3. Select 'Microsoft SQL Server' as the Server type then click Next.
  4. Enter the sa username and password, along with database host name and port, then click Next.
  5. Enter a database name that includes a space in it then click next.
  6. Create new or use the existing 'privileged' and 'public' user names and passwords then click Next.
  7. Observe the reported error.

Changes

 

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