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