cancel
Showing results for 
Search instead for 
Did you mean: 

SEQ error after upgrade to DMIS SP11

AndyBent
Explorer
0 Kudos

I upgraded to DMIS SP11 and applied all notes recommended in the master note.


Replicating an Oracle non-abap source to HANA target. Existing replication is working and loading records. When I try to replicate a new table I get an error about object already exists

check2: OCIStmtExecute() failed with -1=OCI_ERROR
SQL error 955:
statement (len=98) for table ' ':
CREATE SEQUENCE <name>."SEQ_/1CADMC/V0001103" START WITH 1 INCREMENT BY 1 CACHE 1000 ORDER
exec_immediate() -> orc=955, 102=DBSL_ERR_DBOBJECT_EXISTS
head_p=7ffe3c85cd20, cid=0: dbsl err=102=DBSL_ERR_DBOBJECT_EXISTS-> dbds err=1024=DS_DBOBJECTEXISTS,dbdsoci.c:1011
*** ERROR => ^^ Ds_exec_imm() -> err=1024=DS_DBOBJECTEXISTS

Earlier in the log it looks for these objects

/1CADMC/00001103
/1CADMC/S0001103
/1CADMC/L0001103

But I don't see where it is checking for /1CADMC/V0001103.

Thoughts?

Andy

Accepted Solutions (0)

Answers (1)

Answers (1)

Andrey_M
Advisor
Advisor
0 Kudos

Do you have a second SLT server?
Do you use the same source system as source in other SLT server?

It looks like your SLT system has already used this number. When you add a new table, this table get the next ID from number range that is already used for another table.
Check what is max number in source for tables like /1CADMC/*.
Check what is the next number in number range for object IUUC_SHDW - this number must be great as max number of table.

Best regards, Andrey