Skip to Content
-1

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

Jan 30, 2017 at 09:06 AM

347

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers