Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0028898ModulesWarehouse Pickingpublic2015-02-09 18:072015-05-25 16:17
Reportercaristu 
Assigned ToTriage Omni WMS 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusnewResolutionopen 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Support ticket
OBNetwork customer
Regression introduced in release
Summary0028898: Error messages are not retrieved properly in Warehouse Picking List module
DescriptionError messages are not retrieved properly in Warehouse Picking List module. An error is thrown when trying to recover the error text message from the database:

 ERROR org.openbravo.erpCommon.utility.MessageBDData - SQL error in query: SELECT coalesce(t.MSGTEXT, m.MSGTEXT) AS MSGTEXT FROM AD_MESSAGE m left join AD_MESSAGE_TRL t on m.AD_MESSAGE_ID = t.AD_MESSAGE_ID and t.AD_LANGUAGE = ? WHERE m.VALUE=?Exception:org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
867946fe 636371

867946fe 636371 [http-8082-1] ERROR org.openbravo.erpCommon.utility.BasicUtility - Error getting message
javax.servlet.ServletException: @CODE=0@ERROR: current transaction is aborted, commands ignored until end of transaction block
    at org.openbravo.erpCommon.utility.MessageBDData.message(MessageBDData.java:131)
    at org.openbravo.erpCommon.utility.BasicUtility.messageBD(BasicUtility.java:75)
    at org.openbravo.erpCommon.utility.OBMessageUtils.messageBD(OBMessageUtils.java:113)

....

Steps To ReproduceForce any error message to appear. For example:

1) Create a new Sales Order with one line at least
2) Go to the [Warehouse Picking List] window, create a new record in the header of type outbound
3) Click on the "Select Orders" button and choose the order created in 1)
4) Navigate to the generated reservation and put it "on hold"
5) In the [Warehouse Picking List] window, remove the line created in step 3)
6) Click on the "Select Orders" button again, and try to select the same order. An error appears but not with the correct text message (See attached)
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Filespng ErrorMessage.png (9,774) 2015-02-09 18:07
https://issues.openbravo.com/file_download.php?file_id=7775&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2015-02-09 18:07caristuNew Issue
2015-02-09 18:07caristuAssigned To => naiaramartinez
2015-02-09 18:07caristuFile Added: ErrorMessage.png
2015-02-09 18:07caristuResolution time => 1426201200
2015-02-09 18:08caristuAssigned Tonaiaramartinez => Sandrahuguet
2015-02-09 18:08caristuIssue Monitored: networkb
2015-02-19 16:03SandrahuguetAssigned ToSandrahuguet => jorge-garcia
2015-02-23 09:53SandrahuguetAssigned Tojorge-garcia => Sandrahuguet
2015-03-09 17:27jonalegriaesarteResolution time1426201200 =>
2015-05-25 16:17eduardo_ArgalAssigned ToSandrahuguet => Triage Finance

There are no notes attached to this issue.