Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0015207Openbravo ERPA. Platformpublic2010-11-17 10:442010-12-09 16:07
Reportermirurita 
Assigned Toiperdomo 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP23 
Target Version2.50MP24Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0015207: Error with autosave and views
DescriptionThe auto-save in Financial Management || Receivables & Payables || Transaction || Financial Account >> Reconciliations tab (it's a view) produces an error when leaving this tab if a process (report) has been launched before.

Log:
Nov 17, 2010 10:17:31 AM org.apache.catalina.core.ApplicationDispatcher invoke
SEVERE: Servlet.service() for servlet W8266E9ACD87192BFE040007F01004ECB threw exception
org.openbravo.base.exception.OBException: ORA-01779: cannot modify a column which maps to a non key-preserved table

    at org.openbravo.erpWindows.FinancialAccount.ReconciliationsC095D2CC39704DBE8B906B7CD7710968.doPost(ReconciliationsC095D2CC39704DBE8B906B7CD7710968.java:71)
    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:470)
...
Steps To Reproduce1) Install APRM module.
2) Apply the dataset of APRM.
3) Create a new Payment Method in Financial Management || Receivables & Payables || Setup || Payment Method
4) Create a new Financial Account in Financial Management || Receivables & Payables || Transaction || Financial Account and associate previously created payment method from Payment Method tab.
5) Go to to Financial Management || Receivables & Payables || Transaction || Financial Account >> Transactions tab and create a new Reconciliation.
  * Click on Reconcile button and click on Save button in the popup.
6) Go to Financial Management || Receivables & Payables || Transaction || Financial Account >> Reconciliations tab and click on 'Print Reconciliation Detail Report' button. The report will be shown.
7) Move again to Financial Management || Receivables & Payables || Transaction || Financial Account >> Transactions tab.

The following error will appear: ORA-01779: cannot modify a column which maps to a non key-preserved table

(See the attached screen-shot)
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Filespng Error.png (91,265) 2010-11-17 10:44
https://issues.openbravo.com/file_download.php?file_id=3327&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2010-11-17 10:44miruritaNew Issue
2010-11-17 10:44miruritaAssigned To => mtaal
2010-11-17 10:44miruritaFile Added: Error.png
2010-11-17 16:16psarobePrioritynormal => immediate
2010-11-17 16:16psarobeStatusnew => scheduled
2010-11-17 16:16psarobeversion => 2.50MP23
2010-11-17 16:16psarobeTarget Version => 2.50MP24
2010-11-18 14:54mtaalAssigned Tomtaal => iperdomo
2010-11-19 11:19hgbotCheckin
2010-11-19 11:19hgbotNote Added: 0032730
2010-11-19 11:19hgbotStatusscheduled => resolved
2010-11-19 11:19hgbotResolutionopen => fixed
2010-11-19 11:19hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/7c061d2468b9a33a36a02c6f78060f0bd2231e80 [^]
2010-11-19 13:14miruritaNote Added: 0032735
2010-11-19 13:14miruritaStatusresolved => closed
2010-11-19 20:07hudsonbotCheckin
2010-11-19 20:07hudsonbotNote Added: 0032761
2010-12-09 16:07anonymoussf_bug_id0 => 3133561

Notes
(0032730)
hgbot   
2010-11-19 11:19   
Repository: erp/devel/pi
Changeset: 7c061d2468b9a33a36a02c6f78060f0bd2231e80
Author: Iván Perdomo <ivan.perdomo <at> openbravo.com>
Date: Fri Nov 19 11:17:42 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/7c061d2468b9a33a36a02c6f78060f0bd2231e80 [^]

Fixes issue 15207: Append logClick function when the buttons trigger autosave
- At column level we have a flag if the button should trigger autosave or not.
    When the button doesn't trigger autosave, a false is passed as parameter to
    openServletNewWindow(), we need also to remove the logClick() call, since it
    records the latest clicked button. If a button was clicked in the window,
    the autosave is launched when leaving the page.

---
M src-wad/src/org/openbravo/wad/controls/WADButton.html
M src-wad/src/org/openbravo/wad/controls/WADButton.java
M src-wad/src/org/openbravo/wad/controls/WADButton.xml
---
(0032735)
mirurita   
2010-11-19 13:14   
Verified.
(0032761)
hudsonbot   
2010-11-19 20:07   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/7c061d2468b9 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/4960cae97b54 [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.18970.obx [^]