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 ] | |
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 |
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 |
Copyright © 2000 - 2009 MantisBT Group |