Qlik Compose - Data Lake Storage Zone JDBC parameters
This article is to inform the community on the behavior with Data Lake projects where the Storage zone Test Connection is successful but the task starts and get's stuck at 10% without running any queries/task statements in the Database.
Qlik Compose for Data Lakes
The reason is there are additional parameters setup in the JDBC connection string which are not valid but Test connection doesn't detect them as they are not mandatory for general connection.
The parameters can be for enabling Log Level and providing the path to store the jdbc logs. If the directory gets wiped out for some reason, the Test connection would still work but when the task cannot access it to save the logs it will fail to start.
Review all the parameters in the JDBC connection string and remove the ones which are not required.
Sample screenshot from Storage Zone connection where the JDBC parameters are setup: