Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0015788Openbravo ERP08. Project and service managementpublic2011-01-27 10:492011-02-28 20:01
Reportermalsasua 
Assigned Toadrianromero 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionCommunity Appliance
Product Version2.50MP25 
Target Version2.50MP27Fixed in Version2.50MP27 
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
Summary0015788: the system is blocked when run Create AP Expense Invoices
DescriptionIf 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
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 00125862.50MP14 closed adrianromero The way to pay the expeses of the employee is creating an invoice what is not correct 
depends on defect 0015801 closed adrianromero the system is blocked when run Create AP Expense Invoices 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-01-27 10:49malsasuaNew Issue
2011-01-27 10:49malsasuaAssigned To => adrianromero
2011-01-27 10:49malsasuaModules => Core
2011-01-27 10:49malsasuaIssue Monitored: networkb
2011-01-27 10:52malsasuaRelationship addedrelated to 0012586
2011-01-27 10:59rafarodaIssue Monitored: rafaroda
2011-01-27 11:06jonalegriaesarteTarget Version => 2.50MP27
2011-01-27 13:38adrianromeroStatusnew => scheduled
2011-01-27 13:38adrianromeroTypedefect => backport
2011-01-27 13:38adrianromeroIssue cloned0015801
2011-01-27 13:38adrianromeroRelationship addeddepends on 0015801
2011-01-27 14:43psarobeNote Added: 0033919
2011-01-27 14:43psarobeStatusscheduled => feedback
2011-01-28 08:17malsasuaNote Added: 0033940
2011-01-28 08:18malsasuaStatusfeedback => new
2011-02-02 11:48dalsasuafix_in_branch => 2.50
2011-02-03 14:56hgbotCheckin
2011-02-03 14:56hgbotNote Added: 0034040
2011-02-03 14:56hgbotStatusnew => resolved
2011-02-03 14:56hgbotResolutionopen => fixed
2011-02-03 14:56hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/cb44b14e43eade282a9b732c1ec17795d264ba5d [^]
2011-02-03 16:26adrianromeroNote Added: 0034043
2011-02-28 20:01jonalegriaesarteNote Added: 0034446
2011-02-28 20:01jonalegriaesarteStatusresolved => closed
2011-02-28 20:01jonalegriaesarteFixed in Version => 2.50MP27

Notes
(0033919)
psarobe   
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   
2011-01-28 08:17   
if you select a new sequence, the process run ok.
(0034040)
hgbot   
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   
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   
2011-02-28 20:01   
Verified