WDF 2000007 - Error occurred in Intercompany Reports, Message Log, Financial Consolidation, and Hub Initialization status

WDF 2000007 - Error occurred in Intercompany Reports, Message Log, Financial Consolidation, and Hub Initialization status

Symptom

When using Intercompany Solution with SAP 10.0 FP2208/FP2208 HF01/FP2208 HF02/FP2305/FP2305 HF1 on SQL or HANA, you will face issues in viewing the intercompany reports, viewing the intercompany monitoring logs, viewing the financial consolidation status and the initialization status of hub applications.


HOTFIX Delivery (Version 48 or below): Use the HOTFIX file "2000007.zip" to resolve the issue while staying in your current version

Reproducing the issue

Prerequisites:


You are using Intercompany Solution with the following SAP Business One versions:
  1. SAP Business One 10.0 FP2208/FP2208 HF01/FP2208 HF02/FP2305/FP2305 HF1
  2. SAP Business One 10.0 FP2208/FP2208 HF01/FP2208 HF02/FP2305/FP2305 HF1, version for SAP HANA

Scenario:

When using Intercompany Solution with SAP 10.0 FP2208/FP2208 HF01/FP2208 HF02/FP 2305/FP2305 HF1 on SQL or HANA, you will face the following issues:

1. Intercompany Monitoring 
The operational issue in intercompany monitoring. When clicking on the display log button in the message log, it doesn't show the transaction logs, and the default current date does not appear. 
Following are the intercompany monitoring logs where a similar issue occurs:
  1.   Message Log
  2.  Failure Notification Log
  3.  Audit Log
  4.  Monitor Consolidation
Sample screenshot of the Intercompany Message log is given below for reference:


2. Viewing issues in the intercompany reports:
The Intercompany Solution reports have presentation and formatting issues. In addition, the column header names are not displayed in the reports.
This issue impacted the following reports in the Intercompany solution:
  1. Consolidated Balances by Business Partner Report
  2. Branch Balances Report
  3. Branch Inventory in Warehouse Report
  4. Branch Sales Analysis Report
  5. Un-Posted Intercompany Transactions Report
  6. Reports executed using the Query Manager
Sample screenshot of the Branch Sales Analysis report is given below for reference:



3. Viewing issues in the financial consolidation export and import process screens:
The Intercompany financial consolidation export and import process screens have presentation and formatting issues.
This issue impacted the following export and import process screens in the Intercompany solution:
  1. Chart of Account Distribution – Export Status
  2. Chart of Account Distribution – Import Status
  3. Manual Consolidation – Export Status
  4. Manual Consolidation – Import Status
  5. Automatic Consolidation – Export Status
  6. Automatic Consolidation – Import Status
Sample screenshot of the Manual Consolidation - Import Status is given below for reference:


4. Viewing issues in the initialization status of the hub applications: 
The initialization status screen of hub applications has presentation and formatting issues.
This issue impacted the initialization status screen of the following hub applications:
  1. Shopify
  2. Magento
  3. Salesforce
  4. Dynamics 365 Sales
  5. WooCommerce
  6. Tagrain POS
Sample screenshot of the Shopify Initialization Status is given below for reference:



Workaround :
You need to download the HOTFIX file "2000007.zip"
The downloaded "2000007.zip" file contains the following files:
  1. Intercompany IPO files "com.cxs.b1i.ipo.zip"
  2. Intercompany Repository file "com.cxs.b1i.repository.zip"
  3. Intercompany Package file "com.sap.b1i.dev.scenarios.design.zip"
  4. icons.zip
  5. Readme.txt
Note:
Before importing the zip files, please take the backup of the following files and databases:

1. From your existing environment take the backup of "com.cxs.b1i.ipo" ,"com.cxs.b1i.repository" and "com.sap.b1i.dev.scenarios.design" file as per the backup process below:
   
To take the backup of the ipo files, perform the following steps:
  1. Login into Integration Framework 2.0.
  2. Goto Tools -->Control Center --> Maintenance -->BizStore Export.
  3. In the Exporting Content from BizStore, In the selection critera. Select the Dataset button.
  4. In the Choose Dataset, Choose Value "com.cxs.b1i.ipo" and then press Submit button.
  5. Save the file in the relevant folder.
To take the backup of the repository files, perform the following steps:
  1. Login into Integration Framework 2.0.
  2. Goto Tools -->Control Center --> Maintenance -->BizStore Export.
  3. In the Exporting Content from BizStore, In the selection critera. Select the Dataset button.
  4. In the Choose Dataset, Choose Value "com.cxs.b1i.repository" and then press Submit button.
  5. Save the file in the relevant folder.
To take the backup of the package file, perform the following steps:
  1. Login into Integration Framework 2.0.
  2. Goto Tools -->Control Center --> Maintenance -->BizStore Export.
  3. In the Exporting Content from BizStore, In the selection critera. Select the Dataset button.
  4. In the Choose Dataset, Choose Value "com.sap.b1i.dev.scenarios.design", Choose Group "CXS.IC"  and then press Submit button.
  5. Save the file in the relevant folder.
2. From your existing environment take the backup of following databases:
  1. IFSERV or B1if database
  2. Landscape database
3. Perform the following steps to import the IPO file:
  1. Login into Integration Framework 2.0.
  2. Goto Control Center --> Maintenance -->BizStore Import.
  3. In the Importing Content to BizStore, In the Selection Critera. In the Choose Archive, select the Choose File button. 
  4. Select the IPO file "com.cxs.b1i.ipo.zip".
  5. Select the checkbox Assume File System-Friendly Naming and then Submit.
4. Perform the following steps to import the Repository file:
  1. Login into Integration Framework 2.0.
  2. Goto Control Center --> Maintenance -->BizStore Import.
  3. In the Importing Content to BizStore, In the selection critera. In the Choose Archive, select the Choose File button. 
  4. Select the repository file "com.cxs.b1i.repository.zip".
  5. Select the checkbox Assume File System-Friendly Naming and then Submit.
5. Perform the following steps to import the Package file:
  1. Login into Integration Framework 2.0.
  2. Goto Control Center --> Maintenance -->BizStore Import.
  3. In the Importing Content to BizStore, In the selection critera. In the Choose Archive, select the Choose File button. 
  4. Select the package file "com.sap.b1i.dev.scenarios.design.zip".
  5. Select the checkbox Assume File System-Friendly Naming and then Submit.
5. Extract the "icons.zip" to the location "..\..\SAP\SAP Business One Integration\IntegrationServer\Tomcat\webapps\Landscape".

Solution:

The issues described above can be fixed using either of the following methods:

Option 1. Upgrade to Version 49 or higher:
Upgrade to Version 49 by downloading the latest version from My Account > Downloads (https://walldorfsolutions.com/my-account/downloads/)

Option 2. Stay at Version 48 or below: 
Use the HOTFIX file "2000007.zip" to resolve the issue while staying in your current version



After fixing the above issues, sample screenshots are given below for reference:

Intercompany Message log 


Branch Sales Analysis report


Manual Consolidation - Import Status


Shopify Initialization Status 



Product
Product or Product Version
INTERCOMPANY SOLUTION
SAP B1 10.0 FOR SAP HANA
SAP BUSINESS ONE 10.0