Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
12/10/2019 5:45:13 AM: 0015 LET vFileName = Subfield('C:\ProgramData\QlikTech\Documents\MetalsAnalytics_QVDS\Axs\DATA.QVD', '\', SubstringCount('C:\ProgramData\QlikTech\Documents\MetalsAnalytics_QVDS\Axs\DATA.QVD', '\') + 1)
12/10/2019 5:45:13 AM: 0016 LET vFullPath = chr(39) & 'MetalsAnalytics_QVDS\DATA.QVD' & chr(39)
12/10/2019 5:45:13 AM: 0018 [MergeTable]:
12/10/2019 5:45:13 AM: 0019 LOAD
12/10/2019 5:45:13 AM: 0020 *
12/10/2019 5:45:13 AM: 0021 FROM
12/10/2019 5:45:13 AM: 0022 'C:\ProgramData\QlikTech\Documents\MetalsAnalytics_QVDS\Axs\DATA.QVD' (QVD)
12/10/2019 5:45:13 AM: 0023
12/10/2019 5:45:13 AM: 199 fields found: field names(removed because of customer information), 415,124 lines fetched
12/10/2019 5:45:16 AM: 0025 IF (NOT isNull(qvdCreateTime('MetalsAnalytics_QVDS\DATA.QVD'))) THEN
12/10/2019 5:45:16 AM: 0026 Concatenate([MergeTable])
12/10/2019 5:45:16 AM: 0027 LOAD
12/10/2019 5:45:16 AM: 0028 *
12/10/2019 5:45:16 AM: 0029 FROM
12/10/2019 5:45:16 AM: 0030 'MetalsAnalytics_QVDS\DATA.QVD' (QVD)
12/10/2019 5:45:16 AM: 0031
12/10/2019 5:45:16 AM: Error: Error: File extdata.cpp, Line 2903
12/10/2019 5:45:16 AM: General Script Error
12/10/2019 5:45:16 AM: Execution Failed
12/10/2019 5:45:16 AM: Execution finished.
Does the QVD actually exist in that path? I see in the beginning of the script there is an Axs folder as well, and I do not see that you are moving/storing to the location without that folder, so my best hunch would be you are looking in a place the QVD file does not actually exist...
General Script errors are logic errors in the majority of cases, just FYI, and I would expect if the QVD file was not there, we should like be generating a File Not Found error instead, so I am not quite sure what is going on here. I suspect you will need to attach the actually script snippet for this section so folks can see fully what is supposed to be going on, as I would expect that is where the actual issue lies, without that, I doubt you will get much further with just what you have provided.
Regards,
Brett
Hi,
Could you please suggest me what actual script you need from me?
Do you need the qvw and qvw_generator file and data files from both the folders also?
Please confirm the list of files, I need to attach here.
Here is an article link regarding the script/document log, you already have it enabled, you just need to attach the full log rather than just the snippet you did:
How to enable script/document log
The other thing would be the actual script itself, just open the application in the Desktop client, go to the Script Editor, then use the File\Export to Script File to generate the .qvs file and attach that, so folks can see the entire script. The other option would be to attach the QVW file, your choice here.
Regards,
Brett
Thanks, Do you want those data.qvd files too from both the folders.
Attaching log files, as if now. I will share the qvw and qvs after some time, requested from the customer.
Hi Bret,
All the latest files uploaded onto the case. Please find there.