I will try to keep this as concise as possible as I have been wracking my brain the entire day trying to figure this out.
I have 3 environments, Dev, QA and Prod. I have a solution which contains a collection of entities, a couple of flows and some option sets. I have exported and imported this solution from Dev to QA and Prod a couple of times with no issues. However, today I decided to change a field in Entity A to look up on from Entity B in the same solution instead of the System Users Entity. After doing this, I tested to make sure I could create/edit records in Dev and it worked. Exported/imported into QA and everything worked. Importing into Prod is where the trouble happened. I received this error intermittently:
A flow I had connected to this entity also had an error stating this:
The flow error remained constant however the Query Builder error seemed to be intermittent for multiple users. It was really odd that I could create an entry sometimes and other times I could not. Eventually, the error became more and more common until it was consistent.
What I've tried
The most bizarre thing to me is everything works perfectly UNTIL I use my prod environment. I also can't understand how it would create records sometimes then the very next record, using the same data, throw an error. I am out of ideas as to how that environment has issues when everything I use is within the same solution.
Apologies for the wall of text here. My head is swimming and I felt like all of that detail may help someone smarter than myself help me. Please let me know if I can provide any further details that may assist.
Solved! Go to Solution.