Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0039149
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformminoralways2018-08-17 11:522018-09-24 16:15
ReportervmromanosView Statuspublic 
Assigned ToTriage Finance 
PrioritynormalResolutionno change requiredFixed in Version3.0PR18Q4
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version3.0PR18Q4
OSAnyDatabaseOracleJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Merge Request Status
Review Assigned Tocaristu
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0039149: Error message thrown by Oracle trigger after Hibernate upgrade [Oracle only]

DescriptionOne of our AWO JUnit test is failing after the Hibernate upgrade in Oracle only. It seems there is a regression in the way the message is caught, parsed and then sent to the UI.
Steps To ReproduceIt is easily reproducible in the mod-awo job. See for example https://ci.openbravo.com/job/mod-simple/27521/testReport/junit/org.openbravo.warehouse.advancedwarehouseoperations.test/AWOb_BasicFunctionalFlowsWithAWOPreference/aWOb040B_AWOEnabledInventoryCountNotCompleted/ [^]


Error message:

The exception thrown should have been "could not execute update query" :
Expected: "ERROR: @OBAWO_FlowEnabled@"
     but: was "ORA-20000: @OBAWO_FlowEnabled@\nORA-06512: at \"MOD_SIMPLE_CI23141.OBAWO_M_TRANSACTION_TRG\", line 151\nORA-04088: error during execution of trigger 'MOD_SIMPLE_CI23141.OBAWO_M_TRANSACTION_TRG'\n"
Proposed SolutionChange the code that parses the error message thrown by the trigger in Oracle to behave the same way as before the Hibernate upgrade
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 00219113.0MP18 closedioritzCia Wrong error when processing inventory 
caused by feature request 0037064 closedcaristu upgrade hibernate to 5.3.2 
related to defect 0039163 closedAtulOpenbravo QueryTimeoutException is no longer thrown in Oracle after Hibernate 5.3 upgrade 

-  Notes
(0106416)
caristu (viewer)
2018-08-21 08:32
edited on: 2018-08-21 08:33

 This issue is caused due to an internal change in the exception handling performed by Hibernate. In this case, a GenericJDBCException is now thrown instead of a QueryTimeoutException.

To fix this issue, I think that the best solution is to adapt the code when catching the GenericJDBCException.

- In the test: assert using containsString as it is done for the QueryTimeoutException (https://code.openbravo.com/erp/pmods/org.openbravo.warehouse.advancedwarehouseoperations/file/tip/src-test/org/openbravo/warehouse/advancedwarehouseoperations/test/AWOb_BasicFunctionalFlowsWithAWOPreference.java#l343 [^])

- In the InventoryCountProcess: parse the message as it is done for the QueryTimeoutException to show the error message properly in the UI (https://code.openbravo.com/erp/devel/pi/file/tip/src/org/openbravo/materialmgmt/InventoryCountProcess.java#l128 [^])
(0106970)
caristu (viewer)
2018-09-24 16:15

 - Test is fixed. See[1]
- Exception handling in InventoryCountProcess should be fixed with issue 0039163

See here[2] to see the updated information in the Migration Guide.

[1] https://code.openbravo.com/erp/pmods/org.openbravo.warehouse.advancedwarehouseoperations/diff/b25f5f796c3f/src-test/org/openbravo/warehouse/advancedwarehouseoperations/test/AWOb_BasicFunctionalFlowsWithAWOPreference.java [^]

[2] http://wiki.openbravo.com/wiki/Hibernate_5.3_Migration_Guide#Oracle_and_Trigger_Errors [^]

- Issue History
Date Modified Username Field Change
2018-08-17 11:52 vmromanos New Issue
2018-08-17 11:52 vmromanos Assigned To => platform
2018-08-17 11:52 vmromanos OBNetwork customer => No
2018-08-17 11:52 vmromanos Modules => Core
2018-08-17 11:52 vmromanos Triggers an Emergency Pack => No
2018-08-17 11:53 vmromanos Relationship added caused by 0037064
2018-08-20 13:20 caristu Relationship added related to 0021911
2018-08-21 08:32 caristu Note Added: 0106416
2018-08-21 08:33 caristu Note Edited: 0106416 View Revisions
2018-08-21 09:35 caristu Assigned To platform => Triage Finance
2018-08-21 13:11 caristu Relationship added related to 0039163
2018-09-24 16:15 caristu Review Assigned To => caristu
2018-09-24 16:15 caristu Note Added: 0106970
2018-09-24 16:15 caristu Status new => closed
2018-09-24 16:15 caristu Resolution open => no change required
2018-09-24 16:15 caristu Fixed in Version => 3.0PR18Q4

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker