SAP Knowledge Base Article - Preview

2552567 - The temporary database (dbid = 6) is not available - SAP ASE for Business Suite

Symptom

  • SAP ASE is being restarted and ASE error log is reporting this message during recovery phase of the startup (dbid = 6 refers to 'saptempdb' database):

00:0002:00000:000nn:xxxx/xx/xx 15:00:00.78 server The temporary database (dbid = 6) is not available.
00:0002:00000:000nn:xxxx/xx/xx 15:00:00.78 server Temporary database based on the specified soft binding could not be assigned. Assigning temporary database 'tempdb' from the 'default' group.

  • A timeslice error may ensue. It references functions:

    write()
    multdb__set_tempdb()
    b_cerrlog_uio()
    multdb__setassigned_id()
    login()
     

  • Checking ASE Configuration from DBACockpit you can see this parameter 'enable logins during recovery' has value 1.
  • Corresponding to the above occurrence, ASE Error SQL590 maybe received while trying to logon into the system thru SAP Logon - ST22 short dump - :

Database error text: "SQL message: [ASE Error SQL590][SAP][ASE ODBC
Driver][Adaptive Server Enterprise]Dynamic SQL error - Prepared statement
'U3' does not exist.#"


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP NetWeaver (NW) - All versions 

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP NetWeaver all versions

Keywords

"temporary database", binding, saptempdb, prepared statement, Dynamic SQL, "dbid = 6", SQL590, timeslice , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , 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.