SCH not starting after upgrade/first installation

When trying to start StreamSets ControlHub after an upgrade or a fresh installation the application fails to start with an error as:

2020-02-18 05:48:21,371 [requestId:] [app:] [componentId:] [user:] [thread:main] WARN  AbstractTask - Task 'dpm' failed to start, java.lang.RuntimeException: java.lang.StringIndexOutOfBoundsException: String index out of range: -5, calling stopTask() and going into ERROR
java.lang.RuntimeException: java.lang.StringIndexOutOfBoundsException: String index out of range: -5

Here is a list of the possible causes for this error:

• Some of the configurations for the SCH applications are not correct. We would need to verify in the $DPM_CONF directory that all the files *-app. properties have a proper configuration for the Database details:

# Database configuration
db.openjpa.ConnectionDriverName=com.mysql.jdbc.Driver

# Sample jdbc url: jdbc:mysql://mysqldb.com:3306/jobrunner
db.openjpa.ConnectionURL=jdbc:mysql://localhost:3306/jobrunner

db.openjpa.ConnectionUserName=user
db.openjpa.ConnectionPassword=password

• Verify that all the databases are properly created in your database. From SCH 3.14.0 and above these are the databases you should have:

dynamic_preview
jobrunner
messaging
notification
pipelinestore
policy
provisioning
reporting
scheduler
sdp_classification
security
sla
timeseries
topology

• Check that all databases above have been populated with the needed tables. In case the tables are missing we can run the script $DPM_HOME/dev/01-initdb.sh to populate the databases.