Import ECC Extractor to DWC

[liskb]

We can import Remote ABAP tables from our ECC source system. However when trying to select Extractors and then BW or SAPI, we are getting the error below.

I tried troubleshooting with an SAP Basis administered to see if it was authorization related, however we could not see any authorization errors in the trace while executing that function.

This happens on the ECC systems we are connected to but not the BW systems we are connected to - Both systems are Oracle DB. Please advice as to what could be causing the errors when trying to select from Extractors on the ECC connections.

Error

An unexpected error has occurred. Sorry for the inconvenience.

We can provide the following information to assist either you or an SAP engineer to solve the issue:

Correlation ID: faf228f5-8334-47be-5b63-8892c416d26e
HTTP Status: 500 Internal Server Error
Error Code: getChildrenFailed

Technical Message: internal error: Cannot get remote source objects: Could not get tables, Code: 403, SQL State: HY000

[deodutt_dwivedi]

Hi Bart,

Kindly check the sizing of your DP Agent as well, try increasing the allocated memory if its too less. I believe this has nothing to do with Data Flow warning that you have referred to in one of the comment. If you configure cloud connector separately then Data Flow warning will be gone, but this has nothing to do with remote table replications via DP Agent.

Regards,

Deo

[dwc_consultant57]

Hello Bart,

We are facing a similar issue? were you able to resolve this? also, did you use ABAP Adapter (within your DP agent) to connect to ECC or OracleLogReader adapter to connect to ECC? Thank you.

[bhavinvyas]

Please check if this note and link is helpful,

2956519 - Error: "Cannot get remote source objects: Could not get tables" when opening remote source...

Oracle Database Permissions

[cardoso]

Hello,

I suggest you to check authorization for the ECC user that is provided in the Connection's credentials.

You can also validate the connection, I expect you to get a similar error.
Using a SAP_ALL user will answer if this is an auth issue or something else.

BR.
Ismael

[liskb]

Hi Ismael,

Yes, as I stated in my post, we checked authorization doing trace on user while trying to execute. We even gave SAP_ALL to user in non-prod test system to test and have same issue. Doing validate on connection we got warning on DataFlows.only which may not be supported for ECC?

Maybe this Extractor feature is not available on our version of

Error:

Connection "ECC DEV E1D" is valid, but not all features are available. - Data flows can't be used because of errors in the connection. - Remote tables are enabled.
Data Flows: The user aborted a request.