SAP Knowledge Base Article - Preview

2292843 - Error 8201 "mismatch found between the name and id descriptor hash table for table" - SAP ASE

Symptom

  • An 8201 Error in Business Suite
  • 00:0006:00000:00014:2015/07/07 07:53:37.16 server  Error: 1601, Severity: 17, State: 3
    00:0006:00000:00014:2015/07/07 07:53:37.16 server  There are not enough 'user connections' available to start a new process. Retry when there are fewer active users, or ask your System Administrator to reconfigure ASE with more user connections.
  • 00:0010:00000:00244:2015/09/24 17:35:30.68 server  Error: 8201, Severity: 26, State: 2
    00:0010:00000:00244:2015/09/24 17:35:30.68 server  Keep count of descriptor (objid=987081659, dbid=4) was expected to be 1. Instead 2 was found.
    00:0010:00000:00244:2015/09/24 17:35:30.68 kernel  ************************************
    00:0010:00000:00244:2015/09/24 17:35:30.68 kernel  SQL causing error : CREATE PROC "L6U" AS select data_pages(db_id(),object_id('OIRA_PRINTGP') , 0 ) + data_pages(db_id(),object_id('OIRA_PRINTGP') , 255)
    /* R3::0 T:notab
    00:0010:00000:00244:2015/09/24 17:35:30.68 kernel  Current statement number: 1 Current line number: 1
    00:0010:00000:00244:2015/09/24 17:35:30.68 kernel  ************************************
    00:0010:00000:00244:2015/09/24 17:35:30.68 server  SQL Text: CREATE PROC "L6U" AS select data_pages(db_id(),object_id('OIRA_PRINTGP') , 0 ) + data_pages(db_id(),object_id('OIRA_PRINTGP') , 255)
    /* R3::0 T:notable */
    00:0010:00000:00244:2015/09/24 17:35:30.68 server  SQL Text:  select data_pages(db_id(),object_id('OIRA_PRINTGP') , 0 ) + data_pages(db_id(),object_id('OIRA_PRINTGP') , 255)
    /* R3::0 T:notable */


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

Error 8201, Severity: 17, State: 3, des_clean, des_scavenge, Msg 8201, Error: 1601, Severity: 17, State: 3, CR#786588, CR786588, 786588 , 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.