2427071 - DBA Cockpit Transaction Log Usage SQL247 Arithmetic overflow during explicit conversion of UNSIGNED BIGINT value '18446744073709421284' | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2427071 - DBA Cockpit Transaction Log Usage SQL247 Arithmetic overflow during explicit conversion of UNSIGNED BIGINT value '18446744073709421284'

Symptom

  • DBA Cockpit -> Data Collectors and Admin Procedures -> Transaction Log Usage got errors in Object Log:

           Start of routine: saptools..SP_DBH_TXNLOGUSAGE (Log Level: 3) 
           Arithmetic overflow during %S_MSG conversion of %s value '%s' to a %s field .
           Error in job scheduling / execution (job exit code = 0; job user code = 1-)
           Msg 247, Level 16, State 1: 
           Arithmetic overflow during explicit conversion of UNSIGNED BIGINT value '18446744073709421095' to a INT field .

           [ASE Error SQL247][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Arithmetic overflow during explicit conversion of UNSIGNED BIGINT value '18446744073709421114' to a INT field .

  • It is following SQL statement reporting error 247 in stored procedure 'saptools..SP_DBH_TXNLOGUSAGE' :

           INSERT INTO saptools..DBH_SNAP_TXNLOGUSAGE (COLLECT_MODE, .....) SELECT  ...
           FROM  master..sysdatabases AS SRC_LOGINFO WHERE SRC_LOGINFO.status2 & -32768 = 0  /* DBH_TXNLOGUSAGE: SNAPSHOT */

  • The culprit is loginfo(4,'total_pages') within above query. It returns huge value so to cause Arithmetic overflow:

           SELECT  loginfo(dbid,'total_pages') FROM master..sysdatabases AS SRC_LOGINFO WHERE SRC_LOGINFO.status2 && -32768 = 0
           go

           --------------------
           18446744073709421069

  • sp_spaceused syslogs in the database returns negative value for used_pages, which is incorrect:

           1> sp_spaceused syslogs
           2> go
           name            total_pages     free_pages      used_pages      reserved_pages
           --------------- --------------- --------------- --------------- ---------------
           syslogs         1179648         1304518         -124900         30

  • dbcc usedextents(dbid,0,1,1) cannot fix the issue;    

 


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 SP02 PL05 for Business Suite
  • SAP NetWeaver (NW) 7.50 SP6

 

Product

SAP Adaptive Server Enterprise 16.0 ; SAP NetWeaver 7.5

Keywords

SYB, ASE, dbacockpit, DBA cockpit, Transaction Log Usage, SP_DBH_TXNLOGUSAGE, DBH_SNAP_TXNLOGUSAGE, loginfo, sp_spaceused, syslogs, 7408, log free space, SQL247
, KBA , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , Problem

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.