WDF 2560046 – The ntext cannot be used as an Operand error occurs when receiving with multiple checks in Incoming to Outgoing Payment process

WDF 2560046 – The ntext cannot be used as an Operand error occurs when receiving with multiple checks in Incoming to Outgoing Payment process

Symptom

The following error occurs when receiving payments with multiple checks during the Incoming-to-Outgoing Payment process:

“The data type ntext cannot be used as an operand to the UNION, INTERSECT or EXCEPT operators because it is not comparable.”

Reproducing the Issue
Prerequisites

You are using Intercompany Integration Solution version 56.0 or lower.

Scenario
1. Create an Incoming Payment with multiple checks in the source company for the Intercompany scenario.
2. Observe that the payment processing fails with the ntext data type error.

Expected Result

The Incoming Payment with multiple checks should be processed successfully, and the corresponding Outgoing Payment should be generated without any database error.

Actual Result

The ntext cannot be used as an Operand error occurs when receiving multiple checks in the Incoming to Outgoing Payment process.

Workaround:

The attached ZIP file is 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.sap.b1i.dev.scenarios.design" file as per the backup process below:
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 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 B1 10.0 FOR SAP HANA
SAP B1 9.3 FOR SAP HANA
SAP BUSINESS ONE 10.0
SAP BUSINESS ONE 9.3