Connectivity between BODS & SAPBW

dataservices sap-erp-bw
1

Hi,
I’m working on Data Services with BW as target.
I’ve followed the steps given in the url below :
http://wiki.sdn.sap.com/wiki/display/BOBJ/Loading+BW

I was able to run the jobs from BW & pull data via DS when DS jobserver was on windows. Now the DS jobserver is on Solaris 10, DS 3.2 (repo version is 12.2.0.0) & the job fails to get executed.

I’m able to run RfcSvr… command from command prompt of solaris & can read data from BW (SAP BW as Source); but when it comes for writing data into BW (SAPBW as Target) I was getting an error “Java Connector (JCo) not found”. I got the file downloaded & installed it in the specified folder but then also the same error continued moreover RfcSvr command stopped responding. Hence I reverted back to the originial state.

I’m able to generate the *.sh file from export exectuion command & can run the job from BW when the target is an database table. But when the target is BW objects the job fails; no log is found in the log file.

Can anyone help me to get out of this asap. I’m trying all possible methods since 2 weeks.

Thanks in advance.
Arun

hsarun28 (BOB member since 2009-12-07)

2

This is a known package issues I found myself two weeks ago.

The JCO connector is 64bit, the tomcat & Java we deploy by default is 32bit as we package the BOE one. That doesn’t work.

So you should install your own Java JDK and tomcat in another directory and during the installation of DS choose to deploy the Management Console on your tomcat, not the DS provided one.

Note: The RFC Server binary and the Management Console RFCServer are different things. The binary is available for backward compatibility only and should not be used. The Java based one has more features and different approach, e.g. no need to export-execution-command. Point is, they are not interchangeable.

Werner Daehn :de: (BOB member since 2004-12-17)