When configuring the connection of Storage Location with Azure Blob in Workstation, the error message "The storage location could not be connected. The API requires Strategy Storage Service. Please contact your administrator" is shown below:
This issue happens on all client machines, and this Azure Blob Storage could be connected using Microsoft Azure Storage Explorer.
In the Library log, found the following error message.
"@timestamp":"2023-05-16T04:18:35.675Z","@version":"1","message":"Unexpected Library database error. Possible reason is that your database configuration (username, password, sslkeys...) is not correct or database server is down.","logger_name":"com.Strategy.rest.filters.DatabaseVersionCheckFilter","thread_name":"https-jsse-nio-8443-exec-49","level":"ERROR","level_value":40000,"stack_trace":"org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLTransientConnectionException: springHikariCPApplication - Connection is not available, request timed out after 10000ms.\
It’s related to the SSL Mode specified in the configOverride.properties file. For more information, please refer to the PostgreSQL official website: https://www.postgresql.org/docs/current/libpq-ssl.html.
Modify "datasource.sslMode=verify-full" to "datasource.sslMode=require" in configOverride.properties file, then restart the Web Application.
