Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
My Qlikview file just keeps failing "General Script error" in the log file.
138 fields found: FACWT, FAISL, FAREA, FASCG, FAUST, FBAY, FBLAD, FBLWT, FBSCG, FCACG, FCASE, FCASN, FCDIM, FFAS, FFKR, FFTN, FCO, FCODA, FCREX, FCRSZ, FCRT, FCRTP, FCTVL, FCUCG, FCVER, FCVFG, FDARA, FDASL, FDBAY, FDCR, FDIV, FDLCF, FDLCM, FDLDT, FDLM, FDLTM, FDLVL, FDOTF, FDPSN, FDSEL, FDZON, FESWT, FEVCD, FFZN, FINCG, FLDDT, FLDNO, FLDSQ, FLDTM, FLEVL, FLOCN, FLTHL, FLTYP, FLZN, FMANI, FMC1, FMC2, FMIS1, FMIS2, FMPCT, FMPFL, FMPSZ, FNUM1, FNUM2, FNZN, FOFRT, FOSLN, FPAID, FPAKR, FPAKT, FPALT, FPANM, FPATH, FPAWV, FPCBF, FPCKR, FPCTL, FPHLF, FPKCD, FPLAN, FPLN, FPLOC, FPLSZ, FPLTP, FPOSN, FPPFL, FPPSN, FPRA1, FPRA2, FPRA3, FPRA4, FPRA5, FPRVL, FPRWV, FPSTP, FPTMZ, FPTSQ, FRCEX, FRECD, FREFC, FRFDT, FRFNM, FRLNM, FROUT, FRPRN, FSARA, FSASL, FSBAY, FSC1, FSC2, FSC3, FSHNO, FSHUT, FSKU, FSKUF, FSLVL, FSPSN, FSSTS, FSTAT, FSTGI, FSTOR, FSVIA, FSZON, FTBKA, FTCKN, FTCR, FTIER, FTINT, FTLM, FTPID, FTQTY, FTRKN, FTTMZ, FUSER, FWHSE, FXCOR, FYCOR, FZONE, General Script Error
Unable to understand wht is the exact error.
Can someone give some ideas pls.
Hi,
There is no other file related to it.
Moreover, it just fails sometimes and gets executed at times. Its crazy.
Try to reload/debug your code in QlikView Desktop, you might see something more useful in your log file.
try loading the data manually in a new file
load
FACWT, FAISL, FAREA, FASCG, FAUST, FBAY, FBLAD, FBLWT, FBSCG, FCACG, FCASE, FCASN, FCDIM, FFAS, FFKR, FFTN, FCO, FCODA, FCREX, FCRSZ, FCRT, FCRTP, FCTVL, FCUCG, FCVER, FCVFG, FDARA, FDASL, FDBAY, FDCR, FDIV, FDLCF, FDLCM, FDLDT, FDLM, FDLTM, FDLVL, FDOTF, FDPSN, FDSEL, FDZON, FESWT, FEVCD, FFZN, FINCG, FLDDT, FLDNO, FLDSQ, FLDTM, FLEVL, FLOCN, FLTHL, FLTYP, FLZN, FMANI, FMC1, FMC2, FMIS1, FMIS2, FMPCT, FMPFL, FMPSZ, FNUM1, FNUM2, FNZN, FOFRT, FOSLN, FPAID, FPAKR, FPAKT, FPALT, FPANM, FPATH, FPAWV, FPCBF, FPCKR, FPCTL, FPHLF, FPKCD, FPLAN, FPLN, FPLOC, FPLSZ, FPLTP, FPOSN, FPPFL, FPPSN, FPRA1, FPRA2, FPRA3, FPRA4, FPRA5, FPRVL, FPRWV, FPSTP, FPTMZ, FPTSQ, FRCEX, FRECD, FREFC, FRFDT, FRFNM, FRLNM, FROUT, FRPRN, FSARA, FSASL, FSBAY, FSC1, FSC2, FSC3, FSHNO, FSHUT, FSKU, FSKUF, FSLVL, FSPSN, FSSTS, FSTAT, FSTGI, FSTOR, FSVIA, FSZON, FTBKA, FTCKN, FTCR, FTIER, FTINT, FTLM, FTPID, FTQTY, FTRKN, FTTMZ, FUSER, FWHSE, FXCOR, FYCOR, FZONE
From
P:\SOURCE_QVDS\PKMS\MEMPHIS2.PKMANH221D.FCART00.qvd(qvd);
Can you attach the sample file?
try to load the only some rows with First Function to debug the issue like below
First 100
LOAD
*
FROM Source.qvd (qvd) ;
This looks like read write issue. Is there any other application reading the same qvd file at same time?
Check this
Can you copy the QVD to a new filename in windows, this will show if the file is locked by another app.
The QVD is probably empty.
P.