Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0018606Openbravo ERPZ. Otherspublic2011-08-23 11:372011-10-06 19:01
Reportermirurita 
Assigned Tomirurita 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target Version2.50MP35Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0018606: 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
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 00183393.0MP4 closed mirurita Bank Statement document gets locked when trying to post 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-09-23 14:37miruritaTypedefect => backport
2011-09-23 14:37miruritafix_in_branch => 2.50
2011-09-27 11:57miruritaTarget Version3.0MP4 => 2.50MP35
2011-10-06 12:12hgbotCheckin
2011-10-06 12:12hgbotNote Added: 0041527
2011-10-06 12:12hgbotStatusscheduled => resolved
2011-10-06 12:12hgbotResolutionopen => fixed
2011-10-06 12:12hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/59de9c3ad920b4b2f535df45b2f12b70aa2af872 [^]
2011-10-06 19:01maiteNote Added: 0041537
2011-10-06 19:01maiteStatusresolved => closed

Notes
(0041527)
hgbot   
2011-10-06 12:12   
Repository: erp/stable/2.50
Changeset: 59de9c3ad920b4b2f535df45b2f12b70aa2af872
Author: Mikel Irurita <mikel.irurita <at> openbravo.com>
Date: Fri Sep 23 14:38:48 2011 +0200
URL: http://code.openbravo.com/erp/stable/2.50/rev/59de9c3ad920b4b2f535df45b2f12b70aa2af872 [^]

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

---
M src/org/openbravo/erpCommon/ad_forms/DocFINBankStatement.java
---
(0041537)
maite   
2011-10-06 19:01   
verified