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
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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.