My Oracle Support Banner

Sqlserver Incompatibility - Ps4fp (Doc ID 1445970.1)

Last updated on APRIL 10, 2012

Applies to:

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


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)


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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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