After successfully running a query in Chemical Registration database, users might attempt to open a query hit in registration form to view its details. This may fail sometimes showing “An error occurred while retrieving instance at urn:searchbrowse:singleresult:”.

There are two known scenarios that could cause the error:

1. Query to retrieve and view a record that has been retired.

Expected behavior is: if the user has permission to see retired records, they will be taken to the retired record; if not, they will be taken to a page that says that they are not allowed to see the requested record.

Users, with Hub Admin privileges, are advised to check in Foundation Hub if the user’s group is missing the View Retired permission. If so, assign this permission to the user’s group, save the setting, and check again after restarting the Hub and PP services.

2. Two or more attributes having the same display name in the GEMS database, e.g., a custom attribute called "Weight" having its display name "Molecular Weight" when there is already an out of the box attribute "Molecular Weight" in the database.

This needs to be corrected to resolve the error.