Error when trying to access the inbox - Cannot find data type BAIntegerListType

Summary

After migrating your project to 11.2.4.20x, the database might have an inconsistency that prevents users from accessing their inbox.

Applies to

Bizagi Studio from 11.2.x or superior.

Symptoms

When opening the Bizagi Work portal using Google chrome, the following error message appears:

Cause

There is a missing type in the database that needs to be built or created.

Solution

To fix the inconsistency in your database, run the following script:

IF NOT EXISTS (SELECT 1 FROM sys.types WHERE is_table_type = 1 AND name ='BAIntegerListType')
BEGIN
    CREATE TYPE BAIntegerListType AS TABLE
    (
        idValue INT NOT NULL,
        PRIMARY KEY CLUSTERED
        (
            idValue ASC
        )
        WITH (IGNORE_DUP_KEY = OFF)
    );
END;

Bizagi Knowledge Base