6 Replies Latest reply: Jan 7, 2015 2:13 AM by Kamiel Rajaram RSS

    Misleading error message

      Hi

       

      A QlikView script has failed citing the following error

       

      Error: ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: Incorrect syntax near '='

      General Script Error

      Execution Failed

       

      I have attached the code in a .qvw file

       

      There is no issue with the SQL syntax, and I know this because

       

      1) If I run the SQL statement in Management Studio it works fine

      3) If I delete the existing .qvd then the routine works fine (the script uses incremental loading)

       

      Has anyone experienced this type of misleading error message before?

       

      Are there known issues with incremental loading?  If the exisiting .qvd is corrupt or blank for example.

       

      Thanks in advance.