Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

kkkumar82
Valued Contributor III

Invalid Month error in QVC

Hi all,

I am getting an Invalid month error while trying incremental load using qvc component.errors.PNG

Any help , I am using MM/DD/YYYY format

rwunderlich
        
Tags (1)
5 Replies
miguelbraga
Valued Contributor III

Re: Invalid Month error in QVC

Hello there,

This is the first time that appears this error? If so, does the LAST_UPDATE_DATE have the date in your format? If not, then be careful because you might encounter some problems...

Hope it helps

Regards,

MB

Employee
Employee

Re: Invalid Month error in QVC

Maybe your Oracle clients is configured into another DATE format

Please use just after your connecti

SQL

alter session set nls_date_format="MM/DD/YYYY"

MVP
MVP

Re: Invalid Month error in QVC

could you try to execute this and post the resulting table line?

SELECT * FROM nls_session_parameters WHERE parameter = 'NLS_DATE_FORMAT'; 
MVP & Luminary
MVP & Luminary

Re: Invalid Month error in QVC

If you set the correct database:

SET Qvc.Loader.v.Database=ORACLE;

and then use the QVC generated variable:

SELECT * FROM table

WHERE $(Qvc.Loader.v.IncrementalExpression);

QVC should take care of the correct formatting for datetime.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

manucamon
Valued Contributor III

Re: Invalid Month error in QVC

Hi kkkumar82,

How are you calculating this date?. Use addmonths, don't add +1 in months.

Regards!