0020829: BB.DD rrror when executing Bill of Materials Production process

Description

See attached screenshot

a3196480 813916 [TP-Processor6] INFO org.openbravo.erpCommon.utility.ErrorTextParserPOSTGRE - did not find constraint name for error message: query specified join fetching, but the owner of the fetched association was not present in the select list [FromElement{explicit,not a collection join,fetch join,fetch non-lazy properties,classAlias=join_0,role=null,tableName=M_Product,tableAlias=product1_,origin=M_ProductionPlan materialmg0_,columns={materialmg0_.M_Product_ID ,className=Product}}] [select e.id from MaterialMgmtProductionPlan as e left join fetch e.product as join_0 where ( ( e.production.id = :alias_0 ) ) and e.organization.id in ('E443A31992CB4635AFCAEABE7183CE85', '856478800DB049E98ED9FE51693D5B7F', '38C91465BE5A449EBBCCC5DCF33B165F', 'DC206C91AA6A4897B44DA897936E0EC3', '9B0149B3D28549C0B5F91D339E8AE730', 'B843C30461EA4501935CB1D125C9C25A', '2E60544D37534C0B89E765FE29BC0B43', '0', '12CA582AB0D1455D9D323481E25C795A', '7BABA5FF80494CAFA54DEBD22EC46F01', 'A217575E2A9E4631A413D48109163D93', 'BAE22373FEBE4CCCA24517E23F0C8A48', '19404EAD144C49A0AF37D54377CF452D') and e.client.id in ('23C59575B9CF467C9620760EB255B389', '0')order by join_0.name,e.id]

Steps To Reproduce

Login as Openbravo/openbravo

Go to product and create:
Product p11
-Organization: F&B US, Inc.
-Name:p11
-stocked=Y
-bill of materials:N
-tab price: price list: general sales, net unit price=5, net list price=5
Product p12
-Organization: F&B US, Inc.
-Name:p12
-stocked=Y
-bill of materials:N
-tab price: price list: general sales, net unit price=6, net list price=6
Product p1
-Organization: F&B US, Inc.
-Name:p1
-stocked=N
-bill of materials:y
-tab price: price list: general sales, net unit price=0, net list price=0
-tab Bill of matenials
   -bom product:p11, active:yes
   -bom product:p12, active:no
-Click Verify BOM
Product p2
-Organization: F&B US, Inc.
-Name:p2
-stocked=Y
-bill of materials:N
-tab price: price list: general sales, net unit price=1.5, net list price=1.5
Product p
-Organization: F&B US, Inc.
-Name:p
-stocked=Y
-bill of materials:y
-tab price: price list: general sales, net unit price=0, net list price=0
-tab Bill of matenials
   -bom product:p1, active: yes
   -bom product:p2, active: yes
-Click Verify BOM

Go to Bill of Materials Production.
Create a new record:
"Organization": F&B US
"Name": BoMPT
Move to Production Plan tab and create a new record:
"Product": p
"Production Quantity": 10
"Storage Bin": WC-1-0-0

Click on "Create/Process Production" and OK

Tags

No tags attached.

Attached Files

Error.png [^] (84,560 bytes) 2012-06-21 17:33

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0050185) mirurita (viewer) 2012-06-27 11:46	testing OK

Issue History
Date Modified	Username	Field	Change
2012-06-21 17:33	mirurita	New Issue
2012-06-21 17:33	mirurita	Assigned To	=> alostale
2012-06-21 17:33	mirurita	File Added: Error.png
2012-06-21 17:33	mirurita	Modules	=> Core
2012-06-21 17:33	mirurita	OBNetwork customer	=> No
2012-06-21 22:25	mtaal	Assigned To	alostale => mtaal
2012-06-27 11:45	mirurita	Status	new => scheduled
2012-06-27 11:45	mirurita	fix_in_branch	=> pi
2012-06-27 11:46	mirurita	Status	scheduled => resolved
2012-06-27 11:46	mirurita	Fixed in Version	=> 3.0MP13
2012-06-27 11:46	mirurita	Fixed in SCM revision	=> https://issues.openbravo.com/view.php?id=20840 [^]
2012-06-27 11:46	mirurita	Resolution	open => fixed
2012-06-27 11:46	mirurita	Note Added: 0050185
2012-06-27 11:46	mirurita	Status	resolved => closed