Empty contactmech entries leads to fk error

[Daniel Kunkel]

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

[Daniel Kunkel]

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