Error message seen when adding or removing the Agents from a SG. Error attached to the defect.
This is because there is a new link between the route and skillgroup which is now imported, used by the system to add functionality and enforced by security i.e. the user must have rights to browse routes that are linked to skill groups. This essentially means that they should be stored in the same folder as the skillgroup to ensure security is ok.
Error messages in the logs:
2014-06-05 04:56:55,692 DEBUG 4224 Application.DataCommand Exception: LoadEntitiesCommand Exception: Exony.Security.ExonySecurityException
Message: Request for operation permission failed - Demand: Operation: SEC_LIST_DIMENSIONS, Path: /tenant1
at Exony.Security.ExonyOperationPermission.Demand() in t:\Dev\Source\Reporting\D9_2_1\App\Exony\Security\ExonyOperationPermission.cs:line 132
at Exony.Reporting.Application.Provisioning.LoadEntitiesCommand.ExecuteCommand() in t:\Dev\Source\Reporting\D9_2_1\App\Exony.Reporting.Application.Provisioning\LoadEntitiesCommand.cs:line 41
at Exony.Reporting.Application.DataCommand.ExecuteMethodWithRetries(DatabaseMethod method, Boolean allowTransaction, Exception& exception) in t:\Dev\Source\Reporting\D9_2_1\App\Exony.Reporting.Application\DataCommand.cs:line 860
We can run the following script on both DB servers to move the routes to the skillgroup folder
set r.FOLDER_ID = s.FOLDER_ID
from VW_DIM_ROUTE_SKILLGROUP_MEMBER as rsm
inner join TB_DIM_SKILLGROUP as s
on rsm.PARENT_ITEM_BIZ_URN = s.ITEM_BIZ_URN
inner join TB_DIM_ROUTE as r
on rsm.CHILD_ITEM_BIZ_URN = r.ITEM_BIZ_URN
restart the app server