SAP Knowledge Base Article - Preview

2402812 - arithmatic overflow running sp_helpcache or querying syscachepoolinfo and syscacheinfo

Symptom

  • sp_helpcache
    Msg 247, Level 16, State 1:
    Server 'ASE', Line 1:
    Arithmetic overflow during explicit conversion of FLOAT value '1328.103515625' to a NUMERIC field

    or

    sp_helpcache;
    Msg 3606, Level 16, State 4
    Server 'ASE', Procedure 'sp_helpcache', Line 148
    Arithmetic overflow occurred.
    (return status = -6)

  • select * from syscachepoolinfo
    Msg 247, Level 16, State 1:
    Server 'ASE', Line 1:
    Arithmetic overflow during explicit conversion of FLOAT value '1328.103515625' to a NUMERIC field

  • select * from syscacheinfo
    Msg 247, Level 16, State 1:
    Server 'ASE', Line 1:
    Arithmetic overflow during explicit conversion of FLOAT value '1328.103515625' to a NUMERIC field


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

Msg 247, Level 16, State 1, syscachepoolinfo, syscacheinfo, value, numeric, CR735107, CR#730157, 735107, CR819493 , CR#819493, CR824723, CR#824723 , 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.