Skip to Content
avatar image
-1
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers