WDF 2000015 - The error "invalid column name: U_CTX_UDFQ" while opening the Query Manager in SAP Business One

Symptom

The following error occurs while opening the query manager window in SAP Business One if the intercompany solution addon is connected:

General error; 260 invalid column name: U_CTX_UDFQ: line 1 Col23 (at pos 22)

Reproducing the issue

Prerequisites:

You are using one of the Intercompany Solution versions: 41.5, 42.5, 43.5, 44.5, or 45.5.

Scenario:

The following error occurs while opening the query manager window in SAP Business One:

General error; 260 invalid column name: U_CTX_UDFQ: line 1 Col23 (at pos 22)

Expected result:

The query manager window opens successfully without any errors.

Actual result:

The error "invalid column name: U_CTX_UDFQ" while opening the Query Manager in SAP Business One.

Workaround:

Create a UDF at the Users master in all the databases in the landscape. Below are the details for the UDF:

Title - CTX_UDFQ

Description - Replicate User Defined Queries

Length - 1 (Alphanumeric)

Valid Values - i. Y - Yes

            ii. N - No

Set Default Value for Field - N

The screenshot is given below for your reference:

Solution:

The issue described above has been fixed in the Intercompany Integration Solutions version 46.5 and higher versions.

Product

Product or Product Version

INTERCOMPANY SOLUTION

SAP B1 10.0 FOR SAP HANA 

SAP BUSINESS ONE 10.0 

SAP B1 9.3 FOR SAP HANA 

SAP BUSINESS ONE 9.3

• Related Articles

• WDF 1844555 - Troubleshooting Intercompany Integration Solution for SAP Business One

  Symptom You have followed the Administrator's Guide and the User Guide for the intercompany integration solution for SAP Business One (integration solution). However, you require assistance and troubleshooting. Solution In addition to this WDF Note, ...

• WDF 2520015 - The "Invalid field name" error occurs while opening the A/R Credit Memo using the Refund button in the Delivery for the Magento connector

  Symptom The following error occurs while opening the A/R Credit Memo document using the Refund button in the Delivery document for the Magento connector. "Error Description :Data Source - Invalid field name [66000-18]" Reproducing the issue ...

• WDF 2460011 - Invalid object name '@OE_USERINFO' error may occur in add-on installation while migrating from SAP Intercompany solution to Walldorf Intercompany

  Symptom Invalid object name '@OE_USERINFO' error may occur in add-on installation while migrating from SAP Intercompany Solution to Walldorf Intercompany Reproducing the issue Prerequisites: You are using Walldorf Intercompany Add-On Version 46.0. ...

• 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 2510014 - Fails to replicate the intercompany draft A/P Invoice in the HANA environment

  Symptom The following error occurs while the intercompany type draft A/P Invoice is created in the recipient company in the HANA environment: SAP DBTech JDBC:[260] (at 49): invalid column name: T0.BASEABS: line 2 col48 (at pos49) Reproducing the ...