SAP Knowledge Base Article - Public

3534396 - Datasphere push to ADLS is not working due to connectivity issues

Symptom

Running a replication flow, it ends with an error like below one.

Failed to prepare source replication artifacts due to remote source error. (SQL error code = 260, SQL error msg = SAP DBTech JDBC: [260]: invalid column name: "<SPACE_NAME>$TEC"."DELTA_PROVIDER_SUBSCRIBER_UPSERT_SUBSCRIBERS": line 25 col 3 (at pos 827): "<SPACE_NAME>$TEC"."DELTA_PROVIDER_SUBSCRIBER_GET_SUBSCRIBERS": line 55 col 5 (at pos 1830): MIN_VERSION: line 17 col 18 (at pos 500)). Executing CALL "<SPACE_NAME>$TEC"."DELTA_PROVIDER_SUBSCRIBER_UPSERT_SUBSCRIBERS" ( ?, ?, ?, ?) failed. Please check if database stored procedure exists or current user has necessary permissions to access. Contact the system administrator for the HANA system to address the issue and then resume the replication task.

Environment

SAP Datasphere

Reproducing the Issue

Run a replication flow

Cause

Possible it is a metadata inconsistency

Resolution

Redeploy the replication flow and run it again.

Keywords

KBA , DS-DI-RF , Replication Flows , Problem

Product

SAP Datasphere all versions