Skip to Content
avatar image
Former Member

slt replication - cannot use duplicate sequence name

Hello,

maybe somebody had the error I'm currently facing and can provide a solution for that. Thx, Thomas

App-log in SLT:

SM 21 in source-system:

pastedImage_1.png (299.8 kB)
pastedImage_2.png (63.4 kB)
pastedImage_3.png (158.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Oct 30, 2015 at 07:16 AM

    Hi,

    i only fould something for an upgrade NZDM ( HANA ), maybe it will help too.

    Ursache

    This error takes place because the setting "trigger nesting depth max limit" is set to value 8 internally, or explicitly in HANA configuration file indexserver.ini.

    Depending on the scenario, the SUM tool needs more triggers available from the database on this particular phase, but hits this limit and throws the error.

    Lösung

    Please set manually a higher value for this parameter in file indexserver.ini > sql > Nested_Trigger_Limit. If the parameter does not existe, please create it.

    You can also use a SQL statement. For example, setting up a value of 16:

    alter system alter configuration ('indexserver.ini','SYSTEM') set ('sql','nested_trigger_limit') = '16' with reconfigure;

    You can safely leave this parameter after the upgrade finishes.

    For more information, please refer to SAP Note 2130431.

    greetings

    Oliver

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Oliver,

      thx! ... I will align with basis and we will try, if setting ('sql','nested_trigger_limit') = '16' will correct the current behavior.

      Greeting, Thomas

  • avatar image
    Former Member
    Nov 18, 2015 at 08:45 PM

    Hello,

    strange behavior. Without changing any settings it was now possible to add the tables to the replication.

    But now new issues occur. The system dumps permanently while executing the /1LT/IUC_LOAD_MT-jobs. Error enclosed below.

    That's the DMIS-version that is installed. This version is installed in the complete landscape,but errors occur only on 1 system

    Thx.in advance for help / replies,

    Thomas


    12345.JPG (40.0 kB)
    Add comment
    10|10000 characters needed characters exceeded