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

Announcements
Discover how organizations are unlocking new revenue streams: Watch 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.