Skip to main content

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
[eclipselink-users] Multi-thread cache corruption

Hi together,

 

I believe we have some case of cache corruption. We can reproduce it within a test-case of our application with ~70% reliability.

 

How the issues manifest itself: within a transaction, a flush of the EntityManager triggers a Foreign key violation about another entry that has been added (and successfully updated) within the same transaction.

 

What we did to trigger the issue: we started passing id to the asynchronous workers (and let them fetch the entity themselves) instead of passing them the entity directly. This does put a lot of more work onto the entity manager, causing it to corrupt its cache (I believe). When we remove that modification, that issue does not happens. Which leads us to believe that using eclipselink asynchronously more than before is what triggers the issue.

 

Enclosed is an example of logs that get generated while the issue occurs. That log is trimmed to the instant where the erroneous unit-of-work (1298690816) is active. Some other are visible, those are the mentioned asynchronous workers. Let me go briefly through it:

 

An entity of type slaughter_party is first inserted (id: 640). That entity is queried, updated a few times. Later another entity of the same type is created with a (supposedly) reference to the first one (old_party_id). The flush of that second entity claims that the first one does not exist.

 

Sometimes, that same issue (a foreign key violation) happens with different objects, always related to a missing entity of type slaughter_party.

 

There is another cache error happening in this log (probably related): an entity of type join_partner_business (partner 635, business 607) is inserted with id 639 after checking that it doesn’t exists (select count …). That same procedure happens a few moments later and decides to insert a new join_partner_business (id 647) about the same relation. In case where it works, that second join entity is (rightfully) never inserted.

 

I tried with various DB backend (HSQL in-memory, H2 in-memory and H2 file), as those are quite easy to setup, they all trigger the same issue.

 

I hope you can shed some light on our issue and point me to my mistake as I don’t really want to believe that multi-threaded eclipselink is fundamentally broken.


Mit freundlichen Grüßen / Kind regards / С уважением


Benoit Allard
Software Engineer


SOFTWARE. APPLICATIONS. SERVICES.

SLA Software Logistik Artland GmbH

ARTLAND
 Friedrichstr. 30, D-49610 Quakenbrück
 +49 5431 9480 - 379
 +49 5431 9480 - 979
 benoit.allard@xxxxxx
sla.de

BERLIN
 Keithstraße 14, D-10787 Berlin

OSNABRÜCK
 
Dinglingsweg 1a, D-49565 Bramsche

Support
DE
+49 5431 9480 - 77 
AT +43 720 115300

Geschäftsführer Jörg Brezl (CEO) | Hermann Grevemeyer (COO)
Handelsregister 
Amtsgericht Osnabrück - HRB 20381

Follow us:
           

[EL Finer]: transaction: 2018-11-02 14:18:22.847--ClientSession(1224339926)--Thread(Thread[main,5,main])--acquire unit of work: 1298690816
[EL Finer]: transaction: 2018-11-02 14:18:22.848--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--begin unit of work flush
[EL Finer]: transaction: 2018-11-02 14:18:22.848--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--end unit of work flush
[EL Finest]: query: 2018-11-02 14:18:22.848--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query ReadAllQuery(referenceClass=ProjectSlaughterParty sql="SELECT id, afom1_bacon, afom1_bacon_amount, afom1_belly, afom1_belly_amount, afom1_belly_lmp, afom1_belly_lamount, afom1_belly_lweight, afom1_index, afom1_index_amount, afom1_lmp, afom1_lamount, afom1_lweight, afom1_meat, afom1_meat_amount, afom1_pure_ham, afom1_pure_ham_amount, afom1_pure_shoulder, afom1_pure_shoulder_amount, afom3_bacon, afom3_bacon_amount, afom3_belly, afom3_belly_amount, afom3_belly_lmp, afom3_belly_lamount, afom3_belly_lweight, afom3_index, afom3_index_amount, afom3_lmp, afom3_lamount, afom3_lweight, afom3_meat, afom3_meat_amount, afom3_pure_ham, afom3_pure_ham_amount, afom3_pure_shoulder, afom3_pure_shoulder_amount, base_price_ct, bonus_ct, delivery_date, exploitation, fom_bacon, fom_bacon_amount, fom_lmp, fom_lamount, fom_lweight, fom_meat, fom_meat_amount, liver, living_weight, lung, animals_rejected_amount, slaughter_date, slaughter_mark, animals_slaughtered_delivered, animals_slaughtered_payed, animal_weight_slaughtered_original, animal_weight_slaughtered_payed, animals_stable_lost, status, animals_transport_lost, union_price_diff, union_price_ref, value_ct, animals_veterinary_lost, business_id, slaughter_mask_id, old_entry_id, slaughter_house_id, animal_movement_id FROM slaughter_party WHERE ((((status = ?) AND (business_id = ?)) AND (delivery_date = ?)) AND (slaughter_mark = ?))")
2018-11-02 14:18:22.848 [main] TRACE d.s.j.c.LocalDateAttributeConverter#convertToDatabaseColumn[23] - Converted to DB: 2018-11-02 -> 2018-11-02
[EL Finest]: connection: 2018-11-02 14:18:22.849--ServerSession(46351362)--Connection(1638696823)--Thread(Thread[main,5,main])--Connection acquired from connection pool [read].
[EL Finest]: connection: 2018-11-02 14:18:22.849--ServerSession(46351362)--Thread(Thread[main,5,main])--reconnecting to external connection pool
[EL Fine]: sql: 2018-11-02 14:18:22.849--ServerSession(46351362)--Connection(266374831)--Thread(Thread[main,5,main])--SELECT id, afom1_bacon, afom1_bacon_amount, afom1_belly, afom1_belly_amount, afom1_belly_lmp, afom1_belly_lamount, afom1_belly_lweight, afom1_index, afom1_index_amount, afom1_lmp, afom1_lamount, afom1_lweight, afom1_meat, afom1_meat_amount, afom1_pure_ham, afom1_pure_ham_amount, afom1_pure_shoulder, afom1_pure_shoulder_amount, afom3_bacon, afom3_bacon_amount, afom3_belly, afom3_belly_amount, afom3_belly_lmp, afom3_belly_lamount, afom3_belly_lweight, afom3_index, afom3_index_amount, afom3_lmp, afom3_lamount, afom3_lweight, afom3_meat, afom3_meat_amount, afom3_pure_ham, afom3_pure_ham_amount, afom3_pure_shoulder, afom3_pure_shoulder_amount, base_price_ct, bonus_ct, delivery_date, exploitation, fom_bacon, fom_bacon_amount, fom_lmp, fom_lamount, fom_lweight, fom_meat, fom_meat_amount, liver, living_weight, lung, animals_rejected_amount, slaughter_date, slaughter_mark, animals_slaughtered_delivered, animals_slaughtered_payed, animal_weight_slaughtered_original, animal_weight_slaughtered_payed, animals_stable_lost, status, animals_transport_lost, union_price_diff, union_price_ref, value_ct, animals_veterinary_lost, business_id, slaughter_mask_id, old_entry_id, slaughter_house_id, animal_movement_id FROM slaughter_party WHERE ((((status = ?) AND (business_id = ?)) AND (delivery_date = ?)) AND (slaughter_mark = ?))
	bind => [CREATED, 607, 2018-11-02, BRA1234321]
[EL Finest]: connection: 2018-11-02 14:18:22.849--ServerSession(46351362)--Connection(1638696823)--Thread(Thread[main,5,main])--Connection released to connection pool [read].
[EL Finer]: transaction: 2018-11-02 14:18:22.85--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--begin unit of work flush
[EL Finer]: transaction: 2018-11-02 14:18:22.85--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--end unit of work flush
[EL Finest]: query: 2018-11-02 14:18:22.85--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query ReportQuery(referenceClass=ProjectJoinPartnerBusiness sql="SELECT COUNT(id) FROM join_partner_business WHERE (((to_date IS NULL) AND (a_id = ?)) AND (b_id = ?))")
[EL Finest]: connection: 2018-11-02 14:18:22.85--ServerSession(46351362)--Connection(1256971007)--Thread(Thread[main,5,main])--Connection acquired from connection pool [read].
[EL Finest]: connection: 2018-11-02 14:18:22.85--ServerSession(46351362)--Thread(Thread[main,5,main])--reconnecting to external connection pool
[EL Fine]: sql: 2018-11-02 14:18:22.85--ServerSession(46351362)--Connection(266374831)--Thread(Thread[main,5,main])--SELECT COUNT(id) FROM join_partner_business WHERE (((to_date IS NULL) AND (a_id = ?)) AND (b_id = ?))
	bind => [635, 607]
[EL Finest]: connection: 2018-11-02 14:18:22.85--ServerSession(46351362)--Connection(1256971007)--Thread(Thread[main,5,main])--Connection released to connection pool [read].
[EL Finest]: transaction: 2018-11-02 14:18:22.85--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--register_new_for_persist (There is no English translation for this message.)
[EL Finest]: sequencing: 2018-11-02 14:18:22.85--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--assign sequence to the object (639 -> company.customer.project.schema.masterdata.ProjectJoinPartnerBusiness@94d4dd)
[EL Finest]: transaction: 2018-11-02 14:18:22.851--UnitOfWork(969412636)--Thread(Thread[main,5,main])--Register the existing object company.customer.project.schema.masterdata.ProjectJoinFarmBusiness@580a610a
[EL Finest]: transaction: 2018-11-02 14:18:22.851--UnitOfWork(969412636)--Thread(Thread[main,5,main])--Register the existing object company.customer.project.schema.masterdata.ProjectFarm@19e86461
[EL Finest]: transaction: 2018-11-02 14:18:22.851--UnitOfWork(969412636)--Thread(Thread[main,5,main])--Register the existing object company.customer.project.schema.masterdata.ProjectAddress@31475919
[EL Finest]: transaction: 2018-11-02 14:18:22.851--UnitOfWork(969412636)--Thread(Thread[main,5,main])--Register the existing object company.customer.project.schema.masterdata.ProjectBusiness@7d7be366
[EL Finest]: transaction: 2018-11-02 14:18:22.851--UnitOfWork(969412636)--Thread(Thread[main,5,main])--Register the existing object company.customer.project.schema.masterdata.ProjectJoinProducerGroupFarm@541c7857
[EL Finest]: transaction: 2018-11-02 14:18:22.851--UnitOfWork(969412636)--Thread(Thread[main,5,main])--Register the existing object company.customer.project.schema.masterdata.ProjectProducerGroup@40679991
[EL Finest]: transaction: 2018-11-02 14:18:22.851--UnitOfWork(969412636)--Thread(Thread[main,5,main])--Register the existing object company.customer.project.schema.masterdata.ProjectPartner@612c4c10
[EL Finest]: transaction: 2018-11-02 14:18:22.851--UnitOfWork(969412636)--Thread(Thread[main,5,main])--Register the existing object company.customer.project.schema.masterdata.ProjectProducerGroup@40679991
[EL Finest]: transaction: 2018-11-02 14:18:22.851--UnitOfWork(969412636)--Thread(Thread[main,5,main])--Register the existing object company.customer.project.schema.masterdata.ProjectFarm@19e86461
[EL Finer]: transaction: 2018-11-02 14:18:22.857--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--begin unit of work flush
[EL Finest]: query: 2018-11-02 14:18:22.857--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query DoesExistQuery(referenceClass=ProjectPartner )
[EL Finest]: query: 2018-11-02 14:18:22.857--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query DoesExistQuery(referenceClass=ProjectBusiness )
[EL Finest]: query: 2018-11-02 14:18:22.857--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query InsertObjectQuery(company.customer.project.schema.masterdata.ProjectJoinPartnerBusiness@94d4dd)
[EL Finest]: connection: 2018-11-02 14:18:22.858--ServerSession(46351362)--Connection(1878099363)--Thread(Thread[main,5,main])--Connection acquired from connection pool [default].
[EL Finer]: transaction: 2018-11-02 14:18:22.858--ClientSession(1224339926)--Connection(1878099363)--Thread(Thread[main,5,main])--begin transaction
[EL Finest]: connection: 2018-11-02 14:18:22.858--ClientSession(1224339926)--Thread(Thread[main,5,main])--reconnecting to external connection pool
[EL Fine]: sql: 2018-11-02 14:18:22.858--ClientSession(1224339926)--Connection(266374831)--Thread(Thread[main,5,main])--INSERT INTO join_partner_business (id, comparison, from_date, to_date, a_id, b_id) VALUES (?, ?, ?, ?, ?, ?)
	bind => [639, true, 2018-08-02 12:18:22.85, null, 635, 607]
[EL Finer]: transaction: 2018-11-02 14:18:22.858--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--end unit of work flush
[EL Finer]: transaction: 2018-11-02 14:18:22.858--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--resume unit of work
[EL Finest]: query: 2018-11-02 14:18:22.858--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query ReportQuery(referenceClass=ProjectUnionPrice sql="SELECT price FROM union_price WHERE (((((type = ?) AND (valid_from < ?)) AND (valid_to > ?)) AND (animal_group = ?)) AND (animal_sub_group = ?))")
2018-11-02 14:18:22.858 [main] TRACE d.s.j.c.LocalDateAttributeConverter#convertToDatabaseColumn[23] - Converted to DB: 2018-11-02 -> 2018-11-02
2018-11-02 14:18:22.858 [main] TRACE d.s.j.c.LocalDateAttributeConverter#convertToDatabaseColumn[23] - Converted to DB: 2018-11-02 -> 2018-11-02
[EL Fine]: sql: 2018-11-02 14:18:22.858--ClientSession(1224339926)--Connection(266374831)--Thread(Thread[main,5,main])--SELECT price FROM union_price WHERE (((((type = ?) AND (valid_from < ?)) AND (valid_to > ?)) AND (animal_group = ?)) AND (animal_sub_group = ?))
	bind => [VEZG, 2018-11-02, 2018-11-02, PIG, PIG]
[EL Finest]: transaction: 2018-11-02 14:18:22.859--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--register_new_for_persist (There is no English translation for this message.)
[EL Finest]: sequencing: 2018-11-02 14:18:22.859--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--assign sequence to the object (640 -> company.customer.project.schema.animal.ProjectSlaughterParty@320d98f5)
[EL Finer]: transaction: 2018-11-02 14:18:22.859--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--begin unit of work flush
[EL Finest]: query: 2018-11-02 14:18:22.859--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query DoesExistQuery(referenceClass=ProjectBusiness )
[EL Finest]: query: 2018-11-02 14:18:22.859--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query DoesExistQuery(referenceClass=ProjectSlaughterMask )
[EL Finest]: query: 2018-11-02 14:18:22.859--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query DoesExistQuery(referenceClass=ProjectJoinPartnerVvvoNumber )
[EL Finest]: query: 2018-11-02 14:18:22.859--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query InsertObjectQuery(company.customer.project.schema.animal.ProjectSlaughterParty@320d98f5)
2018-11-02 14:18:22.859 [main] TRACE d.s.j.c.LocalDateAttributeConverter#convertToDatabaseColumn[23] - Converted to DB: 2018-11-02 -> 2018-11-02
2018-11-02 14:18:22.860 [main] TRACE d.s.j.c.LocalDateAttributeConverter#convertToDatabaseColumn[23] - Converted to DB: 2018-11-02 -> 2018-11-02
[EL Fine]: sql: 2018-11-02 14:18:22.86--ClientSession(1224339926)--Connection(266374831)--Thread(Thread[main,5,main])--INSERT INTO slaughter_party (id, afom1_bacon, afom1_bacon_amount, afom1_belly, afom1_belly_amount, afom1_belly_lmp, afom1_belly_lamount, afom1_belly_lweight, afom1_index, afom1_index_amount, afom1_lmp, afom1_lamount, afom1_lweight, afom1_meat, afom1_meat_amount, afom1_pure_ham, afom1_pure_ham_amount, afom1_pure_shoulder, afom1_pure_shoulder_amount, afom3_bacon, afom3_bacon_amount, afom3_belly, afom3_belly_amount, afom3_belly_lmp, afom3_belly_lamount, afom3_belly_lweight, afom3_index, afom3_index_amount, afom3_lmp, afom3_lamount, afom3_lweight, afom3_meat, afom3_meat_amount, afom3_pure_ham, afom3_pure_ham_amount, afom3_pure_shoulder, afom3_pure_shoulder_amount, base_price_ct, bonus_ct, delivery_date, exploitation, fom_bacon, fom_bacon_amount, fom_lmp, fom_lamount, fom_lweight, fom_meat, fom_meat_amount, liver, living_weight, lung, animals_rejected_amount, slaughter_date, slaughter_mark, animals_slaughtered_delivered, animals_slaughtered_payed, animal_weight_slaughtered_original, animal_weight_slaughtered_payed, animals_stable_lost, status, animals_transport_lost, union_price_diff, union_price_ref, value_ct, animals_veterinary_lost, business_id, slaughter_mask_id, old_entry_id, slaughter_house_id, animal_movement_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
	bind => [640, null, 0, null, 0, null, 0, 0.0, null, 0, null, 0, 0.0, null, 0, null, 0, null, 0, null, 0, null, 0, null, 0, 0.0, null, 0, null, 0, 0.0, null, 0, null, 0, null, 0, 149, 0, 2018-11-02, null, null, 0, null, 0, 0.0, null, 0, 0.0, null, 0.0, 1, 2018-11-02, BRA1234321, 50, 44, 94.18000030517578, 94.18000030517578, 2, CREATED, 2, 0.0, 0.0, 0, 1, 607, 638, null, 637, null]
[EL Finer]: transaction: 2018-11-02 14:18:22.86--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--end unit of work flush
[EL Finer]: transaction: 2018-11-02 14:18:22.861--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--resume unit of work
[EL Finest]: query: 2018-11-02 14:18:22.861--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query ReadAllQuery(referenceClass=AbstractChoice sql="SELECT id, DTYPE, date_to, description FROM cho_choices WHERE ((description = ?) AND (DTYPE = ?))")
[EL Fine]: sql: 2018-11-02 14:18:22.861--ClientSession(1224339926)--Connection(266374831)--Thread(Thread[main,5,main])--SELECT id, DTYPE, date_to, description FROM cho_choices WHERE ((description = ?) AND (DTYPE = ?))
	bind => [Schlachtschwein geliefert, aber nicht bezahlt, animal_loss_type]
[EL Finest]: query: 2018-11-02 14:18:22.861--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query ReadObjectQuery(name="readProjectBusiness" referenceClass=ProjectBusiness sql="SELECT id, abstention_days, accounting_code, animal_welfare, auto_email_animal_disposal, auto_email_animal_disposal_max_days, business_assessment, default_exploitation, enable_hit_reporting, enable_tam_reporting, evaluation_strategy, fax_number, fodder_consumption_correction, from_date, name, own_fodder_producer, piglet_origin, quality_management, receive_delivery_note_push_info, receive_slaughter_push_info, release_animal_price, release_animal_welfare, release_fodder_price, release_slaughter_price, rest_area, slaughter_mark, to_date, total_area, weight_growth_correction, animal_disposal_partner_id, production_type_id, address_id, partner_self_id FROM business WHERE (id = ?)")
[EL Finest]: transaction: 2018-11-02 14:18:22.867--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Register the existing object company.customer.project.schema.masterdata.ProjectBusiness@7d7be366
[EL Finest]: transaction: 2018-11-02 14:18:22.867--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Register the existing object company.customer.project.schema.masterdata.ProjectProductionType@5626cb89
[EL Finest]: transaction: 2018-11-02 14:18:22.867--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Register the existing object company.customer.project.schema.masterdata.ProjectAddress@2095e085
[EL Finest]: transaction: 2018-11-02 14:18:22.867--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Register the existing object company.customer.project.schema.masterdata.ProjectPartner@23243385
[EL Finest]: transaction: 2018-11-02 14:18:22.867--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Register the existing object company.customer.project.schema.masterdata.ProjectBusiness@7d7be366
[EL Finer]: transaction: 2018-11-02 14:18:22.868--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--begin unit of work flush
[EL Finer]: transaction: 2018-11-02 14:18:22.868--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--end unit of work flush
[EL Finest]: query: 2018-11-02 14:18:22.868--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query ReadAllQuery(referenceClass=ProjectJoinPartnerVvvoNumber sql="SELECT t0.id, t0.clearing_house, t0.from_date, t0.to_date, t0.type, t0.custom_type_id, t0.partner_id, t0.vvvo_number_id FROM join_partner_vvvo_number t0, vvvo_number t1 WHERE (((t0.to_date IS NULL) AND (t1.long_value = ?)) AND (t1.id = t0.vvvo_number_id))")
[EL Fine]: sql: 2018-11-02 14:18:22.868--ClientSession(1224339926)--Connection(266374831)--Thread(Thread[main,5,main])--SELECT t0.id, t0.clearing_house, t0.from_date, t0.to_date, t0.type, t0.custom_type_id, t0.partner_id, t0.vvvo_number_id FROM join_partner_vvvo_number t0, vvvo_number t1 WHERE (((t0.to_date IS NULL) AND (t1.long_value = ?)) AND (t1.id = t0.vvvo_number_id))
	bind => [276112223334445]
[EL Finest]: transaction: 2018-11-02 14:18:22.869--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Register the existing object company.customer.project.schema.masterdata.ProjectPartner@4a09f5b
[EL Finest]: transaction: 2018-11-02 14:18:22.869--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Register the existing object company.customer.project.schema.masterdata.ProjectVvvoNumber@1290fc6a
[EL Finer]: transaction: 2018-11-02 14:18:22.869--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--begin unit of work flush
[EL Finer]: transaction: 2018-11-02 14:18:22.869--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--end unit of work flush
[EL Finest]: query: 2018-11-02 14:18:22.87--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query ReportQuery(referenceClass=ProjectJoinPartnerBusiness sql="SELECT COUNT(id) FROM join_partner_business WHERE (((to_date IS NULL) AND (a_id = ?)) AND (b_id = ?))")
[EL Fine]: sql: 2018-11-02 14:18:22.87--ClientSession(1224339926)--Connection(266374831)--Thread(Thread[main,5,main])--SELECT COUNT(id) FROM join_partner_business WHERE (((to_date IS NULL) AND (a_id = ?)) AND (b_id = ?))
	bind => [593, 607]
[EL Finest]: transaction: 2018-11-02 14:18:22.87--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--register_new_for_persist (There is no English translation for this message.)
[EL Finest]: sequencing: 2018-11-02 14:18:22.87--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--assign sequence to the object (641 -> company.customer.project.schema.masterdata.ProjectJoinPartnerBusiness@38c6f088)
[EL Finest]: transaction: 2018-11-02 14:18:22.87--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--register_new_for_persist (There is no English translation for this message.)
[EL Finest]: sequencing: 2018-11-02 14:18:22.871--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--assign sequence to the object (642 -> company.customer.project.schema.animal.ProjectAnimalMovement@22955ef2)
[EL Finer]: transaction: 2018-11-02 14:18:22.871--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--begin unit of work flush
[EL Finest]: query: 2018-11-02 14:18:22.872--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query DoesExistQuery(referenceClass=ProjectBusiness )
[EL Finest]: query: 2018-11-02 14:18:22.872--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query DoesExistQuery(referenceClass=ProjectSlaughterMask )
[EL Finest]: query: 2018-11-02 14:18:22.872--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query DoesExistQuery(referenceClass=ProjectJoinPartnerVvvoNumber )
[EL Finest]: query: 2018-11-02 14:18:22.872--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query UpdateObjectQuery(company.customer.project.schema.masterdata.ProjectPartner@487befb)
[EL Finest]: query: 2018-11-02 14:18:22.872--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query UpdateObjectQuery(company.customer.project.schema.masterdata.ProjectBusiness@1f6b9ab7)
[EL Finest]: query: 2018-11-02 14:18:22.872--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query InsertObjectQuery(company.customer.project.schema.animal.ProjectAnimalMovement@22955ef2)
2018-11-02 14:18:22.872 [main] TRACE d.s.j.c.LocalDateAttributeConverter#convertToDatabaseColumn[23] - Converted to DB: 2018-11-02 -> 2018-11-02
[EL Fine]: sql: 2018-11-02 14:18:22.872--ClientSession(1224339926)--Connection(266374831)--Thread(Thread[main,5,main])--INSERT INTO animal_movement (id, animal_lost, status, type, comment, date, delivery_note_nr, hit_report_timestamp, invoice_nr, piece_amount, tam_report_timestamp, total_value_ct, total_weight, cancelled_movement_id, clearing_house_id, business_id, animal_loss_type_id, delivery_note_doc_id, invoice_doc_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
	bind => [642, 6, CREATED, ANIMAL_SLAUGHTERED_SOLD, null, 2018-11-02, null, null, 900109, 44, null, null, 5886, null, 595, 607, 103, null, null]
[EL Finest]: query: 2018-11-02 14:18:22.873--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query UpdateObjectQuery(company.customer.project.schema.animal.ProjectSlaughterParty@320d98f5)
[EL Fine]: sql: 2018-11-02 14:18:22.873--ClientSession(1224339926)--Connection(266374831)--Thread(Thread[main,5,main])--UPDATE slaughter_party SET animal_movement_id = ? WHERE (id = ?)
	bind => [642, 640]
[EL Finest]: query: 2018-11-02 14:18:22.873--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query InsertObjectQuery(company.customer.project.schema.masterdata.ProjectJoinPartnerBusiness@38c6f088)
[EL Fine]: sql: 2018-11-02 14:18:22.875--ClientSession(1224339926)--Connection(266374831)--Thread(Thread[main,5,main])--INSERT INTO join_partner_business (id, comparison, from_date, to_date, a_id, b_id) VALUES (?, ?, ?, ?, ?, ?)
	bind => [641, true, 2018-08-02 12:18:22.87, null, 593, 607]
[EL Finer]: transaction: 2018-11-02 14:18:22.876--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--end unit of work flush
[EL Finer]: transaction: 2018-11-02 14:18:22.876--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--resume unit of work
[EL Finest]: query: 2018-11-02 14:18:22.876--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query ReadAllQuery(referenceClass=ProjectSlaughterMask sql="SELECT id, description, from_date, slaughter_house_mask, to_date, type, producer_group_id, slaughter_house_id FROM slaughter_mask WHERE (((slaughter_house_id = ?) AND (slaughter_house_mask = ?)) AND (to_date IS NULL))")
[EL Fine]: sql: 2018-11-02 14:18:22.876--ClientSession(1224339926)--Connection(266374831)--Thread(Thread[main,5,main])--SELECT id, description, from_date, slaughter_house_mask, to_date, type, producer_group_id, slaughter_house_id FROM slaughter_mask WHERE (((slaughter_house_id = ?) AND (slaughter_house_mask = ?)) AND (to_date IS NULL))
	bind => [635, 23]
[EL Finest]: transaction: 2018-11-02 14:18:22.876--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Register the existing object company.customer.project.schema.masterdata.ProjectPartner@207283b4
[EL Finest]: transaction: 2018-11-02 14:18:22.877--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--register_new_for_persist (There is no English translation for this message.)
[EL Finest]: sequencing: 2018-11-02 14:18:22.877--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--assign sequence to the object (643 -> company.customer.project.schema.animal.ProjectSlaughteredAnimal@3d62648d)
[EL Finer]: transaction: 2018-11-02 14:18:22.882--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--begin unit of work flush
[EL Finest]: query: 2018-11-02 14:18:22.882--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query DoesExistQuery(referenceClass=ProjectBusiness )
[EL Finest]: query: 2018-11-02 14:18:22.882--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query DoesExistQuery(referenceClass=ProjectSlaughterMask )
[EL Finest]: query: 2018-11-02 14:18:22.882--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query DoesExistQuery(referenceClass=ProjectJoinPartnerVvvoNumber )
[EL Finest]: query: 2018-11-02 14:18:22.882--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query UpdateObjectQuery(company.customer.project.schema.animal.ProjectSlaughterParty@320d98f5)
[EL Finest]: query: 2018-11-02 14:18:22.882--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query InsertObjectQuery(company.customer.project.schema.animal.ProjectSlaughteredAnimal@3d62648d)
[EL Fine]: sql: 2018-11-02 14:18:22.882--ClientSession(1224339926)--Connection(266374831)--Thread(Thread[main,5,main])--INSERT INTO slaughtered_animal (id, afom_bacon, afom_belly, afom_chop, afom_grade, afom_ham, afom_ham_pure, afom_index_original, afom_index_paid, afom_lmp, afom_lbelly, afom_loin_pure, afom_meat, afom_shoulder, afom_shoulder_pure, afom_type, base_price_ct, exploitation, fom_bacon, fom_grade, fom_lmp, fom_meat, gender, living_weight, slaughter_number, union_price_diff, value_ct, weight_original, weight_paid, slaughter_mask_id, slaughter_party_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
	bind => [643, 0.0, 15.0, 0.0,   , 0.0, 17.75, 0.0, 0.0, 0.0, 57.20000076293945, 6.789999961853027, 0.0, 0.0, 8.789999961853027, 3, 149, 0.8, 19.1, E , 55.400001525878906, 65.7, MALE, 11875.0, 583, 0.0, 0.0, 95.0, 95.0, 638, 640]
[EL Finer]: transaction: 2018-11-02 14:18:22.882--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--end unit of work flush
[EL Finer]: transaction: 2018-11-02 14:18:22.883--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--resume unit of work
[EL Finest]: query: 2018-11-02 14:18:22.883--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query ReportQuery(referenceClass=ProjectSlaughteredAnimal sql="SELECT COUNT(t0.id) FROM slaughtered_animal t0 WHERE ((t0.slaughter_party_id = ?) AND EXISTS (SELECT ? FROM join_animal_finding t3, slaughter_house_finding t2, animal_reclamation t1 WHERE (((t1.mark = ?) AND ((t3.animal_id = t0.id) AND (t2.id = t3.finding_id))) AND (t1.id = t2.reclamation_id))) )")
[EL Fine]: sql: 2018-11-02 14:18:22.883--ClientSession(1224339926)--Connection(266374831)--Thread(Thread[main,5,main])--SELECT COUNT(t0.id) FROM slaughtered_animal t0 WHERE ((t0.slaughter_party_id = 640) AND EXISTS (SELECT 1 FROM join_animal_finding t3, slaughter_house_finding t2, animal_reclamation t1 WHERE (((t1.mark = 'LIVER') AND ((t3.animal_id = t0.id) AND (t2.id = t3.finding_id))) AND (t1.id = t2.reclamation_id))) )
[EL Finer]: transaction: 2018-11-02 14:18:22.883--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--begin unit of work flush
[EL Finer]: transaction: 2018-11-02 14:18:22.884--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--end unit of work flush
[EL Finest]: query: 2018-11-02 14:18:22.884--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query ReportQuery(referenceClass=ProjectSlaughteredAnimal sql="SELECT COUNT(t0.id) FROM slaughtered_animal t0 WHERE ((t0.slaughter_party_id = ?) AND EXISTS (SELECT ? FROM join_animal_finding t3, slaughter_house_finding t2, animal_reclamation t1 WHERE (((t1.mark = ?) AND ((t3.animal_id = t0.id) AND (t2.id = t3.finding_id))) AND (t1.id = t2.reclamation_id))) )")
[EL Fine]: sql: 2018-11-02 14:18:22.884--ClientSession(1224339926)--Connection(266374831)--Thread(Thread[main,5,main])--SELECT COUNT(t0.id) FROM slaughtered_animal t0 WHERE ((t0.slaughter_party_id = 640) AND EXISTS (SELECT 1 FROM join_animal_finding t3, slaughter_house_finding t2, animal_reclamation t1 WHERE (((t1.mark = 'LUNG') AND ((t3.animal_id = t0.id) AND (t2.id = t3.finding_id))) AND (t1.id = t2.reclamation_id))) )
[EL Finer]: transaction: 2018-11-02 14:18:22.885--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--begin unit of work flush
[EL Finer]: transaction: 2018-11-02 14:18:22.886--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--end unit of work flush
[EL Finest]: query: 2018-11-02 14:18:22.886--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query ReportQuery(referenceClass=ProjectSlaughteredAnimal sql="SELECT SUM(union_price_diff) FROM slaughtered_animal WHERE (slaughter_party_id = ?)")
[EL Fine]: sql: 2018-11-02 14:18:22.886--ClientSession(1224339926)--Connection(266374831)--Thread(Thread[main,5,main])--SELECT SUM(union_price_diff) FROM slaughtered_animal WHERE (slaughter_party_id = ?)
	bind => [640]
2018-11-02 14:18:22.899 [main] DEBUG d.s.c.a.m.logic.animal.AnimalDao#autoAssignSlaughterParty[828] - No previous party information.
[EL Finer]: transaction: 2018-11-02 14:18:22.907--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--begin unit of work flush
[EL Finest]: query: 2018-11-02 14:18:22.908--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query DoesExistQuery(referenceClass=ProjectBusiness )
[EL Finest]: query: 2018-11-02 14:18:22.908--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query DoesExistQuery(referenceClass=ProjectSlaughterMask )
[EL Finest]: query: 2018-11-02 14:18:22.908--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query DoesExistQuery(referenceClass=ProjectJoinPartnerVvvoNumber )
[EL Finest]: query: 2018-11-02 14:18:22.908--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query UpdateObjectQuery(company.customer.project.schema.animal.ProjectSlaughterParty@320d98f5)
[EL Fine]: sql: 2018-11-02 14:18:22.908--ClientSession(1224339926)--Connection(266374831)--Thread(Thread[main,5,main])--UPDATE slaughter_party SET afom3_belly = ?, afom3_belly_amount = ?, afom3_belly_lmp = ?, afom3_belly_lamount = ?, afom3_belly_lweight = ?, afom3_pure_ham = ?, afom3_pure_ham_amount = ?, afom3_pure_shoulder = ?, afom3_pure_shoulder_amount = ?, fom_bacon = ?, fom_bacon_amount = ?, fom_lmp = ?, fom_lamount = ?, fom_lweight = ?, fom_meat = ?, fom_meat_amount = ? WHERE (id = ?)
	bind => [15.0, 1, 57.20000076293945, 1, 95.0, 17.75, 1, 8.789999961853027, 1, 19.100000381469727, 1, 55.400001525878906, 1, 95.0, 65.69999694824219, 1, 640]
[EL Finer]: transaction: 2018-11-02 14:18:22.908--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--end unit of work flush
[EL Finer]: transaction: 2018-11-02 14:18:22.908--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--resume unit of work
[EL Finest]: query: 2018-11-02 14:18:22.908--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query ReadAllQuery(referenceClass=ProjectRound sql="SELECT t0.id, t0.afom1_bacon, t0.afom1_bacon_amount, t0.afom1_belly, t0.afom1_belly_amount, t0.afom1_belly_lmp, t0.afom1_belly_lamount, t0.afom1_belly_lweight, t0.afom1_index, t0.afom1_index_amount, t0.afom1_lmp, t0.afom1_lamount, t0.afom1_lweight, t0.afom1_meat, t0.afom1_meat_amount, t0.afom1_pure_ham, t0.afom1_pure_ham_amount, t0.afom1_pure_shoulder, t0.afom1_pure_shoulder_amount, t0.afom3_bacon, t0.afom3_bacon_amount, t0.afom3_belly, t0.afom3_belly_amount, t0.afom3_belly_lmp, t0.afom3_belly_lamount, t0.afom3_belly_lweight, t0.afom3_index, t0.afom3_index_amount, t0.afom3_lmp, t0.afom3_lamount, t0.afom3_lweight, t0.afom3_meat, t0.afom3_meat_amount, t0.afom3_pure_ham, t0.afom3_pure_ham_amount, t0.afom3_pure_shoulder, t0.afom3_pure_shoulder_amount, t0.animal_current, t0.animal_days, t0.animal_delivery_date, t0.animal_in, t0.animal_loss, t0.animal_out, t0.animal_purchase_ct, t0.animal_sale_ct, t0.calculated_animal_value_ct, t0.calculated_animal_weight, t0.calculated_fodder_consumption, t0.calculated_fodder_costs_ct, t0.calculated_total_weight, t0.calculated_weight_growth, t0.calculation_date, t0.electricity_consumption, t0.electricity_costs_ct, t0.date_end, t0.epizootic_funds_ct, t0.fom_bacon, t0.fom_bacon_amount, t0.fom_lmp, t0.fom_lamount, t0.fom_lweight, t0.fom_meat, t0.fom_meat_amount, t0.fodder_purchase_ct, t0.fodder_weight, t0.gas_consumption, t0.gas_costs_ct, t0.heat_consumption, t0.heat_costs_ct, t0.insurance_costs_ct, t0.liver, t0.lung, t0.other_costs_ct, t0.number, t0.animals_slaughtered_delivered, t0.animals_slaughtered_payed, t0.animal_weight_slaughtered_original, t0.animal_weight_slaughtered_payed, t0.date_start, t0.status, t0.union_price_diff, t0.union_price_ref, t0.veterinary_costs_ct, t0.water_consumption, t0.water_costs_ct, t0.animal_weight_in, t0.animal_weight_loss, t0.animal_weight_out, t0.breeding_type_id, t0.fodder_producer_id, t0.stable_id FROM round t0 WHERE ((t0.stable_id IN (SELECT t1.id FROM stable t1 WHERE (EXISTS (SELECT DISTINCT ? FROM join_business_stable t2 WHERE ((t2.b_id = t1.id) AND ((t2.to_date IS NULL) AND (t2.a_id = ?))))  AND ((t1.slaughter_mark_suffix IS NULL) OR (t1.slaughter_mark_suffix = ?)))) AND (t0.status = ?)) AND (t0.animal_delivery_date < ?)) ORDER BY t0.date_start ASC")
2018-11-02 14:18:22.909 [main] TRACE d.s.j.c.LocalDateAttributeConverter#convertToDatabaseColumn[23] - Converted to DB: 2018-11-02 -> 2018-11-02
[EL Fine]: sql: 2018-11-02 14:18:22.909--ClientSession(1224339926)--Connection(266374831)--Thread(Thread[main,5,main])--SELECT t0.id, t0.afom1_bacon, t0.afom1_bacon_amount, t0.afom1_belly, t0.afom1_belly_amount, t0.afom1_belly_lmp, t0.afom1_belly_lamount, t0.afom1_belly_lweight, t0.afom1_index, t0.afom1_index_amount, t0.afom1_lmp, t0.afom1_lamount, t0.afom1_lweight, t0.afom1_meat, t0.afom1_meat_amount, t0.afom1_pure_ham, t0.afom1_pure_ham_amount, t0.afom1_pure_shoulder, t0.afom1_pure_shoulder_amount, t0.afom3_bacon, t0.afom3_bacon_amount, t0.afom3_belly, t0.afom3_belly_amount, t0.afom3_belly_lmp, t0.afom3_belly_lamount, t0.afom3_belly_lweight, t0.afom3_index, t0.afom3_index_amount, t0.afom3_lmp, t0.afom3_lamount, t0.afom3_lweight, t0.afom3_meat, t0.afom3_meat_amount, t0.afom3_pure_ham, t0.afom3_pure_ham_amount, t0.afom3_pure_shoulder, t0.afom3_pure_shoulder_amount, t0.animal_current, t0.animal_days, t0.animal_delivery_date, t0.animal_in, t0.animal_loss, t0.animal_out, t0.animal_purchase_ct, t0.animal_sale_ct, t0.calculated_animal_value_ct, t0.calculated_animal_weight, t0.calculated_fodder_consumption, t0.calculated_fodder_costs_ct, t0.calculated_total_weight, t0.calculated_weight_growth, t0.calculation_date, t0.electricity_consumption, t0.electricity_costs_ct, t0.date_end, t0.epizootic_funds_ct, t0.fom_bacon, t0.fom_bacon_amount, t0.fom_lmp, t0.fom_lamount, t0.fom_lweight, t0.fom_meat, t0.fom_meat_amount, t0.fodder_purchase_ct, t0.fodder_weight, t0.gas_consumption, t0.gas_costs_ct, t0.heat_consumption, t0.heat_costs_ct, t0.insurance_costs_ct, t0.liver, t0.lung, t0.other_costs_ct, t0.number, t0.animals_slaughtered_delivered, t0.animals_slaughtered_payed, t0.animal_weight_slaughtered_original, t0.animal_weight_slaughtered_payed, t0.date_start, t0.status, t0.union_price_diff, t0.union_price_ref, t0.veterinary_costs_ct, t0.water_consumption, t0.water_costs_ct, t0.animal_weight_in, t0.animal_weight_loss, t0.animal_weight_out, t0.breeding_type_id, t0.fodder_producer_id, t0.stable_id FROM round t0 WHERE ((t0.stable_id IN (SELECT t1.id FROM stable t1 WHERE (EXISTS (SELECT DISTINCT 1 FROM join_business_stable t2 WHERE ((t2.b_id = t1.id) AND ((t2.to_date IS NULL) AND (t2.a_id = 607))))  AND ((t1.slaughter_mark_suffix IS NULL) OR (t1.slaughter_mark_suffix = '')))) AND (t0.status = 'ACTIVE')) AND (t0.animal_delivery_date < {d '2018-11-02'})) ORDER BY t0.date_start ASC
[EL Finer]: transaction: 2018-11-02 14:18:22.912--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--begin unit of work flush
[EL Finer]: transaction: 2018-11-02 14:18:22.912--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--end unit of work flush
[EL Finest]: query: 2018-11-02 14:18:22.912--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query ReadAllQuery(referenceClass=ProjectQuarter sql="SELECT t0.id, t0.afom1_bacon, t0.afom1_bacon_amount, t0.afom1_belly, t0.afom1_belly_amount, t0.afom1_belly_lmp, t0.afom1_belly_lamount, t0.afom1_belly_lweight, t0.afom1_index, t0.afom1_index_amount, t0.afom1_lmp, t0.afom1_lamount, t0.afom1_lweight, t0.afom1_meat, t0.afom1_meat_amount, t0.afom1_pure_ham, t0.afom1_pure_ham_amount, t0.afom1_pure_shoulder, t0.afom1_pure_shoulder_amount, t0.afom3_bacon, t0.afom3_bacon_amount, t0.afom3_belly, t0.afom3_belly_amount, t0.afom3_belly_lmp, t0.afom3_belly_lamount, t0.afom3_belly_lweight, t0.afom3_index, t0.afom3_index_amount, t0.afom3_lmp, t0.afom3_lamount, t0.afom3_lweight, t0.afom3_meat, t0.afom3_meat_amount, t0.afom3_pure_ham, t0.afom3_pure_ham_amount, t0.afom3_pure_shoulder, t0.afom3_pure_shoulder_amount, t0.animal_current, t0.animal_days, t0.animal_in, t0.animal_loss, t0.animal_out, t0.animal_purchase_ct, t0.animal_sale_ct, t0.calculated_animal_value_ct, t0.calculated_animal_weight, t0.calculated_fodder_consumption, t0.calculated_fodder_costs_ct, t0.calculated_total_weight, t0.calculated_weight_growth, t0.calculation_date, t0.electricity_consumption, t0.electricity_costs_ct, t0.elusive, t0.date_end, t0.epizootic_funds_ct, t0.fom_bacon, t0.fom_bacon_amount, t0.fom_lmp, t0.fom_lamount, t0.fom_lweight, t0.fom_meat, t0.fom_meat_amount, t0.fodder_purchase_ct, t0.fodder_weight, t0.gas_consumption, t0.gas_costs_ct, t0.heat_consumption, t0.heat_costs_ct, t0.insurance_costs_ct, t0.liver, t0.lung, t0.other_costs_ct, t0.quarter, t0.animals_slaughtered_delivered, t0.animals_slaughtered_payed, t0.animal_weight_slaughtered_original, t0.animal_weight_slaughtered_payed, t0.date_start, t0.status, t0.union_price_diff, t0.union_price_ref, t0.unit, t0.veterinary_costs_ct, t0.water_consumption, t0.water_costs_ct, t0.animal_weight_in, t0.animal_weight_loss, t0.animal_weight_out, t0.year, t0.animal_inventory_id, t0.business_id, t0.farm_id, t0.fodder_producer_id, t0.stable_id FROM quarter t0 WHERE ((((t0.elusive = ?) AND (((t0.unit = ?) AND t0.stable_id IN (SELECT t1.id FROM stable t1 WHERE (EXISTS (SELECT DISTINCT ? FROM join_business_stable t2 WHERE ((t2.b_id = t1.id) AND ((t2.to_date IS NULL) AND (t2.a_id = ?))))  AND ((t1.slaughter_mark_suffix IS NULL) OR (t1.slaughter_mark_suffix = ?))))) OR ((t0.unit = ?) AND EXISTS (SELECT ? FROM business t3 WHERE ((t3.id = t0.business_id) AND ((? = t3.id) AND (t3.slaughter_mark = ?)))) ))) AND (t0.year = ?)) AND (t0.quarter = ?)) ORDER BY t0.date_start ASC")
[EL Fine]: sql: 2018-11-02 14:18:22.913--ClientSession(1224339926)--Connection(266374831)--Thread(Thread[main,5,main])--SELECT t0.id, t0.afom1_bacon, t0.afom1_bacon_amount, t0.afom1_belly, t0.afom1_belly_amount, t0.afom1_belly_lmp, t0.afom1_belly_lamount, t0.afom1_belly_lweight, t0.afom1_index, t0.afom1_index_amount, t0.afom1_lmp, t0.afom1_lamount, t0.afom1_lweight, t0.afom1_meat, t0.afom1_meat_amount, t0.afom1_pure_ham, t0.afom1_pure_ham_amount, t0.afom1_pure_shoulder, t0.afom1_pure_shoulder_amount, t0.afom3_bacon, t0.afom3_bacon_amount, t0.afom3_belly, t0.afom3_belly_amount, t0.afom3_belly_lmp, t0.afom3_belly_lamount, t0.afom3_belly_lweight, t0.afom3_index, t0.afom3_index_amount, t0.afom3_lmp, t0.afom3_lamount, t0.afom3_lweight, t0.afom3_meat, t0.afom3_meat_amount, t0.afom3_pure_ham, t0.afom3_pure_ham_amount, t0.afom3_pure_shoulder, t0.afom3_pure_shoulder_amount, t0.animal_current, t0.animal_days, t0.animal_in, t0.animal_loss, t0.animal_out, t0.animal_purchase_ct, t0.animal_sale_ct, t0.calculated_animal_value_ct, t0.calculated_animal_weight, t0.calculated_fodder_consumption, t0.calculated_fodder_costs_ct, t0.calculated_total_weight, t0.calculated_weight_growth, t0.calculation_date, t0.electricity_consumption, t0.electricity_costs_ct, t0.elusive, t0.date_end, t0.epizootic_funds_ct, t0.fom_bacon, t0.fom_bacon_amount, t0.fom_lmp, t0.fom_lamount, t0.fom_lweight, t0.fom_meat, t0.fom_meat_amount, t0.fodder_purchase_ct, t0.fodder_weight, t0.gas_consumption, t0.gas_costs_ct, t0.heat_consumption, t0.heat_costs_ct, t0.insurance_costs_ct, t0.liver, t0.lung, t0.other_costs_ct, t0.quarter, t0.animals_slaughtered_delivered, t0.animals_slaughtered_payed, t0.animal_weight_slaughtered_original, t0.animal_weight_slaughtered_payed, t0.date_start, t0.status, t0.union_price_diff, t0.union_price_ref, t0.unit, t0.veterinary_costs_ct, t0.water_consumption, t0.water_costs_ct, t0.animal_weight_in, t0.animal_weight_loss, t0.animal_weight_out, t0.year, t0.animal_inventory_id, t0.business_id, t0.farm_id, t0.fodder_producer_id, t0.stable_id FROM quarter t0 WHERE ((((t0.elusive = 0) AND (((t0.unit = 'STABLE') AND t0.stable_id IN (SELECT t1.id FROM stable t1 WHERE (EXISTS (SELECT DISTINCT 1 FROM join_business_stable t2 WHERE ((t2.b_id = t1.id) AND ((t2.to_date IS NULL) AND (t2.a_id = 607))))  AND ((t1.slaughter_mark_suffix IS NULL) OR (t1.slaughter_mark_suffix = ''))))) OR ((t0.unit = 'BUSINESS') AND EXISTS (SELECT 1 FROM business t3 WHERE ((t3.id = t0.business_id) AND ((607 = t3.id) AND (t3.slaughter_mark = 'BRA1234321')))) ))) AND (t0.year = 2018)) AND (t0.quarter = 'Q4')) ORDER BY t0.date_start ASC
[EL Finest]: transaction: 2018-11-02 14:18:22.919--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Register the existing object company.customer.project.schema.masterdata.ProjectBusiness@7d7be366
2018-11-02 14:18:22.919 [main] INFO  d.s.c.a.m.logic.animal.AnimalDao#autoAssignSlaughterParty[852] - Only one Evaluation unit possible. Using that one
[EL Finest]: transaction: 2018-11-02 14:18:22.919--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Merge clone with references company.customer.project.schema.evaluation.ProjectQuarter@79e686ab
[EL Finest]: transaction: 2018-11-02 14:18:22.919--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Register the existing object company.customer.project.schema.evaluation.ProjectJoinQuarterAnimalMovement@60e72ced
[EL Finest]: transaction: 2018-11-02 14:18:22.919--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Register the existing object company.customer.project.schema.animal.ProjectAnimalMovement@77dd0ac9
[EL Finest]: transaction: 2018-11-02 14:18:22.919--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Register the existing object company.customer.project.schema.masterdata.ProjectBusiness@7d7be366
[EL Finest]: transaction: 2018-11-02 14:18:22.919--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Register the existing object company.customer.project.schema.animal.ProjectAnimalDelivery@5eea8854
[EL Finest]: transaction: 2018-11-02 14:18:22.919--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Register the existing object company.customer.project.schema.masterdata.ProjectJoinPartnerVvvoNumber@18e69455
[EL Finest]: transaction: 2018-11-02 14:18:22.92--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Register the existing object company.customer.project.schema.masterdata.ProjectPartner@5111de33
[EL Finest]: transaction: 2018-11-02 14:18:22.92--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Register the existing object company.customer.project.schema.masterdata.ProjectVvvoNumber@775b3762
[EL Finest]: transaction: 2018-11-02 14:18:22.92--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Register the existing object company.customer.project.schema.masterdata.ProjectProducerGroup@2fdbd353
[EL Finest]: transaction: 2018-11-02 14:18:22.92--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Register the existing object company.customer.project.schema.masterdata.ProjectPartner@492b12e5
[EL Finest]: transaction: 2018-11-02 14:18:22.92--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Register the existing object company.customer.project.schema.masterdata.ProjectProducerGroup@2fdbd353
[EL Finest]: transaction: 2018-11-02 14:18:22.92--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Register the existing object company.customer.project.schema.animal.ProjectAnimalMovement@77dd0ac9
[EL Finest]: transaction: 2018-11-02 14:18:22.92--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Register the existing object company.customer.project.schema.evaluation.ProjectQuarter@6153b116
[EL Finest]: transaction: 2018-11-02 14:18:22.92--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Merge clone with references company.customer.project.schema.animal.ProjectAnimalMovement@22955ef2
[EL Finest]: transaction: 2018-11-02 14:18:22.92--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--register_new_for_persist (There is no English translation for this message.)
[EL Finest]: sequencing: 2018-11-02 14:18:22.92--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--assign sequence to the object (644 -> company.customer.project.schema.evaluation.ProjectJoinQuarterAnimalMovement@60a0e576)
[EL Finest]: transaction: 2018-11-02 14:18:22.92--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Merge clone with references company.customer.project.schema.evaluation.ProjectJoinQuarterAnimalMovement@60a0e576
2018-11-02 14:18:22.921 [main] DEBUG d.s.c.a.m.logic.animal.AnimalDao#lambda$getEvaluationUpdater$0[280] - Updating evaluation of type ProjectQuarter with join company.customer.project.schema.evaluation.ProjectJoinQuarterAnimalMovement@60a0e576
2018-11-02 14:18:22.921 [main] DEBUG d.s.c.a.m.logic.animal.AnimalDao#lambda$getEvaluationUpdater$0[281] - Evaluation company.customer.project.schema.evaluation.ProjectQuarter@79e686ab before: 50
2018-11-02 14:18:22.921 [main] INFO  d.s.c.a.m.logic.animal.AnimalDao#setJoinMovementValueInEvaluation[594] - Not updating the evaluation prices as none is known (yet).
[EL Finest]: transaction: 2018-11-02 14:18:22.921--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Merge clone with references company.customer.project.schema.evaluation.ProjectQuarter@79e686ab
2018-11-02 14:18:22.921 [main] DEBUG d.s.c.a.m.logic.animal.AnimalDao#propagateAnimalAmountChange[385] - Propagated animal amount changes to 0 following quarters
2018-11-02 14:18:22.921 [main] DEBUG d.s.c.a.m.logic.animal.AnimalDao#lambda$getEvaluationUpdater$0[287] - Evaluation company.customer.project.schema.evaluation.ProjectQuarter@79e686ab after: 0
[EL Finest]: transaction: 2018-11-02 14:18:22.922--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Merge clone with references company.customer.project.schema.evaluation.ProjectQuarter@79e686ab
[EL Finer]: connection: 2018-11-02 14:18:22.922--ServerSession(46351362)--Thread(Thread[DerivedData-1,5,main])--client acquired: 84650225
[EL Finer]: transaction: 2018-11-02 14:18:22.922--ClientSession(84650225)--Thread(Thread[DerivedData-1,5,main])--acquire unit of work: 620648658
[EL Finest]: query: 2018-11-02 14:18:22.922--UnitOfWork(620648658)--Thread(Thread[DerivedData-1,5,main])--Execute query ReadObjectQuery(name="readProjectJoinQuarterAnimalMovement" referenceClass=ProjectJoinQuarterAnimalMovement sql="SELECT id, amount_in, amount_out, animal_days, loss, status, animal_movement_id, quarter_id FROM join_quarter_animal_movement WHERE (id = ?)")
[EL Finer]: transaction: 2018-11-02 14:18:22.922--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--begin unit of work flush
[EL Finest]: connection: 2018-11-02 14:18:22.922--ServerSession(46351362)--Connection(480070753)--Thread(Thread[DerivedData-1,5,main])--Connection acquired from connection pool [read].
[EL Finest]: connection: 2018-11-02 14:18:22.922--ServerSession(46351362)--Thread(Thread[DerivedData-1,5,main])--reconnecting to external connection pool
[EL Finest]: query: 2018-11-02 14:18:22.922--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query UpdateObjectQuery(company.customer.project.schema.animal.ProjectAnimalMovement@22955ef2)
[EL Finest]: query: 2018-11-02 14:18:22.922--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query UpdateObjectQuery(company.customer.project.schema.evaluation.ProjectQuarter@79e686ab)
[EL Fine]: sql: 2018-11-02 14:18:22.922--ClientSession(1224339926)--Connection(266374831)--Thread(Thread[main,5,main])--UPDATE quarter SET afom3_belly = ?, afom3_belly_amount = ?, afom3_belly_lmp = ?, afom3_belly_lamount = ?, afom3_belly_lweight = ?, afom3_pure_ham = ?, afom3_pure_ham_amount = ?, afom3_pure_shoulder = ?, afom3_pure_shoulder_amount = ?, animal_current = ?, animal_days = ?, animal_loss = ?, fom_bacon = ?, fom_bacon_amount = ?, fom_lmp = ?, fom_lamount = ?, fom_lweight = ?, fom_meat = ?, fom_meat_amount = ?, animals_slaughtered_payed = ?, animal_weight_slaughtered_original = ?, animal_weight_slaughtered_payed = ?, animal_weight_loss = ? WHERE (id = ?)
	bind => [15.0, 1, 57.20000076293945, 1, 95.0, 17.75, 1, 8.789999961853027, 1, 0, 0, 6, 19.100000381469727, 1, 55.400001525878906, 1, 95.0, 65.69999694824219, 1, 44, 94.18000030517578, 94.18000030517578, 706, 611]
[EL Finest]: query: 2018-11-02 14:18:22.923--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query InsertObjectQuery(company.customer.project.schema.evaluation.ProjectJoinQuarterAnimalMovement@60a0e576)
[EL Fine]: sql: 2018-11-02 14:18:22.923--ClientSession(1224339926)--Connection(266374831)--Thread(Thread[main,5,main])--INSERT INTO join_quarter_animal_movement (id, amount_in, amount_out, animal_days, loss, status, animal_movement_id, quarter_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
	bind => [644, 0, 44, 1600, 6, CREATED, 642, 611]
[EL Finer]: transaction: 2018-11-02 14:18:22.923--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--end unit of work flush
[EL Finer]: transaction: 2018-11-02 14:18:22.923--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--resume unit of work
[EL Finest]: query: 2018-11-02 14:18:22.923--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query ReadAllQuery(referenceClass=ProjectSlaughterParty sql="SELECT id, afom1_bacon, afom1_bacon_amount, afom1_belly, afom1_belly_amount, afom1_belly_lmp, afom1_belly_lamount, afom1_belly_lweight, afom1_index, afom1_index_amount, afom1_lmp, afom1_lamount, afom1_lweight, afom1_meat, afom1_meat_amount, afom1_pure_ham, afom1_pure_ham_amount, afom1_pure_shoulder, afom1_pure_shoulder_amount, afom3_bacon, afom3_bacon_amount, afom3_belly, afom3_belly_amount, afom3_belly_lmp, afom3_belly_lamount, afom3_belly_lweight, afom3_index, afom3_index_amount, afom3_lmp, afom3_lamount, afom3_lweight, afom3_meat, afom3_meat_amount, afom3_pure_ham, afom3_pure_ham_amount, afom3_pure_shoulder, afom3_pure_shoulder_amount, base_price_ct, bonus_ct, delivery_date, exploitation, fom_bacon, fom_bacon_amount, fom_lmp, fom_lamount, fom_lweight, fom_meat, fom_meat_amount, liver, living_weight, lung, animals_rejected_amount, slaughter_date, slaughter_mark, animals_slaughtered_delivered, animals_slaughtered_payed, animal_weight_slaughtered_original, animal_weight_slaughtered_payed, animals_stable_lost, status, animals_transport_lost, union_price_diff, union_price_ref, value_ct, animals_veterinary_lost, business_id, slaughter_mask_id, old_entry_id, slaughter_house_id, animal_movement_id FROM slaughter_party WHERE ((((status = ?) AND (business_id = ?)) AND (delivery_date = ?)) AND (slaughter_mark = ?))")
2018-11-02 14:18:22.923 [main] TRACE d.s.j.c.LocalDateAttributeConverter#convertToDatabaseColumn[23] - Converted to DB: 2018-11-02 -> 2018-11-02
[EL Fine]: sql: 2018-11-02 14:18:22.924--ClientSession(1224339926)--Connection(266374831)--Thread(Thread[main,5,main])--SELECT id, afom1_bacon, afom1_bacon_amount, afom1_belly, afom1_belly_amount, afom1_belly_lmp, afom1_belly_lamount, afom1_belly_lweight, afom1_index, afom1_index_amount, afom1_lmp, afom1_lamount, afom1_lweight, afom1_meat, afom1_meat_amount, afom1_pure_ham, afom1_pure_ham_amount, afom1_pure_shoulder, afom1_pure_shoulder_amount, afom3_bacon, afom3_bacon_amount, afom3_belly, afom3_belly_amount, afom3_belly_lmp, afom3_belly_lamount, afom3_belly_lweight, afom3_index, afom3_index_amount, afom3_lmp, afom3_lamount, afom3_lweight, afom3_meat, afom3_meat_amount, afom3_pure_ham, afom3_pure_ham_amount, afom3_pure_shoulder, afom3_pure_shoulder_amount, base_price_ct, bonus_ct, delivery_date, exploitation, fom_bacon, fom_bacon_amount, fom_lmp, fom_lamount, fom_lweight, fom_meat, fom_meat_amount, liver, living_weight, lung, animals_rejected_amount, slaughter_date, slaughter_mark, animals_slaughtered_delivered, animals_slaughtered_payed, animal_weight_slaughtered_original, animal_weight_slaughtered_payed, animals_stable_lost, status, animals_transport_lost, union_price_diff, union_price_ref, value_ct, animals_veterinary_lost, business_id, slaughter_mask_id, old_entry_id, slaughter_house_id, animal_movement_id FROM slaughter_party WHERE ((((status = ?) AND (business_id = ?)) AND (delivery_date = ?)) AND (slaughter_mark = ?))
	bind => [CREATED, 607, 2018-11-02, BRA1234321]
2018-11-02 14:18:22.924 [main] INFO  d.s.c.a.m.l.d.s.PartyRecord#process[189] - Cancelling older version of the party first.
[EL Finer]: transaction: 2018-11-02 14:18:22.925--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--begin unit of work flush
[EL Finer]: transaction: 2018-11-02 14:18:22.925--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--end unit of work flush
[EL Finest]: query: 2018-11-02 14:18:22.925--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query DeleteAllQuery(referenceClass=ProjectSlaughteredAnimal sql="DELETE FROM slaughtered_animal WHERE (slaughter_party_id = ?)")
[EL Fine]: sql: 2018-11-02 14:18:22.926--ClientSession(1224339926)--Connection(266374831)--Thread(Thread[main,5,main])--DELETE FROM join_animal_finding WHERE EXISTS(SELECT id FROM slaughtered_animal WHERE (slaughter_party_id = ?) AND id = join_animal_finding.animal_id)
	bind => [640]
[EL Fine]: sql: 2018-11-02 14:18:22.926--ClientSession(1224339926)--Connection(266374831)--Thread(Thread[main,5,main])--DELETE FROM slaughtered_animal WHERE (slaughter_party_id = ?)
	bind => [640]
[EL Fine]: sql: 2018-11-02 14:18:22.923--ServerSession(46351362)--Connection(266374831)--Thread(Thread[DerivedData-1,5,main])--SELECT id, amount_in, amount_out, animal_days, loss, status, animal_movement_id, quarter_id FROM join_quarter_animal_movement WHERE (id = ?)
	bind => [644]
[EL Finest]: transaction: 2018-11-02 14:18:22.927--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Merge clone with references company.customer.project.schema.animal.ProjectAnimalMovement@22955ef2
[EL Finer]: transaction: 2018-11-02 14:18:22.929--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--begin unit of work flush
[EL Finest]: query: 2018-11-02 14:18:22.929--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query DoesExistQuery(referenceClass=ProjectBusiness )
[EL Fine]: sql: 2018-11-02 14:18:22.929--ClientSession(1224339926)--Connection(266374831)--Thread(Thread[main,5,main])--SELECT id FROM business WHERE (id = ?)
	bind => [607]
[EL Finest]: query: 2018-11-02 14:18:22.93--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query DoesExistQuery(referenceClass=ProjectSlaughterMask )
[EL Fine]: sql: 2018-11-02 14:18:22.93--ClientSession(1224339926)--Connection(266374831)--Thread(Thread[main,5,main])--SELECT id FROM slaughter_mask WHERE (id = ?)
	bind => [638]
[EL Finest]: query: 2018-11-02 14:18:22.931--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query DoesExistQuery(referenceClass=ProjectJoinPartnerVvvoNumber )
[EL Finest]: connection: 2018-11-02 14:18:22.93--ServerSession(46351362)--Connection(480070753)--Thread(Thread[DerivedData-1,5,main])--Connection released to connection pool [read].
[EL Fine]: sql: 2018-11-02 14:18:22.931--ClientSession(1224339926)--Connection(266374831)--Thread(Thread[main,5,main])--SELECT id FROM join_partner_vvvo_number WHERE (id = ?)
	bind => [637]
[EL Finest]: query: 2018-11-02 14:18:22.931--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query UpdateObjectQuery(company.customer.project.schema.animal.ProjectSlaughterParty@320d98f5)
[EL Fine]: sql: 2018-11-02 14:18:22.931--ClientSession(1224339926)--Connection(266374831)--Thread(Thread[main,5,main])--UPDATE slaughter_party SET status = ? WHERE (id = ?)
	bind => [CANCELLED, 640]
[EL Finer]: transaction: 2018-11-02 14:18:22.931--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--end unit of work flush
[EL Finer]: transaction: 2018-11-02 14:18:22.932--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--resume unit of work
[EL Finest]: query: 2018-11-02 14:18:22.932--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query ReportQuery(referenceClass=ProjectJoinQuarterAnimalMovement sql="SELECT ((SUM(amount_out) + SUM(loss)) * ?) FROM join_quarter_animal_movement WHERE ((quarter_id = ?) AND (animal_movement_id = ?))")
[EL Fine]: sql: 2018-11-02 14:18:22.932--ClientSession(1224339926)--Connection(266374831)--Thread(Thread[main,5,main])--SELECT ((SUM(amount_out) + SUM(loss)) * -1) FROM join_quarter_animal_movement WHERE ((quarter_id = 611) AND (animal_movement_id = 642))
[EL Finer]: transaction: 2018-11-02 14:18:22.932--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--begin unit of work flush
[EL Finer]: transaction: 2018-11-02 14:18:22.933--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--end unit of work flush
[EL Finer]: transaction: 2018-11-02 14:18:22.933--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--resume unit of work
[EL Finest]: query: 2018-11-02 14:18:22.933--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query ReadAllQuery(referenceClass=AbstractChoice sql="SELECT id, DTYPE, date_to, description FROM cho_choices WHERE ((description = ?) AND (DTYPE = ?))")
[EL Fine]: sql: 2018-11-02 14:18:22.933--ClientSession(1224339926)--Connection(266374831)--Thread(Thread[main,5,main])--SELECT id, DTYPE, date_to, description FROM cho_choices WHERE ((description = ?) AND (DTYPE = ?))
	bind => [Schlachtschwein geliefert, aber nicht bezahlt, animal_loss_type]
[EL Finest]: query: 2018-11-02 14:18:22.933--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query ReadObjectQuery(name="readProjectBusiness" referenceClass=ProjectBusiness sql="SELECT id, abstention_days, accounting_code, animal_welfare, auto_email_animal_disposal, auto_email_animal_disposal_max_days, business_assessment, default_exploitation, enable_hit_reporting, enable_tam_reporting, evaluation_strategy, fax_number, fodder_consumption_correction, from_date, name, own_fodder_producer, piglet_origin, quality_management, receive_delivery_note_push_info, receive_slaughter_push_info, release_animal_price, release_animal_welfare, release_fodder_price, release_slaughter_price, rest_area, slaughter_mark, to_date, total_area, weight_growth_correction, animal_disposal_partner_id, production_type_id, address_id, partner_self_id FROM business WHERE (id = ?)")
[EL Finer]: transaction: 2018-11-02 14:18:22.933--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--begin unit of work flush
[EL Finer]: transaction: 2018-11-02 14:18:22.933--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--end unit of work flush
[EL Finer]: transaction: 2018-11-02 14:18:22.933--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--resume unit of work
[EL Finest]: query: 2018-11-02 14:18:22.933--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query ReadAllQuery(referenceClass=ProjectJoinPartnerVvvoNumber sql="SELECT t0.id, t0.clearing_house, t0.from_date, t0.to_date, t0.type, t0.custom_type_id, t0.partner_id, t0.vvvo_number_id FROM join_partner_vvvo_number t0, vvvo_number t1 WHERE (((t0.to_date IS NULL) AND (t1.long_value = ?)) AND (t1.id = t0.vvvo_number_id))")
[EL Finest]: query: 2018-11-02 14:18:22.933--ServerSession(46351362)--Thread(Thread[DerivedData-1,5,main])--Execute query ReadObjectQuery(name="itsAnimalMovement" referenceClass=ProjectAnimalMovement )
[EL Fine]: sql: 2018-11-02 14:18:22.935--ClientSession(1224339926)--Connection(266374831)--Thread(Thread[main,5,main])--SELECT t0.id, t0.clearing_house, t0.from_date, t0.to_date, t0.type, t0.custom_type_id, t0.partner_id, t0.vvvo_number_id FROM join_partner_vvvo_number t0, vvvo_number t1 WHERE (((t0.to_date IS NULL) AND (t1.long_value = ?)) AND (t1.id = t0.vvvo_number_id))
	bind => [276112223334445]
[EL Finest]: connection: 2018-11-02 14:18:22.935--ServerSession(46351362)--Connection(1502226667)--Thread(Thread[DerivedData-1,5,main])--Connection acquired from connection pool [read].
[EL Finest]: connection: 2018-11-02 14:18:22.935--ServerSession(46351362)--Thread(Thread[DerivedData-1,5,main])--reconnecting to external connection pool
[EL Fine]: sql: 2018-11-02 14:18:22.935--ServerSession(46351362)--Connection(266374831)--Thread(Thread[DerivedData-1,5,main])--SELECT id, animal_lost, status, type, comment, date, delivery_note_nr, hit_report_timestamp, invoice_nr, piece_amount, tam_report_timestamp, total_value_ct, total_weight, cancelled_movement_id, clearing_house_id, business_id, animal_loss_type_id, delivery_note_doc_id, invoice_doc_id FROM animal_movement WHERE (id = ?)
	bind => [642]
[EL Finer]: transaction: 2018-11-02 14:18:22.936--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--begin unit of work flush
[EL Finer]: transaction: 2018-11-02 14:18:22.936--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--end unit of work flush
[EL Finer]: transaction: 2018-11-02 14:18:22.936--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--resume unit of work
[EL Finest]: query: 2018-11-02 14:18:22.936--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query ReportQuery(referenceClass=ProjectJoinPartnerBusiness sql="SELECT COUNT(id) FROM join_partner_business WHERE (((to_date IS NULL) AND (a_id = ?)) AND (b_id = ?))")
[EL Fine]: sql: 2018-11-02 14:18:22.936--ClientSession(1224339926)--Connection(266374831)--Thread(Thread[main,5,main])--SELECT COUNT(id) FROM join_partner_business WHERE (((to_date IS NULL) AND (a_id = ?)) AND (b_id = ?))
	bind => [593, 607]
2018-11-02 14:18:22.937 [main] INFO  d.s.c.a.m.l.m.MasterDataDao#addPartnerToBusiness[508] - Not adding partner#593 to business #607, as it is already present.
[EL Finest]: query: 2018-11-02 14:18:22.937--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query ReadObjectQuery(name="readProjectSlaughterParty" referenceClass=ProjectSlaughterParty sql="SELECT id, afom1_bacon, afom1_bacon_amount, afom1_belly, afom1_belly_amount, afom1_belly_lmp, afom1_belly_lamount, afom1_belly_lweight, afom1_index, afom1_index_amount, afom1_lmp, afom1_lamount, afom1_lweight, afom1_meat, afom1_meat_amount, afom1_pure_ham, afom1_pure_ham_amount, afom1_pure_shoulder, afom1_pure_shoulder_amount, afom3_bacon, afom3_bacon_amount, afom3_belly, afom3_belly_amount, afom3_belly_lmp, afom3_belly_lamount, afom3_belly_lweight, afom3_index, afom3_index_amount, afom3_lmp, afom3_lamount, afom3_lweight, afom3_meat, afom3_meat_amount, afom3_pure_ham, afom3_pure_ham_amount, afom3_pure_shoulder, afom3_pure_shoulder_amount, base_price_ct, bonus_ct, delivery_date, exploitation, fom_bacon, fom_bacon_amount, fom_lmp, fom_lamount, fom_lweight, fom_meat, fom_meat_amount, liver, living_weight, lung, animals_rejected_amount, slaughter_date, slaughter_mark, animals_slaughtered_delivered, animals_slaughtered_payed, animal_weight_slaughtered_original, animal_weight_slaughtered_payed, animals_stable_lost, status, animals_transport_lost, union_price_diff, union_price_ref, value_ct, animals_veterinary_lost, business_id, slaughter_mask_id, old_entry_id, slaughter_house_id, animal_movement_id FROM slaughter_party WHERE (id = ?)")
[EL Finest]: transaction: 2018-11-02 14:18:22.937--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--register_new_for_persist (There is no English translation for this message.)
[EL Finest]: connection: 2018-11-02 14:18:22.937--ServerSession(46351362)--Connection(1502226667)--Thread(Thread[DerivedData-1,5,main])--Connection released to connection pool [read].
[EL Finest]: sequencing: 2018-11-02 14:18:22.939--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--assign sequence to the object (645 -> company.customer.project.schema.animal.ProjectAnimalMovement@e31d9c2)
[EL Finest]: transaction: 2018-11-02 14:18:22.939--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--register_new_for_persist (There is no English translation for this message.)
[EL Finest]: sequencing: 2018-11-02 14:18:22.939--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--assign sequence to the object (646 -> company.customer.project.schema.evaluation.ProjectJoinQuarterAnimalMovement@10e5c13c)
[EL Finest]: transaction: 2018-11-02 14:18:22.94--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Merge clone with references company.customer.project.schema.evaluation.ProjectJoinQuarterAnimalMovement@10e5c13c
2018-11-02 14:18:22.940 [main] DEBUG d.s.c.a.m.logic.animal.AnimalDao#lambda$getEvaluationUpdater$0[280] - Updating evaluation of type ProjectQuarter with join company.customer.project.schema.evaluation.ProjectJoinQuarterAnimalMovement@10e5c13c
2018-11-02 14:18:22.940 [main] DEBUG d.s.c.a.m.logic.animal.AnimalDao#lambda$getEvaluationUpdater$0[281] - Evaluation company.customer.project.schema.evaluation.ProjectQuarter@79e686ab before: 0
2018-11-02 14:18:22.940 [main] INFO  d.s.c.a.m.logic.animal.AnimalDao#setJoinMovementValueInEvaluation[594] - Not updating the evaluation prices as none is known (yet).
[EL Finest]: transaction: 2018-11-02 14:18:22.94--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Merge clone with references company.customer.project.schema.evaluation.ProjectQuarter@79e686ab
2018-11-02 14:18:22.940 [main] DEBUG d.s.c.a.m.logic.animal.AnimalDao#initAnimalCurrent[351] - Looking for previous quarter to see if thare are animals left for this one.
[EL Finer]: transaction: 2018-11-02 14:18:22.94--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--begin unit of work flush
[EL Finest]: query: 2018-11-02 14:18:22.941--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query DoesExistQuery(referenceClass=ProjectBusiness )
[EL Fine]: sql: 2018-11-02 14:18:22.941--ClientSession(1224339926)--Connection(266374831)--Thread(Thread[main,5,main])--SELECT id FROM business WHERE (id = ?)
	bind => [607]
[EL Finest]: query: 2018-11-02 14:18:22.941--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query DoesExistQuery(referenceClass=ProjectSlaughterMask )
[EL Fine]: sql: 2018-11-02 14:18:22.941--ClientSession(1224339926)--Connection(266374831)--Thread(Thread[main,5,main])--SELECT id FROM slaughter_mask WHERE (id = ?)
	bind => [638]
[EL Finest]: query: 2018-11-02 14:18:22.941--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query DoesExistQuery(referenceClass=ProjectJoinPartnerVvvoNumber )
[EL Fine]: sql: 2018-11-02 14:18:22.941--ClientSession(1224339926)--Connection(266374831)--Thread(Thread[main,5,main])--SELECT id FROM join_partner_vvvo_number WHERE (id = ?)
	bind => [637]
[EL Finest]: query: 2018-11-02 14:18:22.941--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query UpdateObjectQuery(company.customer.project.schema.animal.ProjectAnimalMovement@22955ef2)
[EL Finest]: query: 2018-11-02 14:18:22.941--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query WriteObjectQuery(company.customer.project.schema.animal.ProjectAnimalMovement@e31d9c2)
2018-11-02 14:18:22.941 [main] TRACE d.s.j.c.LocalDateAttributeConverter#convertToDatabaseColumn[23] - Converted to DB: 2018-11-02 -> 2018-11-02
[EL Fine]: sql: 2018-11-02 14:18:22.942--ClientSession(1224339926)--Connection(266374831)--Thread(Thread[main,5,main])--INSERT INTO animal_movement (id, animal_lost, status, type, comment, date, delivery_note_nr, hit_report_timestamp, invoice_nr, piece_amount, tam_report_timestamp, total_value_ct, total_weight, cancelled_movement_id, clearing_house_id, business_id, animal_loss_type_id, delivery_note_doc_id, invoice_doc_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
	bind => [645, 6, CANCELLED, ANIMAL_SLAUGHTERED_SOLD, null, 2018-11-02, null, null, 900109, 44, null, null, 5886, null, 595, 607, 103, null, null]
[EL Fine]: sql: 2018-11-02 14:18:22.942--ClientSession(1224339926)--Connection(266374831)--Thread(Thread[main,5,main])--UPDATE animal_movement SET status = ?, cancelled_movement_id = ? WHERE (id = ?)
	bind => [CANCELLED, 645, 642]
2018-11-02 14:18:22.941 [DerivedData-1] TRACE d.s.j.c.LocalDateAttributeConverter#convertToEntityAttribute[30] - Converted to Entity: 2018-11-02 -> 2018-11-02
[EL Finest]: query: 2018-11-02 14:18:22.943--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query UpdateObjectQuery(company.customer.project.schema.animal.ProjectSlaughterParty@320d98f5)
[EL Finest]: query: 2018-11-02 14:18:22.943--ServerSession(46351362)--Thread(Thread[DerivedData-1,5,main])--Execute query ReadObjectQuery(name="itsClearingHouse" referenceClass=ProjectJoinPartnerVvvoNumber )
[EL Fine]: sql: 2018-11-02 14:18:22.943--ClientSession(1224339926)--Connection(266374831)--Thread(Thread[main,5,main])--UPDATE slaughter_party SET animal_movement_id = ? WHERE (id = ?)
	bind => [645, 640]
[EL Finest]: query: 2018-11-02 14:18:22.943--ServerSession(46351362)--Thread(Thread[DerivedData-1,5,main])--Execute query ReadObjectQuery(name="itsFattener" referenceClass=ProjectBusiness )
[EL Finest]: query: 2018-11-02 14:18:22.943--ServerSession(46351362)--Thread(Thread[DerivedData-1,5,main])--Execute query ReadObjectQuery(name="itsLossType" referenceClass=ProjectAnimalLossType )
[EL Finest]: query: 2018-11-02 14:18:22.943--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query UpdateObjectQuery(company.customer.project.schema.evaluation.ProjectQuarter@79e686ab)
[EL Fine]: sql: 2018-11-02 14:18:22.943--ClientSession(1224339926)--Connection(266374831)--Thread(Thread[main,5,main])--UPDATE quarter SET afom3_belly = ?, afom3_belly_amount = ?, afom3_belly_lmp = ?, afom3_belly_lamount = ?, afom3_belly_lweight = ?, afom3_pure_ham = ?, afom3_pure_ham_amount = ?, afom3_pure_shoulder = ?, afom3_pure_shoulder_amount = ?, fom_bacon = ?, fom_bacon_amount = ?, fom_lmp = ?, fom_lamount = ?, fom_lweight = ?, fom_meat = ?, fom_meat_amount = ?, liver = ?, lung = ?, animals_slaughtered_payed = ?, animal_weight_slaughtered_original = ?, animal_weight_slaughtered_payed = ?, union_price_ref = ? WHERE (id = ?)
	bind => [0.0, 0, 0.0, 0, 0.0, 0.0, 0, 0.0, 0, 0.0, 0, 0.0, 0, 0.0, 0.0, 0, NaN, NaN, 0, NaN, NaN, NaN, 611]
[EL Finest]: query: 2018-11-02 14:18:22.943--ServerSession(46351362)--Thread(Thread[DerivedData-1,5,main])--Execute query ReadObjectQuery(name="itsAnimalDelivery" referenceClass=ProjectAnimalDelivery sql="SELECT id, boar_genetic_id, delivery_partner_id, origin_country_id, producer_group_id, sow_genetic_id, user_id, animal_movement_id FROM animal_delivery WHERE (animal_movement_id = ?)")
[EL Finest]: query: 2018-11-02 14:18:22.943--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query InsertObjectQuery(company.customer.project.schema.evaluation.ProjectJoinQuarterAnimalMovement@10e5c13c)
[EL Finest]: connection: 2018-11-02 14:18:22.943--ServerSession(46351362)--Connection(830560622)--Thread(Thread[DerivedData-1,5,main])--Connection acquired from connection pool [read].
[EL Finest]: connection: 2018-11-02 14:18:22.943--ServerSession(46351362)--Thread(Thread[DerivedData-1,5,main])--reconnecting to external connection pool
[EL Fine]: sql: 2018-11-02 14:18:22.943--ClientSession(1224339926)--Connection(266374831)--Thread(Thread[main,5,main])--INSERT INTO join_quarter_animal_movement (id, amount_in, amount_out, animal_days, loss, status, animal_movement_id, quarter_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
	bind => [646, 0, 44, 1600, 6, CANCELLED, 645, 611]
[EL Fine]: sql: 2018-11-02 14:18:22.943--ServerSession(46351362)--Connection(266374831)--Thread(Thread[DerivedData-1,5,main])--SELECT id, boar_genetic_id, delivery_partner_id, origin_country_id, producer_group_id, sow_genetic_id, user_id, animal_movement_id FROM animal_delivery WHERE (animal_movement_id = ?)
	bind => [642]
[EL Finest]: connection: 2018-11-02 14:18:22.943--ServerSession(46351362)--Connection(830560622)--Thread(Thread[DerivedData-1,5,main])--Connection released to connection pool [read].
[EL Finer]: transaction: 2018-11-02 14:18:22.944--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--end unit of work flush
[EL Finest]: query: 2018-11-02 14:18:22.944--ServerSession(46351362)--Thread(Thread[DerivedData-1,5,main])--Execute query ReadObjectQuery(name="itsSlaughterParty" referenceClass=ProjectSlaughterParty sql="SELECT id, afom1_bacon, afom1_bacon_amount, afom1_belly, afom1_belly_amount, afom1_belly_lmp, afom1_belly_lamount, afom1_belly_lweight, afom1_index, afom1_index_amount, afom1_lmp, afom1_lamount, afom1_lweight, afom1_meat, afom1_meat_amount, afom1_pure_ham, afom1_pure_ham_amount, afom1_pure_shoulder, afom1_pure_shoulder_amount, afom3_bacon, afom3_bacon_amount, afom3_belly, afom3_belly_amount, afom3_belly_lmp, afom3_belly_lamount, afom3_belly_lweight, afom3_index, afom3_index_amount, afom3_lmp, afom3_lamount, afom3_lweight, afom3_meat, afom3_meat_amount, afom3_pure_ham, afom3_pure_ham_amount, afom3_pure_shoulder, afom3_pure_shoulder_amount, base_price_ct, bonus_ct, delivery_date, exploitation, fom_bacon, fom_bacon_amount, fom_lmp, fom_lamount, fom_lweight, fom_meat, fom_meat_amount, liver, living_weight, lung, animals_rejected_amount, slaughter_date, slaughter_mark, animals_slaughtered_delivered, animals_slaughtered_payed, animal_weight_slaughtered_original, animal_weight_slaughtered_payed, animals_stable_lost, status, animals_transport_lost, union_price_diff, union_price_ref, value_ct, animals_veterinary_lost, business_id, slaughter_mask_id, old_entry_id, slaughter_house_id, animal_movement_id FROM slaughter_party WHERE (animal_movement_id = ?)")
[EL Finest]: connection: 2018-11-02 14:18:22.944--ServerSession(46351362)--Connection(1781110296)--Thread(Thread[DerivedData-1,5,main])--Connection acquired from connection pool [read].
[EL Finest]: connection: 2018-11-02 14:18:22.944--ServerSession(46351362)--Thread(Thread[DerivedData-1,5,main])--reconnecting to external connection pool
[EL Fine]: sql: 2018-11-02 14:18:22.944--ServerSession(46351362)--Connection(266374831)--Thread(Thread[DerivedData-1,5,main])--SELECT id, afom1_bacon, afom1_bacon_amount, afom1_belly, afom1_belly_amount, afom1_belly_lmp, afom1_belly_lamount, afom1_belly_lweight, afom1_index, afom1_index_amount, afom1_lmp, afom1_lamount, afom1_lweight, afom1_meat, afom1_meat_amount, afom1_pure_ham, afom1_pure_ham_amount, afom1_pure_shoulder, afom1_pure_shoulder_amount, afom3_bacon, afom3_bacon_amount, afom3_belly, afom3_belly_amount, afom3_belly_lmp, afom3_belly_lamount, afom3_belly_lweight, afom3_index, afom3_index_amount, afom3_lmp, afom3_lamount, afom3_lweight, afom3_meat, afom3_meat_amount, afom3_pure_ham, afom3_pure_ham_amount, afom3_pure_shoulder, afom3_pure_shoulder_amount, base_price_ct, bonus_ct, delivery_date, exploitation, fom_bacon, fom_bacon_amount, fom_lmp, fom_lamount, fom_lweight, fom_meat, fom_meat_amount, liver, living_weight, lung, animals_rejected_amount, slaughter_date, slaughter_mark, animals_slaughtered_delivered, animals_slaughtered_payed, animal_weight_slaughtered_original, animal_weight_slaughtered_payed, animals_stable_lost, status, animals_transport_lost, union_price_diff, union_price_ref, value_ct, animals_veterinary_lost, business_id, slaughter_mask_id, old_entry_id, slaughter_house_id, animal_movement_id FROM slaughter_party WHERE (animal_movement_id = ?)
	bind => [642]
[EL Finest]: connection: 2018-11-02 14:18:22.945--ServerSession(46351362)--Connection(1781110296)--Thread(Thread[DerivedData-1,5,main])--Connection released to connection pool [read].
[EL Finer]: transaction: 2018-11-02 14:18:22.945--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--resume unit of work
[EL Finest]: query: 2018-11-02 14:18:22.945--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query ReadAllQuery(referenceClass=ProjectQuarter sql="SELECT id, afom1_bacon, afom1_bacon_amount, afom1_belly, afom1_belly_amount, afom1_belly_lmp, afom1_belly_lamount, afom1_belly_lweight, afom1_index, afom1_index_amount, afom1_lmp, afom1_lamount, afom1_lweight, afom1_meat, afom1_meat_amount, afom1_pure_ham, afom1_pure_ham_amount, afom1_pure_shoulder, afom1_pure_shoulder_amount, afom3_bacon, afom3_bacon_amount, afom3_belly, afom3_belly_amount, afom3_belly_lmp, afom3_belly_lamount, afom3_belly_lweight, afom3_index, afom3_index_amount, afom3_lmp, afom3_lamount, afom3_lweight, afom3_meat, afom3_meat_amount, afom3_pure_ham, afom3_pure_ham_amount, afom3_pure_shoulder, afom3_pure_shoulder_amount, animal_current, animal_days, animal_in, animal_loss, animal_out, animal_purchase_ct, animal_sale_ct, calculated_animal_value_ct, calculated_animal_weight, calculated_fodder_consumption, calculated_fodder_costs_ct, calculated_total_weight, calculated_weight_growth, calculation_date, electricity_consumption, electricity_costs_ct, elusive, date_end, epizootic_funds_ct, fom_bacon, fom_bacon_amount, fom_lmp, fom_lamount, fom_lweight, fom_meat, fom_meat_amount, fodder_purchase_ct, fodder_weight, gas_consumption, gas_costs_ct, heat_consumption, heat_costs_ct, insurance_costs_ct, liver, lung, other_costs_ct, quarter, animals_slaughtered_delivered, animals_slaughtered_payed, animal_weight_slaughtered_original, animal_weight_slaughtered_payed, date_start, status, union_price_diff, union_price_ref, unit, veterinary_costs_ct, water_consumption, water_costs_ct, animal_weight_in, animal_weight_loss, animal_weight_out, year, animal_inventory_id, business_id, farm_id, fodder_producer_id, stable_id FROM quarter WHERE (((((elusive = ?) AND (unit = ?)) AND (year = ?)) AND (quarter = ?)) AND (business_id = ?))")
[EL Finest]: query: 2018-11-02 14:18:22.945--ServerSession(46351362)--Thread(Thread[DerivedData-1,5,main])--Execute query ReadObjectQuery(name="itsQuarter" referenceClass=ProjectQuarter )
[EL Fine]: sql: 2018-11-02 14:18:22.945--ClientSession(1224339926)--Connection(266374831)--Thread(Thread[main,5,main])--SELECT id, afom1_bacon, afom1_bacon_amount, afom1_belly, afom1_belly_amount, afom1_belly_lmp, afom1_belly_lamount, afom1_belly_lweight, afom1_index, afom1_index_amount, afom1_lmp, afom1_lamount, afom1_lweight, afom1_meat, afom1_meat_amount, afom1_pure_ham, afom1_pure_ham_amount, afom1_pure_shoulder, afom1_pure_shoulder_amount, afom3_bacon, afom3_bacon_amount, afom3_belly, afom3_belly_amount, afom3_belly_lmp, afom3_belly_lamount, afom3_belly_lweight, afom3_index, afom3_index_amount, afom3_lmp, afom3_lamount, afom3_lweight, afom3_meat, afom3_meat_amount, afom3_pure_ham, afom3_pure_ham_amount, afom3_pure_shoulder, afom3_pure_shoulder_amount, animal_current, animal_days, animal_in, animal_loss, animal_out, animal_purchase_ct, animal_sale_ct, calculated_animal_value_ct, calculated_animal_weight, calculated_fodder_consumption, calculated_fodder_costs_ct, calculated_total_weight, calculated_weight_growth, calculation_date, electricity_consumption, electricity_costs_ct, elusive, date_end, epizootic_funds_ct, fom_bacon, fom_bacon_amount, fom_lmp, fom_lamount, fom_lweight, fom_meat, fom_meat_amount, fodder_purchase_ct, fodder_weight, gas_consumption, gas_costs_ct, heat_consumption, heat_costs_ct, insurance_costs_ct, liver, lung, other_costs_ct, quarter, animals_slaughtered_delivered, animals_slaughtered_payed, animal_weight_slaughtered_original, animal_weight_slaughtered_payed, date_start, status, union_price_diff, union_price_ref, unit, veterinary_costs_ct, water_consumption, water_costs_ct, animal_weight_in, animal_weight_loss, animal_weight_out, year, animal_inventory_id, business_id, farm_id, fodder_producer_id, stable_id FROM quarter WHERE (((((elusive = ?) AND (unit = ?)) AND (year = ?)) AND (quarter = ?)) AND (business_id = ?))
	bind => [false, BUSINESS, 2018, Q3, 607]
[EL Finest]: transaction: 2018-11-02 14:18:22.946--UnitOfWork(620648658)--Thread(Thread[DerivedData-1,5,main])--Register the existing object company.customer.project.schema.animal.ProjectAnimalMovement@5a730772
[EL Finest]: transaction: 2018-11-02 14:18:22.946--UnitOfWork(620648658)--Thread(Thread[DerivedData-1,5,main])--Register the existing object company.customer.project.schema.masterdata.ProjectJoinPartnerVvvoNumber@3fd7be2d
[EL Finest]: transaction: 2018-11-02 14:18:22.946--UnitOfWork(620648658)--Thread(Thread[DerivedData-1,5,main])--Register the existing object company.customer.project.schema.masterdata.ProjectPartner@4a09f5b
[EL Finest]: transaction: 2018-11-02 14:18:22.946--UnitOfWork(620648658)--Thread(Thread[DerivedData-1,5,main])--Register the existing object company.customer.project.schema.masterdata.ProjectVvvoNumber@1290fc6a
[EL Finest]: transaction: 2018-11-02 14:18:22.946--UnitOfWork(620648658)--Thread(Thread[DerivedData-1,5,main])--Register the existing object company.customer.project.schema.masterdata.ProjectBusiness@7d7be366
2018-11-02 14:18:22.946 [main] TRACE d.s.j.c.LocalDateAttributeConverter#convertToEntityAttribute[30] - Converted to Entity: 2018-10-01 -> 2018-10-01
[EL Finest]: transaction: 2018-11-02 14:18:22.946--UnitOfWork(620648658)--Thread(Thread[DerivedData-1,5,main])--Register the existing object company.customer.project.schema.masterdata.ProjectProductionType@5626cb89
[EL Finest]: transaction: 2018-11-02 14:18:22.946--UnitOfWork(620648658)--Thread(Thread[DerivedData-1,5,main])--Register the existing object company.customer.project.schema.masterdata.ProjectAddress@2095e085
[EL Finest]: transaction: 2018-11-02 14:18:22.946--UnitOfWork(620648658)--Thread(Thread[DerivedData-1,5,main])--Register the existing object company.customer.project.schema.masterdata.ProjectPartner@23243385
[EL Finest]: transaction: 2018-11-02 14:18:22.946--UnitOfWork(620648658)--Thread(Thread[DerivedData-1,5,main])--Register the existing object company.customer.project.schema.masterdata.ProjectBusiness@7d7be366
2018-11-02 14:18:22.946 [main] TRACE d.s.j.c.LocalDateAttributeConverter#convertToEntityAttribute[30] - Converted to Entity: 2018-07-01 -> 2018-07-01
[EL Finest]: transaction: 2018-11-02 14:18:22.949--UnitOfWork(620648658)--Thread(Thread[DerivedData-1,5,main])--Register the existing object company.customer.project.schema.masterdata.ProjectAnimalLossType@3e63e820
[EL Finest]: query: 2018-11-02 14:18:22.949--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query ReadObjectQuery(name="itsBusiness" referenceClass=ProjectBusiness )
[EL Finest]: transaction: 2018-11-02 14:18:22.949--UnitOfWork(620648658)--Thread(Thread[DerivedData-1,5,main])--Register the existing object company.customer.project.schema.evaluation.ProjectQuarter@6153b116
[EL Finest]: transaction: 2018-11-02 14:18:22.949--UnitOfWork(620648658)--Thread(Thread[DerivedData-1,5,main])--Register the existing object company.customer.project.schema.masterdata.ProjectBusiness@7d7be366
2018-11-02 14:18:22.949 [DerivedData-1] INFO  d.s.c.a.m.l.e.d.DerivedDataDao#joinQuarterAnimalMovement[113] - Updating DerivedData for joinMovement 644
[EL Finer]: transaction: 2018-11-02 14:18:22.949--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--begin unit of work flush
[EL Finest]: transaction: 2018-11-02 14:18:22.949--UnitOfWork(620648658)--Thread(Thread[DerivedData-1,5,main])--Register the existing object company.customer.project.schema.masterdata.ProjectJoinFarmBusiness@580a610a
[EL Finest]: transaction: 2018-11-02 14:18:22.949--UnitOfWork(620648658)--Thread(Thread[DerivedData-1,5,main])--Register the existing object company.customer.project.schema.masterdata.ProjectFarm@19e86461
[EL Finest]: transaction: 2018-11-02 14:18:22.949--UnitOfWork(620648658)--Thread(Thread[DerivedData-1,5,main])--Register the existing object company.customer.project.schema.masterdata.ProjectAddress@31475919
[EL Finest]: transaction: 2018-11-02 14:18:22.949--UnitOfWork(620648658)--Thread(Thread[DerivedData-1,5,main])--Register the existing object company.customer.project.schema.masterdata.ProjectBusiness@7d7be366
[EL Finest]: query: 2018-11-02 14:18:22.95--UnitOfWork(620648658)--Thread(Thread[DerivedData-1,5,main])--Execute query ReadObjectQuery(name="readProjectFarm" referenceClass=ProjectFarm sql="SELECT id, email, fax_number, from_date, name, phone_number, to_date, address_id FROM farm WHERE (id = ?)")
[EL Finer]: transaction: 2018-11-02 14:18:22.95--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--end unit of work flush
[EL Finer]: transaction: 2018-11-02 14:18:22.95--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--resume unit of work
[EL Finest]: query: 2018-11-02 14:18:22.95--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query ReadAllQuery(referenceClass=ProjectQuarter sql="SELECT id, afom1_bacon, afom1_bacon_amount, afom1_belly, afom1_belly_amount, afom1_belly_lmp, afom1_belly_lamount, afom1_belly_lweight, afom1_index, afom1_index_amount, afom1_lmp, afom1_lamount, afom1_lweight, afom1_meat, afom1_meat_amount, afom1_pure_ham, afom1_pure_ham_amount, afom1_pure_shoulder, afom1_pure_shoulder_amount, afom3_bacon, afom3_bacon_amount, afom3_belly, afom3_belly_amount, afom3_belly_lmp, afom3_belly_lamount, afom3_belly_lweight, afom3_index, afom3_index_amount, afom3_lmp, afom3_lamount, afom3_lweight, afom3_meat, afom3_meat_amount, afom3_pure_ham, afom3_pure_ham_amount, afom3_pure_shoulder, afom3_pure_shoulder_amount, animal_current, animal_days, animal_in, animal_loss, animal_out, animal_purchase_ct, animal_sale_ct, calculated_animal_value_ct, calculated_animal_weight, calculated_fodder_consumption, calculated_fodder_costs_ct, calculated_total_weight, calculated_weight_growth, calculation_date, electricity_consumption, electricity_costs_ct, elusive, date_end, epizootic_funds_ct, fom_bacon, fom_bacon_amount, fom_lmp, fom_lamount, fom_lweight, fom_meat, fom_meat_amount, fodder_purchase_ct, fodder_weight, gas_consumption, gas_costs_ct, heat_consumption, heat_costs_ct, insurance_costs_ct, liver, lung, other_costs_ct, quarter, animals_slaughtered_delivered, animals_slaughtered_payed, animal_weight_slaughtered_original, animal_weight_slaughtered_payed, date_start, status, union_price_diff, union_price_ref, unit, veterinary_costs_ct, water_consumption, water_costs_ct, animal_weight_in, animal_weight_loss, animal_weight_out, year, animal_inventory_id, business_id, farm_id, fodder_producer_id, stable_id FROM quarter WHERE (((((elusive = ?) AND (unit = ?)) AND (year = ?)) AND (quarter = ?)) AND (business_id = ?))")
2018-11-02 14:18:22.950 [DerivedData-1] DEBUG d.s.c.a.m.l.e.d.DerivedDataDao#updateQuarters[227] - Updating farm 600, year 2018
[EL Fine]: sql: 2018-11-02 14:18:22.95--ClientSession(1224339926)--Connection(266374831)--Thread(Thread[main,5,main])--SELECT id, afom1_bacon, afom1_bacon_amount, afom1_belly, afom1_belly_amount, afom1_belly_lmp, afom1_belly_lamount, afom1_belly_lweight, afom1_index, afom1_index_amount, afom1_lmp, afom1_lamount, afom1_lweight, afom1_meat, afom1_meat_amount, afom1_pure_ham, afom1_pure_ham_amount, afom1_pure_shoulder, afom1_pure_shoulder_amount, afom3_bacon, afom3_bacon_amount, afom3_belly, afom3_belly_amount, afom3_belly_lmp, afom3_belly_lamount, afom3_belly_lweight, afom3_index, afom3_index_amount, afom3_lmp, afom3_lamount, afom3_lweight, afom3_meat, afom3_meat_amount, afom3_pure_ham, afom3_pure_ham_amount, afom3_pure_shoulder, afom3_pure_shoulder_amount, animal_current, animal_days, animal_in, animal_loss, animal_out, animal_purchase_ct, animal_sale_ct, calculated_animal_value_ct, calculated_animal_weight, calculated_fodder_consumption, calculated_fodder_costs_ct, calculated_total_weight, calculated_weight_growth, calculation_date, electricity_consumption, electricity_costs_ct, elusive, date_end, epizootic_funds_ct, fom_bacon, fom_bacon_amount, fom_lmp, fom_lamount, fom_lweight, fom_meat, fom_meat_amount, fodder_purchase_ct, fodder_weight, gas_consumption, gas_costs_ct, heat_consumption, heat_costs_ct, insurance_costs_ct, liver, lung, other_costs_ct, quarter, animals_slaughtered_delivered, animals_slaughtered_payed, animal_weight_slaughtered_original, animal_weight_slaughtered_payed, date_start, status, union_price_diff, union_price_ref, unit, veterinary_costs_ct, water_consumption, water_costs_ct, animal_weight_in, animal_weight_loss, animal_weight_out, year, animal_inventory_id, business_id, farm_id, fodder_producer_id, stable_id FROM quarter WHERE (((((elusive = ?) AND (unit = ?)) AND (year = ?)) AND (quarter = ?)) AND (business_id = ?))
	bind => [false, BUSINESS, 2018, Q2, 607]
[EL Finer]: connection: 2018-11-02 14:18:22.95--ServerSession(46351362)--Thread(Thread[DerivedData-1,5,main])--client acquired: 1833149163
[EL Finer]: transaction: 2018-11-02 14:18:22.95--ClientSession(1833149163)--Thread(Thread[DerivedData-1,5,main])--acquire unit of work: 1876960571
[EL Finer]: transaction: 2018-11-02 14:18:22.95--UnitOfWork(1876960571)--Thread(Thread[DerivedData-1,5,main])--begin unit of work flush
[EL Finer]: transaction: 2018-11-02 14:18:22.95--UnitOfWork(1876960571)--Thread(Thread[DerivedData-1,5,main])--end unit of work flush
2018-11-02 14:18:22.950 [main] TRACE d.s.j.c.LocalDateAttributeConverter#convertToEntityAttribute[30] - Converted to Entity: 2018-07-01 -> 2018-07-01
2018-11-02 14:18:22.950 [main] TRACE d.s.j.c.LocalDateAttributeConverter#convertToEntityAttribute[30] - Converted to Entity: 2018-04-01 -> 2018-04-01
[EL Finest]: query: 2018-11-02 14:18:22.951--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query ReadObjectQuery(name="itsBusiness" referenceClass=ProjectBusiness )
[EL Finest]: query: 2018-11-02 14:18:22.951--UnitOfWork(1876960571)--Thread(Thread[DerivedData-1,5,main])--Execute query ReadAllQuery(referenceClass=ProjectDerivedQuarter sql="SELECT id, afom1_bacon, afom1_bacon_amount, afom1_belly, afom1_belly_amount, afom1_belly_lmp, afom1_belly_lamount, afom1_belly_lweight, afom1_index, afom1_index_amount, afom1_lmp, afom1_lamount, afom1_lweight, afom1_meat, afom1_meat_amount, afom1_pure_ham, afom1_pure_ham_amount, afom1_pure_shoulder, afom1_pure_shoulder_amount, afom3_bacon, afom3_bacon_amount, afom3_belly, afom3_belly_amount, afom3_belly_lmp, afom3_belly_lamount, afom3_belly_lweight, afom3_index, afom3_index_amount, afom3_lmp, afom3_lamount, afom3_lweight, afom3_meat, afom3_meat_amount, afom3_pure_ham, afom3_pure_ham_amount, afom3_pure_shoulder, afom3_pure_shoulder_amount, animal_current, animal_days, animal_in, animal_loss, animal_out, animal_purchase_ct, animal_sale_ct, calculated_animal_value_ct, calculated_animal_weight, calculated_fodder_consumption, calculated_fodder_costs_ct, calculated_total_weight, calculated_weight_growth, calculation_date, electricity_consumption, electricity_costs_ct, epizootic_funds_ct, fom_bacon, fom_bacon_amount, fom_lmp, fom_lamount, fom_lweight, fom_meat, fom_meat_amount, fodder_purchase_ct, fodder_weight, gas_consumption, gas_costs_ct, heat_consumption, heat_costs_ct, insurance_costs_ct, liver, lung, other_costs_ct, quarter, animals_slaughtered_delivered, animals_slaughtered_payed, animal_weight_slaughtered_original, animal_weight_slaughtered_payed, union_price_diff, union_price_ref, unit, veterinary_costs_ct, water_consumption, water_costs_ct, animal_weight_in, animal_weight_loss, animal_weight_out, year, business_id, farm_id, fodder_producer_id, stable_id FROM derived_quarter WHERE ((((unit = ?) AND (farm_id = ?)) AND (year = ?)) AND (quarter = ?))")
[EL Finer]: transaction: 2018-11-02 14:18:22.951--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--begin unit of work flush
[EL Finer]: transaction: 2018-11-02 14:18:22.951--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--end unit of work flush
[EL Finer]: transaction: 2018-11-02 14:18:22.951--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--resume unit of work
[EL Finest]: connection: 2018-11-02 14:18:22.951--ServerSession(46351362)--Connection(927729689)--Thread(Thread[DerivedData-1,5,main])--Connection acquired from connection pool [default].
[EL Finer]: transaction: 2018-11-02 14:18:22.951--ClientSession(1833149163)--Connection(927729689)--Thread(Thread[DerivedData-1,5,main])--begin transaction
[EL Finest]: connection: 2018-11-02 14:18:22.951--ClientSession(1833149163)--Thread(Thread[DerivedData-1,5,main])--reconnecting to external connection pool
[EL Fine]: sql: 2018-11-02 14:18:22.951--ClientSession(1833149163)--Connection(266374831)--Thread(Thread[DerivedData-1,5,main])--SELECT id, afom1_bacon, afom1_bacon_amount, afom1_belly, afom1_belly_amount, afom1_belly_lmp, afom1_belly_lamount, afom1_belly_lweight, afom1_index, afom1_index_amount, afom1_lmp, afom1_lamount, afom1_lweight, afom1_meat, afom1_meat_amount, afom1_pure_ham, afom1_pure_ham_amount, afom1_pure_shoulder, afom1_pure_shoulder_amount, afom3_bacon, afom3_bacon_amount, afom3_belly, afom3_belly_amount, afom3_belly_lmp, afom3_belly_lamount, afom3_belly_lweight, afom3_index, afom3_index_amount, afom3_lmp, afom3_lamount, afom3_lweight, afom3_meat, afom3_meat_amount, afom3_pure_ham, afom3_pure_ham_amount, afom3_pure_shoulder, afom3_pure_shoulder_amount, animal_current, animal_days, animal_in, animal_loss, animal_out, animal_purchase_ct, animal_sale_ct, calculated_animal_value_ct, calculated_animal_weight, calculated_fodder_consumption, calculated_fodder_costs_ct, calculated_total_weight, calculated_weight_growth, calculation_date, electricity_consumption, electricity_costs_ct, epizootic_funds_ct, fom_bacon, fom_bacon_amount, fom_lmp, fom_lamount, fom_lweight, fom_meat, fom_meat_amount, fodder_purchase_ct, fodder_weight, gas_consumption, gas_costs_ct, heat_consumption, heat_costs_ct, insurance_costs_ct, liver, lung, other_costs_ct, quarter, animals_slaughtered_delivered, animals_slaughtered_payed, animal_weight_slaughtered_original, animal_weight_slaughtered_payed, union_price_diff, union_price_ref, unit, veterinary_costs_ct, water_consumption, water_costs_ct, animal_weight_in, animal_weight_loss, animal_weight_out, year, business_id, farm_id, fodder_producer_id, stable_id FROM derived_quarter WHERE ((((unit = ?) AND (farm_id = ?)) AND (year = ?)) AND (quarter = ?)) FOR UPDATE
	bind => [FARM, 600, 2018, YEAR]
[EL Finest]: query: 2018-11-02 14:18:22.951--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query ReadAllQuery(referenceClass=ProjectQuarter sql="SELECT id, afom1_bacon, afom1_bacon_amount, afom1_belly, afom1_belly_amount, afom1_belly_lmp, afom1_belly_lamount, afom1_belly_lweight, afom1_index, afom1_index_amount, afom1_lmp, afom1_lamount, afom1_lweight, afom1_meat, afom1_meat_amount, afom1_pure_ham, afom1_pure_ham_amount, afom1_pure_shoulder, afom1_pure_shoulder_amount, afom3_bacon, afom3_bacon_amount, afom3_belly, afom3_belly_amount, afom3_belly_lmp, afom3_belly_lamount, afom3_belly_lweight, afom3_index, afom3_index_amount, afom3_lmp, afom3_lamount, afom3_lweight, afom3_meat, afom3_meat_amount, afom3_pure_ham, afom3_pure_ham_amount, afom3_pure_shoulder, afom3_pure_shoulder_amount, animal_current, animal_days, animal_in, animal_loss, animal_out, animal_purchase_ct, animal_sale_ct, calculated_animal_value_ct, calculated_animal_weight, calculated_fodder_consumption, calculated_fodder_costs_ct, calculated_total_weight, calculated_weight_growth, calculation_date, electricity_consumption, electricity_costs_ct, elusive, date_end, epizootic_funds_ct, fom_bacon, fom_bacon_amount, fom_lmp, fom_lamount, fom_lweight, fom_meat, fom_meat_amount, fodder_purchase_ct, fodder_weight, gas_consumption, gas_costs_ct, heat_consumption, heat_costs_ct, insurance_costs_ct, liver, lung, other_costs_ct, quarter, animals_slaughtered_delivered, animals_slaughtered_payed, animal_weight_slaughtered_original, animal_weight_slaughtered_payed, date_start, status, union_price_diff, union_price_ref, unit, veterinary_costs_ct, water_consumption, water_costs_ct, animal_weight_in, animal_weight_loss, animal_weight_out, year, animal_inventory_id, business_id, farm_id, fodder_producer_id, stable_id FROM quarter WHERE (((((elusive = ?) AND (unit = ?)) AND (year = ?)) AND (quarter = ?)) AND (business_id = ?))")
[EL Fine]: sql: 2018-11-02 14:18:22.952--ClientSession(1224339926)--Connection(266374831)--Thread(Thread[main,5,main])--SELECT id, afom1_bacon, afom1_bacon_amount, afom1_belly, afom1_belly_amount, afom1_belly_lmp, afom1_belly_lamount, afom1_belly_lweight, afom1_index, afom1_index_amount, afom1_lmp, afom1_lamount, afom1_lweight, afom1_meat, afom1_meat_amount, afom1_pure_ham, afom1_pure_ham_amount, afom1_pure_shoulder, afom1_pure_shoulder_amount, afom3_bacon, afom3_bacon_amount, afom3_belly, afom3_belly_amount, afom3_belly_lmp, afom3_belly_lamount, afom3_belly_lweight, afom3_index, afom3_index_amount, afom3_lmp, afom3_lamount, afom3_lweight, afom3_meat, afom3_meat_amount, afom3_pure_ham, afom3_pure_ham_amount, afom3_pure_shoulder, afom3_pure_shoulder_amount, animal_current, animal_days, animal_in, animal_loss, animal_out, animal_purchase_ct, animal_sale_ct, calculated_animal_value_ct, calculated_animal_weight, calculated_fodder_consumption, calculated_fodder_costs_ct, calculated_total_weight, calculated_weight_growth, calculation_date, electricity_consumption, electricity_costs_ct, elusive, date_end, epizootic_funds_ct, fom_bacon, fom_bacon_amount, fom_lmp, fom_lamount, fom_lweight, fom_meat, fom_meat_amount, fodder_purchase_ct, fodder_weight, gas_consumption, gas_costs_ct, heat_consumption, heat_costs_ct, insurance_costs_ct, liver, lung, other_costs_ct, quarter, animals_slaughtered_delivered, animals_slaughtered_payed, animal_weight_slaughtered_original, animal_weight_slaughtered_payed, date_start, status, union_price_diff, union_price_ref, unit, veterinary_costs_ct, water_consumption, water_costs_ct, animal_weight_in, animal_weight_loss, animal_weight_out, year, animal_inventory_id, business_id, farm_id, fodder_producer_id, stable_id FROM quarter WHERE (((((elusive = ?) AND (unit = ?)) AND (year = ?)) AND (quarter = ?)) AND (business_id = ?))
	bind => [false, BUSINESS, 2018, Q1, 607]
2018-11-02 14:18:22.952 [main] TRACE d.s.j.c.LocalDateAttributeConverter#convertToEntityAttribute[30] - Converted to Entity: 2018-04-01 -> 2018-04-01
2018-11-02 14:18:22.952 [main] TRACE d.s.j.c.LocalDateAttributeConverter#convertToEntityAttribute[30] - Converted to Entity: 2018-01-01 -> 2018-01-01
[EL Finest]: query: 2018-11-02 14:18:22.952--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query ReadObjectQuery(name="itsBusiness" referenceClass=ProjectBusiness )
[EL Finer]: transaction: 2018-11-02 14:18:22.953--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--begin unit of work flush
[EL Finer]: transaction: 2018-11-02 14:18:22.953--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--end unit of work flush
[EL Finer]: transaction: 2018-11-02 14:18:22.953--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--resume unit of work
[EL Finest]: query: 2018-11-02 14:18:22.953--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query ReadAllQuery(referenceClass=ProjectQuarter sql="SELECT id, afom1_bacon, afom1_bacon_amount, afom1_belly, afom1_belly_amount, afom1_belly_lmp, afom1_belly_lamount, afom1_belly_lweight, afom1_index, afom1_index_amount, afom1_lmp, afom1_lamount, afom1_lweight, afom1_meat, afom1_meat_amount, afom1_pure_ham, afom1_pure_ham_amount, afom1_pure_shoulder, afom1_pure_shoulder_amount, afom3_bacon, afom3_bacon_amount, afom3_belly, afom3_belly_amount, afom3_belly_lmp, afom3_belly_lamount, afom3_belly_lweight, afom3_index, afom3_index_amount, afom3_lmp, afom3_lamount, afom3_lweight, afom3_meat, afom3_meat_amount, afom3_pure_ham, afom3_pure_ham_amount, afom3_pure_shoulder, afom3_pure_shoulder_amount, animal_current, animal_days, animal_in, animal_loss, animal_out, animal_purchase_ct, animal_sale_ct, calculated_animal_value_ct, calculated_animal_weight, calculated_fodder_consumption, calculated_fodder_costs_ct, calculated_total_weight, calculated_weight_growth, calculation_date, electricity_consumption, electricity_costs_ct, elusive, date_end, epizootic_funds_ct, fom_bacon, fom_bacon_amount, fom_lmp, fom_lamount, fom_lweight, fom_meat, fom_meat_amount, fodder_purchase_ct, fodder_weight, gas_consumption, gas_costs_ct, heat_consumption, heat_costs_ct, insurance_costs_ct, liver, lung, other_costs_ct, quarter, animals_slaughtered_delivered, animals_slaughtered_payed, animal_weight_slaughtered_original, animal_weight_slaughtered_payed, date_start, status, union_price_diff, union_price_ref, unit, veterinary_costs_ct, water_consumption, water_costs_ct, animal_weight_in, animal_weight_loss, animal_weight_out, year, animal_inventory_id, business_id, farm_id, fodder_producer_id, stable_id FROM quarter WHERE (((((elusive = ?) AND (unit = ?)) AND (year = ?)) AND (quarter = ?)) AND (business_id = ?))")
[EL Finest]: query: 2018-11-02 14:18:22.953--UnitOfWork(1876960571)--Thread(Thread[DerivedData-1,5,main])--Execute query ReadObjectQuery(name="itsFarm" referenceClass=ProjectFarm )
[EL Fine]: sql: 2018-11-02 14:18:22.954--ClientSession(1224339926)--Connection(266374831)--Thread(Thread[main,5,main])--SELECT id, afom1_bacon, afom1_bacon_amount, afom1_belly, afom1_belly_amount, afom1_belly_lmp, afom1_belly_lamount, afom1_belly_lweight, afom1_index, afom1_index_amount, afom1_lmp, afom1_lamount, afom1_lweight, afom1_meat, afom1_meat_amount, afom1_pure_ham, afom1_pure_ham_amount, afom1_pure_shoulder, afom1_pure_shoulder_amount, afom3_bacon, afom3_bacon_amount, afom3_belly, afom3_belly_amount, afom3_belly_lmp, afom3_belly_lamount, afom3_belly_lweight, afom3_index, afom3_index_amount, afom3_lmp, afom3_lamount, afom3_lweight, afom3_meat, afom3_meat_amount, afom3_pure_ham, afom3_pure_ham_amount, afom3_pure_shoulder, afom3_pure_shoulder_amount, animal_current, animal_days, animal_in, animal_loss, animal_out, animal_purchase_ct, animal_sale_ct, calculated_animal_value_ct, calculated_animal_weight, calculated_fodder_consumption, calculated_fodder_costs_ct, calculated_total_weight, calculated_weight_growth, calculation_date, electricity_consumption, electricity_costs_ct, elusive, date_end, epizootic_funds_ct, fom_bacon, fom_bacon_amount, fom_lmp, fom_lamount, fom_lweight, fom_meat, fom_meat_amount, fodder_purchase_ct, fodder_weight, gas_consumption, gas_costs_ct, heat_consumption, heat_costs_ct, insurance_costs_ct, liver, lung, other_costs_ct, quarter, animals_slaughtered_delivered, animals_slaughtered_payed, animal_weight_slaughtered_original, animal_weight_slaughtered_payed, date_start, status, union_price_diff, union_price_ref, unit, veterinary_costs_ct, water_consumption, water_costs_ct, animal_weight_in, animal_weight_loss, animal_weight_out, year, animal_inventory_id, business_id, farm_id, fodder_producer_id, stable_id FROM quarter WHERE (((((elusive = ?) AND (unit = ?)) AND (year = ?)) AND (quarter = ?)) AND (business_id = ?))
	bind => [false, BUSINESS, 2017, Q4, 607]
[EL Finest]: transaction: 2018-11-02 14:18:22.954--UnitOfWork(1876960571)--Thread(Thread[DerivedData-1,5,main])--Register the existing object company.customer.project.schema.masterdata.ProjectFarm@19e86461
[EL Finest]: transaction: 2018-11-02 14:18:22.954--UnitOfWork(1876960571)--Thread(Thread[DerivedData-1,5,main])--Register the existing object company.customer.project.schema.masterdata.ProjectAddress@31475919
[EL Finest]: transaction: 2018-11-02 14:18:22.954--UnitOfWork(1876960571)--Thread(Thread[DerivedData-1,5,main])--track pessimistic locked object company.customer.project.schema.evaluation.ProjectDerivedQuarter@47e8b0e1 with UnitOfWork 1,876,960,571
2018-11-02 14:18:22.954 [main] DEBUG d.s.c.a.m.logic.animal.AnimalDao#initAnimalCurrent[361] - Taking over a amount of 0 animals from Q1-2018
2018-11-02 14:18:22.954 [DerivedData-1] DEBUG d.s.c.a.m.logic.animal.AnimalDao#lambda$getEvaluationUpdater$0[280] - Updating evaluation of type ProjectDerivedQuarter with join company.customer.project.schema.evaluation.ProjectJoinQuarterAnimalMovement@185c30a2
2018-11-02 14:18:22.954 [main] DEBUG d.s.c.a.m.logic.animal.AnimalDao#propagateAnimalAmountChange[385] - Propagated animal amount changes to 0 following quarters
2018-11-02 14:18:22.954 [DerivedData-1] DEBUG d.s.c.a.m.logic.animal.AnimalDao#lambda$getEvaluationUpdater$0[281] - Evaluation company.customer.project.schema.evaluation.ProjectDerivedQuarter@47e8b0e1 before: 50
2018-11-02 14:18:22.954 [main] DEBUG d.s.c.a.m.logic.animal.AnimalDao#lambda$getEvaluationUpdater$0[287] - Evaluation company.customer.project.schema.evaluation.ProjectQuarter@79e686ab after: 50
[EL Finest]: transaction: 2018-11-02 14:18:22.954--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Merge clone with references company.customer.project.schema.evaluation.ProjectQuarter@79e686ab
2018-11-02 14:18:22.954 [DerivedData-1] INFO  d.s.c.a.m.logic.animal.AnimalDao#setJoinMovementValueInEvaluation[594] - Not updating the evaluation prices as none is known (yet).
[EL Finer]: transaction: 2018-11-02 14:18:22.955--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--begin unit of work flush
[EL Finest]: transaction: 2018-11-02 14:18:22.955--UnitOfWork(1876960571)--Thread(Thread[DerivedData-1,5,main])--Merge clone with references company.customer.project.schema.evaluation.ProjectDerivedQuarter@47e8b0e1
[EL Finer]: transaction: 2018-11-02 14:18:22.955--UnitOfWork(1876960571)--Thread(Thread[DerivedData-1,5,main])--release unit of work
[EL Finest]: query: 2018-11-02 14:18:22.955--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query UpdateObjectQuery(company.customer.project.schema.evaluation.ProjectQuarter@79e686ab)
[EL Finer]: transaction: 2018-11-02 14:18:22.956--ClientSession(1833149163)--Connection(266374831)--Thread(Thread[DerivedData-1,5,main])--rollback transaction
[EL Fine]: sql: 2018-11-02 14:18:22.956--ClientSession(1224339926)--Connection(266374831)--Thread(Thread[main,5,main])--UPDATE quarter SET animal_current = ?, animal_days = ?, animal_loss = ?, animal_weight_loss = ? WHERE (id = ?)
	bind => [50, -1600, 0, 0, 611]
[EL Finest]: connection: 2018-11-02 14:18:22.957--ServerSession(46351362)--Connection(927729689)--Thread(Thread[DerivedData-1,5,main])--Connection released to connection pool [default].
[EL Finer]: connection: 2018-11-02 14:18:22.957--ClientSession(1833149163)--Thread(Thread[DerivedData-1,5,main])--client released
[EL Finer]: transaction: 2018-11-02 14:18:22.957--UnitOfWork(620648658)--Thread(Thread[DerivedData-1,5,main])--release unit of work
[EL Finer]: connection: 2018-11-02 14:18:22.957--ClientSession(84650225)--Thread(Thread[DerivedData-1,5,main])--client released
[EL Finer]: connection: 2018-11-02 14:18:22.957--ServerSession(46351362)--Thread(Thread[DerivedData-1,5,main])--client acquired: 299007436
[EL Finer]: transaction: 2018-11-02 14:18:22.957--ClientSession(299007436)--Thread(Thread[DerivedData-1,5,main])--acquire unit of work: 331327663
[EL Finest]: query: 2018-11-02 14:18:22.957--UnitOfWork(331327663)--Thread(Thread[DerivedData-1,5,main])--Execute query ReadObjectQuery(name="readProjectAnimalMovement" referenceClass=ProjectAnimalMovement sql="SELECT id, animal_lost, status, type, comment, date, delivery_note_nr, hit_report_timestamp, invoice_nr, piece_amount, tam_report_timestamp, total_value_ct, total_weight, cancelled_movement_id, clearing_house_id, business_id, animal_loss_type_id, delivery_note_doc_id, invoice_doc_id FROM animal_movement WHERE (id = ?)")
[EL Finest]: connection: 2018-11-02 14:18:22.957--ServerSession(46351362)--Connection(1187241822)--Thread(Thread[DerivedData-1,5,main])--Connection acquired from connection pool [read].
[EL Finest]: connection: 2018-11-02 14:18:22.957--ServerSession(46351362)--Thread(Thread[DerivedData-1,5,main])--reconnecting to external connection pool
[EL Fine]: sql: 2018-11-02 14:18:22.957--ServerSession(46351362)--Connection(266374831)--Thread(Thread[DerivedData-1,5,main])--SELECT id, animal_lost, status, type, comment, date, delivery_note_nr, hit_report_timestamp, invoice_nr, piece_amount, tam_report_timestamp, total_value_ct, total_weight, cancelled_movement_id, clearing_house_id, business_id, animal_loss_type_id, delivery_note_doc_id, invoice_doc_id FROM animal_movement WHERE (id = ?)
	bind => [645]
[EL Finest]: connection: 2018-11-02 14:18:22.957--ServerSession(46351362)--Connection(1187241822)--Thread(Thread[DerivedData-1,5,main])--Connection released to connection pool [read].
[EL Finer]: transaction: 2018-11-02 14:18:22.957--UnitOfWork(331327663)--Thread(Thread[DerivedData-1,5,main])--release unit of work
[EL Finer]: connection: 2018-11-02 14:18:22.957--ClientSession(299007436)--Thread(Thread[DerivedData-1,5,main])--client released
[EL Finer]: transaction: 2018-11-02 14:18:22.958--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--end unit of work flush
[EL Finer]: transaction: 2018-11-02 14:18:22.958--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--resume unit of work
[EL Finest]: query: 2018-11-02 14:18:22.958--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query ReportQuery(referenceClass=ProjectJoinPartnerBusiness sql="SELECT COUNT(id) FROM join_partner_business WHERE (((to_date IS NULL) AND (a_id = ?)) AND (b_id = ?))")
[EL Fine]: sql: 2018-11-02 14:18:22.958--ClientSession(1224339926)--Connection(266374831)--Thread(Thread[main,5,main])--SELECT COUNT(id) FROM join_partner_business WHERE (((to_date IS NULL) AND (a_id = ?)) AND (b_id = ?))
	bind => [635, 607]
[EL Finest]: transaction: 2018-11-02 14:18:22.958--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--register_new_for_persist (There is no English translation for this message.)
[EL Finest]: sequencing: 2018-11-02 14:18:22.958--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--assign sequence to the object (647 -> company.customer.project.schema.masterdata.ProjectJoinPartnerBusiness@6d487f2b)
[EL Finer]: transaction: 2018-11-02 14:18:22.958--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--begin unit of work flush
[EL Finest]: query: 2018-11-02 14:18:22.959--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query DoesExistQuery(referenceClass=ProjectPartner )
[EL Fine]: sql: 2018-11-02 14:18:22.96--ClientSession(1224339926)--Connection(266374831)--Thread(Thread[main,5,main])--SELECT id FROM partner WHERE (id = ?)
	bind => [635]
[EL Finest]: query: 2018-11-02 14:18:22.96--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query DoesExistQuery(referenceClass=ProjectBusiness )
[EL Fine]: sql: 2018-11-02 14:18:22.96--ClientSession(1224339926)--Connection(266374831)--Thread(Thread[main,5,main])--SELECT id FROM business WHERE (id = ?)
	bind => [607]
[EL Finest]: query: 2018-11-02 14:18:22.96--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query InsertObjectQuery(company.customer.project.schema.masterdata.ProjectJoinPartnerBusiness@6d487f2b)
[EL Fine]: sql: 2018-11-02 14:18:22.961--ClientSession(1224339926)--Connection(266374831)--Thread(Thread[main,5,main])--INSERT INTO join_partner_business (id, comparison, from_date, to_date, a_id, b_id) VALUES (?, ?, ?, ?, ?, ?)
	bind => [647, true, 2018-08-02 12:18:22.958, null, 635, 607]
[EL Finer]: transaction: 2018-11-02 14:18:22.961--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--end unit of work flush
[EL Finer]: transaction: 2018-11-02 14:18:22.961--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--resume unit of work
[EL Finest]: query: 2018-11-02 14:18:22.961--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query ReportQuery(referenceClass=ProjectUnionPrice sql="SELECT price FROM union_price WHERE (((((type = ?) AND (valid_from < ?)) AND (valid_to > ?)) AND (animal_group = ?)) AND (animal_sub_group = ?))")
2018-11-02 14:18:22.961 [main] TRACE d.s.j.c.LocalDateAttributeConverter#convertToDatabaseColumn[23] - Converted to DB: 2018-11-02 -> 2018-11-02
2018-11-02 14:18:22.961 [main] TRACE d.s.j.c.LocalDateAttributeConverter#convertToDatabaseColumn[23] - Converted to DB: 2018-11-02 -> 2018-11-02
[EL Fine]: sql: 2018-11-02 14:18:22.961--ClientSession(1224339926)--Connection(266374831)--Thread(Thread[main,5,main])--SELECT price FROM union_price WHERE (((((type = ?) AND (valid_from < ?)) AND (valid_to > ?)) AND (animal_group = ?)) AND (animal_sub_group = ?))
	bind => [VEZG, 2018-11-02, 2018-11-02, PIG, PIG]
[EL Finest]: transaction: 2018-11-02 14:18:22.962--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--register_new_for_persist (There is no English translation for this message.)
[EL Finest]: sequencing: 2018-11-02 14:18:22.962--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--assign sequence to the object (648 -> company.customer.project.schema.animal.ProjectSlaughterParty@4970b93d)
[EL Finer]: transaction: 2018-11-02 14:18:22.962--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--begin unit of work flush
[EL Finest]: query: 2018-11-02 14:18:22.962--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query DoesExistQuery(referenceClass=ProjectBusiness )
[EL Fine]: sql: 2018-11-02 14:18:22.962--ClientSession(1224339926)--Connection(266374831)--Thread(Thread[main,5,main])--SELECT id FROM business WHERE (id = ?)
	bind => [607]
[EL Finest]: query: 2018-11-02 14:18:22.962--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query DoesExistQuery(referenceClass=ProjectSlaughterMask )
[EL Fine]: sql: 2018-11-02 14:18:22.962--ClientSession(1224339926)--Connection(266374831)--Thread(Thread[main,5,main])--SELECT id FROM slaughter_mask WHERE (id = ?)
	bind => [638]
[EL Finest]: query: 2018-11-02 14:18:22.963--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query DoesExistQuery(referenceClass=ProjectJoinPartnerVvvoNumber )
[EL Fine]: sql: 2018-11-02 14:18:22.963--ClientSession(1224339926)--Connection(266374831)--Thread(Thread[main,5,main])--SELECT id FROM join_partner_vvvo_number WHERE (id = ?)
	bind => [637]
[EL Finest]: query: 2018-11-02 14:18:22.963--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Execute query InsertObjectQuery(company.customer.project.schema.animal.ProjectSlaughterParty@4970b93d)
2018-11-02 14:18:22.963 [main] TRACE d.s.j.c.LocalDateAttributeConverter#convertToDatabaseColumn[23] - Converted to DB: 2018-11-02 -> 2018-11-02
2018-11-02 14:18:22.963 [main] TRACE d.s.j.c.LocalDateAttributeConverter#convertToDatabaseColumn[23] - Converted to DB: 2018-11-02 -> 2018-11-02
[EL Fine]: sql: 2018-11-02 14:18:22.963--ClientSession(1224339926)--Connection(266374831)--Thread(Thread[main,5,main])--INSERT INTO slaughter_party (id, afom1_bacon, afom1_bacon_amount, afom1_belly, afom1_belly_amount, afom1_belly_lmp, afom1_belly_lamount, afom1_belly_lweight, afom1_index, afom1_index_amount, afom1_lmp, afom1_lamount, afom1_lweight, afom1_meat, afom1_meat_amount, afom1_pure_ham, afom1_pure_ham_amount, afom1_pure_shoulder, afom1_pure_shoulder_amount, afom3_bacon, afom3_bacon_amount, afom3_belly, afom3_belly_amount, afom3_belly_lmp, afom3_belly_lamount, afom3_belly_lweight, afom3_index, afom3_index_amount, afom3_lmp, afom3_lamount, afom3_lweight, afom3_meat, afom3_meat_amount, afom3_pure_ham, afom3_pure_ham_amount, afom3_pure_shoulder, afom3_pure_shoulder_amount, base_price_ct, bonus_ct, delivery_date, exploitation, fom_bacon, fom_bacon_amount, fom_lmp, fom_lamount, fom_lweight, fom_meat, fom_meat_amount, liver, living_weight, lung, animals_rejected_amount, slaughter_date, slaughter_mark, animals_slaughtered_delivered, animals_slaughtered_payed, animal_weight_slaughtered_original, animal_weight_slaughtered_payed, animals_stable_lost, status, animals_transport_lost, union_price_diff, union_price_ref, value_ct, animals_veterinary_lost, business_id, slaughter_mask_id, old_entry_id, slaughter_house_id, animal_movement_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
	bind => [648, null, 0, null, 0, null, 0, 0.0, null, 0, null, 0, 0.0, null, 0, null, 0, null, 0, null, 0, null, 0, null, 0, 0.0, null, 0, null, 0, 0.0, null, 0, null, 0, null, 0, 149, 0, 2018-11-02, null, null, 0, null, 0, 0.0, null, 0, 0.0, null, 0.0, 1, 2018-11-02, BRA1234321, 50, 44, 94.18000030517578, 94.18000030517578, 2, CREATED, 2, 0.0, 0.0, 0, 1, 607, 638, 640, 637, null]
[EL Fine]: sql: 2018-11-02 14:18:22.966--ClientSession(1224339926)--Thread(Thread[main,5,main])--SELECT 1
[EL Warning]: 2018-11-02 14:18:22.966--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--Local Exception Stack: 
Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.2.v20180622-f627448): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.h2.jdbc.JdbcSQLIntegrityConstraintViolationException: Referential integrity constraint violation: "FK_SLAUGHTER_PARTY_OLD_ENTRY_ID: PUBLIC.SLAUGHTER_PARTY FOREIGN KEY(OLD_ENTRY_ID) REFERENCES PUBLIC.SLAUGHTER_PARTY(ID) (640)"; SQL statement:
INSERT INTO slaughter_party (id, afom1_bacon, afom1_bacon_amount, afom1_belly, afom1_belly_amount, afom1_belly_lmp, afom1_belly_lamount, afom1_belly_lweight, afom1_index, afom1_index_amount, afom1_lmp, afom1_lamount, afom1_lweight, afom1_meat, afom1_meat_amount, afom1_pure_ham, afom1_pure_ham_amount, afom1_pure_shoulder, afom1_pure_shoulder_amount, afom3_bacon, afom3_bacon_amount, afom3_belly, afom3_belly_amount, afom3_belly_lmp, afom3_belly_lamount, afom3_belly_lweight, afom3_index, afom3_index_amount, afom3_lmp, afom3_lamount, afom3_lweight, afom3_meat, afom3_meat_amount, afom3_pure_ham, afom3_pure_ham_amount, afom3_pure_shoulder, afom3_pure_shoulder_amount, base_price_ct, bonus_ct, delivery_date, exploitation, fom_bacon, fom_bacon_amount, fom_lmp, fom_lamount, fom_lweight, fom_meat, fom_meat_amount, liver, living_weight, lung, animals_rejected_amount, slaughter_date, slaughter_mark, animals_slaughtered_delivered, animals_slaughtered_payed, animal_weight_slaughtered_original, animal_weight_slaughtered_payed, animals_stable_lost, status, animals_transport_lost, union_price_diff, union_price_ref, value_ct, animals_veterinary_lost, business_id, slaughter_mask_id, old_entry_id, slaughter_house_id, animal_movement_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [23506-197]
Error Code: 23506
Call: INSERT INTO slaughter_party (id, afom1_bacon, afom1_bacon_amount, afom1_belly, afom1_belly_amount, afom1_belly_lmp, afom1_belly_lamount, afom1_belly_lweight, afom1_index, afom1_index_amount, afom1_lmp, afom1_lamount, afom1_lweight, afom1_meat, afom1_meat_amount, afom1_pure_ham, afom1_pure_ham_amount, afom1_pure_shoulder, afom1_pure_shoulder_amount, afom3_bacon, afom3_bacon_amount, afom3_belly, afom3_belly_amount, afom3_belly_lmp, afom3_belly_lamount, afom3_belly_lweight, afom3_index, afom3_index_amount, afom3_lmp, afom3_lamount, afom3_lweight, afom3_meat, afom3_meat_amount, afom3_pure_ham, afom3_pure_ham_amount, afom3_pure_shoulder, afom3_pure_shoulder_amount, base_price_ct, bonus_ct, delivery_date, exploitation, fom_bacon, fom_bacon_amount, fom_lmp, fom_lamount, fom_lweight, fom_meat, fom_meat_amount, liver, living_weight, lung, animals_rejected_amount, slaughter_date, slaughter_mark, animals_slaughtered_delivered, animals_slaughtered_payed, animal_weight_slaughtered_original, animal_weight_slaughtered_payed, animals_stable_lost, status, animals_transport_lost, union_price_diff, union_price_ref, value_ct, animals_veterinary_lost, business_id, slaughter_mask_id, old_entry_id, slaughter_house_id, animal_movement_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
	bind => [648, null, 0, null, 0, null, 0, 0.0, null, 0, null, 0, 0.0, null, 0, null, 0, null, 0, null, 0, null, 0, null, 0, 0.0, null, 0, null, 0, 0.0, null, 0, null, 0, null, 0, 149, 0, 2018-11-02, null, null, 0, null, 0, 0.0, null, 0, 0.0, null, 0.0, 1, 2018-11-02, BRA1234321, 50, 44, 94.18000030517578, 94.18000030517578, 2, CREATED, 2, 0.0, 0.0, 0, 1, 607, 638, 640, 637, null]
Query: InsertObjectQuery(company.customer.project.schema.animal.ProjectSlaughterParty@4970b93d)
	at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:331)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:905)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:967)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:637)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:564)
	at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2093)
	at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:309)
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:272)
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:258)
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.insertObject(DatasourceCallQueryMechanism.java:408)
	at org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:165)
	at org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:180)
	at org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.insertObjectForWrite(DatabaseQueryMechanism.java:502)
	at org.eclipse.persistence.queries.InsertObjectQuery.executeCommit(InsertObjectQuery.java:80)
	at org.eclipse.persistence.queries.InsertObjectQuery.executeCommitWithChangeSet(InsertObjectQuery.java:90)
	at org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.executeWriteWithChangeSet(DatabaseQueryMechanism.java:314)
	at org.eclipse.persistence.queries.WriteObjectQuery.executeDatabaseQuery(WriteObjectQuery.java:58)
	at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:911)
	at org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:810)
	at org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWorkObjectLevelModifyQuery(ObjectLevelModifyQuery.java:108)
	at org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWork(ObjectLevelModifyQuery.java:85)
	at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2979)
	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1892)
	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1874)
	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1824)
	at org.eclipse.persistence.internal.sessions.CommitManager.commitNewObjectsForClassWithChangeSet(CommitManager.java:227)
	at org.eclipse.persistence.internal.sessions.CommitManager.commitAllObjectsWithChangeSet(CommitManager.java:126)
	at org.eclipse.persistence.internal.sessions.AbstractSession.writeAllObjectsWithChangeSet(AbstractSession.java:4384)
	at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1491)
	at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithPreBuiltChangeSet(UnitOfWorkImpl.java:1637)
	at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.writeChanges(RepeatableWriteUnitOfWork.java:455)
	at org.eclipse.persistence.internal.jpa.EntityManagerImpl.flush(EntityManagerImpl.java:967)
	at org.eclipse.persistence.internal.jpa.QueryImpl.performPreQueryFlush(QueryImpl.java:974)
	at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:209)
	at org.eclipse.persistence.internal.jpa.QueryImpl.getSingleResult(QueryImpl.java:528)
	at org.eclipse.persistence.internal.jpa.EJBQueryImpl.getSingleResult(EJBQueryImpl.java:402)
	at com.querydsl.jpa.impl.AbstractJPAQuery.getSingleResult(AbstractJPAQuery.java:183)
	at com.querydsl.jpa.impl.AbstractJPAQuery.fetchOne(AbstractJPAQuery.java:253)
	at company.choiceservice.logic.ChoiceDao.getChoice(ChoiceDao.java:43)
	at company.choiceservice.logic.ChoiceDao$$FastClassBySpringCGLIB$$920f8314.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:652)
	at company.choiceservice.logic.ChoiceDao$$EnhancerBySpringCGLIB$$8580721e.getChoice(<generated>)
	at company.customer.project.logic.animal.AnimalMovementConverter.internFillEntity(AnimalMovementConverter.java:112)
	at company.customer.project.logic.animal.AnimalMovementConverter.internFillEntity(AnimalMovementConverter.java:36)
	at company.customer.project.logic.messages.AbstractLogicConverter.fillEntity(AbstractLogicConverter.java:19)
	at company.jpaCommons.dao.GenericDao.createItem(GenericDao.java:25)
	at company.jpaCommons.dao.GenericDao$$FastClassBySpringCGLIB$$54d9b4c5.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:721)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:656)
	at company.jpaCommons.dao.GenericDao$$EnhancerBySpringCGLIB$$2fcf1dd1.createItem(<generated>)
	at company.customer.project.logic.dataimport.slaughterparty.PartyRecord.process(PartyRecord.java:261)
	at company.customer.project.logic.dataimport.slaughterparty.PartyRecord.process(PartyRecord.java:43)
	at company.csvParser.CSVDocumentParser.lambda$parse$1(CSVDocumentParser.java:74)
	at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:133)
	at company.csvParser.CSVDocumentParser.parse(CSVDocumentParser.java:71)
	at company.customer.project.logic.dataimport.slaughterparty.SlaughterPartyImportTest.testOverride(SlaughterPartyImportTest.java:146)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
	at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
	at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
	at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
	at org.springframework.test.context.junit4.statements.RunBeforeTestMethodCallbacks.evaluate(RunBeforeTestMethodCallbacks.java:75)
	at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
	at org.springframework.test.context.junit4.statements.RunAfterTestMethodCallbacks.evaluate(RunAfterTestMethodCallbacks.java:86)
	at org.springframework.test.context.junit4.statements.SpringRepeat.evaluate(SpringRepeat.java:84)
	at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
	at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:252)
	at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:94)
	at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
	at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
	at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
	at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
	at org.springframework.test.context.junit4.statements.RunBeforeTestClassCallbacks.evaluate(RunBeforeTestClassCallbacks.java:61)
	at org.springframework.test.context.junit4.statements.RunAfterTestClassCallbacks.evaluate(RunAfterTestClassCallbacks.java:70)
	at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
	at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:191)
	at org.junit.runner.JUnitCore.run(JUnitCore.java:137)
Caused by: org.h2.jdbc.JdbcSQLIntegrityConstraintViolationException: Referential integrity constraint violation: "FK_SLAUGHTER_PARTY_OLD_ENTRY_ID: PUBLIC.SLAUGHTER_PARTY FOREIGN KEY(OLD_ENTRY_ID) REFERENCES PUBLIC.SLAUGHTER_PARTY(ID) (640)"; SQL statement:
INSERT INTO slaughter_party (id, afom1_bacon, afom1_bacon_amount, afom1_belly, afom1_belly_amount, afom1_belly_lmp, afom1_belly_lamount, afom1_belly_lweight, afom1_index, afom1_index_amount, afom1_lmp, afom1_lamount, afom1_lweight, afom1_meat, afom1_meat_amount, afom1_pure_ham, afom1_pure_ham_amount, afom1_pure_shoulder, afom1_pure_shoulder_amount, afom3_bacon, afom3_bacon_amount, afom3_belly, afom3_belly_amount, afom3_belly_lmp, afom3_belly_lamount, afom3_belly_lweight, afom3_index, afom3_index_amount, afom3_lmp, afom3_lamount, afom3_lweight, afom3_meat, afom3_meat_amount, afom3_pure_ham, afom3_pure_ham_amount, afom3_pure_shoulder, afom3_pure_shoulder_amount, base_price_ct, bonus_ct, delivery_date, exploitation, fom_bacon, fom_bacon_amount, fom_lmp, fom_lamount, fom_lweight, fom_meat, fom_meat_amount, liver, living_weight, lung, animals_rejected_amount, slaughter_date, slaughter_mark, animals_slaughtered_delivered, animals_slaughtered_payed, animal_weight_slaughtered_original, animal_weight_slaughtered_payed, animals_stable_lost, status, animals_transport_lost, union_price_diff, union_price_ref, value_ct, animals_veterinary_lost, business_id, slaughter_mask_id, old_entry_id, slaughter_house_id, animal_movement_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [23506-197]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:454)
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:425)
	at org.h2.message.DbException.get(DbException.java:203)
	at org.h2.message.DbException.get(DbException.java:179)
	at org.h2.constraint.ConstraintReferential.checkRowOwnTable(ConstraintReferential.java:332)
	at org.h2.constraint.ConstraintReferential.checkRow(ConstraintReferential.java:274)
	at org.h2.table.Table.fireConstraints(Table.java:1021)
	at org.h2.table.Table.fireAfterRow(Table.java:1039)
	at org.h2.command.dml.Insert.insertRows(Insert.java:199)
	at org.h2.command.dml.Insert.update(Insert.java:137)
	at org.h2.command.CommandContainer.update(CommandContainer.java:103)
	at org.h2.command.Command.executeUpdate(Command.java:263)
	at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:200)
	at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:154)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:895)
	... 90 more

[EL Finer]: transaction: 2018-11-02 14:18:22.97--UnitOfWork(1298690816)--Thread(Thread[main,5,main])--release unit of work

Back to the top