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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0015801
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 08. Project and service managementmajoralways2011-01-27 13:382011-05-24 10:56
ReporteradrianromeroView Statuspublic 
Assigned Toadrianromero 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revisionfab5abc10d9c
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_18
OS VersionCommunity ApplianceDatabase version8.3.9Ant version1.7.1
Product VersionpiSCM revision 
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
Summary

0015801: 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
TagsclosingMay2011
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0039717 closedalostale unnecesary contention to create new documents in UI 
blocks backport 00157882.50MP27 closedadrianromero the system is blocked when run Create AP Expense Invoices 

-  Notes
(0034042)
hgbot (developer)
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 (viewer)
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.

- Issue History
Date Modified Username Field Change
2011-01-27 13:38 adrianromero New Issue
2011-01-27 13:38 adrianromero Assigned To => adrianromero
2011-01-27 13:38 adrianromero Modules => Core
2011-01-27 13:38 adrianromero OBNetwork customer => Yes
2011-01-27 13:38 adrianromero Issue generated from 0015788
2011-01-27 13:38 adrianromero Relationship added blocks 0015788
2011-01-27 13:39 adrianromero Status new => scheduled
2011-01-27 13:39 adrianromero fix_in_branch => pi
2011-02-03 16:13 hgbot Checkin
2011-02-03 16:13 hgbot Note Added: 0034042
2011-02-03 16:13 hgbot Status scheduled => resolved
2011-02-03 16:13 hgbot Resolution open => fixed
2011-02-03 16:13 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/fab5abc10d9c2d501872995aecf188aa5a850daf [^]
2011-02-03 16:26 adrianromero Note Added: 0034044
2011-05-24 10:08 dalsasua Tag Attached: closingMay2011
2011-05-24 10:56 dalsasua Status resolved => closed
2018-11-30 11:59 alostale Relationship added related to 0039717

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker