8 Replies Latest reply: Feb 2, 2016 6:55 AM by tulasiram bi RSS

    General Script Error when Reload Qvd Generator

    tulasiram bi

      Hi Frnz,

      I am not able to reload in server. I have given correct path names but getting error " General Script Error". Please find the attached Log file. Please help me.

        • Re: General Script Error when Reload Qvd Generator
          Peter Rieper

          Think that you need one more blank in your statement

           

          STORE VW_CPTR_KPIS into ..\..\QvdFiles\ExtractedQvds\VW_CPTR_KPIS.qvd (qvd);

           

          Edit says that it might be better to add a semicolon to the line

          HTH Peter

          • Re: General Script Error when Reload Qvd Generator
            Colin Albert

            Check that the QVD file is not locked by another process, this can cause the script to fail with a General Error.

            One way to check if the file is locked is to try and rename the file. Obviously change the name back if you do change it!

            • Re: General Script Error when Reload Qvd Generator
              Kwok Chong

              There are 2 common problems that could cause this:

               

               

              1. The path is incorrect, check that the path is correct
              2. QlikView might not have permission to overwrite the file, delete VW_CPTR_KPIS.qvd
              • Re: General Script Error when Reload Qvd Generator
                tulasiram bi

                Hi,

                Please find the code.

                 

                OLEDB CONNECT32 TO [Provider=SQLOLEDB.1;Persist Security Info=True;User ID=etlloader;Initial Catalog=GSTDW;Data Source=GNA-QVUAT-V01;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=GNA-QVCL-V06;Use Encryption for Data=False;Tag with column collation when possible=False] (XPassword is WEDJSSROMDbeWQRMFTcEA);

                 

                VW_CPTR_KPIS:

                LOAD "PLNT_C" as Plant,

                    "CTRY_T",

                    "STAT_TYPE_C",

                    "STAT_TYPE_DESC",

                    "ASST_C",

                    "ASST_GRP_C",

                    "OEE_GRP_DESC_T",

                    "MFRNG_REF_I",

                    "CUSTOM_REFERENCE",

                    "OEE_GRP_C",

                    "SHFT_C",

                    "IMPUTATION_DATE" as Date,

                    "IMPUTATION_MONTH",

                    "STROKES_PERCENTAGE",

                    "SERVER_UPDATE_TIME",

                    "LOCAL_UPDATE_TIME",

                    "SPCL_PROD_MODE_C",

                    "DATA_TYPE_C",

                    "UPDT_TYPE_C",

                    "WRKNG_DAY_C",

                    "MFRNG_PHS_C",

                    "COPROD_C",

                    "MFRNG_ORD_I",

                    "REF_VRSN_I",

                    "CNTR_Q",

                    "DURTN_Q",

                    "PLC_FCTR_Q",

                    "SPCL_MODE_Q",

                    "STAT_TYPE_Q",

                    "KT_REF_Q",

                    "KT_WRKPLC_Q",

                    "KNCK_CNTR_Q",

                    "TOT_PRT_PRDCD_Q",

                    "THRTCL_CDNC_Q",

                    "THRTCL_PROD_Q",

                    "FULL_PROD_Q",

                    "PRT_RCVRG_Q",

                    "SCRP_PCS_Q",

                    "GOOD_PRT_Q",

                    "DCTD_WRKPLC_TIME_Q",

                    "SMLTNTY_Q",

                    "THRTCL_PRT_Q",

                    "WRKNG_DAY_CNTR_Q",

                    "CRTE_USER_I",

                    "CRTE_TS",

                    "UPDT_USER_I",

                    "UPDT_TS",

                    "OPENING_TIME",

                    PERFORMANCE,

                    "PERFORMANCE_COUNT",

                    "QUALITY_PER",

                    "QUALITY_COUNT",

                    BREAKDOWN,

                    "BREAKDOWN_FREQUENCY",

                    "BREAKDOWN_FREQUENCY30",

                    BREAKDOWN30,

                    "TOTAL_DURATION",

                    QUALITY,

                    "TOTAL_STROKES",

                    "PLANNED_DOWNTIME",

                    "UNPLANNED_DOWNTIME",

                    "TOOLING_DOWNTIME",

                    "TOOLING_DOWNTIME_FREQUENCY",

                    "PRODUCTION_DOWNTIME",

                    "PRODUCTION_DOWNTIME_FREQUENCY",

                    "MACHINE_DOWNTIME",

                    "MACHINE_DOWNTIME_FREQUENCY",

                    "PROCESS_OPERATION",

                    "NEW_REFERENCE",

                    "SCHEDULED_MAINTENANCE",

                    "PRODUCTION_TIME",

                    PP006,

                    "AVG_DIE_CHANGES",

                    "DIE_CHANGE_FREQUENCY",

                    "Die_Change_Count",

                    "AVAILABILITY_CORPORATE",

                    "OEE_CORP",

                    "OEE_PLANT",

                    "ASPH_CORPORATE",

                    "ASPH_PLANT",

                    "LOT_SIZE";

                SQL SELECT *

                FROM GSTDW.dbo."VW_CPTR_KPIS";

                 

                 

                 

                 

                STORE VW_CPTR_KPIS into $(vSourceQVDs)VW_CPTR_KPIS.qvd(qvd);

                drop Table VW_CPTR_KPIS;