0020367: Create Standards can not be executed - Openbravo Issue Tracking System

bc4ec62b 5979507 [http-8080-1] ERROR org.openbravo.erpCommon.ad_actionButton.CreateWorkEffort - Error creating work effort org.openbravo.base.exception.OBException: ERROR: update o delete en «m_storage_detail» viola la llave foránea «m_storagedetail_mstockaux» en la tabla «m_stock_aux» Detail: La llave (m_storage_detail_id)=(4469BE1DA72C4C8592D5CBCFF1B21449) todavía es referida desde la tabla «m_stock_aux». Where: sentencia SQL: «DELETE FROM M_STORAGE_DETAIL WHERE M_STORAGE_DETAIL_ID = $1 » PL/pgSQL function "m_update_inventory" line 97 at sentencia SQL sentencia SQL: «SELECT M_UPDATE_INVENTORY( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , NULL, NULL, NULL, - $9 , - $10 )» PL/pgSQL function "m_productionline_trg" line 90 at PERFORM at org.openbravo.erpCommon.ad_actionButton.CreateWorkEffort.execute(CreateWorkEffort.java:192) at org.openbravo.scheduling.ProcessRunner.execute(ProcessRunner.java:82) at org.openbravo.erpWindows.WorkRequirement.Header.doPost(Header.java:551) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:225) at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:427) at org.openbravo.erpWindows.WorkRequirement.Header.service(Header.java:100) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:66) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.openbravo.utils.CharsetFilter.doFilter(CharsetFilter.java:35) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.openbravo.client.kernel.KernelFilter$1.doAction(KernelFilter.java:62) at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46) at org.openbravo.client.kernel.KernelFilter.doFilter(KernelFilter.java:71) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.openbravo.dal.core.DalRequestFilter$1.doAction(DalRequestFilter.java:81) at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46) at org.openbravo.dal.core.DalRequestFilter.doFilter(DalRequestFilter.java:103) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:662)

Notes
(0048150) hgbot (developer) 2012-04-27 14:53	Repository: erp/devel/pi Changeset: ef9b9a588ce3b8a71acd7d2d09aea4301194a43d Author: Javier Etxarri <javier.echarri <at> openbravo.com> Date: Fri Apr 27 14:52:20 2012 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/ef9b9a588ce3b8a71acd7d2d09aea4301194a43d [^] Fixes issue 20367: Create Standards can not be executed. The problem was that in the create standares process, application create one record in m_storage_detail with one product without any atrributeset and with qty's zero. So the m_update_inventory tries to delete but it has a related record in m_stock_aux --- M src-db/database/model/functions/M_UPDATE_INVENTORY.xml M src-db/database/model/functions/M_UPDATE_STOCKAUX.xml ---

(0048180) hudsonbot (viewer) 2012-04-28 02:31	A changeset related to this issue has been promoted main and to the Central Repository, after passing a series of tests. Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/cd923b317af4 [^] Maturity status: Test

(0048196) rafademiguel (viewer) 2012-04-30 12:21	Verified

Issue History
Date Modified	Username	Field	Change
2012-04-26 18:18	rafademiguel	New Issue
2012-04-26 18:18	rafademiguel	Assigned To	=> jecharri
2012-04-26 18:18	rafademiguel	File Added: error.txt
2012-04-26 18:18	rafademiguel	Modules	=> Core
2012-04-26 18:18	rafademiguel	OBNetwork customer	=> No
2012-04-26 18:20	rafademiguel	Tag Attached: Regression QA
2012-04-26 18:20	rafademiguel	Relationship added	related to 0020159
2012-04-27 14:53	hgbot	Checkin
2012-04-27 14:53	hgbot	Note Added: 0048150
2012-04-27 14:53	hgbot	Status	new => resolved
2012-04-27 14:53	hgbot	Resolution	open => fixed
2012-04-27 14:53	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/devel/pi/rev/ef9b9a588ce3b8a71acd7d2d09aea4301194a43d [^]
2012-04-28 02:31	hudsonbot	Checkin
2012-04-28 02:31	hudsonbot	Note Added: 0048180
2012-04-30 12:21	rafademiguel	Note Added: 0048196
2012-04-30 12:21	rafademiguel	Status	resolved => closed
2012-04-30 12:21	rafademiguel	Fixed in Version	=> 3.0MP11