Sometimes when you try and run certain reports you may get an strange error message "The passed in report ID or report format ID does not exist". This message is unfortunately a red herring, and there is a different reason for this error.

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]

Attachments

Selected files will be attached to any email sent on saving ticket.

file selected files selected  () Delete Selected

  • Created:
  • by:

Select files to upload

Or drag and drop files here

Uploading …
Done!
Upload More?
There was an error.
Try again?

Save to upload the selected file(s)

Article Info
  • Last Updated: 10/30/2018
  • Article ID: KB399
  • Views: 94