Replication Load job fails

[sebastian_joebharath2]

Hello Experts,

We are trying to replicate the CE1KT01 SAP Tables to HANA database.

Replication job fails with below error.

31.03.2014 13:20:25 Job started	00	516	S
31.03.2014 13:20:25 Step 001 started (program DMC_MT_STARTER_BATCH, variant &0000000004802, user ID BASIS)	00	550	S
31.03.2014 14:00:00 No Application Log exists	DMC_GENERAL	153	E
31.03.2014 14:00:00 Job cancelled after system exception ERROR_MESSAGE	00	564	A

Hana Database version : 1.00.70.00

SAP SLT:

DMIS    2011_1_731    0005    SAPK-11605INDMIS    DMIS 2011_1

Please help us solve this issue.

Regards

Sebastian A

[tobias_koebler · Accepted solution]

Hi,

have you implemented all correction notes for SP5?

Best,

Tobias

[sebastian_joebharath2 · Accepted solution]

Thanks Tobias.

Now we have applied the Support package 6 and replication job is running successfully.

When we tried to replicate 40000 rows of CE1KT01 COPA  table in HANA Table.

Replication job is running more than 1 days and still its running .

How can we speed the replication process

Regards

Sebastian A

[Former Member]

Which notes for SP5?

Thanks

[tobias_koebler]

Have a look here for SP5.

[Former Member]

hi,Tobias Koebler

User Roles for Non- ABAP Source System

To establish a secondary database connection from an ABAP system to an external database, the connection data and the user data of a user are required. This user must be authorized to establish a connection to the external database The ABAP system connects to a specific schema from the database. To perform the replication and initially load a specific table from a given schema, the database user must have privileges for the following actions:

 Selecting from the table

 Creating a table in the given schema (for creating the logging table)

 Selecting from the logging table

 Deleting the logging table

 Creating database triggers for the table

 Deleting the triggers

 Creating synonyms for the specific table

 Deleting the synonyms

Depending on the specific external database system, the process of granting privileges to a user can vary.

But for Oracle database , How to authorize the a user these privileges?

Can you tell me the detail?

thank you very much

[tobias_koebler]

Hi,

puh...I am not an Oracle expert - I owuld suggest to ask this in an Oracle forum.

Sorry.

Best,
Tobias