topic Re: If statement that will cause intentional error in QV script in QlikView

If statement that will cause intentional error in QV script

Wed, 13 Jan 2016 11:39:39 GMT

Hello,

I am solving the problem of reloading 2 tasks - the first task is reloading qvd and storing the number of rows into variable, the second task should have dependency on first and will reload after the first task was successfull.

The problem is that i am not able to make an intentional error in script that will cause task FAILED.

I tried something like this, the first if - task will end SUCCESSFUL

the else - task will end with ERROR:

if vNoofrowsReload > vRowsLast then

execute cmd.exe /c echo OK > OK.txt;

else

LOAD BLABLA from BLABLA;

endif;

Table BLABLA does not exist - the script will fail, but it is not wokring on the QV server. Can anbybody help me with the solution?

Thank you.

Re: If statement that will cause intentional error in QV script

avinashelite — Wed, 13 Jan 2016 12:03:35 GMT

you can make use of the QMC task dependence rite?

Re: If statement that will cause intentional error in QV script

maxgro — Wed, 13 Jan 2016 12:27:07 GMT

load 'THIS IS AN ERROR: .....' from notexists.qvd (qvd);

Re: If statement that will cause intentional error in QV script

Wed, 13 Jan 2016 13:17:54 GMT

Yes i use dependence, but I want the reload FAIL (1st task) when there are no new rows and SUCCESS when there are new.

Your suggestions is not helpful, it works in desktop but both if-s FAILED on the server.

Re: If statement that will cause intentional error in QV script

swuehl — Wed, 13 Jan 2016 13:22:21 GMT

Can you elaborate what you mean with 'not working' and 'FAILED' on the server side?

What do you see in the log files and QMC?

Re: If statement that will cause intentional error in QV script

Wed, 13 Jan 2016 13:45:37 GMT

Desktop:

I reload the QVW with this if clause, when everything is ok the reload finish successfully. When rows from last reload = rows from actual load, the error in script occurs (that is as I want).

QV Server:

I reload QVW saved on server in QV desktop client the reload works as I wanted.

If i reload QVW with QMC, the reload task always end with fail, even it the first if clause or second clause. It look like that the server always take only the second clause when I reload it using QMC.

Thanks.

Re: If statement that will cause intentional error in QV script

swuehl — Wed, 13 Jan 2016 14:06:32 GMT

And how have you defined vNoofrowsReload and vRowsLast variables?

Could you post the document log (from QMC run) / script?

Re: If statement that will cause intentional error in QV script

Wed, 13 Jan 2016 14:31:36 GMT

Short log:

13.1.2016 15:25:56: Execution started.

13.1.2016 15:25:56: QlikView Version:11.20.12758.0

13.1.2016 15:25:56: CPU Target x64

13.1.2016 15:25:56: Operating System Windows Server (R) 2008 Standard Service Pack 2 (64 bit edition)

13.1.2016 15:25:56: Wow64 mode Not using Wow64

13.1.2016 15:25:56: MDAC Version 6.0.6002.18005

13.1.2016 15:25:56: MDAC Full Install Version 6.0.6002.18005

13.1.2016 15:25:56: PreferredCompression 2

13.1.2016 15:25:56: EnableParallelReload 1

13.1.2016 15:25:56: ParallelizeQvdLoads 1

13.1.2016 15:25:56: AutoSaveAfterReload 0

13.1.2016 15:25:56: BackupBeforeReload 0

13.1.2016 15:25:56: EnableFlushLog 0

13.1.2016 15:25:56: SaveInfoWhenSavingFile 0

13.1.2016 15:25:56: UserLogfileCharset 1200

13.1.2016 15:25:56: OdbcLoginTimeout -1

13.1.2016 15:25:56: OdbcConnectionTimeout -1

13.1.2016 15:25:56: ScriptWantsDbWrite false

13.1.2016 15:25:56: ScriptWantsExe false

13.1.2016 15:25:56: LogFile CodePage Used: 1200

...

13.1.2016 15:26:01: 1243 LET vNoofrowsReload=NoOfRows('SalesQTY')

13.1.2016 15:26:01: 1245 NoOfRowsLast:

13.1.2016 15:26:01: 1246 LOAD @1 as noofrowsLast

13.1.2016 15:26:01: 1247 FROM

13.1.2016 15:26:01: 1248 \\noofrowslast.txt

13.1.2016 15:26:01: 1249 (txt, codepage is 1250, explicit labels, delimiter is ',', msq)

13.1.2016 15:26:01: 1 fields found: noofrowsLast, 1 lines fetched

13.1.2016 15:26:01: 1251 execute cmd.exe /c echo 2885 > noofrowslast.txt

13.1.2016 15:26:01: 1253 LET vRowsLast = Peek('noofrowsLast', 0, 'NoOfRowsLast')

13.1.2016 15:26:01: 1255 if vNoofrowsReload > vRowsLast then

13.1.2016 15:26:01: 1256 execute cmd.exe /c echo OK > OK.txt

13.1.2016 15:26:01: 1257 else

13.1.2016 15:26:01: $Syn 1 = Country+Material Number

13.1.2016 15:26:01: $Syn 2 = Country+Material Number+KEY_Order

13.1.2016 15:26:01: $Syn 3 = Month+Country

13.1.2016 15:26:01: $Syn 4 = Month+Country+CustCode

13.1.2016 15:26:01: $Syn 5 = Month+Country+CustCode+Period

13.1.2016 15:26:01: $Syn 6 = Month+Country+CustCode+Material Number

13.1.2016 15:26:01: $Syn 7 = Month+Country+CustCode+Material Number+Year

13.1.2016 15:26:01: $Syn 8 = $Syn 3+$Syn 4

13.1.2016 15:26:01: $Syn 9 = $Syn 3+$Syn 4+$Syn 5

13.1.2016 15:26:01: $Syn 10 = $Syn 1+$Syn 3+$Syn 4+$Syn 6

13.1.2016 15:26:01: $Syn 11 = $Syn 1+$Syn 3+$Syn 4+$Syn 6+$Syn 7

13.1.2016 15:26:01: $Syn 12 = $Syn 1+$Syn 3+$Syn 4+$Syn 5+$Syn 6

13.1.2016 15:26:02: $Syn 13 = $Syn 1+$Syn 2

13.1.2016 15:26:02: $Syn 14 = $Syn 1+$Syn 2+$Syn 3+$Syn 4+$Syn 6

13.1.2016 15:26:02: $Syn 15 = $Syn 8+$Syn 10

13.1.2016 15:26:02: $Syn 16 = $Syn 8+$Syn 10+$Syn 13+$Syn 14

13.1.2016 15:26:02: $Syn 17 = $Syn 8+$Syn 10+$Syn 11

13.1.2016 15:26:02: $Syn 18 = $Syn 8+$Syn 9

13.1.2016 15:26:02: $Syn 19 = $Syn 8+$Syn 9+$Syn 10+$Syn 12

13.1.2016 15:26:02: $Syn 20 = $Syn 15+$Syn 18+$Syn 19

13.1.2016 15:26:02: $Syn 21 = $Syn 15+$Syn 17

13.1.2016 15:26:02: $Syn 22 = $Syn 15+$Syn 16

13.1.2016 15:26:03: General Script Error

13.1.2016 15:26:03: Execution Failed

13.1.2016 15:26:03: Execution finished.

My variables:

LET vNoofrowsReload=NoOfRows('SalesQTY');

NoOfRowsLast:

LOAD @1 as noofrowsLast

FROM

$(vPathTXT)noofrowslast.txt

(txt, codepage is 1250, explicit labels, delimiter is ',', msq);

execute cmd.exe /c echo $(vNoofrowsReload) > noofrowslast.txt;

LET vRowsLast = Peek('noofrowsLast', 0, 'NoOfRowsLast');

Re: If statement that will cause intentional error in QV script

swuehl — Wed, 13 Jan 2016 17:24:09 GMT

Could you add TRACE statements before your if statement to check the actual values of the two variables?

Re: If statement that will cause intentional error in QV script

Wed, 13 Jan 2016 19:54:16 GMT

When the else clause:

2016-01-13 20:42:12 1243 TRACE LET vNoofrowsReload=NoOfRows('SalesQTY')

2016-01-13 20:42:12 1243 LET vNoofrowsReload=NoOfRows('SalesQTY')

2016-01-13 20:42:12 1244

2016-01-13 20:42:12 1245 NoOfRowsLast:

2016-01-13 20:42:12 1246 LOAD @1 as noofrowsLast

2016-01-13 20:42:13 1247 FROM

2016-01-13 20:42:13 1248 \\noofrowslast.txt

2016-01-13 20:42:13 1249 (txt, codepage is 1250, explicit labels, delimiter is ',', msq)

2016-01-13 20:42:13 1 fields found: noofrowsLast,

2016-01-13 20:42:13 1 lines fetched

2016-01-13 20:42:13 1251 execute cmd.exe /c echo 20 > noofrowslast.txt

2016-01-13 20:42:13 1253 TRACE LET vRowsLast = Peek('noofrowsLast', 0, 'NoOfRowsLast')

2016-01-13 20:42:14 1253 LET vRowsLast = Peek('noofrowsLast', 0, 'NoOfRowsLast')

2016-01-13 20:42:14 1254

2016-01-13 20:42:14 1255 if vNoofrowsReload > vRowsLast then

2016-01-13 20:42:14 1256

2016-01-13 20:42:14 1258 LOAD 'This is an error' from notexists.qvd(qvd)

2016-01-13 20:42:14 Error: Cannot open file '\\notexists.qvd' The system cannot find the file specified.

2016-01-13 20:42:14

2016-01-13 20:42:56 1259 endif

2016-01-13 20:42:56 $Syn 1 = CountryCode+Material Number

2016-01-13 20:42:56 $Syn 2 = CountryCode+Material Number+KEY_Order

2016-01-13 20:42:56 $Syn 3 = Month+CountryCode

2016-01-13 20:42:57 $Syn 4 = Month+CountryCode+CustCode

2016-01-13 20:42:57 $Syn 5 = Month+CountryCode+CustCode+Period

2016-01-13 20:42:57 $Syn 6 = Month+CountryCode+CustCode+Material Number

2016-01-13 20:42:57 $Syn 7 = Month+CountryCode+CustCode+Material Number+Year

2016-01-13 20:42:57 $Syn 8 = $Syn 3+$Syn 4

2016-01-13 20:42:58 $Syn 9 = $Syn 3+$Syn 4+$Syn 5

2016-01-13 20:42:58 $Syn 10 = $Syn 1+$Syn 3+$Syn 4+$Syn 6

2016-01-13 20:42:58 $Syn 11 = $Syn 1+$Syn 3+$Syn 4+$Syn 6+$Syn 7

2016-01-13 20:42:58 $Syn 12 = $Syn 1+$Syn 3+$Syn 4+$Syn 5+$Syn 6

2016-01-13 20:42:58 $Syn 13 = $Syn 1+$Syn 2

2016-01-13 20:42:58 $Syn 14 = $Syn 1+$Syn 2+$Syn 3+$Syn 4+$Syn 6

2016-01-13 20:42:59 $Syn 15 = $Syn 8+$Syn 10

2016-01-13 20:42:59 $Syn 16 = $Syn 8+$Syn 10+$Syn 13+$Syn 14

2016-01-13 20:42:59 $Syn 17 = $Syn 8+$Syn 10+$Syn 11

2016-01-13 20:42:59 $Syn 18 = $Syn 8+$Syn 9

2016-01-13 20:43:00 $Syn 19 = $Syn 8+$Syn 9+$Syn 10+$Syn 12

2016-01-13 20:43:00 $Syn 20 = $Syn 15+$Syn 18+$Syn 19

2016-01-13 20:43:00 $Syn 21 = $Syn 15+$Syn 17

2016-01-13 20:43:01 $Syn 22 = $Syn 15+$Syn 16

2016-01-13 20:43:13 Execution finished.

When the first if clause:

2016-01-13 20:51:46 1243 TRACE LET vNoofrowsReload=NoOfRows('SalesQTY')

2016-01-13 20:51:46 1243 LET vNoofrowsReload=NoOfRows('SalesQTY')

2016-01-13 20:51:46 1244

2016-01-13 20:51:46 1245 NoOfRowsLast:

2016-01-13 20:51:46 1246 LOAD @1 as noofrowsLast

2016-01-13 20:51:47 1247 FROM

2016-01-13 20:51:47 1248 \\noofrowslast.txt

2016-01-13 20:51:47 1249 (txt, codepage is 1250, explicit labels, delimiter is ',', msq)

2016-01-13 20:51:47 1 fields found: noofrowsLast,

2016-01-13 20:51:47 1 lines fetched

2016-01-13 20:51:47 1251 execute cmd.exe /c echo 20 > noofrowslast.txt

2016-01-13 20:51:48 1253 TRACE LET vRowsLast = Peek('noofrowsLast', 0, 'NoOfRowsLast')

2016-01-13 20:51:48 1253 LET vRowsLast = Peek('noofrowsLast', 0, 'NoOfRowsLast')

2016-01-13 20:51:48 1254

2016-01-13 20:51:48 1255 if vNoofrowsReload > vRowsLast then

2016-01-13 20:51:48 1256

2016-01-13 20:51:48 1258 LOAD 'This is an error' from notexists.qvd(qvd)

2016-01-13 20:51:48 Error: Cannot open file '\\notexists.qvd' The system cannot find the file specified.

2016-01-13 20:51:48

2016-01-13 20:51:54 1259 endif

2016-01-13 20:51:54 $Syn 1 = CountryCode+Material Number

2016-01-13 20:51:54 $Syn 2 = CountryCode+Material Number+KEY_Order

2016-01-13 20:51:54 $Syn 3 = Month+CountryCode

2016-01-13 20:51:55 $Syn 4 = Month+CountryCode+CustCode

2016-01-13 20:51:55 $Syn 5 = Month+CountryCode+CustCode+Period

2016-01-13 20:51:55 $Syn 6 = Month+CountryCode+CustCode+Material Number

2016-01-13 20:51:55 $Syn 7 = Month+CountryCode+CustCode+Material Number+Year

2016-01-13 20:51:55 $Syn 8 = $Syn 3+$Syn 4

2016-01-13 20:51:55 $Syn 9 = $Syn 3+$Syn 4+$Syn 5

2016-01-13 20:51:56 $Syn 10 = $Syn 1+$Syn 3+$Syn 4+$Syn 6

2016-01-13 20:51:56 $Syn 11 = $Syn 1+$Syn 3+$Syn 4+$Syn 6+$Syn 7

2016-01-13 20:51:56 $Syn 12 = $Syn 1+$Syn 3+$Syn 4+$Syn 5+$Syn 6

2016-01-13 20:51:56 $Syn 13 = $Syn 1+$Syn 2

2016-01-13 20:51:57 $Syn 14 = $Syn 1+$Syn 2+$Syn 3+$Syn 4+$Syn 6

2016-01-13 20:51:57 $Syn 15 = $Syn 8+$Syn 10

2016-01-13 20:51:57 $Syn 16 = $Syn 8+$Syn 10+$Syn 13+$Syn 14

2016-01-13 20:51:57 $Syn 17 = $Syn 8+$Syn 10+$Syn 11

2016-01-13 20:51:58 $Syn 18 = $Syn 8+$Syn 9

2016-01-13 20:51:58 $Syn 19 = $Syn 8+$Syn 9+$Syn 10+$Syn 12

2016-01-13 20:51:59 $Syn 20 = $Syn 15+$Syn 18+$Syn 19

2016-01-13 20:51:59 $Syn 21 = $Syn 15+$Syn 17

2016-01-13 20:51:59 $Syn 22 = $Syn 15+$Syn 16

2016-01-13 20:52:12 Execution finished.

Do you see something in the logs?

Thank you very much

Re: If statement that will cause intentional error in QV script

swuehl — Wed, 13 Jan 2016 22:54:25 GMT

Not sure if I made myself clear, I was talking about TRACE statements to output the values of the variables, not the variable definitions.

TRACE vRowsLast: $(vRowsLast);

TRACE vNoofrowsReload: $(vNoofrowsReload);

Re: If statement that will cause intentional error in QV script

Thu, 14 Jan 2016 08:46:10 GMT

Sorry my fault.

There is output of the 1st if (as I want):

2016-01-14 09:33:22 1261 TRACE vRowsLast = 288

2016-01-14 09:33:22 1261 vRowsLast = 288

2016-01-14 09:33:22 1262

2016-01-14 09:33:22 1262 TRACE vNoofrowsReload = 2885

2016-01-14 09:33:22 1262 vNoofrowsReload = 2885

There is output of the else - QV desktop shows the message that there is bad path to QVD. Then I click OK and the script run to the end. I think that this is not the behaviour that I want - I want to fail the whole qvw!? Any idea please?

2016-01-14 09:41:44 1245 NoOfRowsLast:

2016-01-14 09:41:44 1246 LOAD @1 as noofrowsLast

2016-01-14 09:41:44 1247 FROM

2016-01-14 09:41:44 1248 C:\\noofrowslast.txt

2016-01-14 09:41:44 1249 (txt, codepage is 1250, explicit labels, delimiter is ',', msq)

2016-01-14 09:41:44 1 fields found: noofrowsLast,

2016-01-14 09:41:44 1 lines fetched

