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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0005035
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 07. Sales managementcriticalalways2008-09-12 13:072008-12-03 13:22
ReporterrafarodaView Statuspublic 
Assigned Tocromero 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision7460
ProjectionnoneETAnoneTarget Version2.50
OSLinux 32 bitDatabasePostgreSQLJava version1.5
OS VersionUbuntu 7.10Database version8.3Ant version1.7
Product VersionpiSCM revision7258 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0005035: 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 [^]
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0009077)
svnbot (reporter)
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 (developer)
2008-09-18 12:58

It also failed in Oracle.

- Issue History
Date Modified Username Field Change
2008-09-12 13:07 rafaroda New Issue
2008-09-12 13:07 rafaroda Assigned To => cromero
2008-09-12 13:07 rafaroda sf_bug_id 0 => 2107260
2008-09-12 13:07 rafaroda Regression testing => No
2008-09-16 16:41 cromero Status new => scheduled
2008-09-16 16:41 cromero fix_in_branch => trunk
2008-09-17 09:25 cromero Target Version => 2.50
2008-09-17 09:25 cromero fix_in_branch trunk =>
2008-09-18 12:55 svnbot Checkin
2008-09-18 12:55 svnbot Note Added: 0009077
2008-09-18 12:55 svnbot Status scheduled => resolved
2008-09-18 12:55 svnbot Resolution open => fixed
2008-09-18 12:55 svnbot svn_revision => 7460
2008-09-18 12:58 rafaroda Note Added: 0009078
2008-12-03 13:22 krishna Status resolved => closed


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker