Skip to main content
Announcements
UPGRADE ADVISORY for Qlik Replicate 2024.5: Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
PapaC
Contributor II

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

 
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)
 
 

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?

Labels (2)
1 Solution

Accepted Solutions
lyka
Support

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

 

 

View solution in original post

4 Replies
lyka
Support

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
Contributor II
Author

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
Contributor II
Author

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
Support

Hello,

 

Im glad that worked out for you 🙂

 

Thanks

Lyka