topic Re: Errors when starting task for the first time - logstream to Oracle database. Insufficient pri... in Qlik Replicate

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

PapaC — Thu, 21 Jul 2022 16:04:27 GMT

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_target.htm#Security%20requirements

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?

Re: Errors when starting task for the first time - logstream to Oracle database. Insufficient pri...

lyka — Thu, 21 Jul 2022 16:16:56 GMT

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

Re: Errors when starting task for the first time - logstream to Oracle database. Insufficient pri...

PapaC — Thu, 21 Jul 2022 17:06:53 GMT

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?

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

PapaC — Thu, 21 Jul 2022 17:09:30 GMT

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!

Re: Errors when starting task for the first time - logstream to Oracle database. Insufficient pri...

lyka — Thu, 21 Jul 2022 17:26:29 GMT

Hello,

Im glad that worked out for you 🙂

Thanks

Lyka