Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
anithashivalingappa
Partner - Contributor III
Partner - Contributor III

Incremental load using QVC - Oracle DB

Hi,

Am getting error while trying to setup incremental load using qlikview components. suggest me to fix this. connecting oracle DB, for SQL DB its working fine.

Error.jpg

4 Replies
tresesco
MVP
MVP

It seems that there is a format issue. please check if your date/timestamp format(withing quotes) is similar to the one in database.

perumal_41
Partner - Specialist II
Partner - Specialist II

Hi

Try this code

Select  *

FROM Table1 b where

to_date(b.last_modified_dt, 'dd/mm/yyyy hh:mi PM')

<=to_date('02/04/2013 6:58 PM', 'dd/mm/yyyy hh:mi PM');

anithashivalingappa
Partner - Contributor III
Partner - Contributor III
Author

thanks for your response. the format is same

am using qvs file and calling the incremental function. the script is like this..

SET Qvc.Loader.v.QvdDirectory='F:\IAS_DB\Data';

LET Qvc.Loader.v.BaseValue = num (MakeDate (2013, 01, 01));

SET Qvc.Loader.v.DatabaseDatetimeMask = 'M/D/YYYY h: mm:ss TT';

// Calling parameters are Tablename, UpdateColumn, QVD_PrimaryKey.CALL Qvc.IncrementalSetup ('VIW_MONTHLY_INCIDENT_NODATE', 'LASTMDFDDATE', 'IND_CALL_NO');
Directory;
[$(Qvc.Loader.v.Tablename)]:

LOAD *;
SQL SELECT *
FROM NEWWCCC."VIW_MONTHLY_INCIDENT_NODATE"
WHERE
$(Qvc.Loader.v.IncrementalExpression);

Call Qvc.Log ('$(Qvc.Loader.v.Tablename) loaded, rows=' &

Num (NoOfRows ('$(Qvc.Loader.v.Tablename)'), '#,##0'));

CALL Qvc.IncrementalStore

CALL Qvc.Cleanup;

Also i tried the below script also but its not working. help me out to fix this..

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT'; Let vThisExecTime=Now();

Let vQvd=isnull(QvdCreateTime());

if(vQvd=-1) then

VIW_MONTHLY_INCIDENT_NODATE:
SQL SELECT *
FROM NEWWCCC."VIW_MONTHLY_INCIDENT_NODATE";

Else


SQL SELECT *
FROM NEWWCCC."VIW_MONTHLY_INCIDENT_NODATE" where Trunc(LASTMDFDDATE) >=
$(vLastExecTime) and Trunc(LASTMDFDDATE) <$(vThisExecTime);


Concatenate

LOAD * FROM
[..\Data\VIW_MONTHLY_INCIDENT_NODATE.qvd]
(
qvd) where not Exists(id,id);
ENDIF


Store VIW_MONTHLY_INCIDENT_NODATE into ..\Data\ VIW_MONTHLY_INCIDENT_NODATE.qvd;

DROP Table VIW_MONTHLY_INCIDENT_NODATE;

techvarun
Specialist II
Specialist II

facing this same problem please post the answer

Regards