1999458 - DUMP TRAN command raises error Msg 4205 "Syslogs does not exist in its own segment..." - SAP ASE

• When running 'dump transaction' command
• On a database with no dedicated log segment
• sp_helpdb showing 'mixed log and data' in Status field and
• sysusages.segmap for that database show a value of "7"
• Error 4205 is raised:

Msg 4205, Level 16, State 1:
Server 'ASE', Line 1:
Syslogs does not exist in its own segment in database '<database>' with segmap '7' with logical start page number of '0'.
You cannot use DUMP TRANSACTION in this case, use DUMP DATABASE instead.

SAP Adaptive Server Enterprise (ASE). Not version specific.

4205 , sp_logdevice , "mixed data and log segment" , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem