Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0015788 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| backport | [Openbravo ERP] 08. Project and service management | major | always | 2011-01-27 10:49 | 2011-02-28 20:01 | |||
| Reporter | malsasua | View Status | public | |||||
| Assigned To | adrianromero | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | 2.50MP27 | |||
| Status | closed | Fix in branch | 2.50 | Fixed in SCM revision | cb44b14e43ea | |||
| Projection | none | ETA | none | Target Version | 2.50MP27 | |||
| OS | Linux 32 bit | Database | PostgreSQL | Java version | 1.6.0_18 | |||
| OS Version | Community Appliance | Database version | 8.3.9 | Ant version | 1.7.1 | |||
| Product Version | 2.50MP25 | 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 | 0015788: the system is blocked when run Create AP Expense Invoices | |||||||
| Description | If you create a new document type with check "expense" selected and run the process Create AP Expense Invoices, the bd is bloqued | |||||||
| Steps To Reproduce | . create a new document type: Financial Management || Accounting || Setup || Document Type || Document Definition: . gl category AP Invoice . Document category AP Invoice . sequenced document selected . document sequence "Albaran" . expense selected . run process Create AP Expense Invoices | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||
|
|||||||||||||||
 Relationships |
|
Notes |
|
|
(0033919) psarobe (manager) 2011-01-27 14:43 |
It works perfect for me. But instead of selecting Albaran I have created my own sequence which is the normal way of doing things. Selecting Albaran makes no sense. Can you please try again? In case the problem is selecting a document sequence that makes no sense I would suggest to change from major to minor. |
|
(0033940) malsasua (developer) 2011-01-28 08:17 |
if you select a new sequence, the process run ok. |
|
(0034040) hgbot (developer) 2011-02-03 14:56 |
Repository: erp/stable/2.50 Changeset: cb44b14e43eade282a9b732c1ec17795d264ba5d Author: Adrián Romero <adrianromero <at> openbravo.com> Date: Thu Feb 03 14:56:03 2011 +0100 URL: http://code.openbravo.com/erp/stable/2.50/rev/cb44b14e43eade282a9b732c1ec17795d264ba5d [^] Fixes issue 0015788: the system is blocked when run Create AP Expense Invoices It has been rewritten the SQL sentence that gets the sequence values to not to lock the C_DOCTYPE table because it is not necessary and is the cause of the issue --- M src-db/database/model/functions/AD_SEQUENCE_DOCTYPE.xml --- |
|
(0034043) adrianromero (manager) 2011-02-03 16:26 |
* Testing the issue Kindly follow the steps to test and verify that now the process does not lock the database. Verify that there will be more than 1 invoice to be created. The process does not lock the database if there is only 1 invoice to generate. * Other areas affected It has been modified the PL/SQL function AD_SEQUENCE_DOCTYPE so all proccesses that invoke this function are susceptible to be affected. But the behavior of the function has not been modified. It should behave the same way. |
|
(0034446) jonalegriaesarte (reporter) 2011-02-28 20:01 |
Verified |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2011-01-27 10:49 | malsasua | New Issue | |
| 2011-01-27 10:49 | malsasua | Assigned To | => adrianromero |
| 2011-01-27 10:49 | malsasua | Modules | => Core |
| 2011-01-27 10:49 | malsasua | Issue Monitored: networkb | |
| 2011-01-27 10:52 | malsasua | Relationship added | related to 0012586 |
| 2011-01-27 10:59 | rafaroda | Issue Monitored: rafaroda | |
| 2011-01-27 11:06 | jonalegriaesarte | Target Version | => 2.50MP27 |
| 2011-01-27 13:38 | adrianromero | Status | new => scheduled |
| 2011-01-27 13:38 | adrianromero | Type | defect => backport |
| 2011-01-27 13:38 | adrianromero | Issue cloned | 0015801 |
| 2011-01-27 13:38 | adrianromero | Relationship added | depends on 0015801 |
| 2011-01-27 14:43 | psarobe | Note Added: 0033919 | |
| 2011-01-27 14:43 | psarobe | Status | scheduled => feedback |
| 2011-01-28 08:17 | malsasua | Note Added: 0033940 | |
| 2011-01-28 08:18 | malsasua | Status | feedback => new |
| 2011-02-02 11:48 | dalsasua | fix_in_branch | => 2.50 |
| 2011-02-03 14:56 | hgbot | Checkin | |
| 2011-02-03 14:56 | hgbot | Note Added: 0034040 | |
| 2011-02-03 14:56 | hgbot | Status | new => resolved |
| 2011-02-03 14:56 | hgbot | Resolution | open => fixed |
| 2011-02-03 14:56 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/stable/2.50/rev/cb44b14e43eade282a9b732c1ec17795d264ba5d [^] |
| 2011-02-03 16:26 | adrianromero | Note Added: 0034043 | |
| 2011-02-28 20:01 | jonalegriaesarte | Note Added: 0034446 | |
| 2011-02-28 20:01 | jonalegriaesarte | Status | resolved => closed |
| 2011-02-28 20:01 | jonalegriaesarte | Fixed in Version | => 2.50MP27 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |