Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
kkkumar82
Specialist III
Specialist 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
        
5 Replies
miguelbraga
Partner - Specialist III
Partner - Specialist III

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

Clever_Anjos
Employee
Employee

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"

swuehl
MVP
MVP

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

SELECT * FROM nls_session_parameters WHERE parameter = 'NLS_DATE_FORMAT'; 
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Anonymous
Not applicable

Hi kkkumar82,

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

Regards!