BODS4 & SAP SRM 7.0: no extractors shown

dataservices sap-erp-bw
1

Hi all,

I need some advise.

I have a BODS4 SP2 patch level 3 connected to SAP SRM 7.0. I am trying to access the extractors, however those are not shown and I do not have a clue on what is the cause… I can only see ‘NODESNOTCONNECTED’ and no extractor hierarchy at all and nothing under all extractors.

The SRM 7.0 system has PI_BASIS 702 10, which is higher than the minimum patch level (702 07) as listed in: Note 1521883 - Downport ‘ODP data replication API’. There are no follow-up SAP Notes on not displaying extractors.

When I check table ROOSATTR there are entries, all with EXPOSE_EXTERNAL set to ‘X’.

When I check the functions used by BODS and the program to release extractors then those are both present. I had some doubts with SRM supporting this, but since the program and the functions are present I assume that it is possible…

See functions:
http://wiki.sdn.sap.com/wiki/display/EIM/Debugging+DataServices+issues+with+Extractors+(SAP+internal+only)
See releasing:
http://wiki.sdn.sap.com/wiki/display/EIM/Releasing+Extractors+for+use+by+the+ODP+API

When I manually import an extractor that is listed in the table ROOSATTR then I get the following message:
‘Cannot import the extractor <name=0POC_BUSINESS_ACTIVITY>. Internal error <Extractor: RODPS_REPL_SOURCES_GET_LIST failed> occurred. (BODI-1116153)’.
Or:
‘Cannot import the extractor <name=0POC_BA_TXT>. Internal error <Extractor: RODPS_REPL_SOURCES_GET_LIST failed> occurred. (BODI-1116153)’.
I have found a reference to this error, but that was because of a missing Note and not-released extractors. I have entries in ROOSATTR, so that is not the case here.

Has someone a clue what is going on here? Maybe some auhorization on the SAP BODS user? What should I check?

Edit:
I have found ‘Note 1585204 - ETL interface: Release of DataSources’. The note describes that table entries in ROOSATTR are ignored. The correction delivered in support package does not list my PI_BASIS 702 10, only 09, 11, 12… Could this be the cause?

Johannes Vink :netherlands: (BOB member since 2012-03-20)

2

Yes, that’s the reason. I found out myself that we support the NW version the ECC system runs only, so NW 7.00, NW 7.10 and 7.30 but not 7.20.

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

3

Wait a sec, are you saying that only ECC is supported and not SRM or CRM?

Or can I still let the note installed and happily use the extractors?

Edit: Implementation of the Note did not improve the situation.

Edit2: I should have checked if there were active datasource in the system… there was not one active… :hb:

Johannes Vink :netherlands: (BOB member since 2012-03-20)

4

Hi,

Do we have an answer here? is SAP SRM supported by BODS or only SAP ECC is supported?

ganeshm (BOB member since 2011-03-17)

5

SRM and CRM is supported.
Are we talking about Extractors still?

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

6

You need to keep in mind that there not many official released data sources, so you’ll need to release them your self or create custom ones.

And too be honest, the data model of SRM/CRM is on most cases so simple that an extractor is overkill.

Johannes Vink :netherlands: (BOB member since 2012-03-20)