DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Get_DBTIMESTAMP: unrepresentable DateTime

385980Jun 2 2003 — edited Jun 5 2003

Hello,
our .NET webservice intermittently fails when retrieving DATE values from the database, see exception below. We have checked the DATE values with SQLPlus, checked regional settings of the Oracle client machine, tested with domain and local users. The application can run for hours reading a constant DATE field from a database table, but suddenly it fails. Usually, we restart the ASPNET process but sometimes the problem can disappear by itself after some 30 minutes.

Has anybody encountered similar problems?
We have not found any way to reproduce the problem deterministically. We consider to upgrade to W2K SP3 and Oracle OLEDB 9.2.0.2.0.

Our system:
Client: W2K SP2, .NET 1.1, Oracle 9.2.0.2.1, OLEDB 9.2.0.1.0
Server: Oracle 9.2.0.3 for OpenVMS

System.ArgumentOutOfRangeException: Specified argument was out of the range of valid values.
Parameter name: Hour, Minute, and Second parameters describe an unrepresentable DateTime.
at System.DateTime.TimeToTicks(Int32 hour, Int32 minute, Int32 second)
at System.Data.OleDb.DBBindings.Get_DBTIMESTAMP(IntPtr buffer)
at System.Data.OleDb.DBBindings.get_Value_DBTIMESTAMP()
at System.Data.OleDb.DBBindings.get_Value()
at System.Data.OleDb.OleDbDataReader.GetValue(Int32 ordinal)
at System.Data.OleDb.OleDbCommand.ExecuteScalar()
at OM.Exigo.SGDatabaseD.CDbAccess.RunSQLReturnObject(String sqlStmt, CDbParameter[] parameters)

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 3 2003

Added on Jun 2 2003

#oracle-provider-for-ole-db, #windows-and-net

1 comment

583 views