Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0027732
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementcriticalhave not tried2014-10-01 23:242014-10-02 12:21
ReportershuehnerView Statuspublic 
Assigned Toshuehner 
PriorityimmediateResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision29393001329e
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
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
Summary

0027732: 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-
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  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 (viewer)
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

- 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 OBNetwork customer => No
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

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker