Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> ORA-01843 ORA-02063 on OIAS 903
Hello,
suddenly it came the error on Oracle Application Server OIAS 903.
Logger output:
2004-09-01 13:39:20,343 DEBUG ApplicationServerThread-8 (xxxDO:89) - Now excecute SQL: insert into xxx_T_FILE (bild_id, filetyp_id, pathmap_id, path, filename, fileformat_id, datum, updated) values (1094038760265, 6, 1, '1094038760265', 'PicABC_LR.jpg', 4, to_date('01.09.2004','dd.MM.yyyy'), 0)
Always the statement and the application work fine. But know this error?
2004-09-01 13:39:20,359 ERROR ApplicationServerThread-8 (xxx:96) - SQL
Exception
java.sql.SQLException: ORA-01843: not a valid month
ORA-02063: preceding line from xxx
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:187) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:241) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1477) at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:888)
I restarted the services, OIAS and DB-Services. The same error. I donīt know, what is happen! If i execute the SQL-Statement with PL/SQL-Developer, it work fine! The app is running about 1 year know and the insert sql-statemnt works till now.
Thank you for help and hints,
Jochen
Received on Wed Sep 01 2004 - 08:23:18 CDT