topic General Script Error storing a QVD in QlikView

General Script Error storing a QVD

Mon, 23 Jan 2012 13:59:51 GMT

Hi,

I have a lot of problems with general script errors because all my QVW's that run through the server publish their vital stats to a central LogFile.QVD at the end of their run which I then report on separately.

I think the problem is that the QVD logFile becomes locked when two or more try QVW's try and perform the Store at the same time. I have tried the sleep command as another post suggests for this error but this didn't resolve the issue. And the same post also says to delete the QVD which I don't think I can do via the script and even if I could I don't think this is the issue.

I think what I'm looking for is some sort of 'On Error' code which can be switched on just before, if an error is detected (general script error) then it will SLEEP and try again. It will continue to try this for a set number of goes and then Exit Script is it still doesn't have joy.....

I've looked at the manual but if anyone can give me some pointers that would be great.

Thanks

Rich

Re: General Script Error storing a QVD

Miguel_Angel_Baeyens — Mon, 23 Jan 2012 14:26:57 GMT

Hi Rich,

There is indeed a variable ScriptError (further documentation on its codes in the Reference Manual) that you can use in an If conditional in your script:

// Ignore errors and keep executing the next line
SET ErrorMode = 0; 
[...] // Script here
STORE Table INTO File.qvd (qvd); // First attempt
// If everthing went fine, the following will only iterate 5 taking very few time
FOR vAttemptNo = 1 TO 5 // Number of attempts
     IF ScriptError = 1 THEN
          SLEEP 10000; // 10 secs
          EXIT SCRIPT WHEN $(vAttemptNo) => 5;
          STORE Table INTO File.qvd (qvd); // another attempt
     ENDIF
NEXT

I haven't tested the code, so I have missed something.

Hope that helps.

Miguel

General Script Error storing a QVD

stephencredmond — Mon, 23 Jan 2012 14:49:10 GMT

Hi,

Why not have a separate stats QVD for each QVW?

Easy to concatenate them into a central file for analysis.

Regards,

Stephen

General Script Error storing a QVD

Mon, 23 Jan 2012 15:06:21 GMT

Thanks, I've followed the code and can understand your logic. I'll start to implement this across my qvw's and then, I guess, keep my figures crossed.

Cheers

Rich

General Script Error storing a QVD

Mon, 23 Jan 2012 15:09:47 GMT

Hi Stephen, originally that's how it worked and your right with the * wildcard when loading they'll concat simply..... think I'm a bit OCD really and prefer to remedy the problem and keep a single logfile rather than going back to loads (and I have a lot of QVWs and growing). Cheers for the repsonse though. Rich