3388163 - Database connection issue caused by incorrect value of db.connectionparam.locktimeout

Deployment failed on data migrate step due to failed to connect to database.

here is snippet of error logs:

{"class":"de.hybris.bootstrap.loader.Loader","method":"main","file":"Loader.java","line":108,"exact":false,"location":"ybootstrap.jar","version":"?"}]},"endOfBatch":false,"loggerFqcn":"org.apache.log4j.Category","contextMap":{"Tenant":""},"threadId":1,"threadPriority":5,"origin":"PLATFORM"}
{"instant":{"epochSecond":1696534075,"nanoOfSecond":167428514},"thread":"main","level":"ERROR","loggerName":"de.hybris.platform.jdbcwrapper.JDBCConnectionPool","message":"----------------------------------------\nThu Oct 05 16:27:55 BRT 2023: problem getting database connection\nException message thrown was: The lockTimeOut 3​ is not valid.\n(enable 'db.pool.dumpThreadsOnConnectionError' to see complete thread dump)\n----------------------------------------","endOfBatch":false,"loggerFqcn":"org.apache.log4j.Category","contextMap":{"Tenant":""},"threadId":1,"threadPriority":5,"origin":"PLATFORM"}

SAP Commerce Cloud

dumpThreadsOnConnectionError, db.connectionparam.lockTimeout , KBA , CEC-SCC-CLA-DEP , Deployments , Problem