Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0004827Openbravo ERP03. Procurement managementpublic2008-09-05 16:352008-12-02 07:01
rafaroda 
gorkaion 
urgentcriticalalways
closedfixed 
20Ubuntu 7.10
pi 
2.50 
Core
No
0004827: Can not put Attribute Set Value
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
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.
UUID project
Issue History
2008-09-05 16:35rafarodaNew Issue
2008-09-05 16:35rafarodaAssigned To => cromero
2008-09-05 16:35rafarodasf_bug_id0 => 2095115
2008-09-05 16:35rafarodaRegression testing => No
2008-09-08 10:51psarobeAssigned Tocromero => alostale
2008-09-08 10:51psarobePrioritynormal => high
2008-09-08 10:51psarobeSeveritymajor => critical
2008-09-08 10:51psarobeTarget Version => 2.50
2008-09-08 10:52psarobeStatusnew => scheduled
2008-09-08 10:52psarobefix_in_branch => trunk
2008-10-16 11:45rafarodaNote Added: 0009601
2008-10-16 11:48rafarodaNote Edited: 0009601
2008-10-16 11:48rafarodaNote Edited: 0009601
2008-10-22 09:54pjuvaraPriorityhigh => immediate
2008-10-27 09:59rafarodaTag Attached: UUID project
2008-11-05 10:08alostalePriorityimmediate => urgent
2008-11-05 10:08alostalefix_in_branchtrunk =>
2008-11-10 11:24pjuvaraAssigned Toalostale => gorkaion
2008-11-11 18:38svnbotCheckin
2008-11-11 18:38svnbotNote Added: 0010180
2008-11-11 18:38svnbotStatusscheduled => resolved
2008-11-11 18:38svnbotResolutionopen => fixed
2008-11-11 18:38svnbotsvn_revision => 9893
2008-12-02 07:01krishnaStatusresolved => closed

Notes
(0009601)
rafaroda   
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   
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 [^]