Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0012812
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 04. Warehouse managementmajoralways2010-03-26 02:152011-09-16 09:58
Reporteriori0758View Statuspublic 
Assigned Tojonalegriaesarte 
PrioritynormalResolutionunable to reproduceFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSLinux 64 bitDatabasePostgreSQLJava version1.6.0_18
OS VersionProfessional ApplianceDatabase version8.3.9Ant version1.7.1
Product Version2.50MP13SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0012812: ERROR: record "new" is not assigned yet 详细：The tuple structure of a not-yet-assigned record is indeterminate.

Descriptionwhen 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 Solutiondelete Shipment in line record not complete
TagsNo tags attached.
Attached Filespng file icon 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
Powered by Mantis Bugtracker