Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

anithashivaling
New Contributor II

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

Re: Incremental load using QVC - Oracle DB

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
Valued Contributor II

Re: Incremental load using QVC - Oracle DB

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');

anithashivaling
New Contributor II

Re: Incremental load using QVC - Oracle DB

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
Valued Contributor II

Re: Incremental load using QVC - Oracle DB

facing this same problem please post the answer

Regards

Community Browser