CRM dashboard errors 'Execute permission was denied on the object 'RecIDList'

Problem

Loading the CRM Dashboard errors with the following message

Solution

SQL skills are required

Access to SQL Management Studio and the ability to execute scripts are required.

In versions 7.02.01 or earlier upgrades or create new database or demo databases did not grant permissions to the SQL user defined type RecIDList. The work-around for 7.02.01 or earlier is to run this script against the database:

^{GRANT EXEC ON TYPE::RecIDList TO JiwaUser}

Page:

CRM Dashboard - 'Hierarchical Chart Error - There must be at least one row and one numeric column and data must all be positive values'
Page:

CRM dashboard errors 'Execute permission was denied on the object 'RecIDList'
Page:

CRM Dashboard My Customers sales for Sales This Month are incorrect - 7.01.00, 7.02.00 and 7.02.01
Page:

CRM Dashboard "My Customer Invoices Overdue" displays incorrect data
Page:

Generic Dashboard is slow to load and eventually reports a timeout error message

Problem

Solution

SQL skills are required

Related articles