| Author |
Message
|
| artykito |
 Posted: Fri Jul 02, 2010 3:05 am Post subject: Error with SAPRequest node in WMBv7 |
 |
|
Apprentice
Joined: 24 Jun 2010
Posts: 33
|
Hi all,
I have a problem with this node and/or the SAP Adapter in WMBv7. I've configured the data conexion and the Adapter in order to download a RFC structure. I could downloaded it sucessfully, so I think the conection data are right, but I have a warning in the Adapter proyect (CWYAP_SAPAdapter_TX/build/classes/META-INF/discovery-service.xml and another too in CWYAP_SAPAdapter_TX/build/connectorModule/META-INF/discovery-service.xml) and it says in both cases:
| Quote: |
| No grammar constraints (DTD or XML schema) detected for the document. |
Don't know if this has a relationship with my real problem. Well, my flow is composed by:
File Input > Compute node > SAPRequest > MQOutput
And when I stay in Debug mode and I execute the flow, when it arrives to SAPRequest node, it produces an error and tells me:
| Quote: |
Source not Found.
With a button below wich says: Edit Source Lookup Path |
I thought this problem is because the .bar doesn't have included all the elements required or the Project References are wrong. I've check all of this and it's all fine:
- .bar has the flow+2 messageSet [RFC and for parser the FileInput]+SAPAdapter
- Project references:
· Flow to: Adapter + mSet + RFC mSet
· RFC to: Adapter
· mSet to: none
· Adapter to: RFC mSet
So, I really don't know what is happening. This is the tree I can see in the Variables view in Debug mode. I don't know if it's useful, but here is it:
| Quote: |
this SAPRequestNode (id=1804)
adapterComponent "contact admin.outadapter" (id=1918)
count 35
allowTerminalCreation false
defaultMethod "contact admin" (id=1968)
count 28
dynamicTerminalsGot false
flowName "contact admin" (id=1640)
count 13
handle_ 64189192
inputTerminals_ Hashtable<K,V> (id=1425)
elementCount 0
messageSetProperty "contact admin" (id=2032)
count 13
methodLocation "$LocalEnvironment/Adapter/MethodName" (id=1570)
count 36
methodQuery MbQueryUpdate (id=1902)
handle 231601008
name_ "contact admin#FCMComposite_1_5" (id=1768)
count 30
nodeInterface null
nodeName "SAP Request" (id=2646)
count 11
outputTerminals_ Hashtable<K,V> (id=1438)
elementCount 0
secondaryAdapterMode MbAdapterNode$SECONDARY_ADAPTER_TYPES (id=1845)
name "NONE" (id=2038)
count 4
session MbOutboundSession (id=2593)
adapter MbOutboundAdapter (id=1641)
adapterName "contact admin.IBM WebSphere Adapter for SAP Software with transaction support" (id=2462)
count 84
hashCode 0
offset 0
value char[84] (id=1442)
transactionMode MbAdapterRequestNode$TRANSACTION_TYPES (id=1576)
name "AUTOMATIC" (id=1488)
count 9
arg0 MbAdapterRequestContext (id=1648)
access null
arg1 MbMessageAssembly (id=1653)
exceptionList MbMessage (id=1701)
exceptionList MbMessage (id=1701)
cleared false
handle_ 155712388
inputContextHandle_ 0
mustFinalize false
readOnly false
globalEnvironment MbMessage (id=1692)
cleared false
handle_ 155712140
inputContextHandle_ 0
mustFinalize false
readOnly false
handle_ 155702352
localEnvironment MbMessage (id=1683)
cleared false
message MbMessage (id=1664)
cleared false
readOnlyMbMessages true
|
Please, let me know if do you know what could be the problem!
Thanks in advance. |
|
| Back to top |
|
 |
| artykito |
| Posted: Sun Jul 04, 2010 11:59 pm Post subject: |
|
|
Apprentice
Joined: 24 Jun 2010
Posts: 33
|
Hey guys, don't you know what is the problem? I'm still stucked...  |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Mon Jul 05, 2010 1:10 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
It is a holiday weekend in the US (4th July) and many US Companies are not working today. That may well mean that some of the experts who normally peruse this forum are on the beach, having a beer or just plain chilling out.
Also, there may not be that many readers who are using V7 & SAP yet. I know we aren't even planning to do a POC on this (we use R3 & CRM heavily) until towards the end of the year.
_________________
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. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Mon Jul 05, 2010 5:41 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
I don't know what the error about "no grammar constraints found" means. You should look it up by BIP number if it has one.
The message about source means that the debugger can't find your source code, and it's not got to do with your bar file. You need to configure the debug session to know about the projects in your workspace. |
|
| Back to top |
|
|
| artykito |
| Posted: Mon Jul 05, 2010 10:47 pm Post subject: |
|
|
Apprentice
Joined: 24 Jun 2010
Posts: 33
|
The error in the adapter don't have a BIP number because is a warning. Only the errors has this number, right?
About the source error, I know this error because I saw it before when you forget to include the msgSet for example, but in this case, as I said the flow project is included in the debug configuration and in v7 when you include the flow, the referenced projects are included too. So, I have the flow project, the msgSet project, the RFC msgSet project and the adapter project...
Then, when it says that source is needed, I can't understand it, because all projects are included. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Tue Jul 06, 2010 2:15 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20768
Location: LI,NY
|
| artykito wrote: |
The error in the adapter don't have a BIP number because is a warning. Only the errors has this number, right?
About the source error, I know this error because I saw it before when you forget to include the msgSet for example, but in this case, as I said the flow project is included in the debug configuration and in v7 when you include the flow, the referenced projects are included too. So, I have the flow project, the msgSet project, the RFC msgSet project and the adapter project...
Then, when it says that source is needed, I can't understand it, because all projects are included. |
Well some sources are confidential, like say the SAP Adapter... 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| artykito |
| Posted: Mon Jul 12, 2010 11:40 pm Post subject: |
|
|
Apprentice
Joined: 24 Jun 2010
Posts: 33
|
This is the Exception List catched by a trace node located in the Failure terminal for the SAP Request node:
| Quote: |
( ['MQROOT' : 0x9a6eb78]
(0x01000000:Name):RecoverableException = (
(0x03000000:NameValue):File = 'F:\build\S000_P\src\DataFlowEngine\ImbDataFlowNode.cpp' (CHARACTER)
(0x03000000:NameValue):Line = 1073 (INTEGER)
(0x03000000:NameValue):Function = 'ImbDataFlowNode::createExceptionList' (CHARACTER)
(0x03000000:NameValue):Type = 'ComIbmSAPRequestNode' (CHARACTER)
(0x03000000:NameValue):Name = 'contact admin#FCMComposite_1_9' (CHARACTER)
(0x03000000:NameValue):Label = 'contact admin.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 = 94 (INTEGER)
(0x03000000:NameValue):Function = 'requestData' (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 = 3522 (INTEGER)
(0x03000000:NameValue):Text = 'wrap eis jar libraires not found exceptions' (CHARACTER)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = 'com.sap.conn.jco.JCoRecord' (CHARACTER)
)
)
)
) |
I don't know exactly what is the error, but the .jar and .dll are located in a local folder on my computer, and both files are working in other computer... What is going wrong? |
|
| Back to top |
|
|
| rekarm01 |
| Posted: Tue Jul 13, 2010 12:27 am Post subject: Re: Error with SAPRequest node in WMBv7 |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 1415
|
| artykito wrote: |
This is the Exception List catched by a trace node located in the Failure terminal for the SAP Request node:
| Quote: |
(0x03000000:NameValue):Number = 3522 (INTEGER)
(0x03000000:NameValue):Text = 'wrap eis jar libraires not found exceptions' (CHARACTER)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = 'com.sap.conn.jco.JCoRecord' (CHARACTER)
) |
|
Search the Diagnostics messages list for BIP3522, either from the toolkit help, or online:
| Quote: |
BIP3522
The adapter was unable to locate a required Java library.
Severity
20 : Error
Explanation
The most likely cause of this exception is that the client libraries for the Enterprise Information System (EIS) are missing from the system. The EIS client libraries are not supplied with the message broker product and have to be obtained separately from the EIS provider. If the EIS client libraries have been installed and the broker has been configured to use them then make sure they have the correct permissions and that configurable service points to the correct location. The missing resource which caused this problem was: com.sap.conn.jco.JCoRecord. If the problem persists then it might be due to an internal problem with the product.
Response
Obtain the missing client libraries from the EIS vendor and configure the broker to have access to these files using mqsichangeproperties command. If you are using SAP then ensure you have JCO3 and not JCO2. Consult the documentation for the exact details (topic an09140). If this is not the cause of the missing class exception then contact IBM support. |
|
|
| Back to top |
|
|
| artykito |
| Posted: Tue Jul 13, 2010 1:20 am Post subject: |
|
|
Apprentice
Joined: 24 Jun 2010
Posts: 33
|
Thank you very much mate!
I was checking the topic an09140, and I found this:
| Quote: |
Make the JAR files and shared libraries available to the WebSphere Adapter for SAP:
mqsichangeproperties WBRK_BROKER -c EISProviders -o SAP -n jarsURL,nativeLibs -v c:\sapjco\jars,c:\sapjco\bin |
After that, I restart the broker in console and it works! |
|
| Back to top |
|
|
| Gaya3 |
| Posted: Tue Jul 13, 2010 5:33 am Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
| artykito wrote: |
Thank you very much mate!
I was checking the topic an09140, and I found this:
| Quote: |
Make the JAR files and shared libraries available to the WebSphere Adapter for SAP:
mqsichangeproperties WBRK_BROKER -c EISProviders -o SAP -n jarsURL,nativeLibs -v c:\sapjco\jars,c:\sapjco\bin |
After that, I restart the broker in console and it works! |
these are the basics of adapter configuration..... 
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
|
|
