Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0006307 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 01. General setup | major | always | 2008-12-01 18:09 | 2009-04-21 12:36 | |||
| Reporter | galderromo | View Status | public | |||||
| Assigned To | anthony_wolski | |||||||
| Priority | high | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | 12082 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 32 bit | Database | Oracle | Java version | 1.5.0_15 | |||
| OS Version | Gentoo 2.6.24 | Database version | XE | Ant version | 1.7 | |||
| Product Version | 2.35MP4 | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0006307: Alert rules define alert names longer than REFERENCEKEY_ID column in AD_ALERT table | |||||||
| Description | The disabled constraints ad_alertrule (id=1000008) can cause a database error. The constraint name (referencekey_id) can be larger than defined column at AD_ALERT. This database error avoids the application working as expected. > javax.servlet.ServletException: @CODE=12899@ORA-12899: value too large for column "TAD_HOLDING"."AD_ALERT"."REFERENCEKEY_ID" (actual: 23, maximum: 20) > >at org.openbravo.erpCommon.ad_background.PeriodicAlertData.InsertAlert >at org.openbravo.erpCommon.ad_background.PeriodicAlertData.InsertAlert >at org.openbravo.erpCommon.ad_background.PeriodicAlert.processAlert >at org.openbravo.erpCommon.ad_background.PeriodicAlert.processPL >at org.openbravo.erpCommon.ad_background.PeriodicBackground.process >at org.openbravo.erpCommon.ad_background.PeriodicBackground.run(Unknown Source) >at java.lang.Thread.run(Thread.java:595) Also happends in other alert rules as disactivated triggers. A general review is needed. | |||||||
| Steps To Reproduce | Make sure your alert background process is enabled, disable a constraint and have a look to your OpenbravoERP logs. | |||||||
| Proposed Solution | Cut the length of the names to 20 characters, so the background process won't fail on inserting. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0010854) galderromo (viewer) 2008-12-01 18:10 |
On the proposed solution, I mean cutting the length of the constraint name on the select statement but not cutting the constraint name on database. :) |
|
(0012325) psarobe (viewer) 2009-01-19 13:02 |
Galder please update the product version combo |
|
(0012367) galderromo (viewer) 2009-01-19 20:58 |
I can not update the product version, but is 2.35 + MP4 |
|
(0012433) svnbot (viewer) 2009-01-21 10:43 |
Repository: openbravo Revision: 12082 Author: anthony.wolski Date: 2009-01-21 10:43:34 +0100 (Wed, 21 Jan 2009) Fixes issue 0006307. AD_ALERT.REFERENCEKEY_ID size increased from 20 to 30 --- U branches/r2.3x/database/model/tables/AD_ALERT.xml --- https://dev.openbravo.com/websvn/openbravo/?rev=12082&sc=1 [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2008-12-01 18:09 | galderromo | New Issue | |
| 2008-12-01 18:09 | galderromo | Assigned To | => rafaroda |
| 2008-12-01 18:09 | galderromo | sf_bug_id | 0 => 2372259 |
| 2008-12-01 18:10 | galderromo | Note Added: 0010854 | |
| 2008-12-03 19:03 | pjuvara | Priority | normal => high |
| 2008-12-09 12:24 | pheenan | Assigned To | rafaroda => pheenan |
| 2008-12-09 12:24 | pheenan | Status | new => scheduled |
| 2008-12-09 12:24 | pheenan | fix_in_branch | => trunk |
| 2008-12-18 16:17 | pheenan | Assigned To | pheenan => Hennadzi |
| 2008-12-22 14:50 | PavelPonomarev | Assigned To | Hennadzi => rafaroda |
| 2009-01-10 17:55 | rafaroda | Assigned To | rafaroda => anthony_wolski |
| 2009-01-19 13:02 | psarobe | Note Added: 0012325 | |
| 2009-01-19 13:03 | psarobe | Status | scheduled => feedback |
| 2009-01-19 20:58 | galderromo | Note Added: 0012367 | |
| 2009-01-20 17:18 | anthony_wolski | OBNetwork customer | => No |
| 2009-01-20 17:18 | anthony_wolski | version | => 2.35MP4 |
| 2009-01-20 17:18 | anthony_wolski | fix_in_branch | trunk => |
| 2009-01-21 10:43 | svnbot | Checkin | |
| 2009-01-21 10:43 | svnbot | Note Added: 0012433 | |
| 2009-01-21 10:43 | svnbot | Status | feedback => resolved |
| 2009-01-21 10:43 | svnbot | Resolution | open => fixed |
| 2009-01-21 10:43 | svnbot | svn_revision | => 12082 |
| 2009-04-21 12:36 | psarobe | Status | resolved => closed |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |