Compatiblity Level Error when Attempting to Create Databases in Microsoft SQL Server 2012 using DBSETUP (Doc ID 1618980.1)

Last updated on JULY 11, 2017

Applies to:

Primavera Contract Management - Version 13.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to create a database in Microsoft SQL Server 2012 using DBSETUP, the following error was generated:

Administration (EXPADMIN) Database Error
RuntimeException: Error in Create the sql server tablespaces : RuntimeException (Error in Run SQL Script ssexpadm_init_db.sql : DatabaseToolException (Usage: sp_dbcmptlevel [dbname [, compatibilitylevel]])) (Error in Create
the sql server tablespaces : RuntimeException (Error in Run SQL Script ssexpadm_init_db.sql : DatabaseToolException (Usage: sp_dbcmptlevel [dbname [, compatibilitylevel]])))


Project Database Error
RuntimeException: Error in Create the SQL Server tablespaces for Contract Management: RuntimeException (Error in Run SQL Script ssexp_init_db.sql : DatabaseToolException (Usage: sp_dbcmptlevel [dbname [, compatibilitylevel]])) (Error in Create the SQL Server tablespaces for Contract Management : RuntimeException (Error in Run SQL Script ssexp_init_db.sql : DatabaseToolException (Usage: sp_dbcmptlevel [dbname [, compatibilitylevel]])))

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