10 Replies Latest reply: Feb 3, 2017 5:22 AM by Alvaro Urien Ayala RSS

    Load Script Error

      Hi Qlik Community,

       

      I have an app in QlikSense Desktop that I use to view daily information, from data in excel that I receive in a daily report. I am usually able to delete the old data, add in the new data file, and the app operates fine. The files have all the same headers and are around the same size, but the data changes everyday. Recently, I have been experiencing issues loading the new daily file. I receive an error message that says to go to the data load script to fix the error. In the data load script, I delete the old script, add in the new one and try again to upload my new data, with no success. I have had to go back and recreate the app to show the information I am looking for. Is anyone else having these issues or knows what I am doing wrong? Thank you.

        • Re: Load Script Error
          bruno bertels

          Hi

           

          Nerver having this issue yet.

           

          Nethertheless

          can you check how you have saved the file ? may be it's an .xlsx ou you saved it as .xls

           

          "I am usually able to delete the old data, add in the new data file" you copy past data from a file to another file used as your data base for Qlik ? Or do you saved new daily file as ..and select the previous file to erase it ?


          Bruno

            • Re: Load Script Error

              Hi

               

              I've got that problem too. It's not about .xlsx or .xls

               

              The error says go to the data load script to fix the error. I can't understand where is the error in data load editor. The script is correct though :/

                • Re: Load Script Error

                  I guess i solved the problem. The file's location that you want to load must be the same position the other loaded file's location and the other files should'nt be deleted. If you are sure of these, you should run script in data load editor next to limited load

                   

                  Fatos

                  • Re: Load Script Error
                    bruno bertels

                    can you share your app with an example of excel daily update.

                     

                    Script is correct so far but may be Connection to the field or the folder is corrupted ?

                      • Re: Load Script Error

                        I can't share my app because of privacy of my company. but main problem is the location of your files.

                        You can change only variables of your folders daily instead of deleting files. so you don't have to create an app every day. just run in data load editor you can realise what's wrong. If you can't do i can show you how to do by sending photos

                          • Re: Load Script Error

                            Hi Fatma,

                             

                            Thank you for your response. I used the debug tool in the data load editor and deleted the error that I found. However I still can not load my new daily file. I am receiving the same error, which refers me back to the data load script. What do you mean by the location of my files? I keep all the daily files in one folder on my desktop. 

                              • Re: Load Script Error
                                Mark Little

                                Hi,

                                 

                                To be able to help more could you provide more information.

                                What is the exact error message you are getting?

                                When running the debug does it stop at certain point of the load?

                                Could you share your script?

                                 

                                Mark

                                • Re: Load Script Error

                                  hi John,

                                   

                                  when i receive this error my files were different files so i kept all my files in one file on the desktop after that i run from this button.pic.png After that there was no debug. I had to add one more data so i saved the data file where the other files. Sorry for my bad grammar. I'm trying to help you

                        • Re: Load Script Error
                          Alvaro Urien Ayala

                          I just had the same issue, the same script Works fine in a new App, but doesn't work in the App where i have all the sheets