Data Services 4: Can't create a Data Source for it in BW 7.3

dataservices sap-erp-bw
1

I’ve got a DS4.0 system connected to SAP BW 7.3 SP02. RFC Server on DS is up and running, and connectivity seems to be OK in SM59 on BW side.

I tried to create a BW Data Source for Data Services. When it came to entering something into “Source Object” field, I tried to use “Browse All Objects” (second button), then tried to expand the Root Node, and got this error:

Browse has system error: org.apache.axis2.AxisFault: com.ctc.wstx.exc.WstxEOFException: Unexpected EOF in prolog## at [row,col {unknown-source}]: [1,0]

The other thing I tried was to enter at least something in the format datastore.owner.table which was apparently required, and proceed to “Fields”. I got this error then:

Exception occur while importingDS_LRepo: (14.0) 05-02-11 05:45:48 (E) (8428:6896) SYS-170101: Import external metadata.## System Exception <ACCESS_VIOLATION> occurred. Process dump is written to <C:\Program Files (x86)\SAP BusinessObjects\Data Services{\log\BODI_FULL20110502055528_8384.DMP}

(the part in curly brackets was not in the error message but I found it on DS side in logs)

On Data Services side, in the Job Server eventlog I see this error:

(14.0) 05-02-11 05:44:32 (1676:1812) JobServer:  XML SDK Command <i> failed with error: : (BODI-850296)

The DMP file contains some unreadable stuff.

Any idea where I go from here?

Also, I’m not sure that I understand this: if I have to enter the Source Object for DS data source in BW, why do I still have an option to import any transfer structure to “BW as Target” datastore in BW? Shouldn’t it me one or another?

Codehopper (BOB member since 2010-05-14)

2

I tend to think that no one has yet tried to do that type of Data Services 4.0 → BW 7.3 connection.

I will make a step back and quickly summarise the process how it used to be on e.g. DS 3.x → BW 7.0/7.1:

  1. BW: Create a source system of type Partners, create a Data Source for that source system, manually specifying all fields.
  2. DS: Import the new datasource’s metadata into BW-Target datastore.

Now, the process looks weird in the new environment:

  1. BW: I was still able to create a source system of type Data Services in BW, but not really able to create a datasource, as the system requires me to enter something into “Source Object” field. The syntax of that field is not covered by the supplied documentation or online help. As I indicated above, Find and Browse All options for that field didn’t work. The third option, “Imported Objects” confuses me most – see below.

  2. DS: Somehow, in the metadata browser for BW, Data Services provides transfer structures for export datasources, which source system is BW itself, as opposed to the expected behaviour of listing datasources with DS as source system (and I couldn’t create any in #1!). The supplied documentation wrongly names them “Info Sources”, by the way, and doesn’t explain what should be their source system.

The presence of using “imported objects” option in new step #1 is confusing because the order of steps is unclear: I’ve got no idea what should be created first, datasource or its counterpart in DS.

As some SAP people happen read this forum, I would be much grateful to hear what should be the correct procedure. :hb:

Codehopper (BOB member since 2010-05-14)

3

development said:

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

4

Thanks to those blogs, I finally understand and appreciate the design’s flexibility. Sign me up to DS fanclub, Werner!

Now to DQM…

Codehopper (BOB member since 2010-05-14)