Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0009945 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] Y. DBSourceManager | major | always | 2009-07-17 16:56 | 2009-08-21 00:00 | |||
| Reporter | rajagopal | View Status | public | |||||
| Assigned To | marvintm | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | e774776bfde0 | |||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 32 bit | Database | PostgreSQL | Java version | 1.6 | |||
| OS Version | Cent OS 5.2 | Database version | 8.3.5 | Ant version | 1.7 | |||
| Product Version | pi | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0009945: Summary : DB Source manager creates the different scripts | |||||||
| Description | DB 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 Reproduce | 1. 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" | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0018381) dalsasua (viewer) 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 --- |
|
Notes |
|
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 16:56 | rajagopal | OBNetwork customer | => No |
| 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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |