topic Re: General Script error ???? in QlikView

General Script error ????

markgraham123 — Thu, 13 Aug 2015 14:04:54 GMT

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.

Re: General Script error ????

sunny_talwar — Thu, 13 Aug 2015 14:06:48 GMT

Can you share the script Mark

Re: General Script error ????

jonathandienst — Thu, 13 Aug 2015 14:08:33 GMT

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.

Re: General Script error ????

markgraham123 — Thu, 13 Aug 2015 14:10:24 GMT

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.

Re: General Script error ????

markgraham123 — Thu, 13 Aug 2015 14:10:47 GMT

Hi Jonathan, please find the script above.

Re: General Script error ????

markgraham123 — Thu, 13 Aug 2015 14:16:23 GMT

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

Re: General Script error ????

sunny_talwar — Thu, 13 Aug 2015 14:17:54 GMT

You got it fixed now???

Re: General Script error ????

markgraham123 — Thu, 13 Aug 2015 14:20:06 GMT

Nope sunny.

It still was not able to read the file.

Donno why..

Re: General Script error ????

jonathandienst — Thu, 13 Aug 2015 14:26:59 GMT

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).

Re: General Script error ????

kuczynska — Thu, 13 Aug 2015 14:29:09 GMT

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?

Re: General Script error ????

markgraham123 — Thu, 13 Aug 2015 14:38:53 GMT

Hi,

There is no other file related to it.

Moreover, it just fails sometimes and gets executed at times. Its crazy.

Re: General Script error ????

kuczynska — Thu, 13 Aug 2015 14:52:29 GMT

Try to reload/debug your code in QlikView Desktop, you might see something more useful in your log file.

Re: General Script error ????

sasiparupudi1 — Thu, 13 Aug 2015 18:54:16 GMT

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);

Re: General Script error ????

qlikviewwizard — Fri, 14 Aug 2015 02:57:42 GMT

Can you attach the sample file?

Re: General Script error ????

Fri, 14 Aug 2015 12:17:27 GMT

try to load the only some rows with First Function to debug the issue like below

First 100

LOAD

FROM Source.qvd (qvd) ;

Re: General Script error ????

Gabriel — Fri, 14 Aug 2015 13:25:43 GMT

This looks like read write issue. Is there any other application reading the same qvd file at same time?

Check this

Re: General Script error ????

Colin-Albert — Fri, 14 Aug 2015 13:28:07 GMT

Can you copy the QVD to a new filename in windows, this will show if the file is locked by another app.

Re: General Script error ????

Peter_Cammaert — Fri, 14 Aug 2015 13:29:28 GMT

The QVD is probably empty.