topic Create file on error in App Development

Create file on error

User93 — Thu, 31 Jul 2025 12:36:37 GMT

Hi all,

I would like to create an app which, upon encountering an error while in a reload task, would create a file with the text "error" in it.

So far, I know how to generate a .txt file with STORE into, but I can't find a way to generate the file for every possible error that might be encountered, and I also would like a file with only one line for "Error", instead of the multiple line :

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<QvdTableHeader>
<QvBuildNo>50689</QvBuildNo>

...

For the error, I know there is ErrorMode, but I would like something that works for all possible errors, and within a reload task.

Is there a way to do it whith ErrorMode, or with something else ?

Best regards.

Re: Create file on error

TheLazyDeveloper — Thu, 31 Jul 2025 13:10:55 GMT

Maybe something like this added to your script and in sections to capture your error messages.

SET ErrorMode = 0;

LOAD * FROM [YourDataSource.qvd] (qvd);

// Capture error details if the previous load failed
SET vCustomErrMessage = '$(ScriptErrorDetails)';

ErrorLog:
LOAD
Now() as ErrorTimestamp,
'Section Name' as ScriptSection, // Replace with the actual section name
'$(vCustomErrMessage)' as ErrorMessage,
'$(ScriptErrorCount)' as ErrorCount;

Store ErrorLog into ErrorLog.csv (TXT);

Re: Create file on error

rafaelencinas — Thu, 31 Jul 2025 13:22:10 GMT

Hi @User93

When you get this text

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<QvdTableHeader>
<QvBuildNo>50689</QvBuildNo>

It means that when you store your QVD you forget to put in the end of store .qvd(qvd)

Bye!

Re: Create file on error

User93 — Thu, 31 Jul 2025 14:43:37 GMT

Thanks !

It does solve the number of lines issue.

Re: Create file on error

User93 — Thu, 31 Jul 2025 14:45:29 GMT

Thank you !

After a few tests, I ended with this :

SET ErrorMode = 0;

Load query

if ScriptErrorCount>0 then

File:

Load
'Error' AS [Error]

AutoGenerate 1

;

STORE File Into 'lib://Test/Test_Error.txt'(TXT);

Drop Table File;

end if

And it does work !