Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0012512 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 02. Master data management | minor | always | 2010-03-01 17:54 | 2011-09-16 09:13 | |||
| Reporter | Dowid | View Status | public | |||||
| Assigned To | jonalegriaesarte | |||||||
| Priority | normal | Resolution | unable to reproduce | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | |||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Windows | Database | PostgreSQL | Java version | ||||
| OS Version | XP | Database version | 8.3 | Ant version | ||||
| Product Version | pi | SCM revision | ||||||
| Review Assigned To | ||||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0012512: An error while renaming an Attrubute | |||||||
| Description | Postgers error while renaming an Attribute value. ERROR: function instr(character varying, unknown, integer, numeric) does not exist | |||||||
| Steps To Reproduce | 1.Go to Master Data Management || Product Setup || Attribute || Attribute >> Attribute Value 2. rename attribute value name and save | |||||||
| Tags | No tags attached. | |||||||
| Attached Files |  attribute_renaming_error.png [^] (53,127 bytes) 2010-03-01 17:54
| |||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0024920) Dowid (reporter) 2010-03-01 18:11 |
Proposed Solution: change "pos " varibale type to Integer in m_attributevalue_trg() diff --git a/src-db/database/model/triggers/M_ATTRIBUTEVALUE_TRG.xml b/src-db/database/model/triggers/M_ATTRIBUTEVALUE_TRG.xml --- a/src-db/database/model/triggers/M_ATTRIBUTEVALUE_TRG.xml +++ b/src-db/database/model/triggers/M_ATTRIBUTEVALUE_TRG.xml @@ -25,7 +25,7 @@ v_desc varchar2(500); v_desc_aux varchar2(500); - pos NUMBER; + pos INTEGER; TYPE RECORD IS REF CURSOR; CurSetInstance RECORD; @@ -70,6 +70,6 @@ |
|
(0040990) psarobe (manager) 2011-09-16 09:13 |
Works fine |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2010-03-01 17:54 | Dowid | New Issue | |
| 2010-03-01 17:54 | Dowid | Assigned To | => adrianromero |
| 2010-03-01 17:54 | Dowid | File Added: attribute_renaming_error.png | |
| 2010-03-01 18:11 | Dowid | Note Added: 0024920 | |
| 2011-06-03 11:00 | dalsasua | Assigned To | adrianromero => dalsasua |
| 2011-07-20 18:11 | dalsasua | Assigned To | dalsasua => jonalegriaesarte |
| 2011-09-16 09:13 | psarobe | Note Added: 0040990 | |
| 2011-09-16 09:13 | psarobe | Status | new => closed |
| 2011-09-16 09:13 | psarobe | Resolution | open => unable to reproduce |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |