Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0005035Openbravo ERP07. Sales managementpublic2008-09-12 13:072008-12-03 13:22
Reporterrafaroda 
Assigned Tocromero 
PrioritynormalSeveritycriticalReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionUbuntu 7.10
Product Versionpi 
Target Version2.50Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0005035: Cannot Complete Sales Order PostgreSQL
DescriptionIf you try to complete a sales order using PostgreSQL in the trunk, you get the following message:
Error:
null value in column "c_ordertax_id" violates not-null constraint

Steps To Reproducehttp://wiki.openbravo.com/wiki/Acceptance_Testing#Sales_Management [^]

1) Create a Sales Order.
2) Add some lines.
3) Click on 'Complete' button.
Proposed SolutionReview https://dev.openbravo.com/websvn/openbravo/trunk/src-db/database/model/functions/C_ORDER_POST1.xml [^]

https://dev.openbravo.com/websvn/openbravo/trunk/src-db/database/model/functions/C_ORDER_POST1.xml?op=diff&rev=6799&sc=0 [^]
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-09-12 13:07rafarodaNew Issue
2008-09-12 13:07rafarodaAssigned To => cromero
2008-09-12 13:07rafarodasf_bug_id0 => 2107260
2008-09-12 13:07rafarodaOBNetwork customer => No
2008-09-12 13:07rafarodaRegression testing => No
2008-09-16 16:41cromeroStatusnew => scheduled
2008-09-16 16:41cromerofix_in_branch => trunk
2008-09-17 09:25cromeroTarget Version => 2.50
2008-09-17 09:25cromerofix_in_branchtrunk =>
2008-09-18 12:55svnbotCheckin
2008-09-18 12:55svnbotNote Added: 0009077
2008-09-18 12:55svnbotStatusscheduled => resolved
2008-09-18 12:55svnbotResolutionopen => fixed
2008-09-18 12:55svnbotsvn_revision => 7460
2008-09-18 12:58rafarodaNote Added: 0009078
2008-12-03 13:22krishnaStatusresolved => closed

Notes
(0009077)
svnbot   
2008-09-18 12:55   
Repository: openbravo
Revision: 7460
Author: cromeroherrero
Date: 2008-09-18 12:54:59 +0200 (Thu, 18 Sep 2008)

Fixed bug 5035: Cannot Complete Sales Order PostgreSQL. Problem because C_ORDERTAX table has now one primary key column instead of the old two ones and now it is need to pass the C_ORDERTAX_ID

---
U trunk/src-db/database/model/functions/C_ORDER_POST1.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=7460&sc=1 [^]
(0009078)
rafaroda   
2008-09-18 12:58   
It also failed in Oracle.