2016-01-14 09:41:44 1251 execute cmd.exe /c echo 2885 > noofrowslast.txt

2016-01-14 09:41:44 1253 LET vRowsLast = Peek('noofrowsLast', 0, 'NoOfRowsLast')

2016-01-14 09:41:44 1255 if vNoofrowsReload > vRowsLast then

2016-01-14 09:41:44 1256

2016-01-14 09:41:44 1258 LOAD 'This is an error' from notexists.qvd(qvd)

2016-01-14 09:41:44 C:\\notexists.qvd' The system cannot find the file specified.

2016-01-14 09:41:44

2016-01-14 09:41:48 1259 endif

2016-01-14 09:41:48 1261 TRACE vRowsLast = 2885

2016-01-14 09:41:48 1261 vRowsLast = 2885

2016-01-14 09:41:48 1262

2016-01-14 09:41:48 1262 TRACE vNoofrowsReload = 2885

2016-01-14 09:41:48 1262 vNoofrowsReload = 2885

2016-01-14 09:42:01 Execution finished.

Re: If statement that will cause intentional error in QV script

swuehl — Thu, 14 Jan 2016 18:02:48 GMT

I must admit I am a little bit confused about your configurations and what you want to achieve.

If you want to force QV to enter error without user interaction, you can set error mode to 2 in the script (e.g. just before the LOAD with wrong path):

SET ErrorMode = 2;

Re: If statement that will cause intentional error in QV script

Fri, 15 Jan 2016 11:22:13 GMT

I have one qvd generator that loads data every day, but not so reliable data source that data are as fresh as we want.

So we want to load the external txt file - this file will be made by user, if user thinks that data are not correct, user will throw TXT for QV to load and then we use it in text object for warning. But the problem is that our app is made on 1 sheet (objects use conditional show with variables), and if we reload many times per day - the user gets connection lost. That´s why i want to reload the first QVW every 10 minutes and have another binary load for next QVW that will reload only after the successful task(this qvw wil b presentation layer for users). So I need this else clause to FAIL the task and not to start the dependent task.

Is this more understandable?

Re: If statement that will cause intentional error in QV script

Peter_Cammaert — Fri, 15 Jan 2016 14:43:19 GMT

Clicking the OK button when getting an error message during QV Desktop script execution will ignore the error and continue execution. Click Cancel if you want the script to fail in the ELSE branch.

On the server, scripts will be executed in batch mode and for ERRORMODE=1 you won't get a dialog. The default action will be to fail. If it does not work like that, there is something wrong with your script code.

Can you post the script instead of parts of log files?

Peter

Re: If statement that will cause intentional error in QV script

Fri, 15 Jan 2016 14:58:18 GMT

Here is my script

LET vNoofrowsReload=NoOfRows('SalesQTY'); //actual load
NoOfRowsLast:
LOAD @1 as noofrowsLast
FROM
$(vPathTXT)noofrowslast.txt
(txt, codepage is 1250, explicit labels, delimiter is ',', msq); //load - nmber of rows from previous day, source table SalesQTY

execute cmd.exe /c echo $(vNoofrowsReload) > noofrowslast.txt;

LET vRowsLast = Peek('noofrowsLast', 0, 'NoOfRowsLast'); //number of rows from previous load

if vNoofrowsReload > vRowsLast then
execute cmd.exe /c echo OK > OK.txt; //SUCCESS task on QV server
else
//SET ErrorMode = 2;
LOAD 'This is an error' from notexists.qvd(qvd); //FAIL task on QV server - I dont know what to put here to fail the script every time when the if clause is no correct
endif;

Thank you.

Maros

Re: If statement that will cause intentional error in QV script

Fri, 15 Jan 2016 15:31:48 GMT

We did the same thing on our environment, but we didn't encounter any issues on the server.

Can you please post your qvw script and which version of QV you are using?

Note: If you are using QV 12, then EXECUTE command won't work until you update the settings.ini file.

Re: If statement that will cause intentional error in QV script

Sun, 17 Jan 2016 21:10:11 GMT

We test is on QV Server 11.20.12758.0

Here is the part of the qvw, I am not sure if this will help you.

NOTIFICATIONS_TASK_1x.qvw - Google Drive

Thank you!

Re: If statement that will cause intentional error in QV script

Fri, 22 Jan 2016 13:41:13 GMT

Conclusion: This works on production server.

I dont know why, but on our server it does not work - I will mabye have to reinstall it.

Thank you everybody.