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 30, 2012

Applies to:

Oracle WebCenter Portal - Version 11.1.1.6.0 to 11.1.1.6.4 [Release 11g]
Information in this document applies to any platform.

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

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