Error While triggering tables from SLT to HANA

[former_member203760]

Hi Experts,

I have created configuration successfully.After this i am facing issue like below,

Error in HANA studio,

Please help me for the above issue.

Thanks in Advance.

Jana

[former_member203760 · Accepted solution]

Hello Experts,

While i am replicating any new table i am able to replicate without any errors.

But i am not able to replicate default tables, DD02L,DD08L,DD02T.

While i am checking in SM37, i am not able to see any Background jobs related to IUUC* please let me know i need to schedule any job for replicating this table or any other reason for this issue.

Thanks

Jana

[former_member203760 · Accepted solution]

Thank you all,

I have cleared the issue while following the sap guide.

Thanks

Jana

[Former Member · Accepted solution]

Hi Janardhan

Iam facing the same issue. Could you please help me to resolve it.

Regards

Ramesh

[Former Member]

Hello

Could you please help me how to resolve the same issue which iam facing.

Regards

Ramesh

[Former Member]

Hi Janardhan,

You can try transaction IUUC_SYNC_MON \ Processing Steps \ Create and Activate DB trigger.

If that fails you might want to do this first Expert Functions \ Reset Indicators\ Reset trigger state".

You can test it on a small table first.

Cheers,

Sharma

[former_member203760]

Hello Sharma,

While i am checking from IUUC_SYNC_MON \ Processing Steps \ Create and Activate DB trigger i am getting like below,

here also showing no errors, please help me for the above issues.

Thanks

Jana

[Former Member]

Jana

From your third screenshot, select the table and check "view Errors". This will tell you the error for the failed replication. These tables are replicated automatically when you create the configuration for the first time.

You will also get more information from Application Logs tab in LTRC Transaction.

Mahesh Shetty

[former_member203760]

HI Mahesh,

Thank you very much for your response.

I have checked errors for the table DD02T replication i got error like below,

I have checked all above error its working fine every thing RFC, DB connection.

I tried to replicate one new table(T001) with out any errors, like below,

I am able to see in HANA Studio also,

T001 table is always showing in process only but, i am able to open the table in HANA also.

I have checked in replication,  i am note able to see any tables in replication like below,

I Need to replicate one-by-one or it will replicate all at a time please suggested me for this also.

Thanks

Jana

[Former Member]

Jana

DD Tables seems to be the problem during replication. T001 shows in process means successfully replicated. You can count the number of records between HANA and ECC to confirm if the replication is working correctly. Before you add more tables to replication, we need to first determine the issue with DD tables.

As per your screenshot, if you check Column "Blocked Porcessing Step", I can see as Load/Replication blocked. As per Tobias blog, it means table is in suspend mode.

http://scn.sap.com/thread/3513020

Can you resume the replication for these tables from Data Provisioning in Table Overview tab once to see if that fix the issue.

Mahesh Shetty

[former_member203760]

Hello Mahesh,

Thanks you for your response.if DD table in suspend mode, what i need to do for removing from suspend mode. please help me for this.

Thanks

Jana

[Former Member]

Jana

Go to LTRC --> Table Overview tab -->

Select the Data Provisioning tab

Add the table and Resume Load Replication. If that does not work, try using stop Load/Replication and then resume Load Replication. You may need to do couple of times sometimes to get it done.

Mahesh Shetty

[former_member203760]

Hi Mahesh,

Thank you for your response.

I tried  many time to replicate the DD table, still unable to replicate.

I have one question, we need to replicate DD table must and why.

Please help me.

Thanks

Jana