
leogeeko asked a question.
Hello everyone!
Everything run pretty smooth, the Config.ps1 started to execute, configured a lot of credentials until the following error ocurred:
Executing step Configure FNMP database for operators. C:\Flexera\FlexNet Manager Suite\Support\Config.ps1 : Exception calling "ExecuteNonQuery" with "0" argument(s): "Error 515, Level 16, State 2, Procedure ResetCognosRole, Line 27, Message: Cannot insert the value NULL into column 'GroupID', table 'FNMSCompliance.dbo.RoleRight_MT'; column does not allow nulls. INSERT fails." At line:1 char:1 + .\Config.ps1 ".\Config\FNMS Windows Authentication Config.xml" + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : NotSpecified: (:) [Config.ps1], MethodInvocationException + FullyQualifiedErrorId : SqlException,Config.ps1
Any Ideas?
Thanks!!!

Hi Leonardo,
Interpreting the error message from your PowerShell script:
In FNMS, for configuring the COGNOS Reporting (aka "Flexera Analytics"):
The default installation will create one FNMS role named "Business Reporting Portal Admin" that is configured as described above. This role may be assigned to a single user only.
In FNMS, can you go to 'Admin (cogs) > Accounts > Roles" and make sure your system is configured like this before re-running the PowerShell script, please?