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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0005196
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 00. Application dictionarymajoralways2008-09-23 13:012009-01-25 19:22
ReportergalderromoView Statuspublic 
Assigned Toalostale 
PriorityhighResolutionfixedFixed in Version2.40MP2
StatusclosedFix in branch2.40Fixed in SCM revision11164
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabaseOracleJava version1.5.0_15
OS VersionGentoo 2.6.24Database versionXEAnt version1.7
Product VersionSCM revision 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0005196: Doc sequences and database restrictions

DescriptionRight now, when working with Sales Invoices, WAD generated code updates the document's sequence before is sure the invoice has been created. This way it is possible to update the sequence but not to create the record due to database restrictions.

This issue is critica because can generate sequence jumps on Sales Invoices, which is ilegal.

In some how, this request is related to 4439 and 5054.
Steps To ReproduceSuppose you do not want the user to create an invoice with no c_project_id or not user1_id. So you create on the database this restriction (there is no way to do it through the AP).

Then, when you press the SAVE button, the WAD generated code updates the sequence and later inserts the record on the database. But the restriction avoids this inserting, so the sequence has been lost.
Proposed SolutionChange the sequence control, and make sure the inserting has been properly done, before updating the sequence.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0006395 closedshuehner Inpossible to create a new document on Postgresql 
blocks defect 0005175 closedalostale Doc sequences and database restrictions 

-  Notes
(0010850)
svnbot (viewer)
2008-12-01 15:58

 Repository: openbravo
Revision: 10793
Author: alostale
Date: 2008-12-01 15:58:20 +0100 (Mon, 01 Dec 2008)

fixed bug 0005196: Doc sequences and database restrictions

---
U branches/r2.40/src/org/openbravo/erpCommon/utility/DocumentNo_data.xsql
U branches/r2.40/src/org/openbravo/erpCommon/utility/Utility.java
U branches/r2.40/src-wad/src/org/openbravo/wad/Wad.java
U branches/r2.40/src-wad/src/org/openbravo/wad/datasource.xsqlxml
U branches/r2.40/src-wad/src/org/openbravo/wad/javasource.javaxml
---

https://dev.openbravo.com/websvn/openbravo/?rev=10793&sc=1 [^]
(0010891)
svnbot (viewer)
2008-12-02 15:51

 Repository: openbravo
Revision: 10866
Author: villind
Date: 2008-12-02 15:51:50 +0100 (Tue, 02 Dec 2008)

Merged r10793. fixed bug 0005196: Doc sequences and database restrictions

---
_U branches/bonware/r2.40/
_U branches/bonware/r2.40/config/setup-tool/
_U branches/bonware/r2.40/eclipse.install.source.launch
_U branches/bonware/r2.40/export.database.launch
U branches/bonware/r2.40/src/org/openbravo/erpCommon/utility/DocumentNo_data.xsql
U branches/bonware/r2.40/src/org/openbravo/erpCommon/utility/Utility.java
_U branches/bonware/r2.40/src-core/src/org/openbravo/database/OpenbravoDriverManagerConnectionFactory.java
U branches/bonware/r2.40/src-wad/src/org/openbravo/wad/Wad.java
U branches/bonware/r2.40/src-wad/src/org/openbravo/wad/datasource.xsqlxml
U branches/bonware/r2.40/src-wad/src/org/openbravo/wad/javasource.javaxml
_U branches/bonware/r2.40/update.database.launch
---

https://dev.openbravo.com/websvn/openbravo/?rev=10866&sc=1 [^]
(0011256)
svnbot (viewer)
2008-12-12 16:15

 Repository: openbravo
Revision: 11164
Author: rafaroda
Date: 2008-12-12 16:15:01 +0100 (Fri, 12 Dec 2008)

Fixes bug 0005196 Made fix PotgreSQL compatible

---
U branches/r2.40/src/org/openbravo/erpCommon/utility/DocumentNo_data.xsql
---

https://dev.openbravo.com/websvn/openbravo/?rev=11164&sc=1 [^]

- Issue History
Date Modified Username Field Change
2008-09-23 13:01 cromero New Issue
2008-09-23 13:01 cromero Assigned To => alostale
2008-09-23 13:01 cromero Status new => scheduled
2008-12-01 15:58 svnbot Checkin
2008-12-01 15:58 svnbot Note Added: 0010850
2008-12-01 15:58 svnbot Status scheduled => resolved
2008-12-01 15:58 svnbot Resolution open => fixed
2008-12-01 15:58 svnbot svn_revision => 10793
2008-12-02 15:51 svnbot Checkin
2008-12-02 15:51 svnbot Note Added: 0010891
2008-12-02 15:51 svnbot svn_revision 10793 => 10866
2008-12-12 16:15 svnbot Checkin
2008-12-12 16:15 svnbot Note Added: 0011256
2008-12-12 16:15 svnbot svn_revision 10866 => 11164
2008-12-12 16:56 shuehner Relationship added related to 0006395
2009-01-25 19:22 psarobe Regression testing => No
2009-01-25 19:22 psarobe Status resolved => closed
2009-01-25 19:22 psarobe Fixed in Version => 2.40

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker