topic Re: Qlikview Failed Task in QlikView

Qlikview Failed Task

Eren_yaeger — Fri, 15 Nov 2024 22:00:32 GMT

Hi all,

Tasks is failing with the below error,

"Error: Connector Reply error: Sql##f- sql state: s1000, :Error code 35 Error msg: [Simba ][Hardy](35) Error From server: Error code: 0

Error msg: 'Error running query: java.lang.SecurityException: User does not have permission SELECT on table '

Anyone knows how to resolve it?

Re: Qlikview Failed Task

Ray_Strother — Thu, 06 Oct 2022 18:55:55 GMT

Hello ,

1. Had this query worked prior?
2. were there any changes , such as addition of new fields in the database?
3. Can you make the query from the Qlikview server, using the service account, using a third party query tool?
4. Confirm the account used has the appropriate permissions on the database.

Re: Qlikview Failed Task

Eren_yaeger — Fri, 07 Oct 2022 05:12:07 GMT

Yes query was ran prior.. no changes in database..we were using admin account. But not getting the exact solution

Re: Qlikview Failed Task

Chip_Matejowsky — Mon, 10 Oct 2022 19:09:02 GMT

Hi @Eren_yaeger,

The error being returned, Error code 35 Error msg: [Simba ][Hardy](35) Error From server: Error code: 0, is from the source data and is not a QlikView error per se. The QlikView log is displaying what it received from the source. A Google search on term "Hardy](35) Error From server: Error code: 0" returns that is cause is likely due to permissions on the table. Suggest that you contact your DBA for further assistance or contact the connector/driver vendor for support.

Best Regards

Re: Qlikview Failed Task

KenAdams — Tue, 11 Oct 2022 01:25:10 GMT

Thanks Chip....!