IN Expression with BO Group problem

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

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

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.

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

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.

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

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

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

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

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

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

Solved!

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

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.

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