Errors when starting task for the first time - logstream to Oracle database. Insufficient privileges

[PapaC]

00000336: 2022-07-21T16:08:59 [TASK_MANAGER ]I: Task error notification received from subtask 1, thread 1, status 1020414 (replicationtask.c:3464)

00003888: 2022-07-21T16:08:59 [TARGET_LOAD ]E: ORA-00604: error occurred at recursive SQL level 1 ORA-01031: insufficient privileges [1022307] (oracle_endpoint_load.c:1598)

00003888: 2022-07-21T16:08:59 [TARGET_LOAD ]E: Direct Path error [1022307] (oracle_endpoint_load.c:1598)

00003888: 2022-07-21T16:08:59 [TARGET_LOAD ]E: Endpoint is disconnected [1020414] (endpointshell.c:3976)

00003888: 2022-07-21T16:08:59 [TARGET_LOAD ]E: Error executing data handler [1020414] (streamcomponent.c:2001)

00003888: 2022-07-21T16:08:59 [TASK_MANAGER ]E: Stream component failed at subtask 1, component st_1_ITO_Material_Status1 [1020414] (subtask.c:1396)

00003888: 2022-07-21T16:08:59 [TARGET_LOAD ]E: Stream component 'st_1_ITO_Material_Status1' terminated [1020414] (subtask.c:1565)

I have issued the following grants per: https://help.qlik.com/en-US/replicate/May2022/Content/Replicate/Main/Oracle/security_req_oracle_targ...

GRANT SELECT ON SYS.ALL_CONSTRAINTS TO USER;
GRANT SELECT ON SYS.ALL_CONS_COLUMNS TO USER;
GRANT SELECT ON SYS.ALL_INDEXES TO USER;
GRANT SELECT ON SYS.ALL_IND_COLUMNS TO USER;

GRANT ALTER ANY TABLE TO USER;
GRANT CREATE ANY INDEX TO USER;
GRANT CREATE ANY TABLE TO USER;
GRANT DELETE ANY TABLE TO USER;
GRANT DROP ANY TABLE TO USER;
GRANT INSERT ANY TABLE TO USER;
GRANT SELECT ANY TABLE TO USER;
GRANT UPDATE ANY TABLE TO USER;

Any ideas on what I might be missing?

[lyka · Accepted solution]

Hello,

Can you try with unchecking "Use direct path full load" on the advanced tab of the oracle endpoint

Also i've seen a similar issue and the fix was to grant LOCK ANY TABLE to ATTREP;

It seems the permissions which are missing from the TARGET (not SOURCE):

Thanks

Lyka

[PapaC]

That worked!  It performed the Full Load.  But, instead of writing to the table that I had already created, it created another table.  Is there a reason that it did not use the existing table?

[PapaC]

My error!  I found that I had entered the table name in mixed case in the Table Name field.  It is now loading the correct table. 

Thanks for much for the help!

[lyka]

Hello,

Im glad that worked out for you 🙂

Thanks

Lyka