WorkflowGen 7.16.1 Upgrade

Overview

The following procedures apply to the WorkflowGen 7.16.1 upgrade pack, available at https://github.com/advantys/workflowgen-releases/releases.

Package contents

The upgrade pack is distributed as a compressed file containing the following folders:

  • Inetpub: WorkflowGen web application files

  • Program Files: WorkflowGen Windows Services files

  • Databases: WorkflowGen database update and creation files

IIS server

Stop the IIS server or at least your WorkflowGen web applications if other websites are using the same IIS server.

WorkflowGen Windows Services

Stop the WorkflowGen Directory Sync and Engine services in the Windows Services Management Console.

Backup

Application and data files

Back up the following folders:

  • DRIVE:\Inetpub\wwwroot\wfgen

  • DRIVE:\Program Files\Advantys\WorkflowGen

If the file storage path is not the standard DRIVE:\Inetpub\wwwroot\wfgen\App_Data then you have to back up the corresponding folder.

Database

Perform a standard database backup using your DBMS tools.

Update WorkflowGen web application files

  1. Delete the existing DRIVE:\Inetpub\wwwroot\wfgen\hooks\test folder before copying the files from the upgrade pack, since the upgrade pack contains a newer version.

  2. Copy and overwrite with the upgrade content from Update\Inetpub\wwwroot\wfgen to your WorkflowGen web application folder. By default, the suggested physical path is DRIVE:\Inetpub\wwwroot\wfgen.

Important notes

  • Domain users and the Windows accounts used to run the WorkflowGen IIS application pool and Engine service must have read and write permissions for the \wfgen\app_data folder.

  • Do NOT copy and overwrite your existing DRIVE:\Inetpub\wwwroot\wfgen\web.config file if you want to keep your current WorkflowGen configuration settings and database connection information.

  • It’s possible that the following default CSS files have been updated in this release and could overwrite any changes you had made in your existing installation:

    • \wfgen\App_Themes\Default\portal\css\Default.css

    • \wfgen\App_Themes\Default\admin\css\Default.css

  • If you have made changes to any of the default files in the following folders (e.g. *.aspx, *.css, *.resx files), make a backup of the existing files prior to the upgrade and manually re-apply these changes to the corresponding version 7.x.x files:

    • \wfgen

    • \wfgen\App_Themes

    • \wfgen\App_Data\Templates\Emails

    • \wfgen\App_Data\Templates\Forms

    • \wfgen\App_Data\Templates\Processes

Update WorkflowGen Windows Services files

Overwrite the contents of your WorkflowGen Windows Services folder with the contents of Update\Program Files\Advantys\WorkflowGen. By default, the suggested physical path is DRIVE:\Program Files\Advantys\WorkflowGen.

Important: Do NOT copy and overwrite your existing DRIVE:\Program Files\Advantys\WorkflowGen\Services\bin\*.config files.

Update the web configuration file

This section contains configuration parameter changes to be applied based on the version of WorkflowGen from which you are upgrading. For example:

  • When upgrading to version 7.16.1 from version 7.10.0, apply the changes in the When upgrading from version 7.14.3 and earlier, When upgrading from version 7.14.6 and earlier, When upgrading from version 7.15.2 and earlier, When upgrading from version 7.15.4 and earlier, and When upgrading from version 7.15.5 and earlier sections.

  • When upgrading to version 7.16.1 from version 7.16.0, there are no changes to apply to the configuration file.

Important: You must remove the xmlns attribute from the web configuration file regardless of the version from which you are upgrading. See Remove the xmlns attribute for instructions on how to do this.

When upgrading from version 5.7.4 and earlier

Check the following parameters in your \wfgen\web.config and add them if they are not already there.

<add key="EngineEnableSelfServiceDataAssignException" value="N" />

<add key="EngineNotificationDefaultReplyTo" value="" />

<add key="EngineNotificationMaxFileAttSize" value="10" />

<add key="EngineNotificationTextDetection" value="Y" />

<add key="EngineNotificationServerTimeout" value="3" />

<add key="ApplicationDistributedDatabaseSourceMode" value="0" />

<add key="ApplicationEnableDistributedDatabaseSource" value="N" />

<add key="ApplicationEnableArchiveSiteRedirectConfirmation" value="Y" />

<add key="ApplicationArchiveSiteUrl" value="" />

<add key="ApplicationShowAssociatedDataWithEmptyValue" value="Y" />

<add key="ApplicationSecurityEnableWebAppsSecureMode" value="N" />

Note: WorkflowGen.My and WorkflowGen.My.Web.UI.WebControls (WorkflowFileUpload) version 3.0 or later are required in all your Visual Studio Web Forms if the security feature is enabled. For more information, see the Web apps security: Workflow parameters secure mode WorkflowGen Knowledge Base article.

<add key="PortalEnableComments" value="Y" />

<add key="PortalCommentsRefreshFrequency" value="30000" />

<add key="PortalCommentsPopUpWidth" value="376" />

<add key="PortalCommentsPopUpHeight" value="545" />

<add key="PortalCommentsSortBy" value="DATE_POST" />

<add key="PortalCommentsSortOrder" value="ASC" />

<add key="PortalCommentsExpandView" value="N" />

<add key="PortalCommentsListSize" value="25" />

<add key="PortalDisplayCodeNames" value="N" />

<add key="PortalMaxListSize" value="1000" />

<add key="PortalQuickViewEnabled" value="Y" />

<add key="PortalQuickViewDataName" value="FORM_ARCHIVE" />

<add key="PortalQuickViewDisplayOnMouseEvent" value="CLICK" />

<add key="PortalTextDetection" value="Y" />

<add key="PortalActivityCompleteInBackground" value="N" />

<add key="PortalEnableSearchResultAutoRedirect" value="Y" />

<add key="PortalCommonProcessDataNameList" value="" />

<add key="PortalReportEnableCustomColumns" value="Y" />

<add key="PortalReportAllowUserToCreateCustomColumns" value="Y" />

<add key="ReportsTextDetection" value="Y" />

<add key="AdministrationFormDataProviderName" value="System.Data.SqlClient, System.Data.OleDb, System.Data.Odbc, System.Data.OracleClient" />

<add key="AdministrationEnableDeletionRulesCheck" value="Y" />

<add key="AdministrationRestrictManagerToModifyGlobalParticipant" value="N" />

<add key="AdministrationFormDesignUndoLimit" value="30" />

<add key="DirectorySynchronizationMaxUserDeletionCount" value="0" />

<add key="DirectorySynchronizationSyncGroupMembersUsedInParticipantOnly" value="N" />

Add the following new parameters to <appSettings>:

<add key="PortalFrameSetHeight" value="0,68,*,0" />

Note: The first number in this value is the height of the banner. If your website is configured to display a banner, enter its height in pixels here. The other default values should not be changed.

<add key="PortalEnableCallingCard" value="Y" />

<add key="PortalReportAdvancedViewDefault" value="Y" />

<add key="PortalReportEnableCustomCharts" value="Y" />

<add key="PortalReportEnableQuickMassApproval" value="N" />

<add key="PortalReportAllowUserToCreateCustomCharts" value="Y" />

<add key="PortalDefaultWorkflowGraphicalMode" value="HTML5" />

<add key="ProcessesRuntimeWebServiceAllowedUsers" value="wfgen_admin" />

Note: You can copy this parameter from your existing \wfgen\ws\web.config to \wfgen\web.config.

<add key="EFormAspxPreviousFilesCleanUp" value="Y" />

Note: You can copy this parameter from your existing \wfgen\WfApps\WebApps\eFormASPX\web.config to \wfgen\web.config.

<add key="GetUsersFromDirMaxResultNb" value="100" />

Note: You can copy this parameter from your existing \wfgen\WfApps\WebServices\GetUsersFromDir\web.config to \wfgen\web.config.

<add key="XmlToDatabaseTestMode" value="N" />

<add key="XmlToDatabaseEnableTrace" value="N" />

Note: You can copy these parameters from your existing \wfgen\WfApps\WebServices\XmlToDatabase\web.config to \wfgen\web.config.

<add key="XmlTransPreviousFilesCleanUp" value="Y" />

<add key="XmlTransEnableTrace" value="N" />

Note: You can copy these parameters from your existing \wfgen\WfApps\WebServices\XmlTrans\web.config to \wfgen\web.config.

Remove the following deprecated parameters from <appSettings>:

PortalFollowUpRelevantDataListNumber

PortalPopupRelevantDataListNumber

PortalEnableRequestDataListPopUp

Define the following nodes in <configuration>:

<location path="." inheritInChildApplications="false">
<system.web>
<httpRuntime requestValidationMode="2.0" />
</system.web>
</location>
<location path="wfapps/webforms" inheritInChildApplications="false">
<system.web>
<httpRuntime requestValidationMode="2.0" />
<pages clientIDMode="AutoID" controlRenderingCompatibilityVersion="3.5" />
</system.web>
</location>
<location path="ws" inheritInChildApplications="false">
<system.web>
<httpRuntime requestValidationMode="2.0" />
</system.web>
</location>

Define or update the following node in <configuration>/<system.web>:

<pages validateRequest="false" enableSessionState="false" />

When upgrading from version 6.0.0 and earlier

Add the following new parameters to <appSettings>:

<add key="AdministrationDefaultWorkflowGraphicalMode" value="HTML5" />

<add key="EngineNotificationLogLevel" value="1" />

<add key="RemoteApprovalLogTraceLevel" value="3" />

<add key="RemoteApprovalMailServerSecurity" value="none" />

<add key="RemoteApprovalRefreshInterval" value="180000" />

<add key="RemoteApprovalMailServerType" value="POP" />

<add key="RemoteApprovalLifeSpan" value="0" />

<add key="RemoteApprovalMailServerPort" value="110" />

<add key="ApplicationSecurityPasswordManagementMode" value="V5" />

<add key="ApplicationSecurityMaxLoginAttempts" value="5" />

<add key="ApplicationSecurityMinimumPasswordLength" value="8" />

<add key="ApplicationSmtpPickupDirectory" value="DRIVE:\inetpub\mailroot\Pickup" />

Note: Replace the file path above with the path of your SMTP gateway pickup folder.

<add key="ApplicationSmtpServerTimeout" value="3000" />

<add key="ApplicationSmtpDeliveryMethod" value="SmtpServer" />

Note: The above parameter defines the notification delivery method. By default, it uses the SMTP server, but you can change the SMTP delivery method to Pickup directory in the Administration Module Configuration Panel.

When upgrading from version 6.1.0 and earlier

Add the following new parameter to <appSettings>:

<add key="AdministrationAssociatedActivitiesToSwimlane" value="Y" />

When upgrading from version 6.1.4 and earlier

Add or modify the AdministrationFormDataProviderName parameter as follows:

<add key="AdministrationFormDataProviderName" value="System.Data.SqlClient,System.Data.OleDb,System.Data.Odbc,System.Data.OracleClient,Oracle.DataAccess.Client" />

Note: The Oracle.DataAccess.Client value was added to this parameter in version 6.1.5.

When upgrading from version 6.1.6 and earlier

Add the following new parameters to <appSettings>:

<add key="ApplicationWebFormsPath" value="" />

<add key="EngineNotificationDefaultSenderName" value="" />

<add key="PortalDashboardAutoRefreshInterval" value="0" />

<add key="PortalActivityOnCompleteRedirectToView" value ="N" />

When upgrading from version 6.4.0 and earlier

Add the following new parameters to <appSettings>:

<add key="SendMessageProvider" value="TWILIO" />

<add key="SendMessageAccountSID" value="" />

<add key="SendMessageAuthToken" value="" />

<add key="SendMessageFrom" value="" />

<add key="SendMessageApiUrl" value="https://api.twilio.com/2010-04-01/Accounts/" />

<add key="SendMessageEnableLogs" value="Y" />

When upgrading from version 6.5.0 and earlier

