Troubleshooting database configuration issues during Engineering Lifecycle Management instance creation

Review the following troubleshooting information for the database connection or authorization issues during Engineering Lifecycle Management instance creation. Related error reason codes are CreateTableErr and DWCreateErr.

Procedure

  1. Access the application pod log. For more information, see Accessing application pod logs.
  2. Go to the application pod log at /elm/server/conf/<app-context-root>/logs/repotools-<application-name>_createTables.log.
    Item Description
    <app-context-root> Application context root
    <application-name> Application name
  3. For the database connection issues, complete the following steps.
    1. Verify that if the following error message is available in the log. 
      CRJAZ2654E The server was unable to connect to the database because 
      the database connection settings are invalid or because database is unreachable 
      (SQLSTATE: 08001, SQLCODE: -4499).
      If the error message is available in the log, the database connection settings that you provided during Engineering Lifecycle Management instance creation are invalid or the database is unreachable.
    2. Verify that correct information is provided in the database connection settings.
  4. For the database authorization issues, complete the following steps.
    1. Verify that if the following error message is available in the log. 
      <~REPO_TOOLS~>~~>
com.ibm.db2.jcc.am.SqlInvalidAuthorizationSpecException: [jcc][t4][2013][11249][4.26.14] 
      Connection authorization failure occurred.  
      Reason: User ID or Password invalid. ERRORCODE=-4214, SQLSTATE=28000
      If the error message is available in the log, the credentials that you provided in secret elm-auth-secret are incorrect.
    2. Provide the valid credentials in secret elm-auth-secret. For more information, see Creating the Engineering Lifecycle Management instance secret.
  5. Create the Engineering Lifecycle Management instance. For more information, see Creating ELM instance in the Red Hat OpenShift and Kubernetes services.
  6. If the issue still exists, contact IBM support.

Troubleshooting JAS database connection issue during Engineering Lifecycle Management instance creation

Review the following troubleshooting information when the JAS database connection is failed during Engineering Lifecycle Management instance creation. Related error reason code is CreateTableErr.

Procedure

  1. Verify that if the following error messages are available in the log.
    1. Go to JTS pod log at /elm/server/conf/jts/logs/repotools-jts_createTables.log and verify that if the following error message is available in the log. 
      <~ERROR~> <~~> <~main~> <~com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication~> 
      CRJAZ2236E There was an error executing setup: "CRJAZ2594E An error occurred while executing request 
      "https://hostname:443/jts/service/com.ibm.team.repository.service.internal.IExternalUserRegistryRestService/createUserById""
    2. Go to JAS pod log at elm/server/conf/jas/logs/messages.log and verify that if the following error message is available in the log. 
      0000003b om.ibm.ws.security.oauth20.plugins.db.CachedDBOidcTokenStore 
      E Internal error getting DB connection: java.sql.SQLInvalidAuthorizationSpecException: 
      [jcc][t4][2013][11249][4.17.29] Connection authorization failure occurred.  
      Reason: User ID or Password invalid. 
      ERRORCODE=-4214, SQLSTATE=28000 DSRA0010E: SQL State = 28000, Error Code = -4,214
    If the error messages are available in the respective log file, the JAS database password that you provided in secret elm-auth-secret is incorrect.
  2. Provide the valid JAS database password in secret elm-auth-secret. For more information, see Creating the Engineering Lifecycle Management instance secret.
  3. If the issue still exists, contact IBM support.