qvc.qvs works in 12.10 but not in 12.40. Unknown statement error

[sreeramulas]

Hi Experts,
We recently upgraded from 12.10 to 12.40 version of QlikView.

Below is the code that works fine in 12.10 but not in 12.40. It throws unknown statement error.

Your help here is highly appreciated.

Attached are the error messages that I receive and the actual qvc.qvs file that I use while generating the QVD's using the qvdGenerator.qvw. This generator uses an excel file to get the list of tables names and the load code.

//==========================================================//==========================================================// Execute the SQL Select.//==========================================================

[$(Qvc.Loader.v.Tablename)]: // vTablename is set by the IncrementalSetup routine.

Rem; // Fix syntax error from table label with variable // If LOAD Statement provided, use it

IF len('$(_qvctemp.den.loadStatement)')>0 THEN

$(_qvctemp.den.loadStatement);

ELSE // No LOAD Statement, build a SQL SELECT

   IF $(Qvc.Loader.v.CreateExtractTimestampField) THEN

            LOAD *, now(1) as ExtractTimestamp;

   ENDIF

   SQL SELECT $(_qvctemp.den.columns) FROM $(_qvctemp.den.table) WHERE $(Qvc.Loader.v.IncrementalExpression) //incrementalExpression is set up the Qvc.IncrementalSetup routine. ;

ENDIF

Qvc.zip

[RobWunderlich]

Fix to Qvc.DbExtract is available by using the repo copy here at Qvc_Runtime/qvc.qvs or script including with a web link:
$(Must_Include=http://raw.githubusercontent.com/RobWunderlich/Qlikview-Components/master/Qvc_Runtime/Qvc.qvs);

I'll build this into a release later this week.

[sreeramulas]

Hi Rob,

Thanks heaps for your response and looking into the issue. Appreciate it.

I have copy pasted the code in the above link into the qvc.qvs file and I keep getting a pop up window to select the data source. Please find the attached pic. And it does for each of the table load.

Could you please advise what am I missing?

Thanks in advance.

[RobWunderlich]

Fixed in release V11.3

[sreeramulas]

Qvc.zip

DbExtract.zip

Hi Rob,

Thank you for your quick update.
I have tried using the new qvc.qvs file in the link
https://github.com/RobWunderlich/Qlikview-Components/tree/master/Qvc_Runtime

I still get the pop up window asking the data source.
Please find attached files that I am using.

[RobWunderlich]

Can you try downloading and extracting the 11.3 release?

[sreeramulas]

Hi Rob,

Sorry for the delay in my response.
I have downloaded the whole component folder and tried but still it is the same and keeps asking me the Data source. The folder structure which I downloaded is intact.
Only changes I did is replace the sampleextractlist.xls with my file and the connection file with my file.

Rest all same and I do keep getting the pop up window asking 'Select Data Source'.

I really appreciate you taking helping me out Rob. Cheers.