Strange Load Script ERROR !

[#1]

Hi guys,

I am getting a strange Load script error while using Include syntex.. but if I just use SQL query instead of include file then it works fine.

About my Application:

This is a staging application only used for creating QVD files

• I store my SQL scripts, QVS scripts and QVD files in separate folders.
• I set these folder paths in the beginning of load script and then I use include statements to include SQL scripts.

This is how it works..

Products: // Table Name

SQL  $(Include=$(vSQLpath)Products.sql) ; // vSQLpath = the location of SQL script folder

STORE Products into $(vQVDpath)Products.qvd(QVD); //vQVDpath = location where QVD is saved.

It runs 10 different SQL scripts like this and creates 10 different QVD files.

But this error message only appears in 2 - 3 tables and those scripts is not even complex SQL query.,. it is just selecting 4 columns from one single table in SQL.

I have attached SQL Script and Log file in this post.

Thanks

[sujeetsingh]

Change the format in Document setting in the qlikview file .