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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Unable to read the data from the Database

For my report I fetch the data from the Database.

I was using the same database more than six month.

Suddenly now when I try to reload my report form the same database its not refreshing the data properly .

I tried reloading it manually, It throwed an error as below.

"SQL error: no error

Script Line: select feilds from the databse table name.

Could anyone please help me out.

5 Replies
Miguel_Angel_Baeyens

It seems to be an scripting problem. I'm guessing but are you reading from a table or from a view? If so, do you have permissions enough to read? Have you changed anything in your data source? Have you changed the code of your load script?

Not applicable
Author

Is there a username/password combination in your connection string and is it up to date?

Was something like a virus killer installed on the database server or on the QV server?

Not applicable
Author

I am reading from the same database table.

I have and use the same permissions,have not changed any datasource name and load script.

Not applicable
Author

Could you please tell me how a Virus killer in database can affect the information to be fetched.

Not applicable
Author

This was something we stumbled on to in QV 8.5

McAfee uses a port that is also used by the QV Server. That means that a connection from the outside can fail. Of course there is a solution around it.

But that would only be a factor when you try to access your QV documents from the outside, not when you already have the document and are having issues with loading data. So it's indeed not a factor in your problem.