Views:

Behavior: 
When trying to create a database connection for Notification's, but the option is missing.

Solution:
We can manually adjust the use for “Email notification” on the database side.

   1. Create a new database connection in the Admin Tool by right-clicking the "Data Connections" tab, then select "Create New Database Connection"

   2.Name it “DWnotification”. For now, select any one of the available “used for” options when creating the connection.

   3. In the database section you can enter dwnotification as the database, then enter the username and password for your database, then Select "Finish".

   4. Once completed, open your database and run the following query.


***Make sure you have a complete database backup before making any changes you your database.***
 

MSSQL:

 use dwsystem
       update DWSystemSettings
       set settings = replace (cast (settings as nvarchar(max)),'usedForNotifications="false"','usedForNotifications="true"')
       where type like '%databaseconnection%'
       and cast (settings as nvarchar(max)) like '%<name>DWnotification</name>%'

 

MySQL:

use Dwsystem;
     update dwsystemsettings
     set settings = replace(settings,'usedForNotifications="fasle"','usedForNotifications="true"')
     where type like '%databaseconnection%'
     and settings like '%<name>DWnotification</name>%'

 

   5. Your database connection “DWnotification” has now had “email notification’s” enabled.

   6. If you were in the process of upgrading your DocuWare system, you may now proceed with your upgrade.

 

Comments (0)