EnterPriseOne Adapter 8.0 unble to invoke adapter service

anumolurk · March 8, 2006, 10:47pm

Hi All,
I am working on webMethods 6.x, JDE EnterPriseOneWorld adapter 8.0.Just i invoked Business Functions(BF) from JDE Side and I am trying to feed dummy data from webMethods to JDE.I want to see the data is sending to table in JDE or Not.
I created adapter services successfully and invoked BF.If ran the adapter service and feed some data in the fields i am getting the following error.

Could not run ‘Inventory_Transfer_Header_NER’.

com.wm.app.b2b.server.ServiceException: [ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service MU084_GSC_JDEConnections.adapterInventoryOperations.adapterInventoryTransfer:Inventory_Transfer_Header_NER.
null
java.lang.reflect.InvocationTargetException
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:324)
    at com.psft.xpi.adapter.erp.service.ERP8_BSFNTemplateImpl.execute(ERP8_BSFNTemplateImpl.java:228)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:324)
    at com.psft.xpi.adapter.erp.service.BSFNExecuteTemplate.execute(BSFNExecuteTemplate.java:173)
    at com.wm.adk.cci.interaction.WmInteraction.execute(WmInteraction.java:70)
    at com.wm.pkg.art.ns.AdapterServiceNode.invokeService(AdapterServiceNode.java:596)
    at com.wm.pkg.art.ns.ARTNSService.baseInvoke(ARTNSService.java:47)
    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:198)
    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.comm.DefaultServerRequestHandler.handleMessage(DefaultServerRequestHandler.java:119)
    at com.wm.app.b2b.server.HTTPMessageHandler.process(HTTPMessageHandler.java:167)
    at com.wm.app.b2b.server.Dispatch.run(Dispatch.java:298)
    at com.wm.util.pool.PooledThread.run(PooledThread.java:105)
    at java.lang.Thread.run(Thread.java:534)
Caused by: com.jdedwards.system.connector.StringTooLongException: szY55WADJ_Company_code must be less than 3 characters long.
    at com.jdedwards.application.interop.jdewmhcs.D55411301.setszY55WADJ_Company_code(D55411301.java:138)
    ... 28 more

anumolurk · March 15, 2006, 8:30pm

Hi,
I am getting FTP’d file and publishing to the broker, trigger fires and invoke JDE Business Function(BF).In this case I have somany Header and Data Records In FF.Problem is Only few records are storeing into JDE Tables and rest of the records are storing .I am getting error as follows

Error-Adjustment_Detail_NER-null-078L-Error: Initialization of cache F41UI001 failed in xt4111z1.c javax.resource.ResourceException: Error-Adjustment_Detail_NER-null-078L-Error: Initialization of cache F41UI001 failed in xt4111z1.c at com.psft.xpi.adapter.erp.service.ERP8_BSFNTemplateImpl.execute(ERP8_BSFNTemplateImpl.java:304) at sun.reflect.GeneratedMethodAccessor116.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at com.psft.xpi.adapter.erp.service.BSFNExecuteTemplate.execute(BSFNExecuteTemplate.java:173) at com.wm.adk.cci.interaction.WmInteraction.execute(WmInteraction.java:70) at com.wm.pkg.art.ns.AdapterServiceNode.invokeService(AdapterServiceNode.java:596) at com.wm.pkg.art.ns.ARTNSService.baseInvoke(ARTNSService.java:47) at com.wm.app.b2b.server.invoke.InvokeManager.process(InvokeManager.java:587) at com.wm.app.b2b.server.invoke.StatisticsProcessor.proce Stack trace data … e0b16ea0b43211dab42cb50927a71385

Any one can guide me .
It is an Importent issue.
Thanks
Ravi

artischeung · March 20, 2006, 8:18am

Hi all,
I have simular problem: I am using Adapter service to call JDE BSFN. The adapter call is returning Java-like exception error after 6-7 minutes (I logged the error to a text file in exception handling routine). Besides, JDE side found 1 of the BSDNs in the Adapter service is called twice (know from JDE job queue history) and hence JDE table found duplicate records. Note that the call is normally OK in many attempts: it completes within 20 seconds and no duplicate record found.

Is there any setting in wM so that the service itself will retry to call JDE BSFN automatically? Say, when no reply from JDE after 5 minutes (but actually JDE is processing the job in queue and take more than 5 minutes), wM fires the same call to JDE again.

Thanks,
Artis Cheung

