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

• 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;    

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