Skip to Content
avatar image
Former Member

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Apr 13, 2016 at 11:58 AM

    Hi Lucia,

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

    Regards

    BJ


    sybase_7.png (88.1 kB)
    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi, Brillion,

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

      Best,

      Lucía.