[jboss-jira] [JBoss JIRA] Updated: (JBAS-5616) read-ahead left-join problem

read-ahead left-join problem ---------------------------- Key: JBAS-5616 URL: http://jira.jboss.com/jira/browse/JBAS-5616 Project: JBoss Application Server Issue Type: Bug Security Level: Public(Everyone can see) Components: CMP service, EJB2 Affects Versions: JBossAS-4.0.4.GA Environment: java version "1.6.0_05" Java(TM) SE Runtime Environment (build 1.6.0_05-b13) Java HotSpot(TM) Client VM (build 10.0-b19, mixed mode, sharing) Windows XP Reporter: Tamara Cattivelli Assigned To: Alexey Loubyansky Attachments: server.log I added a left-join entry in jbosscmp-jdbc.xml file for a jboss query. The generated query is correct, but the data for the bean corresponding to the CMR field defined in read-ahead/left-join are loaded from database, not from read ahead cache. First, the correct left-join SQL statement is pushed and shown on the server. Then, the standard behaviour of lazy-loading from the database follows immediatly whenever you access an entities' bean local object. This is a strange behaviour. Corresponding fragment in jbosscmp-jdbc.xml is: <query> <query-method> <method-name>findOfferProposalByContractIDAndOfferType</method-name> <method-params> <method-param>java.lang.String</method-param> <method-param>int</method-param> <method-param>java.lang.Integer</method-param> </method-params> </query-method> <jboss-ql><![CDATA[SELECT OBJECT(a) FROM OfferProposalEntityBean AS a WHERE a.domain = ?1 AND a.contractNo = ?2 AND a.offerTypeEntity.iD = ?3]]></jboss-ql> <read-ahead> <strategy>on-find</strategy> <eager-load-group>*</eager-load-group> <left-join cmr-field="offerProposalItems" eager-load-group="*"> <left-join cmr-field="offerProposalItemCriteria" eager-load-group="*"/> <left-join cmr-field="process" eager-load-group="*"> <left-join cmr-field="processType" eager-load-group="*"/> </left-join> <left-join cmr-field="offerProposalMappingItems" eager-load-group="*"> <left-join cmr-field="offerProductOptionMapping" eager-load-group="*"> <left-join cmr-field="offerProduct" eager-load-group="*"> <left-join cmr-field="offerProductTypeEntity" eager-load-group="*"/> </left-join> <left-join cmr-field="offerOption" eager-load-group="*"/> </left-join> </left-join> </left-join> <left-join cmr-field="offerProposalCriteria" eager-load-group="*"/> <left-join cmr-field="offerChannelEntity" eager-load-group="*"/> <left-join cmr-field="offerTypeGroupEntity" eager-load-group="*"/> <left-join cmr-field="offerTypeEntity" eager-load-group="*"/> </read-ahead> </query> Generated query (is correct): 13:54:44,087 DEBUG [OfferProposalEntityBean#findOfferProposalByContractID] Executing SQL: SELECT t0_a.ID, t0_a.DOMAIN, t 0_a.CONTRACT_NO, t0_a.PARTY_NO, t0_a.OFFER_PERIOD, t0_a.VALID_FROM, t0_a.VALID_TO, t0_a.PROPOSAL_PERMISSION, t0_a.OFFER_ CHANNEL_ID, t0_a.OFFER_TYPE_GROUP_ID, t0_a.OFFER_TYPE_ID, t1_a_offerProposalItems.ID, t1_a_offerProposalItems.PROPOSAL_I D, t1_a_offerProposalItems.POSITION, t1_a_offerProposalItems.RANK_AFFINITY, t1_a_offerProposalItems.RANK_MARGIN, t1_a_of ferProposalItems.RANK_PRIORITY, t1_a_offerProposalItems.PROCESS_ID, t2_a_offerProposalItems_offerP.ID, t2_a_offerProposa lItems_offerP.CRITERIA_VALUE, t2_a_offerProposalItems_offerP.CRITERIA_TYPE_ID, t2_a_offerProposalItems_offerP.PROPOSAL_I TEM_ID, t3_a_offerProposalItems_proces.ID, t3_a_offerProposalItems_proces.PROCESS_LABEL, t3_a_offerProposalItems_proces. PROCESS_DESCRIPTION, t3_a_offerProposalItems_proces.PROCESS_TYPE_ID, t4_a_offerProposalItems_proces.ID, t4_a_offerPropos alItems_proces.SHORTCUT, t4_a_offerProposalItems_proces.LABEL, t4_a_offerProposalItems_proces.DESCRIPTION, t5_a_offerPro posalItems_offerP.ID, t5_a_offerProposalItems_offerP.PROPOSAL_ITEM_ID, t5_a_offerProposalItems_offerP.PRODUCT_MAPPING_ID , t6_a_offerProposalItems_offerP.ID, t6_a_offerProposalItems_offerP.OPTIONAL, t6_a_offerProposalItems_offerP.SELECTED, t 6_a_offerProposalItems_offerP.PRODUCT_ID, t6_a_offerProposalItems_offerP.OPTION_ID, t7_a_offerProposalItems_offerP.ID, t 7_a_offerProposalItems_offerP.PRODUCT_VARIANT_ID, t7_a_offerProposalItems_offerP.PRODUCT_EXTERNAL_REFERENCE, t7_a_offerP roposalItems_offerP.PRODUCT_LABEL, t7_a_offerProposalItems_offerP.PRODUCT_PROVIDER, t7_a_offerProposalItems_offerP.PRODU CT_DESCRIPTION, t7_a_offerProposalItems_offerP.PRODUCT_TYPE_ID, t8_a_offerProposalItems_offerP.ID, t8_a_offerProposalIte ms_offerP.SHORTCUT, t8_a_offerProposalItems_offerP.LABEL, t8_a_offerProposalItems_offerP.DESCRIPTION, t9_a_offerProposal Items_offerP.ID, t9_a_offerProposalItems_offerP.OPTION_NUMBER, t9_a_offerProposalItems_offerP.OPTION_EXTERNAL_REFERENCE, t9_a_offerProposalItems_offerP.OPTION_LABEL, t10_a_offerProposalCriteria.ID, t10_a_offerProposalCriteria.CRITERIA_VALUE , t10_a_offerProposalCriteria.PROPOSAL_ID, t10_a_offerProposalCriteria.CRITERIA_TYPE_ID, t11_a_offerChannelEntity.ID, t1 1_a_offerChannelEntity.SHORTCUT, t12_a_offerTypeGroupEntity.ID, t12_a_offerTypeGroupEntity.SHORTCUT, t13_a_offerTypeEnti ty.ID, t13_a_offerTypeEntity.SHORTCUT FROM OFFER_PROPOSAL t0_a LEFT OUTER JOIN OFFER_PROPOSAL_ITEM t1_a_offerProposalIte ms ON t0_a.ID=t1_a_offerProposalItems.PROPOSAL_ID LEFT OUTER JOIN OFFER_PROPOSAL_ITEM_CRITERIA t2_a_offerProposalItems_o fferP ON t1_a_offerProposalItems.ID=t2_a_offerProposalItems_offerP.PROPOSAL_ITEM_ID LEFT OUTER JOIN OFFER_PROCESS t3_a_o fferProposalItems_proces ON t1_a_offerProposalItems.PROCESS_ID=t3_a_offerProposalItems_proces.ID LEFT OUTER JOIN OFFER_P ROCESS_TYPE t4_a_offerProposalItems_proces ON t3_a_offerProposalItems_proces.PROCESS_TYPE_ID=t4_a_offerProposalItems_pro ces.ID LEFT OUTER JOIN OFFER_PROPOSAL_MAPPING t5_a_offerProposalItems_offerP ON t1_a_offerProposalItems.ID=t5_a_offerPro posalItems_offerP.PROPOSAL_ITEM_ID LEFT OUTER JOIN OFFER_PRODUCT_2_OFFER_OPTION t6_a_offerProposalItems_offerP ON t5_a_o fferProposalItems_offerP.PRODUCT_MAPPING_ID=t6_a_offerProposalItems_offerP.ID LEFT OUTER JOIN OFFER_PRODUCT t7_a_offerPr oposalItems_offerP ON t6_a_offerProposalItems_offerP.PRODUCT_ID=t7_a_offerProposalItems_offerP.ID LEFT OUTER JOIN OFFER_ PRODUCT_TYPE t8_a_offerProposalItems_offerP ON t7_a_offerProposalItems_offerP.PRODUCT_TYPE_ID=t8_a_offerProposalItems_of ferP.ID LEFT OUTER JOIN OFFER_OPTION t9_a_offerProposalItems_offerP ON t6_a_offerProposalItems_offerP.OPTION_ID=t9_a_off erProposalItems_offerP.ID LEFT OUTER JOIN OFFER_PROPOSAL_CRITERIA t10_a_offerProposalCriteria ON t0_a.ID=t10_a_offerProp osalCriteria.PROPOSAL_ID LEFT OUTER JOIN OFFER_CHANNEL t11_a_offerChannelEntity ON t0_a.OFFER_CHANNEL_ID=t11_a_offerChan nelEntity.ID LEFT OUTER JOIN OFFER_TYPE_GROUP t12_a_offerTypeGroupEntity ON t0_a.OFFER_TYPE_GROUP_ID=t12_a_offerTypeGrou pEntity.ID LEFT OUTER JOIN OFFER_TYPE t13_a_offerTypeEntity ON t0_a.OFFER_TYPE_ID=t13_a_offerTypeEntity.ID WHERE (t0_a.D OMAIN = ? AND t0_a.CONTRACT_NO = ?) Lazy-loading from database when entity bean locals are accessed to be transferred to DTOs: 13:54:45,134 DEBUG [OfferProposalEntityBean] Executing SQL: SELECT DOMAIN, CONTRACT_NO, PARTY_NO, OFFER_PERIOD, VALID_FR OM, VALID_TO, PROPOSAL_PERMISSION, OFFER_CHANNEL_ID, OFFER_TYPE_GROUP_ID, OFFER_TYPE_ID FROM OFFER_PROPOSAL WHERE (ID=?) 13:54:45,165 DEBUG [OfferProposalEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM WHERE (PROPOSAL_ID=?) 13:54:45,212 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN , RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:45,259 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (P ROPOSAL_ITEM_ID=?) 13:54:45,290 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:45,337 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:45,400 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:45,447 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:45,493 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:45,540 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_LABEL, PROCESS_DESCRIPTION, PROCESS_TYPE_ID FR OM OFFER_PROCESS WHERE (ID=?) 13:54:45,603 DEBUG [OfferProcessTypeEntityBean] Executing SQL: SELECT SHORTCUT, LABEL, DESCRIPTION FROM OFFER_PROCESS_TY PE WHERE (ID=?) 13:54:45,650 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:45,697 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:45,743 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:45,790 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSA L_ITEM_ID=?) 13:54:45,822 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN , RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:45,868 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (P ROPOSAL_ITEM_ID=?) 13:54:45,900 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:45,947 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:45,993 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:46,056 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:46,103 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:46,150 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:46,212 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:46,259 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:46,306 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:46,353 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSA L_ITEM_ID=?) 13:54:46,384 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN , RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:46,415 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (P ROPOSAL_ITEM_ID=?) 13:54:46,447 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:46,509 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:46,556 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:46,603 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:46,650 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:46,712 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:46,759 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:46,806 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:46,853 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:46,900 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSA L_ITEM_ID=?) 13:54:46,931 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN , RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:46,978 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (P ROPOSAL_ITEM_ID=?) 13:54:47,009 DEBUG [OfferProposalItemCriteriaEntityBean] Executing SQL: SELECT CRITERIA_VALUE, CRITERIA_TYPE_ID, PROPOSA L_ITEM_ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?) 13:54:47,056 DEBUG [OfferProposalItemCriteriaEntityBean] Executing SQL: SELECT CRITERIA_TYPE_ID, PROPOSAL_ITEM_ID FROM O FFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?) 13:54:47,118 DEBUG [ItemCriteriaTypeEntityBean] Executing SQL: SELECT SHORTCUT, LABEL, DESCRIPTION FROM ITEM_CRITERIA_TY PE WHERE (ID=?) 13:54:47,165 DEBUG [OfferProposalItemCriteriaEntityBean] Executing SQL: SELECT CRITERIA_VALUE, CRITERIA_TYPE_ID, PROPOSA L_ITEM_ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?) 13:54:47,228 DEBUG [OfferProposalItemCriteriaEntityBean] Executing SQL: SELECT CRITERIA_TYPE_ID, PROPOSAL_ITEM_ID FROM O FFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?) 13:54:47,275 DEBUG [ItemCriteriaTypeEntityBean] Executing SQL: SELECT SHORTCUT, LABEL, DESCRIPTION FROM ITEM_CRITERIA_TY PE WHERE (ID=?) 13:54:47,337 DEBUG [OfferProposalItemCriteriaEntityBean] Executing SQL: SELECT CRITERIA_VALUE, CRITERIA_TYPE_ID, PROPOSA L_ITEM_ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?) 13:54:47,384 DEBUG [OfferProposalItemCriteriaEntityBean] Executing SQL: SELECT CRITERIA_TYPE_ID, PROPOSAL_ITEM_ID FROM O FFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?) 13:54:47,447 DEBUG [ItemCriteriaTypeEntityBean] Executing SQL: SELECT SHORTCUT, LABEL, DESCRIPTION FROM ITEM_CRITERIA_TY PE WHERE (ID=?) 13:54:47,493 DEBUG [OfferProposalItemCriteriaEntityBean] Executing SQL: SELECT CRITERIA_VALUE, CRITERIA_TYPE_ID, PROPOSA L_ITEM_ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?) 13:54:47,540 DEBUG [OfferProposalItemCriteriaEntityBean] Executing SQL: SELECT CRITERIA_TYPE_ID, PROPOSAL_ITEM_ID FROM O FFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?) 13:54:47,603 DEBUG [ItemCriteriaTypeEntityBean] Executing SQL: SELECT SHORTCUT, LABEL, DESCRIPTION FROM ITEM_CRITERIA_TY PE WHERE (ID=?) 13:54:47,650 DEBUG [OfferProposalItemCriteriaEntityBean] Executing SQL: SELECT CRITERIA_VALUE, CRITERIA_TYPE_ID, PROPOSA L_ITEM_ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?) 13:54:47,697 DEBUG [OfferProposalItemCriteriaEntityBean] Executing SQL: SELECT CRITERIA_TYPE_ID, PROPOSAL_ITEM_ID FROM O FFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?) 13:54:47,743 DEBUG [ItemCriteriaTypeEntityBean] Executing SQL: SELECT SHORTCUT, LABEL, DESCRIPTION FROM ITEM_CRITERIA_TY PE WHERE (ID=?) 13:54:47,806 DEBUG [OfferProposalItemCriteriaEntityBean] Executing SQL: SELECT CRITERIA_VALUE, CRITERIA_TYPE_ID, PROPOSA L_ITEM_ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?) 13:54:47,853 DEBUG [OfferProposalItemCriteriaEntityBean] Executing SQL: SELECT CRITERIA_TYPE_ID, PROPOSAL_ITEM_ID FROM O FFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?) 13:54:47,900 DEBUG [ItemCriteriaTypeEntityBean] Executing SQL: SELECT SHORTCUT, LABEL, DESCRIPTION FROM ITEM_CRITERIA_TY PE WHERE (ID=?) 13:54:47,962 DEBUG [OfferProposalItemCriteriaEntityBean] Executing SQL: SELECT CRITERIA_VALUE, CRITERIA_TYPE_ID, PROPOSA L_ITEM_ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?) 13:54:48,009 DEBUG [OfferProposalItemCriteriaEntityBean] Executing SQL: SELECT CRITERIA_TYPE_ID, PROPOSAL_ITEM_ID FROM O FFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?) 13:54:48,056 DEBUG [ItemCriteriaTypeEntityBean] Executing SQL: SELECT SHORTCUT, LABEL, DESCRIPTION FROM ITEM_CRITERIA_TY PE WHERE (ID=?) 13:54:48,119 INFO [STDOUT] leer 13:54:48,119 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:48,165 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:48,212 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:48,275 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:48,322 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:48,369 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:48,415 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:48,478 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:48,525 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:48,556 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSA L_ITEM_ID=?) 13:54:48,587 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN , RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:48,634 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (P ROPOSAL_ITEM_ID=?) 13:54:48,665 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:48,712 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:48,775 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:48,837 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:48,884 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:48,931 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:48,978 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:49,040 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:49,087 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:49,134 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSA L_ITEM_ID=?) 13:54:49,150 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN , RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:49,197 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (P ROPOSAL_ITEM_ID=?) 13:54:49,228 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:49,275 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:49,337 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:49,384 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:49,431 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:49,478 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:49,540 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:49,587 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:49,634 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:49,681 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSA L_ITEM_ID=?) 13:54:49,712 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN , RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:49,759 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (P ROPOSAL_ITEM_ID=?) 13:54:49,790 DEBUG [OfferProposalItemCriteriaEntityBean] Executing SQL: SELECT CRITERIA_VALUE, CRITERIA_TYPE_ID, PROPOSA L_ITEM_ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?) 13:54:49,837 DEBUG [OfferProposalItemCriteriaEntityBean] Executing SQL: SELECT CRITERIA_TYPE_ID, PROPOSAL_ITEM_ID FROM O FFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?) 13:54:49,884 DEBUG [OfferProposalItemCriteriaEntityBean] Executing SQL: SELECT CRITERIA_VALUE, CRITERIA_TYPE_ID, PROPOSA L_ITEM_ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?) 13:54:49,931 DEBUG [OfferProposalItemCriteriaEntityBean] Executing SQL: SELECT CRITERIA_TYPE_ID, PROPOSAL_ITEM_ID FROM O FFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?) 13:54:49,994 DEBUG [OfferProposalItemCriteriaEntityBean] Executing SQL: SELECT CRITERIA_VALUE, CRITERIA_TYPE_ID, PROPOSA L_ITEM_ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?) 13:54:50,040 DEBUG [OfferProposalItemCriteriaEntityBean] Executing SQL: SELECT CRITERIA_TYPE_ID, PROPOSAL_ITEM_ID FROM O FFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?) 13:54:50,103 DEBUG [OfferProposalItemCriteriaEntityBean] Executing SQL: SELECT CRITERIA_VALUE, CRITERIA_TYPE_ID, PROPOSA L_ITEM_ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?) 13:54:50,150 DEBUG [OfferProposalItemCriteriaEntityBean] Executing SQL: SELECT CRITERIA_TYPE_ID, PROPOSAL_ITEM_ID FROM O FFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?) 13:54:50,197 DEBUG [OfferProposalItemCriteriaEntityBean] Executing SQL: SELECT CRITERIA_VALUE, CRITERIA_TYPE_ID, PROPOSA L_ITEM_ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?) 13:54:50,244 DEBUG [OfferProposalItemCriteriaEntityBean] Executing SQL: SELECT CRITERIA_TYPE_ID, PROPOSAL_ITEM_ID FROM O FFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?) 13:54:50,306 DEBUG [OfferProposalItemCriteriaEntityBean] Executing SQL: SELECT CRITERIA_VALUE, CRITERIA_TYPE_ID, PROPOSA L_ITEM_ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?) 13:54:50,353 DEBUG [OfferProposalItemCriteriaEntityBean] Executing SQL: SELECT CRITERIA_TYPE_ID, PROPOSAL_ITEM_ID FROM O FFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?) 13:54:50,400 DEBUG [OfferProposalItemCriteriaEntityBean] Executing SQL: SELECT CRITERIA_VALUE, CRITERIA_TYPE_ID, PROPOSA L_ITEM_ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?) 13:54:50,447 DEBUG [OfferProposalItemCriteriaEntityBean] Executing SQL: SELECT CRITERIA_TYPE_ID, PROPOSAL_ITEM_ID FROM O FFER_PROPOSAL_ITEM_CRITERIA WHERE (ID=?) 13:54:50,509 INFO [STDOUT] leer 13:54:50,509 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:50,556 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:50,619 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:50,666 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:50,712 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:50,775 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:50,822 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:50,869 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:50,931 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:50,962 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSA L_ITEM_ID=?) 13:54:50,994 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN , RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:51,041 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (P ROPOSAL_ITEM_ID=?) 13:54:51,072 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:51,119 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:51,166 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:51,228 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:51,275 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:51,322 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:51,384 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:51,431 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:51,478 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:51,525 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSA L_ITEM_ID=?) 13:54:51,556 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN , RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:51,587 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (P ROPOSAL_ITEM_ID=?) 13:54:51,619 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:51,666 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:51,728 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:51,775 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:51,837 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:51,884 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:51,931 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:51,994 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:52,041 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:52,072 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSA L_ITEM_ID=?) 13:54:52,119 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN , RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:52,166 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (P ROPOSAL_ITEM_ID=?) 13:54:52,181 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:52,244 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:52,291 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:52,353 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:52,400 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:52,447 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:52,509 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:52,556 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:52,634 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:52,681 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSA L_ITEM_ID=?) 13:54:52,712 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN , RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:52,744 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (P ROPOSAL_ITEM_ID=?) 13:54:52,775 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:52,837 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:52,884 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:52,931 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:52,994 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:53,041 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:53,087 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:53,134 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:53,197 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:53,228 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSA L_ITEM_ID=?) 13:54:53,259 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN , RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:53,306 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (P ROPOSAL_ITEM_ID=?) 13:54:53,337 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:53,384 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:53,431 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:53,478 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:53,541 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:53,588 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:53,634 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:53,681 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:53,744 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:53,775 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSA L_ITEM_ID=?) 13:54:53,806 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN , RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:53,853 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (P ROPOSAL_ITEM_ID=?) 13:54:53,884 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:53,931 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:53,978 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:54,041 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:54,088 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:54,134 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:54,197 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:54,244 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:54,291 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:54,338 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSA L_ITEM_ID=?) 13:54:54,369 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN , RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:54,400 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (P ROPOSAL_ITEM_ID=?) 13:54:54,431 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:54,494 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:54,541 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:54,588 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:54,650 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:54,697 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:54,744 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:54,791 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:54,853 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:54,884 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSA L_ITEM_ID=?) 13:54:54,916 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN , RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:54,963 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (P ROPOSAL_ITEM_ID=?) 13:54:54,994 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:55,041 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:55,088 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:55,150 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:55,197 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:55,244 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:55,291 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:55,353 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:55,400 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:55,447 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSA L_ITEM_ID=?) 13:54:55,478 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN , RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:55,509 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (P ROPOSAL_ITEM_ID=?) 13:54:55,541 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:55,588 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:55,650 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:55,697 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:55,744 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:55,791 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:55,853 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:55,900 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:55,947 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:55,994 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSA L_ITEM_ID=?) 13:54:56,025 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN , RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:56,056 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (P ROPOSAL_ITEM_ID=?) 13:54:56,088 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:56,150 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:56,197 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:56,244 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:56,291 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:56,353 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:56,400 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:56,447 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:56,494 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:56,541 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSA L_ITEM_ID=?) 13:54:56,572 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN , RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:56,619 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (P ROPOSAL_ITEM_ID=?) 13:54:56,650 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:56,697 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:56,744 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:56,791 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:56,853 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:56,900 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:56,947 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:57,010 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:57,056 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:57,103 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSA L_ITEM_ID=?) 13:54:57,135 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN , RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:57,166 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (P ROPOSAL_ITEM_ID=?) 13:54:57,197 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:57,244 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:57,306 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:57,353 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:57,400 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:57,447 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:57,510 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:57,556 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:57,603 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:57,650 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSA L_ITEM_ID=?) 13:54:57,681 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN , RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:57,713 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (P ROPOSAL_ITEM_ID=?) 13:54:57,744 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:57,806 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:57,853 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:57,900 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:57,963 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:58,010 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:58,056 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:58,103 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:58,166 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:58,197 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSA L_ITEM_ID=?) 13:54:58,228 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN , RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:58,275 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (P ROPOSAL_ITEM_ID=?) 13:54:58,306 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:58,353 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:58,416 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:58,463 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:58,510 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:58,572 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:58,619 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:58,666 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:58,713 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:58,760 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSA L_ITEM_ID=?) 13:54:58,791 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN , RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:58,838 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (P ROPOSAL_ITEM_ID=?) 13:54:58,869 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:58,916 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:58,963 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:59,010 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:59,072 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:59,119 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:59,166 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:59,213 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:59,275 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:59,307 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSA L_ITEM_ID=?) 13:54:59,338 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN , RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:59,385 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (P ROPOSAL_ITEM_ID=?) 13:54:59,416 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:59,463 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:59,510 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:59,572 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:59,619 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:59,666 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:59,713 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:59,775 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:54:59,822 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:59,869 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSA L_ITEM_ID=?) 13:54:59,900 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN , RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:54:59,932 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (P ROPOSAL_ITEM_ID=?) 13:54:59,978 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:55:00,025 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:55:00,072 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:55:00,135 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:55:00,182 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:55:00,228 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:55:00,275 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:55:00,322 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:55:00,385 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:55:00,416 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSA L_ITEM_ID=?) 13:55:00,447 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROPOSAL_ID, POSITION, RANK_AFFINITY, RANK_MARGIN , RANK_PRIORITY, PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:55:00,494 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_ITEM_CRITERIA WHERE (P ROPOSAL_ITEM_ID=?) 13:55:00,525 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:55:00,572 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:55:00,635 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:55:00,682 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:55:00,728 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:55:00,791 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:55:00,838 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:55:00,885 DEBUG [OfferProcessEntityBean] Executing SQL: SELECT PROCESS_TYPE_ID FROM OFFER_PROCESS WHERE (ID=?) 13:55:00,932 DEBUG [OfferProposalItemEntityBean] Executing SQL: SELECT PROCESS_ID FROM OFFER_PROPOSAL_ITEM WHERE (ID=?) 13:55:00,978 DEBUG [OfferProposalItemEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_MAPPING WHERE (PROPOSA L_ITEM_ID=?) 13:55:01,010 DEBUG [OfferProposalEntityBean] Executing SQL: SELECT OFFER_CHANNEL_ID, OFFER_TYPE_GROUP_ID, OFFER_TYPE_ID FROM OFFER_PROPOSAL WHERE (ID=?) 13:55:01,057 DEBUG [OfferProposalEntityBean] load relation SQL: SELECT ID FROM OFFER_PROPOSAL_CRITERIA WHERE (PROPOSAL_I D=?) 13:55:01,088 DEBUG [OfferProposalCriteriaEntityBean] Executing SQL: SELECT CRITERIA_VALUE, PROPOSAL_ID, CRITERIA_TYPE_ID FROM OFFER_PROPOSAL_CRITERIA WHERE (ID=?) 13:55:01,135 DEBUG [OfferProposalCriteriaEntityBean] Executing SQL: SELECT PROPOSAL_ID, CRITERIA_TYPE_ID FROM OFFER_PROP OSAL_CRITERIA WHERE (ID=?) 13:55:01,182 DEBUG [CriteriaTypeEntityBean] Executing SQL: SELECT SHORTCUT, LABEL, DESCRIPTION FROM CRITERIA_TYPE WHERE (ID=?) 13:55:01,244 DEBUG [OfferProposalCriteriaEntityBean] Executing SQL: SELECT CRITERIA_VALUE, PROPOSAL_ID, CRITERIA_TYPE_ID FROM OFFER_PROPOSAL_CRITERIA WHERE (ID=?) 13:55:01,291 DEBUG [OfferProposalCriteriaEntityBean] Executing SQL: SELECT PROPOSAL_ID, CRITERIA_TYPE_ID FROM OFFER_PROP OSAL_CRITERIA WHERE (ID=?) 13:55:01,338 DEBUG [CriteriaTypeEntityBean] Executing SQL: SELECT SHORTCUT, LABEL, DESCRIPTION FROM CRITERIA_TYPE WHERE (ID=?) 13:55:01,385 DEBUG [OfferProposalCriteriaEntityBean] Executing SQL: SELECT CRITERIA_VALUE, PROPOSAL_ID, CRITERIA_TYPE_ID FROM OFFER_PROPOSAL_CRITERIA WHERE (ID=?) 13:55:01,447 DEBUG [OfferProposalCriteriaEntityBean] Executing SQL: SELECT PROPOSAL_ID, CRITERIA_TYPE_ID FROM OFFER_PROP OSAL_CRITERIA WHERE (ID=?) 13:55:01,494 DEBUG [CriteriaTypeEntityBean] Executing SQL: SELECT SHORTCUT, LABEL, DESCRIPTION FROM CRITERIA_TYPE WHERE (ID=?) 13:55:01,541 DEBUG [OfferProposalCriteriaEntityBean] Executing SQL: SELECT CRITERIA_VALUE, PROPOSAL_ID, CRITERIA_TYPE_ID FROM OFFER_PROPOSAL_CRITERIA WHERE (ID=?) 13:55:01,588 DEBUG [OfferProposalCriteriaEntityBean] Executing SQL: SELECT PROPOSAL_ID, CRITERIA_TYPE_ID FROM OFFER_PROP OSAL_CRITERIA WHERE (ID=?) 13:55:01,650 DEBUG [CriteriaTypeEntityBean] Executing SQL: SELECT SHORTCUT, LABEL, DESCRIPTION FROM CRITERIA_TYPE WHERE (ID=?) 13:55:01,697 DEBUG [OfferProposalCriteriaEntityBean] Executing SQL: SELECT CRITERIA_VALUE, PROPOSAL_ID, CRITERIA_TYPE_ID FROM OFFER_PROPOSAL_CRITERIA WHERE (ID=?) 13:55:01,744 DEBUG [OfferProposalCriteriaEntityBean] Executing SQL: SELECT PROPOSAL_ID, CRITERIA_TYPE_ID FROM OFFER_PROP OSAL_CRITERIA WHERE (ID=?) 13:55:01,791 DEBUG [CriteriaTypeEntityBean] Executing SQL: SELECT SHORTCUT, LABEL, DESCRIPTION FROM CRITERIA_TYPE WHERE (ID=?) 13:55:01,854 DEBUG [OfferProposalCriteriaEntityBean] Executing SQL: SELECT CRITERIA_VALUE, PROPOSAL_ID, CRITERIA_TYPE_ID FROM OFFER_PROPOSAL_CRITERIA WHERE (ID=?) 13:55:01,900 DEBUG [OfferProposalCriteriaEntityBean] Executing SQL: SELECT PROPOSAL_ID, CRITERIA_TYPE_ID FROM OFFER_PROP OSAL_CRITERIA WHERE (ID=?) 13:55:01,963 DEBUG [CriteriaTypeEntityBean] Executing SQL: SELECT SHORTCUT, LABEL, DESCRIPTION FROM CRITERIA_TYPE WHERE (ID=?) 13:55:02,010 DEBUG [OfferProposalCriteriaEntityBean] Executing SQL: SELECT CRITERIA_VALUE, PROPOSAL_ID, CRITERIA_TYPE_ID FROM OFFER_PROPOSAL_CRITERIA WHERE (ID=?) 13:55:02,057 DEBUG [OfferProposalCriteriaEntityBean] Executing SQL: SELECT PROPOSAL_ID, CRITERIA_TYPE_ID FROM OFFER_PROP OSAL_CRITERIA WHERE (ID=?) 13:55:02,119 DEBUG [CriteriaTypeEntityBean] Executing SQL: SELECT SHORTCUT, LABEL, DESCRIPTION FROM CRITERIA_TYPE WHERE (ID=?) 13:55:02,166 DEBUG [OfferProposalCriteriaEntityBean] Executing SQL: SELECT CRITERIA_VALUE, PROPOSAL_ID, CRITERIA_TYPE_ID FROM OFFER_PROPOSAL_CRITERIA WHERE (ID=?) 13:55:02,213 DEBUG [OfferProposalCriteriaEntityBean] Executing SQL: SELECT PROPOSAL_ID, CRITERIA_TYPE_ID FROM OFFER_PROP OSAL_CRITERIA WHERE (ID=?) 13:55:02,260 DEBUG [CriteriaTypeEntityBean] Executing SQL: SELECT SHORTCUT, LABEL, DESCRIPTION FROM CRITERIA_TYPE WHERE (ID=?) 13:55:02,322 DEBUG [OfferProposalEntityBean] Executing SQL: SELECT OFFER_CHANNEL_ID, OFFER_TYPE_GROUP_ID, OFFER_TYPE_ID FROM OFFER_PROPOSAL WHERE (ID=?) 13:55:02,369 DEBUG [OfferProposalEntityBean] Executing SQL: SELECT OFFER_CHANNEL_ID, OFFER_TYPE_GROUP_ID, OFFER_TYPE_ID FROM OFFER_PROPOSAL WHERE (ID=?) 13:55:02,416 DEBUG [OfferProposalEntityBean] Executing SQL: SELECT OFFER_CHANNEL_ID, OFFER_TYPE_GROUP_ID, OFFER_TYPE_ID FROM OFFER_PROPOSAL WHERE (ID=?) 13:55:02,479 DEBUG [OfferChannelEntityBean] Executing SQL: SELECT SHORTCUT FROM OFFER_CHANNEL WHERE (ID=?) 13:55:02,525 DEBUG [OfferProposalEntityBean] Executing SQL: SELECT OFFER_CHANNEL_ID, OFFER_TYPE_GROUP_ID, OFFER_TYPE_ID FROM OFFER_PROPOSAL WHERE (ID=?) 13:55:02,572 DEBUG [OfferTypeEntityBean] Executing SQL: SELECT SHORTCUT FROM OFFER_TYPE WHERE (ID=?) 13:55:02,666 DEBUG [OfferProposalEntityBean] Executing SQL: SELECT OFFER_CHANNEL_ID, OFFER_TYPE_GROUP_ID, OFFER_TYPE_ID FROM OFFER_PROPOSAL WHERE (ID=?) 13:55:02,713 DEBUG [OfferTypeGroupEntityBean] Executing SQL: SELECT SHORTCUT FROM OFFER_TYPE_GROUP WHERE (ID=?) 13:55:02,760 DEBUG [OfferProposalEntityBean] Executing SQL: SELECT OFFER_CHANNEL_ID, OFFER_TYPE_GROUP_ID, OFFER_TYPE_ID FROM OFFER_PROPOSAL WHERE (ID=?) 13:55:02,822 DEBUG [OfferProposalEntityBean] Executing SQL: SELECT OFFER_CHANNEL_ID, OFFER_TYPE_GROUP_ID, OFFER_TYPE_ID FROM OFFER_PROPOSAL WHERE (ID=?) 13:55:02,869 DEBUG [OfferProposalEntityBean] Executing SQL: SELECT OFFER_CHANNEL_ID, OFFER_TYPE_GROUP_ID, OFFER_TYPE_ID FROM OFFER_PROPOSAL WHERE (ID=?) 13:55:02,916 DEBUG [OfferProposalEntityBean] Executing SQL: SELECT OFFER_CHANNEL_ID, OFFER_TYPE_GROUP_ID, OFFER_TYPE_ID FROM OFFER_PROPOSAL WHERE (ID=?) 13:55:02,979 DEBUG [OfferProposalEntityBean] Executing SQL: SELECT OFFER_CHANNEL_ID, OFFER_TYPE_GROUP_ID, OFFER_TYPE_ID FROM OFFER_PROPOSAL WHERE (ID=?)