E1: ENV: While Activating OCM Mappings, Getting Error: "Activating Invalid Data Source" (Doc ID 963403.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

JD Edwards EnterpriseOne Tools - Version 8.98 and later
Information in this document applies to any platform.

Symptoms

In this scenario, customer is on EnterpriseOne 8.12 applications release level. The status of F9860 OCM mapping for PS812 environment is NA (Not Active).  When you try to change the status of the OCM mapping for F9860 in the Planner database for PS812 & JPS812 from Non-Active to Active, it throws the following error message:

Error : Activating Invalid Data Source

As a result, you are unable to login to PS812 environment on the Deployment Server and the following error message appears:

Error Opening F98MOQUE Table

The JDE.LOG has the following messages:

3164/3168 MAIN_THREAD Wed Nov 04 09:19:36.250000 Jdb_ctl.c3488        Starting OneWorld
3164/3168 MAIN_THREAD Wed Nov 04 09:19:38.812000 Odbc_u1.c901       ODB0000163 - wSQLNumResultCols failure. rc=-1
3164/3168 MAIN_THREAD Wed Nov 04 09:19:38.812005 Jdb_drvm.c893      JDB9900168 - Failed to initialize db request
3164/3168 MAIN_THREAD Wed Nov 04 09:19:38.812006 Jtp_cm.c1004        JDB9909007 - Unable to obtain driver request handle

 

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