The Source Document was NOT reloaded successfully, what it means?

[#1]

Hi

Can someone tell me why this error comes ?

Error      The Source Document was NOT reloaded successfully. DocumentPath=\\development\Documents\ part 1.qvw.

11/28/2011 06:02:23     Information        Initializing Reload (0), Finished (141008)

11/28/2011 06:02:23      Error Reload failed.

11/28/2011 06:02:23      Information Closing the document.

11/28/2011 06:02:23      Information        Closed the QlikView Engine successfully. ProcessID=13332

11/28/2011 06:02:23      Information        Initializing (0), Finished (141)

11/28/2011 06:02:23      Error Reload failed. Distribution skipped.

11/28/2011 06:02:23      Error      The task " part 1.qvw" failed. ErrorCount=3

Br

Avantika

[SunilChauhan]

go to source document and see the log file which is at same location as qlikview ddocument .

if not then open qv application and go to document properties-> select genrate logfile.

then reload .it will create one log file at souce document folder with the name applicationname.qvw.log.

see the log file and trace the error .

hope this may help

[Miguel_Angel_Baeyens]

Hi,

According to the first line of the log you post, it seems that the file " part 1.qvw" has some issues when reloading. Make sure the ODBC drivers if any, and the paths in the document are all right to be reloaded from the Server, not only manually. Anyway, try to reload it opening the file locally in the Server and see what happens. Go to the Settings menu, Document Properties and click on Generate Logfile, then save and quit. The log file will be created anytime the document is reloaded, either manually or from the Server, so you can narrow down where the problem is.

Hope that helps.

Miguel

[#4]

Hi Sunil

at the same location, where document is present I am able to see only document log.

and I did not find any difference.

Br

Avantika

[SunilChauhan]

can you attched the log file which at same location of .qvw file?

[#6]

I just found this error :

11/29/2011 9:35:43 AM:       Error: ErrorSource: OraOLEDB, ErrorMsg: ORA-00942: table or view does not exist

11/29/2011 9:35:43 AM:       General Script Error

11/29/2011 9:35:43 AM:       Execution Failed

11/29/2011 9:35:43 AM:      Execution finished.

[#7]

I just found this error :

11/29/2011 9:35:43 AM:       Error: ErrorSource: OraOLEDB, ErrorMsg: ORA-00942: table or view does not exist

11/29/2011 9:35:43 AM:       General Script Error

11/29/2011 9:35:43 AM:       Execution Failed

11/29/2011 9:35:43 AM:      Execution finished.

[SunilChauhan]

general script is due to one of following reason

Connection is not proper-> create connection again areload

Group By-> check weither it required some where.

syntax is missing

check your code in qlikview application

hope this helps

[Miguel_Angel_Baeyens]

Hi,

Do a debug load instead of a reload, and check where the script fails extracting data from the database. Although it does not name the table or view that is not readable, the error message is clear enough to say that QlikView cannot read the source (because of permissions or because in the production environment the table or view used in the SQL SELECT doesn't really exist).

Hope that helps.

Miguel

[#10]

yes, I too feel so. Its related to DB.

Certain privileges may be required to access the table. If an application returned this message, the table the application tried to access does not exist in the database, or the application does not have access to it.