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,[email protected](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
