SAP Knowledge Base Article - Preview

3749784 - Error: Command execution failed. Failed to validate credentials during saphostctrl livedatabaseupdate – SAP ASE

Symptom

  • Below error occurs while updating SAP ASE for Business Suite following SAP KB 2800483 - SYB: Upgrade / Update SAP ASE with SAP Host Agent 7.21 PL43 and later
    saphostctrl -user sapadm pass000 -dbname SID -dbtype syb -function LiveDatabaseUpdate -updatemethod Check -updateoption
    TASK=CHECK_UPDATE_ASE -updateoption DROP_LOCATION="H:\Packages"
    Error: Command execution failed. : Failed to logon sapsid. Please provide valid sapsid credentials in at least one of the supported SAP Secure Stores. (fault code: 127)
  • While checking secure storage info, user sapsid indeed shows missing:
    saphostctrl -user sapadm pass000 -function LiveDatabaseUpdate -dbname SID -dbtype syb -updateoption TASK=VALIDATE_SEC_STORES

    GLOBAL_SAPSA=not found
    GLOBAL_SAPSSO=not found
    GLOBAL_DR_ADMIN=not found
    GLOBAL_SYBSID=not found
    GLOBAL_SAPSID=not found
    GLOBAL_SAPADM=not found
    GLOBAL_SAPSR3=not found
    GLOBAL_SAUPD=not found
    GLOBAL_SA_BS=not found
    GLOBAL_SSL_CERTIFICATE=not found
    GLOBAL_JDK_TRUSTED_STORE=not found
    LOCAL_SAPSA=valid
    LOCAL_SAPSSO=valid
    LOCAL_DR_ADMIN=not found
    LOCAL_SYBSID=valid
    LOCAL_SAPSID=not found
    LOCAL_SAPADM=valid    
    LOCAL_SAPSR3=valid  
    LOCAL_SAUPD=valid
    LOCAL_SA_BS=not found
    LOCAL_SSL_CERTIFICATE=not found
    LOCAL_JDK_TRUSTED_STORE=not found

  • However, while trying to set the missing entry, below error occurs even if the given password is correct:
    saphostctrl -function SetDatabaseProperty -dbname SID -dbtype syb -dbuser Domain\SIDADM -dbpass pass000 USER=SAPSID
    Error: Command execution failed. : Failed to validate credentials. Please make sure you have entered the correct username and password. (fault code: 127)


Read more...

Environment

  • Windows NT system
  • SAP Adaptive Server Enterprise (SAP ASE) 16.0.04 on Business Suite

Product

SAP Adaptive Server Enterprise 16.0.4 ; SAP Solution Manager all versions

Keywords

sybase abap update, failed to logon sybsid, fault code 127, saphostctrl livedatabaseupdate, secure store, db_connect syb, rsecssfx list, sybctrl verify_secure_store, validate_sec_stores, access is denied, sap host agent, login locked , 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.