Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

tulasiram_bitra
New Contributor III

General Script Error when Reload Qvd Generator

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.

8 Replies
prieper
Honored Contributor II

Re: General Script Error when Reload Qvd Generator

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

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!

quwok
Contributor III

Re: General Script Error when Reload Qvd Generator

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
balrajahlawat
Esteemed Contributor

Re: General Script Error when Reload Qvd Generator

share script code?

tulasiram_bitra
New Contributor III

Re: General Script Error when Reload Qvd Generator

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;

tulasiram_bitra
New Contributor III

Re: General Script Error when Reload Qvd Generator

Hi,

Set vSourceQVDs='..\..\QvdFiles\ExtractedQvds\';

Re: General Script Error when Reload Qvd Generator

as per your log your giving the relative path for the document , if the qvw has changed its path or cluster the relative path might not work properly. Try to set the QVD path for the absolute path and then check the task once ...

Highlighted
tulasiram_bitra
New Contributor III

Re: General Script Error when Reload Qvd Generator

Hi Avinash,

I have given like below:

'C:\ProgramData\QlikTech\Documents\GestampApp\QvdFiles\ExtractedQvds'

This absolute path is working. But we need to give relative path. So, how can i give Please let me know.