====== 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