Question:
ServerSetup is displaying on of the following or a similiar error message when connecting to the database during an upgrade or initial installation.
- Setup cannot continue because your machine is running an unsupported database server version.
- Setup cannot continue because your machine is running %MySQL Version x% which is unsupported.
- "Only MSSQL versions 09.x, 10.x, 11.x, 12.x, 13.x are supported"
Answer:
You're running DocuWare against an unsupported database version.
Please check the following KBA to see an overview of database to DocuWare compatibility.
Compatible Windows and Database versions for DocuWare On-premises
Additionally you can check the upgrade path to find the best possible upgrade path for your system.
DocuWare Update path
Once the DocuWare Server Setup encounters this issue, please stop the Setup and check your database installation.
For a more detailed look into MySQl, MSSQL or Oracle, please choose:
To get the exact installed version of MySQL, please execute this command on your database.
SHOW VARIABLES LIKE "%version%";
This will display the currently iinstalled MySQL version.
Please check the following KBAs to get the correct upgrade path for your environment.
Be sure that your MySQL database is running on the correct collation, which can be done by executing the following query
SELECT TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, COLLATION_NAME
FROM INFORMATION_SCHEMA.COLUMNS
In case of DocuWare 7.13, be sure to use the correct MySQL version <> collation mix, else DocuWare will not work correctly.
MySQL has collations set on database, table and column level.
If you need to adjust the collation, adjust each level individually
If your MSSQL database is not supported by the currently used DocuWare Server Setup, please check the System requirements.
You can get your exact version, please execute the following query
SELECT @@VERSION
With this information, you can check the Microsoft documentation and get a more readable MSSQL version.
If for some reason you cannot move to a supported MSSQL database version, you can disable the check for the DocuWare Server Setup.
If any error occurs because an unsupported database version, you will have to move to a supported database version on your own.
Disable SQL Server version check for DocuWare
Oracle is supported until DocuWare 7.9.
Later DocuWare versions are unable to use Oracle as their main databases.
Using Oracle for select lists is still possible.
If you're using a later DocuWare version and use Oracle for select lists, DocuWare Server setup might still show a message that Oracle is no longer supported.
This is because the Setup cannot differentiate between a "main database" or only used for select lists in this step.
Disabling the database connections or switching them to MySQL/MSSQL for the time of the upgrade resolves this issue and can be reverted afterwards.
Some basic information about DocuWare upgrades, migration etc:
How to move a DocuWare Database (7+)
How to Upgrade DocuWare Correctly (7.1+)
KBA is applicable for On-premise Organizations ONLY.