Troubleshooting the "Cannot Obtain Lock" exception during the consolidation
The "Cannot obtain lock" exception is a retryable error that typically relates to performance constraints during the consolidation process. To effectively address this issue, please review and perform the following actions:
-
Evaluate Consolidation Batch Size
Navigate to Intercompany Administration Console → Preferences → Consolidation Configuration → Consolidation Batch Size.
Consider increasing the batch size to improve processing efficiency, and then retry the consolidation. -
Optimize Date Range for Consolidation
Review the date range configured for the consolidation process. If the range is too broad, try running the consolidation over a shorter period to reduce system load. -
Validate DI Proxies and Groups
Ensure that the configuration of DI Proxies and group settings are correctly implemented and properly aligned with each company’s System Landscape Directory (SLD) configuration. -
Review Server Memory Allocation
Check both the total RAM available on the server and the RAM allocated to Tomcat. If necessary, increase the allocation to Tomcat to enhance performance.
After completing these checks and optimizations:
-
Reset the Consolidation Process
Go to Intercompany Administration Console → Preferences → Consolidation Configuration and reset the consolidation. Please refer to the screenshot provided for guidance.
Once reset, re-run the consolidation process. As this is a retryable error, the process may succeed after optimization. -
Verify Consolidation Account Mapping
Confirm that consolidation account mappings are fully configured in all branch companies before initiating the consolidation.
By following these steps, you can significantly improve system performance and reduce the likelihood of encountering the "Cannot obtain lock" exception.
Related Articles
Troubleshooting B1if Runtime User details
Verify the details in the "B1i Server Details" window in all the SAP Business One companies in the landscape. To display the B1i Server Details window, choose Administration → Setup → Intercompany → B1i Server Details. To know more information about ...Troubleshooting Replication Issues for Intercompany Master Data or Transactions
Verify SAP B1if Services: Ensure all services are running smoothly. If they are already running, we recommend restarting all services, including the SAP B1 Integration Framework, Event Sender, and DI Proxy services. Please ensure that the appropriate ...System Health Check (System Status) tool for troubleshooting in Intercompany Solution
The users can look forward to the addition of a powerful "System Health Check" tool within the Intercompany Administration Console. This innovative feature empowers administrative users to initiate a thorough health check, obtaining a wealth of ...Consolidation Setup in Intercompany Solution
To setup the consolidation process, perform the following tasks: Define the consolidation companies in the Intercompany Landscape application and set their Company Type as Consolidation. In the Administration Console, on the Company Registration ...Monitor Consolidation Report in Intercompany Solution
The monitor consolidation report enables you to view the journal entries not imported into the consolidation company from the branch company during the financial consolidation process. To view the monitor consolidation report, perform the following ...