topic General Script Error when Reload Qvd Generator in QlikView

General Script Error when Reload Qvd Generator

tulasiram_bitra — Tue, 02 Feb 2016 10:02:09 GMT

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

prieper — Tue, 02 Feb 2016 10:24:32 GMT

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 — Tue, 02 Feb 2016 10:29:09 GMT

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

quwok — Tue, 02 Feb 2016 10:29:29 GMT

There are 2 common problems that could cause this:

The path is incorrect, check that the path is correct
QlikView might not have permission to overwrite the file, delete VW_CPTR_KPIS.qvd

Re: General Script Error when Reload Qvd Generator

Anonymous — Tue, 02 Feb 2016 10:30:13 GMT

share script code?

Re: General Script Error when Reload Qvd Generator

tulasiram_bitra — Tue, 02 Feb 2016 10:45:50 GMT

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;

Re: General Script Error when Reload Qvd Generator

tulasiram_bitra — Tue, 02 Feb 2016 10:51:13 GMT

Hi,

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

Re: General Script Error when Reload Qvd Generator

avinashelite — Tue, 02 Feb 2016 10:58:07 GMT

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

Re: General Script Error when Reload Qvd Generator

tulasiram_bitra — Tue, 02 Feb 2016 11:55:50 GMT

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.