Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

ORA-01843 ORA-02063 on OIAS 903

60 views
Skip to first unread message

Jochen

unread,
Sep 1, 2004, 9:23:18 AM9/1/04
to
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

Frank van Bortel

unread,
Sep 2, 2004, 4:09:35 AM9/2/04
to
Jochen wrote:

Where's the 8th argument? I don't see "updated" (which I presume
to be a date, too) updated.
Probably the default date format was changed on the "client" (which
would be the application server) - never manipulate
dates without an explicit format.
--

Regards,
Frank van Bortel

Jochen

unread,
Sep 8, 2004, 7:04:30 AM9/8/04
to
>
> Where's the 8th argument? I don't see "updated" (which I presume
> to be a date, too) updated.
> Probably the default date format was changed on the "client" (which
> would be the application server) - never manipulate
> dates without an explicit format.


All arguments are ok. There is a problem with OIAS or sth dependent
on. If i run the statement from another server, it works correct.
Where does OIAS changed my date format. If this the real problem? I
think no.

The problem, i have to analyse, is the OIAS in configuration files or
JDBC drivers i think.

Knows sb about this problem?

Jochen

0 new messages