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
Keywords
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.