Views:

Behavior:
When attempting to restore a MySql DocuWare backup, the following MySql error is displayed:

 CREATE TABLE `dwconnectionlicense` (
  `clid` char(36) NOT NULL,
  `slid` char(36) NOT NULL,
  `orgid` int(11) default NULL,
  `guid` char(36) NOT NULL,
  `end_of_license` datetime NOT NULL,
  `checksum` varchar(50) NOT NULL,
  PRIMARY KEY  (`guid`),
  KEY `dwfk_1c1d95f25a1106a4d66b1fdc6` (`slid`),
  CONSTRAINT `dwfk_1c1d95f25a1106a4d66b1fdc6` FOREIGN KEY (`slid`) REFERENCES `dwserverlicense` (`guid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
The server has returned this error message: Cannot add foreign key constraint
MySQL Error.

Solution:
This occurs when your restore tries to overwrite pre-existing database tables. To resolve this issue, drop any pre-existing database schemas before you restore them.
***NOTE: Make sure you have complete backups of your DocuWare databases before following any of the following steps.***

  • Log into either Workbench or MySql administrator, locate and select all DocuWare databases that begin with "dw" and select "Drop 4 Schemas."

                        Work Bench
                       
 

  • In MySql Administration, repeat the previous step for all DocuWare databases.

     

Proceed to restore your backup, which should complete successfully. 
​​​​​​​​​​​​​​​​​​​
KBA is applicable for On-premise Organizations ONLY.

This article is valid for DocuWare versions: 7 7.1 7.2 7.3 7.4 7.5 7.6 7.7 7.8 7.9 | "Cannot add foreign key constraint"