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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0018339
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] Z. Othersmajoralways2011-08-23 11:372011-10-12 01:59
ReportermiruritaView Statuspublic 
Assigned Tomirurita 
PrioritynormalResolutionfixedFixed in Version3.0MP4
StatusclosedFix in branchpiFixed in SCM revisionaf9194d3dafd
ProjectionnoneETAnoneTarget Version3.0MP4
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0018339: Bank Statement document gets locked when trying to post

DescriptiongetDocumentConfirmation of DocFINBankStatement returns false if the bank statement posting is not enable in Financial Account || Accounting Configuration.

line 629 AcctServer.java
getDocumentConfirmation(conn, Record_ID)

then when trying to save the record restoring the processing = 'N' the update statement fails because Status is empty ("")

line 635 AcctServer.java
save(conn, vars.getUser())

Status is "" (empty)
AcctServerData.updateSave(conn, tableName, Status, strUser, Record_ID)


3675287 [DefaultQuartzScheduler_Worker-4] ERROR org.openbravo.erpCommon.ad_forms.AcctServerData - SQL error in query: UPDATE FIN_BankStatement SET Posted= ? ,Processing='N', updated=now(), updatedby=? WHERE FIN_BankStatement_ID = ?Exception:org.postgresql.util.PSQLException: ERROR: null value in column "posted" violates not-null constraint
3675288 [DefaultQuartzScheduler_Worker-4] WARN org.openbravo.erpCommon.ad_forms.AcctServer - javax.servlet.ServletException: @CODE=0@ERROR: null value in column "posted" violates not-null constraint
javax.servlet.ServletException: @CODE=0@ERROR: null value in column "posted" violates not-null constraint
Steps To Reproduce1) Create a manual bank statement
1.1) Create one line of Amount In: 10
2) Do NOT process
3) Don't enable the Bank Statement Posting (Financial Account || Accounting Configuration)
4) Run the acct server background process
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
depends on backport 00186062.50MP35 closedmirurita Bank Statement document gets locked when trying to post 

-  Notes
(0041265)
hgbot (developer)
2011-09-23 14:54

Repository: erp/devel/pi
Changeset: af9194d3dafdb1b7673a906c18d7cc4550caab05
Author: Mikel Irurita <mikel.irurita <at> openbravo.com>
Date: Fri Sep 23 14:42:30 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/af9194d3dafdb1b7673a906c18d7cc4550caab05 [^]

Fixes issue 18339: Bank Statement document gets locked when trying to post

---
M src/org/openbravo/erpCommon/ad_forms/DocFINBankStatement.java
---
(0041536)
maite (developer)
2011-10-06 17:36

verified
(0041701)
hudsonbot (developer)
2011-10-12 01:59

A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/9bd2b5c2d982 [^]

Maturity status: Test

- Issue History
Date Modified Username Field Change
2011-08-23 11:37 mirurita New Issue
2011-08-23 11:37 mirurita Assigned To => eduardo_Argal
2011-08-23 11:37 mirurita Modules => Core
2011-09-12 09:35 mirurita Target Version 3.0RC4 => 3.0MP4
2011-09-15 12:52 dalsasua Assigned To eduardo_Argal => mirurita
2011-09-23 14:37 mirurita Status new => scheduled
2011-09-23 14:37 mirurita fix_in_branch => pi
2011-09-23 14:54 hgbot Checkin
2011-09-23 14:54 hgbot Note Added: 0041265
2011-09-23 14:54 hgbot Status scheduled => resolved
2011-09-23 14:54 hgbot Resolution open => fixed
2011-09-23 14:54 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/af9194d3dafdb1b7673a906c18d7cc4550caab05 [^]
2011-10-06 17:36 maite Note Added: 0041536
2011-10-06 17:36 maite Status resolved => closed
2011-10-06 17:36 maite Fixed in Version => 3.0MP4
2011-10-12 01:59 hudsonbot Checkin
2011-10-12 01:59 hudsonbot Note Added: 0041701


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker