WDF 2474389 - CONCAT Issue When Installing Intercompany Solution on MS SQL Server 2008 R2
Symptom
While you are installing the Intercompany Solution 2.0 add-on on MS SQL Server 2008 R2, the following error message may appear and the installation fails:
"There was an error running the SQL script
LandscapeDatabaseCreationScript.sql. Setup will now terminate. Line: 21173
Error: 'CONCAT'is not a recognized built-in function name. (195)"
Reproducing the issue
Prerequisite:
You are trying to install Intercompany Integration Solution 2.0 on MS SQL Server 2008 R2.
Cause
CONCAT (Transact-SQL) is not supported by MS SQL Server 2008 in the required way.
Solution
Please run the installer of Intercompany Integration Solution 2.0 twice.
Note: Make sure you execute the installer with explicit admin privileges; run the program As Administrator by right-clicking.Product
Product or Product Version
B1 INTERCOMPNY INTEGRATION 2.0
SAP B1 VERSION FOR SAP HANA all versions
SAP BUSINESS ONE all versions
This document refers to :
WDF 1844555 - Troubleshooting Intercompany Integration Solution for SAP Business One
Related Articles
WDF 2000011 - Known SAP performance issue in new intercompany installation while executing addon script with SAP 10.0 FP2308 on MS SQL
Symptom While installing the new Intercompany Solution Version 49/Version 50/Version 51 with SAP 10.0 FP2308 on MS SQL, the Add-on script execution may take enormous time. This may take up to 4-6 hours in each company. Reproducing the issue ...WDF 2000004 - Migrating to the Walldorf version of the Intercompany solutions
To migrate to the Walldorf version of the Intercompany solutions, refer to the following section: Version compatibility 1. When installing or upgrading the integration solution, ensure that the version/patch level is compatible with SAP Business One ...WDF 2490003 - Intercompany Solution Reports Enhancements
Symptom When using Intercompany Solution Version 46/Version 47/Version 48 with SAP 10.0 FP2208/FP2208 HF01/FP2208 HF02 on SQL or HANA, You will face Integration Framework (B1if 2.0) presentation and formatting issues in the intercompany reports. ...WDF 2177037 - Troubleshooting Tool for Intercompany Solution
Symptom The Troubleshooting Tool for Intercompany Solution is designed to help partners or customers to identify problems themselves or export all necessary information when creating support incidents. Any effort for operating or troubleshooting in ...WDF 2470030 - Fails to add intercompany A/R Invoice document if the Branch representing BP is a delivery consolidating BP
Symptom The following message occurs while adding an intercompany A/R Invoice document if the branch representing BP is linked to a local or global customer as a "Delivery Consolidation" business partner: (1) This document cannot be added as the base ...