Symptom
- OLEDB driver reports Arithmetic overflow during implicit conversion of BIGDATETIME when using DateTime.MaxValue.
- ERROR:
Error in Reconciliation:ApplicationName
System.Data.OleDb.OleDbException (0x80040E07): [ZZZZZ]
[Message Class: 16]
[Message State: 1]
[Transaction State: 1]
[Server Name: ASE]
[Procedure Name: Stored_Procedure]
[Line Number: 0]
[Native Code: 247]
[ASEOLEDB]Arithmetic overflow during implicit conversion of BIGDATETIME value 'Jan 1 0000 12:00AM' to a DATETIME field .
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling (OleDbHResult hr)
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult (tagDBPARAMS dbParams, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal (CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader (CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at D.B3.Common.CommonBlotterDC.LoadDataFromPyramid(String conn, ReconciliationParameter parameters, DataTable& pyrDataRaw)
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 15.7
- SAP Sybase Software Developer Kit (SDK) 15.7 SP130
- Adaptive Server Enterprise OLE DB Provider by Sybase
Product
Keywords
SDK for SAP ASE, Open Client, OCS, Developer's, CR#784045, CR784045, 784045 , KBA , BC-SYB-SDK , SDK , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Known Error
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.