Connecting to PeopleSoftEnterprise One

, ,
1

hi,
Iam using WM6.1 for connecting PeopleSoftEnterpriseOne(DV7334).When i enable conection iam getting following error.Could any one help me.

Thanks In Advance
Balaji

[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource connection:EnterpriseOne.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
[SECURITY_ERROR] SECURITY_ERROR
com.jdedwards.system.security.SecurityServerException: FAILURE: null
at com.jdedwards.system.security.proxy.SecurityServerProxyImpl.processSecurityServerRequest(Unknown Source)
at com.jdedwards.system.security.proxy.SecurityServerProxyImpl.login(Unknown Source)
at com.jdedwards.database.impl.signon.JDBSignon.signon(Unknown Source)
at com.psft.xpi.adapter.erp.classloader.ERP9ConnectorAbstracter.createBaseJDBjConnection(ERP9ConnectorAbstracter.java:52)
at java.lang.reflect.Method.invoke(Native Method)
at com.psft.xpi.adapter.erp.connection.ConnectionFactory.executeConnectionMethod(ConnectionFactory.java:139)
at com.psft.xpi.adapter.erp.connection.ERP9ConnectionFactory.initializeConnector(ERP9ConnectionFactory.java:380)
at com.psft.xpi.adapter.erp.connection.ERP9ConnectionFactory.addConnection(ERP9ConnectionFactory.java:301)
at com.psft.xpi.adapter.erp.connection.ERP9Connection.initializeConnection(ERP9Connection.java:97)
at com.wm.adk.connection.WmManagedConnectionFactory.createManagedConnection(WmManagedConnectionFactory.java:168)
at com.wm.app.b2b.server.jca.WmConnectionPool$ConnectionEntry.(WmConnectionPool.java:919)
at com.wm.app.b2b.server.jca.WmConnectionPool.init(WmConnectionPool.java:269)
at com.wm.app.b2b.server.jca.WmConnectionPool.(WmConnectionPool.java:172)
at com.wm.app.b2b.server.jca.WmConnectionManager.setConfiguration(WmConnectionManager.java:197)
at com.wm.pkg.art.j2eecaBridge.WmConnectionManagerPropertiesBridge.setManagerProperties(WmConnectionManagerPropertiesBridge.java:156)
at com.wm.pkg.art.ns.ConnectionDataNodeManager.createConnectionManager(ConnectionDataNodeManager.java:809)
at com.wm.pkg.art.ns.ConnectionDataNode.createAndStartConnectionResource(ConnectionDataNode.java:782)
at com.wm.pkg.art.ns.ConnectionDataNode.enable(ConnectionDataNode.java:633)
at com.wm.pkg.art.ns.ConnectionDataNodeManager.setConnectionState(ConnectionDataNodeManager.java:1058)
at java.lang.reflect.Method.invoke(Native Method)
at com.wm.app.b2b.server.JavaService.baseInvoke(JavaService.java:287)
at com.wm.app.b2b.server.invoke.InvokeManager.process(InvokeManager.java:554)
at com.wm.app.b2b.server.invoke.StatisticsProcessor.process(StatisticsProcessor.java:44)
at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java:221)
at com.wm.app.b2b.server.invoke.ValidateProcessor.process(ValidateProcessor.java:49)
at com.wm.app.b2b.server.ACLManager.process(ACLManager.java:194)
at com.wm.app.b2b.server.invoke.DispatchProcessor.process(DispatchProcessor.java:39)
at com.wm.app.b2b.server.AuditLogManager.process(AuditLogManager.java:384)
at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:486)
at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:359)
at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:246)
at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:128)
at com.wm.app.b2b.server.ns.Namespace.invoke(Namespace.java:533)
at com.wm.util.template.Reporter.invoke(Reporter.java:963)
at com.wm.util.template.InvokeToken.eval(InvokeToken.java:75)
at com.wm.util.template.TemplateToken.evalChild(TemplateToken.java(Inlined Compiled Code))
at com.wm.util.template.SwitchToken.evalChild(SwitchToken.java(Compiled Code))
at com.wm.util.template.TemplateToken.eval(TemplateToken.java(Compiled Code))
at com.wm.util.template.SwitchToken.eval(SwitchToken.java:58)
at com.wm.util.template.TemplateToken.evalChild(TemplateToken.java(Inlined Compiled Code))
at com.wm.util.template.IfVarToken.evalChild(IfVarToken.java(Inlined Compiled Code))
at com.wm.util.template.TemplateToken.eval(TemplateToken.java(Inlined Compiled Code))
at com.wm.util.template.IfVarToken.eval(IfVarToken.java(Compiled Code))
at com.wm.util.template.TemplateToken.evalChild(TemplateToken.java(Compiled Code))
at com.wm.util.template.TemplateToken.eval(TemplateToken.java(Compiled Code))
at com.wm.util.template.Reporter.reportNoReset(Reporter.java:1299)
at com.wm.util.template.Reporter.reportToOutput(Reporter.java:1274)
at com.wm.util.template.Reporter.reportIData(Reporter.java:1163)
at com.wm.app.b2b.server.HTTPDocHandler._process(HTTPDocHandler.java:490)
at com.wm.app.b2b.server.HTTPDocHandler.process(HTTPDocHandler.java:112)
at com.wm.app.b2b.server.Dispatch.run(Dispatch.java:311)
at com.wm.util.pool.PooledThread.run(PooledThread.java:105)
at java.lang.Thread.run(Thread.java:512)
com.jdedwards.database.base.JDBException: [SECURITY_ERROR] SECURITY_ERROR
at com.jdedwards.database.impl.signon.JDBSignon.signon(Unknown Source)
at com.psft.xpi.adapter.erp.classloader.ERP9ConnectorAbstracter.createBaseJDBjConnection(ERP9ConnectorAbstracter.java:52)
at java.lang.reflect.Method.invoke(Native Method)
at com.psft.xpi.adapter.erp.connection.ConnectionFactory.executeConnectionMethod(ConnectionFactory.java:139)
at com.psft.xpi.adapter.erp.connection.ERP9ConnectionFactory.initializeConnector(ERP9ConnectionFactory.java:380)
at com.psft.xpi.adapter.erp.connection.ERP9ConnectionFactory.addConnection(ERP9ConnectionFactory.java:301)
at com.psft.xpi.adapter.erp.connection.ERP9Connection.initializeConnection(ERP9Connection.java:97)
at com.wm.adk.connection.WmManagedConnectionFactory.createManagedConnection(WmManagedConnectionFactory.java:168)
at com.wm.app.b2b.server.jca.WmConnectionPool$ConnectionEntry.(WmConnectionPool.java:919)
at com.wm.app.b2b.server.jca.WmConnectionPool.init(WmConnectionPool.java:269)
at com.wm.app.b2b.server.jca.WmConnectionPool.(WmConnectionPool.java:172)
at com.wm.app.b2b.server.jca.WmConnectionManager.setConfiguration(WmConnectionManager.java:197)
at com.wm.pkg.art.j2eecaBridge.WmConnectionManagerPropertiesBridge.setManagerProperties(WmConnectionManagerPropertiesBridge.java:156)
at com.wm.pkg.art.ns.ConnectionDataNodeManager.createConnectionManager(ConnectionDataNodeManager.java:809)
at com.wm.pkg.art.ns.ConnectionDataNode.createAndStartConnectionResource(ConnectionDataNode.java:782)
at com.wm.pkg.art.ns.ConnectionDataNode.enable(ConnectionDataNode.java:633)
at com.wm.pkg.art.ns.ConnectionDataNodeManager.setConnectionState(ConnectionDataNodeManager.java:1058)
at java.lang.reflect.Method.invoke(Native Method)
at com.wm.app.b2b.server.JavaService.baseInvoke(JavaService.java:287)
at com.wm.app.b2b.server.invoke.InvokeManager.process(InvokeManager.java:554)
at com.wm.app.b2b.server.invoke.StatisticsProcessor.process(StatisticsProcessor.java:44)
at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java:221)
at com.wm.app.b2b.server.invoke.ValidateProcessor.process(ValidateProcessor.java:49)
at com.wm.app.b2b.server.ACLManager.process(ACLManager.java:194)
at com.wm.app.b2b.server.invoke.DispatchProcessor.process(DispatchProcessor.java:39)
at com.wm.app.b2b.server.AuditLogManager.process(AuditLogManager.java:384)
at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:486)
at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:359)
at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:246)
at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:128)
at com.wm.app.b2b.server.ns.Namespace.invoke(Namespace.java:533)
at com.wm.util.template.Reporter.invoke(Reporter.java:963)
at com.wm.util.template.InvokeToken.eval(InvokeToken.java:75)
at com.wm.util.template.TemplateToken.evalChild(TemplateToken.java(Inlined Compiled Code))
at com.wm.util.template.SwitchToken.evalChild(SwitchToken.java(Compiled Code))
at com.wm.util.template.TemplateToken.eval(TemplateToken.java(Compiled Code))
at com.wm.util.template.SwitchToken.eval(SwitchToken.java:58)
at com.wm.util.template.TemplateToken.evalChild(TemplateToken.java(Inlined Compiled Code))
at com.wm.util.template.IfVarToken.evalChild(IfVarToken.java(Inlined Compiled Code))
at com.wm.util.template.TemplateToken.eval(TemplateToken.java(Inlined Compiled Code))
at com.wm.util.template.IfVarToken.eval(IfVarToken.java(Compiled Code))
at com.wm.util.template.TemplateToken.evalChild(TemplateToken.java(Compiled Code))
at com.wm.util.template.TemplateToken.eval(TemplateToken.java(Compiled Code))
at com.wm.util.template.Reporter.reportNoReset(Reporter.java:1299)
at com.wm.util.template.Reporter.reportToOutput(Reporter.java:1274)
at com.wm.util.template.Reporter.reportIData(Reporter.java:1163)
at com.wm.app.b2b.server.HTTPDocHandler._process(HTTPDocHandler.java:490)
at com.wm.app.b2b.server.HTTPDocHandler.process(HTTPDocHandler.java:112)
at com.wm.app.b2b.server.Dispatch.run(Dispatch.java:311)
at com.wm.util.pool.PooledThread.run(PooledThread.java:105)
at java.lang.Thread.run(Thread.java:512)

