Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

DB table Access Issue

Hi,
I am using TOS 4.1.2 and have an AS400 connection. The connection is successful and I can retrieve the schema of the tables, however when I try to run a job that has one of AS400 tables as lookup/input, it fails, throws the following error.
Exception in component tAS400Input_2
java.sql.SQLException: Not authorized to object AUPRDDBF in QSYS type *FILE.
Do you have any idea why this is? I can access the particular table without any issues using otehr means so I don't think i have an access unless there is something that I need to do in TOS.
Thank for all your help.
Labels (3)
1 Reply
Anonymous
Not applicable
Author

Hi,
Are you sure your user can read this file? Did you have a look a the file's rights?