Hi We're having a significant problem with a lot of garbage data appearing in our database.
In one case, we cannot quick ship anything since the quick_ship algorithm cannot correctly access the telephone number. In the below example, 18132 represents a postal address. Failure in create operation for entity [ShipmentRouteSegment]: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ShipmentRouteSegment] ... VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: insert or update on table "shipment_route_segment" violates foreign key constraint "shpmt_rtseg_dtcn" Detail: Key (dest_telecom_number_id)=(18132) is not present in table "telecom_number".)). Rolling back transaction.org.ofbiz.entity.GenericEntityException: Error while inserting: --------------- The same party has had their name updated 5 times for no apparent reason. We're running a modified version of svn trunk, -r731728 Is anyone else seeing errors this? Daniel On Mon, 2009-01-05 at 19:54 -0800, Daniel Kunkel wrote: > 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 > > > > > > >