Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0037011Openbravo ERPA. Platformpublic2017-10-05 13:272017-10-06 13:08
Reporterinigosanchez 
Assigned Toinigosanchez 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Toalostale
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0037011: dbconsistency fails in org.openbravo.integration.alfresco
DescriptionDB Consistency fails [1] in org.openbravo.integration.alfresco module. Since two new modules had been added to mods-platform job, some dbconsistency errors are raised. The added methdos are:
- org.openbravo.integration.alfresco
- org.openbravo.integration.alfresco.es_ES

The error is:
.....................................
Checking module org.openbravo.integration.alfresco:
diff -r 7ec560654725 src-db/database/model/modifiedTables/C_ATTACHMENT_CONF.xml
--- a/src-db/database/model/modifiedTables/C_ATTACHMENT_CONF.xml Fri Sep 29 08:27:40 2017 +0200
+++ b/src-db/database/model/modifiedTables/C_ATTACHMENT_CONF.xml Wed Oct 04 02:57:16 2017 +0000
@@ -28,9 +28,9 @@
       <foreign-key foreignTable="AD_LANGUAGE" name="EM_OBIALF_C_ATT_CONF_AD_LANG">
         <reference local="EM_OBIALF_LANGUAGE" foreign="AD_LANGUAGE"/>
       </foreign-key>
- <check name="EM_OBIALF_ATTMETHOD_IP"><![CDATA[(((C_ATTACHMENT_METHOD_ID) = '8FC51DE7BB394841936CDB3443810E00') AND (EM_OBIALF_IP IS NOT NULL)) OR ((C_ATTACHMENT_METHOD_ID) <> '8FC51DE7BB394841936CDB3443810E00')]]></check>
- <check name="EM_OBIALF_ATTMETHOD_LANG"><![CDATA[(((C_ATTACHMENT_METHOD_ID) = '8FC51DE7BB394841936CDB3443810E00') AND (EM_OBIALF_LANGUAGE IS NOT NULL)) OR ((C_ATTACHMENT_METHOD_ID) <> '8FC51DE7BB394841936CDB3443810E00')]]></check>
- <check name="EM_OBIALF_ATTMETHOD_PASSWD"><![CDATA[(((C_ATTACHMENT_METHOD_ID) = '8FC51DE7BB394841936CDB3443810E00') AND (EM_OBIALF_PASSWORD IS NOT NULL)) OR ((C_ATTACHMENT_METHOD_ID) <> '8FC51DE7BB394841936CDB3443810E00')]]></check>
- <check name="EM_OBIALF_ATTMETHOD_USER"><![CDATA[(((C_ATTACHMENT_METHOD_ID) = '8FC51DE7BB394841936CDB3443810E00') AND (EM_OBIALF_USER IS NOT NULL)) OR ((C_ATTACHMENT_METHOD_ID) <> '8FC51DE7BB394841936CDB3443810E00')]]></check>
+ <check name="EM_OBIALF_ATTMETHOD_IP"><![CDATA[C_ATTACHMENT_METHOD_ID = '8FC51DE7BB394841936CDB3443810E00' AND EM_OBIALF_IP IS NOT NULL OR C_ATTACHMENT_METHOD_ID <> '8FC51DE7BB394841936CDB3443810E00']]></check>
+ <check name="EM_OBIALF_ATTMETHOD_LANG"><![CDATA[C_ATTACHMENT_METHOD_ID = '8FC51DE7BB394841936CDB3443810E00' AND EM_OBIALF_LANGUAGE IS NOT NULL OR C_ATTACHMENT_METHOD_ID <> '8FC51DE7BB394841936CDB3443810E00']]></check>
+ <check name="EM_OBIALF_ATTMETHOD_PASSWD"><![CDATA[C_ATTACHMENT_METHOD_ID = '8FC51DE7BB394841936CDB3443810E00' AND EM_OBIALF_PASSWORD IS NOT NULL OR C_ATTACHMENT_METHOD_ID <> '8FC51DE7BB394841936CDB3443810E00']]></check>
+ <check name="EM_OBIALF_ATTMETHOD_USER"><![CDATA[C_ATTACHMENT_METHOD_ID = '8FC51DE7BB394841936CDB3443810E00' AND EM_OBIALF_USER IS NOT NULL OR C_ATTACHMENT_METHOD_ID <> '8FC51DE7BB394841936CDB3443810E00']]></check>
     </table>
   </database>
Checking module org.openbravo.utility.hqlquerytool.es_ES:
.....................................


[1].- http://ci.openbravo.com/view/modules/job/mod-platform/679/ [^]
Steps To Reproduce-
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0033050 closed inigosanchez Errors in tests and DB Consistency of platform modules should be fixed. 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2017-10-05 13:27inigosanchezNew Issue
2017-10-05 13:27inigosanchezAssigned To => inigosanchez
2017-10-05 13:27inigosanchezModules => Core
2017-10-05 13:27inigosanchezTriggers an Emergency Pack => No
2017-10-05 13:28inigosanchezRelationship addedrelated to 0033050
2017-10-06 10:18inigosanchezStatusnew => scheduled
2017-10-06 10:51hgbotCheckin
2017-10-06 10:51hgbotNote Added: 0099789
2017-10-06 10:51hgbotStatusscheduled => resolved
2017-10-06 10:51hgbotResolutionopen => fixed
2017-10-06 10:51hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.integration.alfresco/rev/924b950b4c53af694c00ba41488bed4b5619e7e4 [^]
2017-10-06 12:11inigosanchezReview Assigned To => alostale
2017-10-06 12:11inigosanchezNote Added: 0099790
2017-10-06 13:08alostaleNote Added: 0099798
2017-10-06 13:08alostaleStatusresolved => closed

Notes
(0099789)
hgbot   
2017-10-06 10:51   
Repository: erp/pmods/org.openbravo.integration.alfresco
Changeset: 924b950b4c53af694c00ba41488bed4b5619e7e4
Author: Inigo Sanchez <inigo.sanchez <at> openbravo.com>
Date: Thu Oct 05 15:33:06 2017 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.integration.alfresco/rev/924b950b4c53af694c00ba41488bed4b5619e7e4 [^]

Fixed issue 37011: Fix db consistency of org.openbravo.integration.alfresco.

---
M src-db/database/model/modifiedTables/C_ATTACHMENT_CONF.xml
---
(0099790)
inigosanchez   
2017-10-06 12:11   
Now mod-platform job is fixed -> http://ci.openbravo.com/view/modules/job/mod-platform/681/ [^]
(0099798)
alostale   
2017-10-06 13:08   
reviewed: even changed, the expressions are equivalent