Skip to Content

SEQ error after upgrade to DMIS SP11

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 21 at 11:59 AM

    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

    Add comment
    10|10000 characters needed characters exceeded