MQSeries.net :: View topic - 7.0.0.2 SapAdapter Null Pointers

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » 7.0.0.2 SapAdapter Null Pointers

7.0.0.2 SapAdapter Null Pointers

« View previous topic :: View next topic »

Author

Message

smdavies99

Posted: Fri Jan 07, 2011 5:10 am Post subject: 7.0.0.2 SapAdapter Null Pointers

Jedi Council

Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.

Here is the ExceptionList received from a call to SAP/R3 on a flow that has been migrated from 6.1.0.7

Code:

<RecoverableException>
<File>F:\build\S700_P\src\DataFlowEngine\ImbComputeNode.cpp</File>
<Line>489</Line>
<Function>ImbComputeNode::evaluate</Function>
<Type>ComIbmComputeNode</Type>
<Name>ZS_GetList/ZSSAP_GetList#FCMComposite_1_2.ZS_GetList/ZSSAP_GetList_getList#FCMComposite_1_5</Name>
<Label>ZS_GetList.ZSSAP_GetList.ZSSAP_GetList_getList.throwException</Label>
<Catalog>BIPmsgs</Catalog>
<Severity>3</Severity>
<Number>2230</Number>
<Text>Caught exception and rethrowing</Text>
<RecoverableException>
<File>F:\build\S700_P\src\DataFlowEngine\ImbRdl\ImbRdlStatementGroup.cpp</File>
<Line>641</Line>
<Function>SqlStatementGroup::execute</Function>
<Type>ComIbmComputeNode</Type>
<Name>ZS_GetList/ZSSAP_GetList#FCMComposite_1_2.ZS_GetList/ZSSAP_GetList_getWorkList#FCMComposite_1_5</Name>
<Label>ZS_GetList.ZSSAP_GetList.ZSSAP_GetList_getList.throwException</Label>
<Catalog>BIPmsgs</Catalog>
<Severity>3</Severity>
<Number>2488</Number>
<Text>Error detected, rethrowing</Text>
<Insert>
<Type>5</Type>
<Text>ZS_GetList.ZSSAP_GetList_getList_throwException.Main</Text>
</Insert>
<Insert>
<Type>5</Type>
<Text>8.3</Text>
</Insert>
<Insert>
<Type>5</Type>
<Text>THROW EXCEPTION VALUES( 'ERR-20031', 'FAILED:There was an error in retrieving the WorkListDetails from SAP R/3. The error message from SAP is: ' || chrExceptionMsg, 'CRITICAL');</Text>
</Insert>
<UserException>
<File>F:\build\S700_P\src\DataFlowEngine\ImbRdl\ImbRdlThrowExceptionStatements.cpp</File>
<Line>229</Line>
<Function>SqlThrowExceptionStatement::execute</Function>
<Type>ComIbmComputeNode</Type>
<Name>ZS_GetList/ZSSAP_GetList#FCMComposite_1_2.ZS_GetList/ZSSAP_GetList_getList#FCMComposite_1_5</Name>
<Label>ZS_GetList.ZSSAP_GetList.ZSSAP_GetList_getList.throwException</Label>
<Catalog>BIPmsgs</Catalog>
<Severity>1</Severity>
<Number>2951</Number>
<Text>User generated exception</Text>
<Insert>
<Type>5</Type>
<Text>ERR-20031</Text>
</Insert>
<Insert>
<Type>5</Type>
<Text>FAILED:There was an error in retrieving the WorkListDetails from SAP R/3. The error message from SAP is: throw a RecordNotFoundException | com.ibm.j2ca.sap.exception.SapBAPIException: Error: JCO.CreateFunction(ZCUSTOMERS_LIST) returned null,please verify BO ASI com.ibm.j2ca.sap.exception.SapBaseException: Error: JCO.CreateFunction(ZCUSTOMERS_LIST) returned null,please verify BO ASI
at com.ibm.j2ca.sap.exception.SapBaseException.<init>(SapBaseException.java:56)
at com.ibm.j2ca.sap.exception.SapBAPIException.<init>(SapBAPIException.java:34)
at com.ibm.j2ca.sap.bapi.SapBAPIInvoker.invokeSimpleBAPI(SapBAPIInvoker.java:408)
at com.ibm.j2ca.sap.bapi.SapBAPIInvoker.invokeBAPI(SapBAPIInvoker.java:166)
at com.ibm.j2ca.sap.bapi.SapBAPIInvoker.execute(SapBAPIInvoker.java:565)
at com.ibm.j2ca.sap.SAPInteraction.invokeBAPI(SAPInteraction.java:915)
at com.ibm.j2ca.sap.SAPInteraction.doExecute(SAPInteraction.java:350)
at com.ibm.j2ca.base.WBIInteraction.execute(WBIInteraction.java:336)
at com.ibm.broker.adapter.deploy.MbAdapterAccess.execute(MbAdapterAccess.java:172)
at com.ibm.broker.adapter.nodes.MbAdapterRequestNode.requestData(MbAdapterRequestNode.java:534)
at com.ibm.broker.plugin.MbRequestTemplateNode.requestData(MbRequestTemplateNode.java:51)
at com.ibm.broker.plugin.MbRoute._propagate(Native Method)
at com.ibm.broker.plugin.MbRoute.propagate(MbRoute.java:87)
at com.ibm.broker.soap.SoapExtractNode.routeToOperationLabelNode(SoapExtractNode.java:386)
at com.ibm.broker.soap.SoapExtractNode.evaluate(SoapExtractNode.java:176)
at com.ibm.broker.plugin.MbNode.evaluate(MbNode.java:1469)
Caused by: java.lang.Exception: Error: JCO.CreateFunction(ZCUSTOMERS_LIST) returned null,please verify BO ASI
... 16 more

