You do not have access to any report results folder
2 years ago
Originally Published: 2014-01-07
Article Number
000066937
Applies To
enVision Core

Alert is fired with the following event:

Message Text %NIC-3-802003: Webserver-InvalidScheduledReportTask-ErrorDetection, Webserver, enVisionSystem, InvalidScheduledReportTask, "TaskName", ErrorDetection
Alert ID envision_ip:xxxxxxxxxxxx

Issue
Manager Scheduled reports shows You do not have access to any report results folder
Stale Permissions in the nicdb or broken permissions in the nicdb
Resolution

Open a cmd prompt on the ES or ASRv:
1. change directory to %_Envision%\database\cmd.
2. run validatepermissions.
3. it will show something similar but for the device group table
=================== The following entries in permission table refer to a non-existent user or group ===================
Guid: has 1 references.
=================== The following entries in user_group table refer to a non-existent user ===================
=================== The following entries in user_group table refer to a non-existent group ===================
=================== The following entries in view_user_group table refer to a non-existent user ===================
=================== The following entries in view_user_group table refer to a non-existent group ===================
=================== The following entries in permission table refer to a non-existent device group ===================
=================== The following entries in permission table refer to a non-existent report folder ===================
=================== The following entries in permission table refer to a non-existent site ===================
=================== The following entries in permission table refer to a non-existent dashboard item ===================
=================== END OF PERMISSION VALIDATION ===================
Execution time: 0.062 seconds

if that is the case
run the following

E:\nic\4100\\database\cmd&gt;validatePermissions.cmd DELETE<BR>it will show something similar but for the device group table<BR><BR>=================== The following entries in permission table refer to a non-existent user or group ===================<BR>Guid: has 1 references.<BR>Guid: deleted from permission<BR>=================== The following entries in user_group table refer to a non-existent user ===================<BR>=================== The following entries in user_group table refer to a non-existent group ===================<BR>=================== The following entries in view_user_group table refer to a non-existent user ===================<BR>=================== The following entries in view_user_group table refer to a non-existent group ===================<BR>=================== The following entries in permission table refer to a non-existent device group ===================<BR>=================== The following entries in permission table refer to a non-existent report folder ===================<BR>=================== The following entries in permission table refer to a non-existent site ===================<BR>=================== The following entries in permission table refer to a non-existent dashboard item ===================<BR>=================== END OF PERMISSION VALIDATION ===================</FONT></P> <P><FONT face="Times New Roman"><FONT size=2>Stop and start the nic webserver service and verify correction.</FONT></P></FONT></body>