2334115 - OLEDB: Arithmetic overflow during implicit conversion of BIGDATETIME with maximum value - SAP SDK | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

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

Symptom

  • OLEDB driver reports Arithmetic overflow during implicit conversion of BIGDATETIME when using DateTime.MaxValue.
  • ERROR: 

Error in Reconciliation:LoadDataFromPyramid
System.Data.OleDb.OleDbException (0x80040E07): [ZZZZZ]
[Message Class: 16]
[Message State: 1]
[Transaction State: 1]
[Server Name: ASE]
[Procedure Name: ptp_b3_daily_activity]
[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

  • Adaptive Server Enterprise OLE DB Provider by Sybase
  • SAP Adaptive Server Enterprise (ASE) 15.7 
  • SAP Sybase Software Developer Kit (SDK) 15.7 SP130

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) , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.