Reload failed for delta loAD

[#1]

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

[Colin-Albert]

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?

[jagan]

1. LET BeginningThisExecTime = Now();
2. LET LastExecTime = Alt(LastExecTime, 0);
3. 
   
4. EMP: 
5. SQL SELECT EMPNO, 
6.      ENAME, 
7.      JOB, 
8.      MGR, 
9.      HIREDATE, 
10.      SAL, 
11.      COMM, 
12.      DEPTNO, 
13.      ModificationTime 
14. FROM 
15.  
16. (ooxml, embedded labels, table is EMP) 
17. WHERE ModificationTime >= #$(LastExecTime)# 
18. AND ModificationTime < #$(BeginningThisExecTime)#; 
19. 
    
20. LET LastExecTime = BeginningThisExecTime;
21. 
    
22. Concatenate   
23. LOAD EMPNO, 
24.      ENAME, 
25.      JOB, 
26.      MGR, 
27.      HIREDATE, 
28.      SAL, 
29.      COMM, 
30.      DEPTNO 
31. FROM 
32. C:\Users\QV\EMP.qvd 
33. (qvd); 
34. 
    
35. store EMP into C:\Users\QV\EMP.qvd; 
36. 
    

Hope this helps you.

Regards,

Jagan.

[jagan · Accepted solution]

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.

[#5]

Thank you Jagan.