Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0018339Openbravo ERPZ. Otherspublic2011-08-23 11:372011-10-12 01:59
Reportermirurita 
Assigned Tomirurita 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target Version3.0MP4Fixed in Version3.0MP4 
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
Summary0018339: 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
depends on backport 00186062.50MP35 closed mirurita Bank Statement document gets locked when trying to post 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-08-23 11:37miruritaNew Issue
2011-08-23 11:37miruritaAssigned To => eduardo_Argal
2011-08-23 11:37miruritaModules => Core
2011-09-12 09:35miruritaTarget Version3.0RC4 => 3.0MP4
2011-09-15 12:52dalsasuaAssigned Toeduardo_Argal => mirurita
2011-09-23 14:37miruritaStatusnew => scheduled
2011-09-23 14:37miruritafix_in_branch => pi
2011-09-23 14:54hgbotCheckin
2011-09-23 14:54hgbotNote Added: 0041265
2011-09-23 14:54hgbotStatusscheduled => resolved
2011-09-23 14:54hgbotResolutionopen => fixed
2011-09-23 14:54hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/af9194d3dafdb1b7673a906c18d7cc4550caab05 [^]
2011-10-06 17:36maiteNote Added: 0041536
2011-10-06 17:36maiteStatusresolved => closed
2011-10-06 17:36maiteFixed in Version => 3.0MP4
2011-10-12 01:59hudsonbotCheckin
2011-10-12 01:59hudsonbotNote Added: 0041701

Notes
(0041265)
hgbot   
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   
2011-10-06 17:36   
verified
(0041701)
hudsonbot   
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