Add the following new parameter to <appSettings> to configure the SENDHTTPPOST workflow application log file, replacing the value n with 0 to disable logging, 1 for simple logs, or 2 for debug logs:

<add key="SendHttpPostLogLevel" value="n" />

When upgrading from version 6.6.0 and earlier

Remove the following deprecated parameters from <appSettings>:

ApplicationImpersonificationUsername

ApplicationImpersonificationPassword

PortalDefaultWorkflowGraphicalMode

ApplicationEnableFlashDetection

When upgrading from version 7.1.1 and earlier

Add the following new parameters to <appSettings>:

<add key="GraphqlQueryTimeout" value="90000" />

<add key="GraphqlOperationTimeout" value="30000" />

<add key="GraphqlMaxOperationCount" value="10000" />

<add key="GraphqlMaxInputFileSize" value="10240" />

<add key="GraphqlInputFileDownloadTimeout" value="100000" />

<add key="HookslInputFileDownloadTimeout" value="100000" />

<add key="HooksOperationTimeout" value="30000" />

<add key="HooksMaxInputFileSize" value="10240" />

<add key="EngineServiceTempApiFilesLifespan" value="2" />

When upgrading from version 7.3.1 and earlier

Add the following new parameter to <appSettings>:

<add key="AdministrationDefaultConditionLanguage" value="JS" />

When upgrading from version 7.6.0 and earlier

Add the following new parameters to <appSettings>:

<add key="ApplicationSmtpEnableSsl" value="N" />

<add key="ApplicationSmtpPort" value="" />

<add key="ApplicationSmtpUsername" value="" />

<add key="ApplicationSmtpPassword" value="" />

When upgrading from version 7.9.1 and earlier

Add the following new parameters to <appSettings>:

<add key="GraphqlMaxInputFileContentSize" value="0" />

<add key="HooksMaxInputFileContentSize" value="0" />

<add key="GraphqlFileInputAllowedFolders" value="" />

<add key="HooksFileInputAllowedFolders" value="" />

When upgrading from version 7.14.3 and earlier

Add the following new parameter to <appSettings>:

<add key="ApplicationSecurityAuthSessionRefreshEnableIFrame" value="Y" />

When upgrading from version 7.14.6 and earlier

Add the following new parameters to <appSettings>:

<add key="EngineServiceInactiveRequestLifespanUnit" value="d" />

<add key="SendHttpPostMaxResponseLength" value="4194304" />

<add key="RestApiClientLogLevel" value="0"/>

<add key="RestApiClientRequestTimeout" value="3000" />

<add key="RestApiClientMaxResponseLength" value="4194304" />

<add key="RestApiClientEnableFilesCleanUp" value="Y" />

<add key="GetUsersFromDirLogLevel" value="0" />

<add key="XmlTransEnableFilesCleanUp" value="Y" />

<add key="MergeFormEnableFilesCleanUp" value="Y" />

<add key="GraphqlInputFileAllowedHttpUrls" value="" />

<add key="HooksInputFileAllowedHttpUrls" value="" />

Remove the following deprecated parameters from <appSettings>:

<add key="XmlTransPreviousFilesCleanUp" value="Y"/>

<add key="MergeFormTempFilesLifeSpan" value="1" />

When upgrading from version 7.15.2 and earlier

  1. Add the following nodes after the existing <location> nodes in \wfgen\web.config:

    <location path="auth" inheritInChildApplications="false">
    <system.webServer>
    <modules>
    <remove name="ApplicationSecurityAuthenticationModule" />
    </modules>
    </system.webServer>
    </location>
    <location path="hooks" inheritInChildApplications="false">
    <system.webServer>
    <modules>
    <remove name="ApplicationSecurityAuthenticationModule" />
    </modules>
    </system.webServer>
    </location>
    <location path="scim" inheritInChildApplications="false">
    <system.webServer>
    <modules>
    <remove name="ApplicationSecurityAuthenticationModule" />
    </modules>
    </system.webServer>
    </location>
  2. Remove the node below from \wfgen\auth\web.config, \wfgen\hooks\web.config, and \wfgen\scim\web.config, if present:

