_UD tables split off in BAQ

Kinetic ERP
1

In Kinetic, I have had quite a few baqs break and do this:

image
image809×422 8.09 KB

The only way to fix it is to delete the query and start over. Any idea what causes it to randomly do this?

The original had only Erp.PartLot. It decided to add the separate table like this and not link it. (If I do link it and save, it simply deletes the link) This causes what should have a single result return to return thousands (one line for every line in PartLot_UD)

I had two separate queries do it on me currently on a single project so now I’m back to starting the project over and I would prefer to not have to start over again, so if I’m doing something that causes this, it would be nice to know.

2

I’m also waiting for the answer.

3

It happens when PartLot_UD is not found in the zdata as UD table. but it is not clear to me, how it can happen.

DO you have access to DB, what do these queries return

select TableID, Seq, TableType, DBTableName, IsVisibleInDesigner from Ice.QueryTable where QueryID='your query id'
select RelationID, IsFK, ParentTableID, ChildTableID, JoinType from Ice.QueryRelation where QueryID='your query id'
select  RelationID, Seq, ParentFieldName, ChildFieldName from Ice.QueryRelationField where QueryID='your query id'
4

I have had this happen to queries uplifted from previous versions. They will also work just fine until you edit it the first time, then it blows up. Is this an older query?

5

I do have access to the DB, but I deleted and rebuilt those queries already so if I run that for those specific queries, don’t think it will show you what you are looking for. If you still want me to do it, I will.

6

No, I just created them on Kinetic. They are not on our old version.

I did have 1 or 2 do that during our upgrade, but these are new queries.

7

no, i need broken one

8

You know, at first I thought this

image

was a fire symbol, like this:

image

which would have been amazing if that’s what the BAQ did.

9

That’s what I saw !

1 Like
10

I found a different one that it did it on.
Did it on both the subquery and the top query:
image
image

image
image928×251 9.45 KB

image
image938×143 6.38 KB

image
image1057×176 6.43 KB

11

looks like all info is lost except table itself :frowning:
Do you really have EmpBasic_UD defined and green in the UD field maintenance?
Does EmpBasic(1) show the UD fields in the field list in BAQ designer? as part of the main table?

12

Yes and yes.

image
image980×272 10.3 KB

image

13

Sorry, in case you meant here as well, yes it shows:

image
image984×227 9.82 KB

14

It looks like that if you just delete those 2 tables it should work normally after that.

15

I deleted them and saved.
Currently they are gone. I tried to run the query and it errored.
It apparently changed the reference within my calculated field:
image

Once I fixed that part, it worked.

This is also a query that was created in Kinetic and not carried over from 10.
It’s great that it can be fixed, but it would be even better if we knew what caused it so I can avoid doing whatever causes it because I may not notice that my query broke until after it has caused problems.
These queries were fine when I wrote them but broke afterwards. I only found it because the project I had done wasn’t working correctly after I had handed it off to the next person to test. Worked fine on my original testing. Error sprung up later when he was testing.

16

yes, it is a magic that have to be done to hide UD fields in BAQ and make them look like part of the main table.

If you run the same queires that you did above, you will see the difference in table and relation definition.

Question is when they broke. On save or on load by that other person and then save with wrong values…

17

To provide another data point:
I had never had any issues creating BAQs in Kinetic until I created one using the Classic screen (to create a UBAQ) and this same thing happened.
Could it be that it only happens on the Classic screen? or Only with UBAQ?

What solved it for me was also to just re-create the UBAQ from zero, each time.

18

Do you have definitive steps to repeat this error?

19

It is as @jgiese.wci said:

I just tried again to confirm it’s exactly that.

20

I only use the Classic screen to create BAQs so that may be related. This is not a UBAQ so that’s not it. It doesn’t happen every time (not even that often as I have hundreds of BAQs and this has happened less than 10 times).
I don’t have any specific steps to recreate the problem. If I did, that would help me prevent it happening again.