Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0004827 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 03. Procurement management | critical | always | 2008-09-05 16:35 | 2008-12-02 07:01 | |||
| Reporter | rafaroda | View Status | public | |||||
| Assigned To | gorkaion | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | 9893 | ||||
| Projection | none | ETA | none | Target Version | 2.50 | |||
| OS | Linux 32 bit | Database | PostgreSQL | Java version | 1.5 | |||
| OS Version | Ubuntu 7.10 | Database version | 8.3 | Ant version | 1.7 | |||
| Product Version | pi | SCM revision | 6905 | |||||
| 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 | 0004827: Can not put Attribute Set Value | |||||||
| Description | Attribute Set Value can not be put to a product with error: 15:32:32 [http-8382-Processor24] ERROR org.openbravo.erpCommon.info.AttributeSetInstanceData - SQL error in query: INSERT INTO M_ATTRIBUTEINSTANCE (M_ATTRIBUTESETINSTANCE_ID, M_ATTRIBUTE_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, M_ATTRIBUTEVALUE_ID, VALUE) VALUES ( ?, ?, ?, ?, 'Y', now(), ?, now(), ?, ?, ?)Exception:org.postgresql.util.PSQLException: ERROR: null value in column "m_attributeinstance_id" violates not-null constraint 15:32:32 [http-8382-Processor24] ERROR org.openbravo.base.secureApp.HttpSecureAppServlet - Rollback in transaction: javax.servlet.ServletException: @CODE=0@ERROR: null value in column "m_attributeinstance_id" violates not-null constraint | |||||||
| Steps To Reproduce | 1) Create a new Goods Receipt: Procurement Management || Transactions || Goods Receipt 2) Add a line, select a product and save it. 3) Try to put an Attribute Set Value using the icon. You can not. | |||||||
| Tags | UUID project | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0009601) rafaroda (developer) 2008-10-16 11:45 edited on: 2008-10-16 11:48 |
The problem is in the method insert of erpCommon/info/AttributeSetInstance_Data.xsql that inserts data into M_ATTRIBUTEINSTANCE without putting M_ATTRIBUTEINSTANCE_ID. Inside erpCommon/info/AttributeSetInstance.java, review line 219. |
|
(0010180) svnbot (reporter) 2008-11-11 18:38 |
Repository: openbravo Revision: 9893 Author: gorkaion Date: 2008-11-11 18:38:48 +0100 (Tue, 11 Nov 2008) Fixed bug 4827. Added m_attributeinstance_id primary key to the insert statement. --- U trunk/src/org/openbravo/erpCommon/info/AttributeSetInstance.java U trunk/src/org/openbravo/erpCommon/info/AttributeSetInstance_data.xsql --- https://dev.openbravo.com/websvn/openbravo/?rev=9893&sc=1 [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2008-09-05 16:35 | rafaroda | New Issue | |
| 2008-09-05 16:35 | rafaroda | Assigned To | => cromero |
| 2008-09-05 16:35 | rafaroda | sf_bug_id | 0 => 2095115 |
| 2008-09-05 16:35 | rafaroda | Regression testing | => No |
| 2008-09-08 10:51 | psarobe | Assigned To | cromero => alostale |
| 2008-09-08 10:51 | psarobe | Priority | normal => high |
| 2008-09-08 10:51 | psarobe | Severity | major => critical |
| 2008-09-08 10:51 | psarobe | Target Version | => 2.50 |
| 2008-09-08 10:52 | psarobe | Status | new => scheduled |
| 2008-09-08 10:52 | psarobe | fix_in_branch | => trunk |
| 2008-10-16 11:45 | rafaroda | Note Added: 0009601 | |
| 2008-10-16 11:48 | rafaroda | Note Edited: 0009601 | |
| 2008-10-16 11:48 | rafaroda | Note Edited: 0009601 | |
| 2008-10-22 09:54 | pjuvara | Priority | high => immediate |
| 2008-10-27 09:59 | rafaroda | Tag Attached: UUID project | |
| 2008-11-05 10:08 | alostale | Priority | immediate => urgent |
| 2008-11-05 10:08 | alostale | fix_in_branch | trunk => |
| 2008-11-10 11:24 | pjuvara | Assigned To | alostale => gorkaion |
| 2008-11-11 18:38 | svnbot | Checkin | |
| 2008-11-11 18:38 | svnbot | Note Added: 0010180 | |
| 2008-11-11 18:38 | svnbot | Status | scheduled => resolved |
| 2008-11-11 18:38 | svnbot | Resolution | open => fixed |
| 2008-11-11 18:38 | svnbot | svn_revision | => 9893 |
| 2008-12-02 07:01 | krishna | Status | resolved => closed |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |