Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0017018 | Openbravo ERP | A. Platform | public | 2011-05-05 09:49 | 2015-02-24 11:13 |
|
| Reporter | vmromanos | |
| Assigned To | marvintm | |
| Priority | normal | Severity | minor | Reproducibility | have not tried |
| Status | closed | Resolution | duplicate | |
| Platform | | OS | 20 | OS Version | Debian 5.0 |
| Product Version | | |
| Target Version | | Fixed in Version | | |
| Merge Request Status | |
| Review Assigned To | |
| OBNetwork customer | |
| Web browser | |
| Modules | Core |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0017018: DalStoredProcedureTest.testCallProcess fails only in Oracle |
| Description | Due to the clean-up project (i.e., removing deprecated/old/unused stuff in Core), I have modified the DalStoredProcedureTest.testCallProcess JUnit test (the table and process used are no longer available in core)
When modifying it, I have tried to keep your original structure, and just change the necessary code (diff attached):
1. I have set core as indevelopment (to override a trigger check)
2. I have modified the original db process by another one that essential does the same: copying some records (fields) from the database
The problem we have seen is that the process fails just in Oracle (http://builds.openbravo.com/job/int-dbcons-oracle/1602/console [^]). As you can see, when exporting the DB, all the fields created by the process are exported, so the database has been modified.
If you take a look at the end of the method, there is a rollback call that shouldn't commit the changes.
What is strange is that this code is working fine in PostgreSQL.
Right now the test is deactivated, so the integration process is not stopped.
FYI: the Oracle instance where it fails has the AUTOCOMMIT = OFF |
| Steps To Reproduce | |
| Proposed Solution | |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | | duplicate of | design defect | 0028875 | | acknowledged | Triage Platform Base | Class "CallStoredProcedure" does not support parameters of type out |
|
| Attached Files |  DalStoredProcedureTest-cleanup.diff (5,444) 2011-05-05 09:49
https://issues.openbravo.com/file_download.php?file_id=3941&type=bug |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2011-05-05 09:49 | vmromanos | New Issue | |
| 2011-05-05 09:49 | vmromanos | Assigned To | => mtaal |
| 2011-05-05 09:49 | vmromanos | File Added: DalStoredProcedureTest-cleanup.diff | |
| 2011-05-05 09:49 | vmromanos | Modules | => Core |
| 2011-05-16 10:06 | alostale | Status | new => scheduled |
| 2011-11-04 19:56 | mtaal | Assigned To | mtaal => marvintm |
| 2015-02-24 11:12 | alostale | Relationship added | related to 0028875 |
| 2015-02-24 11:12 | alostale | Relationship replaced | has duplicate 0028875 |
| 2015-02-24 11:13 | alostale | Relationship replaced | duplicate of 0028875 |
| 2015-02-24 11:13 | alostale | Status | scheduled => closed |
| 2015-02-24 11:13 | alostale | Resolution | open => duplicate |