java.lang.NullPointerException

[Former Member]

Hi,

I get the following error in JDBC adapter. Any idea what the reason might be? When I change the procedure name to something that doesn't exist it gets again the same mistake. But if I for example delete the attribute of a field the error changes and says that the attribute is missing. My JDBC is working. I have an other sp which works fine. But with this I can't get any further.

com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'sp_biz' (structure 'DATA_ITEM'): java.lang.NullPointerException

<?xml version="1.0" encoding="UTF-8" ?>

<ns1:MT_SP_BIZ xmlns:ns1="http://si/si_ol">

<DATA_ITEM>

<sp_biz action="EXECUTE">

<table>sp_biz</table>

<a type="NUMERIC" isInput="true" isOutput="true">2010</a>

<b type="NUMERIC" isInput="true" isOutput="true">1</b>

<c type="NUMERIC" isInput="true" isOutput="true" />

<d type="NUMERIC" isInput="true" isOutput="true">5</d>

<e type="NUMERIC" isInput="true" isOutput="true">1</e>

<f type="NUMERIC" isInput="true" isOutput="true">5305</f>

<g type="NUMERIC" isInput="true" isOutput="true">5305</g>

<h type="NUMERIC" isInput="true" isOutput="true" />

<i type="NUMERIC" isInput="true" isOutput="true">000010</i>

<j type="NUMERIC" isInput="true" isOutput="true">082280</j>

<k type="VARCHAR" isInput="true" isOutput="true">M3</k>

<l type="NUMERIC" isInput="true" isOutput="true">0000000018000</l>

<m type="VARCHAR" isInput="true" isOutput="true">1500</m>

<n type="VARCHAR" isInput="true" isOutput="true" />

<o type="VARCHAR" />

<p type="VARCHAR">00</p>

<q type="VARCHAR" isOutput="TRUE" />

<r type="NUMERIC" isOutput="TRUE" />

<s type="NUMERIC" isOutput="TRUE" />

<t type="NUMERIC" isOutput="TRUE" />

</sp_biz>

</DATA_ITEM>

</ns1:MT_SP_BIZ>

[former_member4985 · Accepted solution]

Hello Chris,

For the NullPointer exception, check if you have all your XI/PI components in the

same SP level.

With regards,

Caio Cagnani

[Former Member · Accepted solution]

Hi,

This scenario is working for other SP's. But in this special case I get this error. Is there another way to see the detailed error? java.lang.NullPointerException explains not much...

[Former Member · Accepted solution]

Chris

You can get detailed error in NetWeaver Administrator --> Performance --> Logs & Traces & select default.

I dont have NWA open in front of me but i guess i gave you right path, you might not be having the access to NWA so ask for it from BASIS & then look for that timeframe in logs.

[madhusudana_reddy2]

If it is receiver jdbc adapter,

In advanced table, use below setting to see SQL Statement

logSQLStatement --- true. so that it iwll generate the stored procedure code. Then copy this to your database and execute in the database server.

If you will get null pointer exception means some thing you are missing to give input. Database is considering that input as null. You can not get more information while getting null pointer exception.

thanks,

madhu

[Former Member]

Hi,

When I look at the logs in NWA I see the error below:

Exception caught when executing statement for table/stored proc. 'sp_biz_order_item_check' (structure 'DATA_ITEM'):

java.lang.NullPointerException

at java.math.BigDecimal.<init>(BigDecimal.java:649)... [see details]

any idea what this means?

[Former Member]

the complete error:

Exception caught when executing statement for table/stored proc. 'sp_..._check' (structure 'DATA_ITEM'):

java.lang.NullPointerException

at java.math.BigDecimal.<init>(BigDecimal.java:649)

at com.sap.aii.adapter.jdbc.SAXHandler.registerParameter(xml2sql.java:1315)

at com.sap.aii.adapter.jdbc.SAXHandler.SQLcallStmt(xml2sql.java:1051)

at com.sap.aii.adapter.jdbc.SAXHandler.processList(xml2sql.java:812)

at com.sap.aii.adapter.jdbc.SAXHandler.endElement(xml2sql.java:691)

at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.endElement(AbstractSAXParser.java:633)

at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.scanEndElement(XMLNSDocumentScannerImpl.java:719)

at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(XMLDocumentFragmentScannerImpl.java:1685)

at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:368)

at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:834)

at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:764)

at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:148)

at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1242)

at javax.xml.parsers.SAXParser.parse(SAXParser.java:375)

at javax.xml.parsers.SAXParser.parse(SAXParser.java:176)

at com.sap.aii.adapter.jdbc.xml2sql.service(xml2sql.java:205)

at com.sap.aii.adapter.jdbc.XI2JDBC.processMessage(XI2JDBC.java:584)

at com.sap.aii.adapter.jdbc.XI2JDBC.dispatchMessage(XI2JDBC.java:249)

at com.sap.aii.adapter.jdbc.SapAdapterServiceFrameImpl.callSapAdapter(SapAdapterServiceFrameImpl.java:210)

at com.sap.aii.af.app.modules.CallAdapterWithMessageBean.process_receiver(CallAdapterWithMessageBean.java:259)

at com.sap.aii.af.app.modules.CallAdapterWithMessageBean.process(CallAdapterWithMessageBean.java:180)

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:585)

at com.sap.engine.services.ejb3.runtime.impl.RequestInvocationContext.proceedFinal(RequestInvocationContext.java:46)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:166)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_StatesTransition.invoke(Interceptors_StatesTransition.java:19)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_Resource.invoke(Interceptors_Resource.java:71)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_Transaction.doWorkWithAttribute(Interceptors_Transaction.java:38)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_Transaction.invoke(Interceptors_Transaction.java:22)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:189)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_StatelessInstanceGetter.invoke(Interceptors_StatelessInstanceGetter.java:16)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_SecurityCheck.invoke(Interceptors_SecurityCheck.java:21)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_ExceptionTracer.invoke(Interceptors_ExceptionTracer.java:16)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.DefaultInvocationChainsManager.startChain(DefaultInvocationChainsManager.java:133)

at com.sap.engine.services.ejb3.runtime.impl.DefaultEJBProxyInvocationHandler.invoke(DefaultEJBProxyInvocationHandler.java:164)

at $Proxy255.process(Unknown Source)

at com.sap.aii.af.app.mp.ejb.ModuleProcessorBean.process(ModuleProcessorBean.java:275)

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:585)

at com.sap.engine.services.ejb3.runtime.impl.RequestInvocationContext.proceedFinal(RequestInvocationContext.java:46)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:166)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_StatesTransition.invoke(Interceptors_StatesTransition.java:19)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_Resource.invoke(Interceptors_Resource.java:71)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_Transaction.doWorkWithAttribute(Interceptors_Transaction.java:38)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_Transaction.invoke(Interceptors_Transaction.java:22)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:189)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_StatelessInstanceGetter.invoke(Interceptors_StatelessInstanceGetter.java:16)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_SecurityCheck.invoke(Interceptors_SecurityCheck.java:21)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_ExceptionTracer.invoke(Interceptors_ExceptionTracer.java:16)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.DefaultInvocationChainsManager.startChain(DefaultInvocationChainsManager.java:133)

at com.sap.engine.services.ejb3.runtime.impl.DefaultEJBProxyInvocationHandler.invoke(DefaultEJBProxyInvocationHandler.java:164)

at $Proxy288.process(Unknown Source)

at com.sap.aii.af.app.listener.AFWListenerBean.onMessage(AFWListenerBean.java:332)

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:585)

at com.sap.engine.services.ejb3.runtime.impl.RequestInvocationContext.proceedFinal(RequestInvocationContext.java:46)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:166)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_StatesTransition.invoke(Interceptors_StatesTransition.java:19)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_Resource.invoke(Interceptors_Resource.java:71)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_Transaction.doWorkWithAttribute(Interceptors_Transaction.java:38)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_Transaction.invoke(Interceptors_Transaction.java:22)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:189)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_StatelessInstanceGetter.invoke(Interceptors_StatelessInstanceGetter.java:16)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_SecurityCheck.invoke(Interceptors_SecurityCheck.java:21)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_ExceptionTracer.invoke(Interceptors_ExceptionTracer.java:16)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.DefaultInvocationChainsManager.startChain(DefaultInvocationChainsManager.java:133)

at com.sap.engine.services.ejb3.runtime.impl.DefaultEJBProxyInvocationHandler.invoke(DefaultEJBProxyInvocationHandler.java:164)

at $Proxy327.onMessage(Unknown Source)

at com.sap.engine.messaging.impl.spi.ServicesImpl.deliver(ServicesImpl.java:326)

at com.sap.aii.adapter.xi.ms.XIEventHandler.onDeliver(XIEventHandler.java:1127)

at com.sap.engine.messaging.impl.core.queue.consumer.RequestConsumer.onMessage(RequestConsumer.java:73)

at com.sap.engine.messaging.impl.core.queue.Queue.run(Queue.java:921)

at com.sap.engine.messaging.runtime.MSWorkWrapper.run(MSWorkWrapper.java:56)

at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37)

at java.security.AccessController.doPrivileged(Native Method)

at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:169)

at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:266)

[Former Member]

Any ideas?

[Former Member]

Hi

Your Target Strucutre is not correct!!

DB format should start with statementname.

http://help.sap.com/saphelp_nw70/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

Regards

Ramg

[Former Member]

Hi,

Any help?

com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'sp_pi_order_item_check' (structure 'DATA_TEIL'): java.lang.NullPointerException

I cant go any further. I call a stored procedure with no output values and get this error.

[Former Member]

no matter what stored procedure name I write into table tag, the error is the same. I think its like something the JDBC driver cant parse and it doesn't even sent it to the DB. right?