Scenario:
After upgrading to DocuWare 7 or higher, a "spinning wheel" appears when attempting to open the Autoindex Configurations page. In the Settings logs, the following error is shown:
"Simple filter format is not supported!"
Solution:
This error occurs when the "Simple Filter" couldn't be converted to the new format during the upgrade process.
To resolve this behavior, the Autoindex jobs in the results need to be removed from the database table and be recreated.
1. We must first detect which AutoIndexes are not correctly upgraded. We can run the following SQL command on the database:
MSSQL:
SELECT * FROM [dwsystem].[dbo].[DWOrganizationSettings] where [type] LIKE '%AutoIndex%' AND CAST([settings] as nvarchar(max)) LIKE '%format="Simple"%'
MySQL:
SELECT * FROM dwsystem.dworganizationsettings where type like '%autoindex%' and settings like '%format="Simple"%'
2. Next, we must remove these entries from the database to regain access to the Autoindex Configurations. We can delete these entries with the following query:
***Before making any changes please take a backup of the DWSystem database first.***
MSSQL:
DELETE FROM [dwsystem].[dbo].[DWOrganizationSettings] where [type] LIKE '%AutoIndex%' AND CAST([settings] as nvarchar(max)) LIKE '%format="Simple"%'
MySQL:
DELETE FROM dwsystem.dworganizationsettings where type like '%autoindex%' and settings like '%format="Simple"%'
3. Once deleted, refresh your browser and open the Autoindex plugin without issue.
KBA applicable to On-Premises Organization ONLY.
