17 Replies Latest reply: Aug 14, 2015 9:29 AM by Peter Cammaert RSS

    General Script error ????

    Mark Graham

      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

          Can you share the script Mark

            • Re: General Script error ????
              Mark Graham

              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 ????
                Mark Graham

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

              • Re: General Script error ????
                Jonathan Dienst

                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 ????
                  Michalina Kuczynska

                  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 ????
                      Mark Graham

                      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 ????
                          Michalina Kuczynska

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

                          • Re: General Script error ????
                            Sasidhar Parupudi

                            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 ????
                          arjun rao

                          Can you attach the sample file?

                          • Re: General Script error ????
                            Srikanth P

                            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 Oluwaseye

                              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 ????
                                Peter Cammaert

                                The QVD is probably empty.

                                 

                                P.