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

Last Year
JuanG
Work Portal - Others

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;

Rate this Article:

Details

Last Modified:Last Year
Last Modified By: JorgeR
Type: ERROR
Level: Advanced
Article not rated yet.
Article has been viewed 419 times.

Options