Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0027732Openbravo ERP09. Financial managementpublic2014-10-01 23:242014-10-02 12:21
Reportershuehner 
Assigned Toshuehner 
PriorityimmediateSeveritycriticalReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Toeduardo_Argal
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression levelAutomated tests
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0027732: m_costing_rule_trg has broken syntax breaking at least oracle
DescriptionLine 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-
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-10-01 23:24shuehnerNew Issue
2014-10-01 23:24shuehnerAssigned To => dmiguelez
2014-10-01 23:24shuehnerOBNetwork customer => No
2014-10-01 23:24shuehnerModules => Core
2014-10-01 23:24shuehnerTriggers an Emergency Pack => No
2014-10-01 23:25shuehnerAssigned Todmiguelez => shuehner
2014-10-01 23:25shuehnerRegression level => Automated tests
2014-10-02 00:05shuehnerNote Added: 0070633
2014-10-02 00:34hgbotCheckin
2014-10-02 00:34hgbotNote Added: 0070634
2014-10-02 00:34hgbotStatusnew => resolved
2014-10-02 00:34hgbotResolutionopen => fixed
2014-10-02 00:34hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/29393001329ed341c8dc2d89882f54db3a0e022f [^]
2014-10-02 09:21gorka_gilIssue Monitored: gorka_gil
2014-10-02 12:21eduardo_ArgalReview Assigned To => eduardo_Argal
2014-10-02 12:21eduardo_ArgalNote Added: 0070656
2014-10-02 12:21eduardo_ArgalStatusresolved => closed

Notes
(0070633)
shuehner   
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   
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   
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