Products documentation

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== 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