on 02-09-2018 8:53 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.