Verifying whether you have inefficient business rules - Support and Troubleshooting

Verifying whether you have inefficient business rules Description This article provides common solutions if you notice any of the following symptoms:

Slow transaction response times. General slow performance throughout the instance. Semaphores appear to be locked or have long running times. localhost logs display a slow business rule message. Cause Scripts are stuck in an infinite loop. Queries returned a large result set. A script created an inefficient query by using LIKE instead of = in the Where clause or is running full table scans on large tables. There are global business rules that do not apply to every transaction. Nested queries exist in MySQL server. Many nested queries are capable of bringing your MySQL database to a halt under certain data conditions. Resolution To verify that business rules are efficient:

Log in to your instance and navigate to System Diagnostics > Debug Business Rule to turn on business rule debugging.

Load the form or run the transaction in question. Analyze the debugging output for long transaction times.

Check the system logs to search the output while loading the form or transaction in question. See Use the log file browser for more information.

To resolve a business rule issue:

Navigate to System Definition > Business Rules and open the business rule record in question Clear the Active check box to disable the business rule Click the Update button to save the record The next step in the resolution process depends on the part of the business rule that is causing the issue. The following table lists the common issues found when working with business rules and how to resolve them. Global business rules may not need to be global Set the business rule to run on a specific table and specify a condition(s). JavaScript errors Function calls are generating errors Verify the function exists. Verify the function is spelled correctly. Search for any parameter requirements. Variables are generating errors Verify the variables are spelled correctly. Review the data type of the variable(s) in question. Review the value of the variable(s) in question. Verify the value has been initialized. The system is generating a large result set Verify that the GlideRecord query filters out all unnecessary results. If the issue continues to exist after trying the steps in this article:

Clearly identify the issue or question. Visit the ServiceNow product documentation . Search the ServiceNow Community . Post a question on the ServiceNow Community forums . New users must create an account on the ServiceNow Community in order to post. Open an incident via email or the online Technical Support system. Contact the Technical Support team. Additional Information For more information on related topics, review the following:

Business Rules Performance Metrics Troubleshooting slow performance