2373568 - Node fails to start after upgrade - SAP ESP

• The ESP installation was upgraded from 5.1 SP08 or 5.1 SP09 to 5.1 SP12.

• During the upgrade installation process to SP12, a new password was entered for the database administrator (different from the existing password).

• At the end of performing the installation, the installer reports that ESP was successfully installed.

• Starting the cluster database was successful.

• However, when using "start_node.sh node1" to start the initial node, it fails and reports the following error in node1.log:
   

FATAL - CODE_700418 | Could not load config from database
com.sybase.esp.cluster.config.ConfigException: com.sybase.esp.cluster.impl.DatabaseException: com.sybase.esp.cluster.config.ConfigException: com.sybase.esp.cluster.impl.DatabaseException: Could not create database connection
...
Caused by: java.sql.SQLException: JZ00L: Login failed.  Examine the SQLWarnings chained to this exception for the reason(s).
...
FATAL - CODE_700412 | Factory of new node failed

• In the installation log directory, init_cluster_db.log reports the following errors:
   

File/database "/espinstall/ESP-5_1/cluster/config/esp1/esp_cluster.db" already exists
SQL Anywhere Initialization Utility Version 16.0.0.2165
Could not connect to the database.
Invalid user ID or password
SQLCODE=-103, ODBC 3 State="28000"

com.sybase.esp.cluster.config.ConfigException: com.sybase.esp.cluster.impl.DatabaseException: com.sybase.esp.cluster.config.ConfigException: com.sybase.esp.cluster.impl.DatabaseException: Could not create database connection
...
 

• Running "dbping" succeeds when testing to see if the database is reachable.
   
  For example:

/espinstall/ESP-5_1/sqla/bin64s/dbping -d -c "UID=espdadm;PWD=mypassword;ENG=esp_cluster_esp1_myhostname.com;DBN=esp_cluster"
Ping database successful.

• After updating the password in the cluster.cfg to use an unencrypted value (by setting the "jdbc-password-is-encrypted" flag to false) the start_node command fails and reports an exception:

com.sybase.esp.cluster.impl.CipherService$CipherServiceException: Caught exception decrypting data
 

• Running dbisql fails when trying to connect to the database.
   
  For example:

/espinstall/ESP-5_1/sqla/bin64/dbisql -c "uid=espdadm;pwd=mypassword;dbn=esp_cluster" -nogui
Could not connect to the database.
Invalid user ID or password
SQLCODE=-103, ODBC 3 State="28000"

SAP Event Stream Processor (ESP) 5.1 SP 12

streaming, processing, upgrade, db, config, upgrading, update , KBA , BC-SYB-ESP , Sybase ESP (Event Stream Processor) , Problem