Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0015801Openbravo ERP08. Project and service managementpublic2011-01-27 13:382011-05-24 10:56
Reporteradrianromero 
Assigned Toadrianromero 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionCommunity Appliance
Product Versionpi 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0015801: 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
TagsclosingMay2011
Relationships
related to defect 0039717 closed alostale unnecesary contention to create new documents in UI 
blocks backport 00157882.50MP27 closed adrianromero the system is blocked when run Create AP Expense Invoices 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-01-27 13:38adrianromeroNew Issue
2011-01-27 13:38adrianromeroAssigned To => adrianromero
2011-01-27 13:38adrianromeroModules => Core
2011-01-27 13:38adrianromeroOBNetwork customer => Yes
2011-01-27 13:38adrianromeroIssue generated from0015788
2011-01-27 13:38adrianromeroRelationship addedblocks 0015788
2011-01-27 13:39adrianromeroStatusnew => scheduled
2011-01-27 13:39adrianromerofix_in_branch => pi
2011-02-03 16:13hgbotCheckin
2011-02-03 16:13hgbotNote Added: 0034042
2011-02-03 16:13hgbotStatusscheduled => resolved
2011-02-03 16:13hgbotResolutionopen => fixed
2011-02-03 16:13hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/fab5abc10d9c2d501872995aecf188aa5a850daf [^]
2011-02-03 16:26adrianromeroNote Added: 0034044
2011-05-24 10:08dalsasuaTag Attached: closingMay2011
2011-05-24 10:56dalsasuaStatusresolved => closed
2018-11-30 11:59alostaleRelationship addedrelated to 0039717

Notes
(0034042)
hgbot   
2011-02-03 16:13   
Repository: erp/devel/pi
Changeset: fab5abc10d9c2d501872995aecf188aa5a850daf
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Thu Feb 03 16:13:02 2011 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/fab5abc10d9c2d501872995aecf188aa5a850daf [^]

Fixes issue 0015801: 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
---
(0034044)
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.