topic Re: Reload failed for delta loAD in QlikView

Reload failed for delta loAD

Thu, 29 Jan 2015 07:23:47 GMT

Hi All,

I am facing reload failed error for delta-inserts.

How to resolve?

EMP:
SQL SELECT EMPNO,
     ENAME,
     JOB,
     MGR,
     HIREDATE,
     SAL,
     COMM,
     DEPTNO,
     ModificationTime
FROM

(ooxml, embedded labels, table is EMP)
WHERE ModificationTime >= #$(LastExecTime)#
AND ModificationTime < #$(BeginningThisExecTime)#;
Concatenate

LOAD EMPNO,
     ENAME,
     JOB,
     MGR,
     HIREDATE,
     SAL,
     COMM,
     DEPTNO
FROM
C:\Users\QV\EMP.qvd
(qvd);
store EMP into C:\Users\QV\EMP.qvd;

EMPNO	ENAME	JOB	MGR	HIREDATE	SAL	COMM	DEPTNO	ModificationTime
7369	SMITH	CLERK	7902	17-Dec-80	800		20	23-Jan-82
7499	ALLEN	SALESMAN	7698	20-Feb-81	1600	300	30	23-Jan-82
7521	WARD	SALESMAN	7698	22-Feb-81	1250	500	30	23-Jan-82
7566	JONES	MANAGER	7839	2-Apr-81	2975		20	23-Jan-82
7654	MARTIN	SALESMAN	7698	28-Sep-81	1250	1400	30	23-Jan-82
7698	BLAKE	MANAGER	7839	1-May-81	2850		30	23-Jan-82
7782	CLARK	MANAGER	7839	9-Jun-81	2450		10	23-Jan-82
7788	SCOTT	ANALYST	7566	9-Dec-82	3000		20	23-Jan-82
7839	KING	PRESIDENT		17-Nov-81	5000		10	23-Jan-82
7844	TURNER	SALESMAN	7698	8-Sep-81	1500	0	30	23-Jan-82
7876	ADAMS	CLERK	7788	12-Jan-83	1100		20	23-Jan-82
7900	JAMES	CLERK	7698	3-Dec-81	950		30	23-Jan-82
7902	FORD	ANALYST	7566	3-Dec-81	3000		20	23-Jan-82
7934	MILLER	CLERK	7782	23-Jan-82	1300		10	23-Jan-82

Re: Reload failed for delta loAD

Colin-Albert — Thu, 29 Jan 2015 07:49:16 GMT

Does the qvd file exist?

Your post shows the variables as. #$(variablename)# this should be '$(variablename)'

Do the formats of the variables match the fields they are being compared to?

Re: Reload failed for delta loAD

jagan — Mon, 02 Feb 2015 02:24:00 GMT

LET BeginningThisExecTime = Now();
LET LastExecTime = Alt(LastExecTime, 0);
EMP:
SQL SELECT EMPNO,
ENAME,
JOB,
MGR,
HIREDATE,
SAL,
COMM,
DEPTNO,
ModificationTime
FROM
(ooxml, embedded labels, table is EMP)
WHERE ModificationTime >= #$(LastExecTime)#
AND ModificationTime < #$(BeginningThisExecTime)#;
LET LastExecTime = BeginningThisExecTime;
Concatenate
LOAD EMPNO,
ENAME,
JOB,
MGR,
HIREDATE,
SAL,
COMM,
DEPTNO
FROM
C:\Users\QV\EMP.qvd
(qvd);
store EMP into C:\Users\QV\EMP.qvd;

Hope this helps you.

Regards,

Jagan.

Re: Reload failed for delta loAD

jagan — Tue, 03 Feb 2015 14:40:20 GMT

Hi,

Check this working script

LET BeginningThisExecTime = Now();

LET LastExecTime = Alt(LastExecTime, 0);

Temp:

LOAD EMPNO,

ENAME,

JOB,

MGR,

HIREDATE,

SAL,

COMM,

DEPTNO,

ModificationTime

FROM

test.xlsx

(ooxml, embedded labels, table is Sheet1)

WHERE ModificationTime >= '$(LastExecTime)'

AND ModificationTime < '$(BeginningThisExecTime)';

LET LastExecTime = BeginningThisExecTime;

IF FileSize('C:\Test.qvd') > 0 then

Concatenate (Temp)

LOAD EMPNO,

ENAME,

JOB,

MGR,

HIREDATE,

SAL,

COMM,

DEPTNO

FROM

C:\Test.qvd

(qvd);

EndIF;

store Temp into C:\Test.qvd;

Regards,

Jagan.

Re: Reload failed for delta loAD

Tue, 03 Feb 2015 15:38:03 GMT

Thank you Jagan.