When I try to save a role, I get the following error.
Cannot insert the value NULL into column 'ACTION_ID', table 'SplendidCRM-Cvt41.dbo.ACL_ROLES_ACTIONS'; column does not allow nulls. INSERT fails. The statement has been terminated.
1) SQL profiler displays everything correctly.
Just wondering if anybody has seen this and knows of a fix.
It sounds like there is a missing record in the ACL_ACTIONS table. When a module is created using the stored procedures, records are added to the ACL_ACTIONS table to define the types of actions that can be assigned. Is it possible that you are missing the ACL_ACTIONS records for the specific module that you are trying to define a role for?
Thanks,
That fixed the problem. We improperly added a new module, those records were missing from the ACL_Actions table.
You need to run the spACL_ACTIONS_Initialize stored procedure. You can do this directly using some SQL tool or you can just run the SplendidCRM Configuration Wizard. If you use the wizard, just remember that it will overwrite any stored procedures or views that you have customized. If you have not customized any, then the Wizard is your best bet.
