Not unique table/alias:

nlarson

I am receiving the following error when a query loads.

Internal error. Error reading business object. Not unique table/alias: 'Wall_OwnerReference'

I have fixed the issues previously, by rebuilding the query from scratch, but the issues is now back. I think it has to do with grouping for a few reasons:

I have not added or removed any attributes in a few publishes
If I log in as a different users the query works fine, even with the same data
there is a colum added to my grid called BAS_REF_VALUE, and several other are missing
A restore to default seems to have corrected the issue

I belive there are other ways to triger this, but by playing around a bit I was able to get Steps to Repro at will in my BSV.

Create a Query for a BO Group
Group it by a shortcut
Login to Ops mode
Run the Query
From the gird options turn off grouping
Then Turn groups back on
The error should be thrown and will stick until Restore to defaults is hit and the pannel is reloaded.

nlarson

Not sure if this helps, but I found a little more info. It seems like certain grid changes are being saved even if the user does not 'click save'. This creates a user varient of the grid.

If changes are then made to the query and the User settings do not match the new changes this error is thrown.

I believe that there needs to be a 'reset to defaults' option in the config tool, so that if we as devs make a change we can force the user defined variant to be deleted.

Does that make sense?

Powerm

Just happened to me. I've duplicated a Query using copy/paste. It disappeared after building the Query from scratch...