SAP Knowledge Base Article - Preview

2373568 - Node fails to start after upgrade - SAP ESP

Symptom

  • 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"


Read more...

Environment

SAP Event Stream Processor (ESP) 5.1 SP 12

Product

SAP Event Stream Processor 5.1

Keywords

streaming, processing, upgrade, db, config, upgrading, update , KBA , BC-SYB-ESP , Sybase ESP (Event Stream Processor) , 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.