Skip to Content
author's profile photo Former Member
Former Member

Replication issue in HANA

Hi ,

We are using SLT technology (SLT configured in separate system) for repliciating tables from ecc to HANA. schema in SLT system is showing in red status with error messages in trigger tab "Trigger is missing in Source System although it is internally set as activated" but when i looked in source system we found triggers for those tables.

Also when we are trying to replicate new tables in HANA studio few tables are going into schedule or error status and in schema thest tables are showing in yellow status with "Table was not yet processed; trigger should be created during first processing" in schema under trigger tab and also we can't find triggers for these tables in source system.

we already applied oss note 1663138 and 1645517. we are on HANA SP4 and DMIS SP5.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Dec 05, 2012 at 04:56 PM

    Hi Uday,

    You could use transaction iuuc_sync_mon in your SLT system to check a few things:

    a. Application logs to see if it gives you anymore info on why the trigger creation failed

    b. You could use the same transaction to delete and recreate the triggers for a specific table (Do this only if it isnt a production environment). If that recreates the trigger successfully, then you can restart the replication within the HANA studio.

    Thanks,

    Anooj

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Anooj,

      There are no error logs in iuuc_sync_mon t.code, moreover when i try to delete triggers i got meassage table (tried with one table) triggers are deleted but i still see errror message in schema for that table under trigger tab and also while trying to create/activate trigger getting message "no object to be processed for this selection". I'm just providing table name and mass id number for deleting trigger.

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.