[jira] [Commented] (OFBIZ-5345) Cannot pick or pack shipment for mutiple sales orders
[ https://issues.apache.org/jira/browse/OFBIZ-5345?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13875846#comment-13875846 ] Jacques Le Roux commented on OFBIZ-5345: This is only in R12.04? Cannot pick or pack shipment for mutiple sales orders - Key: OFBIZ-5345 URL: https://issues.apache.org/jira/browse/OFBIZ-5345 Project: OFBiz Issue Type: Bug Components: order Affects Versions: Release Branch 12.04 Reporter: Christian Carlow Attachments: InvoiceServices.java.patch, InvoiceServices.xml.patch, OFBIZ-5345.patch I get this error when trying to change the statusId of a shipment to picked or packed: Error calling event: org.ofbiz.webapp.event.EventHandlerException: Service invocation error (Could not commit transaction for service [updateShipment] call: Roll back error, could not commit transaction, was rolled back instead because of: Failure in create operation for entity [InvoiceRole]: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:InvoiceRole][createdStamp,2013-10-09 13:13:57.498(java.sql.Timestamp)][createdTxStamp,2013-10-09 13:13:49.522(java.sql.Timestamp)][datetimePerformed,2013-10-09 13:13:57.498(java.sql.Timestamp)][invoiceId,CI6(java.lang.String)][lastUpdatedStamp,2013-10-09 13:13:57.498(java.sql.Timestamp)][lastUpdatedTxStamp,2013-10-09 13:13:49.522(java.sql.Timestamp)][partyId,DemoCustCompany(java.lang.String)][roleTypeId,PLACING_CUSTOMER(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.INVOICE_ROLE (INVOICE_ID, PARTY_ID, ROLE_TYPE_ID, DATETIME_PERFORMED, PERCENTAGE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint pk_invoice_rolebr/ Detail: Key (invoice_id, party_id, role_type_id)=(CI6, DemoCustCompany, PLACING_CUSTOMER) already exists.)). Rolling back transaction.org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:InvoiceRole][createdStamp,2013-10-09 13:13:57.498(java.sql.Timestamp)][createdTxStamp,2013-10-09 13:13:49.522(java.sql.Timestamp)][datetimePerformed,2013-10-09 13:13:57.498(java.sql.Timestamp)][invoiceId,CI6(java.lang.String)][lastUpdatedStamp,2013-10-09 13:13:57.498(java.sql.Timestamp)][lastUpdatedTxStamp,2013-10-09 13:13:49.522(java.sql.Timestamp)][partyId,DemoCustCompany(java.lang.String)][roleTypeId,PLACING_CUSTOMER(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.INVOICE_ROLE (INVOICE_ID, PARTY_ID, ROLE_TYPE_ID, DATETIME_PERFORMED, PERCENTAGE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint pk_invoice_rolebr/ Detail: Key (invoice_id, party_id, role_type_id)=(CI6, DemoCustCompany, PLACING_CUSTOMER) already exists.)) (Error while inserting: [GenericEntity:InvoiceRole][createdStamp,2013-10-09 13:13:57.498(java.sql.Timestamp)][createdTxStamp,2013-10-09 13:13:49.522(java.sql.Timestamp)][datetimePerformed,2013-10-09 13:13:57.498(java.sql.Timestamp)][invoiceId,CI6(java.lang.String)][lastUpdatedStamp,2013-10-09 13:13:57.498(java.sql.Timestamp)][lastUpdatedTxStamp,2013-10-09 13:13:49.522(java.sql.Timestamp)][partyId,DemoCustCompany(java.lang.String)][roleTypeId,PLACING_CUSTOMER(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.INVOICE_ROLE (INVOICE_ID, PARTY_ID, ROLE_TYPE_ID, DATETIME_PERFORMED, PERCENTAGE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint pk_invoice_rolebr/ Detail: Key (invoice_id, party_id, role_type_id)=(CI6, DemoCustCompany, PLACING_CUSTOMER) already exists. The createInvoiceForOrder service is called for each orderId in createInvoicesFromShipments of InvoiceServices.java but the createInvoiceForOrder calls createInvoiceRole which attempts to insert the OrderRoles associated with the orderId which causes primary key violations. -- This message was sent by Atlassian JIRA (v6.1.5#6160)
[jira] [Created] (OFBIZ-5501) ImageManagementServices.createContentAndDataResource() method might uses DataResource.dataResourceName field to store too long names
Jacques Le Roux created OFBIZ-5501: -- Summary: ImageManagementServices.createContentAndDataResource() method might uses DataResource.dataResourceName field to store too long names Key: OFBIZ-5501 URL: https://issues.apache.org/jira/browse/OFBIZ-5501 Project: OFBiz Issue Type: Bug Components: product Affects Versions: Release Branch 11.04, SVN trunk, Release Branch 12.04, Release Branch 13.07 Reporter: Jacques Le Roux So you get this kind of errors: ERROR 22001: A truncation error was encountered trying to shrink VARCHAR 'D:\projectsASF\ofbizClean\framework\images\webapp\images\pro' to length 100. org.apache.derby.iapi.error.StandardException.newException(Unknown Source) -- This message was sent by Atlassian JIRA (v6.1.5#6160)
Re: Framework Refactor - Revisited
Using Moqui was suggested in the links I posted, but no one has done anything about it. Like I said, The goal would be to start over from scratch - using sound design principles and the lessons learned from the current code. Moqui copies problems from our existing framework, I want to fix them. Adrian Crum Sandglass Software www.sandglass-software.com On 1/18/2014 8:26 PM, Hans Bakker wrote: Adrian, My position is that OFBiz will probably last another 10-20 years and i am not in favor of big changes in the OFBiz framework and certainly are against replacing it unless it is Moqui. When i think the Moqui framework is ready to take over, we will slowly move GrowERP and our customers using OFBiz to using Moqui. I think it would be really a pity if you start your own framework, I would suggest to work together with David and join forces. Getting a new framework into the market will be really hard work and competing with Moqui you sure will get a difficult time. We from AntWebsystems certainly will help in the Mantle/Moqui development in the next few years Regards, Hans On 19/01/14 04:11, Adrian Crum wrote: Some years ago we engaged in a discussion about rewriting the OFBiz framework: http://mail-archives.apache.org/mod_mbox/ofbiz-dev/201203.mbox/%3c4f4f51da.50...@sandglass-software.com%3E Then a suggestion was made to base OFBiz on the Moqui framework: http://mail-archives.apache.org/mod_mbox/ofbiz-dev/201203.mbox/%3c4f617965.4010...@me.com%3E Since those discussions, progress has been made in rewriting bits and pieces of the framework, but no one has tackled replacing the framework entirely. I am ready to begin that effort. My preference would be to create a branch and start building things out there - with the help of others. The goal would be to start over from scratch - using sound design principles and the lessons learned from the current code. If there is support for this effort, then I can begin working on it in February. If not, then I will most likely start a separate project - similar to the approach taken by Moqui. I created a design document: https://cwiki.apache.org/confluence/display/OFBADMIN/Another+Framework+Vision It is in the draft stage. Comments and suggestions are welcome.
Re: Discussion: Potential Data Model Improvements
On Saturday, January 18, 2014 5:34 PM, pierre.sm...@gmail.com wrote Indeed, doing cleanups in the data model is a major feat requiring awareness, focus and coordination. But not putting these improvement issues on the docket (roadmap) will ensure that the suggestions (discussion items) done in this thread will be overwhelmed by other threads and keep recurring as discussion topics not addressed. But also the perception of (potential) organisations, that investing in (the implementation of) OFBiz is a valid option, will wither and die. I tend to agree After incorporating these improvement issues in the roadmap, associated JIRA issues can be created to discuss impact in detail, increase awareness of impact and dependencies, and integration can be planned. In stead of muddling along on the path where we are now. We could discuss it again, but IIRW the path is: 1) Discuss ideas/concepts, define/refine requirements/data-models on dev ML (simply because it's faster and easier for most, if not all of us, at the ASF Jira and Confluence can be slow...) 2) Write them in Confluence 3) Open corresponding Jira issues (grouping them can help, how to group depends but sub-tasks sounds easier to me) If the community would embark on the endeavour regarding the cleanup the data model, services and ui aspects, it would warrant a new branch of trunk leading to new version of OFBiz. Premature, we should before estimate who wants to do what, the bottleneck as always been the manpower. I noted we should prune https://cwiki.apache.org/confluence/display/OFBADMIN/New+Features+Roadmap+-+Living+Document Future is still not a priority to me (hopefully soon). I'm still in cleaning and securing stuff. I believe that this could also recharge the community to interact more and even grow. Otherwise this project will not live long enough to celebrate a second decade. It would be a pity. Things like node.js and AKKA are quickly gaining interest (for good reasons). Still all those lack what OFBiz framework has around it (even is not perfect). Jacques Pierre Smits *ORRTIZ.COM http://www.orrtiz.com* Services Solutions for Cloud- Based Manufacturing, Professional Services and Retail Trade http://www.orrtiz.com On Sat, Jan 18, 2014 at 11:04 AM, David E. Jones d...@me.com wrote: Doing significant data model cleanups and changes is a LOT of work with a large code base and user community. All code that uses the data structure needs to be changes, and accommodations are needed for deprecating the old entity or fields and migrating data to the new ones. So yes, to the point Jacques made, it's not likely short-term and without significant investment and coordination with others in the community it is not really likely long-term either. For years I built up a list of changes that would be nice to do in OFBiz itself, but so many are not really feasible. There may still be some of them worth doing, so for some ideas to consider here are my change notes for the Mantle data model: https://github.com/jonesde/mantle/blob/master/mantle-udm/Planning.txt At this point there are lots of generic services and end-to-end automated tests that use many of these changes to the data structures so they are pretty well vetted and validated and not just theoretical like when this thread started a couple years ago. One of the benefits to many of these changes is that not only is the data model smaller and cleaner, but it makes it possible to simplify or eliminate large amounts of logic layer code. For OFBiz, along the lines of the reasons mentioned above, that would involve quite a few code changes but maybe the best way to look at it is that this is the main reason to do the data model changes (ie simplifying and eliminating code) as opposed to just changing the data model for the sake of the data model itself. -David On Jan 17, 2014, at 4:57 AM, Jacques Le Roux jacques.le.r...@les7arts.com wrote: I think it's still alive, but I bet it will not be short-term... Jacques On Friday, January 17, 2014 12:34 PM, pierre.sm...@gmail.com wrote Is this subject still valid? And wouldn't it be great to have one (or some) of the subjects on the (short-term) roadmap? Regards, Pierre Smits *ORRTIZ.COM http://www.orrtiz.com* Services Solutions for Cloud- Based Manufacturing, Professional Services and Retail Trade http://www.orrtiz.com
Re: Tomcat and Websocket
Like for instance dynamic messages sent to UI (called -- Last system notes -- on top of OFBiz backend pages) ? Jacques On Sunday, January 12, 2014 8:52 PM, e...@brainfood.com wrote I have played with it some. It would be really fun to do some things with the entity cache and webforms to automatically update views when data changes. - Jacques Le Roux jacques.le.r...@les7arts.com wrote: I just upgraded Tomcat. Doing so I spotted tomcat7-websocket.jar and websocket-api.jar (that we have not embedded) I have not worked with Websocket yet, I wonder if someone did?
Re: Tomcat and Websocket
Or, if you were currently looking at a party and someone updated their address that you would immediately see it without reloading. - Jacques Le Roux jacques.le.r...@les7arts.com wrote: Like for instance dynamic messages sent to UI (called -- Last system notes -- on top of OFBiz backend pages) ? Jacques On Sunday, January 12, 2014 8:52 PM, e...@brainfood.com wrote I have played with it some. It would be really fun to do some things with the entity cache and webforms to automatically update views when data changes. -- Ean Schuessler, CTO e...@brainfood.com 214-720-0700 x 315 Brainfood, Inc. http://www.brainfood.com
Re: Framework Refactor - Revisited
+1 on finalizing Another Framework Vision document in cwiki +1 on: refactoring in a new branch. +1 on: with the help from others Pierre Smits *ORRTIZ.COM http://www.orrtiz.com* Services Solutions for Cloud- Based Manufacturing, Professional Services and Retail Trade http://www.orrtiz.com On Sat, Jan 18, 2014 at 10:11 PM, Adrian Crum adrian.c...@sandglass-software.com wrote: Some years ago we engaged in a discussion about rewriting the OFBiz framework: http://mail-archives.apache.org/mod_mbox/ofbiz-dev/201203. mbox/%3c4f4f51da.50...@sandglass-software.com%3E Then a suggestion was made to base OFBiz on the Moqui framework: http://mail-archives.apache.org/mod_mbox/ofbiz-dev/201203. mbox/%3c4f617965.4010...@me.com%3E Since those discussions, progress has been made in rewriting bits and pieces of the framework, but no one has tackled replacing the framework entirely. I am ready to begin that effort. My preference would be to create a branch and start building things out there - with the help of others. The goal would be to start over from scratch - using sound design principles and the lessons learned from the current code. If there is support for this effort, then I can begin working on it in February. If not, then I will most likely start a separate project - similar to the approach taken by Moqui. I created a design document: https://cwiki.apache.org/confluence/display/OFBADMIN/ Another+Framework+Vision It is in the draft stage. Comments and suggestions are welcome. -- Adrian Crum Sandglass Software www.sandglass-software.com
[jira] [Updated] (OFBIZ-5345) Cannot pick or pack shipment for mutiple sales orders
[ https://issues.apache.org/jira/browse/OFBIZ-5345?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Christian Carlow updated OFBIZ-5345: Affects Version/s: SVN trunk Cannot pick or pack shipment for mutiple sales orders - Key: OFBIZ-5345 URL: https://issues.apache.org/jira/browse/OFBIZ-5345 Project: OFBiz Issue Type: Bug Components: order Affects Versions: SVN trunk, Release Branch 12.04 Reporter: Christian Carlow Attachments: InvoiceServices.java.patch, InvoiceServices.xml.patch, OFBIZ-5345.patch I get this error when trying to change the statusId of a shipment to picked or packed: Error calling event: org.ofbiz.webapp.event.EventHandlerException: Service invocation error (Could not commit transaction for service [updateShipment] call: Roll back error, could not commit transaction, was rolled back instead because of: Failure in create operation for entity [InvoiceRole]: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:InvoiceRole][createdStamp,2013-10-09 13:13:57.498(java.sql.Timestamp)][createdTxStamp,2013-10-09 13:13:49.522(java.sql.Timestamp)][datetimePerformed,2013-10-09 13:13:57.498(java.sql.Timestamp)][invoiceId,CI6(java.lang.String)][lastUpdatedStamp,2013-10-09 13:13:57.498(java.sql.Timestamp)][lastUpdatedTxStamp,2013-10-09 13:13:49.522(java.sql.Timestamp)][partyId,DemoCustCompany(java.lang.String)][roleTypeId,PLACING_CUSTOMER(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.INVOICE_ROLE (INVOICE_ID, PARTY_ID, ROLE_TYPE_ID, DATETIME_PERFORMED, PERCENTAGE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint pk_invoice_rolebr/ Detail: Key (invoice_id, party_id, role_type_id)=(CI6, DemoCustCompany, PLACING_CUSTOMER) already exists.)). Rolling back transaction.org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:InvoiceRole][createdStamp,2013-10-09 13:13:57.498(java.sql.Timestamp)][createdTxStamp,2013-10-09 13:13:49.522(java.sql.Timestamp)][datetimePerformed,2013-10-09 13:13:57.498(java.sql.Timestamp)][invoiceId,CI6(java.lang.String)][lastUpdatedStamp,2013-10-09 13:13:57.498(java.sql.Timestamp)][lastUpdatedTxStamp,2013-10-09 13:13:49.522(java.sql.Timestamp)][partyId,DemoCustCompany(java.lang.String)][roleTypeId,PLACING_CUSTOMER(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.INVOICE_ROLE (INVOICE_ID, PARTY_ID, ROLE_TYPE_ID, DATETIME_PERFORMED, PERCENTAGE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint pk_invoice_rolebr/ Detail: Key (invoice_id, party_id, role_type_id)=(CI6, DemoCustCompany, PLACING_CUSTOMER) already exists.)) (Error while inserting: [GenericEntity:InvoiceRole][createdStamp,2013-10-09 13:13:57.498(java.sql.Timestamp)][createdTxStamp,2013-10-09 13:13:49.522(java.sql.Timestamp)][datetimePerformed,2013-10-09 13:13:57.498(java.sql.Timestamp)][invoiceId,CI6(java.lang.String)][lastUpdatedStamp,2013-10-09 13:13:57.498(java.sql.Timestamp)][lastUpdatedTxStamp,2013-10-09 13:13:49.522(java.sql.Timestamp)][partyId,DemoCustCompany(java.lang.String)][roleTypeId,PLACING_CUSTOMER(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.INVOICE_ROLE (INVOICE_ID, PARTY_ID, ROLE_TYPE_ID, DATETIME_PERFORMED, PERCENTAGE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint pk_invoice_rolebr/ Detail: Key (invoice_id, party_id, role_type_id)=(CI6, DemoCustCompany, PLACING_CUSTOMER) already exists. The createInvoiceForOrder service is called for each orderId in createInvoicesFromShipments of InvoiceServices.java but the createInvoiceForOrder calls createInvoiceRole which attempts to insert the OrderRoles associated with the orderId which causes primary key violations. -- This message was sent by Atlassian JIRA (v6.1.5#6160)
[jira] [Commented] (OFBIZ-5345) Cannot pick or pack shipment for mutiple sales orders
[ https://issues.apache.org/jira/browse/OFBIZ-5345?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13875908#comment-13875908 ] Christian Carlow commented on OFBIZ-5345: - Thanks Jacques, I've since switched to using SVN and confirmed the bug still exists. Cannot pick or pack shipment for mutiple sales orders - Key: OFBIZ-5345 URL: https://issues.apache.org/jira/browse/OFBIZ-5345 Project: OFBiz Issue Type: Bug Components: order Affects Versions: SVN trunk, Release Branch 12.04 Reporter: Christian Carlow Attachments: InvoiceServices.java.patch, InvoiceServices.xml.patch, OFBIZ-5345.patch I get this error when trying to change the statusId of a shipment to picked or packed: Error calling event: org.ofbiz.webapp.event.EventHandlerException: Service invocation error (Could not commit transaction for service [updateShipment] call: Roll back error, could not commit transaction, was rolled back instead because of: Failure in create operation for entity [InvoiceRole]: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:InvoiceRole][createdStamp,2013-10-09 13:13:57.498(java.sql.Timestamp)][createdTxStamp,2013-10-09 13:13:49.522(java.sql.Timestamp)][datetimePerformed,2013-10-09 13:13:57.498(java.sql.Timestamp)][invoiceId,CI6(java.lang.String)][lastUpdatedStamp,2013-10-09 13:13:57.498(java.sql.Timestamp)][lastUpdatedTxStamp,2013-10-09 13:13:49.522(java.sql.Timestamp)][partyId,DemoCustCompany(java.lang.String)][roleTypeId,PLACING_CUSTOMER(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.INVOICE_ROLE (INVOICE_ID, PARTY_ID, ROLE_TYPE_ID, DATETIME_PERFORMED, PERCENTAGE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint pk_invoice_rolebr/ Detail: Key (invoice_id, party_id, role_type_id)=(CI6, DemoCustCompany, PLACING_CUSTOMER) already exists.)). Rolling back transaction.org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:InvoiceRole][createdStamp,2013-10-09 13:13:57.498(java.sql.Timestamp)][createdTxStamp,2013-10-09 13:13:49.522(java.sql.Timestamp)][datetimePerformed,2013-10-09 13:13:57.498(java.sql.Timestamp)][invoiceId,CI6(java.lang.String)][lastUpdatedStamp,2013-10-09 13:13:57.498(java.sql.Timestamp)][lastUpdatedTxStamp,2013-10-09 13:13:49.522(java.sql.Timestamp)][partyId,DemoCustCompany(java.lang.String)][roleTypeId,PLACING_CUSTOMER(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.INVOICE_ROLE (INVOICE_ID, PARTY_ID, ROLE_TYPE_ID, DATETIME_PERFORMED, PERCENTAGE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint pk_invoice_rolebr/ Detail: Key (invoice_id, party_id, role_type_id)=(CI6, DemoCustCompany, PLACING_CUSTOMER) already exists.)) (Error while inserting: [GenericEntity:InvoiceRole][createdStamp,2013-10-09 13:13:57.498(java.sql.Timestamp)][createdTxStamp,2013-10-09 13:13:49.522(java.sql.Timestamp)][datetimePerformed,2013-10-09 13:13:57.498(java.sql.Timestamp)][invoiceId,CI6(java.lang.String)][lastUpdatedStamp,2013-10-09 13:13:57.498(java.sql.Timestamp)][lastUpdatedTxStamp,2013-10-09 13:13:49.522(java.sql.Timestamp)][partyId,DemoCustCompany(java.lang.String)][roleTypeId,PLACING_CUSTOMER(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.INVOICE_ROLE (INVOICE_ID, PARTY_ID, ROLE_TYPE_ID, DATETIME_PERFORMED, PERCENTAGE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint pk_invoice_rolebr/ Detail: Key (invoice_id, party_id, role_type_id)=(CI6, DemoCustCompany, PLACING_CUSTOMER) already exists. The createInvoiceForOrder service is called for each orderId in createInvoicesFromShipments of InvoiceServices.java but the createInvoiceForOrder calls createInvoiceRole which attempts to insert the OrderRoles associated with the orderId which causes primary key violations. -- This message was sent by Atlassian JIRA (v6.1.5#6160)
[jira] [Commented] (OFBIZ-5371) SimpleMethod parameters doesnt work with prefix
[ https://issues.apache.org/jira/browse/OFBIZ-5371?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13875916#comment-13875916 ] Michael Ende commented on OFBIZ-5371: - Hi Jacques, can you tell me the state of the ticket? In my point of you it is working:-) Best regards Michael SimpleMethod parameters doesnt work with prefix --- Key: OFBIZ-5371 URL: https://issues.apache.org/jira/browse/OFBIZ-5371 Project: OFBiz Issue Type: Bug Components: ALL COMPONENTS Affects Versions: SVN trunk Reporter: Michael Ende Assignee: Jacques Le Roux Attachments: OFBIZ-5371.patch, OFBIZ-5371.patch I experianced some problems when a form submitted parameters with prefix directly to a SimpleMethod (through the controller request). In this case the prefix is not stripped from the parameter name. The patch updates the method ModelService.java:makePrefixMap(). The idea of the prefixMap is: If you have some fields like packageweight_1(value=55), packageweight_2(value=65) ... in a form and in a service you need a map called packageweight with the following key values packageweight{1=55;2=56;...} The Problem ist that the function makePrefixMap doesn't replace the Prefix. For Example: On the Complete button of the Facility-Shipment screen we call an event and not the completePack service directly. The event checks some userrights and after that he call the completePack service. If we call the service from an event there throws an NumberFormatException because the packeweight-PrefixMap contains the prefixes. This is my event discription: simple-method method-name=completePackCheckPermission short-description=Check if this user has permission to create a picklist role login-required=true check-permission permission=LOGISTICS_CREATE alt-permission permission=LOGISTICS_ADMIN/ fail-property resource=EcommerceLogisticsErrorUiLabels property=NoPermissionForUsage / /check-permission check-errors / session-to-field field=packingSession/ set field=parameters.packingSession from-field=packingSession/ set-service-fields service-name=completePack to-map=serviceParameters map=parameters / call-service service-name=completePack in-map-name=serviceParameters / return / /simple-method -- This message was sent by Atlassian JIRA (v6.1.5#6160)
[jira] [Commented] (OFBIZ-5501) ImageManagementServices.createContentAndDataResource() method might uses DataResource.dataResourceName field to store too long names
[ https://issues.apache.org/jira/browse/OFBIZ-5501?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13876070#comment-13876070 ] bill hongs commented on OFBIZ-5501: --- like these: File file = new File(imageServerPath + / + productId + / + uploadFileName); String imageName = null; imagePath = imageServerPath + / + productId + / + uploadFileName; file = checkExistsImage(file); if (UtilValidate.isNotEmpty(file)) { imageName = file.getPath(); imageName = imageName.substring(imageName.lastIndexOf(/) + 1); } Change to: File file = new File(imageServerPath + / + productId + / + uploadFileName); String imageName = null; imagePath = imageServerPath + / + productId + / + uploadFileName; file = checkExistsImage(file); if (UtilValidate.isNotEmpty(file)) { imageName = file.getPath(); imageName = imageName.substring(imageName.lastIndexOf(File.separator) + 1); } ImageManagementServices.createContentAndDataResource() method might uses DataResource.dataResourceName field to store too long names Key: OFBIZ-5501 URL: https://issues.apache.org/jira/browse/OFBIZ-5501 Project: OFBiz Issue Type: Bug Components: product Affects Versions: Release Branch 11.04, SVN trunk, Release Branch 12.04, Release Branch 13.07 Reporter: Jacques Le Roux So you get this kind of errors: ERROR 22001: A truncation error was encountered trying to shrink VARCHAR 'D:\projectsASF\ofbizClean\framework\images\webapp\images\pro' to length 100. org.apache.derby.iapi.error.StandardException.newException(Unknown Source) -- This message was sent by Atlassian JIRA (v6.1.5#6160)
[jira] [Commented] (OFBIZ-5478) Form pagination failes if total length of search condition is more than about 2~3k bytes
[ https://issues.apache.org/jira/browse/OFBIZ-5478?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13876112#comment-13876112 ] Leon commented on OFBIZ-5478: - hi, Jacques, Does r1204170 mean to reflect the true setting if you change the view size value in URL directly? Form pagination failes if total length of search condition is more than about 2~3k bytes Key: OFBIZ-5478 URL: https://issues.apache.org/jira/browse/OFBIZ-5478 Project: OFBiz Issue Type: Bug Components: framework Affects Versions: SVN trunk Reporter: Leon Assignee: Jacques Le Roux Priority: Minor Fix For: SVN trunk Attachments: OFBIZ-5478.patch Since it uses GET method to submit the pagination request, it's restricted by the URL max length limitation. The patch attached changes the submit way from GET to POST if total length of URL 2k. -- This message was sent by Atlassian JIRA (v6.1.5#6160)