0020742: Many-to-one references to language are always eagerly fetched using a separate query

Description

The language table is special because most foreign keys to it do not refer to the primary key column but to the language code column.

As a result hibernate can't load the language as a proxy but will always eagerly fetch the referenced language.

Steps To Reproduce

See the output of a query for the businesspartner: many language queries are done:

13183 [main] DEBUG org.hibernate.SQL - select businesspa0_.C_BPartner_ID as C1_127_0_, businesspa0_.AD_Client_ID as AD2_127_0_, businesspa0_.AD_Org_ID as AD3_127_0_, businesspa0_.IsActive as IsActive127_0_, businesspa0_.Created as Created127_0_, businesspa0_.CreatedBy as CreatedBy127_0_, businesspa0_.Updated as Updated127_0_, businesspa0_.UpdatedBy as UpdatedBy127_0_, businesspa0_.Value as Value127_0_, businesspa0_.Name as Name127_0_, businesspa0_.Name2 as Name11_127_0_, businesspa0_.Description as Descrip12_127_0_, businesspa0_.IsSummary as IsSummary127_0_, businesspa0_.C_BP_Group_ID as C14_127_0_, businesspa0_.IsOneTime as IsOneTime127_0_, businesspa0_.IsProspect as IsProspect127_0_, businesspa0_.IsVendor as IsVendor127_0_, businesspa0_.IsCustomer as IsCustomer127_0_, businesspa0_.IsEmployee as IsEmployee127_0_, businesspa0_.IsSalesRep as IsSalesRep127_0_, businesspa0_.ReferenceNo as Referen21_127_0_, businesspa0_.DUNS as DUNS127_0_, businesspa0_.URL as URL127_0_, businesspa0_.AD_Language as AD24_127_0_, businesspa0_.TaxID as TaxID127_0_, businesspa0_.IsTaxExempt as IsTaxEx26_127_0_, businesspa0_.C_InvoiceSchedule_ID as C27_127_0_, businesspa0_.Rating as Rating127_0_, businesspa0_.SalesVolume as SalesVo29_127_0_, businesspa0_.NumberEmployees as NumberE30_127_0_, businesspa0_.NAICS as NAICS127_0_, businesspa0_.FirstSale as FirstSale127_0_, businesspa0_.AcqusitionCost as Acqusit33_127_0_, businesspa0_.PotentialLifeTimeValue as Potenti34_127_0_, businesspa0_.ActualLifeTimeValue as ActualL35_127_0_, businesspa0_.ShareOfCustomer as ShareOf36_127_0_, businesspa0_.PaymentRule as Payment37_127_0_, businesspa0_.SO_CreditLimit as SO38_127_0_, businesspa0_.SO_CreditUsed as SO39_127_0_, businesspa0_.C_PaymentTerm_ID as C40_127_0_, businesspa0_.M_PriceList_ID as M41_127_0_, businesspa0_.IsDiscountPrinted as IsDisco42_127_0_, businesspa0_.SO_Description as SO43_127_0_, businesspa0_.POReference as PORefer44_127_0_, businesspa0_.PaymentRulePO as Payment45_127_0_, businesspa0_.PO_PriceList_ID as PO46_127_0_, businesspa0_.PO_PaymentTerm_ID as PO47_127_0_, businesspa0_.DocumentCopies as Documen48_127_0_, businesspa0_.C_Greeting_ID as C49_127_0_, businesspa0_.InvoiceRule as Invoice50_127_0_, businesspa0_.DeliveryRule as Deliver51_127_0_, businesspa0_.DeliveryViaRule as Deliver52_127_0_, businesspa0_.SalesRep_ID as SalesRep53_127_0_, businesspa0_.BPartner_Parent_ID as BPartner54_127_0_, businesspa0_.SOCreditStatus as SOCredi55_127_0_, businesspa0_.AD_Forced_Org_ID as AD56_127_0_, businesspa0_.ShowPriceInOrder as ShowPri57_127_0_, businesspa0_.Invoicegrouping as Invoice58_127_0_, businesspa0_.FixMonthDay as FixMont59_127_0_, businesspa0_.FixMonthDay2 as FixMont60_127_0_, businesspa0_.Fixmonthday3 as Fixmont61_127_0_, businesspa0_.Isworker as Isworker127_0_, businesspa0_.UPC as UPC127_0_, businesspa0_.C_Salary_Category_ID as C64_127_0_, businesspa0_.Invoice_Printformat as Invoice65_127_0_, businesspa0_.Last_Days as Last66_127_0_, businesspa0_.PO_Bankaccount_ID as PO67_127_0_, businesspa0_.PO_BP_TaxCategory_ID as PO68_127_0_, businesspa0_.PO_Fixmonthday as PO69_127_0_, businesspa0_.PO_Fixmonthday2 as PO70_127_0_, businesspa0_.PO_Fixmonthday3 as PO71_127_0_, businesspa0_.SO_Bankaccount_ID as SO72_127_0_, businesspa0_.SO_Bp_Taxcategory_ID as SO73_127_0_, businesspa0_.Fiscalcode as Fiscalcode127_0_, businesspa0_.Isofiscalcode as Isofisc75_127_0_, businesspa0_.PO_C_Incoterms_ID as PO76_127_0_, businesspa0_.SO_C_Incoterms_ID as SO77_127_0_, businesspa0_.FIN_Paymentmethod_ID as FIN78_127_0_, businesspa0_.PO_Paymentmethod_ID as PO79_127_0_, businesspa0_.FIN_Financial_Account_ID as FIN80_127_0_, businesspa0_.PO_Financial_Account_ID as PO81_127_0_, businesspa0_.EM_Obwifde_Widget1 as EM82_127_0_, businesspa0_.EM_Obdun_Dunningpolicy_ID as EM83_127_0_ from C_BPartner businesspa0_ where businesspa0_.C_BPartner_ID in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
13198 [main] DEBUG org.hibernate.SQL - select adlanguage0_.AD_Language_ID as AD1_50_0_, adlanguage0_.AD_Language as AD2_50_0_, adlanguage0_.AD_Client_ID as AD3_50_0_, adlanguage0_.AD_Org_ID as AD4_50_0_, adlanguage0_.IsActive as IsActive50_0_, adlanguage0_.Created as Created50_0_, adlanguage0_.CreatedBy as CreatedBy50_0_, adlanguage0_.Updated as Updated50_0_, adlanguage0_.UpdatedBy as UpdatedBy50_0_, adlanguage0_.Name as Name50_0_, adlanguage0_.LanguageISO as Languag11_50_0_, adlanguage0_.CountryCode as Country12_50_0_, adlanguage0_.IsBaseLanguage as IsBaseL13_50_0_, adlanguage0_.IsSystemLanguage as IsSyste14_50_0_, adlanguage0_.Processing as Processing50_0_, adlanguage0_.Pixelsize as Pixelsize50_0_, adlanguage0_.Translatedby as Transla17_50_0_, adlanguage0_.Isrtl as Isrtl50_0_ from AD_Language adlanguage0_ where adlanguage0_.AD_Language=?
13207 [main] DEBUG org.hibernate.SQL - select adlanguage0_.AD_Language_ID as AD1_50_0_, adlanguage0_.AD_Language as AD2_50_0_, adlanguage0_.AD_Client_ID as AD3_50_0_, adlanguage0_.AD_Org_ID as AD4_50_0_, adlanguage0_.IsActive as IsActive50_0_, adlanguage0_.Created as Created50_0_, adlanguage0_.CreatedBy as CreatedBy50_0_, adlanguage0_.Updated as Updated50_0_, adlanguage0_.UpdatedBy as UpdatedBy50_0_, adlanguage0_.Name as Name50_0_, adlanguage0_.LanguageISO as Languag11_50_0_, adlanguage0_.CountryCode as Country12_50_0_, adlanguage0_.IsBaseLanguage as IsBaseL13_50_0_, adlanguage0_.IsSystemLanguage as IsSyste14_50_0_, adlanguage0_.Processing as Processing50_0_, adlanguage0_.Pixelsize as Pixelsize50_0_, adlanguage0_.Translatedby as Transla17_50_0_, adlanguage0_.Isrtl as Isrtl50_0_ from AD_Language adlanguage0_ where adlanguage0_.AD_Language=?
13210 [main] DEBUG org.hibernate.SQL - select adlanguage0_.AD_Language_ID as AD1_50_0_, adlanguage0_.AD_Language as AD2_50_0_, adlanguage0_.AD_Client_ID as AD3_50_0_, adlanguage0_.AD_Org_ID as AD4_50_0_, adlanguage0_.IsActive as IsActive50_0_, adlanguage0_.Created as Created50_0_, adlanguage0_.CreatedBy as CreatedBy50_0_, adlanguage0_.Updated as Updated50_0_, adlanguage0_.UpdatedBy as UpdatedBy50_0_, adlanguage0_.Name as Name50_0_, adlanguage0_.LanguageISO as Languag11_50_0_, adlanguage0_.CountryCode as Country12_50_0_, adlanguage0_.IsBaseLanguage as IsBaseL13_50_0_, adlanguage0_.IsSystemLanguage as IsSyste14_50_0_, adlanguage0_.Processing as Processing50_0_, adlanguage0_.Pixelsize as Pixelsize50_0_, adlanguage0_.Translatedby as Transla17_50_0_, adlanguage0_.Isrtl as Isrtl50_0_ from AD_Language adlanguage0_ where adlanguage0_.AD_Language=?
13211 [main] DEBUG org.hibernate.SQL - select adlanguage0_.AD_Language_ID as AD1_50_0_, adlanguage0_.AD_Language as AD2_50_0_, adlanguage0_.AD_Client_ID as AD3_50_0_, adlanguage0_.AD_Org_ID as AD4_50_0_, adlanguage0_.IsActive as IsActive50_0_, adlanguage0_.Created as Created50_0_, adlanguage0_.CreatedBy as CreatedBy50_0_, adlanguage0_.Updated as Updated50_0_, adlanguage0_.UpdatedBy as UpdatedBy50_0_, adlanguage0_.Name as Name50_0_, adlanguage0_.LanguageISO as Languag11_50_0_, adlanguage0_.CountryCode as Country12_50_0_, adlanguage0_.IsBaseLanguage as IsBaseL13_50_0_, adlanguage0_.IsSystemLanguage as IsSyste14_50_0_, adlanguage0_.Processing as Processing50_0_, adlanguage0_.Pixelsize as Pixelsize50_0_, adlanguage0_.Translatedby as Transla17_50_0_, adlanguage0_.Isrtl as Isrtl50_0_ from AD_Language adlanguage0_ where adlanguage0_.AD_Language=?
13213 [main] DEBUG org.hibernate.SQL - select adlanguage0_.AD_Language_ID as AD1_50_0_, adlanguage0_.AD_Language as AD2_50_0_, adlanguage0_.AD_Client_ID as AD3_50_0_, adlanguage0_.AD_Org_ID as AD4_50_0_, adlanguage0_.IsActive as IsActive50_0_, adlanguage0_.Created as Created50_0_, adlanguage0_.CreatedBy as CreatedBy50_0_, adlanguage0_.Updated as Updated50_0_, adlanguage0_.UpdatedBy as UpdatedBy50_0_, adlanguage0_.Name as Name50_0_, adlanguage0_.LanguageISO as Languag11_50_0_, adlanguage0_.CountryCode as Country12_50_0_, adlanguage0_.IsBaseLanguage as IsBaseL13_50_0_, adlanguage0_.IsSystemLanguage as IsSyste14_50_0_, adlanguage0_.Processing as Processing50_0_, adlanguage0_.Pixelsize as Pixelsize50_0_, adlanguage0_.Translatedby as Transla17_50_0_, adlanguage0_.Isrtl as Isrtl50_0_ from AD_Language adlanguage0_ where adlanguage0_.AD_Language=?
13214 [main] DEBUG org.hibernate.SQL - select adlanguage0_.AD_Language_ID as AD1_50_0_, adlanguage0_.AD_Language as AD2_50_0_, adlanguage0_.AD_Client_ID as AD3_50_0_, adlanguage0_.AD_Org_ID as AD4_50_0_, adlanguage0_.IsActive as IsActive50_0_, adlanguage0_.Created as Created50_0_, adlanguage0_.CreatedBy as CreatedBy50_0_, adlanguage0_.Updated as Updated50_0_, adlanguage0_.UpdatedBy as UpdatedBy50_0_, adlanguage0_.Name as Name50_0_, adlanguage0_.LanguageISO as Languag11_50_0_, adlanguage0_.CountryCode as Country12_50_0_, adlanguage0_.IsBaseLanguage as IsBaseL13_50_0_, adlanguage0_.IsSystemLanguage as IsSyste14_50_0_, adlanguage0_.Processing as Processing50_0_, adlanguage0_.Pixelsize as Pixelsize50_0_, adlanguage0_.Translatedby as Transla17_50_0_, adlanguage0_.Isrtl as Isrtl50_0_ from AD_Language adlanguage0_ where adlanguage0_.AD_Language=?
13215 [main] DEBUG org.hibernate.SQL - select adlanguage0_.AD_Language_ID as AD1_50_0_, adlanguage0_.AD_Language as AD2_50_0_, adlanguage0_.AD_Client_ID as AD3_50_0_, adlanguage0_.AD_Org_ID as AD4_50_0_, adlanguage0_.IsActive as IsActive50_0_, adlanguage0_.Created as Created50_0_, adlanguage0_.CreatedBy as CreatedBy50_0_, adlanguage0_.Updated as Updated50_0_, adlanguage0_.UpdatedBy as UpdatedBy50_0_, adlanguage0_.Name as Name50_0_, adlanguage0_.LanguageISO as Languag11_50_0_, adlanguage0_.CountryCode as Country12_50_0_, adlanguage0_.IsBaseLanguage as IsBaseL13_50_0_, adlanguage0_.IsSystemLanguage as IsSyste14_50_0_, adlanguage0_.Processing as Processing50_0_, adlanguage0_.Pixelsize as Pixelsize50_0_, adlanguage0_.Translatedby as Transla17_50_0_, adlanguage0_.Isrtl as Isrtl50_0_ from AD_Language adlanguage0_ where adlanguage0_.AD_Language=?
13216 [main] DEBUG org.hibernate.SQL - select adlanguage0_.AD_Language_ID as AD1_50_0_, adlanguage0_.AD_Language as AD2_50_0_, adlanguage0_.AD_Client_ID as AD3_50_0_, adlanguage0_.AD_Org_ID as AD4_50_0_, adlanguage0_.IsActive as IsActive50_0_, adlanguage0_.Created as Created50_0_, adlanguage0_.CreatedBy as CreatedBy50_0_, adlanguage0_.Updated as Updated50_0_, adlanguage0_.UpdatedBy as UpdatedBy50_0_, adlanguage0_.Name as Name50_0_, adlanguage0_.LanguageISO as Languag11_50_0_, adlanguage0_.CountryCode as Country12_50_0_, adlanguage0_.IsBaseLanguage as IsBaseL13_50_0_, adlanguage0_.IsSystemLanguage as IsSyste14_50_0_, adlanguage0_.Processing as Processing50_0_, adlanguage0_.Pixelsize as Pixelsize50_0_, adlanguage0_.Translatedby as Transla17_50_0_, adlanguage0_.Isrtl as Isrtl50_0_ from AD_Language adlanguage0_ where adlanguage0_.AD_Language=?
13217 [main] DEBUG org.hibernate.SQL - select adlanguage0_.AD_Language_ID as AD1_50_0_, adlanguage0_.AD_Language as AD2_50_0_, adlanguage0_.AD_Client_ID as AD3_50_0_, adlanguage0_.AD_Org_ID as AD4_50_0_, adlanguage0_.IsActive as IsActive50_0_, adlanguage0_.Created as Created50_0_, adlanguage0_.CreatedBy as CreatedBy50_0_, adlanguage0_.Updated as Updated50_0_, adlanguage0_.UpdatedBy as UpdatedBy50_0_, adlanguage0_.Name as Name50_0_, adlanguage0_.LanguageISO as Languag11_50_0_, adlanguage0_.CountryCode as Country12_50_0_, adlanguage0_.IsBaseLanguage as IsBaseL13_50_0_, adlanguage0_.IsSystemLanguage as IsSyste14_50_0_, adlanguage0_.Processing as Processing50_0_, adlanguage0_.Pixelsize as Pixelsize50_0_, adlanguage0_.Translatedby as Transla17_50_0_, adlanguage0_.Isrtl as Isrtl50_0_ from AD_Language adlanguage0_ where adlanguage0_.AD_Language=?
13219 [main] DEBUG org.hibernate.SQL - select adlanguage0_.AD_Language_ID as AD1_50_0_, adlanguage0_.AD_Language as AD2_50_0_, adlanguage0_.AD_Client_ID as AD3_50_0_, adlanguage0_.AD_Org_ID as AD4_50_0_, adlanguage0_.IsActive as IsActive50_0_, adlanguage0_.Created as Created50_0_, adlanguage0_.CreatedBy as CreatedBy50_0_, adlanguage0_.Updated as Updated50_0_, adlanguage0_.UpdatedBy as UpdatedBy50_0_, adlanguage0_.Name as Name50_0_, adlanguage0_.LanguageISO as Languag11_50_0_, adlanguage0_.CountryCode as Country12_50_0_, adlanguage0_.IsBaseLanguage as IsBaseL13_50_0_, adlanguage0_.IsSystemLanguage as IsSyste14_50_0_, adlanguage0_.Processing as Processing50_0_, adlanguage0_.Pixelsize as Pixelsize50_0_, adlanguage0_.Translatedby as Transla17_50_0_, adlanguage0_.Isrtl as Isrtl50_0_ from AD_Language adlanguage0_ where adlanguage0_.AD_Language=?
13220 [main] DEBUG org.hibernate.SQL - select adlanguage0_.AD_Language_ID as AD1_50_0_, adlanguage0_.AD_Language as AD2_50_0_, adlanguage0_.AD_Client_ID as AD3_50_0_, adlanguage0_.AD_Org_ID as AD4_50_0_, adlanguage0_.IsActive as IsActive50_0_, adlanguage0_.Created as Created50_0_, adlanguage0_.CreatedBy as CreatedBy50_0_, adlanguage0_.Updated as Updated50_0_, adlanguage0_.UpdatedBy as UpdatedBy50_0_, adlanguage0_.Name as Name50_0_, adlanguage0_.LanguageISO as Languag11_50_0_, adlanguage0_.CountryCode as Country12_50_0_, adlanguage0_.IsBaseLanguage as IsBaseL13_50_0_, adlanguage0_.IsSystemLanguage as IsSyste14_50_0_, adlanguage0_.Processing as Processing50_0_, adlanguage0_.Pixelsize as Pixelsize50_0_, adlanguage0_.Translatedby as Transla17_50_0_, adlanguage0_.Isrtl as Isrtl50_0_ from AD_Language adlanguage0_ where adlanguage0_.AD_Language=?
13221 [main] DEBUG org.hibernate.SQL - select adlanguage0_.AD_Language_ID as AD1_50_0_, adlanguage0_.AD_Language as AD2_50_0_, adlanguage0_.AD_Client_ID as AD3_50_0_, adlanguage0_.AD_Org_ID as AD4_50_0_, adlanguage0_.IsActive as IsActive50_0_, adlanguage0_.Created as Created50_0_, adlanguage0_.CreatedBy as CreatedBy50_0_, adlanguage0_.Updated as Updated50_0_, adlanguage0_.UpdatedBy as UpdatedBy50_0_, adlanguage0_.Name as Name50_0_, adlanguage0_.LanguageISO as Languag11_50_0_, adlanguage0_.CountryCode as Country12_50_0_, adlanguage0_.IsBaseLanguage as IsBaseL13_50_0_, adlanguage0_.IsSystemLanguage as IsSyste14_50_0_, adlanguage0_.Processing as Processing50_0_, adlanguage0_.Pixelsize as Pixelsize50_0_, adlanguage0_.Translatedby as Transla17_50_0_, adlanguage0_.Isrtl as Isrtl50_0_ from AD_Language adlanguage0_ where adlanguage0_.AD_Language=?

Proposed Solution

The solution is to change the mapping logic to eagerly join the language to the original query, the original query gets bigger but many queries are prevented.

Tags

Performance

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

related to

defect

0028479

closed

alostale

unneeded queries to ad_langue table

Notes
(0049803) mtaal (manager) 2012-06-13 11:41	// language is always loaded explicitly by Hibernate because it is a non-pk // association, eager fetch with the parent then.. // after some more thought, normally only a limited number of languages are used // resulting in a few extra queries in the beginning of the transaction, the rest is loaded // from the first level cache, so the current approach is fine, keep the following // lines commented

(0049968) hgbot (developer) 2012-06-21 12:03	Repository: erp/devel/pi Changeset: 2baccc5f8395b32082dcae3ea1afbe81f3483d65 Author: Martin Taal <martin.taal <at> openbravo.com> Date: Wed Jun 13 10:49:40 2012 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/2baccc5f8395b32082dcae3ea1afbe81f3483d65 [^] Fixes issue 20742: Many-to-one references to language are always eagerly fetched using a separate query To join fetching for many-to-one references to Language --- M src/org/openbravo/dal/core/DalMappingGenerator.java ---

(0049969) hgbot (developer) 2012-06-21 12:03	Repository: erp/devel/pi Changeset: 38a3ce7253787fe3af5f84d2011e33499eafcfbb Author: Martin Taal <martin.taal <at> openbravo.com> Date: Wed Jun 13 11:31:23 2012 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/38a3ce7253787fe3af5f84d2011e33499eafcfbb [^] Related to issue 20742: Many-to-one references to language are always eagerly fetched using a separate query Remove commented lines --- M src/org/openbravo/dal/core/DalMappingGenerator.java ---

(0049970) hgbot (developer) 2012-06-21 12:03	Repository: erp/devel/pi Changeset: 6f486cc8c40f3f160f2a8daaf1e05392da22f79e Author: Martin Taal <martin.taal <at> openbravo.com> Date: Wed Jun 13 11:40:45 2012 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/6f486cc8c40f3f160f2a8daaf1e05392da22f79e [^] Related to issue 20742: Many-to-one references to language are always eagerly fetched using a separate query Commented lines, reversing changes for this issue, issue is invalid --- M src/org/openbravo/dal/core/DalMappingGenerator.java ---

(0050092) mtaal (manager) 2012-06-26 15:39	Change was reversed

(0050139) hudsonbot (developer) 2012-06-27 05:28	A changeset related to this issue has been promoted main and to the Central Repository, after passing a series of tests. Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/cf3a7135839f [^] Maturity status: Test

(0050140) hudsonbot (developer) 2012-06-27 05:28	A changeset related to this issue has been promoted main and to the Central Repository, after passing a series of tests. Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/cf3a7135839f [^] Maturity status: Test

(0050141) hudsonbot (developer) 2012-06-27 05:28	A changeset related to this issue has been promoted main and to the Central Repository, after passing a series of tests. Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/cf3a7135839f [^] Maturity status: Test

Issue History
Date Modified	Username	Field	Change
2012-06-13 10:48	mtaal	New Issue
2012-06-13 10:48	mtaal	Assigned To	=> mtaal
2012-06-13 10:48	mtaal	Modules	=> Core
2012-06-13 10:51	alostale	Tag Attached: Performance
2012-06-13 11:41	mtaal	Note Added: 0049803
2012-06-13 11:41	mtaal	Status	new => closed
2012-06-13 11:41	mtaal	Resolution	open => no change required
2012-06-21 12:03	hgbot	Checkin
2012-06-21 12:03	hgbot	Note Added: 0049968
2012-06-21 12:03	hgbot	Status	closed => resolved
2012-06-21 12:03	hgbot	Resolution	no change required => fixed
2012-06-21 12:03	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/devel/pi/rev/2baccc5f8395b32082dcae3ea1afbe81f3483d65 [^]
2012-06-21 12:03	hgbot	Checkin
2012-06-21 12:03	hgbot	Note Added: 0049969
2012-06-21 12:03	hgbot	Checkin
2012-06-21 12:03	hgbot	Note Added: 0049970
2012-06-26 15:39	mtaal	Note Added: 0050092
2012-06-26 15:39	mtaal	Status	resolved => closed
2012-06-26 15:39	mtaal	Fixed in Version	=> 3.0MP13
2012-06-27 05:28	hudsonbot	Checkin
2012-06-27 05:28	hudsonbot	Note Added: 0050139
2012-06-27 05:28	hudsonbot	Checkin
2012-06-27 05:28	hudsonbot	Note Added: 0050140
2012-06-27 05:28	hudsonbot	Checkin
2012-06-27 05:28	hudsonbot	Note Added: 0050141
2017-10-13 12:02	alostale	Relationship added	related to 0028479
2017-10-13 12:39	alostale	Relationship added	related to 0037064
2017-10-13 12:39	alostale	Relationship deleted	related to 0037064