Skip to Content

Replication with BODS failed

Hello guys,

I face a problem with replicating a database from SQL SERVER to SAP HANA.

I use SAP DATASERVICES Workbench to do the replication through Quick Replication Wizard.

The connection to the source database and target one is done suuccessfly,

When I execute the job, I notice that only the tables structure is replicated but not the data and the job failed with the following errors :

-Error code :DBS-070407 : SQL submitted to database <> resulted in error <[SAP AG][LIBODBCHDB DLL][HDBODBC] Base table not found;259 invalid table name: cs_cognos_AKWA: line 1 col 25 (at pos 24)>. The SQL submitted is <TRUNCATE TABLE "SYSTEM"."cs_cognos_AKWA" >.

RUN-051005 : Execution of <Clean Table Before Load> for target <cs_cognos_AKWA> failed. Possible causes: (1) Error in the SQL syntax; (2) Database connection is broken; (3) Database related errors such as transaction log is full, etc.; (4) The user defined in the datastore has insufficient privileges to execute the SQL. If the error is for preload or postload operation, or if it is for regular load operation and load triggers are defined, check the SQL. Otherwise, for (3) and (4), contact your local DBA.

Thanks in advance for any help

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Dec 28, 2017 at 02:38 PM


    TRUNCATE TABLE "SYSTEM"."cs_cognos_AKWA ---------> is SYSTEM the correct schema name?

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.