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.

Is WmOAAdapter package enabled?

Can you share the full/detailed error?

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

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

HTH,
RMG

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