DB connection Issues

Activate driver logs

You can activate logs from DB drivers in order to investigate specific database issues.

Create the file [PM_INSTALL_FOLDER]\workers\worker1\logging.properties

Set the logging properties within the file.

Mind to remove/rename the file once investigation is over

Example for MSSQL:

# Logging levels: OFF, SEVERE, WARNING, INFO, CONFIG, FINE, FINER, FINEST, ALL
# Set the default logging level for all loggers
# .level =ALL
# Configure the file handler
handlers = java.util.logging.FileHandler
java.util.logging.FileHandler.level = ALL
java.util.logging.FileHandler.pattern = mssql.log
java.util.logging.FileHandler.append = true
java.util.logging.FileHandler.formatter = java.util.logging.SimpleFormatter
# Configure the MSSQL driver logger
com.microsoft.sqlserver.jdbc.level = ALL
com.microsoft.sqlserver.jdbc.formatter = java.util.logging.SimpleFormatter
# Uncomment the following line if you want to log the SQL statements
# com.microsoft.sqlserver.jdbc.level = FINEST
# Uncomment the following line if you want to log parameters along with SQL statements
# com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.level = FINEST
# Uncomment the following line if you want to log results along with SQL statements
# com.microsoft.sqlserver.jdbc.SQLServerResultSet.level = FINEST