topic Issue After Upgrade to 7.4 – Error When Using "Find References" (@retired variable already declared) in Product Forum

Issue After Upgrade to 7.4 – Error When Using "Find References" (@retired variable already declared)

kantasit — Thu, 27 Mar 2025 09:37:45 GMT

The variable name '@retired' has already been declared.
Variable names must be unique within a query batch or stored procedure.

This happens when right-clicking an action on an object and selecting “Find References.”
It does not seem related to any logic in our own automations.

What We’ve Investigated:

The stack trace shows the error comes from:

BluePrism.AutomateAppCore.IServer.GetReferences
→ Which suggests this is an internal Blue Prism SQL query, not something we’ve created.
We ran the following query on our Blue Prism database to check for duplicates:
sql

SELECT OBJECT_NAME(object_id), definition FROM sys.sql_modules WHERE definition LIKE '%@retired%'
→ Result: 0 rows — no procedures, views, or functions use @retired.

This confirms the error likely originates from Blue Prism’s internal metadata handling during the reference scan.

Currently, we are avoiding the use of “Find References” to prevent client crashes until a solution is found.

Questions

Is this a known issue in BP 7.4.0?
Has it been resolved in any subsequent 7.4.x patch?
Is there any way to resolve or patch this internally?

We’d appreciate any guidance or confirmation.
Happy to provide logs or more technical details if needed.

Thanks in advance!

Best Regards,
Kantasit

Re: Issue After Upgrade to 7.4 – Error When Using "Find References" (@retired variable alr

steven.boggs — Thu, 27 Mar 2025 13:33:42 GMT

Hi Kantasit,

I've checked on this internally and can confirm our Product team are aware of this issue and are currently investigating it, with a fix request logged against v7.4 of BPE. Currently there are no timelines for when this fix is slated to be included in an upcoming release but we'd recommend keeping an eye out for future release notes updates on it.

Re: Issue After Upgrade to 7.4 – Error When Using "Find References" (@retired variable alr

nicolailykke — Thu, 22 May 2025 08:35:01 GMT

Hi we are also having this issue.

I was a bit surprised to find that it is not currently listed as an issue when upgrading to 7.4 from an earlier version.

Re: Issue After Upgrade to 7.4 – Error When Using "Find References" (@retired variable alr

Steve-Pete — Tue, 27 May 2025 18:03:31 GMT

It's pretty frustrating that this hasn't been fixed yet. I took over a project from another developer and it's exhausting to search for all references to an object without a working "Find References" feature.