SAP Knowledge Base Article - Preview

2952720 - Error 942 followed by Error 834 when dropping database - SAP ASE

Symptom

  • Dropping user defined temporary database
  • The following messages reported in errorlog multiple times for different table ID and the database is not invloved in the drop database:
    Error: 942, Severity: 20, State: 2
    00:0023:00000:15475:2020/07/10 22:12:43.62 server Database 'db1' cannot be opened because the system descriptor for table ID 8 cannot be installed.
  • Another connection that access the db1 report the following error and stacks:
    Error: 834, Severity: 20, State: 4
    00:0029:00000:15475:2020/07/10 22:12:52.68 server Illegal attempt to clean buffer: BUF=0x0x00002b516714b6a0, MASS=0x0x00002b516714b6a0, Buf#=0, page=0x0x00002b2c43c04800, dbid=200, Mass vdevno=690, vpage=6852184, Buf lpage=14890584, Mass stat=0x4201008, Buf stat=0x1, size=4096, cid=0 ('default data cache'), Pinned xdes=0x(nil), spid=0.

    cm_dbclean
    bufdbclean
    dbt_removeall
    dbt_get
    dbt_get_with_statuscheck
    dbcontext_change
    usedb
    openrangedes
    get_range_sdes
    open_range
    s_opentables


Read more...

Environment

SAP Adaptive Server Enterprise 16.0 SP02 PL08

Product

SAP Adaptive Server Enterprise 16.0

Keywords

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.