Spectrum user is unable to generate group based reports from Spectrum Report Manager and receives the error message "No Entity Groups Created".

Document ID : KB000046410
Last Modified Date : 14/02/2018
Show Technical Document Details

Issue:

We have a user who is not able to generate (group based) reports within InfoView.

When trying to select a group / global collection, he'll get the error message:

"No entity groups created"

We have checked if the privilege "Report Manager -> View Reports" is set in the SRM OneClick Server and it is.

Also the user has assigned security communities within OneClick, however when displayed from the reporting database via MYSQL the Security Communities show unknown.

 

mysql> select * from v_security_string_accessibility_by_landscape where user_name like 'SpecAdmin';

+-----------+-------------+-----------------+

| user_name | landscape_h | security_string |

+-----------+-------------+-----------------+

| SpecAdmin | 527433748 | *UNKNOWN* |

| SpecAdmin | 530579426 | *UNKNOWN* |

| SpecAdmin | 531628042 | *UNKNOWN* |

+-----------+-------------+-----------------+

3 rows in set (0.00 sec)

 

Environment:

Spectrum 9.4.x

CABI 3.3

Spectrum Report Manager (SRM)

 

Cause:

The issue is caused by having a user created in OneClick as different case sensitivity (SpecAdmin and specadmin).  When the original user (SpecAdmin) is removed from OneClick, it is not removed from the oc_user table in the MYSQL Reporting database because OneClick is case sensitive but CABI is not, thus CABI treats SpecAdmin and specadmin as the same user and when SpecAdmin is removed from OneClick users list, it is not removed from the Reporting database oc_user table.

OneClick security sees that SpecAdmin and specadmin are different users and thus the security strings are removed.

 

Resolution:

The solution is to ensure that there are no duplicate users in OneClick and to delete all instances of this user, such as SpecAdmin, specadmin, SPECADMIN, etc..

Once this has been done the users will be marked for deletion and within an hour they should no longer exist in the MYSQL oc_user table as seen by this command.

 

select * from oc_user where user_name like 'SpecAdmin';

 

You should no longer see this user, if the user does exist after 1 hour, you can remove the user by

 

delete from oc_user where user_name like 'SpecAdmin';

 

then you can verify that the user has been removed

select * from oc_user where user_name like 'SpecAdmin';

 

Once user has been removed, you can recreate the user in OneClick and all should work correctly.