Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0038664Openbravo ERPA. Platformpublic2018-05-30 19:032018-07-17 10:13
Reporterjarmendariz 
Assigned Toplatform 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR18Q4 
Merge Request Status
Review Assigned Tocaristu
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0038664: Exceptions generated by trigger appears twice when using Oracle
DescriptionOn Postgres when a trigger exception is raised, Hibernate print a log line reporting the error. However, when Oracle is used, this log line is printed twice.
Steps To ReproduceAssuming that the ERP is using Oracle and no module has the "In Development" field checked:
- Log in as System Administrator
- Go to [Windows, Tabs and Fields]
- Edit any window, change its name and save
- It should appear an error message "Saving failed. Cannot update an object in a module not in development and without an active template"

Now if checking the Hibernate log, the following error line should appear twice:

ERROR org.hibernate.util.JDBCExceptionReporter - ORA-20000: @20532@
ORA-06512: at "INT_FULL_ORACLE.AD_WINDOW_MOD_TRG", line 78
ORA-04088: error during execution of trigger 'INT_FULL_ORACLE.AD_WINDOW_MOD_TRG'
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to feature request 0037064 closed caristu upgrade hibernate to 5.3.2 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2018-05-30 19:03jarmendarizNew Issue
2018-05-30 19:03jarmendarizAssigned To => platform
2018-05-30 19:03jarmendarizModules => Core
2018-05-30 19:03jarmendarizTriggers an Emergency Pack => No
2018-05-30 19:07jarmendarizNote Added: 0104818
2018-05-30 19:09jarmendarizRelationship addedrelated to 0037064
2018-06-13 09:26caristuNote Added: 0105114
2018-06-15 10:56alostaleNote Added: 0105172
2018-06-15 10:56alostaleStatusnew => acknowledged
2018-06-15 10:56alostaleTypedefect => design defect
2018-07-17 10:11caristuStatusacknowledged => scheduled
2018-07-17 10:13caristuReview Assigned To => caristu
2018-07-17 10:13caristuNote Added: 0105769
2018-07-17 10:13caristuStatusscheduled => closed
2018-07-17 10:13caristuResolutionopen => fixed
2018-07-17 10:13caristuFixed in Version => 3.0PR18Q4

Notes
(0104818)
jarmendariz   
2018-05-30 19:07   
This is a Hibernate with Oracle bug. The double print is generated in JDBCExceptionReporter:logExceptions(SqlException, String). Check if this behavior can still be reproduced with the latest version of Hibernate, and if so, report it.
(0105114)
caristu   
2018-06-13 09:26   
Reported to Hibernate: https://hibernate.atlassian.net/browse/HHH-12688 [^]
(0105172)
alostale   
2018-06-15 10:56   
Moving to design defect as it is an issue in Hibernate: https://hibernate.atlassian.net/browse/HHH-12688 [^]
(0105769)
caristu   
2018-07-17 10:13   
Fixed with 0037064

Starting from Hibernate version 5.3.2 this issue is fixed.