Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0012812 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Openbravo ERP] 04. Warehouse management | major | always | 2010-03-26 02:15 | 2011-09-16 09:58 | |||
Reporter | iori0758 | 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 | Linux 64 bit | Database | PostgreSQL | Java version | 1.6.0_18 | |||
OS Version | Professional Appliance | Database version | 8.3.9 | Ant version | 1.7.1 | |||
Product Version | 2.50MP13 | 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 | 0012812: ERROR: record "new" is not assigned yet 详细:The tuple structure of a not-yet-assigned record is indeterminate. | |||||||
Description | when I inserted a Shipment in line record,and I want to delete it,appears that 'ERROR: record "new" is not assigned yet 详细:The tuple structure of a not-yet-assigned record is indeterminate.' | |||||||
Proposed Solution | delete Shipment in line record not complete | |||||||
Tags | No tags attached. | |||||||
Attached Files | Screenshot.png [^] (55,037 bytes) 2010-03-26 02:15
| |||||||
Relationships [ Relation Graph ] [ Dependency Graph ] | |
Notes | |
(0025745) iori0758 (reporter) 2010-03-26 02:18 |
I upadte the database function m_inoutline_trg,change follow code: IF (NEW.C_ORDERLINE_ID IS NOT NULL) THEN SELECT COUNT(*) INTO V_COUNT FROM C_ORDERLINE ol WHERE ol.C_ORDERLINE_ID = NEW.C_ORDERLINE_ID AND NEW.MOVEMENTQTY > ol.QTYORDERED; SELECT ol.QTYORDERED INTO oldordered FROM C_ORDERLINE ol WHERE ol.C_ORDERLINE_ID = NEW.C_ORDERLINE_ID AND NEW.MOVEMENTQTY > ol.QTYORDERED; IF(V_COUNT <> 0) THEN RAISE EXCEPTION '%', '@MovementQtyCheck@'; --OBTG:-20000-- END IF; END IF; to: IF (TG_OP <> 'DELETE') THEN IF (NEW.C_ORDERLINE_ID IS NOT NULL) THEN SELECT COUNT(*) INTO V_COUNT FROM C_ORDERLINE ol WHERE ol.C_ORDERLINE_ID = NEW.C_ORDERLINE_ID AND NEW.MOVEMENTQTY > ol.QTYORDERED; SELECT ol.QTYORDERED INTO oldordered FROM C_ORDERLINE ol WHERE ol.C_ORDERLINE_ID = NEW.C_ORDERLINE_ID AND NEW.MOVEMENTQTY > ol.QTYORDERED; IF(V_COUNT <> 0) THEN RAISE EXCEPTION '%', '@MovementQtyCheck@'; --OBTG:-20000-- END IF; END IF; END IF; Anything is ok, |
Issue History | |||
Date Modified | Username | Field | Change |
2010-03-26 02:15 | iori0758 | New Issue | |
2010-03-26 02:15 | iori0758 | Assigned To | => adrianromero |
2010-03-26 02:15 | iori0758 | File Added: Screenshot.png | |
2010-03-26 02:18 | iori0758 | Note Added: 0025745 | |
2011-06-03 10:59 | dalsasua | Assigned To | adrianromero => dalsasua |
2011-07-20 18:12 | dalsasua | Assigned To | dalsasua => jonalegriaesarte |
2011-09-16 09:58 | psarobe | Status | new => closed |
2011-09-16 09:58 | psarobe | Resolution | open => unable to reproduce |
Copyright © 2000 - 2009 MantisBT Group |