Error logged in the file:

 com.wm.pkg.art.error.DetailedServiceException: [ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service hswf_jde.as:enterPOReceiptsPA.
[ADA.7180.1018] SystemException: Fatal exception thrown when executing BSFN Method.
Fail to execute BSFNMethod com.jdedwards.system.kernel.CallObjectSystemException: The business function being executed is causing a problem
 at com.wm.pkg.art.error.DetailedServiceException.create(DetailedServiceException.java:125)
 at com.wm.pkg.art.error.DetailedServiceException.create(DetailedServiceException.java:116)
 at com.wm.pkg.art.error.DetailedServiceException.create(DetailedServiceException.java:103)
 at com.wm.pkg.art.ns.AdapterServiceNode.invokeService(AdapterServiceNode.java(Compiled Code))
 at com.wm.pkg.art.ns.ARTNSService.baseInvoke(ARTNSService.java(Compiled Code))
 at com.wm.app.b2b.server.invoke.InvokeManager.process(InvokeManager.java(Compiled Code))
 at com.wm.app.b2b.server.invoke.StatisticsProcessor.process(StatisticsProcessor.java(Compiled Code))
 at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java(Compiled Code))
 at com.wm.app.b2b.server.invoke.ValidateProcessor.process(ValidateProcessor.java(Compiled Code))
 at com.wm.app.b2b.server.ACLManager.process(ACLManager.java(Compiled Code))
 at com.wm.app.b2b.server.invoke.DispatchProcessor.process(DispatchProcessor.java(Compiled Code))
 at com.wm.app.b2b.server.AuditLogManager.process(AuditLogManager.java(Compiled Code))
 at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java(Compiled Code))
 at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java(Inlined Compiled Code))
 at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java(Inlined Compiled Code))
 at com.wm.app.b2b.server.BaseService.invoke(BaseService.java(Compiled Code))
 at com.wm.lang.flow.FlowInvoke.invoke(FlowInvoke.java(Compiled Code))
 at com.wm.lang.flow.FlowState.invokeNode(FlowState.java(Compiled Code))
 at com.wm.lang.flow.FlowState.step(FlowState.java(Compiled Code))
 at com.wm.lang.flow.FlowState.invoke(FlowState.java(Compiled Code))
 at com.wm.app.b2b.server.FlowSvcImpl.baseInvoke(FlowSvcImpl.java(Compiled Code))
 at com.wm.app.b2b.server.invoke.InvokeManager.process(InvokeManager.java(Compiled Code))
 at com.wm.app.b2b.server.invoke.StatisticsProcessor.process(StatisticsProcessor.java(Compiled Code))
 at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java(Compiled Code))
 at com.wm.app.b2b.server.invoke.ValidateProcessor.process(ValidateProcessor.java(Compiled Code))
 at com.wm.app.b2b.server.ACLManager.process(ACLManager.java(Compiled Code))
 at com.wm.app.b2b.server.invoke.DispatchProcessor.process(DispatchProcessor.java(Compiled Code))
 at com.wm.app.b2b.server.AuditLogManager.process(AuditLogManager.java(Compiled Code))
 at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java(Compiled Code))
 at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java(Inlined Compiled Code))
 at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java(Inlined Compiled Code))
 at com.wm.app.b2b.server.BaseService.invoke(BaseService.java(Compiled Code))
 at com.wm.lang.flow.FlowInvoke.invoke(FlowInvoke.java(Compiled Code))
 at com.wm.lang.flow.FlowState.invokeNode(FlowState.java(Compiled Code))
 at com.wm.lang.flow.FlowState.step(FlowState.java(Compiled Code))
 at com.wm.lang.flow.FlowState.invoke(FlowState.java(Compiled Code))
 at com.wm.app.b2b.server.FlowSvcImpl.baseInvoke(FlowSvcImpl.java(Compiled Code))
 at com.wm.app.b2b.server.invoke.InvokeManager.process(InvokeManager.java(Compiled Code))
 at com.wm.app.b2b.server.invoke.StatisticsProcessor.process(StatisticsProcessor.java(Compiled Code))
 at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java(Compiled Code))
 at com.wm.app.b2b.server.invoke.ValidateProcessor.process(ValidateProcessor.java(Compiled Code))
 at com.wm.app.b2b.server.ACLManager.process(ACLManager.java(Compiled Code))
 at com.wm.app.b2b.server.invoke.DispatchProcessor.process(DispatchProcessor.java(Compiled Code))
 at com.wm.app.b2b.server.AuditLogManager.process(AuditLogManager.java(Compiled Code))
 at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java(Compiled Code))
 at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java(Inlined Compiled Code))
 at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java(Inlined Compiled Code))
 at com.wm.app.b2b.server.BaseService.invoke(BaseService.java(Compiled Code))
 at com.wm.lang.flow.FlowInvoke.invoke(FlowInvoke.java(Compiled Code))
 at com.wm.lang.flow.FlowState.invokeNode(FlowState.java(Compiled Code))
 at com.wm.lang.flow.FlowState.step(FlowState.java(Compiled Code))
 at com.wm.lang.flow.FlowState.invoke(FlowState.java(Compiled Code))
 at com.wm.app.b2b.server.FlowSvcImpl.baseInvoke(FlowSvcImpl.java(Compiled Code))
 at com.wm.app.b2b.server.invoke.InvokeManager.process(InvokeManager.java(Compiled Code))
 at com.wm.app.b2b.server.invoke.StatisticsProcessor.process(StatisticsProcessor.java(Compiled Code))
 at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java(Compiled Code))
 at com.wm.app.b2b.server.invoke.ValidateProcessor.process(ValidateProcessor.java(Compiled Code))
 at com.wm.app.b2b.server.ACLManager.process(ACLManager.java(Compiled Code))
 at com.wm.app.b2b.server.invoke.DispatchProcessor.process(DispatchProcessor.java(Compiled Code))
 at com.wm.app.b2b.server.AuditLogManager.process(AuditLogManager.java(Compiled Code))
 at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java(Compiled Code))
 at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java(Inlined Compiled Code))
 at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java(Inlined Compiled Code))
 at com.wm.app.b2b.server.BaseService.invoke(BaseService.java(Compiled Code))
 at com.wm.lang.flow.FlowInvoke.invoke(FlowInvoke.java(Compiled Code))
 at com.wm.lang.flow.FlowState.invokeNode(FlowState.java(Compiled Code))
 at com.wm.lang.flow.FlowState.step(FlowState.java(Compiled Code))
 at com.wm.lang.flow.FlowState.invoke(FlowState.java(Compiled Code))
 at com.wm.app.b2b.server.FlowSvcImpl.baseInvoke(FlowSvcImpl.java(Compiled Code))
 at com.wm.app.b2b.server.invoke.InvokeManager.process(InvokeManager.java(Compiled Code))
 at com.wm.app.b2b.server.invoke.StatisticsProcessor.process(StatisticsProcessor.java(Compiled Code))
 at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java(Compiled Code))
 at com.wm.app.b2b.server.invoke.ValidateProcessor.process(ValidateProcessor.java(Compiled Code))
 at com.wm.app.b2b.server.ACLManager.process(ACLManager.java(Compiled Code))
 at com.wm.app.b2b.server.invoke.DispatchProcessor.process(DispatchProcessor.java(Compiled Code))
 at com.wm.app.b2b.server.AuditLogManager.process(AuditLogManager.java(Compiled Code))
 at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java(Compiled Code))
 at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java(Inlined Compiled Code))
 at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java(Inlined Compiled Code))
 at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java(Inlined Compiled Code))
 at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java(Compiled Code))
 at com.wm.app.b2b.server.SessionInvoke.run(Session.java(Compiled Code))
 at com.wm.util.pool.PooledThread.run(PooledThread.java(Compiled Code))
 at java.lang.Thread.run(Thread.java:512)

