Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0000583Openbravo ERPZ. Otherspublic2008-06-09 19:012008-11-26 20:20
psarobe 
rafaroda 
urgenttrivialalways
closedfixed 
5
2.40alpha-r2 
2.50 
Core
No
0000583: Review all the .xsql that has insert or update statements
In some processes or manual windows (.java processes) when an error happens due to a null value, for example, then a message shows up "ProcessRunError". This message is not clear at all and in the log you can see perfectly the error for example:ORA-01400: no se puede realizar una inserciĆ³n NULL en ("TAD240R2"."C_INVOICE"."PAYMENTRULE"
1. Go to project service management->transactions->Expense sheet
2. Click new and save. Very important to select an employee without a payment rule(as a vendor)
3. Move to lines. Click new and select a product, reinvoicing, a business partner.
4. Move back to Header and process
5. Go to Create AP expense invoices and select that employee and the dates to invoice the expense sheet

It will give you a message error "ProcessRunError"
We should catch somehow the error and show it instead of "ProcessRunError"
ReleaseCandidate
related to defect 00023012.40 closed rafaroda Create SO from Expenses & AP Expense Invoice messages review 
Issue History
2008-06-09 19:01psarobeNew Issue
2008-06-09 19:01psarobeAssigned To => cromero
2008-06-09 19:02psarobeStatusnew => scheduled
2008-06-17 11:35pjuvaraRelationship addedhas duplicate 0002301
2008-06-17 11:44pjuvaraTypedefect => feature request
2008-06-17 11:53rafarodaRelationship deletedhas duplicate 0002301
2008-06-17 11:54rafarodaRelationship addedrelated to 0002301
2008-06-17 11:55rafarodaNote Added: 0007773
2008-06-24 18:48pjuvaraTag Attached: ReleaseCandidate
2008-06-24 18:48pjuvaraPrioritynormal => urgent
2008-06-24 18:48pjuvaraSeveritymajor => trivial
2008-07-01 17:56anonymoussf_bug_id0 => 2007942
2008-07-09 13:09cromeroAssigned Tocromero => rafaroda
2008-10-11 15:37rafarodaNote Added: 0009516
2008-10-11 15:37rafarodaStatusscheduled => resolved
2008-10-11 15:37rafarodasvn_revision => 8583
2008-11-26 20:20pjuvaraStatusresolved => closed

Notes
(0007773)
rafaroda   
2008-06-17 11:55   
Bug 2301 is a particular case of the current general bug.
(0009516)
rafaroda   
2008-10-11 15:37   
Project http://wiki.openbravo.com/wiki/Projects/XSQL_Insert_Update_Review [^]