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

[Former Member]

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

[former_member297883]

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

[former_member219299]

Set the parameter rdisp/bufrefmode = sendoff,exeauto.

SAP Note 14754 - Profile parameters for buffer synchronization explains all set. If you have several Application Server this cannot be set. Check the SAP Note!

Hudson Soares

[S0021322438]

Thanks my issue resolved