IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Back to discussions
Expand all | Collapse all

Connecting to PeopleSoftEnterprise One

  • 1.  Connecting to PeopleSoftEnterprise One

    Posted Thu October 07, 2004 01:18 AM

    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)


    #webMethods
    #Adapters-and-E-Standards
    #Integration-Server-and-ESB


  • 2.  RE: Connecting to PeopleSoftEnterprise One

    Posted Thu October 07, 2004 07:10 AM

    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.


    #webMethods
    #Integration-Server-and-ESB
    #Adapters-and-E-Standards


  • 3.  RE: Connecting to PeopleSoftEnterprise One

    Posted Wed October 13, 2004 03:53 PM

    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


    #Adapters-and-E-Standards
    #Integration-Server-and-ESB
    #webMethods


  • 4.  RE: Connecting to PeopleSoftEnterprise One

    Posted Thu October 14, 2004 12:39 PM

    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?


    #Integration-Server-and-ESB
    #Adapters-and-E-Standards
    #webMethods


  • 5.  RE: Connecting to PeopleSoftEnterprise One

    Posted Mon October 25, 2004 11:54 PM

    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


    #Adapters-and-E-Standards
    #webMethods
    #Integration-Server-and-ESB


  • 6.  RE: Connecting to PeopleSoftEnterprise One

    Posted Tue November 23, 2004 12:24 PM

    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


    #Adapters-and-E-Standards
    #webMethods
    #Integration-Server-and-ESB


  • 7.  RE: Connecting to PeopleSoftEnterprise One

    Posted Fri August 12, 2005 09:10 AM

    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


    #Adapters-and-E-Standards
    #webMethods
    #Integration-Server-and-ESB


  • 8.  RE: Connecting to PeopleSoftEnterprise One

    Posted Fri September 02, 2005 04:46 AM

    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!


    #Integration-Server-and-ESB
    #webMethods
    #Adapters-and-E-Standards


  • 9.  RE: Connecting to PeopleSoftEnterprise One

    Posted Thu September 08, 2005 11:14 AM

    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


    #webMethods
    #Integration-Server-and-ESB
    #Adapters-and-E-Standards


  • 10.  RE: Connecting to PeopleSoftEnterprise One

    Posted Mon September 19, 2005 09:41 AM

    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…


    #Integration-Server-and-ESB
    #webMethods
    #Adapters-and-E-Standards


  • 11.  RE: Connecting to PeopleSoftEnterprise One

    Posted Tue October 04, 2005 04:10 PM

    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.


    #Integration-Server-and-ESB
    #webMethods
    #Adapters-and-E-Standards


  • 12.  RE: Connecting to PeopleSoftEnterprise One

    Posted Wed October 05, 2005 09:40 AM

    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.


    #Integration-Server-and-ESB
    #webMethods
    #Adapters-and-E-Standards


Related Content