Special character like & is not recognized for DB user ID password in dSeries

Products

• ESP dSeries Workload Automation
• ESP dSeries Workload Automation - Scheduler (dSeries)

Issue/Introduction

When installing or configuring ESP dSeries Workload Automation v25.0 with SQL Server 2022, using the special characters, like  & in the database user password leads to a connection failure during the server startup process.

Environment

Product Release: ESP dSeries Workload Automation 12.3 or above

Operating System: Any

Database: Any

Cause

Some special characters like ampersand (&) maybe reserved in JDBC connections.  

Also, always use encrypted password in db.properties

Resolution

Use setdbparm to update db.properties file with encrypted password. E.g.

setdbparm rdbms.password

Note: Database password constraints are controlled by the database vendor (e.g., Microsoft SQL Server), not directly by the dSeries application.