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

[gautamkumar]

This isssue is related to buffer synchronization in SAP .
To synchronize the changes made to buffered tables, synchronization records are written to the table DDLOG. An Oracle sequence DDLOG_SEQ is used to uniquely identify these synchronization records.
The error message mentioned above indicates that this sequence has not been created on the database. This may be due to an incomplete installation of the system.
:
Solution :

You must create the Oracle sequence DDLOG_SEQ
You can create the sequence using Oracle tools, for example, sqlplus. Log on the the Oracle database as user SAP<sid> and execute the following statements:

truncate table ddlog;
create sequence ddlog_seq minvalue -2147483640 maxvalue 2147483640
increment by 1 cache 50 order nocycle;