rdearnaley · March 21, 2006, 12:13am

My recomendation is that you should not call JDE business functions directly that you expect to run a long time. These type of processes should be put into a UBE and then have a small business function that wM IS can call that kicks off the UBE. If your integration needs to get information back from a long running JDE process, then you should have the UBE write to a results table and have a JDBC basic notification that will kick off a flow service when a record gets written to that results table.

artischeung · March 27, 2006, 1:30pm

Thanks. You recommendation did work.

austin2 · June 6, 2007, 8:35pm

anumolurk

JDE adapter Variables lengths needs to be followed strictly when calling bsfn, szY55WADJ could be a string of length 2 in your particular installation. Check with CNC or your JDE Developer for exact field lengths

your error is definitely one related to Data and required input parameters. JDE adapter can be really a scikler when trying to execute business fucntions , Its always a good practice to initialize variable with zero or blanks depending on the parameter type. Hint if variable starts with sz (its a string) mn(is numeric)

HTH

Chandra_Bhushan_Agarwal · April 26, 2014, 8:17am

hi i am getting the below error can anyone guide me ?

Could not run ‘DynamicSqlForLikeStatement’.

com.wm.app.b2b.server.ServiceException: [ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service Wiki_Track_Activity.services:DynamicSqlForLikeStatement.
[ADA.1.316] Cannot execute the SQL statement “select * from ESBCONFIG.PROD_WIKI as wiki where wiki.UNIQUEID COLLATE UTF8_GENERAL_CI like’%2%’ and wiki. MODULE COLLATE UTF8_GENERAL_CI like’%1%’ or wiki.DESCRIPTION COLLATE UTF8_GENERAL_CI like’%%’ or wiki.RESOLUTION COLLATE UTF8_GENERAL_CI like ‘%%’”. "
(42000/933) ORA-00933: SQL command not properly ended
"
ORA-00933: SQL command not properly ended

Mahesh_K_Sreenivas · April 26, 2014, 12:19pm

Please re-check your SQL query statement. I see its a select statement

Just an idea - Try executing the same statement on TOAD or SQL developer see if it fetches you some results.

Topic		Replies	Views
PSFT Adapter errors upon BSFN execute webMethods , Integration-Server-and-ESB , Adapters-and-E-Standards	11	3048	April 2, 2021
JDE adapter Issue. webMethods , Integration-Server-and-ESB , Adapters-and-E-Standards	4	2374	April 2, 2021
JDBC adapter and OracleCursor problem webMethods , Integration-Server-and-ESB , Adapters-and-E-Standards	9	4975	April 2, 2021
EnterPriseOne Adapter 8.0 unble to invoke adapter service webMethods , Integration-Server-and-ESB , Adapters-and-E-Standards	1	1742	April 2, 2021
Adapter usage webMethods , Integration-Server-and-ESB , Flow-and-Java-services	10	1687	April 2, 2021

EnterPriseOne Adapter 8.0 unble to invoke adapter service

Related topics