| Author |
Message
|
| cherruti |
 Posted: Wed Aug 21, 2013 9:04 am Post subject: Help SAP QISS WMB 8 |
 |
|
Newbie
Joined: 07 Feb 2013
Posts: 5
|
Hello
I'm trying to make a query to SAP tables using QISS interface but is generating the following error:
ExceptionList
RecoverableException
File: CHARACTER :/ build/slot1/S800_P/src/DataFlowEngine/ImbDataFlowNode.cpp
Line: INTEGER: 1154
Function: CHARACTER: ImbDataFlowNode :: createExceptionList
Type: CHARACTER: ComIbmSAPRequestNode
Name: CHARACTER: SAMPLE_QISS # FCMComposite_1_1
Label: CHARACTER: SAMPLE_QISS.SAP Request
Catalog: CHARACTER: BIPmsgs
Severity: INTEGER: 3
Number: INTEGER: 2230
Text: CHARACTER: Node throwing exception
RecoverableException
File: CHARACTER: MbErrorHandler.java
Line: INTEGER: 154
Function: CHARACTER: RequestData
Type: CHARACTER:
Name: CHARACTER:
Label: CHARACTER:
Catalog: CHARACTER: BIPmsgs
Severity: INTEGER: 3
Number: INTEGER: 3442
Text: CHARACTER: Caught Throwable
Insert
Type: INTEGER: 5
Text: CHARACTER: SAP Request
Insert
Type: INTEGER: 5
Text: CHARACTER: ZTM008.outadapter
RecoverableException
File: CHARACTER: MbErrorHandler.java
Line: INTEGER: 154
Function: CHARACTER: execute
Type: CHARACTER:
Name: CHARACTER:
Label: CHARACTER:
Catalog: CHARACTER: BIPmsgs
Severity: INTEGER: 3
Number: INTEGER: 3450
Text: CHARACTER: throw a recoverable exception ResourceException Wrappering
Insert
Type: INTEGER: 5
Text: CHARACTER: com.ibm.j2ca.sap.exception.SapSQIException
RecoverableException
File: CHARACTER: MbErrorHandler.java
Line: INTEGER: 318
Function: CHARACTER: throwableToMbException
Type: CHARACTER:
Name: CHARACTER:
Label: CHARACTER:
Catalog: CHARACTER: BIPmsgs
Severity: INTEGER: 3
Number: INTEGER: 3450
Text: CHARACTER: throw a recoverable exception ResourceException Wrappering
Insert
Type: INTEGER: 5
Text: CHARACTER: com.ibm.j2ca.sap.exception.SapSQIException
I am using WebSphere Message Broker 8.0.0.1 |
|
| Back to top |
|
 |
| Vitor |
| Posted: Wed Aug 21, 2013 9:09 am Post subject: Re: Help SAP QISS WMB 8 |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| cherruti wrote: |
| I am using WebSphere Message Broker 8.0.0.1 |
Apply 8.0.0.2 and try again. There are a lot of fixes in that.
Also please use [ c o d e ] tags when posting output. It's a lot easier to read.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Wed Aug 21, 2013 9:10 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
SAP support is provided by WMB through SAP nodes. Directly accessing SAP or SAP datastores from WMB is not supported.
Update your toolkit and runtime to 8.0.0.2 iFix 001.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| mqjeff |
| Posted: Wed Aug 21, 2013 9:16 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
that's not the right error message. Or if it is, it's not the complete error message.
It shows that the SAPRequest node had some issue doing something, but doesn't show the part that says what.
Look in the system log for the BIP errors at the same time.
Troubleshoot based on those, not on what you see in Debugger. |
|
| Back to top |
|
|
| enrique14 |
| Posted: Wed Aug 21, 2013 9:28 am Post subject: |
|
|
Novice
Joined: 26 Mar 2010
Posts: 12
|
| They know the APAR number that solves the issue? |
|
| Back to top |
|
|
| enrique14 |
| Posted: Wed Aug 21, 2013 9:54 am Post subject: |
|
|
Novice
Joined: 26 Mar 2010
Posts: 12
|
Hello
I have the same situation, I am using the node sapRequest
which shows the log of system is as follows:
Aug 21 12:50:12 pprd028ms01 WebSphere Broker v8001[9245]: [ID 702911 user.error] (BROKER.QA.EJEMPLO1)[62]BIP2232E: Error detected whilst handling a previous error in node 'SAMPLE_QISS.Throw'. : BROKER.QA.d854ce40-3d01-0000-0080-f0b3391e4ffd: /build/slot1/S800_P/src/DataFlowEngine/ImbDataFlowNode.cpp: 950: ImbDataFlowNode::logExceptionList: ComIbmThrowNode: SAMPLE_QISS#FCMComposite_1_5
Aug 21 12:50:12 pprd028ms01 WebSphere Broker v8001[9245]: [ID 702911 user.error] (BROKER.QA.EJEMPLO1)[62]BIP2230E: Error detected whilst processing a message in node 'SAMPLE_QISS.SAP Request'. : BROKER.QA.d854ce40-3d01-0000-0080-f0b3391e4ffd: /build/slot1/S800_P/src/DataFlowEngine/ImbDataFlowNode.cpp: 1154: ImbDataFlowNode::createExceptionList: ComIbmSAPRequestNode: SAMPLE_QISS#FCMComposite_1_1
Aug 21 12:50:12 pprd028ms01 WebSphere Broker v8001[9245]: [ID 702911 user.error] (BROKER.QA.EJEMPLO1)[62]BIP3442E: An exception occurred in adapter node 'SAP Request', which is using adapter component 'ZTM008.outadapter'.. : BROKER.QA.d854ce40-3d01-0000-0080-f0b3391e4ffd: MbErrorHandler.java: 154: requestData: :
Aug 21 12:50:12 pprd028ms01 WebSphere Broker v8001[9245]: [ID 702911 user.error] (BROKER.QA.EJEMPLO1)[62]BIP3450E: An adapter error occurred during the processing of a message. The adapter error message is 'com.ibm.j2ca.sap.exception.SapSQIException'. : BROKER.QA.d854ce40-3d01-0000-0080-f0b3391e4ffd: MbErrorHandler.java: 154: execute: :
Aug 21 12:50:12 pprd028ms01 WebSphere Broker v8001[9245]: [ID 702911 user.error] (BROKER.QA.EJEMPLO1)[62]BIP3450E: An adapter error occurred during the processing of a message. The adapter error message is 'com.ibm.j2ca.sap.exception.SapSQIException '. : BROKER.QA.d854ce40-3d01-0000-0080-f0b3391e4ffd: MbErrorHandler.java: 318: throwableToMbException: :
Aug 21 12:50:12 pprd028ms01 WebSphere Broker v8001[9245]: [ID 702911 user.error] (BROKER.QA.EJEMPLO1)[62]BIP4623E: Exception condition detected by input node 'SAMPLE_QISS.Timeout Notification'. : BROKER.QA.d854ce40-3d01-0000-0080-f0b3391e4ffd: /build/slot1/S800_P/src/DataFlowEngine/TimeoutControl/ImbTimeoutNotificationNode.cpp: 1607: ImbTimeoutNotificationNode::propagateToCatch: ComIbmTimeoutNotificationNode: SAMPLE_QISS#FCMComposite_1_3 |
|
| Back to top |
|
|
| enrique14 |
| Posted: Wed Aug 21, 2013 12:00 pm Post subject: |
|
|
Novice
Joined: 26 Mar 2010
Posts: 12
|
in usertrace in broker and shows me the following:
[2013-08-21 14:23:31.957366 89 UserTrace BIP3484E: ''CWYAP4005S: The QISS interface could not create a function-template for custom function: ZTM008 Explanation=The custom function name supplied in the interaction specification does not exist in SAP. UserAction=Verify that the function exists in SAP and correct the custom function name in QISSInteractionSpec. '' ]
Do you have to make settings in SAP, so that the adapter can find the table?
Thanks |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed Aug 21, 2013 12:36 pm Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| enrique14 wrote: |
I have the same situation, I am using the node sapRequest
|
No you don't. The OP is trying to get directly to the SAP tables. Or has explained his problem badly.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| enrique14 |
| Posted: Wed Aug 21, 2013 12:49 pm Post subject: |
|
|
Novice
Joined: 26 Mar 2010
Posts: 12
|
| Vitor wrote: |
| enrique14 wrote: |
I have the same situation, I am using the node sapRequest
|
No you don't. The OP is trying to get directly to the SAP tables. Or has explained his problem badly. |
flow attempts to query SAP table through QISS interface with sap request node |
|
| Back to top |
|
|
| mqjeff |
| Posted: Wed Aug 21, 2013 12:52 pm Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| Vitor wrote: |
| enrique14 wrote: |
I have the same situation, I am using the node sapRequest
|
No you don't. The OP is trying to get directly to the SAP tables. Or has explained his problem badly. |
You read the exception list wrong
| Quote: |
| Type: CHARACTER: ComIbmSAPRequestNode |
|
|
| Back to top |
|
|
| enrique14 |
| Posted: Wed Aug 21, 2013 1:19 pm Post subject: |
|
|
Novice
Joined: 26 Mar 2010
Posts: 12
|
| mqjeff wrote: |
| Vitor wrote: |
| enrique14 wrote: |
I have the same situation, I am using the node sapRequest
|
No you don't. The OP is trying to get directly to the SAP tables. Or has explained his problem badly. |
You read the exception list wrong
| Quote: |
| Type: CHARACTER: ComIbmSAPRequestNode |
|
The only description you get the adapter in SapRequest node is:
| Quote: |
| The adapter error message is 'com.ibm.j2ca.sap.exception.SapSQIException' |
but the user trace shows the following:
| Quote: |
| 2013-08-21 14:23:31.957366 89 UserTrace BIP3484E: ''CWYAP4005S: The QISS interface could not create a function-template for custom function: ZTM008 Explanation=The custom function name supplied in the interaction specification does not exist in SAP. UserAction=Verify that the function exists in SAP and correct the custom function name in QISSInteractionSpec. '' |
may be happening? |
|
| Back to top |
|
|
| enrique14 |
| Posted: Fri Aug 23, 2013 11:12 am Post subject: |
|
|
Novice
Joined: 26 Mar 2010
Posts: 12
|
hello all
in the compute node i change the code to SAP invocation as follows:
| Code: |
SET OutputRoot.DataObject.ns: SapZtm008.SapZtm008Querybo.sapMaxRows = 2;
SET OutputRoot.DataObject.ns: SapZtm008.SapZtm008Querybo.sapRowsSkip = 0;
SET OutputRoot.DataObject.ns: SapZtm008.SapZtm008Querybo.sapWhereClause = 'BNAME = /L00417808';
|
the exception that throws the adapter (SAPRequest node using QISS Interface) is:
| Quote: |
( ['MQROOT' : 0x1109dc448]
(0x01000000:Name):RecoverableException = (
(0x03000000:NameValue):File = '/build/slot1/S800_P/src/DataFlowEngine/ImbDataFlowNode.cpp' (CHARACTER)
(0x03000000:NameValue):Line = 1154 (INTEGER)
(0x03000000:NameValue):Function = 'ImbDataFlowNode::createExceptionList' (CHARACTER)
(0x03000000:NameValue):Type = 'ComIbmSAPRequestNode' (CHARACTER)
(0x03000000:NameValue):Name = 'SAMPLE_QISS#FCMComposite_1_1' (CHARACTER)
(0x03000000:NameValue):Label = 'SAMPLE_QISS.SAP Request' (CHARACTER)
(0x03000000:NameValue):Catalog = 'BIPmsgs' (CHARACTER)
(0x03000000:NameValue):Severity = 3 (INTEGER)
(0x03000000:NameValue):Number = 2230 (INTEGER)
(0x03000000:NameValue):Text = 'Node throwing exception' (CHARACTER)
(0x01000000:Name ):RecoverableException = (
(0x03000000:NameValue):File = 'MbErrorHandler.java' (CHARACTER)
(0x03000000:NameValue):Line = 154 (INTEGER)
(0x03000000:NameValue):Function = 'buildResponseMessage' (CHARACTER)
(0x03000000:NameValue):Type = '' (CHARACTER)
(0x03000000:NameValue):Name = '' (CHARACTER)
(0x03000000:NameValue):Label = '' (CHARACTER)
(0x03000000:NameValue):Catalog = 'BIPmsgs' (CHARACTER)
(0x03000000:NameValue):Severity = 3 (INTEGER)
(0x03000000:NameValue):Number = 3442 (INTEGER)
(0x03000000:NameValue):Text = 'Caught throwable' (CHARACTER)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = 'SAP Request' (CHARACTER)
)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = 'ZTM008.outadapter' (CHARACTER)
)
(0x01000000:Name ):RecoverableException = (
(0x03000000:NameValue):File = 'MbErrorHandler.java' (CHARACTER)
(0x03000000:NameValue):Line = 339 (INTEGER)
(0x03000000:NameValue):Function = 'throwableToMbException' (CHARACTER)
(0x03000000:NameValue):Type = '' (CHARACTER)
(0x03000000:NameValue):Name = '' (CHARACTER)
(0x03000000:NameValue):Label = '' (CHARACTER)
(0x03000000:NameValue):Catalog = 'BIPmsgs' (CHARACTER)
(0x03000000:NameValue):Severity = 3 (INTEGER)
(0x03000000:NameValue):Number = 3450 (INTEGER)
(0x03000000:NameValue):Text = 'Caught throwable' (CHARACTER)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = 'java.lang.NullPointerException at com.ibm.j2ca.sap.records.SAPSQIRecord.getNext(SAPSQIRecord.java:71) at com.ibm.broker.adapter.deploy.MbAdapterAccess.parseResult(MbAdapterAccess.java:198) at com.ibm.broker.adapter.nodes.MbAdapterRequestNode.buildResponseMessage(MbAdapterRequestNode.java:623) ' (CHARACTER)
)
)
)
)
)
|
means no records?
the exception is correct?
Thanks |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Fri Aug 23, 2013 11:26 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
http://publib.boulder.ibm.com/infocenter/wmbhelp/v8r0m0/index.jsp?topic=%2Fcom.ibm.etools.mft.doc%2Fac66410_.htm
| Quote: |
Outbound processing for the query interface for SAP Software
You use the Query interface for SAP Software for outbound processing only.
The message flow that makes the request uses the interface information that was generated by the Adapter Connection wizard.
The following list describes the sequence of processing actions that result from an outbound request that uses the query interface for SAP Software.
The adapter receives a request, which includes a table object, from a message flow.
The query business object can be in a container business object, or it can be received as a table business object.
The adapter determines, from the table object sent with the query, the name of the table to examine.
The adapter determines the columns to retrieve or examine.
The adapter determines the rows to retrieve or examine.
The adapter responds.
For a RetreiveAll operation, the adapter returns a result set in the form of a container of query business objects, which represent the data for each row retrieved from the table. If the query is received as a table business object (not inside a container), the rows are returned one at a time, as they are retrieved.
For the Exists operation, the adapter returns an indication of whether the data exists in the SAP table.
If no data exists, the adapter generates an exception. |
Your hypothesis seems possible. When you try a QISS query outside of WMB, do you get rows back?
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| enrique14 |
| Posted: Fri Aug 23, 2013 12:05 pm Post subject: |
|
|
Novice
Joined: 26 Mar 2010
Posts: 12
|
| lancelotlinc wrote: |
http://publib.boulder.ibm.com/infocenter/wmbhelp/v8r0m0/index.jsp?topic=%2Fcom.ibm.etools.mft.doc%2Fac66410_.htm
| Quote: |
Outbound processing for the query interface for SAP Software
You use the Query interface for SAP Software for outbound processing only.
The message flow that makes the request uses the interface information that was generated by the Adapter Connection wizard.
The following list describes the sequence of processing actions that result from an outbound request that uses the query interface for SAP Software.
The adapter receives a request, which includes a table object, from a message flow.
The query business object can be in a container business object, or it can be received as a table business object.
The adapter determines, from the table object sent with the query, the name of the table to examine.
The adapter determines the columns to retrieve or examine.
The adapter determines the rows to retrieve or examine.
The adapter responds.
For a RetreiveAll operation, the adapter returns a result set in the form of a container of query business objects, which represent the data for each row retrieved from the table. If the query is received as a table business object (not inside a container), the rows are returned one at a time, as they are retrieved.
For the Exists operation, the adapter returns an indication of whether the data exists in the SAP table.
If no data exists, the adapter generates an exception. |
Your hypothesis seems possible. When you try a QISS query outside of WMB, do you get rows back? |
thanks for your reply
I'm using the operation RetreiveAll in SAPRequest node
try with the two modes of operation (RetreiveAll and Exist ) but you get the same exception.
the result of the query returns 1 record in SAP |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Mon Aug 26, 2013 4:15 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
|
| Back to top |
|
|
|
|
