SAP Knowledge Base Article - Preview

2969774 - "Database <SID> with dbid 4 is already shut down" is returned - SAP ASE for Business Suite

Symptom

  • The application has stopped working and this message can be seen the ASE error log repeated times like this:

00:0009:00000:00769:yyyy/mm/dd 11:35:34.61 server Database <SID> with dbid 4 is already shut down.
00:0009:00000:00070:yyyy/mm/dd 11:35:39.74 server Database <SID> with dbid 4 is already shut down.
00:0009:00000:00873:yyyy/mm/dd 11:35:53.63 server Database <SID> with dbid 4 is already shut down.
00:0009:00000:01196:yyyy/mm/dd 11:35:53.64 server Database <SID> with dbid 4 is already shut down.
00:0009:00000:00724:yyyy/mm/dd 11:35:54.38 server Database <SID> with dbid 4 is already shut down.
00:0009:00000:01313:yyyy/mm/dd 11:35:55.00 server Database <SID> with dbid 4 is already shut down.
00:0009:00000:00682:yyyy/mm/dd 11:35:56.05 server Database <SID> with dbid 4 is already shut down.
00:0009:00000:00066:yyyy/mm/dd 11:35:56.23 server Database <SID> with dbid 4 is already shut down.

  • Same message is reported for any query executed thru isql, like in this sample with sp_helpdb stored procedure:

Database <SID> with dbid 4 is already shut down.
Msg 7408, Level 16, State 1:
Server '<SID>', Procedure 'sp_helpdb', Line 1148:
Could not find a dbtable for database 4.
Database <SID> with dbid 4 is already shut down.
Msg 7408, Level 16, State 1:
Server '<SID>', Procedure 'sp_helpdb', Line 1148:
Could not find a dbtable for database 4.

  • The ASE error log is also reporting Errors 539, 716 and 871 before the  "---------- Shutting Down Database '<SID>' ----------" message.


with dbid 4 is already shut down" is returned - SAP ASE for Business Suite"> Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP Netweaver - All versions 

Product

SAP Adaptive Server Enterprise 16.0 ; SAP NetWeaver all versions

Keywords

shutdown, dbtable, 7408, 716, 539 , 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 ONE Support launchpad (Login required).

Search for additional results

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