Reload fails

[Anonymous]

Hi all,

When  loading the data from database to Qlikview, reload fails on QMC. Everyday it reloads succesfully. But today reload fails on QMC.

I have checked in log file. Am getting below error msg

Error:Microsoft OLE DB Provider for SQL Server, ErrorMsg: Unspecified error occurred on SQL Server. Connection may have been terminated by the server.

Can anyone please help me on this?.

[jagan]

I think there is an issue at the database side when the dashboard reloading?  If you reload again it will be solved I think.

[Anonymous]

Hi Jagan,

Thanks for your reply. yes now its reloading. When i was trying to reload manually then also its not reloading. After four to five hours its started reloading again.

Regards,

Nisha.

[jagan · Accepted solution]

Check with your database team for the issue during that time. You can find

the reason from them easily.

On Jun 30, 2015 11:20 PM, "Nisha loganathan" <qcwebmaster@qlikview.com>

[Anonymous]

Hi Jagan,

Am checking with my DB team. But again same problem am facing today at same time on QMC. When am trying to load manually , it is showing the connected status as per below screenshot.

But Data is not started loading from database. Can you please suggest some solution. Could be issue in Qlikview or database?

Thanks,

Nisha.

[jagan]

HI,

May be the query taking more time to execute?  Run this query in the database and check how much time it is taking.

Regards,

jagan.

[Anonymous]

Hi Jagan,

Usually after connected, data will start to load within 2 secs in Qlikview.

Regards,

Nisha

[Anonymous]

Hi,

Am getting this error msg in QMC.

(2015-07-01 09:09:32) Warning: The QlikView Engine is Reloading, it will be killed (Please ignore logged warnings/errors about the kill).

(2015-07-01 09:09:32) Information: Killing the QlikView Engine. ProcessID=8020

(2015-07-01 09:09:32) Information: Reload was aborted.

(2015-07-01 09:09:32) Information: Killing a child process of the QlikView Engine. ProcessID=9076. ProcessName=qvconnect64

(2015-07-01 09:09:32) Information: Successfully killed a child process of the QlikView Engine. ProcessID=8020. ProcessName=qvb

(2015-07-01 09:09:32) Information: Closed the QlikView Engine successfully. ProcessID=8020

[pratap6699]

ya sometime retriving data is more then also it will occures...i think it is reload again the script problem will gone....

i have same type of problem occured in my project now that is every day night 12:00AM my script will be reloaded unfortunatly from last month 18,19,and 20 it was not reload but 21 to till now it was reloaded properly mai i know the reason...

thanking you in advance...