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

sql error 2289 performing INS on table DDLOG,sequence does not exist

Hi All,

I am installing PI 7.3. While installing primary application server I am getting the error at step"Abap Post Installation activities".

sql error 2289 performing INS on table DDLOG [dbsynseq 336]

***LOG BY0=> ORA-02289: sequence does not exist [dbsynseq 336]

db_syflush2 (TRUE) failed

please help me on this.

Thanks,

Mahendar

ddlog.png (18.6 kB)
Add comment
10|10000 characters needed characters exceeded

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Feb 22, 2013 at 04:43 PM

    Hi,

    You need to apply the below note.

    SAP Note 185821 - ORA-2289 during insert on DDLOG

    This will fix your issue.

    Even I fixed this issue using the above note.

    Please check and provide your feedback.

    Thanks and Regards,

    Vimal

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 08, 2014 at 03:20 PM

    Hello,

    I had the same issue and it fixed with the below commands. To truncate the correct table and to create sequence under the correct schema, we need to use the ‘SAP SCHEMA NAME’ option in the commands.

    SQL> truncate table <Schema name>.ddlog;

    SQL> create sequence <Schema name>.ddlog_seq minvalue -2147483640 maxvalue 2147483640 increment by 1 cache 50 order nocycle;

    SQL> commit;

    SQL> shutdown

    SQL> startup

    ....Continue the installation.

    The original post is quite old but Hoping that the solution will work for the other friends.

    Regards

    Balaji Shelke


    Add comment
    10|10000 characters needed characters exceeded