CIS 5 - specifically release 5.03

tcyprys

Hi All

Not sure if anyone else has implemented the latest release for CIS 5, 5.03.00.

We are having problems linking this to XRL… this was an upgrade from 5.02.00 and XRL linked fine for the customer in that release.

When setting up, even as the standard Guest, and linking the user to CIS Manager user (System Admin), it fails when selecting tables in XRL spreadsheet with the message 'Invalid Companies'. You get this in the old release when trying to use anything other than Manager user when setting up a Profile in XRL Setup… but this is using that Manager user in the profile.

I have installed offsite and cannot recreate, so not sure what is happening - two of use have looked at it, so I am not seeing it as a setup mistake, but not ruling it out either!!

Cheers

Tony

tcyprys

Just in case anyone else gets this issue, this is what was done to resolve it on my system and also the client - obviously take backups and test where possible.

1. In SQL, edit PegasusCIS_Configuration>Groups table.
2. Find the System Administration group and alter the GroupID from -1 to say 1009
3. Go to Pegasus CIS Admin tool, select Groups and the System Admin Group
4. Note that the Manager user will now be unticked.
5. Tick the Manager user and Save.
6. Go back to edit PegasusCIS_Configuration>Groups table and change the GroupID back to -1

NOTE: If you don't do the last part in point 6, you will get a script error when accessing CIS via XRL. The script shows it is hard coded to look for the GroupID = -1

Hope that helps!