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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0019697
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2012-02-09 09:302012-04-02 12:13
ReporterpsanjuanView Statuspublic 
Assigned Tovmromanos 
PriorityurgentResolutionfixedFixed in Version3.0MP9
StatusclosedFix in branchFixed in SCM revisione0d914c1efd1
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabaseOracleJava version1.6
OS VersionUbuntu 8.04.1Database version11.1.0.6.0Ant version1.7.0
Product VersionSCM revision 
Review Assigned To
Web browserGoogle Chrome
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0019697: It is not possible to create a Campaign, see error attached.

DescriptionIt is not possible to create a Campaign, see error attached.
Steps To ReproduceNavigate to F&B US Inc Accounting Schema and add:
Sales Region
Campaign
as new account elements (dimensions).

Navigate to Account Combination window.
Create a new record
Click on "Sales Campaign" field in order to create a new campaign.
Campaig window is open.
Try to create a new campaign.
Below error will be shown.
TagsOB3 Documentation, Regression, VMA-Reviewed
Attached Filespng file icon error_campaign.png [^] (66,610 bytes) 2012-02-09 09:30

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 00184073.0MP5 closedjecharri Campaign tree does not work 

-  Notes
(0046579)
hgbot (developer)
2012-03-21 10:30

 Repository: erp/devel/pi
Changeset: 57131b13c97a77f1edc8a9d1e038b995fadcb8a2
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Wed Mar 21 10:29:38 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/57131b13c97a77f1edc8a9d1e038b995fadcb8a2 [^]

Fixes issue 19697: It is not possible to create a Campaign, see error attached.
Also complete the issue 18407

---
A src-util/modulescript/build/classes/org/openbravo/modulescript/UpdateADClientInfo.class
A src-util/modulescript/build/classes/org/openbravo/modulescript/UpdateADClientInfoData.class
A src-util/modulescript/src/org/openbravo/modulescript/UpdateADClientInfo.java
A src-util/modulescript/src/org/openbravo/modulescript/UpdateADClientInfo_data.xsql
---
(0046582)
hgbot (developer)
2012-03-21 11:41

 Repository: erp/devel/pi
Changeset: 240bae48f88cfe1e21262242df7034cb9f03a964
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Wed Mar 21 11:40:03 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/240bae48f88cfe1e21262242df7034cb9f03a964 [^]

issue 19697, issue 18407.
Changed the method selectClientsID to have better performance and only update the neccesary clients

---
M src-util/modulescript/build/classes/org/openbravo/modulescript/UpdateADClientInfoData.class
M src-util/modulescript/src/org/openbravo/modulescript/UpdateADClientInfo_data.xsql
---
(0046584)
vmromanos (manager)
2012-03-21 11:52

 The root cause of this bug is in the fix of https://issues.openbravo.com/view.php?id=18407 [^] (on Oct 31)

This issue added a trigger to the C_Campaign table and a new column to the AD_ClientInfo, called AD_Tree_Campaing_ID

The C_Campaign_TRG trigger does the following query:
 SELECT c.AD_Tree_Campaign_ID,
      n.Node_ID
    INTO v_xTree_ID,
      v_xParent_ID
    FROM AD_ClientInfo c,
      AD_TreeNode n
    WHERE c.AD_Tree_Campaign_ID=n.AD_Tree_ID
      AND n.Parent_ID IS NULL
      AND c.AD_Client_ID=:new.AD_Client_ID;

In case c.AD_Tree_Campaign_ID is null the bug is reproducible.

For clients created before 0018407 this column is always null so it's necessary to create a module script that fills it for old clients
(0046585)
vmromanos (manager)
2012-03-21 11:55

 No regression risk:
Test plan:
- Ensure AD_ClientInfo.AD_Tree_Campaign_ID is null for the clients in your instance
- Update your working copy to include this fix (MP9)
- Run ant smartbuild -Dlocal=no -Dforce=true
- Check org.openbravo.modulescript.UpdateADClientInfo is executed
- Query the database and check AD_ClientInfo.AD_Tree_Campaign_ID is not null for clients <> '0'
- Run again ant smartbuild -Dlocal=no -Dforce=true and check AD_ClientInfo.AD_Tree_Campaign_ID has the same data
(0046588)
vmromanos (manager)
2012-03-21 12:02

 code review + testing OK
