A few things.
- Your last bullet point. You misinterpret the meaning of OnError. This is more of a “Something’s broken” in the query vs. there are no records to display.
- There are often issues querying models separately that relate to each other in any way. I suggest that you query both models in one action. It seems counter intuitive in many cases, but I have run into this being an issue on more than one occasion. I still don’t fully understand why it’s an issue to query separately.
- The last thing to do is set the CompetencyAssessment Advanced setting “Create default row if Model has none” to checked.