<modules>
<remove name="ApplicationSecurityAuthenticationModule" />
</modules>

When upgrading from version 7.15.4 and earlier

Add the following new parameter to <appSettings>:

<add key="PortalRedirectAllowedHttpUrls" value="" />

Important note:

As of version 7.15.5, the optional BACKURL_SUBMIT and BACKURL_CANCEL HTTP parameters used in custom WorkflowGen URLs (for example, when launching a new request and starting the first action within another website) now ONLY support absolute URLs (starting with http:// or https://), relative URLs (starting with /), or URLs defined in the PortalRedirectAllowedHttpUrls configuration parameter (e.g. value='blank.htm, myPage.htm').

When upgrading from version 7.15.5 and earlier

  1. Add the following to the <configuration> node in\wfgen\web.config:

    <location path="graphql" inheritInChildApplications="false">
    <system.webServer>
    <httpProtocol>
    <customHeaders>
    <add name="Access-Control-Allow-Origin" value="*" />
    <add name="Access-Control-Allow-Methods" value="GET, POST, OPTIONS, HEAD" />
    <add name="Access-Control-Allow-Headers" value="Accept, Origin, Authorization, Content-Type, x-wfgen-impersonate-username, x-iisnode-auth_user" />
    </customHeaders>
    </httpProtocol>
    </system.webServer>
    </location>
  2. Change the default value of RestApiClientRequestTimeout from 3000 to 30000 milliseconds.

  3. Make the following modifications to each Node.js component's web.config file (located in \wfgen\graphql, \wfgen\hooks, \wfgen\scim, and \wfgen\auth):

    • Change the iisnode handler path from server.js to dist/server.js.

    • Change the rewrite rule url property from server.js to dist/server.js.

    It should look as follows:

    <handlers>
    <add name="iisnode" path="dist/server.js" verb="*" modules="iisnode"/>
    </handlers>
    <rewrite>
    <rules>
    <rule name="DynamicContent">
    <conditions>
    <add input="{{REQUEST_FILENAME}}" matchType="IsFile" negate="True"/>
    </conditions>
    <action type="Rewrite" url="dist/server.js"/>
    </rule>
    </rules>
    </rewrite>

Remove the xmlns attribute

In WorkflowGen version 7.x.x, you must remove the xmlns attribute from these configuration files:

\wfgen\web.config \wfgen\ws\web.config \wfgen\WfApps\WebForms\web.config DRIVE:\Program Files\Advantys\WorkflowGen\Services\bin\WfgWorkflowEngineServer.exe.config

DRIVE:\Program Files\Advantys\WorkflowGen\Services\bin\WfgDirectoriesSyncService.exe.config

To do this, change <configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0"> to <configuration>.

Update the GraphQL and webhooks configuration files

In the \wfgen\graphql\web.config and \wfgen\hooks\web.config files, add the following to <system.webServer>:

<httpErrors existingResponse="PassThrough" errorMode="Detailed"></httpErrors>

Update the Directory Synchronization configuration file

There is a new configuration parameter required when upgrading from version 5.1.5 and earlier. This parameter allows you to provide a unique service name to the WorkflowGen Directory Synchronization service should you have multiple instances of WorkflowGen installed on a single server.

Add the following parameter to DRIVE:\Program Files\Advantys\WorkflowGen\Services\bin\WfgDirectoriesSyncService.exe.config:

<add key="ServiceName" value="WorkflowGenDirSyncService" />

Update the WorkflowGen Engine Service configuration file

There is a new configuration parameter required when upgrading from version 5.1.5 or earlier. This parameter allows you to provide a unique service name to the WorkflowGen Engine service should you have multiple instances of WorkflowGen installed on a single server.

Add the following parameter to DRIVE:\Program Files\Advantys\WorkflowGen\Services\bin\WfgWorkflowEngineService.exe.config:

<add key="ServiceName" value="WorkflowGenEngineService" />

Move the XMLTODATABASE transactions file

If you are upgrading from version 5.7.4 or earlier, copy the Transactions.xml file from \wfgen\WfApps\WebServices\XmlToDatabase\App_Data to \wfgen\App_Data\Files\XmlToDatabase.

Upgrade the WorkflowGen database

Run the SQL scripts listed below in order, starting with your current version of WorkflowGen. For example, if you are upgrading from version 5.5.0, run the scripts starting with For version 5.5.0 and earlier until For versions 7.15.1, 7.15.0 and earlier, inclusively.

Note: Oracle database is no longer supported as of WorkflowGen 7.16.0.

MS SQL Server

For version 5.1.9 and earlier

Launch the Update\Databases\MsSQLServer\Update_WFG-V5-2-0.sql database update script in your SQL Server Management Studio tool.

For version 5.2.x and earlier

Launch the Update\Databases\MsSQLServer\Update_WFG-V5-3-0.sql database update script in your SQL Server Management Studio tool.

For versions 5.3.x, 5.4.0 (alpha, beta 1 and beta 2) and earlier

Launch the Update\Databases\MsSQLServer\Update_WFG-V5-4-0.sql database update script in your SQL Server Management Studio tool.

For version 5.4.x official and earlier

Launch the Update\Databases\MsSQLServer\Update_WFG-V5-5-0.sql database update script in your SQL Server Management Studio tool.

For version 5.5.0 and earlier

Launch the Update\Databases\MsSQLServer\Update_WFG-V5-5-1.sqldatabase update script in your SQL Server Management Studio tool.

For version 5.5.1 and earlier

Launch the Update\Databases\MsSQLServer\Update_WFG-V5-5-2.sql database update script in your SQL Server Management Studio tool.

For version 5.5.4 and earlier

Launch the Update\Databases\MsSQLServer\Update_WFG-V5-5-5.sql database update script in your SQL Server Management Studio tool.

For version 5.5.5 and earlier

Launch the Update\Databases\MsSQLServer\Update_WFG-V5-6-0.sql database update script in your SQL Server Management Studio tool.

For version 5.6.1 and earlier

Launch the Update\Databases\MsSQLServer\Update_WFG-V5-6-2.sql database update script in your SQL Server Management Studio tool.

For version 5.6.2 and earlier

Launch the Update\Databases\MsSQLServer\Update_WFG-V5-6-3.sql database update script in your SQL Server Management Studio tool.

For version 5.6.3 and earlier

Launch the Update\Databases\MsSQLServer\Update_WFG-V5-6-4.sql database update script in your SQL Server Management Studio tool.

For version 5.7.0 and earlier

Launch the Update\Databases\MsSQLServer\Update_WFG-V5-7-1.sql database update script in your SQL Server Management Studio tool.

For version 5.7.1 and earlier

Launch the Update\Databases\MsSQLServer\Update_WFG-V5-7-2.sql database update script in your SQL Server Management Studio tool.

For versions 5.7.2, 5.7.3, or 5.7.4 and earlier

Launch the Update\Databases\MsSQLServer\Update_WFG-V6-0-0.sql database update script in your SQL Server Management Studio tool.

For version 6.0.0 and earlier

Launch the Update\Databases\MsSQLServer\Update_WFG-V6-1-0.sql database update script in your SQL Server Management Studio tool.

For version 6.1.2 and earlier

Launch the Update\Databases\MsSQLServer\Update_WFG-V6-1-3.sql database update script in your SQL Server Management Studio tool.

For version 6.1.3 and earlier

Launch the Update\Databases\MsSQLServer\Update_WFG-V6-1-4.sql database update script in your SQL Server Management Studio tool.

For version 6.1.6 and earlier

Launch the Update\Databases\MsSQLServer\Update_WFG-V6-2-0.sql database update script in your SQL Server Management Studio tool.

For version 6.4.0 and earlier

Launch the Update\Databases\MsSQLServer\Update_WFG-V6-5-0.sql database update script in your SQL Server Management Studio tool.

For version 6.5.0 and earlier

Launch the Update\Databases\MsSQLServer\Update_WFG-V6-6-0.sql database update script in your SQL Server Management Studio tool.

For version 6.6.0 and earlier

Launch the Update\Databases\MsSQLServer\Update_WFG-V7-0-0.sql database update script in your SQL Server Management Studio tool.

For versions 6.6.0 and earlier

Launch the Update\Databases\MsSQLServer\Update_WFG-V7-0-0.sql database update script in your SQL Server Management Studio tool.

For version 7.1.0 and earlier

Launch the Update\Databases\MsSQLServer\Update_WFG-V7-1-1.sql database update script in your SQL Server Management Studio tool.

For version 7.1.1 and earlier

Launch the Update\Databases\MsSQLServer\Update_WFG-V7-2-0.sql database update script in your SQL Server Management Studio tool.

For version 7.2.1 and earlier

Launch the Update\Databases\MsSQLServer\Update_WFG-V7-3-0.sql database update script in your SQL Server Management Studio tool.

For version 7.5.1, 7.5.0, 7.4.1, 7.4.0, 7.3.1, or 7.3.0

Launch the Update\Databases\MsSQLServer\Update_WFG-V7-6-0.sql database update script in your SQL Server Management Studio tool.

For version 7.9.1, 7.9.0, 7.8.0, 7.7.0, or 7.6.0

Launch the Update\Databases\MsSQLServer\Update_WFG-V7-10-0.sql database update script in your SQL Server Management Studio tool.

For version 7.10.0 and earlier

Launch the Update\Databases\MsSQLServer\Update_WFG-V7-11-0.sql database update script in your SQL Server Management Studio tool.

For version 7.11.2 and earlier

Launch the Update\Databases\MsSQLServer\Update_WFG-V7-12-0.sql database update script in your SQL Server Management Studio tool.

For versions 7.12.2, 7.12.1, 7.12.0 and earlier

Launch the Update\Databases\MsSQLServer\Update_WFG-V7-13-0.sql database update script in your SQL Server Management Studio tool.

For version 7.13.1 and earlier

Launch the Update\Databases\MsSQLServer\Update_WFG-V7-14-0.sql database update script in your SQL Server Management Studio tool.

For versions 7.14.7, 7.14.6 and earlier

Launch the Update\Databases\MsSQLServer\Update_WFG-V7-15-0.sql database update script in your SQL Server Management Studio tool.

For versions 7.15.1, 7.15.0 and earlier

Launch the Update\Databases\MsSQLServer\Update_WFG-V7-15-2.sql database update script in your SQL Server Management Studio tool.

For versions 7.15.5 and earlier

Launch the Update\Databases\MsSQLServer\Update_WFG-V7-16-0.sql database update script in your SQL Server Management Studio tool.

For version 7.16.0

There is no database update script to run.

Configure IIS

Note: Domain users and the Windows accounts used to run the WorkflowGen IIS application pool and Engine service must have read and write permissions for the \wfgen\app_data folder.

Update or create the application pool in .NET 4

The WorkflowGen website and web applications must now use an application pool in .NET 4. If this has not already been configured, do the following:

  1. Install .NET Framework 4 on the server, if not already installed.

  2. Update the existing application pool or create a new application pool using .NET Framework 4 for:

    • The WorkflowGen website

    • \wfgen

    • \wfgen\wfapps\webforms (create this IIS web application if it isn’t already created)

    • \wfgen\ws

  3. If your application pool is set to use Classic Managed Pipeline Mode, make sure ASP.NET v4.0.30319 is set to "Allowed" in the IIS manager ISAPI and CGI Restrictions list.

Restart the WorkflowGen server

Reboot your WorkflowGen web server.

New location of workflow application temporary and log files

The following workflow applications store their files in these new locations:

  • EFORMASPX: \wfgen\App_Data\Files\EFormAspx

  • XMLTODATABASE: \wfgen\App_Data\LogFiles\XmlToDatabase

  • XMLTRANS: \wfgen\App_Data\Files\XmlTrans and \wfgen\App_Data\LogFiles\XmlTrans