WDF 3067041 - Value too long in property province_code or state in address error occurs while replicating Business Partner and Sales Order from Shopify to SAP B1

WDF 3067041 - Value too long in property province_code or state in address error occurs while replicating Business Partner and Sales Order from Shopify to SAP B1

Symptom

Value too long in property province_code  or state error occurs while replicating Business Partner and Sales Order from Shopify to SAP B1.

Reproducing the issue
Prerequisites:

You are using Intercompany Integration Solution PL42 or lower.

Scenario:

Value too long in property province_code  or state error occurs while replicating Business Partner and Sales Order from Shopify to SAP B1.

Expected Result:

Business Partner and Sales Order from Shopify to SAP B1 is replicated successfully.

Actual Result:

Business Partner and Sales Order from Shopify to SAP B1 fails to replicate.

Workaround:

Note:
1. If you are using Intercompany Integration Solution PL41 or Lower, use the attachements with below name:

     i. com.cxs.b1i.repository_PL41.zip

    ii. com.cxs.b1i.dev.scenarios.design_PL41.zip

2. If you are using Intercompany Integration Solution PL42, use the attachments with below name:

    i. com.cxs.b1i.repository.zip

   ii. com.cxs.b1i.dev.scenarios.design.zip

Follow the below instructions to import the attachments:

Attached zip files (count 2) are to be imported via BizStore Import of Control Center.

1. Take the backup of scenario package:

    Integration Framework 2.0 -->Scenarios --> OE.HUB.Shopify package

2. Following are the steps to import the attached zip file in Integration Server:
  1. Login into B1iP Control Center.
  2. From the top menu bar, click Maintenance.
  3. From the left menu, click BizStore Import.
  4. In Import content to the BizStore in Selection criteria, Choose archive. Click on Browse button.
  5. Select the file path for zip file attachment.
  6. Click on Submit button. Caution message will appear. Click on OK button.
  7. SAP B1iP Control Center shows the Import Status.
3. Go the integration hub and edit the existing Shopify template.

4. Uncheck the checkbox for State in field mapping in Scenarios.

5. Deploy the solution again.

Solution
The issue described above has been fixed in the Intercompany integration solution PL43 for SAP Business One, and higher versions.

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 refers to :
WDF 3063771 - Overview Note for Intercompany integration solution 2.0 PL43 for SAP Business One