EGRC 8.6.3: Access Synchronization/ETL on Peoplesoft Datasource on MS SQL Server 2008 Fails With Error '[FMWGEN][SQLServer JDBC Driver]This driver is locked for use with embedded applications' (Doc ID 1541146.1)

Last updated on FEBRUARY 09, 2015

Applies to:

Oracle Application Access Controls Governor - Version 8.6.3 to 8.6.3 [Release 8]
Information in this document applies to any platform.

Symptoms

GRC build version: GRC 8.6.3 ( any minor version) or 8.6.4 ( any minor version)

Access Synchronization/ETL on Peoplesoft Datasource on MS SQL Server 2008 Fails and application server is Tomcat With Error.

Error
--------
ERROR [SimpleAsyncTaskExecutor-1] JuliToLog4jHandler:76 (com.sunopsis.dwg.dbobj.SnpSession:2137) Mar 20, 2013 2:53:14 PM com.sunopsis.dwg.dbobj.SnpSession treatSession
SEVERE: Session LOADACCESSDATA (162144) fails with return code 8000.
ODI-1226: Step PS_OPR_DEF_TBL_HR_EXISTS fails after 1 attempt(s).
ODI-1228: Task PS_OPR_DEF_TBL_HR_EXISTS (Variable) fails on the target  connection physical_schema_src.
Caused By: java.sql.SQLException: [FMWGEN][SQLServer JDBC Driver]This driver is locked for use with embedded applications.

Steps to Reproduce

----------------------

1.GRC is deployed on Tomcat.

2.Setup a data source that is Peoplesoft FIN or HR 9.1 on database MS SQl Server 2008 R2.

3. Run Access Synchronization.

Impact on Business

-------------------------
Due to this issue, customer is not able to complete Access Synchronization.

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