IN Expression with BO Group problem

Rennur

Is anyone familiar with this error?

-Execution Exception after resuming a process message Internal error. Error reading business object. Unknown column 'BO_BOGroup_BOinGroup_Invoice.ID' in 'where clause

Cheers

Rennur

Just an observation as I'm no expert.
There are some indexes missing. They weren't created from the imported BSV. They exist in the Config Tool but are missing in the database.

Also, I've just created a ref attribute Invoice2 (per 1-many) in InvoiceLine BO and it has not been created in MySQL. Can't find the REM, RID & RMA fields and its not under indexes.

I cant explain why the columns are missing. Can anyone please share some insight into this.

Thanks

Rennur

The same error is now popping up in 2 separate BOs when saving it.

Pulling my hair out.

This object (called WaitingTime) is owned by a BO Group which contains 5 Objects.

The error is popping up in the Invoice object and now the Truck object when I try to save it.

Server log for the Truck object:
-Execution Exception after starting system process message Internal error. Error reading business object. Unknown column 'Docket_WaitingTime_DocketsId_Docket_Tip_Truck.ID' in 'where clause'

Docket_WaitingTime = BO
DocketsId = BO Group that owns the Docket_WaitingTime
Docket_Tip = 1 of the 5 BOs in the DocketsId Group
Truck.ID = ref attribute in the Docket_Tip BO to a Truck object

Also, the error pops up with or without any WaitingTime records in the database.

RocketRod

You're sure that the Where clause of your group query only has in it attributes that are common to all BOs within the group?

Cheers Rod

Rennur

What is the 'Where Clause'?
Internal error, can't the system find the relationship?

All the Docket BOs in the BO Group have exact same references to the WaitingTime,Truck and Invoice Object.

RocketRod

When defining a query you have the WHERE grid, that's what I meant. Any attributes you use here have to be common to all members of the group.

Cheers Rod

Rennur

The Truck BO has no relation to WaitingTime BO.

The WaitingTime BO has a cross reference rule to the Truck BO through the BO Group.

Eg. WaitingTime.DocketsId.Truck.Type

Rennur

Rebuilding the cross reference rules seems to have fixed the problem.

Rennur

Rebuilding the cross reference rules seems to have fixed the problem.

This is a bit of a show support issue for me, I'll probably buy a support ticket but I was hoping to get some clues as to what this error means or if anyone has had this in the past.

I only get the error when creating Docket_C.

I have a BO Group DocketsGroup with 3 Objects
Docket_A
Docket_B
Docket_C

2014-07-08 09:49:21,352 ERROR Reply#3910#BASTestDomainXX#73eb7d23a11d82f029903d4e7f7fc40b    -Execution Exception after resuming a process message Internal error. Error reading business object. Unknown column 'Docket_Cartage_DocketsGroup_Docket_A_Docket_Split.ID' in 'where clause'

Docket_Cartage = Reference attr in Docket_A (as well as in Docket_B & Docket_C).
DocketsGroup = BO Group
Docket_A = Object in the DocketsGroup group.
Docket_Split = Reference attr to itself. e.g Docket_A ref to Docket_A. Basically, once Docket_A B or C is created, sometimes it is duplicated and the duplicated Docket_x is referenced through this attribute.

You're sure that the Where clause of your group query only has in it attributes that are common to all BOs within the group? - Rod

The only attribute that is different is the Docket_Split attribute as all three Dockets ref to themselves.

I'm stuck and not sure where the inconsistency is or which object to check and trouvbleshoot.

Cheers

Rennur

show support issue

Oops, meant to type show stopper issue 🙂

I don't know which issue is more likely:
a) Object Group issue
b) Business Object attribute issue
c) Business Rules issue
d) Reference attribute issues
e) DUPLICATE or CREATE action in a process

Rennur

Some troubleshooting results in a slightly different error message.

I've changed Docket_Split to Docket_SplitC and the error I get now is:

Execution Exception after resuming a process message Internal error. Unable to build alias for the following attribute DocketsGroup.Docket_Split uses attribute 'Docket_Split' which has not been found

Rennur

Solved!

Not exactly sure how, but I've recreated some references that involve Groups.

Rennur

Not solved 🙁

There seems to be an issue with cross-reference rules when a shortcut path goes through a reference group attribute.

I cannot isolate the problem as it keeps jumping from object to object that the Dockets group is related to.

Frustrating, show stopper issue & I'm stuck.

Rennur

Narrowed it down to an issue with reference attributes belonging to a object group when cross-reference rules are executed.