Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0015207
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajoralways2010-11-17 10:442010-12-09 16:07
ReportermiruritaView Statuspublic 
Assigned Toiperdomo 
PriorityimmediateResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision7c061d2468b9
ProjectionnoneETAnoneTarget Version2.50MP24
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.50MP23SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0015207: 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)
TagsNo tags attached.
Attached Filespng file icon Error.png [^] (91,265 bytes) 2010-11-17 10:44

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0032730)
hgbot (developer)
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 (developer)
2010-11-19 13:14

Verified.
(0032761)
hudsonbot (developer)
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 [^]

- Issue History
Date Modified Username Field Change
2010-11-17 10:44 mirurita New Issue
2010-11-17 10:44 mirurita Assigned To => mtaal
2010-11-17 10:44 mirurita File Added: Error.png
2010-11-17 16:16 psarobe Priority normal => immediate
2010-11-17 16:16 psarobe Status new => scheduled
2010-11-17 16:16 psarobe version => 2.50MP23
2010-11-17 16:16 psarobe Target Version => 2.50MP24
2010-11-18 14:54 mtaal Assigned To mtaal => iperdomo
2010-11-19 11:19 hgbot Checkin
2010-11-19 11:19 hgbot Note Added: 0032730
2010-11-19 11:19 hgbot Status scheduled => resolved
2010-11-19 11:19 hgbot Resolution open => fixed
2010-11-19 11:19 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/7c061d2468b9a33a36a02c6f78060f0bd2231e80 [^]
2010-11-19 13:14 mirurita Note Added: 0032735
2010-11-19 13:14 mirurita Status resolved => closed
2010-11-19 20:07 hudsonbot Checkin
2010-11-19 20:07 hudsonbot Note Added: 0032761
2010-12-09 16:07 anonymous sf_bug_id 0 => 3133561


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker