Collect troubleshooting data for database problems in IBM Business Process Manager (BPM)

Collect troubleshooting information for database problems in IBM Business Process Manager. Gathering this information before calling IBM support helps in understanding the problem and saves time when analyzing the data.

Setting the trace string

Set the trace string to

​*=info:org.springframework.jdbc.*=all:WAS.clientinfopluslogging=all

That would log the SQL queries that are run in the background.

Note: Enabling the trace might slow down your system. This delay can lead to transaction time-outs and errors. Disable this trace after collecting the requested information.

To set the tracing and generate a new set of logs and traces, complete the following steps for the servers or cluster that show the issue:

1. In the Integrated Solutions Console, under ​Troubleshooting​ ​>​ ​Log and Trace​, pick the server for which you want to change the settings. ​
   
   
2. Click Change Log Detail Levels​.
   
   
3. Select the ​configuration tab to set the tracing. This change takes effect after the next server restart and a completely new set of log files can be collected. Optionally, select the runtime​ tab to dynamically set the tracing.
   
   
4. Enter the trace string and click OK.
   
   
5. If you selected the configuration tab, stop the server.
   
   
6. Archive and delete the current logs/traces/ffdc from the following directories:
   • <install​​_​​root>​​/​​profiles/<profile​​_​​name>​​/​​logs​​/<​​server​​_​​name>
   • <install​​_​​root>​​/​​profiles/<profile​​_​​name>​​/​​logs​​/ffdc
     
     
7. Start the server and check the trace.log file to make sure that the correct tracing is set.
   
   
8. Reproduce the problem and note down the timestamp. Check the trace.log file to ensure that the time of the issue is covered in the file. Gather the complete server log files and the ffdc directory.
   
   
9. Delete the trace string from the Log Detail Level for your server.
   
   

Note: Ensure that you have set the Maximum trace file size (recommendation: 20MB) as well as the number of historical trace files (recommendation: 20) to an appropriate value. You can find those values at Servers > Application Servers > server_name > Diagnostic Trace Service.

General diagnostic information

Collect the general troubleshooting information as described in Collect troubleshooting data for the IBM Business Process Manager products.

In addition:

• Describe the problem in detail
• Can you say which database/data source has the issue?
• Which database vendor and which version are you running?
• Is the database located on another physical machine?
• Which JDBC driver are you using?
• Is the connection test for your data sources successful? (In the Integrated Solutions Console, click Test Connection under Resources > JDBC > Data sources)

What to do next

1. Review the logs and traces at the time of the problem to try to determine the source of the problem.
   
   
2. Use IBM Support Assistant to search for known problems in the information center, forums, and technotes.
   
   
3. If you cannot find related problems or cannot solve the problem, send the information you have collected to IBM by following the instructions in Exchanging Information with IBM Technical Support.