Question Re: sql error 2289 performing INS on table DDLOG,sequence does not exist in Technology Q&A

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

Former Member — Fri, 22 Feb 2013 16:34:00 GMT

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

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

Former Member — Fri, 22 Feb 2013 16:43:39 GMT

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

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

Former Member — Fri, 22 Feb 2013 17:05:04 GMT

Hi Vimal,

while executing truncate command I am getting below error:

SQL> truncate table ddlog;

truncate table ddlog

ERROR at line 1:

ORA-00942: table or view does not exist

Thanks,

Mahendar

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

Former Member — Fri, 22 Feb 2013 17:12:04 GMT

Hi,

You need to execute with your schema.

what is your ABAP schema ?

Example :

truncate table SAPSR3.ddlog;

create sequence ddlog_seq minvalue -2147483640 maxvalue 2147483640

increment by 1 cache 50 order nocycle;

Or you can directly enter the second command.

create sequence ddlog_seq minvalue -2147483640 maxvalue 2147483640

increment by 1 cache 50 order nocycle;

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

Former Member — Fri, 22 Feb 2013 17:25:14 GMT

Hi Vimal,

I did and got the success message but it installation is still failing.

SQL> truncate table SAPSR3.ddlog;

Table truncated.

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

Sequence created.

Thanks,

Mahendar

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

Former Member — Fri, 22 Feb 2013 17:47:04 GMT

Hi MAhemdar,

Could you check delete the existing license from the system and continue with the installation.

Regards,

Deepak Kori

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

Former Member — Sat, 23 Feb 2013 01:27:23 GMT

Hi,

Can you please attach the sapinst_dev.log file ?

I feel that you will be receiving a new error message... If you have executed that step, then it should be working fine.

Try to stop the sapinst and start again using continue with old installation... It should work fine..

If not, please attach the new sapinst_dev.log for analysis.

Thanks and Regards,

Vimal

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

Former Member — Sat, 23 Feb 2013 10:09:11 GMT

Hi Vimal,

I have restarted sapinst but still getting same error. please find the below sapinst_dev.log file:

TRACE 2013-02-23 09:36:17.904
SAPInst calls the LogInquirer. The output of the LogInquirer can be found in file sapinst_loginquirer.log.

TRACE 2013-02-23 09:36:31.18 [iaxxgenimp.cpp:699]
CGuiEngineImp::showMessageBox

<html> <head> </head> <body> An error occurred while processing option SAP NetWeaver 7.3 > SAP Systems > Process Integration > Distributed System > Primary Application Server Instance( Last error reported by the step: Process call '/usr/sap/P3D/SYS/exe/uc/linuxx86_64/saplikey pf=/usr/sap/P3D/SYS/profile/P3D_DVEBMGS03_lxv2036 -install_first_temp Q0693519609 XXXXXX' exits with error code 2. For details see log file(s) saplikey.log, dev_slic.). You can now: <ul> <li> Choose Retry to repeat the current step. </li> <li> Choose Log Files to get more information about the error. </li> <li> Stop the option and continue with it later. </li> </ul> Log files are written to <code>/tmp/sapinst_instdir/NW73/INSTALL/NW73/ORA/DISTRIBUTED/PI/APP1</code>. </body></html>

TRACE 2013-02-23 09:36:31.24 [iaxxgenimp.cpp:1248]
CGuiEngineImp::acceptAnswerForBlockingRequest
Waiting for an answer from GUI

INFO 2013-02-23 09:36:33.508 [sixxcstepexecute.cpp:1028]
An error occured and the user decided to stop.\n Current step "|NW_Doublestack_CI|ind|ind|ind|ind|0|0|NW_CI_Instance|ind|ind|ind|ind|ci|0|NW_CI_Instance_ABAP_Reports|ind|ind|ind|ind|auto.id:3|0|createTempLicense".

TRACE      2013-02-23 09:36:59.868 [syuxccuren.cpp:306]
           CSyCurrentProcessEnvironmentImpl::setEffectiveGroup(PSyGroupInt)
           lib=syslib module=syslib
effective group already set. Nothing to do.

TRACE      2013-02-23 09:36:59.967 [syuxcuser.cpp:701]
           PSyGroupImpl CSyUserImpl::getPrimaryGroup()const
           lib=syslib module=syslib
account user="root" uid="0" exists with parameter gid="0"

TRACE      2013-02-23 09:36:59.967 [syuxccuren.cpp:266]
           CSyCurrentProcessEnvironmentImpl::setEffectiveUser(PSyUserInt, const iastring&)
           lib=syslib module=syslib
effective user already set. Nothing to do.

INFO       2013-02-23 09:36:59.967 [syuxccuren.cpp:562]
           CSyCurrentProcessEnvironmentImpl::setWorkingDirectory(const CSyPath& /tmp/sapinst_instdir/NW73/INSTALL/NW73/ORA/DISTRIBUTED/PI/APP1)
           lib=syslib module=syslib
Working directory changed to /tmp/sapinst_instdir/NW73/INSTALL/NW73/ORA/DISTRIBUTED/PI/APP1.

