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 , Business Suite on Adaptive Server Enterprise , 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.