Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0028330Openbravo ERPA. Platformpublic2014-12-01 18:002014-12-30 23:28
Reporterreinaldoguerra 
Assigned Toreinaldoguerra 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Topramakrishnan
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0028330: "java.lang.IllegalArgumentException: node to traverse cannot be null!" error when executing Reset Accounting
DescriptionA "java.lang.IllegalArgumentException: node to traverse cannot be null!" exception is shown in log when executing Reset Accounting process.
Steps To ReproduceAs group Admin role:
1- Execute Reset Accounting process from Financial management - Accounting - Transactions menu
2- Select C_Order table
3- Click OK button and realize that "Error Reseting Accounting" is shown. Also an exception (java.lang.IllegalArgumentException: node to traverse cannot be null!) is registered in the log
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 00281633.0PR15Q1 closed reinaldoguerra "java.lang.IllegalArgumentException: node to traverse cannot be null!" error when trying to Unpost an Order 
related to defect 0030663 closed AtulOpenbravo Error Reseting Accounting if a table without processing column or with acctdate_column_id null is included in GL configuration 
related to design defect 0037708 acknowledged Triage Platform Base Update of Order table not working in HQL 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-12-01 18:00reinaldoguerraNew Issue
2014-12-01 18:00reinaldoguerraAssigned To => reinaldoguerra
2014-12-01 18:00reinaldoguerraOBNetwork customer => Yes
2014-12-01 18:00reinaldoguerraModules => Core
2014-12-01 18:00reinaldoguerraTriggers an Emergency Pack => No
2014-12-01 18:01reinaldoguerraRelationship addedrelated to 0028163
2014-12-01 18:02reinaldoguerraStatusnew => scheduled
2014-12-02 03:43reinaldoguerraNote Added: 0072220
2014-12-30 09:05hgbotCheckin
2014-12-30 09:05hgbotNote Added: 0072866
2014-12-30 09:05hgbotStatusscheduled => resolved
2014-12-30 09:05hgbotResolutionopen => fixed
2014-12-30 09:05hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/1c4fc1c5303fcfac6852fd4916c37078b9eaedeb [^]
2014-12-30 09:05pramakrishnanReview Assigned To => pramakrishnan
2014-12-30 09:05pramakrishnanNote Added: 0072867
2014-12-30 09:05pramakrishnanStatusresolved => closed
2014-12-30 23:28hudsonbotCheckin
2014-12-30 23:28hudsonbotNote Added: 0073276
2015-08-25 12:33ngarciaRelationship addedrelated to 0030663
2018-01-23 18:51aferrazRelationship addedrelated to 0037708

Notes
(0072220)
reinaldoguerra   
2014-12-02 03:43   
Test plan used:
1- Login into Openbravo ERP
2- Execute Reset Accounting process from Financial management - Accounting - Transactions menu
3- Select C_Order table and do not check "Delete existing Accounting entries"
4- Click OK button, process now does not launches any error and is executed successfuly
(0072866)
hgbot   
2014-12-30 09:05   
Repository: erp/devel/pi
Changeset: 1c4fc1c5303fcfac6852fd4916c37078b9eaedeb
Author: Reinaldo Guerra <reinaldo.guerra <at> peoplewalking.com>
Date: Mon Dec 01 18:36:51 2014 -0500
URL: http://code.openbravo.com/erp/devel/pi/rev/1c4fc1c5303fcfac6852fd4916c37078b9eaedeb [^]

Fixed bug 28330: IllegalArgumentException error when executing Reset Accounting.

HQL Query when updating order status during reset accounting process, launches an hibernate exception when parsing "Order" keyword. In order to avoid this, ResetAccounting java class was changed to use native SQL Query instead of HQL Query in the logic of restore method.
This changes takes into account all kind of unposteable openbravo entities listed in Reset Accounting window's process. Now it is possible to reset c_order table accounting information successfuly.

---
M src/org/openbravo/financial/ResetAccounting.java
---
(0072867)
pramakrishnan   
2014-12-30 09:05   
verified
(0073276)
hudsonbot   
2014-12-30 23:28   
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/6525fe229e06 [^]
Maturity status: Test