Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0018339 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] Z. Others | major | always | 2011-08-23 11:37 | 2011-10-12 01:59 | |||
| Reporter | mirurita | View Status | public | |||||
| Assigned To | mirurita | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | 3.0MP4 | |||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | af9194d3dafd | |||
| Projection | none | ETA | none | Target Version | 3.0MP4 | |||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | pi | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0018339: Bank Statement document gets locked when trying to post | |||||||
| Description | getDocumentConfirmation 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 Reproduce | 1) 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 | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
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 (viewer) 2011-10-06 17:36 |
verified |
|
(0041701) hudsonbot (viewer) 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 |
|
Notes |
|
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-08-23 11:37 | mirurita | OBNetwork customer | => No |
| 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 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |