EA16.1 - DAO QueryDef error adding new elements

[PeteC]

This is a weird error:

I have an MDG that custom defines a lot. Included are stereotypes redefined from other stereotypes (several unrelated sets thereof).

I have an old model that now, in EA 16.1, when I try to add any type of element created from a redefined stereotype, I get a dialog with DAO.QueryDef [0x00000c03]   Syntax Error (missing operator) in query expression 't_object.Classifier = t_object_1.Object_ID INNER JOIN t_package ON t_package.Package_ID = t_object.Package_ID'. The only option is OK, and when I click that the element is added.

I get no issues adding the element in EA 16.0.

Adding any type of element that was not created from a re-defined stereotype does not create an error. So, it seems to be related to the use of redefinition of a stereotype to add customisation from a base stereotype. I've got three different sets of stereotypes that are redefined and they are not linked to each other. Elements from each all cause the error.

Trying to replicate the fault by creating a tiny MDG of a redefined element has not recreated the issue and I have also found that if I create a NEW model from my MDG (including starting first in EA15.2) and then add one of the re-defined stereotypes that it works without an error (I've also tried a different existing model that's not quite as old and it also works fine). My issue is that I don't know how many old models might be affected - if it's just the one then that's fine (it's my model that I use to test the MDG so can bin it and start again). So I'd like to understand what is causing the error.

I've disabled the one Add-in that I did have enabled and searched all my scripts for a portion of the SQL (and not found it).

Is this a new bug in 16.1? Is it something gone a bit wrong in my model but was hiding? Is it something inherent that is not quite right in my MDG?

I do have some model searches set to run in the background, but they don't include the SQL that is being presented. So, is that SQL built into EA (or is it something that I've forgotten I've entered somewhere!)?

[qwerty]

That SQL is definitely buggy. You should send a bug report.

q.