Unable to log in to the Db2 Big SQL console

After you install the Db2® Big SQL console, you are unable to log in.

Symptoms

The following error appears.
HWCSEC0102E: The repository database for authentication is unavailable, Please contact the administrator or refer to log file for more details.

When you check the /var/log/uc/logs/repoUtil.0 file, you find the following details:

monitor (1023) <timestamp> ERROR Error occured while establish JDBC connections [jcc][t4][10107][11233][4.24.92] Password length, 0, is not allowed. ERRORCODE=-4461, SQLSTATE=42815
com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][t4][10107][11233][4.24.92] Password length, 0, is not allowed. ERRORCODE=-4461, SQLSTATE=42815
at com.ibm.db2.jcc.am.b6.a(b6.java:810)
at com.ibm.db2.jcc.am.b6.a(b6.java:66)
at com.ibm.db2.jcc.am.b6.a(b6.java:116)
at com.ibm.db2.jcc.t4.b.e(b.java:2449)
at com.ibm.db2.jcc.t4.b.a(b.java:2467)

Resolving the problem

To resolve the problem, perform the following steps as the Db2 Big SQL console user (the default user is conuser).
  1. In a command-line interface, go to the /usr/ibmpacks/bigsql-uc/7.1.0.0/ibm-datasrvrmgr/Config directory.
  2. Run ./crypt.sh <Db2 Big SQL console user password>.

    The crypt.sh utility encrypts the password that you enter.

  3. Edit the /usr/ibmpacks/bigsql-uc/7.1.0.0/ibm-datasrvrmgr/Config/metadb.properties file.
  4. In the password field, type the encrypted password.
  5. Save the file.
  6. In Cloudera Manager, restart the Db2 Big SQL console.