Scenario:
When upgrading to DocuWare 7.7 or later, the system database upgrade or the system database upgrade simulation fails.
In the Phase_SimulateSystemUpgrade.log file or the Phase_UpgradeDatabases.log file (located in %programdata%\DocuWare\SetupLogs), the following error is displayed;
'UNC file path for Fulltext index files is found in database. Upgrade can not continue.'
Solution:
Due to the upgrade of SOLR 4 to SOLR 8 when upgrading to 7.7 or later, we can no longer use a UNC path or mapped drives for fulltext indexes.
To address this, please refer to KBA-34402 to move the index files. Once the path is set in both the admin tool and the solr.xml, you can continue with the upgrade.
The existing fulltext index folders do not need to be moved manually. Since we are upgrading to SOLR 8, all of the existing fulltext indexes cannot be used and will need to be rebuilt regardless, as it is a limitation of SOLR and Java.
If the Server Setup has not yet upgraded the database, you can close the setup, restart the services, and change the file path inside DocuWare Administration. If the database has been upgraded, then we will have to change this manually via the database.
Use this query to find the SOLR connection:
MySQL:
SELECT *
FROM dwsystem.DWSystemSettings
WHERE type = 'DocuWare.Settings.SolrConnectionSettings, DocuWare.Settings'
MSSQL:
SELECT *
FROM [dwsystem].[dbo].[DWSystemSettings]
WHERE type = 'DocuWare.Settings.SolrConnectionSettings, DocuWare.Settings'
Open the settings column of the entry that shows by clicking on it, then copy the entire string to a text editor and update the indexFilesPath. Once completed, use the below update query to change the value in the database.
The below string is just an example of what the update query may look like. Please take a backup of all DocuWare Databases prior to executing the query:
MySQL:
UPDATE dwsystem.DWSystemSettings
SET settings = '<SolrConnection version=5.1.0.1 setid=10 guid=1XXXX-XXXX-XXXXXXXX-XXXXXX name=Default Solr connection default=false tomcatURL=http://DWSERVER:9012/solrt indexFilesPath=C:\ProgramData\DocuWare\Full-Text Index>
<description />
<EnabledOrgs totalNumber=0 />
</SolrConnection>'
WHERE type = 'DocuWare.Settings.SolrConnectionSettings, DocuWare.Settings'
MSSQL:
UPDATE [dwsystem].[dbo].[DWSystemSettings]
SET settings = '<SolrConnection version=5.1.0.1 setid=10 guid=1XXXX-XXXX-XXXXXXXX-XXXXXX name=Default Solr connection default=false tomcatURL=http://DWSERVER:9012/solrt indexFilesPath=C:\ProgramData\DocuWare\Full-Text Index>
<description />
<EnabledOrgs totalNumber=0 />
</SolrConnection>'
WHERE type = 'DocuWare.Settings.SolrConnectionSettings, DocuWare.Settings'
KBA is applicable for On-premise Organizations ONLY.