10 Replies Latest reply: Jul 20, 2012 2:10 PM by Rajni Batra RSS

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

      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

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

          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

          • The Source Document was NOT reloaded successfully, what it means?
            Miguel Angel Baeyens de Arce

            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

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

                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.

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

                    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

                    • The Source Document was NOT reloaded successfully, what it means?
                      Miguel Angel Baeyens de Arce

                      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

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

                          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.

                            • Re: The Source Document was NOT reloaded successfully, what it means?
                              Rajni Batra

                              Hello Kindly help me my appliaction getting reloaded manually but failed during reload schedular.

                              it shows Source document not found

                              7/20/2012 12:02:00.2068293InformationStarting task 'Stage 1/Stage 1 Profir Center.qvw'. Id:2391083c-4a8d-4212-8a4a-ceaf59aca752. Triggered by 'ScheduleTrigger'. Id:5802ad55-4433-4bb6-b0c6-958d7bc9e95d
                              7/20/2012 12:02:00.2224293InformationEntering Task Execution.
                              7/20/2012 12:02:00.2224293InformationClusterID=1
                              7/20/2012 12:02:00.2224293InformationQDSID=ac0ccb08-4acc-9645-c813-105d73e3c98b
                              7/20/2012 12:02:00.2224293InformationTaskID=2391083c-4a8d-4212-8a4a-ceaf59aca752
                              7/20/2012 12:02:00.2224293InformationMaxRunTime=06:00:00
                              7/20/2012 12:02:00.2224293InformationMax attempts:1
                              7/20/2012 12:02:00.2224293InformationCurrent Attempt=0
                              7/20/2012 12:02:00.2380293InformationTask Dependencies are OK
                              7/20/2012 12:02:00.3784293ErrorThe task "Stage 1/Stage 1 Profir Center.qvw" failed. Exception:

                              QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.SourceDocumentNotFoundException: Could not find SourceDocument (Distribution): qvp://aedcapp11/Stage 1/Stage 1 Profir Center.qvw

                                 at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

                                 --- End of inner exception stack trace ---

                                 at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

                                 at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

                              7/20/2012 12:02:00.4096293InformationTask Execute Duration=00:00:00.1872000
                              7/20/2012 12:02:00.4252293InformationTaskResult.status=Finished
                              7/20/2012 12:02:00.4252293InformationNotifying all triggers of new state:FinishedWithErrors
                              7/20/2012 12:02:00.4252293InformationNotifying all triggers of new state:FinishedWithErrors - completed
                              7/20/2012 12:02:00.4408293Information

                              Saving Task Result

                               

                               

                               

                               

                               

                              Regards,

                              Rajni