cancel
Showing results for 
Search instead for 
Did you mean: 

Unusual role Error replicating Oracle nonSAP DB

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member252769
Active Participant
0 Kudos

Hi Lucia,

Please make sure that DB user in Oracle should have required authorizations to create triggers.

Regards

BJ

Former Member
0 Kudos

Hi, Brillion,

Thanks but the user was granted all possible roles an permissions to rule privilege issues out.

Best,

Lucía.