Troubleshooting the "Report ID" Does Not Exist Error in Spira

Symptoms

When you try and run a standard (or custom) report in Spira, you get the following error dialog:

However when you check, the report ID does exist and is active. If you try different filters on the same report, you sometimes get the error, and sometimes not.

Cause

The error message is actually caused by having a User custom property defined that previously was defined as a different type of custom property (List, Text, etc.):

The system is trying to find a User with an ID that does not exist, and that error is incorrectly being understood that the report itself does not exist.

Solution

To confirm that this is indeed the issue, run the following SQL command to see if any custom property values do not exist as an actual user:

SELECT * FROM TST_ARTIFACT_CUSTOM_PROPERTY
WHERE PROJECT_ID = X
AND ARTIFACT_TYPE_ID = X
AND CAST(CUST_01 AS INTEGER) NOT IN (SELECT USER_ID FROM TST_USER)

where CUST_01 would be the correct Custom Property Field #, and the X is replaced for the Project ID and Artifact Type ID.

If you find any matches, the following SQL will fix the issue:

UPDATE TST_ARTIFACT_CUSTOM_PROPERTY
SET CUST_01 = NULL
WHERE PROJECT_ID = X
AND ARTIFACT_TYPE_ID = X
AND CAST(CUST_01 AS INTEGER) NOT IN (SELECT USER_ID FROM TST_USER)

Other Information

[This issue has been fixed in the v6.0 release of Spira]