OFBiz › OFBiz - Dev

Dev - Various Small Issues

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

5 messages Options

Daniel Kunkel

Dev - Various Small Issues

Hi

I want to thank Contegix for picking up the slack and getting the OFBiz
mailing lists up and running again so quickly!

Regarding the new lists, Now please forgive me if I'm blind... but I
just can't see how to search the mailing lists anymore...

I wanted to check them before asking the next few questions...

---

I get an error:

WARNING: Service updateTrackingCodeType is defined more than once, most
recent will over-write previous definition(s)

--

I got an error:

(ERROR: payment_pmtyp referential integrity violation - key referenced
from payment not found in payment_type))))]

It seems as though CUSTOMER_PAYMENT is not a seed value type if I've
figured everything correctly...

Or is there a better solution?

--

I'm getting this error when I try to quick ship orders...

ERROR: Could not complete the Sub-method used by quickShip methods to
create a shipment
[file:/wrk/bwbiz/ofbiz/applications/product/script/org/ofbiz/shipment/shipment/ShipmentServices.xml#createShipmentForFacilityAndShipGroup] process [problem invoking the [updateShipment] service with the map named [packedContext] containing [[shipmentId=10207, statusId=SHIPMENT_SHIPPED, userLogin=[GenericEntity:UserLogin][createdStamp,2005-03-19 13:54:59.054(java.sql.Timestamp)][createdTxStamp,2005-03-19 13:54:58.882(java.sql.Timestamp)][currentPassword,ca452b4784d85039b58d82cb0c78c11ae4c1aa4c(java.lang.String)][disabledDateTime,null()][enabled,Y(java.lang.String)][hasLoggedOut,N(java.lang.String)][isSystem,null()][lastCurrencyUom,null()][lastLocale,null()][lastUpdatedStamp,2005-12-13 11:12:22.064(java.sql.Timestamp)][lastUpdatedTxStamp,2005-12-13 11:12:22.063(java.sql.Timestamp)][partyId,10010(java.lang.String)][passwordHint,Cheapest(java.lang.String)][successiveFailedLogins,null()][userLoginId,[hidden email](java.lang.String)], locale=en_US]]: Problems with the transaction. (Service target threw an unexpected exception (null))]

Thanks

_______________________________________________
Dev mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/dev

Daniel Kunkel

Re: Dev - Various Small Issues

Hi

Update...

The payment_pmtyp referential integrity violation was operator error...
Please ignore.

Thanks

--
Daniel

*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-
Have a GREAT Day!

Daniel Kunkel [hidden email]
BioWaves, LLC http://www.BioWaves.com
14150 NE 20th St. Suite F1
Bellevue, WA 98007
800-734-3588 425-895-0050
http://www.WizCity.com http://www.Illusion-Optical.com
*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-

payment_pmtyp referential integrity violation

_______________________________________________
Dev mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/dev

Jacopo Cappellato

Re: Dev - Various Small Issues

In reply to this post by Daniel Kunkel

Daniel,

please see my comments inline:

Daniel Kunkel wrote:

> Hi
>
> I want to thank Contegix for picking up the slack and getting the OFBiz
> mailing lists up and running again so quickly!
>
> Regarding the new lists, Now please forgive me if I'm blind... but I
> just can't see how to search the mailing lists anymore...
>
> I wanted to check them before asking the next few questions...
>
> ---
>
> I get an error:
>
> WARNING: Service updateTrackingCodeType is defined more than once, most
> recent will over-write previous definition(s)
>

I've removed the duplicated definition of the "updateTrackingCodeType"
service in rev. 6464.
Thanks for the bug report.

> --
>
> I got an error:
>
> (ERROR: payment_pmtyp referential integrity violation - key referenced
> from payment not found in payment_type))))]
>
> It seems as though CUSTOMER_PAYMENT is not a seed value type if I've
> figured everything correctly...
>
>

Hmmm... this is strange. In the SVN version of the accounting's seed
data (applications/accounting/data/AccountingTypeData.xml) the
CUSTOMER_PAYMENT is present:

<PaymentType description="Receipt" hasTable="N" parentTypeId=""
paymentTypeId="RECEIPT"/>
<PaymentType description="Customer Payment" hasTable="N"
parentTypeId="RECEIPT" paymentTypeId="CUSTOMER_PAYMENT"/>
<PaymentType description="Customer Deposit" hasTable="N"
parentTypeId="RECEIPT" paymentTypeId="CUSTOMER_DEPOSIT"/>

Could you please verify if that file is up to date in your workin directory?
Daniel, what about your yesterday's issues? Have you resolved them?

Jacopo

>
> Or is there a better solution?
>
> --
>
>
> I'm getting this error when I try to quick ship orders...
>
> ERROR: Could not complete the Sub-method used by quickShip methods to
> create a shipment
> [file:/wrk/bwbiz/ofbiz/applications/product/script/org/ofbiz/shipment/shipment/ShipmentServices.xml#createShipmentForFacilityAndShipGroup] process [problem invoking the [updateShipment] service with the map named [packedContext] containing [[shipmentId=10207, statusId=SHIPMENT_SHIPPED, userLogin=[GenericEntity:UserLogin][createdStamp,2005-03-19 13:54:59.054(java.sql.Timestamp)][createdTxStamp,2005-03-19 13:54:58.882(java.sql.Timestamp)][currentPassword,ca452b4784d85039b58d82cb0c78c11ae4c1aa4c(java.lang.String)][disabledDateTime,null()][enabled,Y(java.lang.String)][hasLoggedOut,N(java.lang.String)][isSystem,null()][lastCurrencyUom,null()][lastLocale,null()][lastUpdatedStamp,2005-12-13 11:12:22.064(java.sql.Timestamp)][lastUpdatedTxStamp,2005-12-13 11:12:22.063(java.sql.Timestamp)][partyId,10010(java.lang.String)][passwordHint,Cheapest(java.lang.String)][successiveFailedLogins,null()][userLoginId,[hidden email](java.lang.String)], locale=en_US]]: Problems with the

transaction. (Service target threw an unexpected exception (null))]

>
> Thanks
>
>
>
>
> _______________________________________________
> Dev mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/dev
>

_______________________________________________
Dev mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/dev

Daniel Kunkel

Re: Dev - Various Small Issues

Hi Jacopo

I've been working to update my OFBiz instance, and although I've found
and fix many things, I'm still having quite a few issues.

---

Data Export

This is still failing for me. I have an idea that it may be related to
an incompatibility between postgres 7.3.10 and the svn postgres driver
for 8.0. A log is available.

----
> I got an error:
>
> (ERROR: payment_pmtyp referential integrity violation - key referenced
> from payment not found in payment_type))))]
>
> It seems as though CUSTOMER_PAYMENT is not a seed value type if I've
> figured everything correctly...

This was my fault... Luckily I was easily able to just delete the table
and reseed.

However, this brings up a big issue I'd love some feedback on.

Changing Primary Key's in a table populated hundreds of user records
seems to make upgrading quite a challenge. Is there an easier way than:

1.) Turning off referential integrity
2.) export/rename table in question
3.) restart/recreate new table
4.) copy/import data from copy made in step 2.
5.) turn back on referential integrity.

Is there an easy way to disable the rest of OFBiz while performing steps
3, 4 and 5?

---

Finally, I'm still getting the third error I mentioned when I try to
ship some old orders. I'm not too worried about it since new orders
seem to be working OK.

Thanks

--
Daniel

*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-
Have a GREAT Day!

Daniel Kunkel [hidden email]
BioWaves, LLC http://www.BioWaves.com
14150 NE 20th St. Suite F1
Bellevue, WA 98007
800-734-3588 425-895-0050
http://www.WizCity.com http://www.Illusion-Optical.com
*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-

Daniel,

please see my comments inline:

Daniel Kunkel wrote:

I've removed the duplicated definition of the "updateTrackingCodeType"
service in rev. 6464.
Thanks for the bug report.

transaction. (Service target threw an unexpected exception (null))]

>
> Thanks
>
>
>
>
> _______________________________________________
> Dev mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/dev
>

_______________________________________________
Dev mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/dev

_______________________________________________
Dev mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/dev

David E. Jones

Re: Dev - Various Small Issues

On Jan 4, 2006, at 12:21 AM, Daniel Kunkel wrote:

> However, this brings up a big issue I'd love some feedback on.
>
> Changing Primary Key's in a table populated hundreds of user records
> seems to make upgrading quite a challenge. Is there an easier way
> than:
>
> 1.) Turning off referential integrity
> 2.) export/rename table in question
> 3.) restart/recreate new table
> 4.) copy/import data from copy made in step 2.
> 5.) turn back on referential integrity.
>
> Is there an easy way to disable the rest of OFBiz while performing
> steps
> 3, 4 and 5?

Yeah, this sort of database change is never easy, especially when
there are combinations of primary keys and foreign keys to deal with,
and when you have to manufacture new data to get everything filled in
and such... This is why the Entity Engine just warns about this sort
of error and doesn't actually try to fix it automatically. For more
critical databases that should only really be done by a qualified DBA
or engineer with experience doing such things.

For anything running from OFBiz the best thing to do is usually to
hit the database from a maintenance box rather than the production
box so that the public facing site is not available. This can be a
development box or in more formal environments a testing or staging
box. The DB maintenance tools in OFBiz are still pretty basic and not
at all meant to replace the more granular changes possible with any
good DB management tool. For example, removing all primary keys is
usually a bad thing and DBAs don't like it unless it is a database
they've never touched, well maybe not, some people like global rules
regardless of circumstance.... ;)

-David

_______________________________________________
Dev mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/dev