# WorkflowGen 7.15.2

**URL:** https://discuss.workflowgen.com/t/workflowgen-7-15-2/1394
**Category:** Release Notes & Downloads
**Created:** [May 28, 2019, 7:48pm UTC](https://discuss.workflowgen.com/t/workflowgen-7-15-2/1394 "2019-05-28T19:48:07Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![wfg-admin](https://yyz2.discourse-cdn.com/flex030/user_avatar/discuss.workflowgen.com/wfg-admin/32/714_2.png) [@wfg-admin](https://discuss.workflowgen.com/u/wfg-admin)
#### Post date: [May 28, 2019, 7:48pm UTC](https://discuss.workflowgen.com/t/workflowgen-7-15-2/1394/1 "2019-05-28T19:48:08Z")

</div>

### Portal

- Bug (#2424): Fixed an issue where a supervisor had the rights to cancel a specific process request even when the supervisor process participant `Cancel requests` permission was disabled.

- Bug (#2605): Fixed an issue where a cancelled action would store the delegatee as the aborted user instead of the actual user (delegator) in delegation mode.

- Bug (#2612): Fixed an issue where users could not access requests containing one or more actions that they cancelled previously.

### Notifications

- Enhancement (#2433): Request data numeric values are now always formatted in text using a language culture in email notifications.

- Enhancement, Change (#2646): Macro datetime values are now displayed in the user’s timezone instead of UTC in email notifications.

### Web services API

- Enhancement (#2433): Request data numeric values are now always formatted in text using a language culture in the web method XML response.

### GraphQL

- Enhancement (#2616): Apply consistent requests and actions user access security check in all queries and mutations.

- Bug (#2608): Fixed an issue where a delegatee could cancel another request of their delegator where the specific request was not intentionally delegated to them in delegation mode.

- Bug (#2610): Fixed an issue where a delegatee could not access a request of their delegator in delegation mode.

- Bug (#2624): Fixed an issue where a standard user was able to create a new request in test mode.

### Webhooks

- Enhancement (#2611): Added support for the new `args.onBehalfOfUserName` parameter for operations in delegation mode.

- Enhancement (#2616): Apply consistent requests and actions user access security check in all queries and mutations.

- Bug (#2608): Fixed an issue where a delegatee could cancel another request of their delegator where the specific request was not intentionally delegated to them in delegation mode.

- Bug (#2610): Fixed an issue where a delegatee could not access a request of their delegator in delegation mode.

- Bug (#2624): Fixed an issue where a standard user was able to create a new request in test mode.

### Database

- Performance (#1922): Added some new indexes on datetime columns for request and action tables.

- Enhancement (#2541, #2618): Improved some table columns’ schemas for not null values.

### Upgrade scripts

- Change (#2598): All `alter table column` queries now use `SQL_Latin1_General_CP1_CI_AS` collation for SQL Server in our database upgrade scripts.

### Notes

- All of the Node.js modules (`GraphQL v2.0.1`, `Webhooks v4.0.1`, `Auth v1.0.0`, and `SCIM v1.0.0`) now require Node.js **version `10.15.3 LTS`**.

### Reminders

- **Microsoft Windows Server 2008 is no longer supported as of WorkflowGen version 7.11.0.** We recommend migrating to Windows Server 2012 or later.

- **Microsoft SQL Server 2008 is no longer supported as of WorkflowGen version 7.10.0.** While SQL Server 2008 is still compatible with WorkflowGen, support for any performance issues or bugs resulting from using SQL Server 2008 will no longer be provided.

### Installation Packs

[WorkflowGen 7.15.2 (Upgrade)](https://github.com/advantys/workflowgen-releases/releases/download/7.15.2/update.zip)  
[WorkflowGen 7.15.2 (Clean Install - PowerShell)](https://github.com/advantys/workflowgen-releases/releases/download/7.15.2/powershell-setup-7.15.2.zip)  
[WorkflowGen 7.15.2 (Clean Install - manual)](https://github.com/advantys/workflowgen-releases/releases/download/7.15.2/manual.zip)  
[WorkflowGen.My](https://download.workflowgen.com/library/wfg-my/4-4-0/wfg-my.zip)

### Documentation

[WorkflowGen 7.15.2 Upgrade Guide](https://advantys.gitbooks.io/workflowgen-upgrade-guide/content/)  
[WorkflowGen 7.15.2 Technical Guide](https://advantys.gitbooks.io/workflowgen-technical-reference-guide/content/)  
[WorkflowGen 7.15.2 Administration Guide](https://advantys.gitbooks.io/workflowgen-administration-module-reference-guide/content/)  
[WorkflowGen 7.15.2 User Portal Guide](https://advantys.gitbooks.io/workflowgen-user-portal-reference-guide/content/)  
[WorkflowGen 7.15.2 Integration Guide](https://advantys.gitbooks.io/workflowgen-integration-guide/content/)

---

<div class="post-metadata">

### Author: ![jianan.hsu](https://yyz2.discourse-cdn.com/flex030/user_avatar/discuss.workflowgen.com/jianan.hsu/32/411_2.png) [@jianan.hsu](https://discuss.workflowgen.com/u/jianan.hsu)
#### Post date: [May 28, 2019, 8:16pm UTC](https://discuss.workflowgen.com/t/workflowgen-7-15-2/1394/2 "2019-05-28T20:16:56Z")

</div>



---

<div class="post-metadata">

### Author: ![dcarruth](https://avatars.discourse-cdn.com/v4/letter/d/8c91f0/32.png) [@dcarruth](https://discuss.workflowgen.com/u/dcarruth)
#### Post date: [June 3, 2019, 11:58pm UTC](https://discuss.workflowgen.com/t/workflowgen-7-15-2/1394/3 "2019-06-03T23:58:53Z")

</div>

We have just upgraded to 7.15.2 but we now get the following error when trying to export a process:  
Cannot resolve the collation conflict between “Latin1\_General\_CI\_AS” and “SQL\_Latin1\_General\_CP1\_CI\_AS” in the UNION operation.

---

<div class="post-metadata">

### Author: ![qpomarel](https://yyz2.discourse-cdn.com/flex030/user_avatar/discuss.workflowgen.com/qpomarel/32/262_2.png) [@qpomarel](https://discuss.workflowgen.com/u/qpomarel)
#### Post date: [June 4, 2019, 12:39am UTC](https://discuss.workflowgen.com/t/workflowgen-7-15-2/1394/4 "2019-06-04T00:39:47Z")

</div>

Hello David,

You need to set your database collation as `SQL_Latin1_General_CP1_CI_AS`, you can follow the following procedure:

> [@I receive the following SQL error when accessing WorkflowGen: A SQL error has occurred .Net SqlClient Data Provider: Invalid column name ‘RES’](https://discuss.workflowgen.com/t/i-receive-the-following-sql-error-when-accessing-workflowgen-a-sql-error-has-occurred-net-sqlclient-data-provider-invalid-column-name-res/497):
>
> Solution If you receive an SQL error indicating .NET SqlClient Data Provider: Invalid column name RES, it’s likely because your SQL Server database collation is set to Latin1\_General\_BIN, which is not compatible for use with WorkflowGen. We suggest changing your WorkflowGen database collation to the default SQL\_Latin1\_General\_CP1\_CI\_AS, since the database installation script uses this collation. To do this: Back up your WorkflowGen database. Stop all WorkflowGen services and the IIS web …

---

<div class="post-metadata">

### Author: ![dcarruth](https://avatars.discourse-cdn.com/v4/letter/d/8c91f0/32.png) [@dcarruth](https://discuss.workflowgen.com/u/dcarruth)
#### Post date: [June 4, 2019, 1:39am UTC](https://discuss.workflowgen.com/t/workflowgen-7-15-2/1394/5 "2019-06-04T01:39:13Z")

</div>

We just followed this procedure to change the collation but we still get the same error when trying to export a process.

---

<div class="post-metadata">

### Author: ![qpomarel](https://yyz2.discourse-cdn.com/flex030/user_avatar/discuss.workflowgen.com/qpomarel/32/262_2.png) [@qpomarel](https://discuss.workflowgen.com/u/qpomarel)
#### Post date: [June 4, 2019, 2:55pm UTC](https://discuss.workflowgen.com/t/workflowgen-7-15-2/1394/6 "2019-06-04T14:55:06Z")

</div>

You need to identify columns which provide the error and change the collation for these columns.

You can execute the following request to identify columns:

```sql
DECLARE @DatabaseCollation VARCHAR(100) = 'SQL_Latin1_General_CP1_CI_AS'

SELECT 
    t.Name 'Table Name',
    c.name 'Col Name',
    c.collation_name
FROM 
    sys.columns c 
INNER JOIN 
    sys.tables t ON c.object_id = t.object_id
INNER JOIN 
    sys.types ty ON c.system_type_id = ty.system_type_id    
WHERE 
    t.is_ms_shipped = 0
    AND 
    c.collation_name <> @DatabaseCollation

```
