Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0009945Openbravo ERPY. DBSourceManagerpublic2009-07-17 16:562009-08-21 00:00
Reporterrajagopal 
Assigned Tomarvintm 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionCent OS 5.2
Product Versionpi 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0009945: 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"
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0010025 closed dalsasua APi check build 89 fails 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-07-17 16:56rajagopalNew Issue
2009-07-17 16:56rajagopalAssigned To => marvintm
2009-07-17 17:04dalsasuaNote Added: 0018381
2009-07-17 17:06dalsasuaIssue Monitored: dalsasua
2009-07-21 00:04psarobeStatusnew => scheduled
2009-07-21 00:04psarobefix_in_branch => pi
2009-07-21 16:55hgbotCheckin
2009-07-21 16:55hgbotNote Added: 0018497
2009-07-21 16:55hgbotStatusscheduled => resolved
2009-07-21 16:55hgbotResolutionopen => fixed
2009-07-21 16:55hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/6f2495d474fd37fc3ff77cb96c44ef653aa39533 [^]
2009-07-22 23:11hgbotCheckin
2009-07-22 23:11hgbotNote Added: 0018566
2009-07-22 23:11hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/6f2495d474fd37fc3ff77cb96c44ef653aa39533 [^] => http://code.openbravo.com/erp/devel/pi/rev/1a216ea10d98d58ca1bb3cc7f51a05d215f833a7 [^]
2009-07-25 01:13dalsasuaRelationship addedrelated to 0010025
2009-07-25 01:15hgbotCheckin
2009-07-25 01:15hgbotNote Added: 0018615
2009-07-25 01:15hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/1a216ea10d98d58ca1bb3cc7f51a05d215f833a7 [^] => http://code.openbravo.com/erp/devel/pi/rev/e774776bfde0c24231591a79cade1685fbe9b3e9 [^]
2009-08-20 12:28plujanStatusresolved => closed
2009-08-21 00:00anonymoussf_bug_id0 => 2841450

Notes
(0018381)
dalsasua   
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   
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   
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   
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
---