Error: "This report may be based upon data that is not present in your database. Please ensure you have any associated data already loaded prior to running the report"
Article ID: 243539
Updated On:
Products
Issue/Introduction
You may receive the following error when running a report as a non-administrator:
This report may be based upon data that is not present in your database. Please ensure you have any associated data already loaded prior to running the report
In addition to the message above, the actual report does not returning any data. When inspecting the SMP logs the following error is seen:
Failure running Report 'Cloned for 6 Months of Data Windows Compliance by Computer' (9b101978-e28f-4290-9a29-83a71690390b). Please check the configuration of the query.
An unexpected SQL error occurred when running the RawSqlDataSource: 'Cloned for 6 Months of Data Windows Compliance by Computer' (2031901b-0cb1-41aa-8d92-90d5b93b7c96)
Violation of PRIMARY KEY constraint 'PK__#A4DB545__E94AFBA6AEF492EF'. Cannot insert duplicate key in object 'dbo.@tmpScopeCollection'. The duplicate key value is (######-36ec-df57-dc7e-26f291e5b6b6).
The statement has been terminated.
SQL Exception details: code=2627, line=76, procedure=spPMWindows_ComplianceByCVE
Environment
ITMS 8.6
Cause
Report scoping is set to Computers
Resolution
Noticed when running the report that it is scoped to Computers. The end-user most likely does not have access to the Computers Asset. The Computers Asset is All Computers. You will need to click on Computers to change it to the Organizational Unit that you have access to as shown here:
Feedback
