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
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.