Skip to Content
0

SEQ error after upgrade to DMIS SP11

Feb 09 at 08:53 PM

32

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Andrey Martynov
Feb 21 at 11:59 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded