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.
SAP Knowledge Base Article - Preview