Views:

Behavior:
After upgrading to DocuWare version 7.3 or higher, when attempting to edit an external select list, you receive one of the following errors;

" An object or column name is missing or empty..."

"Select list data cannot be retrieved"

 


Solution:
This is due to an empty parameter in the Select List XML at the database level for MSSQL databases.
Before proceeding, take a backup of the DWSYSTEM database.

  1. Select the top 1000 rows for the DWOrganizationSettings database
  2. Open the settings column xml for the select list that is affected (for this example, the "Select List 6" entry was used)

     
  3. When you open the XML you'll see the tableName parameter has an empty value
  4. You'll need to update the XML with the correct tableName used for the select list connection. Copy the XML and in a new query tab type the following:

    update [dwsystem.[dbo].[DwOrganizationSettings] set settings = 'paste xml here' where setid = 'the setid next to the name of the affected select list'
     
  5. Execute the query and then refresh your configurations page. You should now be able to edit the previously affected select list without error.

KBA is applicable for On-premise Organizations ONLY.

This article is valid for DocuWare versions: 7.3 7.4 7.5 7.6 7.7 7.8 7.9 | Object Column error when trying to edit Select List after upgrade to 7.3 (MSSQL)