(0047016)
hgbot (developer)
2012-04-01 20:34

 Repository: erp/devel/pi
Changeset: e0d914c1efd1635ff518ce027e4072e24b968df6
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Wed Mar 21 10:29:38 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/e0d914c1efd1635ff518ce027e4072e24b968df6 [^]

Fixes issue 19697: It is not possible to create a Campaign, see error attached.
Also complete the issue 18407

---
A src-util/modulescript/build/classes/org/openbravo/modulescript/UpdateADClientInfo.class
A src-util/modulescript/build/classes/org/openbravo/modulescript/UpdateADClientInfoData.class
A src-util/modulescript/src/org/openbravo/modulescript/UpdateADClientInfo.java
A src-util/modulescript/src/org/openbravo/modulescript/UpdateADClientInfo_data.xsql
---
(0047017)
hgbot (developer)
2012-04-01 20:34

 Repository: erp/devel/pi
Changeset: f5fe379ed93a6096bac2caa837ce4bee45a63597
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Wed Mar 21 11:40:03 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/f5fe379ed93a6096bac2caa837ce4bee45a63597 [^]

issue 19697, issue 18407.
Changed the method selectClientsID to have better performance and only update the neccesary clients

---
M src-util/modulescript/build/classes/org/openbravo/modulescript/UpdateADClientInfoData.class
M src-util/modulescript/src/org/openbravo/modulescript/UpdateADClientInfo_data.xsql
---
(0047179)
hudsonbot (developer)
2012-04-02 06:11

 A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/7814864461ac [^]

Maturity status: Test
(0047182)
hudsonbot (developer)
2012-04-02 06:11

 A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/7814864461ac [^]

Maturity status: Test
(0047295)
gorka_gil (administrator)
2012-04-02 12:13

 Reopened by merge.

- Issue History
Date Modified Username Field Change
2012-02-09 09:30 psanjuan New Issue
2012-02-09 09:30 psanjuan Assigned To => jonalegriaesarte
2012-02-09 09:30 psanjuan Web browser => Google Chrome
2012-02-09 09:30 psanjuan Modules => Core
2012-02-09 09:30 psanjuan File Added: error_campaign.png
2012-02-09 09:57 psanjuan Tag Attached: OB3 Documentation
2012-02-15 19:03 iciordia Assigned To jonalegriaesarte => vmromanos
2012-02-17 08:55 vmromanos Tag Attached: VMA-Reviewed
2012-03-20 00:04 dmitry_mezentsev Issue Monitored: dmitry_mezentsev
2012-03-20 18:30 vmromanos Relationship added related to 0018407
2012-03-20 20:09 dmitry_mezentsev Tag Attached: Regression
2012-03-21 10:30 hgbot Checkin
2012-03-21 10:30 hgbot Note Added: 0046579
2012-03-21 10:30 hgbot Status new => resolved
2012-03-21 10:30 hgbot Resolution open => fixed
2012-03-21 10:30 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/57131b13c97a77f1edc8a9d1e038b995fadcb8a2 [^]
2012-03-21 11:41 hgbot Checkin
2012-03-21 11:41 hgbot Note Added: 0046582
2012-03-21 11:52 vmromanos Note Added: 0046584
2012-03-21 11:55 vmromanos Note Added: 0046585
2012-03-21 12:02 vmromanos Note Added: 0046588
2012-03-21 12:02 vmromanos Status resolved => closed
2012-04-01 20:34 hgbot Checkin
2012-04-01 20:34 hgbot Note Added: 0047016
2012-04-01 20:34 hgbot Status closed => resolved
2012-04-01 20:34 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/57131b13c97a77f1edc8a9d1e038b995fadcb8a2 [^] => http://code.openbravo.com/erp/devel/pi/rev/e0d914c1efd1635ff518ce027e4072e24b968df6 [^]
2012-04-01 20:34 hgbot Checkin
2012-04-01 20:34 hgbot Note Added: 0047017
2012-04-02 06:11 hudsonbot Checkin
2012-04-02 06:11 hudsonbot Note Added: 0047179
2012-04-02 06:11 hudsonbot Checkin
2012-04-02 06:11 hudsonbot Note Added: 0047182
2012-04-02 12:13 gorka_gil Note Added: 0047295
2012-04-02 12:13 gorka_gil Status resolved => closed
2012-04-02 12:13 gorka_gil Fixed in Version => 3.0MP9

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker