EnterPriseOne Adapter 8.0 unble to invoke adapter service

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

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

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)

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.

Thanks. You recommendation did work.

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

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

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.