E-One connection could not be enabled

, ,
1

Issue in enabling E-one connection in webMethod

Connection Type Oracle EnterpriseOne Connection

Error encountered
[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource JDEConnections.unicem:E810_LocalTransaction.
[ART.118.5063] Adapter Runtime (Connection): Unable to start connection JDEConnections.unicem:E810_LocalTransaction: after 1 attempt(s).
Exception occurred while validating role and/or environment in Java Connector Login method:Unknown return code from role validation: 12
com.jdedwards.system.connector.dynamic.ServerFailureException: Exception occurred while validating role and/or environment in Java Connector Login method:Unknown return code from role validation: 12
at com.jdedwards.system.connector.dynamic.Connector.loginBase(Unknown Source)
at com.jdedwards.system.connector.dynamic.Connector.loginBase(Unknown Source)
at com.jdedwards.system.connector.dynamic.Connector.login(Unknown Source)
at com.psft.xpi.adapter.erp.classloader.ERP9ConnectorAbstracter.getSession(ERP9ConnectorAbstracter.java:239)
Can you please help us out

E-ONE_ConnectionError.PNG
E-ONE_ConnectionError.PNG943×365 217 KB

2

Hi Chaitra,

please provide your IS version, your E-One Adapter version as well as the applied fixes for IS, ART, E-One Adapter?

Please check if you have the correct E-One API applied to your Adapter.

Regards,
Holger

3

Hi Holger,

Here are the details:

IS Version:9.6
E-One Adapter version :8.98
Applied fixes for IS, ART:
TNS_9.6_Fix4
IS_9.6_Core_Fix1
WmART - WAR_9.6_Fix1
WmJDBCAdapter - JDBC_6.5_Fix39

Note: the same connection work’s well in Dev environment , when i tested in QA the connection is not enabling though all fixes/jars are same across both the environments.

4

Hi Chaitra,

you should consider updating your FixLevel.

Latest Fixes are:
TNS_9-6_Fix10
IS_9-6_Core_Fix16
WAR_9-6_Fix5
JDBC_6-5_Fix55

Please note that these Fixes might require additional fixes to be applied too.
These are mentioned in the readmes of the fixes.

Additionally there are two Fixes for EnterpiseOne Adapter 8.98 available.

Regards,
Holger

5

Hi Holger,
In that case even in Dev environment the connection should have similar issue isn’t it?

Why only in QA we have this issue?

Note: Both Dev and QA have similar fixes!

Regards,
Chaitra

6

Hi Chaitra,

are you sure that both connections have identical values?

Please check for leading and trailing blanks in the values.

The error message comes either from API or from E-One server.

Similar, but not identical?

Regards,
Holger

7

hi hogler,

Both connections have identical values!
We cross verified again, there are no trailing blanks in the values.

Regards,
Chaitra

8

I assume you are trying to enable this as first time in your QA?

Can you please check if any jar file associated to E-one adapter are there in QA env similar to your dev configuration?

There is a possibility may be some thing is missing your dev (working) vs qa (not working)

HTH,
RMG