Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0036945ModulesNot Posted Transactionspublic2017-09-25 17:212017-10-03 17:30
Reporterngarcia 
Assigned ToAtulOpenbravo 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned Toaferraz
Support ticket47753
OBNetwork customerOBPS
Regression introduced in release
Summary0036945: 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
...
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0028934 closed inigosanchez Modules Error when launching "Create AP Expense Invoices" related to Openbravo External Connection Pools module. 
related to defect 0030811 closed dmiguelez Openbravo ERP process: "Create expense AP Invoice" does not work 
blocks defect 0036946 closed collazoandy4 Modules Error message when trying to post more than one document with error in Report Not Posted Window 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2017-09-25 17:21ngarciaNew Issue
2017-09-25 17:21ngarciaAssigned To => Triage Finance
2017-09-25 17:21ngarciaSupport ticket => 47753
2017-09-25 17:21ngarciaOBNetwork customer => Yes
2017-09-25 17:22ngarciaResolution time => 1508104800
2017-09-25 17:22ngarciaIssue Monitored: networkb
2017-09-25 17:31ngarciaSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=15983#r15983
2017-09-25 17:33ngarciaRelationship addedblocks 0036946
2017-09-26 10:33aferrazRelationship addedrelated to 0028934
2017-09-26 10:39aferrazRelationship addedrelated to 0030811
2017-09-26 11:40aferrazAssigned ToTriage Finance => markmm82
2017-09-26 16:37markmm82Statusnew => acknowledged
2017-09-26 19:38markmm82Statusacknowledged => scheduled
2017-09-28 18:13aferrazAssigned Tomarkmm82 => AtulOpenbravo
2017-10-03 14:27AtulOpenbravoNote Added: 0099726
2017-10-03 17:28hgbotCheckin
2017-10-03 17:28hgbotNote Added: 0099735
2017-10-03 17:28hgbotStatusscheduled => resolved
2017-10-03 17:28hgbotResolutionopen => fixed
2017-10-03 17:28hgbotFixed in SCM revision => http://code.openbravo.com/erp/mods/org.openbravo.financialmgmt.accounting.report.notposted/rev/26465021b964e6d36b7cda81d2bb38c0c515dfa6 [^]
2017-10-03 17:28hgbotCheckin
2017-10-03 17:28hgbotNote Added: 0099737
2017-10-03 17:30aferrazReview Assigned To => aferraz
2017-10-03 17:30aferrazNote Added: 0099738
2017-10-03 17:30aferrazStatusresolved => closed

Notes
(0099726)
AtulOpenbravo   
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   
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   
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   
2017-10-03 17:30   
Code review + Testing OK