DWC Local Connection to SQL-Server Dataflow not working

[CKnall]

Hi,

i have an issue regarding the local connection for sql-server on premise.

The option DataFlow is not working:

Warning

Connection "huhu" 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. Could this be a firewall issue? Is DataFlow not using DP Agent?SQL Server 2019 with mssql-jdbc-8.4.1.jre8.jar enable in the DP_Agent root folder/.../libOn my SQL Linux installation (Not supported) it works for some times and than it doesn't work and after a while it works again. Any ideas?Thanks and greetings Cornelius

[ravicondamoor]

Hi @CKnall 

I am seeing this error - Data Flows: The user aborted a request.

What did you fix to get past this issue?  Data Flow used to work for me in the past but am seeing this error now.

Thanks

-ravi

[CKnall]

Dear Klaus-Peter,

I was able to get an valid connection:

"Connection "ConnectionName" is valid.

- Data flows are enabled.

- Remote tables are enabled"

But if I use a Dataflow the next error is occuring:

Connection Error

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

Correlation ID: 8982e410-5bdb-403f-78d7-f69fc0b06579
HTTP Status: 500 Internal Server Error
Error Code: getChildrenFailed
Technical Message: Failed to fetch the data. Failed to get container children for /.

Cause 1: Browse request could not be performed due to error: Open needs to be called before other operations Code:99999;

In the Admin guide there is no need for a Cloud Connector. Or am i wrong?

By the way, with SSMS i can connect through public string to the server and get data.

Greeting Cornelius

[CKnall]

By the way, dataflows are now working as well. I think maybe DWC needs some time to get all informations.

Somethimes while drag and droping tables from connections, there is an error. retrying it several times solved this issue.

At the moment everything is working fine

[atriquellc]

I have your first issue... How did you fixed it?

[kpsauer]

Hi Cornelius,

first thing I would check is IP allow list on both sides, meaning source system IP to be allowed in Data Warehouse Cloud and also the other way around, meaning the Data Warehouse Cloud IP to be allowed to get through the firewall and allowed to connect to your source system.

Data Flows are not using the DP agent. In case you are not sure, just check our SAP Help documentation: https://help.sap.com/viewer/9f804b8efa8043539289f42f372c4862/cloud/en-US/bffbd58c15784a62af0520f1710.... You will find lots of other interesting information around connection topics there.

Best regards
KP Sauer