Help, I am having a problem with ETL it is refusing to transform the data. The log says that it has trouble transforming from char to datetime format... Could it be localization settings on the machine? What do I need to change in my SQL Server?
Here is the error:
03/07/24 17:34:43.011 JST 2293760 main@6589979 INFO TRANSFORM started
03/07/24 17:34:43.402 JST 3387392 main@6589979 EXCEPT Unhandled exception happend. Exiting ...[ExcptMsg: The conversion of a char data type to a datetime data type resulted in an outof
ange datetime value. Severity 16, State 3, Procedure 'IMAI null', Line 1]
Add info:
SQLState: 01000
Message: The conversion of a char data type to a datetime data type resulted in an outof
ange datetime value. Severity 16, State 3, Procedure 'IMAI null', Line 1
Vendor: 242
Stack Trace:
java.sql.SQLException: The conversion of a char data type to a datetime data type resulted in an outof
ange datetime value. Severity 16, State 3, Procedure 'IMAI null', Line 1
at weblogic.jdbcbase.mssqlserver4.TdsStatement.processWarning(TdsStatement.java:1207)
at weblogic.jdbcbase.mssqlserver4.TdsStatement.parseMsWarning(TdsStatement.java:1129)
at weblogic.jdbcbase.mssqlserver4.TdsStatement.getMoreResults(TdsStatement.java:812)
at weblogic.jdbcbase.mssqlserver4.TdsStatement.execute(TdsStatement.java:211)
at weblogic.jdbcbase.mssqlserver4.TdsStatement.executeQuery(TdsStatement.java:51)
at WatchDog.perform(WatchDog.java:69)
at Transformer.start(Transformer.java:241)
at Transformer.main(Transformer.java:547)
03/07/24 17:34:43.402 JST 3387392 main@6589979 END Log closed
T