Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0026708ModulesService Contract Managementpublic2014-05-27 21:032014-05-28 10:24
Reportersjkumar 
Assigned Tovmromanos 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionduplicate 
PlatformOS30OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Support ticket
OBNetwork customer
Regression introduced in release
Summary0026708: Get Constraint error while updating any column in Subscribed Services Tab
DescriptionSteps:
1)Create a subscription and add subscribed service as per the below
screenshot
2)Modify the overage policy for the ratecard service Line : Oracle Cloud IaaS Data Transfer - GB PER MONTH . So now I click on that ratecard service , change the Overage Policy and save it BUT I get an error:
Error:Saving Failed.There is a constraint defined that was not satisfied. Please check the data entered
3)The reason I get the error is for this line, the ‘Bill To Customer’ in the Billing Details section is having some value But since the display logic is not showing that field, I cannot Modify it to make it NULL.
Workaround is
a)I need to Uncheck ‘Do Not Generate Invoice Plan Lines’
b)Remove the entry from ‘Bill To Customer’ field.
c)Change the overage Policy
d)Check back the ‘‘Do Not Generate Invoice Plan Lines’ Save and it lets you save it.

Steps To ReproduceSteps:
1)Create a subscription and add subscribed service as per the below
screenshot
2)Modify the overage policy for the ratecard service Line : Oracle Cloud IaaS Data Transfer - GB PER MONTH . So now I click on that ratecard service , change the Overage Policy and save it BUT I get an error:
Error:Saving Failed.There is a constraint defined that was not satisfied. Please check the data entered
3)The reason I get the error is for this line, the ‘Bill To Customer’ in the Billing Details section is having some value But since the display logic is not showing that field, I cannot Modify it to make it NULL.
Workaround is
a)I need to Uncheck ‘Do Not Generate Invoice Plan Lines’
b)Remove the entry from ‘Bill To Customer’ field.
c)Change the overage Policy
d)Check back the ‘‘Do Not Generate Invoice Plan Lines’ Save and it lets you save it.

Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
duplicate of defect 0026286 closed AugustoMauch Openbravo ERP Unexpected behaviour when same column name exists in header and lines tab 
Attached Filesdoc ConstraintError.doc (258,560) 2014-05-27 21:03
https://issues.openbravo.com/file_download.php?file_id=6954&type=bug
Issue History
Date ModifiedUsernameFieldChange
2014-05-27 21:03sjkumarNew Issue
2014-05-27 21:03sjkumarAssigned To => vmromanos
2014-05-27 21:03sjkumarFile Added: ConstraintError.doc
2014-05-28 10:10naiaramartinezStatusnew => scheduled
2014-05-28 10:10naiaramartinezfix_in_branch => pi
2014-05-28 10:24naiaramartinezRelationship addedduplicate of 0026286
2014-05-28 10:24naiaramartinezNote Added: 0067510
2014-05-28 10:24naiaramartinezStatusscheduled => closed
2014-05-28 10:24naiaramartinezResolutionopen => duplicate

Notes
(0067510)
naiaramartinez   
2014-05-28 10:24   
This issue has been closed because it is already fixed. The following links are the issues that were created some time ago to fix it:
    - https://issues.openbravo.com/view.php?id=26286 [^]
    - https://issues.openbravo.com/view.php?id=26369 [^]

Moreover, when the issue was fixed we sent an email to you with the steps to follow in order to have this bug fixed in your environment. This email was sent on May 13. The following text was in the email:

"This issue was on the Platform side, and it was already fixed (see https://issues.openbravo.com/view.php?id=26286 [^] for more details).

In order to fix your environment you should either upgrade your Openbravo installation to version 3.0.22989 (or higher), which is currenty in test status, or alternatively you can directly apply this patch https://code.openbravo.com/erp/devel/pi/rev/de359036d46be34e5f86267664c040bc1a2a9826 [^] to your working copy."