WDF 2353460 - Troubleshooting Performance Issues in Intercompany Integration Solution for SAP Business One

WDF 2353460 - Troubleshooting Performance Issues in Intercompany Integration Solution for SAP Business One

Symptom

You're experiencing performance issues with the Intercompany Solution and require more help to troubleshoot it.

Solution

1. Performance issues while processing transactions in the Integration Framework or on the Database
2. Performance issues with the Intercompany Integration Solution add-on running on the SAP Business One client application
3. Performance improvements already implemented for the Intercompany Integration Solution
4. How to report a performance issue in the Intercompany Integration Solution

1. Performance issues while processing transactions in the Integration Framework or on the Database:

      1.1. Make sure the Integration Framework queue is being processed, if not refer to SAP Note 2173439
      1.2. Check the overall Integration Framework performance as per SAP Note 2192737
      1.3. Review and optimize the Integration Framework's log settings as outlined in SAP Note 1873607. In case the Integration Framework's database size is large or if there's log information no longer required, check section 4.1 of the same Note for how to delete log information
      1.4. As a recommendation in this blog, when working with the Intercompany Integration Solution, implement DI Proxy group with 5 DI Proxies (SAP Note 1993784)

      Important: Whenever SLD registration or email connectivity details are updated, you must deploy the Intercompany Integration Solution again. See also the Administrator's Guide for the Intercompany Integration Solution.

      1.5. If using SAP Business One on HANA, please check:
            1.5.1. General Linux Settings for HANA, as per SAP Note 1944415, 2369910, 1275776, 2235581, 1944799 (make sure the recommended settings for the SUSE Linux version used are applied)
            1.5.2. Make sure THP are disabled as per SAP Note 2131662 and 2391706
            1.5.3. Make sure that the HANA server sizing is correct as per SAP Business One on HANA Sizing Tool
            1.5.4. Make sure the SQL Plan cache is correctly sized as per SAP Note 2040002

      1.6. Set up event filter in Event Sender to avoid unnecessary processing load in the Integration Framework:

If only the Intercompany Integration Solution is being used in the Integration Framework, refer to section 6. Changing Event Sender Settings in the Administrator's Guide for the Intercompany Integration Solution
      1.7. Increase parallel processing threads number in Integration Framework
  1. Edit Xcellerator.cfg (..\SAP\SAP Business One Integration\IntegrationServer\Tomcat\webapps\B1iXcellerator) and change parameter xcl.thread to a larger negative number
  2. Increase the memory used by B1i tomcat in the field "Maximum memory pool" on the "Java" tab located in "...\SAP\SAP Business One Integration\IntegrationServer\Tomcat\bin\tomcat6w.exe"
  3. Restart the Integration service
      1.8. Increase event sender batch count
  1. Run Event Sender setup from (..\SAP\SAP Business One Integration\EventSender\setup)
  2. Go to step 2/5: Configure EventSender Parameters → Change Batch Count to a larger number, e.g. 300 → Next → Next → Next → Finish
  3. Restart Event Sender service from service pane
      1.9. Deactivate sap.B1System package
  1. sap.B1System package is used to create SAP Business One company system entries in Integration Framework → SLD → B1iServer. When a company is added/deleted/updated, the package adds/deletes/updates the system id for the company accordingly. However, in context of intercompany solution, we suggest you to deactivate the package to avoid system id changing during solution runtime which possibly results in queue blocking issue. Once you set up the intercompany landscape, please deactivate the package (go to Integration Framework → Scenarios → Control → Deselect checkbox for package sap.B1System). If you need to add a new company to intercompany landscape, you can manually create the system entry and re-deploy the solution. Refer to SAP Note 2032666 for detailed instructions
      Note: As a consequence, any change to an SLD entry requires the deactivation and reactivation of Scenario Packages that have inbound or outbound using SLD entries, as deactivating sap.B1System deactivates the sap.B1SysSLDSync step

      1.10. Switch off the Integration Framework message log
  1.       This improves data processing performance as it avoids writing unnecessary log to integration framework database. To switch off, go to Integration Framework UI → Maintenance → Cfg MsgLog → Unselect 
      1.11. Replication of large sets or batches of data

The Intercompany Solution is not optimized to replicate very large batches of data, for example SAP Business Master Data. To avoid unnecessary transaction volume, you can replicate this type of large data sets using DTW, as described in Note WDF 2342823. 

2. Intercompany Solution add on running on the SAP Business One:

      2.1. For SAP Business One client application freezing issues, refer to SAP Note 2151806 for a possible solution and further troubleshooting
      2.2. Clear windows temporary files if client login is slow:
  1. Open Windows run prompt (Window+R) and type %temp% in search box , press enter and delete files from this folder
  2. Go to C:\Windows\Temp and delete files from this folder
      2.3. Report an SAP Business One Support Incident as per section 4

3. How to report an Intercompany performance issue on an SAP Business One support incident:
​
      3.1. Run all the steps for the Intercompany Troubleshooting tool, as outlined in Note WDF 2177037 and export the results
      3.2. How many users on average are running the Intercompany add-on?
      3.3. What exact steps allow this issue to be reproduced?
      3.4. If issue is happening on the SAP Business One client while running the Intercompany add-on:
            3.4.1. When does the performance issue occur?
            3.4.2. Are you running the SAP Business One client over Remote Desktop Services?
            3.4.3. Are there any other add-ons running? If the other add-ons are stopped is the performance issue still reproduced?
      3.5. If issue is happening on the SAP Business One Server side:
            3.5.1. For a HANA environment, collect the following:
                  i) Full System Info Dump (see SAP Note 1732157)
                  ii) SAP Business One Sizing tool results
                  iii) Results from query HANA_Configuration_MiniChecks_[HANA_REVISION] from SAP Note 1969700.

Product
Product or Product Version
B1 INTERCOMPNY INTEGRATION 2.0
SAP B1 10.0 FOR SAP HANA
SAP B1 9.3 FOR SAP HANA
SAP BUSINESS ONE 10.0
SAP BUSINESS ONE 9.3

This document is referenced by :
WDF 2872021 - Troubleshooting in SAP Business One Integration Hub - Salesforce Template
WDF 2872015 - Troubleshooting in SAP Business One Integration Hub - UPS Template
WDF 2863887 - Troubleshooting in SAP Business One Integration Hub - Shopify Template
WDF 2838562 - Troubleshooting in SAP Business One Integration Hub - General Issues
WDF 1844555 - Troubleshooting Intercompany Integration Solution for SAP Business One