Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0007042Openbravo ERP00. Application dictionarypublic2009-01-21 10:502009-05-20 09:18
Reporteranthony_wolski 
Assigned Toanthony_wolski 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40 
Target Version2.40Fixed in Version2.40MP3 
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
Summary0007042: Backport for issue: AD_ALERT.REFERENCEKEY_ID size too small
DescriptionInserting an alert into AD_ALERT can cause error as USER_CONSTRAINT.CONSTRAINT_NAME is varchar(30) and AD_ALERT.REFERENCEKEY_ID is varchar(20).
Steps To ReproduceSee steps to reproduce in https://issues.openbravo.com/view.php?id=6307 [^]
Proposed SolutionIncrease size of AD_ALERT.REFERENCEKEY_ID to 30
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-01-21 10:50anthony_wolskiNew Issue
2009-01-21 10:50anthony_wolskiAssigned To => anthony_wolski
2009-01-21 10:50anthony_wolskiOBNetwork customer => No
2009-01-21 10:50anthony_wolskiRegression testing => No
2009-01-21 13:13anthony_wolskiStatusnew => acknowledged
2009-01-21 13:13anthony_wolskiStatusacknowledged => scheduled
2009-01-21 13:13anthony_wolskifix_in_branch => trunk
2009-01-21 13:14svnbotCheckin
2009-01-21 13:14svnbotNote Added: 0012450
2009-01-21 13:14svnbotStatusscheduled => resolved
2009-01-21 13:14svnbotResolutionopen => fixed
2009-01-21 13:14svnbotsvn_revision => 12088
2009-05-20 09:18sureshbabuStatusresolved => closed
2009-05-20 09:18sureshbabuNote Added: 0016488
2009-05-20 09:18sureshbabuFixed in Version => 2.40MP3

Notes
(0012450)
svnbot   
2009-01-21 13:14   
Repository: openbravo
Revision: 12088
Author: anthony.wolski
Date: 2009-01-21 13:14:24 +0100 (Wed, 21 Jan 2009)

Fixes issue 0007042. AD_ALERT.REFERENCEKEY_ID size increased from 20 to 30

---
U branches/r2.40/src-db/database/model/tables/AD_ALERT.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=12088&sc=1 [^]
(0016488)
sureshbabu   
2009-05-20 09:18   
AD_ALERT.REFERENCEKEY_ID size has been increased from 20 to 30

Tested.