SAP Knowledge Base Article - Preview

1909590 - Invalid data returned by SELECT against monCachedStatement - ASE

Symptom

  • Execution of a SELECT query against the monitoring table monCachedStatement returns invalid data
  • The LastRecompiledDate field shows invalid datetime values

select LastRecompiledDate from monCachedStatement

Aug 30 7105 6:35PM
Dec 9 0306 5:46AM
May 30 7625 3:06AM
Sep 9 5902 6:55AM
Nov 9 7272 3:17AM
Dec 9 0306 5:46AM
Sep 23 7016 3:28AM
Oct 3 0181 9:40PM
Dec 20 1247 10:20PM
Jan 13 6999 7:22AM


Read more...

Environment

  • SAP Sybase Adaptive Server Enterprise (ASE) 12.5.x
  • Sybase Sybase Adaptive Server Enterprise (ASE) 15.0
  • Sybase Sybase Adaptive Server Enterprise (ASE) 15.5

Product

SAP Adaptive Server Enterprise 12.5 ; Sybase Adaptive Server Enterprise 15.0 ; Sybase Adaptive Server Enterprise 15.5

Keywords

wrong results invalid date datetime bad data incorrect , KBA , cr635483 , sybase , mda table , mda , 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 for Me (Login required).

Search for additional results

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