2160732 - loginfo() built-in fails with Error 605 on syslogs - SAP ASE

You are running SAP or custom applications on SAP ASE database.

You use the built-in function, loginfo(<dbid>, 'xactspanbyspid', <spid>) to monitor and manage transaction log space. This invocation fails with Error 605:

Error: 605, Severity: 21, State: 1
An attempt was made to fetch logical page '<pageno>' from cache 'log cache'. Page belongs to database '<dbname>', object '<Unknown>' (0), index '<Unknown>' (0), partition '<Unknown>' (-1) and not to database '<dbname>' (<dbid>), object 'syslogs' (8), index 'syslogs' (0), partition 'syslogs_8' (8)" together with a stack trace which includes the modules 'getpage_with_validation', 'num_logpages' and 'loginfo3_xactspanbyspid'

The job referencing this built-in fails with a stacktrace reported in the ASE errorlog where object id = 8 is the syslogs table. The stacktrace includes the modules:

• getpage_with_validation
• num_logpages
• loginfo3_xactspanbyspid

xactspanbyspid, loginfo3_xactspanbyspid, loginfo_builtin3, getpage_with_validation,  num_logpages, wrongpage, stacktrace, builtin , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed