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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0002448
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] Z. Othersminoralways2008-01-02 15:032008-06-12 09:43
ReportergorkaionView Statuspublic 
Assigned Togorkaion 
PrioritynormalResolutionfixedFixed in Version2.40alpha-r2
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0002448: Problem with default dates format

DescriptionIn several database objects are used different dates as a minimum or maximum dates without any mask. If the NLS_DATE_FORMAT defined in the database is different that the used in the object the application throws a Month not valid exception.

See M_INOUT_CHK_RESTRICTIONS_TRG trigger as an example.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0002913)
gorkaion (viewer)
2008-01-02 18:29
edited on: 2008-06-12 09:23

Logged In: YES
user_id=1500690
Originator: YES

Fixed all default dates to include a to_date function with the correspondent mask.

The default limit dates for comparisons have been set to January 1, 1900 and December 31, 9999.
(0002914)
psarobe (viewer)
2008-06-04 17:03
edited on: 2008-06-12 09:23

Logged In: YES
user_id=1500703
Originator: NO

Tested making a random in some objects (procedures, functions, triggers)
(0006037)
user71
2005-06-01 00:00
edited on: 2008-06-12 09:43

This bug was originally reported in SourceForge bug tracker and then migrated to Mantis.

You can see the original bug report in:
https://sourceforge.net/support/tracker.php?aid=1862189 [^]

- Issue History
Date Modified Username Field Change


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker