Flow Designer - Erro - Invalid pharmacy compound uuid: 4e536ea7-84ba-4819-bedb-344306fef337

[Bruno Moreira]

  has anyone experienced this error when activating a Flow in the Flow designer?

I can change and save my flow. I can test the flow, but I can't activate my flow.

I'm on the Washington DC version patch4-hotfix1

[Bruno Moreira · Accepted solution]

I removed the "Get catalog variables" component and inserted it again and the problem was solved

[Kelly Logan]

It really seems like sometimes a reference of some type gets corrupted, but it's not clear what it is. It would be very helpful if we could translate these into a specific object or connection to look at and diagnose. So far the only solutions seems to be 'delete everything until it starts working'. 

[danielanork]

I also had this error and think i found a good way to troubleshoot and resolve it.

"Invalid pharmacy compound UUID:" refers to the table sys_hub_pill_compound, where the field "UI Unique ID" is the sys_id being referenced in the error.

Steps to Troubleshoot:

1. Navigate to: sys_hub_pill_compound.list
2. Filter by:
   UI Unique ID = [enter the sys_id from the error message
3. This will return a list of pill compounds.
   In the "Pill Prescription" column, you'll see the sys_id and the name of the data pill.
   Go through your flow and remove any references to this data pill.
4. Try activating your flow again.

This issue seems to happen when a copied flow tries to reference a data pill from the original flow. Since the reference is no longer valid in the new context, it throws the error. 

[Tristan Elmore]

Bless you for this contribution. I've been aware of this issue that pops up with corrupt data pills in Flow designer for a while. The idea of having to search out / find the one that's broken and/or clear every single one of them makes me want to pull out my hair.

This method was the fastest way I've seen to find the exact data pill(s) that I needed to remove.

[ViktoriaMikoova]

I have run into the same issue, removing and replacing the Get Catalog variables action didn't help. It's a shame I didn't noticed solutions from @danielanork Blessing3 and newmanan as they would have saved me a lot of time and I think they should be the accepted solutions. 

Anyway, how I found the exact step that had the corrupted data pill instead of going through every step was this: 

I opened the System Diagnostics -> Session Debug -> Debug Log and then run test on the flow again. 
In the logs I got the "Invalida pharmacy compound uuid" error again but before it you can actually see which step was the last that was created OK - in my case step 20 so then it was easy to go to step 21 and find the corrupted pill there. By replacing the corrupted data pill the issue was fixed.

[Viswa2]

I removed and disabled the "Error Handler" within sub flow, which resolved the issue. Added back "Error Handler", I was able to save and publish the sub flow successfully.