Hello The problem here is that the changeset https://code.openbravo.com/erp/stable/2.40/rev/a6d63548df78 removes one AD_PROCESS record but in the sample data there is a record in the table AD_PROCESS_ACCESS https://code.openbravo.com/erp/stable/2.40/file/15d25ae42e1f/src-db/database/sampledata/AD_PROCESS_ACCESS.xml#l47573that references the deleted record and I suppose this is the reason this foreign key cannot be activated and is removed.
Hari, please fix this ASAP removing in the 2.40 sample data AD_PROCESS_ACCESS.xml the referenced record that is not necesary. There is no need to do it in pi because this issue was not required to fix in the pi branch Thanks. > 2010/5/25 Juan Pablo Aroztegi <[email protected]> > This test had been failing since the 13th of May, so 12 days already. > > The problematic changeset is one of these: > > http://builds.openbravo.com/view/stable-2.40/job/erp_stable_2.40-pgsql-db-full-consistency-test/182/ > > And the inconsistency is this one: > > --- a/src-db/database/model/tables/AD_PROCESS_ACCESS.xml Tue May 18 > 10:45:06 2010 +0530 > +++ b/src-db/database/model/tables/AD_PROCESS_ACCESS.xml Tue May 18 > 09:33:41 2010 +0200 > @@ -47,9 +47,6 @@ > <foreign-key foreignTable="AD_ORG" name="AD_PROCESSTACCESS_ORG"> > <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/> > </foreign-key> > - <foreign-key foreignTable="AD_PROCESS" > name="ADPROCESS_ADPROCESSACCESS" onDelete="cascade"> > - <reference local="AD_PROCESS_ID" foreign="AD_PROCESS_ID"/> > - </foreign-key> > <foreign-key foreignTable="AD_ROLE" name="ADROLE_ADPROCESSACCESS" > onDelete="cascade"> > <reference local="AD_ROLE_ID" foreign="AD_ROLE_ID"/> > </foreign-key> > > > Those who push any of those commits, please review them to see which > is causing the inconsistency. > > As this problem is making our 2.40 branch unusable for end users, we > have to take this as an immediate issue. > > > Thanks, > > Juan Pablo > > > On 09:35 Tue 25 May , [email protected] wrote: > > erp_stable_2.40-pgsql-db-full-consistency-test - Build # 183 - Still > Failing: > > > > Check console output at > http://builds.openbravo.com/job/erp_stable_2.40-pgsql-db-full-consistency-test/183/to > view the results. > > > > > > Committers since last success: > > > > Changes for Build #181 > > > > Víctor Martínez Romanos <[email protected]> > > Fixed bug 13122: Allow withholding when create payment from Bank > > src-db/database/model/functions/C_DEBT_PAYMENT_CREATE.xml > > src-db/database/sourcedata/AD_MESSAGE.xml > > src-db/database/sourcedata/AD_PROCESS_PARA.xml > > > > Balamurugan Ramadoss <[email protected]> > > Fixes Issue 13129: Report trial balance in PDF does not filter by > partner > > > src/org/openbravo/erpCommon/ad_reports/ReportTrialBalance.html > > src/org/openbravo/erpCommon/ad_reports/ReportTrialBalance.java > > > > Balamurugan Ramadoss <[email protected]> > > Fixes Issue 13129: Report trial balance in PDF does not filter by > partner > > > src/org/openbravo/erpCommon/ad_reports/ReportTrialBalance.java > > > > Víctor Martínez Romanos <[email protected]> > > merge > > > > Víctor Martínez Romanos <[email protected]> > > Fixed bug 13123: Report trial balance (PDF) is not translated at all > > src-db/database/sourcedata/AD_MESSAGE.xml > > src/org/openbravo/erpCommon/ad_reports/ReportTrialBalance.java > > > > RM packaging bot <[email protected]> > > Tag the stable revision > > > > RM packaging bot <[email protected]> > > Added signature for changeset 0f3d5f8ea8b3 > > .hgsigs > > > > RM packaging bot <[email protected]> > > Added tag 2.40MP12.7 for changeset 7012d8561a54 > > .hgtags > > > > RM packaging bot <[email protected]> > > Update Openbravo.properties for 2.40MP12.7 > > config/Openbravo.properties.template > > > > Changes for Build #182 > > > > Harikrishnan Raja <[email protected]> > > Fixes issue 12973 The problem was that the change audit servlet was > defined as a process, therefore before executing it, it is checked the > current role has permission to it. So if the new role doesn't have explicit > access to the process, it doesn't work. > > src-db/database/sourcedata/AD_MODEL_OBJECT.xml > > src-db/database/sourcedata/AD_PROCESS.xml > > > > Sathiyan Sivaprakasam <[email protected]> > > Fixes Issue 13131: The names 'Foreign Currency Debit' and 'Foreign > Currency Credit' are not correct. > > src-db/database/sourcedata/AD_COLUMN.xml > > src-db/database/sourcedata/AD_ELEMENT.xml > > src-db/database/sourcedata/AD_FIELD.xml > > > > Adrián Romero <[email protected]> > > Fixes issue 0013324: Wrong payment conditions when associating a > Project to a Purchase Invoice > > This changeset removes the condition that avoided to modify the payment > terms and conditions in purchase invoices. This way the behavior is > consistent in all orders and invoices > > > src/org/openbravo/erpCommon/ad_callouts/SE_Invoice_Project.java > > > > Adrián Romero <[email protected]> > > Fixes issue 0012711: Phisical Inventory processed twice > > It has been modified the M_INVENTORY trigger to avoid to set as > unprocessed a physycal inventory record that has already been processed. > This avoids to process the same record twice > > src-db/database/model/triggers/M_INVENTORY_TRG.xml > > > > Sathiyan Sivaprakasam <[email protected]> > > Fixes Issue 13121: Amount quantities are remembered when running > General Ledger and Payment Report > > > src/org/openbravo/erpCommon/ad_reports/ReportDebtPayment.java > > src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.java > > > > Sivaraman Rajagopal <[email protected]> > > Fixes issue 12971: Not possible to delete an attached document > > > > The given delete command in the HTML page is not correct. As a fix, 'DEL' > command has been replaced with 'DELETE' in TabAttachments_F1.html. > > > src/org/openbravo/erpCommon/businessUtility/TabAttachments_F1.html > > > > Asier Lostalé <[email protected]> > > fixed bug 13213: trl attribute in language XML files is always set to > Y > > > src/org/openbravo/erpCommon/ad_forms/TranslationHandler.java > > > > Víctor Martínez Romanos <[email protected]> > > Fixed db inconsistency 181 > > src-db/database/sourcedata/AD_PROCESS_PARA.xml > > > > Asier Lostalé <[email protected]> > > fixed bug 10916: Export translation does not work > > src/org/openbravo/erpCommon/ad_forms/Translation.java > > > > Changes for Build #183 > > > > Balamurugan Ramadoss <[email protected]> > > Fixed Issue 11785: On Cashflow Forecast some amount appears with > decimal comma > > > src/org/openbravo/erpCommon/ad_reports/ReportCashflowForecast.xml > > > > Balamurugan Ramadoss <[email protected]> > > Back out to old version as commit message was not given in previous > commit. > > > src/org/openbravo/erpCommon/ad_reports/ReportCashflowForecast.xml > > > > Balamurugan Ramadoss <[email protected]> > > (no commit message) > > > src/org/openbravo/erpCommon/ad_reports/ReportCashflowForecast.xml > > > > > > > > > > Last 20 lines of the console output: > > > > [...truncated 5511 lines...] > > > > BUILD SUCCESSFUL > > Total time: 4 minutes 0 seconds > > M src-db/database/model/tables/AD_PROCESS_ACCESS.xml > > diff -r 471d03b588cb src-db/database/model/tables/AD_PROCESS_ACCESS.xml > > --- a/src-db/database/model/tables/AD_PROCESS_ACCESS.xml Thu May 20 > 14:56:07 2010 +0530 > > +++ b/src-db/database/model/tables/AD_PROCESS_ACCESS.xml Tue May 25 > 09:35:20 2010 +0200 > > @@ -47,9 +47,6 @@ > > <foreign-key foreignTable="AD_ORG" name="AD_PROCESSTACCESS_ORG"> > > <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/> > > </foreign-key> > > - <foreign-key foreignTable="AD_PROCESS" > name="ADPROCESS_ADPROCESSACCESS" onDelete="cascade"> > > - <reference local="AD_PROCESS_ID" foreign="AD_PROCESS_ID"/> > > - </foreign-key> > > <foreign-key foreignTable="AD_ROLE" name="ADROLE_ADPROCESSACCESS" > onDelete="cascade"> > > <reference local="AD_ROLE_ID" foreign="AD_ROLE_ID"/> > > </foreign-key> > > Email was triggered for: Failure > > Sending email for trigger: Failure > > > > > > > ------------------------------------------------------------------------------ > > > > _______________________________________________ > > Openbravo-builds mailing list > > [email protected] > > https://lists.sourceforge.net/lists/listinfo/openbravo-builds > > > > ------------------------------------------------------------------------------ > > _______________________________________________ > Openbravo-builds mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/openbravo-builds > -- Adrián Romero [email protected] Openbravo, S. L. http://www.openbravo.com Opening ERP's future! Address Ed. Slan, Calle J, Landaben, Pamplona, 31012, Spain Mailing Address PO Box 5117, Pamplona, 31010, Spain
------------------------------------------------------------------------------
_______________________________________________ Openbravo-builds mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openbravo-builds
