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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0036945
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Modules] Not Posted Transactionsmajoralways2017-09-25 17:212017-10-03 17:30
ReporterngarciaView Statuspublic 
Assigned ToAtulOpenbravo 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision26465021b964
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned Toaferraz
Support ticket47753
OBNetwork customerOBPS
Regression introduced in release
Summary

0036945: Cannot post a document from the Report Not Posted window if an External Connection Pool is not used

DescriptionCannot post a document from the Report Not Posted window if an External Connection Pool is not used
Steps To ReproduceCheck the db.externalPoolClassName parameter is not defined in Openbravo.properties file (remove it and compile if it is not the case)

As group admin role:
   Go to Report Not Posted window, select a record, click on post and OK and check the pop-up does not disappear and no message is shown

   The log shows:
   ERROR org.hibernate.transaction.JDBCTransaction - JDBC commit failed
org.postgresql.util.PSQLException: Cannot commit when autoCommit is enabled.
...
SEVERE: Servlet.service() for servlet [MA761FF99519C45D1A4BEE9FA30B40AAC] in context with path [/openbravo_pisp] threw exception
org.hibernate.TransactionException: JDBC commit failed
...
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0028934 closedinigosanchez Modules Error when launching "Create AP Expense Invoices" related to Openbravo External Connection Pools module. 
related to defect 0030811 closeddmiguelez Openbravo ERP process: "Create expense AP Invoice" does not work 
blocks defect 0036946 closedcollazoandy4 Modules Error message when trying to post more than one document with error in Report Not Posted Window 

-  Notes
(0099726)
AtulOpenbravo (viewer)
2017-10-03 14:27

 Test Plan

- Login as F&B International Group Admin role.
- Make sure the accounting background process is not scheduled.
- Create a Sales Invoice for any business partner, any product, complete it.
- Go to Report Not Posted window, select a invoice record created above, click on post and click OK.
- Realize that record is posted successfully, grid is refreshed and removed from the grid view.
(0099735)
hgbot (developer)
2017-10-03 17:28

 Repository: erp/mods/org.openbravo.financialmgmt.accounting.report.notposted
Changeset: 26465021b964e6d36b7cda81d2bb38c0c515dfa6
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Tue Oct 03 01:59:30 2017 +0530
URL: http://code.openbravo.com/erp/mods/org.openbravo.financialmgmt.accounting.report.notposted/rev/26465021b964e6d36b7cda81d2bb38c0c515dfa6 [^]

Fixes issue 36945: Cannot post a document from the Report Not Posted window

Cannot post a document from the Report Not Posted window if an
External Connection Pool is not used

Use transaction connection from connection provider instead of connection from
OBDal instance

---
M src/org/openbravo/financialmgmt/accounting/report/notposted/PostHandler.java
---
(0099737)
hgbot (developer)
2017-10-03 17:28

 Repository: erp/mods/org.openbravo.financialmgmt.accounting.report.notposted
Changeset: 29754c44a4be4a305f4517ecbf9924e5794f8d6e
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Tue Oct 03 17:08:00 2017 +0200
URL: http://code.openbravo.com/erp/mods/org.openbravo.financialmgmt.accounting.report.notposted/rev/29754c44a4be4a305f4517ecbf9924e5794f8d6e [^]

Related to issue 36945: Update module version

---
M src-db/database/sourcedata/AD_MODULE.xml
---
(0099738)
aferraz (viewer)
2017-10-03 17:30

 Code review + Testing OK

- Issue History
Date Modified Username Field Change
2017-09-25 17:21 ngarcia New Issue
2017-09-25 17:21 ngarcia Assigned To => Triage Finance
2017-09-25 17:21 ngarcia Support ticket => 47753
2017-09-25 17:21 ngarcia OBNetwork customer => Yes
2017-09-25 17:22 ngarcia Resolution time => 1508104800
2017-09-25 17:22 ngarcia Issue Monitored: networkb
2017-09-25 17:31 ngarcia Steps to Reproduce Updated View Revisions
2017-09-25 17:33 ngarcia Relationship added blocks 0036946
2017-09-26 10:33 aferraz Relationship added related to 0028934
2017-09-26 10:39 aferraz Relationship added related to 0030811
2017-09-26 11:40 aferraz Assigned To Triage Finance => markmm82
2017-09-26 16:37 markmm82 Status new => acknowledged
2017-09-26 19:38 markmm82 Status acknowledged => scheduled
2017-09-28 18:13 aferraz Assigned To markmm82 => AtulOpenbravo
2017-10-03 14:27 AtulOpenbravo Note Added: 0099726
2017-10-03 17:28 hgbot Checkin
2017-10-03 17:28 hgbot Note Added: 0099735
2017-10-03 17:28 hgbot Status scheduled => resolved
2017-10-03 17:28 hgbot Resolution open => fixed
2017-10-03 17:28 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/mods/org.openbravo.financialmgmt.accounting.report.notposted/rev/26465021b964e6d36b7cda81d2bb38c0c515dfa6 [^]
2017-10-03 17:28 hgbot Checkin
2017-10-03 17:28 hgbot Note Added: 0099737
2017-10-03 17:30 aferraz Review Assigned To => aferraz
2017-10-03 17:30 aferraz Note Added: 0099738
2017-10-03 17:30 aferraz Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker