NullPointerException when calling a stored procedure from a service task
(Doc ID 2043004.1)
Last updated on MAY 15, 2023
Applies to:
Oracle Business Process Management Suite - Version 12.1.3.0.0 and laterInformation in this document applies to any platform.
Symptoms
When making a stored procedure call using BPM the following exception occurs:
BINDING.JCA-11812
Interaction processing error.
Error while processing the execution of the TPSUSER.UPDATEPROCESSACTIVITY API interaction.
An error occurred while processing the interaction for invoking the TPSUSER.UPDATEPROCESSACTIVITY API. Cause: java.lang.NullPointerException
Check to ensure that the XML containing parameter data matches the parameter definitions in the XSD. This exception is considered not retriable, likely due to a modelling mistake.
...
java.lang.NullPointerException
at oracle.tip.adapter.db.sp.SPInteraction.executeStoredProcedure(SPInteraction.java:162)
at oracle.tip.adapter.db.DBInteraction.executeStoredProcedure(DBInteraction.java:1302)
at oracle.tip.adapter.db.DBInteraction.execute(DBInteraction.java:307)
at oracle.integration.platform.blocks.adapter.fw.jca.cci.JCAInteractionInvoker.executeJcaInteraction(JCAInteractionInvoker.java:417)
at oracle.integration.platform.blocks.adapter.fw.jca.cci.JCAInteractionInvoker.invokeJcaReference(JCAInteractionInvoker.java:726)
at oracle.integration.platform.blocks.adapter.fw.jca.cci.JCAInteractionInvoker.invokeAsyncJcaReference(JCAInteractionInvoker.java:691)
at oracle.integration.platform.blocks.adapter.fw.jca.cci.JCAEndpointInteraction.performAsynchronousInteraction(JCAEndpointInteraction.java:628)
at oracle.integration.platform.blocks.adapter.AdapterReference.post(AdapterReference.java:325)
at oracle.integration.platform.blocks.mesh.AsynchronousMessageHandler.doPost(AsynchronousMessageHandler.java:144)
at oracle.integration.platform.blocks.mesh.MessageRouter.post(MessageRouter.java:231)
at oracle.integration.platform.blocks.mesh.MeshImpl$3.run(MeshImpl.java:472)
at oracle.integration.platform.blocks.mesh.MeshImpl$3.run(MeshImpl.java:470)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAs(Subject.java:415)
at oracle.integration.platform.blocks.mesh.MeshImpl.doPostAsSubject(MeshImpl.java:470)
at oracle.integration.platform.blocks.mesh.MeshImpl.post(MeshImpl.java:414)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.
Interaction processing error.
Error while processing the execution of the TPSUSER.UPDATEPROCESSACTIVITY API interaction.
An error occurred while processing the interaction for invoking the TPSUSER.UPDATEPROCESSACTIVITY API. Cause: java.lang.NullPointerException
Check to ensure that the XML containing parameter data matches the parameter definitions in the XSD. This exception is considered not retriable, likely due to a modelling mistake.
...
java.lang.NullPointerException
at oracle.tip.adapter.db.sp.SPInteraction.executeStoredProcedure(SPInteraction.java:162)
at oracle.tip.adapter.db.DBInteraction.executeStoredProcedure(DBInteraction.java:1302)
at oracle.tip.adapter.db.DBInteraction.execute(DBInteraction.java:307)
at oracle.integration.platform.blocks.adapter.fw.jca.cci.JCAInteractionInvoker.executeJcaInteraction(JCAInteractionInvoker.java:417)
at oracle.integration.platform.blocks.adapter.fw.jca.cci.JCAInteractionInvoker.invokeJcaReference(JCAInteractionInvoker.java:726)
at oracle.integration.platform.blocks.adapter.fw.jca.cci.JCAInteractionInvoker.invokeAsyncJcaReference(JCAInteractionInvoker.java:691)
at oracle.integration.platform.blocks.adapter.fw.jca.cci.JCAEndpointInteraction.performAsynchronousInteraction(JCAEndpointInteraction.java:628)
at oracle.integration.platform.blocks.adapter.AdapterReference.post(AdapterReference.java:325)
at oracle.integration.platform.blocks.mesh.AsynchronousMessageHandler.doPost(AsynchronousMessageHandler.java:144)
at oracle.integration.platform.blocks.mesh.MessageRouter.post(MessageRouter.java:231)
at oracle.integration.platform.blocks.mesh.MeshImpl$3.run(MeshImpl.java:472)
at oracle.integration.platform.blocks.mesh.MeshImpl$3.run(MeshImpl.java:470)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAs(Subject.java:415)
at oracle.integration.platform.blocks.mesh.MeshImpl.doPostAsSubject(MeshImpl.java:470)
at oracle.integration.platform.blocks.mesh.MeshImpl.post(MeshImpl.java:414)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |