CPI-DS not able to pull data from SAP

[former_member60331]

Hi Experts,

We are trying to pull master data from SAP using CPI-DS, but we are not able to pull the data from SAP.

We have tried with both the option "Execute and Load" and "Execute Preload".

Following is the error -

2020-06-01 06:54:46 (R)(8951:738195200)R3C-150412 |Data flow Task_S4H_IBP_LocationMaster_DF_S4H_IBP_LocationMaster|Reader Task_S4H_IBP_LocationMaster_R3_DF_S4H_IBP_LocationMaster|Transform Task_S4H_IBP_LocationMaster_R3_DF_S4H_IBP_LocationMaster__Driver
RFC CallReceive error <Function /SAPDS/RFC_ABAP_INSTALL_RUN: RFC_ABAP_MESSAGE, Changes to repository objects are not permitted
in this client)- Changes to repository objects are not permitted in this client[SAP NWRFC 721][SAP Partner 754
][D4A][xxxxxxxxxxx][SAPIBP ][4103]>.

We are using client 200 for this, which is not an open client (UAT client).

However, when we make this client open and perform (Execute and Load) CPI-DS is able to fetch the data.

Is there a way in which I can pull the data from the UAT client using CPI-DS without opening the client for changes?

Regards,

Akash

[former_member598107]

The generated ABAP program should not contain any errors. Check the ABAP dataflow and make sure that it does not contain any errors. The program name used by ABAP dataflow should be the same when the code is generated in the ABAP code. When the ABAP developer runs the abap program in se38 he should not receive any errors and the program should be compiled successfully.

The ABAP developer should not fix the code manually as it would be a tedious process for him.

Once you make sure that the code is working fine in Dev then you can import the transport in QA and UAT and execute the job using Execute Preloaded option in SAP Application datastore.

Regards

Arun Sasi

[former_member598107]

akashenoc

If you are only reading the data using SAP Datastore then I believe the BODS user should have authorization to read data from SAP tables SAP generates a ABAP program with runtime SQL to fetch the data from tables and although there is no write happening on the repository tables, the ABAP program assumes that there is a database write and thus it gives the error Changes to repository objects are not permitted.

The Authorization team should be able to help you with that. You cannot fetch the data using the generate and execute SAP datastore option from UAT Client. For this the ABAP program should always exist on the SAP Application server.

SAP Authorization team needs to create a Role with the proper authorization objects

https://help.sap.com/viewer/df959412681b4619a38f03ff90207e6b/4.2.10/en-US/577771716d6d1014b3fc9283b0...

Regards

Arun Sasi

[former_member60331]

Hi Arun Sasi,

Thank you for the reply.

The abap program which is getting generated automatically has some syntax errors.

We are able to replicate the data in dev client as we used "Execute and Load" option, however, the same abap code throws the syntax error when we run it in UAT client with "Preload" option.

When we manually correct the code and then execute in UAT client the replication is successful.

Do you have any idea about how to resolve the code issue?

Regards,

Akash