Connectivity with a Microsoft SQL Server 2005 Security Database May Fail With Some Webcenter Interaction Products (Doc ID 1070618.1)

Last updated on DECEMBER 02, 2016

Applies to:

Oracle-BEA AquaLogic Pathways - Version 1.5.0 and later
Oracle WebCenter Interaction Common Security - Version 1.0 and later
Oracle WebCenter Ensemble - Version 10.3.0.0 and later
Oracle WebCenter Interaction Common Remoting Servic - Version 2.0.0 and later
Oracle WebCenter Analytics - Version 2.5 and later
Information in this document applies to any platform.
***Checked for relevance on 28-Jan-2014***

Symptoms

Connectivity with a MS SQL Server 2005 Security Database may fail with some Webcenter Interaction Activity Services, if the Security Database Password has the particular string pattern, 'ORACLExxxxxxxx'.

For example, WebCenter Analytics 10.3.0.1 is one of the Activity Services that utilizes the 'Common Security Services' component. When Analytics connects to the Security Database in SQL Server 2005, 'Common Security Services' incorrectly chooses to use an Oracle dictionary to submit queries to the database.

When analyzing a PTSPY trace of the Analytics product, the Common Security Services logs the following message:

2312 analytics.SERVER.Administrator 1-22-2010 12:50:24.293 Info Common Security Services
WrapperStartStopAppMain com.bea.common.security.service.StoreService Using dictionary class "org.apache.openjpa.jdbc.sql.OracleDictionary".


The wrapper.log of the Analytics Service shows an invalid MS SQL Server 2005 Query with an 'incorrect syntax' error:

INFO | jvm 1 | 2010/02/23 12:22:34 | Caused by: weblogic.management.utils.NotFoundException: <1.0.0-SNAPSHOT-SNAPSHOT nonfatal store error> kodo.jdo.DataStoreException: [plumtree][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'. {prepstmnt 2691845 SELECT t0.DOMN, t0.REALMN, t0.NAME, t1.URI FROM BEASAML2_SPPARTNER t0, BEASAML2_SP_AUDIENCEURI t1 WHERE (t0.DOMN = ? AND t0.REALMN = ? AND t0.NAME = ?) AND t0.DOMN = t1.DOMN(+) AND t0.REALMN = t1.REALMN(+) AND t0.NAME = t1.PARTNER_NAME(+) ORDER BY t0.DOMN ASC, t0.REALMN ASC, t0.NAME ASC [params=(String) alui-domain-name, (String) alui-realm, (String) SAML2_CM_WSSSPPartner]} [code=102, state=HY000]

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