Share
Report
139Hello,
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.
Problem
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
- I ensured I removed any remnant of the old field that a replaced with the new lookup field. If it matters, I did name it the same. Note - I have another look up field that I essentially remade during troubleshooting and I named that something different but it is having a similar issue.
- Used a few XRMtoolbox plugins to see if I could find any reference of the attribute. Nothing showed up having to do with the old fields.
- I tried updating data using the "edit data in excel" function but that yielded the same result as the flow.
- I tried removing the fields from the forms and import/exporting into prod. I noticed that after doing this, one of the option set fields would throw the error shown above so if I left it blank, I could create items. This was also intermittent.
- After noticing this, I tried removing the problematic option set from the solution and reimporting to prod. This seemed to be the most consistent way of creating/editing records in Prod.
- I tried creating the relationships manually instead of letting CDS do it when you create a field.
- I've deleted all data in prod just in case previous data from the old fields messed things up.
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.
Update - After coming back to this with a fresh mind, I actually found out what was going on. It turns out the only difference between QA and Prod for me was a duplicate detection rule. I created that rule using the old fields and forgot about updating it. It's unfortunate that all of the errors seemed to indicate something was wrong with the entity or solution when it was actually something in the environment itself.
I still don't understand this error seemed to pop up only if I edited records. I would think creating records would trigger the dup detection rule.
All responses (
Answers (
