SAP Knowledge Base Article - Preview

3027785 - SYB: The database requires DBA interaction - SAP ASE

Symptom

1. Command 'saphostctrl -function ListDatabases' shows following error:

Component name: Database (SYBASE Server Database), Status: Error (The database requires DBA interaction.)  

2. Enable trace level 3 for SAP Host Agent, trace log /usr/sap/hostctrl/work/dev_sapdbctrl shows following messages,

[PID 841] ERROR AT sybOpenClient.cpp:executeQuery:2183 TIME: **** DESCRIPTION: Server message: Number 208, Severity 16, State 1, Line 2, Server * --- Message string: dbname..sapsa_alive_chk not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).  LAST OS-ERROR: (0) : Success
[PID 841] ERROR AT sybServer.cpp:getDatabaseStatus:32782 TIME: **** DESCRIPTION: SAPSA user 'sapsa' failed to interact with the database (delete/insert) LAST OS-ERROR: (0) : Success


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

DBA interaction, saphostctrl, sapsa_alive_chk, dev_sapdbctrl , KBA , BC-DB-SYB , Business Suite 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.