2

I have this problem for past two months to configue PSFT adpater to JDE One. Now the ticket is with PSFT sicne this adapter is developed by them. Not sure both are in same boat, post if you can solve this problem. My environmenet is 7333 SP22.

3

The problem is the Adapter expects only the machine name and OneWorld will expect only machine name, so do this:
On adapter host, add this to /etc/hosts
OW server IP OWmachineName

On OW server host, add this to /etc/hosts
AdapterServerIP AdapterServername

The in Adapter config, under ERP host and Security host, use OWmachineName
Also, you need minimum OW-XE SP22_O1

Hope this helps. We are having issues of receiving RTE’s from OW-XE. If you guys get this working, appreciate if you could let me know.
Thanks.
Eric

4

Eric, is this host information needs to be created under IntegrationServer folder?. I don’t see any /etc folder there.

Right now our environment is SP22_I1. Do you have any idea is there any specific difference between I1 and O1 related to PSFT adapter?

5

Hey Guys

I am facing the same error till date, Has anyone found a solution for the same and has any1 figured out what eric_rustomji was trying to say.
This is preetu urgent if you guys can help

Error encountered
[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource Conn_Name.connection:connectWeaas400.
[ART.118.5021] Adapter Runtime (Connection): Unable to process connection properties. Internal error.

Thanks
AJ

6

Hey guys,

Sorry didnt get back to this earlier.
You have to edit your Unix /etc/hosts file where your IS server is running
and put the entry for the OW server in there, e.g.
OW1server 10.10.2.3

Then on your OW server, do the same in /etc/hosts
ISServer 10.10.7.9

In your adapter connection configuration screen, just use OW1serve and same for security server as well.
Hope that helps.
Thanks

7

Hi

I am geting following error during the PeopleSoftEnterprise One Adapter configuration

Error encountered
[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource Sample:EnterpriseOne89.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
[SECURITY_ERROR2] A security error occurred, status=1, error code=337.
com.jdedwards.database.base.JDBException: [SECURITY_ERROR2] A security error occurred, status=1, error code=337.
at com.jdedwards.database.impl.signon.JDBSignon.signon(Unknown Source)
at com.psft.xpi.adapter.erp.classloader.ERP9ConnectorAbstracter.createBaseJDBjConnection(ERP9ConnectorAbstracter.java:52)
at java.lang.reflect.Method.invoke(Native Method)
at com.psft.xpi.adapter.erp.connection.ConnectionFactory.executeConnectionMethod(ConnectionFactory.java:144)
at com.psft.xpi.adapter.erp.connection.ERP9ConnectionFactory.initializeConnector(ERP9ConnectionFactory.java:420)
at com.psft.xpi.adapter.erp.connection.ERP9ConnectionFactory.addConnection(ERP9ConnectionFactory.java:340)
at com.psft.xpi.adapter.erp.connection.ERP9Connection.initializeConnection(ERP9Connection.java:97)
at com.wm.adk.connection.WmManagedConnectionFactory.createManagedConnection(WmManagedConnectionFactory.java:168)
at com.wm.app.b2b.server.jca.WmConnectionPool$ConnectionEntry.(WmConnectionPool.java:925)
at com.wm.app.b2b.server.jca.WmConnectionPool.init(WmConnectionPool.java:269)
at com.wm.app.b2b.server.jca.WmConnectionPool.(WmConnectionPool.java:172)
at com.wm.app.b2b.server.jca.WmConnectionManager.setConfiguration(WmConnectionManager.java:197)
at com.wm.pkg.art.j2eecaBridge.WmConnectionManagerPropertiesBridge.setManagerProperties(WmConnectionManagerPropertiesBridge.java:156)
at com.wm.pkg.art.ns.ConnectionDataNodeManager.createConnectionManager(ConnectionDataNodeManager.java:809)
at com.wm.pkg.art.ns.ConnectionDataNode.createAndStartConnectionResource(ConnectionDataNode.java:782)
at com.wm.pkg.art.ns.ConnectionDataNode.enable(ConnectionDataNode.java:633)
at com.wm.pkg.art.ns.ConnectionDataNodeManager.setConnectionState(ConnectionDataNodeManager.java:1058)
at java.lang.reflect.Method.invoke(Native Method)
at com.wm.app.b2b.server.JavaService.baseInvoke(JavaService.java:287)
at com.wm.app.b2b.server.invoke.InvokeManager.process(InvokeManager.java:587)
at com.wm.app.b2b.server.invoke.StatisticsProcessor.process(StatisticsProcessor.java:44)
at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java:229)
at com.wm.app.b2b.server.invoke.ValidateProcessor.process(ValidateProcessor.java:49)
at com.wm.app.b2b.server.ACLManager.process(ACLManager.java:194)
at com.wm.app.b2b.server.invoke.DispatchProcessor.process(DispatchProcessor.java:39)
at com.wm.app.b2b.server.AuditLogManager.process(AuditLogManager.java:403)
at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:503)
at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:367)
at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:246)
at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:128)
at com.wm.app.b2b.server.ns.Namespace.invoke(Namespace.java:533)
at com.wm.util.template.Reporter.invoke(Reporter.java:963)
at com.wm.util.template.InvokeToken.eval(InvokeToken.java:75)
at com.wm.util.template.TemplateToken.evalChild(TemplateToken.java(Compiled Code))
at com.wm.util.template.SwitchToken.evalChild(SwitchToken.java:90)
at com.wm.util.template.TemplateToken.eval(TemplateToken.java(Compiled Code))
at com.wm.util.template.SwitchToken.eval(SwitchToken.java:58)
at com.wm.util.template.TemplateToken.evalChild(TemplateToken.java(Inlined Compiled Code))
at com.wm.util.template.IfVarToken.evalChild(IfVarToken.java(Compiled Code))
at com.wm.util.template.TemplateToken.eval(TemplateToken.java(Compiled Code))
at com.wm.util.template.IfVarToken.eval(IfVarToken.java:219)
at com.wm.util.template.TemplateToken.evalChild(TemplateToken.java(Compiled Code))
at com.wm.util.template.TemplateToken.eval(TemplateToken.java(Compiled Code))
at com.wm.util.template.Reporter.reportNoReset(Reporter.java:1299)
at com.wm.util.template.Reporter.reportToOutput(Reporter.java:1274)
at com.wm.util.template.Reporter.reportIData(Reporter.java:1163)
at com.wm.app.b2b.server.HTTPDocHandler._process(HTTPDocHandler.java:490)
at com.wm.app.b2b.server.HTTPDocHandler.process(HTTPDocHandler.java:112)
at com.wm.app.b2b.server.Dispatch.run(Dispatch.java:311)
at com.wm.util.pool.PooledThread.run(PooledThread.java:105)
at java.lang.Thread.run(Thread.java:512)

Can you help to solve this problem.
Regards
Pandurang

8

Hi pandurang

I’m getting exactly the same error, been trying for 3 weeks now to solve it, with the help of PeopleSoft but to no avail…
If you managed to solve it, could you give me a pointer to what was wrong?
Thanks!

9

Did you add the entries in /etc/hosts on wM server as well as your OneWorld server?

If you have a separate OneWorld security server, then add the wM machine name in there as well in its /etc/hosts.

Eric

10

Hello Eric,

On my wM server, I changed the {windows sys32}/drivers/etc/hosts (and lmhosts) file to contain the OW Ent Server and on the (AS400) OW server, I added an entry for the wM server but I’m still receiving the same error.

Are there any pointers I can get from the logs? There’s a strange link in there, pointing to my jdeinterop.ini file… Could it cause the problems?
Here’s the strange line I’m talking about:
19 sep 2005 15:25:45,781 [HTTP Handler 10.48.31.18] INFO : {com.jdedwards.base.util.IniFileLoader} - Loading config from file F:/XPI894/IntegrationServer//ini_files/E811_DV_Connection//jdeinterop.ini per the config_file system property.

there seem to be too many / on a few places… It doesn’t throw an error on this…

11

Hi,

Copy the jdeinterop.ini file from OW server to your WM server and use it there.
Also the Event port in the ini files, u will need to play with till u find a port which is available to use on the OW server. (use netstat -a) for it.

12

I had this issue (error) earlier with webMethods 6.1 PSFT adapter to connect with E1 (JDE) DV7333 J1. Then found out that this adapter requires patch level greater than SP22 O1. After upgrading the JDE, it worked.