Error: JCO.CreateFunction(ZCUSTOMERS_LIST) returned null,please verify BO ASI com.ibm.j2ca.sap.exception.SapBaseException: Error: JCO.CreateFunction(ZCUSTOMERS_LIST) returned null,please verify BO ASI
at com.ibm.j2ca.sap.exception.SapBaseException.<init>(SapBaseException.java:56)
at com.ibm.j2ca.sap.exception.SapBAPIException.<init>(SapBAPIException.java:34)
at com.ibm.j2ca.sap.bapi.SapBAPIInvoker.invokeSimpleBAPI(SapBAPIInvoker.java:408)
at com.ibm.j2ca.sap.bapi.SapBAPIInvoker.invokeBAPI(SapBAPIInvoker.java:166)
at com.ibm.j2ca.sap.bapi.SapBAPIInvoker.execute(SapBAPIInvoker.java:565)
at com.ibm.j2ca.sap.SAPInteraction.invokeBAPI(SAPInteraction.java:915)
at com.ibm.j2ca.sap.SAPInteraction.doExecute(SAPInteraction.java:350)
at com.ibm.j2ca.base.WBIInteraction.execute(WBIInteraction.java:336)
at com.ibm.broker.adapter.deploy.MbAdapterAccess.execute(MbAdapterAccess.java:172)
at com.ibm.broker.adapter.nodes.MbAdapterRequestNode.requestData(MbAdapterRequestNode.java:534)
at com.ibm.broker.plugin.MbRequestTemplateNode.requestData(MbRequestTemplateNode.java:51)
at com.ibm.broker.plugin.MbRoute._propagate(Native Method)
at com.ibm.broker.plugin.MbRoute.propagate(MbRoute.java:87)
at com.ibm.broker.soap.SoapExtractNode.routeToOperationLabelNode(SoapExtractNode.java:386)
at com.ibm.broker.soap.SoapExtractNode.evaluate(SoapExtractNode.java:176)
at com.ibm.broker.plugin.MbNode.evaluate(MbNode.java:1469)
Caused by: java.lang.Exception: Error: JCO.CreateFunction(ZCUSTOMERS_LIST) returned null,please verify BO ASI
... 16 more</Text>
</Insert>
<Insert>
<Type>5</Type>
<Text>CRITICAL</Text>
</Insert>
</UserException>
</RecoverableException>
</RecoverableException>

I get pretty well much the same response from R3 using 6.1.0.7 but without the Null Pointers.
Has anyone else experienced the same sort of thing in their migration work.
Currently the runtime is on Windows but the target at the end of the day is Solaris.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995

Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions.

fatherjack

Posted: Fri Jan 07, 2011 5:33 am Post subject: Re: 7.0.0.2 SapAdapter Null Pointers

Knight

Joined: 14 Apr 2010
Posts: 522
Location: Craggy Island

smdavies99 wrote:

Has anyone else experienced the same sort of thing in their migration work.

Yes. Pretty well all my messge flows that throw an exception in 6.1.0.7 still throw an exception after being migrated.

Can you clarify what you are asking?
_________________
Never let the facts get in the way of a good theory.

smdavies99

Posted: Fri Jan 07, 2011 5:41 am Post subject:

Jedi Council

Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.

Exceptions are ok. It's the raft of Null Pointers Exceptions that I'm not too keen on. These could mask the real cause of the problem.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995

Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions.

fatherjack

Posted: Fri Jan 07, 2011 5:49 am Post subject:

Knight

Joined: 14 Apr 2010
Posts: 522
Location: Craggy Island

smdavies99 wrote:

It's the raft of Null Pointers

Ah! Sorry missed this

Quote:

... 16 more

But even so, the error's pretty clear and surely the fact that the SAP call has returned null is actually quite important.
_________________
Never let the facts get in the way of a good theory.

smdavies99

Posted: Fri Jan 07, 2011 9:29 am Post subject:

Jedi Council

Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.

Quote:

But even so, the error's pretty clear and surely the fact that the SAP call has returned null is actually quite important.

Exactly. Whereas 6.1 didn't throw its toys out of the pram when getting this error 7.0.0.2 does. I consider reporting Null pointer exceptions very bad form 'what'!

When calling the Bapi correctly in V7 it returns the right results. It's just that the error response leaves a lot to be desired.

sigh.
Oh well, it's Friday, it's gove 5pm and (no its not time for Crackerjack) it's time to head to the pub. {darn. There goes the new years resolution already}
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995

Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions.

mqjeff

Posted: Fri Jan 07, 2011 9:32 am Post subject:

Grand Master

Joined: 25 Jun 2008
Posts: 17447

smdavies99 wrote:

Oh well, it's Friday, it's gove 5pm and (no its not time for Crackerjack) it's time to head to the pub. {darn. There goes the new years resolution already}

Don't forget a nice cup of tea.

Vitor

Posted: Fri Jan 07, 2011 9:56 am Post subject:

Grand High Poobah

Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA

mqjeff wrote:

smdavies99 wrote:

Oh well, it's Friday, it's gove 5pm and (no its not time for Crackerjack) it's time to head to the pub. {darn. There goes the new years resolution already}

Don't forget a nice cup of tea.

"Now for the nice cup of tea"
"Is this part of the ordeal?"
"Part of the ordeal for us...."
_________________
Honesty is the best policy.
Insanity is the best defence.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » 7.0.0.2 SapAdapter Null Pointers

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP