SDI - error when executing a replication task

[FCI]

Hi,

I have created a remote source (to a local flat file) using SDI. I have no issue when creating a virtual table on top of this source and when creating a replication task on the same source.

But when executing the replication task, the following error occured: invalid name of function or procedure

[11:44:08] Start
executing REPT_CNTR....

[11:44:09] InternalError:
dberror($.hdb.Connection.executeProcedure): 328 - SQL error, server error code:
328. invalid name of function or procedure: demo::REPT_CNTR.START_REPLICATION:
line 1 col 13 (at pos 12) at
/sapmnt/ld7272/a/HDB/jenkins_prod/workspace/HANA__FA_CO_LIN64GCC48HAPPY_rel_fa~hana1sp12/s/ptime/query/checker/check_call.cc:38

Any idea on what can cause this kind of error ?

I'm using a neo trial db (1SPS12) and the last available version of the SDI components (2.3 for the agent).

Thanks in advance.

Regards,

Frédéric

[FCI · Accepted solution]

Problem was due to missing authorizations on the remote source for user _SYS_REPO. For a unknown reason, in my case, no error occured when activating.

[ssurampally]

Hi Frederic, I can't think of any other reasons for getting the stored procedure and tables created.., may be something to do with authorizations.

Before that, can you locate your tables where do they exist, I mean which schema etc..

select * from "SYS"."M_TABLES" where table_name like '%country%

[FCI]

I initially thought to an autorisation issue on the target schema but I have the same problem when using the SYSTEM schema (I'm using the SYSTEM user).

I will try to find the tables elsewhere as you suggest.

Thanks

[FCI]

The tables definitively don't exist on my system.

[FCI]

I'm still stucked on this one.

Any idea why the procedure is not generated when activating the replication task ?

[ssurampally]

Can you call the procedure which was created for the replication task? it does the same action of running the replication task. You can find the procedure in the the schema in which target table is created..,

[FCI]

H Sreekanth,

Thanks for your answer.

I can't find any procedure in the target schema. I guess that explains the error 😉 but why is the procedure not created ?

I have no error during activation:

Moreover, I can't find the associated tables (virtual or physical) in the same schema.

Regards,

Frederic