When installing FlexNet Manager Suite, you might encounter errors related to missing stored procedures after running the configuration command:
.\Config.ps1 "Config\FNMS Windows Authentication Config.xml"
Common error messages include:
Could not find stored procedure 'dbo.ComplianceOperatorCreateOperatorWithTenantPermission'
Could not find stored procedure 'dbo.GrantOperatorFullAcess'
This issue occurs when the FNMSCompliance database was not correctly initialized during the database creation step.
- Rerun the FNMSCompliance database creation script
-
- Re-execute the database creation script to ensure all required stored procedures are created
- Check for errors
-
- Review the script output
- Look for an error such as the one shown below:
- Disable CLR strict security (If needed)
If this error appears during script execution, you may need to disable CLR strict security in SQL Server before rerunning the script. To do this, execute the following SQL command using SQL Server Management Studio:
EXEC sp_configure 'clr strict security', 0;
RECONFIGURE;
GO
Related Articles
Error: "Could not find stored procedure 'EcmCreateUsageApplications'. [SQLSTATE 42000] (Error 2812). The step failed." 27Number of Views FlexNet Manager Suite log files and locations 188Number of Views ARL import fails with "Error = [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Could not find stored procedure 'sp_d… 6Number of Views ARL update on FlexNet Manager Suite versions 2020 R2 and earlier fails with error while executing stored procedure ARLSoft… 4Number of Views How to enable FlexNet Manager Suite diagnostic tracing 274Number of Views
Hi, I am Reva - Ask me anything.
No new updates
Thanks for the feedback!
Your feedback has been saved.Rate this response:
Add Additional feedback ( Optional )
Are you sure you want to cancel
the case creation?
Are you sure you want to cancel the case creation?
Are you sure you want to close this case
| Products | Region | Phone Numbers |
|---|---|---|
| FlexNet Operations FlexNet Embedded FlexNet Publisher FlexNet Connect FlexNet Code Insight InstallAnywhere InstallShield |
North America * |
+1 630-332-2513 (toll) +1 877-279-2853 (toll-free in North America) |
| Europe * |
+44 1925 944367 (toll) +44 800 047 8642 (toll-free in Europe) |
|
| Japan * | +81 3-4540-5335 (select option 2) | |
| Australia * |
+61 3 9895 2177 +61 1800 560 603 (toll-free in Australia) |
|
|
Usage Intelligence (formerly
Revulytics) Compliance Intelligence |
Please use the Case Portal to submit your support ticket or reach out to your Revenera contact. | |
Case id: 00001065
Activity: Status change: 2 hours ago