Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Unusual role Error replicating Oracle nonSAP DB

Hi,

We are trying to replicate data from a nonSAP Oracle 11g database and are getting the following error:

Failed to create triggers for table TABLE_NAME  with logging table /1CADMC/TABLENUMBER

ORA-01917: user or role '' does not exist

When looking at the error log, we see that it is trying to execute a CREATE SEQUENCE statement:

C  *** ERROR => Error 1917 in exec_immediate() from oci_execute_stmt(), orpc=0

[dbsloci.c    13569]

C  {root-id=0050569737A81EE6809D7340A73079BF}_{conn-id=00000000000000000000000000000000}_0

C  *** ERROR => ORA-01917 occurred at SQL stmt (parse error offset=16)

[dbsloci.c    13570]

C  {root-id=0050569737A81EE6809D7340A73079BF}_{conn-id=00000000000000000000000000000000}_0

C  Dump statement cache (after SQL error):

C  sc_p=00000000099617E8,no=229,idc_p=0000000000000000,con=3,act=0,slen=97,smax=1280,#vars=0,stmt=0000000019CF9BB0,table=

C  CREATE SEQUENCE "SCHEMA_NAME"."SEQ_/1CADMC/V0001330" START WITH 1 INCREMENT BY 1 CACHE   100 ORDER;

C     statement (len=97) for table '                              ':

C         CREATE SEQUENCE "SCHEMA_NAME"."SEQ_/1CADMC/V0001330" START WITH 1 INCREMENT BY 1 CACHE   100 ORDER

C     exec_immediate() -> orc=1917, 99=DBSL_ERR_DB

C  head_p=0000000002117970, cid=0: dbsl err=99=DBSL_ERR_DB-> dbds err=1=DS_SQLERR,dbdsoci.c:1011

C  *** ERROR => ^^ Ds_exec_imm() -> err=1=DS_SQLERR

And then the connection is terminated. We tried enabling trace on Oracle's side with no luck. Any clues to what it is trying to do or how to figure it out without looking at the Oracle trace?

Thank you in advance!

Lucía.

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question