SAP Note 27108 - sql error -4020 performing INS on table DDLOG

Symptom:

The following error message is displayed in the syslog:
sql error -4020 performing INS on table DDLOG
> unknown sequence name

Reason and Prerequisites

A MaxDB system or SAP DB system was not installed using R3Inst, R3Setup, or SAPInst.
Therefore, an object of the sequence type is missing in the database.

Solution

After the installation, you must subsequently create the sequence.

1. Start the SQLStudio (user SAPR3).

2. Execute the following select statement:
select * from DOMAIN.SEQUENCES

3. If the entry DDLOG_SEQ is not displayed, execute the following create statement:
CREATE SEQUENCE DDLOG_SEQ MINVALUE -2147483646
MAXVALUE 2147483646 INCREMENT BY 1 START WITH
-2147483646 NOCACHE NOORDER NOCYCLE