Unable to Start the Analytics-collector When Configured with Microsoft SQL Server Database, Error "java.sql.SQLException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Partition function can only be created in Enterprise edition of SQL Server." (Doc ID 1508042.1)

Last updated on NOVEMBER 06, 2023

Applies to:

Symptoms

When attempting to start all WebCenter servers the internal application: "analytics-collector" is down and fails to start. (Application Defined MBeans >oracle.webcenter.analytics >Server: WC_Utilities >Application: analytics-collector)

The WC_Utilities_diagnostic.log file shows the exception below:

Caused By: java.sql.SQLException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Partition
function can only be created in Enterprise edition of SQL Server. Only Enterprise
edition of SQL Server supports partitioning.
at weblogic.jdbc.sqlserverbase.ddb_.b(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb_.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb9.b(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb9.a(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddr.v(Unknown Source)
Truncated. see log file for complete stacktrace

Changes

 WebCenter is configured to connect to a Microsoft (MS) SQL Server database.

Cause

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