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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0009945
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] Y. DBSourceManagermajoralways2009-07-17 16:562009-08-21 00:00
ReporterrajagopalView Statuspublic 
Assigned Tomarvintm 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revisione774776bfde0
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.6
OS VersionCent OS 5.2Database version8.3.5Ant version1.7
Product VersionpiSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0009945: Summary : DB Source manager creates the different scripts

DescriptionDB Source manager creates the wrong sql script for function call for postgres which causes the build failure.

C_VALIDCOMBINATION_CLONE function has the function call as below


ACTUAL(REPOSITORY VERSION) FUNCTIONAL CALL IN C_VALIDCOMBINATION_CLONE.XML FILE
-------------------------------------------------------------------------------
C_ValidCombination_Insert(C_Out_New_Acct_Number, v_Default_Account_Client_ID , v_Org_ID , v_C_AcctSchema_ID, v_C_ElementValue_ID,NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-------------------------------------------------------------------------------

The above function works fine in both oracle and postgres. But when we execute the "ant export.database" in postgres which modifies the C_VALIDCOMBINATION_CLONE.XML which causes the build failure, Because the function call has been modified in the xml file as below.

POSTGRES SCRIPT FOR FUNCTION CALL AFTER "EXPORT.DATABASE"
---------------------------------
SELECT * INTO C_Out_New_Acct_Number FROM C_ValidCombination_Insert( v_Default_Account_Client_ID , v_Org_ID , v_C_AcctSchema_ID,
v_C_ElementValue_ID,NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL);
Steps To Reproduce1. clone erp/devel/pi
2. Execute "ant install.source"
3. Set core to In development
4. Do some changes in AD (for testing purpose).
5. Execute "ant compile.complete"
6. Execute "ant export.database"
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0010025 closeddalsasua APi check build 89 fails 

-  Notes
(0018381)
dalsasua (reporter)
2009-07-17 17:04

 Even this step:
4. Do some changes in AD (for testing purpose).
is not necessary. Main point here is that with no change performed, just after install.source finishes, if you put core as in development, and perform an export.database -Dforce=yes, some changes appears in this file, that user has not done.
(0018497)
hgbot (developer)
2009-07-21 16:55

 Repository: erp/devel/pi
Changeset: 6f2495d474fd37fc3ff77cb96c44ef653aa39533
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Tue Jul 21 16:55:14 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/6f2495d474fd37fc3ff77cb96c44ef653aa39533 [^]

Fixes issue 9945: Summary : DB Source manager creates the different scripts

---
M src-db/database/model/functions/C_VALIDCOMBINATION_CLONE.xml
M src-db/database/model/triggers/C_BPARTNER_TRG.xml
M src-db/database/model/triggers/M_PRODUCT_TRG.xml
---
(0018566)
hgbot (developer)
2009-07-22 23:11

 Repository: erp/devel/pi
Changeset: 1a216ea10d98d58ca1bb3cc7f51a05d215f833a7
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Wed Jul 22 23:11:16 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/1a216ea10d98d58ca1bb3cc7f51a05d215f833a7 [^]

Fixes issue 9945: Summary : DB Source manager creates the different scripts

---
M src-db/database/model/functions/C_VALIDCOMBINATION_CLONE.xml
M src-db/database/model/functions/C_VALIDCOMBINATION_INSERT.xml
M src-db/database/model/triggers/C_BPARTNER_TRG.xml
M src-db/database/model/triggers/M_PRODUCT_TRG.xml
---
(0018615)
hgbot (developer)
2009-07-25 01:15

 Repository: erp/devel/pi
Changeset: e774776bfde0c24231591a79cade1685fbe9b3e9
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Sat Jul 25 01:15:11 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/e774776bfde0c24231591a79cade1685fbe9b3e9 [^]

Fixes issue 10025: APi check build 89 fails. Fixes issue 9945: Summary : DB Source manager creates the different scripts. Fixes issue 9918: Inconsistent database

---
M src-db/database/model/functions/C_VALIDCOMBINATION_CLONE.xml
M src-db/database/model/functions/C_VALIDCOMBINATION_INSERT.xml
---

- Issue History
Date Modified Username Field Change
2009-07-17 16:56 rajagopal New Issue
2009-07-17 16:56 rajagopal Assigned To => marvintm
2009-07-17 17:04 dalsasua Note Added: 0018381
2009-07-17 17:06 dalsasua Issue Monitored: dalsasua
2009-07-21 00:04 psarobe Status new => scheduled
2009-07-21 00:04 psarobe fix_in_branch => pi
2009-07-21 16:55 hgbot Checkin
2009-07-21 16:55 hgbot Note Added: 0018497
2009-07-21 16:55 hgbot Status scheduled => resolved
2009-07-21 16:55 hgbot Resolution open => fixed
2009-07-21 16:55 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/6f2495d474fd37fc3ff77cb96c44ef653aa39533 [^]
2009-07-22 23:11 hgbot Checkin
2009-07-22 23:11 hgbot Note Added: 0018566
2009-07-22 23:11 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/6f2495d474fd37fc3ff77cb96c44ef653aa39533 [^] => http://code.openbravo.com/erp/devel/pi/rev/1a216ea10d98d58ca1bb3cc7f51a05d215f833a7 [^]
2009-07-25 01:13 dalsasua Relationship added related to 0010025
2009-07-25 01:15 hgbot Checkin
2009-07-25 01:15 hgbot Note Added: 0018615
2009-07-25 01:15 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/1a216ea10d98d58ca1bb3cc7f51a05d215f833a7 [^] => http://code.openbravo.com/erp/devel/pi/rev/e774776bfde0c24231591a79cade1685fbe9b3e9 [^]
2009-08-20 12:28 plujan Status resolved => closed
2009-08-21 00:00 anonymous sf_bug_id 0 => 2841450

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker