Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
markgraham123
Contributor II

General Script error ????

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.

17 Replies

Re: General Script error ????

Can you share the script Mark

MVP
MVP

Re: General Script error ????

It would be easier to diagnose your problem if you supplied the script around where the error is occurring. This is a generic error message and there are a number of possible causes.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
markgraham123
Contributor II

Re: General Script error ????

8/13/2015 8:57:59 AM: Execution started.

8/13/2015 8:57:59 AM: QlikView Version:10.00.9731.9

8/13/2015 8:57:59 AM: CPU Target                    x64

8/13/2015 8:57:59 AM: Operating System Windows Server 2008 R2 Enterprise Service Pack 1 (64 bit edition)

8/13/2015 8:57:59 AM: Wow64 mode                    Not using Wow64

8/13/2015 8:57:59 AM: MDAC Version                  6.1.7601.17514

8/13/2015 8:57:59 AM: MDAC Full Install Version 6.1.7601.17514

8/13/2015 8:57:59 AM: PreferredCompression          2

8/13/2015 8:57:59 AM: EnableParallelReload          1

8/13/2015 8:57:59 AM: ParallelizeQvdLoads           1

8/13/2015 8:57:59 AM: AutoSaveAfterReload           0

8/13/2015 8:57:59 AM: BackupBeforeReload            0

8/13/2015 8:57:59 AM: EnableFlushLog                0

8/13/2015 8:57:59 AM: SaveInfoWhenSavingFile        0

8/13/2015 8:57:59 AM: UserLogfileFarset            0

8/13/2015 8:57:59 AM: OdbcLoginTimeout              -1

8/13/2015 8:57:59 AM: OdbcConnectionTimeout         -1

8/13/2015 8:57:59 AM: ScriptWantsDbWrite false

8/13/2015 8:57:59 AM: ScriptWantsExe false

8/13/2015 8:57:59 AM: LogFile CodePage Used:        1252

8/13/2015 8:57:59 AM: 0002 SET ThousandSep=','

8/13/2015 8:57:59 AM: 0003 SET DecimalSep='.'

8/13/2015 8:57:59 AM: 0004 SET MoneyThousandSep=','

8/13/2015 8:57:59 AM: 0005 SET MoneyDecimalSep='.'

8/13/2015 8:57:59 AM: 0006 SET MoneyFormat='$#,##0.00;($#,##0.00)'

8/13/2015 8:57:59 AM: 0007 SET TimeFormat='h:mm:ss TT'

8/13/2015 8:57:59 AM: 0008 SET DateFormat='M/D/YYYY'

8/13/2015 8:57:59 AM: 0009 SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT'

8/13/2015 8:57:59 AM: 0010 SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'

8/13/2015 8:57:59 AM: 0011 SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'

8/13/2015 8:57:59 AM: 0013 LOAD FACWT,

8/13/2015 8:57:59 AM: 0014       FAISL,

8/13/2015 8:57:59 AM: 0015       FAREA,

8/13/2015 8:57:59 AM: 0016       FASCG,

8/13/2015 8:57:59 AM: 0017       FAUST,

8/13/2015 8:57:59 AM: 0018       FBAY,

8/13/2015 8:57:59 AM: 0019       FBLAD,

8/13/2015 8:57:59 AM: 0020       FBLWT,

8/13/2015 8:57:59 AM: 0021       FBSCG,

8/13/2015 8:57:59 AM: 0022       FCACG,

8/13/2015 8:57:59 AM: 0023       FCASE,

8/13/2015 8:57:59 AM: 0024       FCASN,

8/13/2015 8:57:59 AM: 0025       FCDIM,

8/13/2015 8:57:59 AM: 0026       FFAS,

8/13/2015 8:57:59 AM: 0027       FFKR,

8/13/2015 8:57:59 AM: 0028       FFTN,

8/13/2015 8:57:59 AM: 0029       FCO,

8/13/2015 8:57:59 AM: 0030       FCODA,

8/13/2015 8:57:59 AM: 0031       FCREX,

8/13/2015 8:57:59 AM: 0032       FCRSZ,

8/13/2015 8:57:59 AM: 0033       FCRT,

8/13/2015 8:57:59 AM: 0034       FCRTP,

8/13/2015 8:57:59 AM: 0035       FCTVL,

8/13/2015 8:57:59 AM: 0036       FCUCG,

8/13/2015 8:57:59 AM: 0037       FCVER,

8/13/2015 8:57:59 AM: 0038       FCVFG,

8/13/2015 8:57:59 AM: 0039       FDARA,

8/13/2015 8:57:59 AM: 0040       FDASL,

8/13/2015 8:57:59 AM: 0041       FDBAY,

8/13/2015 8:57:59 AM: 0042       FDCR,

8/13/2015 8:57:59 AM: 0043       FDIV,

8/13/2015 8:57:59 AM: 0044       FDLCF,

8/13/2015 8:57:59 AM: 0045       FDLCM,

8/13/2015 8:57:59 AM: 0046       FDLDT,

8/13/2015 8:57:59 AM: 0047       FDLM,

8/13/2015 8:57:59 AM: 0048       FDLTM,

8/13/2015 8:57:59 AM: 0049       FDLVL,

8/13/2015 8:57:59 AM: 0050       FDOTF,

8/13/2015 8:57:59 AM: 0051       FDPSN,

8/13/2015 8:57:59 AM: 0052       FDSEL,

8/13/2015 8:57:59 AM: 0053       FDZON,

8/13/2015 8:57:59 AM: 0054       FESWT,

8/13/2015 8:57:59 AM: 0055       FEVCD,

8/13/2015 8:57:59 AM: 0056       FFZN,

8/13/2015 8:57:59 AM: 0057       FINCG,

8/13/2015 8:57:59 AM: 0058       FLDDT,

8/13/2015 8:57:59 AM: 0059       FLDNO,

8/13/2015 8:57:59 AM: 0060       FLDSQ,

8/13/2015 8:57:59 AM: 0061       FLDTM,

8/13/2015 8:57:59 AM: 0062       FLEVL,

8/13/2015 8:57:59 AM: 0063       FLOCN,

8/13/2015 8:57:59 AM: 0064       FLTHL,

8/13/2015 8:57:59 AM: 0065       FLTYP,

8/13/2015 8:57:59 AM: 0066       FLZN,

8/13/2015 8:57:59 AM: 0067       FMANI,

8/13/2015 8:57:59 AM: 0068       FMC1,

8/13/2015 8:57:59 AM: 0069       FMC2,

8/13/2015 8:57:59 AM: 0070       FMIS1,

8/13/2015 8:57:59 AM: 0071       FMIS2,

8/13/2015 8:57:59 AM: 0072       FMPCT,

8/13/2015 8:57:59 AM: 0073       FMPFL,

8/13/2015 8:57:59 AM: 0074       FMPSZ,

8/13/2015 8:57:59 AM: 0075       FNUM1,

8/13/2015 8:57:59 AM: 0076       FNUM2,

8/13/2015 8:57:59 AM: 0077       FNZN,

8/13/2015 8:57:59 AM: 0078       FOFRT,

8/13/2015 8:57:59 AM: 0079       FOSLN,

8/13/2015 8:57:59 AM: 0080       FPAID,

8/13/2015 8:57:59 AM: 0081       FPAKR,

8/13/2015 8:57:59 AM: 0082       FPAKT,

8/13/2015 8:57:59 AM: 0083       FPALT,

8/13/2015 8:57:59 AM: 0084       FPANM,

8/13/2015 8:57:59 AM: 0085       FPATH,

8/13/2015 8:57:59 AM: 0086       FPAWV,

8/13/2015 8:57:59 AM: 0087       FPCBF,

8/13/2015 8:57:59 AM: 0088       FPCKR,

8/13/2015 8:57:59 AM: 0089       FPCTL,

8/13/2015 8:57:59 AM: 0090       FPHLF,

8/13/2015 8:57:59 AM: 0091       FPKCD,

8/13/2015 8:57:59 AM: 0092       FPLAN,

8/13/2015 8:57:59 AM: 0093       FPLN,

8/13/2015 8:57:59 AM: 0094       FPLOC,

8/13/2015 8:57:59 AM: 0095       FPLSZ,

8/13/2015 8:57:59 AM: 0096       FPLTP,

8/13/2015 8:57:59 AM: 0097       FPOSN,

8/13/2015 8:57:59 AM: 0098       FPPFL,

8/13/2015 8:57:59 AM: 0099       FPPSN,

8/13/2015 8:57:59 AM: 0100       FPRA1,

8/13/2015 8:57:59 AM: 0101       FPRA2,

8/13/2015 8:57:59 AM: 0102       FPRA3,

8/13/2015 8:57:59 AM: 0103       FPRA4,

8/13/2015 8:57:59 AM: 0104       FPRA5,

8/13/2015 8:57:59 AM: 0105       FPRVL,

8/13/2015 8:57:59 AM: 0106       FPRWV,

8/13/2015 8:57:59 AM: 0107       FPSTP,

8/13/2015 8:57:59 AM: 0108       FPTMZ,

8/13/2015 8:57:59 AM: 0109       FPTSQ,

8/13/2015 8:57:59 AM: 0110       FRCEX,

8/13/2015 8:57:59 AM: 0111       FRECD,

8/13/2015 8:57:59 AM: 0112       FREFC,

8/13/2015 8:57:59 AM: 0113       FRFDT,

8/13/2015 8:57:59 AM: 0114       FRFNM,

8/13/2015 8:57:59 AM: 0115       FRLNM,

8/13/2015 8:57:59 AM: 0116       FROUT,

8/13/2015 8:57:59 AM: 0117       FRPRN,

8/13/2015 8:57:59 AM: 0118       FSARA,

8/13/2015 8:57:59 AM: 0119       FSASL,

8/13/2015 8:57:59 AM: 0120       FSBAY,

8/13/2015 8:57:59 AM: 0121       FSC1,

8/13/2015 8:57:59 AM: 0122       FSC2,

8/13/2015 8:57:59 AM: 0123       FSC3,

8/13/2015 8:57:59 AM: 0124       FSHNO,

8/13/2015 8:57:59 AM: 0125       FSHUT,

8/13/2015 8:57:59 AM: 0126       FSKU,

8/13/2015 8:57:59 AM: 0127       FSKUF,

8/13/2015 8:57:59 AM: 0128       FSLVL,

8/13/2015 8:57:59 AM: 0129       FSPSN,

8/13/2015 8:57:59 AM: 0130       FSSTS,

8/13/2015 8:57:59 AM: 0131       FSTAT,

8/13/2015 8:57:59 AM: 0132       FSTGI,

8/13/2015 8:57:59 AM: 0133       FSTOR,

8/13/2015 8:57:59 AM: 0134       FSVIA,

8/13/2015 8:57:59 AM: 0135       FSZON,

8/13/2015 8:57:59 AM: 0136       FTBKA,

8/13/2015 8:57:59 AM: 0137       FTCKN,

8/13/2015 8:57:59 AM: 0138       FTCR,

8/13/2015 8:57:59 AM: 0139       FTIER,

8/13/2015 8:57:59 AM: 0140       FTINT,

8/13/2015 8:57:59 AM: 0141       FTLM,

8/13/2015 8:57:59 AM: 0142       FTPID,

8/13/2015 8:57:59 AM: 0143       FTQTY,

8/13/2015 8:57:59 AM: 0144       FTRKN,

8/13/2015 8:57:59 AM: 0145       FTTMZ,

8/13/2015 8:57:59 AM: 0146       FUSER,

8/13/2015 8:57:59 AM: 0147       FWHSE,

8/13/2015 8:57:59 AM: 0148       FXCOR,

8/13/2015 8:57:59 AM: 0149       FYCOR,

8/13/2015 8:57:59 AM: 0150       FZONE

8/13/2015 8:57:59 AM: 0151 FROM

8/13/2015 8:57:59 AM: 0152 P:\SOURCE_QVDS\PKMS\MEMPHIS2.PKMANH221D.FCART00.qvd

8/13/2015 8:57:59 AM: 0153 (qvd)

8/13/2015 8:57:59 AM: 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

8/13/2015 8:58:06 AM: Execution Failed

8/13/2015 8:58:06 AM: Execution finished.

markgraham123
Contributor II

Re: General Script error ????

Hi Jonathan, please find the script above.

markgraham123
Contributor II

Re: General Script error ????

The problem is.. it was not able to read and fetch the fields from Qvd.

Re: General Script error ????

You got it fixed now???

markgraham123
Contributor II

Re: General Script error ????

Nope sunny.

It still was not able to read the file.

Donno why..

MVP
MVP

Re: General Script error ????

It looks like another process interfered with the qvd file or the qvd file is corrupt. Investigate the corruption by having the QVD generator create a new instance of the file and try again.

You can also see if the QVD generator run time overlapped with this run, or another process locked the file. Check for qv.exe instances in the task manager (qvb.exe if you are doing the reload on QVS/Publisher).

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
kuczynska
Contributor III

Re: General Script error ????

Is there any other QV app reading from this same QVD that could possibly be reloaded at the same time? Did your reload was performing well in the past and this issue started just now?

Are you able to reach the location from the machine you are running your script?

Community Browser