Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0028330Openbravo ERPA. Platformpublic2014-12-01 18:002014-12-30 23:28
reinaldoguerra 
reinaldoguerra 
normalmajoralways
closedfixed 
5
 
 
pramakrishnan
Core
No
0028330: "java.lang.IllegalArgumentException: node to traverse cannot be null!" error when executing Reset Accounting
A "java.lang.IllegalArgumentException: node to traverse cannot be null!" exception is shown in log when executing Reset Accounting process.
As 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
No tags attached.
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 
Issue History
2014-12-01 18:00reinaldoguerraNew Issue
2014-12-01 18:00reinaldoguerraAssigned To => reinaldoguerra
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