Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0005175 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 00. Application dictionary | major | always | 2008-09-23 09:30 | 2009-04-21 11:07 | |||
| Reporter | galderromo | View Status | public | |||||
| Assigned To | alostale | |||||||
| Priority | immediate | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | 11193 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 32 bit | Database | Oracle | Java version | 1.5.0_15 | |||
| OS Version | Gentoo 2.6.24 | Database version | XE | Ant version | 1.7 | |||
| Product Version | SCM revision | |||||||
| Review Assigned To | ||||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0005175: Doc sequences and database restrictions | |||||||
| Description | Right 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 Reproduce | Suppose 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 Solution | Change the sequence control, and make sure the inserting has been properly done, before updating the sequence. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||
|
|||||||||||||||
 Relationships |
|
Notes |
|
|
(0010846) alostale (manager) 2008-12-01 15:09 |
The solution is to make transactional the insert and update processes so when it fails a rollback is done. |
|
(0010847) svnbot (reporter) 2008-12-01 15:12 |
Repository: openbravo Revision: 10784 Author: alostale Date: 2008-12-01 15:12:41 +0100 (Mon, 01 Dec 2008) fixed bug 0005175: Doc sequences and database restrictions --- U trunk/src/org/openbravo/erpCommon/utility/DocumentNo_data.xsql U trunk/src/org/openbravo/erpCommon/utility/Utility.java U trunk/src-wad/src/org/openbravo/wad/Wad.java U trunk/src-wad/src/org/openbravo/wad/datasource.xsqlxml U trunk/src-wad/src/org/openbravo/wad/javasource.javaxml --- https://dev.openbravo.com/websvn/openbravo/?rev=10784&sc=1 [^] |
|
(0011351) svnbot (reporter) 2008-12-15 10:11 |
Repository: openbravo Revision: 11193 Author: rafaroda Date: 2008-12-15 10:11:47 +0100 (Mon, 15 Dec 2008) Fixes bug 0005175 Made fix PotgreSQL compatible --- U trunk/src/org/openbravo/erpCommon/utility/DocumentNo_data.xsql --- https://dev.openbravo.com/websvn/openbravo/?rev=11193&sc=1 [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2008-09-23 09:30 | galderromo | New Issue | |
| 2008-09-23 09:30 | galderromo | Assigned To | => cromero |
| 2008-09-23 09:30 | galderromo | sf_bug_id | 0 => 2124106 |
| 2008-09-23 12:59 | cromero | Priority | normal => high |
| 2008-09-23 12:59 | cromero | Severity | critical => major |
| 2008-09-23 13:01 | cromero | Status | new => scheduled |
| 2008-09-23 13:01 | cromero | Assigned To | cromero => alostale |
| 2008-09-23 13:01 | cromero | fix_in_branch | => trunk |
| 2008-12-01 11:18 | networkb | Priority | high => immediate |
| 2008-12-01 11:18 | networkb | fix_in_branch | trunk => |
| 2008-12-01 11:18 | networkb | Issue Monitored: networkb | |
| 2008-12-01 15:09 | alostale | Note Added: 0010846 | |
| 2008-12-01 15:12 | svnbot | Checkin | |
| 2008-12-01 15:12 | svnbot | Note Added: 0010847 | |
| 2008-12-01 15:12 | svnbot | Status | scheduled => resolved |
| 2008-12-01 15:12 | svnbot | Resolution | open => fixed |
| 2008-12-01 15:12 | svnbot | svn_revision | => 10784 |
| 2008-12-15 10:11 | svnbot | Checkin | |
| 2008-12-15 10:11 | svnbot | Note Added: 0011351 | |
| 2008-12-15 10:11 | svnbot | svn_revision | 10784 => 11193 |
| 2009-04-21 11:07 | psarobe | Status | resolved => closed |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |