Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0000255Openbravo ERP05. Production managementpublic2008-05-10 21:342009-03-18 11:01
plujan 
cromero 
urgentcriticalhave not tried
closedno change required 
5
2.35 
 
Core
No
0000255: AT235mp4 - On PostgreSQL I cannot process a Work Requirement
When I click on Work Requirement Process button I get an error message. See attach.

Log file says:
16:24:17 [http-8080-3] ERROR org.openbravo.erpCommon.utility.TableSQLData - Parsing failed on orderby clause: MA_Sequence.Value ASC, MA_Sequence.SeqNo ASC - pos: 21
16:25:09 [http-8080-3] ERROR org.openbravo.erpCommon.utility.TableSQLData - Parsing failed on orderby clause: MA_Sequence.Value ASC, MA_Sequence.SeqNo ASC - pos: 21
16:25:53 [http-8080-3] ERROR org.openbravo.erpCommon.security.Logout - Error captured: java.lang.IllegalStateException
# Login as userA
# Go to Production management->Transactions->Work requirement->Header
# Click New and fill:

    * Select Production Final goods A as process plan
    * Quantity=10
    * Starting Date= The current day
    * Ending Date= The following date

# Save and click on button "Work requirement process"
No tags attached.
jpg r235mp4_PG_BUG_ProcessingWorkRequirement.JPG (59,415) 2008-05-10 21:34
https://issues.openbravo.com/file_download.php?file_id=26&type=bug
jpg
Issue History
2008-05-10 21:34plujanNew Issue
2008-05-10 21:34plujanAssigned To => cromero
2008-05-10 21:34plujanFile Added: r235mp4_PG_BUG_ProcessingWorkRequirement.JPG
2008-05-11 18:00cromeroNote Added: 0000130
2008-05-11 18:00cromeroStatusnew => feedback
2008-05-11 21:15plujanStatusfeedback => closed
2008-05-11 21:15plujanNote Added: 0000137
2008-05-11 21:15plujanResolutionopen => no change required
2009-03-18 11:01anonymoussf_bug_id0 => 2691252

Notes
(0000130)
cromero   
2008-05-11 18:00   
Have you verified that you do not have any product in the:
Production Management || Transactions || Process Plan || Process Plan >> Version >> Operation >> I/O Products
with Production Type equals to "Non stocked product"
(0000137)
plujan   
2008-05-11 21:15   
I had a product with "Non stocked product" option on Process Plan. I changed it and the work requirement works fine.