SAP Knowledge Base Article - Preview

3320149 - SUM PREP_INPUT/DBQUERY_PRE error: Unknown database user '***' - SAP ASE for Business Suite

Symptom

  • SUM phase PREP_INPUT/DBQUERY_PRE to fail with the following error.
    Reading SQL output from 'SYBCONCHECKSSO.LOG'.
    Check password of database user 'sapsa'
    Last error code set is: Unknown database user '<***>'!
    Upgrade phase "DBQUERY_PRE" aborted with severe errors ("20230329175431")

  • /usr/sap/hostctrl/exe/saphostctrl -function LiveDatabaseUpdate -dbname <SID> -dbtype syb -updateoption TASK=VALIDATE_SEC_STORES 

    shows 
    GLOBAL_SAPSA=valid
    LOCAL_SAPSA=valid 
    ASE_SAPSA=valid 

  • "sybctrl verify_secure_store" got below results.

    cannot retrieve connection data for authority type 'SA'.

    OK: connected user <***> to server <hostname>, port <port> via odbc.
    OK: connected user sapsso to server sazatidgrdsi, port <port>via odbc.
    OK: connected user SAPSR3 to server <hostname>,port<port> via odbc.

  • "aseuserstore list sapsa" shows the USERNAME for KEY SAPSA is ***

    [sybgrd@sazatidgrdsi ~]$ aseuserstore list sapsa

    KEY: SAPSA
      CON_ENV       : <hostname> <port>
      USERNAME      : <***>
      PASSWORD      : ***


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE)  16.0 for Business Suite
  • NetWeaver 7.4, 7.5
  • SUM

Product

SAP Adaptive Server Enterprise all versions ; SAP NetWeaver Application Server for ABAP innovation package all versions

Keywords

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 for Me (Login required).

Search for additional results

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