Sqlserver Incompatibility - Ps4fp

(Doc ID 1445970.1)

Last updated on APRIL 10, 2012

Applies to:

Oracle Business Process Management Suite - Version: 11.1.1.5.0 and later   [Release: 11gR1 and later ]
Information in this document applies to any platform.

Symptoms

Error occurs during human task/message callbacks

Internal Exception: java.sql.SQLSyntaxErrorException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Invalid column name 'xxxx'.
Error Code: 207
Call: SELECT ds1.SUBSCRIBER_ID, ds1.CONV_ID, ds1.CONV_TYPE, ds1.xxxxx, ds1.DOMAIN_NAME, ds1.COMPOSITE_NAME, ds1.COMPONENT_NAME, ds1.COMPOSITE_LABEL, ds1.COMPOSITE_REVISION, ds1.OPERATION_NAME, ds1.EVENT_NAME, ds1.PARTNER_LINK, ds1.SERVICE_NAME, ds1.SUBSCRIPTION_DATE, ds1.STATE, ds1.PROPERTIES FROM DLV_SUBSCRIPTION ds1 WITH (UPDLOCK, NOWAIT), (SELECT DISTINCT ds2.xxxxx FROM DLV_SUBSCRIPTION ds2 WHERE ds2.CONV_ID = ? AND ds2.COMPONENT_NAME = ? AND ds2.STATE = 0) unresolved_subscriptions, CUBE_INSTANCE ci WHERE ds1.xxxxx = unresolved_subscriptions.xxxxx AND ds1.STATE = 0 AND NOT EXISTS (SELECT 1 FROM DLV_SUBSCRIPTION ds3 WHERE ds3.STATE = 1 AND ds3.xxxxx = ds1.xxxxx) AND ci.xxxxx = unresolved_subscriptions.xxxxx AND ci.state NOT in (2)


Changes

SQL Server 2008 has collation settings that cause queries to be case senstive. It is important to not choose a collation setting that is case sensitive. Microsoft SQL Server 2008 collation settings can be found in the link below.

http://support.microsoft.com/kb/222664

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