WDF 2560048 – STRING_AGG is not a recognized error occurs while replicating Delivery to GRPO

WDF 2560048 – STRING_AGG is not a recognized error occurs while replicating Delivery to GRPO

Symptom

The following error occurs while replicating a Delivery document to a Goods Receipt PO in the intercompany document exchange:

“'STRING_AGG' is not a recognized built-in function name.”

Reproducing the Issue
Prerequisites

1. You are using Intercompany Integration Solution version 56.0.
2. You are using database version MSSQL 2016 or lower.

Scenario
1. Create an intercompany Delivery document in the source company.
2. It triggers the replication of the Delivery to the target company as a Goods Receipt PO.
3. Observe that the replication fails with the STRING_AGG error.

Expected Result

The Delivery should be successfully replicated as a Goods Receipt PO without any database-related error.

Actual Result

STRING_AGG is not a recognized error occurs while replicating Delivery to GRPO.

Workaround:

If you are using Integration Hub version 56.0, follow the steps mentioned below:

A. Download the add-on hotfix version 56.3 from here.

B. The attached ZIP files (count: 2) are to be imported via BizStore Import in Control Center by following the steps below:

1. From your existing environment, take a backup of the "com.cxs.b1i.ipo" and "com.sap.b1i.dev.scenarios.design" files as per the backup process below:
   
To take a backup of the ipo file, perform the following steps:
  1. Log in to Integration Framework 2.0.
  2. Go to Tools -->Control Center --> Maintenance -->BizStore Export.
  3. In Exporting Content from BizStore, under the selection criteria, select the Dataset button.
  4. In Choose Dataset, choose the value "com.cxs.b1i.ipo" and then press the Submit button.
  5. Save the file in the relevant folder.
To take a backup of the package file, perform the following steps:
  1. Log in to Integration Framework 2.0.
  2. Go to Tools -->Control Center --> Maintenance -->BizStore Export.
  3. In Exporting Content from BizStore, under the selection criteria, select the Dataset button.
  4. In Choose Dataset, choose the value "com.sap.b1i.dev.scenarios.design", choose the group "CXS.IC", and then press the Submit button.
  5. Save the file in the relevant folder.
2. Perform the following steps to import the IPO file:
  1. Log in to Integration Framework 2.0.
  2. Go to Control Center --> Maintenance -->BizStore Import.
  3. In Importing Content to BizStore, under Selection Criteria, select the Choose File button next to Choose Archive. 
  4. Select the IPO file "com.cxs.b1i.ipo.zip".
  5. Select the checkbox Assume File System-Friendly Naming and then click Submit.
3. Perform the following steps to import the Package file:
  1. Log in to Integration Framework 2.0.
  2. Go to Control Center --> Maintenance -->BizStore Import.
  3. In Importing Content to BizStore, under Selection Criteria, select the Choose File button next to Choose Archive. 
  4. Select the package file "com.sap.b1i.dev.scenarios.design.zip".
  5. Select the checkbox Assume File System-Friendly Naming, and then click Submit.
Solution

The issue described above will be incorporated in Intercompany Integration Solutions version 57 and higher versions.

Product
Product or Product Version
B1 INTERCOMPANY INTEGRATION
SAP BUSINESS ONE 10.0
SAP BUSINESS ONE 9.3

This document refers to : 
WDF 2570001 - Overview Note for Intercompany integration solution Version 57 for SAP Business One