Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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!
There are 2 common problems that could cause this:
share script code?
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;
Hi,
Set vSourceQVDs='..\..\QvdFiles\ExtractedQvds\';
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 ...
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.