Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ORA-01843 ORA-02063 on OIAS 903

ORA-01843 ORA-02063 on OIAS 903

From: Jochen <jri_at_doneware.de>
Date: 1 Sep 2004 06:23:18 -0700
Message-ID: <9331ca31.0409010523.2ff3f2ad@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US