Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0009287 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] A. Platform | minor | have not tried | 2009-06-02 12:13 | 2009-07-27 00:00 | |||
| Reporter | AinhoaPagola | View Status | public | |||||
| Assigned To | shuehner | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | 2.50MP3 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 3e83886b79dc | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 32 bit | Database | Any | Java version | 1.5 | |||
| OS Version | Ubuntu 8.4 | Database version | Ant version | 1.7 | ||||
| Product Version | main | SCM revision | ||||||
| Review Assigned To | ||||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0009287: Errors thrown from triggers with code -20000 are not correctly displayed in Oracle | |||||||
| Description | If an error message with code -20000 is thrown from a trigger in Oracle, the error message displayed in the application contains the error message and some extra unnecessary information. Example: There is already one default setup record. Only one record is allowed. ORA-06512: en "MAINHCM.HCMC_DEFAULT_TRG", línea 35 ORA-04088: error durante la ejecución del disparador 'MAINHCM.HCMC_DEFAULT_TRG' Notice that the first sentence is the msgtext of the error message thrown. This only happens if the error code used is -20000, it works fine with other codes. This problem is not visible in core because every single error thrown in a trigger has a numeric code in its message value. In modules, the value of the message must start with the prefix so it is not posible to set a number to it an skip this problem. This problem is not reproducible in functions. The translation is properly done in that case. It is also not reproduceable in PostgreSQL, it works fine for triggers and functions. That is, this problem happens: In oracle, for message with string value thrown in triggers. | |||||||
| Steps To Reproduce | - Create a message in add_message with a string value. That is, do not use a numeric value (like 20540) but a string (example "MoreThanOneRecord"). - Raise the error from a trigger. Use this instruction: RAISE_APPLICATION_ERROR(-20000,'@HCMC_OneDefaultRecord@'); - In the application, perform the action that launches the trigger. The error displayed in the error box contains the error message properly translated and some extra error message that shouldn't be visible. | |||||||
| Tags | 250MP3releasecandidate, Modularity | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0017424) hgbot (developer) 2009-06-18 13:22 |
Repository: erp/devel/pi Changeset: 3e83886b79dc5a92c167dc9184a41d3b380cd94f Author: Stefan Hühner <stefan.huehner <at> openbravo.com> Date: Thu Jun 18 13:21:56 2009 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/3e83886b79dc5a92c167dc9184a41d3b380cd94f [^] Fixed 9287. Restrict the incoming error message for code=20000 to one line - Restrict the incoming token string which are translated for the error code 20000 to the first line - If these are raised from inside a trigger a pl-stacktrace is attched to the incoming error string - This change discards the extra stacktrace lines --- M src/org/openbravo/erpCommon/utility/ErrorTextParserORACLE.java --- |
|
(0018157) AinhoaPagola (reporter) 2009-07-13 11:24 |
I have tested the solution and works fine for me. |
|
(0018620) psarobe (manager) 2009-07-26 22:01 |
Thanks Ainhoa |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-06-02 12:13 | AinhoaPagola | New Issue | |
| 2009-06-02 12:13 | AinhoaPagola | Assigned To | => rafaroda |
| 2009-06-02 15:04 | AinhoaPagola | version | => main |
| 2009-06-03 10:02 | rafaroda | Assigned To | rafaroda => shuehner |
| 2009-06-03 10:02 | rafaroda | Priority | normal => high |
| 2009-06-03 10:02 | rafaroda | Status | new => scheduled |
| 2009-06-09 19:35 | AinhoaPagola | Priority | high => urgent |
| 2009-06-18 10:53 | AinhoaPagola | Tag Attached: Modularity | |
| 2009-06-18 13:22 | hgbot | Checkin | |
| 2009-06-18 13:22 | hgbot | Note Added: 0017424 | |
| 2009-06-18 13:22 | hgbot | Status | scheduled => resolved |
| 2009-06-18 13:22 | hgbot | Resolution | open => fixed |
| 2009-06-18 13:22 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/3e83886b79dc5a92c167dc9184a41d3b380cd94f [^] |
| 2009-06-22 11:09 | psarobe | Fixed in Version | => main |
| 2009-07-13 11:24 | AinhoaPagola | Note Added: 0018157 | |
| 2009-07-21 16:24 | psarobe | Fixed in Version | main => 2.50MP3 |
| 2009-07-21 16:26 | psarobe | Tag Attached: 250MP3releasecandidate | |
| 2009-07-26 22:01 | psarobe | Status | resolved => closed |
| 2009-07-26 22:01 | psarobe | Note Added: 0018620 | |
| 2009-07-27 00:00 | anonymous | sf_bug_id | 0 => 2827480 |
| 2009-08-04 15:22 | AinhoaPagola | Relationship added | related to 0010180 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |