| Author |
Message
|
| matuwe |
 Posted: Tue Jul 17, 2012 11:44 pm Post subject: SAP Input Adapter on Broker 8 |
 |
|
Master
Joined: 05 Dec 2007
Posts: 296
|
HI
Has anyone used SAP Adapter on broker 8. It is looking for sapjco3 files. I have sapjco without the 3. Is the 3 a version on SAP. The wizard is also looking for sapjco3.dll or libsapjco3.so whic I cannot find and my SAP administrator can find them too. Where can I locate these files.
Please help, I need to create a SAP Input.
Thanks
 |
|
| Back to top |
|
 |
| smdavies99 |
| Posted: Wed Jul 18, 2012 12:57 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
The SAP dll's are available for download from the SAP website. You need to have an account to get at them thus your SAP admin people should be able to find them for you.
_________________
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 |
|
|
| matuwe |
| Posted: Wed Jul 18, 2012 6:19 am Post subject: |
|
|
Master
Joined: 05 Dec 2007
Posts: 296
|
Thanks a million I managed to find them.
One more question, If I am building a SAPInput flow , how come it is asking me for SAP details? I thought it would be like SOAP or HTTP where I provide SAP with my connection details if they need to poll information from message broker. Is there any physical connection between SAP and Broker? if so how would I manage deployments if data is hardcoded on the Adapter? |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Wed Jul 18, 2012 9:50 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
In a webservice you can (if the target permits it) retrieve the WSDL so that you can set your end up knowing that you won't get problems with the contract between the two ends.
In a SAP Environment, you perform a behind the scenes login to SAP to retrieve the bapi etc which is used to define a message set in Broker so that you can format your data properly.
The hard part is finding the right bapi to configure against.
you will find that SAP is very unforgiving. It can also lie to you. When it says 'I'm done' with an update, it isn't. Another Async process in the background actually will do the updating fo the database.
_________________
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 |
|
|
| fjb_saper |
| Posted: Wed Jul 18, 2012 8:36 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| smdavies99 wrote: |
you will find that SAP is very unforgiving. It can also lie to you. When it says 'I'm done' with an update, it isn't. Another Async process in the background actually will do the updating fo the database. |
Well this needs precision and comment....
SAP actually has 3 levels of updates
- Transaction data
- statistics level 1
- statistics level 2
When SAP releases the thread the transaction data has been updated.
Statistics level 1 and level 2 are then asynchronous threads that happen in the background and update according to the order of the events on the queues...
This is why when you change the way statistics behave you can run into the paradox that the main transaction is committed and you are unable to get the statistics to commit. Stuff piles up (SM13)...
Normal procedure is to have this all fleshed out in dev/qa...
Have fun 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Wed Jul 18, 2012 10:26 pm Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
If your BAPI code calls another BAPI to do the updating then you will see the behaviour I describe (at least in R3 & CRM).
A typical situation is that you have a main sales-order process and a whole bunch of processes feeding it. I found that there was often a queue of 'jobs' for the Sales Order process yet the things calling it told their callers that they were done and dusted.
Hence my statement, 'SAP Lies' or at very least is 'uneconomical with the truth'.
_________________
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 |
|
|
| mb01mqbrkrs |
| Posted: Wed Jul 18, 2012 10:37 pm Post subject: |
|
|
Apprentice
Joined: 18 Nov 2011
Posts: 48
|
| smdavies99 wrote: |
| If your BAPI code calls another BAPI to do the updating then you will see the behaviour I describe (at least in R3 & CRM). |
Confirmed in ECC6 also. I notice that WMB8 has a option on the adapter - "wait until commit call to SAP database is completed and returned". Not sure if this was in V7 (upgrading from 6.1 to 8) Hopefully, that may do something to fix the issue in the future.
The other really fun thing about SAP is when it decides to run an old version of a function, rather than the newly promoted one. Hilarity ensues. |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Wed Jul 18, 2012 11:16 pm Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
| mb01mqbrkrs wrote: |
| Hilarity ensues. |
don't you mean much cursing in German and sticking pins into a SAP Doll?
_________________
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 |
|
|
| matuwe |
| Posted: Mon Jul 30, 2012 3:20 am Post subject: |
|
|
Master
Joined: 05 Dec 2007
Posts: 296
|
HI
I managed to connect to SAP. And got some error when trying to Select RFC from the list I got UnAthorised. THe SAP Administrator gave my user SAP ALL Access to get it to work. Now I can see a list of RFC but the one that has been created for me is not on the list.
Is there any specific way it should be created on the SAP side? If I am developing a SAP Input how does SAP Connect to me? Do I give them host name port or URL?
My interface is SAP needs to call message broker >> retrieve data from some DB >> return data to SAP.
Thanks  |
|
| Back to top |
|
|
| marko.pitkanen |
| Posted: Mon Jul 30, 2012 3:51 am Post subject: |
|
|
Chevalier
Joined: 23 Jul 2008
Posts: 440
Location: Jamsa, Finland
|
Hi matuwe,
Have you read what InfoCenter says?
| Code: |
RfcProgramID
The remote function call identifier under which the adapter registers in the SAP gateway. This property applies only to .inadapter files.
The value of this property must match the RFC Program ID that is registered in SAP (transaction SM59).
The default value is an empty string, which indicates that behavior is controlled by the .inadapter file.
|
--
Marko |
|
| Back to top |
|
|
| matuwe |
| Posted: Mon Jul 30, 2012 4:34 am Post subject: |
|
|
Master
Joined: 05 Dec 2007
Posts: 296
|
Hi
Thanks Marko... I also saw that . I cannot find that file... too I am not sure if it is difference in version or what.. I am using broker 8 with SAP JCO 3. Could this be the difference.. I am trying to attach two pictures, one from the samples and another from my new connection, Is there anyway I can attach the file/s . Currently I am still stuck on the wizard .
[/img] |
|
| Back to top |
|
|
| marko.pitkanen |
| Posted: Mon Jul 30, 2012 5:40 am Post subject: |
|
|
Chevalier
Joined: 23 Jul 2008
Posts: 440
Location: Jamsa, Finland
|
|
| Back to top |
|
|
| matuwe |
| Posted: Mon Jul 30, 2012 5:42 am Post subject: |
|
|
Master
Joined: 05 Dec 2007
Posts: 296
|
Okay now I find this a bit weird... The Wizard takes me from the SAP detail screen, then according to the Sample Docs, I need to specify if it is a Inbound or OutBound but I am not getting that screen. Is this new in version 8?  |
|
| Back to top |
|
|
| matuwe |
| Posted: Tue Jul 31, 2012 3:02 am Post subject: |
|
|
Master
Joined: 05 Dec 2007
Posts: 296
|
I am making progress I think  .
If I use the File >> New >> Adapter Connection, then I got the screen which allows me to select inbound or outbound. Then entered the required info. The RFC still doesn't show on the list. I select one of on the list and managed to proceed foward.
This then allowed me to enter "RFC PROGRAME ID" and successfully created my adapter. I am hoping that all is well, still a little worried about selecting any RFC from the initial list .
My broker configarable service is all set up and ready. Is the next step asking the SAP developer to call the RFC from his side? Is there any information I need to provide him with? Server or port? Or does the adapter makes a direct inbound link between SAP and message broker. Thanks |
|
| Back to top |
|
|
| matuwe |
| Posted: Tue Jul 31, 2012 3:36 am Post subject: |
|
|
Master
Joined: 05 Dec 2007
Posts: 296
|
Hi
I am now tryng to deploy my flow to the broker... I have set the broker properties to point to the right place and restarted the broker
| Code: |
VM# mqsireportproperties MyBROKER -c EISProviders -o SAP -r
EISProviders
SAP
jarsURL='/home/wbiadmin/sapjco'
nativeLibs='/home/wbiadmin/sapjco'
|
Now this is the error I am getting, Could it mean I have downloaded the wrong LIBS?
An adapter error occurred during the processing of a message. The adapter error message is 'Error getting the version of the native layer: java.lang.UnsatisfiedLinkError: sapjco3 (/home/wbiadmin/sapjco/libsapjco3.so: wrong ELF class: ELFCLASS64) '. : MyBROKER .a06eb9dc-3801-0000-0080-97901b62f020: MbErrorHandler.java: 310: throwableToMbException: : |
|
| Back to top |
|
|
|
|
