topic ORA-01843: not a valid month in Talend Studio

ORA-01843: not a valid month

_AnonymousUser — Sat, 16 Nov 2024 13:16:20 GMT

Hi,
I have the same talend 4.0.2 installed on 2 different computers.
I have the same proyect on these 2 computers (they point on the same database).
When i run this proyect it runs well on one computer but it gives the following exception on the other:
Exception in component tOracleInput_1
java.sql.SQLException: ORA-01843: not a valid month
Do someone has an idea?
Bianca

Re: ORA-01843: not a valid month

Anonymous — Wed, 29 Sep 2010 11:29:49 GMT

Hi
Its an SQL Exception, check your query

Re: ORA-01843: not a valid month

_AnonymousUser — Wed, 29 Sep 2010 12:08:08 GMT

The query is perfect.
The job runs perfectly on one computer.
But on the other computer it gives me that exception. (same proyect, same query, same database)

Re: ORA-01843: not a valid month

Anonymous — Wed, 29 Sep 2010 12:17:31 GMT

Hi
di you check driver version oracle client and country settings (windows ??)
Benjamin