TRACE      2013-02-23 09:36:59.968 [syuxccuren.cpp:128]
           CSyCurrentProcessEnvironmentImpl::setUmask(ulong)
           lib=syslib module=syslib
umask set to 23

TRACE      2013-02-23 09:36:59.971 [syuxccuren.cpp:613]
           CSyCurrentProcessEnvironmentImpl::removeEnvironmentVariable(iastring)
           lib=syslib module=syslib
Removed environment variable 'SYSLIB_SWITCH_ONLY_EFFECTIVE_ACCOUNT' from current process environment.

TRACE      2013-02-23 09:37:00.295 [syxxcfile.cpp:123]
           CSyFileImpl::decideIfMoveCopyNode(const CopyMoveDestinationInfo & {m_nodeTypeForCombiCheck: ..., m_path: /tmp/sapinst_instdir/.lastInstallationLocation.1, m_realNodeType: 8}, ISyNode::CopyMoveMode_t 0x3, PSyNodeInt &) const
           lib=syslib module=syslib
Target node does not exist and (mode & ISyNode::MISSING) ==> I will copy/move.

TRACE      2013-02-23 09:37:00.298 [syxxcnode.cpp:454]
           CSyNodeImpl::move(const CSyPath & /tmp/sapinst_instdir/.lastInstallationLocation.1, ISyNode::CopyMoveMode_t 0x3)
           lib=syslib module=syslib
Moved /tmp/sapinst_instdir/.lastInstallationLocation to /tmp/sapinst_instdir/.lastInstallationLocation.1

INFO 2013-02-23 09:37:00.300 [syuxcpath.cpp:471]
CSyPath::createFile() lib=syslib module=syslib
Creating file /tmp/sapinst_instdir/.lastInstallationLocation.

TRACE 2013-02-23 09:37:02.302 [syuxctask.cpp:1115]
CSyTaskImpl::cancel() lib=syslib module=syslib
sending SIGKILL to process with id 6764

INFO 2013-02-23 09:37:02.302 [syuxctask.cpp:1122]
CSyTaskImpl::cancel() lib=syslib module=syslib
Cancelled task 0.

TRACE      2013-02-23 09:37:02.309 [syuxctask.cpp:878]
           CUnixProcessManager::sap_waitpid(pid_t pid, int * pStatus, int options)
           lib=syslib module=syslib
Child process 6764 terminated by signal 9

Thanks,

Mahendar

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

Former Member — Sat, 23 Feb 2013 10:16:51 GMT

please find the dev_likey log below:

