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 for Me (Login required).

Search for additional results

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