Hi I'm seeing the OnePageCheckout system create foreign key conflicts with regard to the telecom_number field...
OnePageCheckout... Enter telecom_number Service creates telecom_number id's 18051, 18052, and 18053. 18051 is null 18052 and 18053 are duplicated. --------- Later during quick ship: 2009-01-05 13:46:58,497 (TP-Processor1) [ GenericDelegator.java:812:ERROR] ---- exception report ---------------------------------------------------------- Failure in create operation for entity [ShipmentRouteSegment]: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:$ violates foreign key constraint "shpmt_rtseg_dtcn" Detail: Key (dest_telecom_number_id)=(18051) is not present in table "telecom_number".)). Rolling back transaction. Exception: org.ofbiz.entity.GenericEntityException Message: Error while inserting: [GenericEntity:ShipmentRouteSegment][carrierPartyId,USPS(java.lang.String)][carrierServiceStatusId,SHRSCS_NOT_$ Detail: Key (dest_telecom_number_id)=(18051) is not present in table "telecom_number".)) ---- cause --------------------------------------------------------------------- Exception: org.ofbiz.entity.GenericDataSourceException Message: SQL Exception while executing the following:INSERT INTO public.SHIPMENT_ROUTE_SEGMENT (SHIPMENT_ID, SHIPMENT_ROUTE_SEGMENT_ID, DELIVE$ Detail: Key (dest_telecom_number_id)=(18051) is not present in table "telecom_number".) --------------------------------------------------- Telecom_number Created: 2009-01-04 21:47:39,763 (TP-Processor1) [ ControlServlet.java:93 :INFO ] The character encoding of the request is: [UTF-8]. The character encoding we will use for the request and response is: [UTF-8] 2009-01-04 21:47:39,897 (TP-Processor1) [ JkInputStream.java:196:INFO ] Receiving: getting request body chunk 630 630 2009-01-04 21:47:39,925 (TP-Processor1) [ RequestHandler.java:251:INFO ] [Processing Request]: createUpdateBillingAndPayment sessionId=92C90C69C909CCE895D6EB77D01225A1.jvm1 2009-01-04 21:47:39,927 (TP-Processor1) [ Log.java:110:INFO ] [CustomerEvents.xml#setAnonUserLogin] userLogin is [GenericEntity:UserLogin][createdStamp,2009-01-04 21:39:01.149(java.sql.Timestamp)][createdTxStamp,2009-01-04 21:39:00.888 (java.sql.Timestamp)][currentPassword,{SHA}924167c5a254d33bd7425389aae51c6b26e52534(java.lang.String)][disabledDateTime,null()] [enabled,null()][hasLoggedOut,null()][isSystem,null()][lastCurrencyUom,null()][lastLocale,null()][lastTimeZone,null()] [lastUpdatedStamp,2009-01-04 21:39:01.149(java.sql.Timestamp)][lastUpdatedTxStamp,2009-01-04 21:39:00.888(java.sql.Timestamp)] [partyId,12971(java.lang.String)][passwordHint,Please Use the Forgot Password Feature(java.lang.String)] [requirePasswordChange,null()][successiveFailedLogins,null()][userLdapDn,null()][userLoginId,lizmcg...@aol.com(java.lang.String)] 2009-01-04 21:47:39,927 (TP-Processor1) [ SimpleMethod.java:797:INFO ] No response code string or errors found, assuming success; returning code [success] 2009-01-04 21:47:39,938 (TP-Processor1) [ Log.java:110:INFO ] [PartyContactMechServices.xml#createPartyTelecomNumber] Creating telecom number 2009-01-04 21:47:39,957 (TP-Processor1) [ Log.java:110:INFO ] [ContactMechServices.xml#createContactMech] Contact mech created with id 18053 2009-01-04 21:47:40,029 (TP-Processor1) [ Log.java:110:INFO ] [PartyContactMechServices.xml#createPartyTelecomNumber] Copied id to createPartyContactMechMap: 18053 2009-01-04 21:47:40,043 (TP-Processor1) [ Log.java:110:INFO ] [PartyContactMechServices.xml#createPartyContactMech] Creating a PartyContactMech with id: 18053 2009-01-04 21:47:40,086 (TP-Processor1) [ ServiceEcaRule.java:150:INFO ] Running Service ECA Service: createPartyContactMechPurpose, triggered by rule on Service: createPartyContactMech 2009-01-04 21:47:40,105 (TP-Processor1) [ Log.java:110:INFO ] [PartyServices.xml#createUpdateTelecomNumber] Phone Contact created phoneContactMechId is 18053 2009-01-04 21:47:40,108 (TP-Processor1) [ ServiceEcaRule.java:150:INFO ] Running Service ECA Service: buildCcExpireDate, triggered by rule on Service: createCreditCard 2009-01-04 21:47:40,154 (TP-Processor1) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [PaymentMethod]; curSeqId=12900, maxSeqId=12910, bankSize=10 2009-01-04 21:47:40,331 (TP-Processor1) [ ServiceEcaRule.java:150:INFO ] Running Service ECA Service: verifyCreditCard, triggered by rule on Service: createCreditCard