SAP Knowledge Base Article - Preview

2045258 - Errorlog / getdate() shows time jumping (incorrect system datetime / time zone), gets reset sometime later - SAP ASE

Symptom

  • Under the following conditions, the ASE log may show inconsistent time stamps that jump ahead by several hours and then return to the proper time:
    • ASE 15.7 on Solaris 10.x prior to update 11 (Generic_147441-23).

    • ASE running in kernel threaded mode.

  • Under these conditions, the ASE error log may show occaisional timestamps that "jump ahead". That is, the error log timestamp increases by several hours for a period of time and then returns to the proper time. For example, the timestamp of 11:02 may jump to 17:30 and then return to 12:38, as shown below:

2014/04/17 10:51:10.83 server Increase the config parameter 'number of open partitions' to avoid descriptor reuse. Reuse may result in performance degradation.
2014/04/17 11:02:08.77 Logon Login failed : User mgoff, Client IP address: '10.1.110.79', Appname: SAM 6.2700, Progname: CT-Library, Progversion: 15.0.0.0, TdsVersion:5.0.0.0.
2014/04/17 17:30:57.31 kernel Begin processing to generate RSA keypair.
2014/04/17 17:30:57.35 kernel Completed processing to generate RSA keypair.
2014/04/17 12:38:07.29 Logon Login failed : User bhoffman, Client IP address: '10.21.153.149', Appname: Rapid SQL, Progname: CT-Library, Progversion: 15.7.0.0, TdsVersion:5.0.0.0.
2014/04/17 12:47:32.68 Logon Login failed : User alyle, Client IP address: '10.63.228.221', Appname: VBUS, Progname: CT-Library, Progversion: 15.7.0.0, TdsVersion:5.0.0.0.
2014/04/17 12:47:56.77 Logon Login failed : User alyle, Client IP address: '10.63.228.221', Appname: VBUS, Progname: CT-Library, Progversion: 15.7.0.0, TdsVersion:5.0.0.0.
2014/04/17 13:06:36.76 Logon Login failed : User pcarpenter, Client IP address: '10.1.110.79', Appname: VBUS, Progname: CT-Library, Progversion: 15.0.0.0, TdsVersion:5.0.0.0.


Read more...

Environment

  • SAP Adaptive Server Enterprise  (ASE) 15.7 
  • SAP Adaptive Server Enterprise  (ASE) 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

threaded mode, timestamps, open partitions , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.