Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0027732 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 09. Financial management | critical | have not tried | 2014-10-01 23:24 | 2014-10-02 12:21 | |||
| Reporter | shuehner | View Status | public | |||||
| Assigned To | shuehner | |||||||
| Priority | immediate | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | 29393001329e | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Review Assigned To | eduardo_Argal | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | Automated tests | |||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0027732: m_costing_rule_trg has broken syntax breaking at least oracle | |||||||
| Description | Line 36 in that trigger has a date-format mask of DD-MM-YYY which is missing 4th Y for the date. Breaking trigger on oracle. Example failure: http://ci.openbravo.com/view/retail/job/ret-inc-oracle/914/console [^] [java] 76905 WARN - SQL Command failed with: ORA-01830: date format picture ends before converting entire input string [java] ORA-06512: at "RET_INC_ORACLE.M_COSTING_RULE_TRG", line 37 [java] ORA-04088: error during execution of trigger 'RET_INC_ORACLE.M_COSTING_RULE_TRG' | |||||||
| Steps To Reproduce | - | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0070633) shuehner (administrator) 2014-10-02 00:05 |
Note: marking as regression as it appeared now as effect like a regression. Checking that line 37 in that trigger the wrong date-mask is there since the addition of that trigger to the erp in 2012. Not completely clear why only fails now. |
|
(0070634) hgbot (developer) 2014-10-02 00:34 |
Repository: erp/devel/pi Changeset: 29393001329ed341c8dc2d89882f54db3a0e022f Author: Stefan Hühner <stefan.huehner <at> openbravo.com> Date: Wed Oct 01 23:27:27 2014 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/29393001329ed341c8dc2d89882f54db3a0e022f [^] Fixed 27732. Fix wrong dateformat changing DD-MM-YYY to DD-MM-YYYY --- M src-db/database/model/triggers/M_COSTING_RULE_TRG.xml --- |
|
(0070656) eduardo_Argal (developer) 2014-10-02 12:21 |
Code Reviewed and tested. New module script was raising this issue as it is updating records inside that table and then this fires the trigger. Now it is working fine after the fix |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2014-10-01 23:24 | shuehner | New Issue | |
| 2014-10-01 23:24 | shuehner | Assigned To | => dmiguelez |
| 2014-10-01 23:24 | shuehner | Modules | => Core |
| 2014-10-01 23:24 | shuehner | Triggers an Emergency Pack | => No |
| 2014-10-01 23:25 | shuehner | Assigned To | dmiguelez => shuehner |
| 2014-10-01 23:25 | shuehner | Regression level | => Automated tests |
| 2014-10-02 00:05 | shuehner | Note Added: 0070633 | |
| 2014-10-02 00:34 | hgbot | Checkin | |
| 2014-10-02 00:34 | hgbot | Note Added: 0070634 | |
| 2014-10-02 00:34 | hgbot | Status | new => resolved |
| 2014-10-02 00:34 | hgbot | Resolution | open => fixed |
| 2014-10-02 00:34 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/29393001329ed341c8dc2d89882f54db3a0e022f [^] |
| 2014-10-02 09:21 | gorka_gil | Issue Monitored: gorka_gil | |
| 2014-10-02 12:21 | eduardo_Argal | Review Assigned To | => eduardo_Argal |
| 2014-10-02 12:21 | eduardo_Argal | Note Added: 0070656 | |
| 2014-10-02 12:21 | eduardo_Argal | Status | resolved => closed |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |