Error to connect to a view in oracle

[fkeuroglian]

Hi expert, i have this error when i try to connect to a view

i no have the field "mes" but in the error i see in the message

what could be?

i not have acces to the view

thank you  a lot

Fernando

[Anonymous]

It's because the month is not in the correct format. Try TO_DATE function after the SQL sentence.

[#3]

The error you receive is related to the conversion of a date.
In your data (on Oracle) you have a date when the month is invalid.

Check the format in which you created the view and verify that it corresponds to general settings in QlikView script.

For more information see the link:

http://www.techonthenet.com/oracle/errors/ora01843.php

[avinashelite]

check the format of that column once ??

[sasiparupudi1]

check your dates, may be you are passing a wrong format? may be for example? passing  31 april instead of 30th april

[fkeuroglian]

Hi Avinash, i do not have any column called "MES" only one date column called Fecha

[avinashelite]

thanks for the info, I think the issue is some thing else ...can you please share your script ?? let have check

[Anonymous]

Fernando,It's because the month is not in the correct format. Try TO_DATE function after the SQL sentence.

[#9]

MES is not a field but the message in Spanish.
The message says that the "month is not valid"