Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am working on handling error in Qlik Sense script and wanted to know if any one has encountered "File has wrong format" error and when exactly we receive this error?
Below is the error which I'm getting after debug the script.
ScriptErrorCount 1
ScriptErrorDetails QVX_UNKNOWN_ERROR:
ScriptErrorList File Has Wrong Format
ScriptError File Has Wrong Format
LongDayNames "Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday"
DayNames "Mon;Tue;Wed;Thu;Fri;Sat;Sun"
LongMonthNames "January;February;March;April;May;June;July;August;September;October;November;December"
MonthNames "Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec"
CollationLocale "en-US"
FirstMonthOfYear 1
ReferenceDay 0
BrokenWeeks 1
FirstWeekDay 6
TimestampFormat "M/D/YYYY h:mm:ss[.fff] TT"
DateFormat "M/D/YYYY"
TimeFormat "h:mm:ss TT"
MoneyFormat "$#,##0.00;-$#,##0.00"
MoneyDecimalSep "."
MoneyThousandSep ","
DecimalSep "."
ThousandSep ","
OpenUrlTimeout 86400
StripComments 1
ErrorMode 1
WinRoot "C:"
WinPath "C:\Windows"
QvWorkRoot "D:"
QvWorkPath "D:\DEV\DATA\GenerationQVDQlikView\SALES\Stock"
QvRoot "C:"
QvPath "C:\Program Files\QlikView"
CD "C:"
Any help is much appreciated
thanks in advance
@Gysbert_Wassenaar and @Patricia_Silva . Please help me with this .
It may happen by loading a xls with ooxml or reverse xlsx with biff within the file-format or also by xml with a html or reverse respectively if these files have an invalid structure or in similar cases ...
- Marcus
Can you please explain me ? Because i am getting same error when i am trying to load Data from my Oracle Server into QlikView.
In this case the error may come from the used driver which may not be able to handle the queried data and/or isn't properly configured. There are various reasons possible, like:
Happen this by all queries or only certain ones? You may for testing just to try to load only a few simple tables/fields respectively reducing your origin query step by step to find the causing one. If you know where it breaks you should find valuable hints within the various communities - especially within the oracle ones because your error isn't really related to Qlik.
- Marcus