Views:

Important Note:
Before attempting the changes in the following KBA, please take a complete database backup. If performed Incorrectly your DocuWare system will not work.


Behavior:

When Upgrading to DocuWare versions 7 or higher, old File cabinet tables are re-named. If the length of the re-named tables exceeds 32 characters in the database, the update will fail with an error such as the below.

“Rename of DOCUWARE_TESTING_FILE__CABINETS will fail. DWSYS.ARCHIVE size is 32”

The BOLD Value will be the name of the file cabinet which is failing, you can find this error in the log file located in C:\Programdata\DocuWare\setuplogs. The name of the fille is: CTServerUpgrader.log.

Solution:

1.  Within the DWData database, right-click > Edit Table. Enter the new adjusted name in the Table Name field and select accept (A safe length is 25 character or less). There are 6-7 tables for each cabinet which need to be renamed. Don’t change the suffix, ie. _DSKS.  Make sure to take note of the old table name, we will need it fir later queries.


                          Before                                                                                      After         

                                                  


NOTE: Making these changes does not have an impact on the name of the filecabinet from the web client side. The file cabinet name will be exactly the same for users.


2. Now changes need to be made to the DWSys table located in the DWData database.
There is a reference within this table to the old file cabinet name, the below query is a find and replace which updates this value. This query only needs to be ran once for each adjusted File cabinet.

  UPDATE DWData.DWSys 
               Set Archive = replace (archive,'OLDTABLENAME','NEWTABLENAME');

In our example the query would look like so:

3. Lastly changes to the DWFilecabinet table located in the DWSystem database need to be made. The settings column of the adjusted file cabinet needs to be updated to reflect the new name. 
The below query is a find and replace for that value. This query only needs to be ran once for each adjusted File cabinet.

  Update DWSystem.DWFileCabinet 
             Set settings = replace (settings,'OLDTABLENAME','OLDTABLENAME');

 

In our example the query would look like so:

Once all affected file cabinets are adjusted you can select the retry option on the installer to re-attempt the Upgrade.