{ db_tran94( fcode = RS_FETCH, xfer = 0, tname = 'SAPLIKEY', stmt { no ID }, 0xb84480 )
-->DbSlExeRead(#1: con=0, ss_p=b8e5c0, da_p=b8bab0)
 time 2013.02.23. 09:58:18
-->oci_execute_stmt(con=0, stp=13caf80, iters=1, rowoff=0, dml_batch_err=0)
before OCIStmtExecute(svchp=1256550, errhp=1256630): [dur. 0,000s]
OCIStmtExecute() completed, rc=100=OCI_NO_DATA, no further data
 -> rc=1403=OCI_ERR_NOT_FOUND
after OCIStmtExecute(rpc=0): [dur. 0,001s]
<--oci_execute_stmt(rc=1403, rows processed 0, iters-errors = 1-0) [dur. 0,001s]
 set_ocica() -> SQL code 1403
-->oci_get_errmsg (con=0, rc=1403)
 OCIErrorGet -> SQL error code: 1403
 ORA-01403: no data found
 stmt_fetch() -> orc=1403, 24=DBSL_ERR_NOT_FOUND
 DbSlExeRead(#1) --> 24=DBSL_ERR_NOT_FOUND
} db_tran94( retcode = 2048, mod_cnt = 0, cursor = 1 )
{ db_tran94( fcode = RS_CLOSE, xfer = 0, tname = 'SAPLIKEY', stmt { no ID }, 0xb84480 )
-->DbSlEndRead(#2: con=0, ss_p=b8e5c0, da_p=b8bab0)
 DbSlEndRead(#2) -> 0=DBSL_ERR_OK
} db_tran94( retcode = 0, mod_cnt = 0, cursor = 1 )
} db_rsql1994[0]( retcode = 2048, mod_cnt = 0, cursor = 2 )
SlicLikeyGetAllRecords: no more records found
{ db_rsql1994[0]( fcode = RS_CLOSE, xfer = 0, tname = 'SAPLIKEY', stmt { no ID } ) {sliclikey.c:1198}
} db_rsql1994[0]( retcode = 0, mod_cnt = 0, cursor = 2 )
likeyper_get_all_records () returns:
0 records listed.
Start first loop.
Start second loop.
likeyper_cleanup () called.
likeyche_fill_buffer: returning 0
Installation number is "0000000000".
System number is "000000000000000000".
likeymem_free (1386750) called (type Buffer of likeys (array), size 80).
likeymem_free (13d6af0) called (type Buffer of likeys (handle), size 96).
likeyadm_get_install_system_no () is returning 0 (okay).
SlicIDbLock: first call to SlicIDbLock: initialize Mutex
-->DbSlPrepare(con=0, ss_p=b71980, op=DBSL_SELECT, da_p=e7cb60)
 time 2013.02.23. 09:58:18
-->oci_prepare_stmt(con=0, len=31, stp=13d9d90); AI=,0,,
 SELECT COUNT (*) FROM MLICHECK
 DbSlPrepare(lit=0, lob=0, fae=0, col=0, mrk=0) --> 0=DBSL_ERR_OK
-->DbSlRead(con=0, ss_p=b71980, da_p=e7cb60), table='LICENSE'
Out 00: DBSL_DATA_INTEGER_4 (len=4, max=4, dec=0)
bind_type_and_length(): 0 input variables given
bind_type_and_length(): 1 output variables given
- oci_define ( 0: SQLT_INT , l= 4, con=0, stp=13d9d90, vp=1358398,ip=136d620,rlp=(nil),rcp=(nil))
 time 2013.02.23. 09:58:18
-->oci_execute_stmt(con=0, stp=13d9d90, iters=1, rowoff=0, dml_batch_err=0)
before OCIStmtExecute(svchp=1256550, errhp=1256630): [dur. 0,000s]
 OCIStmtExecute() failed with -1=OCI_ERROR
 SQL error 942:
 ORA-00942: table or view does not exist
after OCIStmtExecute(rpc=0): [dur. 0,002s]
<--oci_execute_stmt(rc=942, rows processed 0, iters-errors = 1-0) [dur. 0,002s]
 set_ocica() -> SQL error code 942
-->oci_get_errmsg (con=0, rc=942)
 OCIErrorGet -> SQL error code: 942
 ORA-00942: table or view does not exist
 stmt_fetch() -> orc=942, 103=DBSL_ERR_DBOBJECT_UNKNOWN
 DbSlRead() --> 103=DBSL_ERR_DBOBJECT_UNKNOWN
SlicFindHighLCheckDate: no licenses found
No license found from the old license key library, assuming system number "000000000000000000" and installation number "0000000000".
likeymem_malloc (440) for type "Internal form of a likey" returns 13e2a00.
likeymem_malloc (50) for type "Signature of a likey" returns 1387770.
likeymem_free (1387770) called (type Signature of a likey, size 50).
likeymem_free (13e2a00) called (type Internal form of a likey, size 440).
SlLikeyIAllocSlot: allocated new space to hold 10 strings (240 bytes)
SlLikeyIStrPrepModif: allocated new slot 0
SlicLikeyInsertRecord: insert SAPLIKEY 0002LK0003P3D0011Q06935196090013NetWeaver_ORA/001021474836470001T0024+LJTDwMm7OGpfDuZPsvIJA==001000000000000008201302230008201305
2400180000000000000000000000
{ db_rsql1994[0]( fcode = RS_INSERT, xfer = 0, tname = 'SAPLIKEY', stmt { no ID } ) {sliclikey.c:460}
{ db_tran94( fcode = RS_INSERT, xfer = 0, tname = 'SAPLIKEY', stmt { no ID }, 0xb83fd0 )
-->DbSlModify(con=0, ss_p=b8e5c0, op=-1828885524, da_p=b8b828)
 DbSlModify() --> 13=DBSL_ERR_STMTID
-->DbSlPrepare(con=0, ss_p=b8e5c0, op=DBSL_INSERT, da_p=b8b828)
 time 2013.02.23. 09:58:18
-->oci_prepare_stmt(con=0, len=68, stp=13df6e0); AI=,0,,
 INSERT INTO "SAPLIKEY" VALUES(:A0 , :A1 ) RETURNING "VALUE" INTO :A2
 DbSlPrepare(lit=0, lob=1, fae=0, col=2, mrk=3) --> 0=DBSL_ERR_OK
-->DbSlModify(con=0, ss_p=b8e5c0, op=-1828885524, da_p=b8b828)
 DbSlModify(): table='SAPLIKEY'
In 00: DBSL_DATA_SHORT_CHAR (len=510, max=510, dec=0)
In 01: DBSL_DATA_CLOB (len=1234, max=64000, dec=0)
bind_type_and_length(): 2 input variables given
LOB descriptor allocated to output descriptor area: lob_ret_cnt=1
-->oci_alloc_loblocators (con=0, new_cnt=1, old itp=(nil))
-->extend_ll(new_max=1, unused chunk=(nil))
<--extend_ll(old used_LL=0,xl=(nil) -> new max_LL=1,xil=12b56c8)
<--oci_alloc_loblocators(new itp=12b56c8, locarr=12dfe28)
- oci_bind ( 0: SQLT_AFC , l=510, con=0, stp=13df6e0, progv=135897a, indp=1358398,rlen=1358784,rcode=(nil))
- oci_bind_dyn( 1: SQLT_CLOB, l= 0, con=0, stp=13df6e0)
- oci_bind_dyn( 2: SQLT_CLOB, l= 0, con=0, stp=13df6e0)
exec_modify(): bulk=0, input_cnt=2, literal_cnt=0, fae_cnt=0
 time 2013.02.23. 09:58:18
-->oci_execute_stmt(con=0, stp=13df6e0, iters=1, rowoff=0, dml_batch_err=0)
before OCIStmtExecute(svchp=1256550, errhp=1256630): [dur. 0,000s]
- loblocator_in_cbf(row=0, ((ctxt=11b5988)->lob_arr+0)->locarr[0]=13cb6d8)
-->lob_do_nothing_cbf (ibind_ctxt=(nil),bind_p=13df048,iter=0,index=0)
 loblocator_ret_cbf(vdp=11b59e8, bind_p=13df048, iter=0, row#=0, lob#=0)
-->oci_alloc_loblocators (con=0, new_cnt=1, old itp=(nil))
-->extend_ll(new_max=1, unused chunk=(nil))
<--extend_ll(old used_LL=0,xl=(nil) -> new max_LL=1,xil=13d6b28)
<--oci_alloc_loblocators(new itp=13d6b28, locarr=13e5148)
after OCIStmtExecute(rpc=1): [dur. 0,002s]
<--oci_execute_stmt(rc=0, rows processed 1, iters-errors = 1-0) [dur. 0,002s]
-->oci_lob_write(con=0, CLOB locp=13e0e20, bufp=13e2b00, bufl=222, 0=ONE_PIECE, amt=111) [dur. 0,000s]
<--oci_lob_write(orc=0, amt=111) [dur. 0,002s]
 lobwrite_1piece(lob_pw_cnt=0) -> rc=0=DBSL_ERR_OK
 stmt_execute() -> orc=0, rc=0=DBSL_ERR_OK
 exec_modify() -> 0=DBSL_ERR_OK
 DbSlModify() --> 0=DBSL_ERR_OK
} db_tran94( retcode = 0, mod_cnt = 1, cursor = 0 )
db_sync: class = 3
table = 'SAPLIKEY '
 keylen = 0
} db_rsql1994[0]( retcode = 0, mod_cnt = 1, cursor = 0 )
SlLikeyIStrDrop: dropped slot 0
db_con_commit (con_da={R/3,0,0},th_commit=1,tx=1,hold_cursor=1)
-->DbSlModify(con=0, ss_p=bc8160, op=-1828885524, da_p=bc8180)
 DbSlModify() --> 13=DBSL_ERR_STMTID
-->DbSlPrepare(con=0, ss_p=bc8160, op=DBSL_INSERT, da_p=bc8180)
 time 2013.02.23. 09:58:18
-->oci_prepare_stmt(con=0, len=123, stp=13e06c8); AI=,0,,
 INSERT INTO DDLOG (SEQNUMBER, TIMESTAMP, SYSTEMID, NBLENGTH, NOTEBOOK) VALUES ( DDLOG_SEQ.NEXTVAL, :A0 , :A1 , :A2 , :A3 )

DbSlPrepare(lit=0, lob=0, fae=0, col=4, mrk=4) --> 0=DBSL_ERR_OK
-->DbSlModify(con=0, ss_p=bc8160, op=-1828885524, da_p=bc8180)
 DbSlModify(): table='DDLOG'
In 00: DBSL_DATA_SHORT_CHAR (len=28, max=28, dec=0)
In 01: DBSL_DATA_SHORT_CHAR (len=44, max=44, dec=0)
In 02: DBSL_DATA_INTEGER_2 (len=2, max=2, dec=0)
In 03: DBSL_DATA_LONG_RAW (len=32000, max=32000, dec=0)
bind_type_and_length(): 4 input variables given
- oci_bind ( 0: SQLT_AFC , l= 28, con=0, stp=13e06c8, progv=13583e0, indp=13583a8,rlen=13583c8,rcode=(nil))
- oci_bind ( 1: SQLT_AFC , l= 44, con=0, stp=13e06c8, progv=1358450, indp=13583b0,rlen=13583d0,rcode=(nil))
- oci_bind ( 2: SQLT_INT , l= 4, con=0, stp=13e06c8, progv=1358398, indp=13583b8,rlen=(nil),rcode=(nil))
- oci_bind ( 3: SQLT_LBI , l=32002, con=0, stp=13e06c8, progv=1358500, indp=13583c0,rlen=13583d8,rcode=(nil))
exec_modify(): bulk=0, input_cnt=4, literal_cnt=0, fae_cnt=0
 time 2013.02.23. 09:58:18
-->oci_execute_stmt(con=0, stp=13e06c8, iters=1, rowoff=0, dml_batch_err=0)
before OCIStmtExecute(svchp=1256550, errhp=1256630): [dur. 0,000s]
 OCIStmtExecute() failed with -1=OCI_ERROR
 SQL error 2289:
 ORA-02289: sequence does not exist
after OCIStmtExecute(rpc=0): [dur. 0,002s]
<--oci_execute_stmt(rc=2289, rows processed 0, iters-errors = 1-0) [dur. 0,002s]
*** ERROR => Error 2289 in stmt_execute() from oci_execute_stmt(), orpc=0
[dbsloci.c 16180]
*** ERROR => ORA-02289 occurred when executing SQL stmt (parse error offset=80)
[dbsloci.c 16181]
sc_p=11ac2e8,no=8,idc_p=11c3f60,con=0,act=1,slen=123,smax=256,#vars=4,stmt=1400ab8,table=DDLOG
INSERT INTO DDLOG (SEQNUMBER, TIMESTAMP, SYSTEMID, NBLENGTH, NOTEBOOK) VALUES ( DDLOG_SEQ.NEXTVAL, 😕
A0 , :A1 , :A2 , :A3 ) ;
 set_ocica() -> SQL error code 2289
-->oci_get_errmsg (con=0, rc=2289)
 OCIErrorGet -> SQL error code: 2289
 ORA-02289: sequence does not exist
 stmt_execute() -> orc=2289, rc=99=DBSL_ERR_DB
 exec_modify() -> 99=DBSL_ERR_DB
error 99 in exec_modify()
sc_p=11ac2e8,no=8,idc_p=11c3f60,con=0,act=1,slen=123,smax=256,#vars=4,stmt=1400ab8,table=DDLOG
Statement cache: sc=11ac2e8, upsert_sc=(nil), oci_stp=13e06c8
prepared=0, literal_cnt=0, native_sql=0, lob_ret_cnt=0, fae_cnt=0, xop=1, dbcount=0
IN : col_cnt=4, row_max=1, row_xcnt=1, row_pcnt=0, row_i=0, row_total=1,
 row_upto=4294967295, row_size=32078, vda_max=32, bound=1, itp=12dcf98, vda_arr=1402e98
 lob_cnt=0, lob_max=0, lob_pw_cnt=0, lob_arr=(nil), rows_ret=0
OUT: col_cnt=0, row_max=0, row_xcnt=0, row_pcnt=0, row_i=0, row_total=0,
 row_upto=0, row_size=0, vda_max=0, bound=0, itp=(nil), vda_arr=(nil)
 lob_cnt=0, lob_max=0, lob_pw_cnt=0, lob_arr=(nil), rows_ret=0
INSERT INTO DDLOG (SEQNUMBER, TIMESTAMP, SYSTEMID, NBLENGTH, NOTEBOOK) VALUES ( DDLOG_SEQ.NEXTVAL, 😕
A0 , :A1 , :A2 , :A3 ) ;
 DbSlModify() --> 99=DBSL_ERR_DB
***LOG BY4=> sql error 2289 performing INS on table DDLOG [dbsynseq 336]
***LOG BY0=> ORA-02289: sequence does not exist [dbsynseq 336]
db_syflush2 (TRUE) failed
db_con_commit received error 1024 in before-commit action, returning 8
*** ERROR => SlicLikeyInsertRecord: db_commit98 failed rc=1024 [sliclikey.c 501]
likeyper_insert_record ("0002LK0003P3D0011Q06935196090013NetWeaver_ORA", "001021474836470001T0024+LJTDwMm7OGpfDuZPsvIJA==00100000000000000820130223000820130524001800000
00000000000000000") returns 1.

Thanks,

Mahendar

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

Former Member — Sat, 23 Feb 2013 12:58:36 GMT

Hi,

It seems that the sequence is not created properly.

Please perform the following.

1. Truncate the table DDLOG.

2. Create the sequence.

3.commit the transaction using commit statement in SQL.

4.Restart the DB & SAPINST

I hope it should work now.

Please check and provide your feedback.

Thanks and Regards,

vimal

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

Former Member — Mon, 25 Feb 2013 07:14:51 GMT

Hi Vimal,

I did perfomed the below; but the same error I am getting.

The thing is I am installing PI on running ECC.

SQL> drop sequence ddlog_seq;

Sequence dropped.

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

Sequence created.

SQL> commit;

Commit complete.

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup;

Thanks,

Mahendar

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

Former Member — Mon, 25 Feb 2013 07:57:49 GMT

Hi,

Now I am getting the below error:

ERROR 2013-02-25 07:08:24.883 [sixxcstepexecute.cpp:937]

FCO-00011 The step createTempLicense with step key |NW_Doublestack_CI|ind|ind|ind|ind|0|0|NW_CI_Instance|ind|ind|ind|ind|ci|0|NW_CI_Instance_ABAP_Reports|ind|ind|ind|i

nd|auto.id:3|0|createTempLicense was executed with status ERROR ( Last error reported by the step: Process call '/usr/sap/P3D/SYS/exe/uc/linuxx86_64/saplikey pf=/usr/sa

p/P3D/SYS/profile/P3D_DVEBMGS03_lxv2036 -install_first_temp Q0693519609 XXXXXX' exits with error code 2. For details see log file(s) saplikey.log, dev_slic.).

saplikey & saplicence files showing

Thanks,

Mahendar

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

Former Member — Mon, 25 Feb 2013 08:11:00 GMT

Hi,

Can you please attach saplikey.log?

Thanks and Regards,

Vimal

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

Former Member — Mon, 25 Feb 2013 08:14:07 GMT

Hi,

please find the below.

saplikey.log

Thanks,

Mahendar

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

Former Member — Mon, 25 Feb 2013 08:21:29 GMT

There is no information from the log.

Please attach the last 1000 lines of sapinst_dev.log

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

Former Member — Mon, 25 Feb 2013 08:27:16 GMT

account user="p3dadm" uid="12036" exists with parameter gid="20166"

TRACE      2013-02-25 07:28:57.151 [syuxcuser.cpp:701]
           PSyGroupImpl CSyUserImpl::getPrimaryGroup()const
           lib=syslib module=syslib
account user="p3dadm" uid="12036" exists with parameter gid="20166"

TRACE 2013-02-25 07:28:57.167 [syuxctask.cpp:276]
CChildApplicationImpl::doStart() lib=syslib module=syslib
A child process has been started. Pid = 16380

TRACE 2013-02-25 07:28:57.171
FSPath(/usr/sap/P3D/SYS/exe/uc/linuxx86_64/saplikey) done

TRACE 2013-02-25 07:28:57.171
ChildApplication(/usr/sap/P3D/SYS/exe/uc/linuxx86_64/saplikey).start() done: true

TRACE 2013-02-25 07:28:57.172
FSPath(/usr/sap/P3D/SYS/exe/uc/linuxx86_64/saplikey) done

INFO 2013-02-25 07:28:57.174
CJSlibModule::writeInfo_impl()
Output of /usr/sap/P3D/SYS/exe/uc/linuxx86_64/saplikey pf=/usr/sap/P3D/SYS/profile/P3D_DVEBMGS03_lxv2036 -install_first_temp Q0693519609 XXXXXX is written to the logfile saplikey.log.

TRACE 2013-02-25 07:28:58.615
FSPath(/usr/sap/P3D/SYS/exe/uc/linuxx86_64/saplikey) done

TRACE 2013-02-25 07:28:58.615
ChildApplication(/usr/sap/P3D/SYS/exe/uc/linuxx86_64/saplikey).getReturnCode(true)

TRACE      2013-02-25 07:28:58.616 [syuxctask.cpp:878]
           CUnixProcessManager::sap_waitpid(pid_t pid, int * pStatus, int options)
           lib=syslib module=syslib
Child process 16380 returned 2

TRACE 2013-02-25 07:28:58.617
FSPath(/usr/sap/P3D/SYS/exe/uc/linuxx86_64/saplikey) done

TRACE 2013-02-25 07:28:58.617
ChildApplication(/usr/sap/P3D/SYS/exe/uc/linuxx86_64/saplikey).getReturnCode() done: 2

TRACE 2013-02-25 07:28:58.619
FSPath(/usr/sap/P3D/SYS/exe/uc/linuxx86_64/saplikey) done

TRACE 2013-02-25 07:28:58.619
ChildApplication(/usr/sap/P3D/SYS/exe/uc/linuxx86_64/saplikey).getStatus()

TRACE 2013-02-25 07:28:58.620
FSPath(/usr/sap/P3D/SYS/exe/uc/linuxx86_64/saplikey) done

TRACE 2013-02-25 07:28:58.621
ChildApplication(/usr/sap/P3D/SYS/exe/uc/linuxx86_64/saplikey).getStatus() done: TST_FINISHED

TRACE 2013-02-25 07:28:58.622
FSPath(/usr/sap/P3D/SYS/exe/uc/linuxx86_64/saplikey) done

WARNING 2013-02-25 07:28:58.623
CJSlibModule::writeWarning_impl()
Execution of the command "/usr/sap/P3D/SYS/exe/uc/linuxx86_64/saplikey pf=/usr/sap/P3D/SYS/profile/P3D_DVEBMGS03_lxv2036 -install_first_temp Q0693519609 XXXXXX" finished with return code 2. Output:
SAP License Key Administration - Copyright (C) 2003 - 2007 SAP AG

TRACE 2013-02-25 07:28:58.624
FSPath(/usr/sap/P3D/SYS/exe/uc/linuxx86_64/saplikey) done

TRACE 2013-02-25 07:28:58.624
ChildApplication(/usr/sap/P3D/SYS/exe/uc/linuxx86_64/saplikey).run(): 2. done.

TRACE 2013-02-25 07:28:58.625
FSPath(/usr/sap/P3D/SYS/exe/uc/linuxx86_64/saplikey) done

TRACE 2013-02-25 07:28:58.626
ChildApplication(/usr/sap/P3D/SYS/exe/uc/linuxx86_64/saplikey).runAs() done

TRACE 2013-02-25 07:28:58.627
FSPath(/usr/sap/P3D/SYS/exe/uc/linuxx86_64/saplikey) done

TRACE 2013-02-25 07:28:58.627
Function setMessageIdOfExceptionMessage: nw.processError

ERROR 2013-02-25 07:28:58.628
CJSlibModule::writeError_impl()
CJS-30023 Process call '/usr/sap/P3D/SYS/exe/uc/linuxx86_64/saplikey pf=/usr/sap/P3D/SYS/profile/P3D_DVEBMGS03_lxv2036 -install_first_temp Q0693519609 XXXXXX' exits with error code 2. For details see log file(s) saplikey.log, dev_slic.

TRACE 2013-02-25 07:28:58.628 [iaxxejsbas.hpp:503]
EJS_Base::dispatchFunctionCall()
JS Callback has thrown unknown exception. Rethrowing.

TRACE 2013-02-25 07:28:58.649 [syuxctask.cpp:276]
CChildApplicationImpl::doStart() lib=syslib module=syslib
A child process has been started. Pid = 16385

TRACE      2013-02-25 07:28:58.669 [syuxctask.cpp:878]
           CUnixProcessManager::sap_waitpid(pid_t pid, int * pStatus, int options)
           lib=syslib module=syslib
Child process 16385 returned 0

TRACE 2013-02-25 07:28:58.683 [syuxctask.cpp:276]
CChildApplicationImpl::doStart() lib=syslib module=syslib
A child process has been started. Pid = 16386

TRACE      2013-02-25 07:28:58.704 [syuxctask.cpp:878]
           CUnixProcessManager::sap_waitpid(pid_t pid, int * pStatus, int options)
           lib=syslib module=syslib
Child process 16386 returned 0

ERROR 2013-02-25 07:28:58.768 [sixxcstepexecute.cpp:937]
FCO-00011 The step createTempLicense with step key |NW_Doublestack_CI|ind|ind|ind|ind|0|0|NW_CI_Instance|ind|ind|ind|ind|ci|0|NW_CI_Instance_ABAP_Reports|ind|ind|ind|ind|auto.id:3|0|createTempLicense was executed with status ERROR ( Last error reported by the step: Process call '/usr/sap/P3D/SYS/exe/uc/linuxx86_64/saplikey pf=/usr/sap/P3D/SYS/profile/P3D_DVEBMGS03_lxv2036 -install_first_temp Q0693519609 XXXXXX' exits with error code 2. For details see log file(s) saplikey.log, dev_slic.).

TRACE 2013-02-25 07:28:58.804 [kdxxctaco.cpp:225]
CKdbTableContainerImpl::syncToContainerFile lib=iakdblib
CKdbTableContainerImpl::syncToContainerFile start ...

TRACE 2013-02-25 07:28:59.131 [kdxxctaco.cpp:257]
CKdbTableContainerImpl::syncToContainerFile lib=iakdblib
after creating out stream

TRACE 2013-02-25 07:28:59.248 [kdxxctaco.cpp:291]
CKdbTableContainerImpl::syncToContainerFile lib=iakdblib
CKdbTableContainerImpl::syncToContainerFile stop ...

TRACE      2013-02-25 07:28:59.286 [syxxcfile.cpp:123]
           CSyFileImpl::decideIfMoveCopyNode(const CopyMoveDestinationInfo & {m_nodeTypeForCombiCheck: ..., m_path: /tmp/sapinst_instdir/NW73/INSTALL/NW73/ORA/DISTRIBUTED/PI/APP1/__instana_tmp.33.xml, m_realNodeType: 8}, ISyNode::CopyMoveMode_t 0x3, PSyNodeInt &) const
           lib=syslib module=syslib
Target node does not exist and (mode & ISyNode::MISSING) ==> I will copy/move.

TRACE      2013-02-25 07:28:59.286 [syxxcnode.cpp:454]
           CSyNodeImpl::move(const CSyPath & /tmp/sapinst_instdir/NW73/INSTALL/NW73/ORA/DISTRIBUTED/PI/APP1/__instana_tmp.33.xml, ISyNode::CopyMoveMode_t 0x3)
           lib=syslib module=syslib
Moved /tmp/sapinst_instdir/NW73/INSTALL/NW73/ORA/DISTRIBUTED/PI/APP1/__instana_tmp.xml to /tmp/sapinst_instdir/NW73/INSTALL/NW73/ORA/DISTRIBUTED/PI/APP1/__instana_tmp.33.xml

INFO 2013-02-25 07:28:59.289 [syuxcpath.cpp:471]
CSyPath::createFile() lib=syslib module=syslib
Creating file /tmp/sapinst_instdir/NW73/INSTALL/NW73/ORA/DISTRIBUTED/PI/APP1/__instana_tmp.xml.

TRACE 2013-02-25 07:28:59.305 [syuxctask.cpp:276]
CChildApplicationImpl::doStart() lib=syslib module=syslib
A child process has been started. Pid = 16387

TRACE      2013-02-25 07:28:59.325 [syuxctask.cpp:878]
           CUnixProcessManager::sap_waitpid(pid_t pid, int * pStatus, int options)
           lib=syslib module=syslib
Child process 16387 returned 0

TRACE 2013-02-25 07:28:59.339 [syuxctask.cpp:276]
CChildApplicationImpl::doStart() lib=syslib module=syslib
A child process has been started. Pid = 16388

TRACE      2013-02-25 07:28:59.361 [syuxctask.cpp:878]
           CUnixProcessManager::sap_waitpid(pid_t pid, int * pStatus, int options)
           lib=syslib module=syslib
Child process 16388 returned 0

TRACE 2013-02-25 07:29:01.651
SAPInst calls the LogInquirer. The output of the LogInquirer can be found in file sapinst_loginquirer.log.

TRACE 2013-02-25 07:29:08.875 [iaxxgenimp.cpp:699]
CGuiEngineImp::showMessageBox

TRACE 2013-02-25 07:29:08.879 [iaxxgenimp.cpp:1248]
CGuiEngineImp::acceptAnswerForBlockingRequest
Waiting for an answer from GUI

INFO 2013-02-25 07:42:58.509 [sixxcstepexecute.cpp:1028]
An error occured and the user decided to stop.\n Current step "|NW_Doublestack_CI|ind|ind|ind|ind|0|0|NW_CI_Instance|ind|ind|ind|ind|ci|0|NW_CI_Instance_ABAP_Reports|ind|ind|ind|ind|auto.id:3|0|createTempLicense".

TRACE      2013-02-25 07:43:01.439 [syuxccuren.cpp:306]
           CSyCurrentProcessEnvironmentImpl::setEffectiveGroup(PSyGroupInt)
           lib=syslib module=syslib
effective group already set. Nothing to do.

TRACE      2013-02-25 07:43:01.625 [syuxcuser.cpp:701]
           PSyGroupImpl CSyUserImpl::getPrimaryGroup()const
           lib=syslib module=syslib
account user="root" uid="0" exists with parameter gid="0"

TRACE      2013-02-25 07:43:01.626 [syuxccuren.cpp:266]
           CSyCurrentProcessEnvironmentImpl::setEffectiveUser(PSyUserInt, const iastring&)
           lib=syslib module=syslib
effective user already set. Nothing to do.

INFO       2013-02-25 07:43:01.626 [syuxccuren.cpp:562]
           CSyCurrentProcessEnvironmentImpl::setWorkingDirectory(const CSyPath& /tmp/sapinst_instdir/NW73/INSTALL/NW73/ORA/DISTRIBUTED/PI/APP1)
           lib=syslib module=syslib
Working directory changed to /tmp/sapinst_instdir/NW73/INSTALL/NW73/ORA/DISTRIBUTED/PI/APP1.

TRACE      2013-02-25 07:43:01.626 [syuxccuren.cpp:128]
           CSyCurrentProcessEnvironmentImpl::setUmask(ulong)
           lib=syslib module=syslib
umask set to 23

TRACE      2013-02-25 07:43:01.629 [syuxccuren.cpp:613]
           CSyCurrentProcessEnvironmentImpl::removeEnvironmentVariable(iastring)
           lib=syslib module=syslib
Removed environment variable 'SYSLIB_SWITCH_ONLY_EFFECTIVE_ACCOUNT' from current process environment.

TRACE      2013-02-25 07:43:01.663 [syxxcfile.cpp:123]
           CSyFileImpl::decideIfMoveCopyNode(const CopyMoveDestinationInfo & {m_nodeTypeForCombiCheck: ..., m_path: /tmp/sapinst_instdir/.lastInstallationLocation.7, m_realNodeType: 8}, ISyNode::CopyMoveMode_t 0x3, PSyNodeInt &) const
           lib=syslib module=syslib
Target node does not exist and (mode & ISyNode::MISSING) ==> I will copy/move.

TRACE      2013-02-25 07:43:01.664 [syxxcnode.cpp:454]
           CSyNodeImpl::move(const CSyPath & /tmp/sapinst_instdir/.lastInstallationLocation.7, ISyNode::CopyMoveMode_t 0x3)
           lib=syslib module=syslib
Moved /tmp/sapinst_instdir/.lastInstallationLocation to /tmp/sapinst_instdir/.lastInstallationLocation.7

INFO 2013-02-25 07:43:01.665 [syuxcpath.cpp:471]
CSyPath::createFile() lib=syslib module=syslib
Creating file /tmp/sapinst_instdir/.lastInstallationLocation.

TRACE 2013-02-25 07:43:03.666 [syuxctask.cpp:1115]
CSyTaskImpl::cancel() lib=syslib module=syslib
sending SIGKILL to process with id 15348

INFO 2013-02-25 07:43:03.667 [syuxctask.cpp:1122]
CSyTaskImpl::cancel() lib=syslib module=syslib
Cancelled task 0.

TRACE      2013-02-25 07:43:03.673 [syuxctask.cpp:878]
           CUnixProcessManager::sap_waitpid(pid_t pid, int * pStatus, int options)
           lib=syslib module=syslib
Child process 15348 terminated by signal 9

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

Former Member — Mon, 25 Feb 2013 09:01:29 GMT

Thanks..

Please attach the dev_slic log... it seems to be an index problem...

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

Former Member — Mon, 25 Feb 2013 09:23:33 GMT

Hi Vimal,

There is no log abailable for dev_slic..

Thanks,

Mahendar

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

former_member297883 — Mon, 08 Dec 2014 15:20:16 GMT

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

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

former_member219299 — Sat, 12 Mar 2016 17:10:56 GMT

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