SAP Knowledge Base Article - Preview

2334115 - OLEDB: Arithmetic overflow during implicit conversion of BIGDATETIME with maximum value - SDK for SAP ASE

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

SAP Adaptive Server Enterprise 15.7 ; Sybase SDK 15.7 ; Sybase Software Developer Kit 15.7

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.