SAP Knowledge Base Article - Preview

3428022 - DB error 535 :  The datediff function resulted in an overflow. The number of dateparts separating two date/time instances is too large.

Symptom

System gets time difference issue after OS restart. For example, the system time is changed to 2262/12/14 which was extremely far than current time.
After modifying the system time, the system can be started without issue except the database error 535 occurs every 2 hours from job SAP_COLLECTOR_PERFMON_RSDBPREV        

error 535 :  The datediff function resulted in an overflow. The number of dateparts separating two date/time instances is too large.


Read more...

Environment

Netweaver based SAP application systems

Microsoft SQL Server 2005 or higher

Product

SAP NetWeaver 7.5

Keywords

KBA , BC-DB-MSS-SYS , Database Interface/DBMS for MSS , Problem

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.