Oracle Apps Adapter Invokation Error

, ,
1

Hello Everyone,

Reently intalled the webMethods 9.7 version and imported all the packages and transactions from 8.2 server to 9.7 server. But while invoking the oracle apps adapter I am getting this type of error
“Error while invoking adapter service com.wm.adapter.wmoa.services.ComplexSelectOperation.
com.wm.adapter.wmoa.connection.OAConnection cannot be cast to com.wm.adapter.wmoa.connection.OAConnection”

the oracle apps version is 12.0.6

can anyone please tell me why I am getting this kind of error.

Thanks in advance.

2

Is WmOAAdapter package enabled?

Can you share the full/detailed error?

3

Error: [ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service ERPBank.util:haemoGetBankAccountData.
[ART.114.505] Error while invoking adapter service com.wm.adapter.wmoa.services.ComplexSelectOperation.
com.wm.adapter.wmoa.connection.OAConnection cannot be cast to com.wm.adapter.wmoa.connection.OAConnection
Details:
com.wm.pkg.art.error.DetailedServiceException: [ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service ERPBank.util:haemoGetBankAccountData.
[ART.114.505] Error while invoking adapter service com.wm.adapter.wmoa.services.ComplexSelectOperation.
com.wm.adapter.wmoa.connection.OAConnection cannot be cast to com.wm.adapter.wmoa.connection.OAConnection
at com.wm.pkg.art.error.DetailedServiceException.create(DetailedServiceException.java:122)
at com.wm.pkg.art.error.DetailedServiceException.create(DetailedServiceException.java:113)
at com.wm.pkg.art.error.DetailedServiceException.create(DetailedServiceException.java:100)
at com.wm.pkg.art.ns.AdapterServiceNode.invokeService(AdapterServiceNode.java:388)
at com.wm.pkg.art.ns.ARTNSService.baseInvoke(ARTNSService.java:53)
at com.wm.app.b2b.server.invoke.InvokeManager.process(InvokeManager.java:641)
at com.wm.app.b2b.server.util.tspace.ReservationProcessor.process(ReservationProcessor.java:39)
at com.wm.app.b2b.server.invoke.StatisticsProcessor.process(StatisticsProcessor.java:49)
at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java:243)
at com.wm.app.b2b.server.invoke.ValidateProcessor.process(ValidateProcessor.java:49)
at com.wm.app.b2b.server.invoke.PipelineProcessor.process(PipelineProcessor.java:171)
at com.wm.app.b2b.server.ACLManager.process(ACLManager.java:302)
at com.wm.app.b2b.server.invoke.DispatchProcessor.process(DispatchProcessor.java:34)
at com.wm.app.b2b.server.AuditLogManager.process(AuditLogManager.java:369)
at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:545)
at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:384)
at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:238)
at com.wm.app.b2b.server.BaseService.invoke(BaseService.java:205)
at com.wm.lang.flow.FlowInvoke.invoke(FlowInvoke.java:254)
at com.wm.lang.flow.FlowState.invokeNode(FlowState.java:511)
at com.wm.lang.flow.FlowState.step(FlowState.java:389)
at com.wm.lang.flow.FlowState.invoke(FlowState.java:360)
at com.wm.app.b2b.server.FlowSvcImpl.baseInvoke(FlowSvcImpl.java:1080)
at com.wm.app.b2b.server.invoke.InvokeManager.process(InvokeManager.java:641)
at com.wm.app.b2b.server.util.tspace.ReservationProcessor.process(ReservationProcessor.java:39)
at com.wm.app.b2b.server.invoke.StatisticsProcessor.process(StatisticsProcessor.java:49)
at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java:243)
at com.wm.app.b2b.server.invoke.ValidateProcessor.process(ValidateProcessor.java:49)
at com.wm.app.b2b.server.invoke.PipelineProcessor.process(PipelineProcessor.java:171)
at com.wm.app.b2b.server.ACLManager.process(ACLManager.java:302)
at com.wm.app.b2b.server.invoke.DispatchProcessor.process(DispatchProcessor.java:34)
at com.wm.app.b2b.server.AuditLogManager.process(AuditLogManager.java:369)
at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:545)
at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:384)
at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:238)
at com.wm.app.b2b.server.BaseService.invoke(BaseService.java:205)
at com.wm.lang.flow.FlowInvoke.invoke(FlowInvoke.java:254)
at com.wm.lang.flow.FlowState.invokeNode(FlowState.java:511)
at com.wm.lang.flow.FlowState.step(FlowState.java:389)
at com.wm.lang.flow.FlowState.invoke(FlowState.java:360)
at com.wm.app.b2b.server.FlowSvcImpl.baseInvoke(FlowSvcImpl.java:1080)
at com.wm.app.b2b.server.invoke.InvokeManager.process(InvokeManager.java:641)
at com.wm.app.b2b.server.util.tspace.ReservationProcessor.process(ReservationProcessor.java:39)
at com.wm.app.b2b.server.invoke.StatisticsProcessor.process(StatisticsProcessor.java:49)
at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java:243)
at com.wm.app.b2b.server.invoke.ValidateProcessor.process(ValidateProcessor.java:49)
at com.wm.app.b2b.server.invoke.PipelineProcessor.process(PipelineProcessor.java:171)
at com.wm.app.b2b.server.ACLManager.process(ACLManager.java:302)
at com.wm.app.b2b.server.invoke.DispatchProcessor.process(DispatchProcessor.java:34)
at com.wm.app.b2b.server.AuditLogManager.process(AuditLogManager.java:369)
at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:545)
at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:342)
at com.wm.app.b2b.server.dispatcher.trigger.Trigger.invokeService(Trigger.java:536)
at com.wm.app.b2b.server.dispatcher.trigger.Trigger.processMessage(Trigger.java:427)
at com.wm.app.b2b.server.dispatcher.trigger.DefaultTriggerTaskHelper.process(DefaultTriggerTaskHelper.java:253)
at com.wm.app.b2b.server.dispatcher.trigger.TriggerTask.run(TriggerTask.java:299)
at com.wm.util.pool.PooledThread.run(PooledThread.java:127)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.wm.adk.error.AdapterServiceException: [ART.114.505] Error while invoking adapter service com.wm.adapter.wmoa.services.ComplexSelectOperation.
com.wm.adapter.wmoa.connection.OAConnection cannot be cast to com.wm.adapter.wmoa.connection.OAConnection
at com.wm.adk.error.AdapterException.(AdapterException.java:427)
at com.wm.adk.cci.interaction.WmInteraction.execute(WmInteraction.java:92)
at com.wm.pkg.art.ns.AdapterServiceNode.invokeService(AdapterServiceNode.java:338)
… 54 more
Caused by: java.lang.ClassCastException: com.wm.adapter.wmoa.connection.OAConnection cannot be cast to com.wm.adapter.wmoa.connection.OAConnection
at com.wm.adapter.wmoa.services.ComplexSelectOperation.execute(ComplexSelectOperation.java:322)
at com.wm.adk.cci.interaction.WmInteraction.execute(WmInteraction.java:76)
… 55 more

4

Since the issue related to 9.7 it’s better open a SAG support ticket and followup for faster turn around.

HTH,
RMG

5

Assuming the same connection configuration worked in 8.2.2 with the OA Adapter?

Since the issue related to 9.7 it’s better open a SAG support ticket and followup for a quick turn around.

HTH,
RMG