Hierarchy data source activation error "Syntax error in GP_ERR_RSAPTH3, row 30 (-> long text)"

[former_member216525]

Hi Experts,

Have InfoObject based Hierarchy (0CRM_MKTELM) in BW system A which need to made available in BW system B.

I have followed the below steps:

1. Generated an Export DataSource for the Characteristic in BW system A; and replicated in the DataSource in BW system B (SAP BWoH 7.4)

2. When trying to activate the datasource in BW system B, seeing the error.

Syntax error in GP_ERR_RSAPTH3, row 30 (-> long text)"

Have followed the below notes and implemented it but it seem of no use, as this report activates only the Active datasource as per logic?

SAP Note 2113639 - Activation of Hierarchy DataSource - GP_ERR_RSAPTH3

I ran the report ZROOHIECAT_REPAIR from the note but it's working with record from ROOHIECAT table, which doesn't exist until the datasource is not activated:

SELECT * INTO TABLE lt_ohiecat

FROM roohiecat

WHERE oltpsource IN ( SELECT oltpsource FROM roosource

WHERE oltpsource IN so_osnam

AND objvers EQ 'A'

AND type EQ 'HIER'

AND tfmethods EQ space

)

AND objvers EQ 'A'

Can you suggest on this issue plz?

HV found another query raised with same issue with no answer:

https://archive.sap.com/discussions/thread/3801915

[s__muscas]

Hello,

how this has been solved?

[murcielago83]

Hi,

you should run the program in BW system A in order to repair issue ... and after that activate Datasource in BW system B.

Regards