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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0037011
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformminorhave not tried2017-10-05 13:272017-10-06 13:08
ReporterinigosanchezView Statuspublic 
Assigned Toinigosanchez 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision924b950b4c53
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Toalostale
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0037011: 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-
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0033050 closedinigosanchez Errors in tests and DB Consistency of platform modules should be fixed. 

-  Notes
(0099789)
hgbot (developer)
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 (developer)
2017-10-06 12:11

Now mod-platform job is fixed -> http://ci.openbravo.com/view/modules/job/mod-platform/681/ [^]
(0099798)
alostale (manager)
2017-10-06 13:08

reviewed: even changed, the expressions are equivalent

- Issue History
Date Modified Username Field Change
2017-10-05 13:27 inigosanchez New Issue
2017-10-05 13:27 inigosanchez Assigned To => inigosanchez
2017-10-05 13:27 inigosanchez Modules => Core
2017-10-05 13:27 inigosanchez Triggers an Emergency Pack => No
2017-10-05 13:28 inigosanchez Relationship added related to 0033050
2017-10-06 10:18 inigosanchez Status new => scheduled
2017-10-06 10:51 hgbot Checkin
2017-10-06 10:51 hgbot Note Added: 0099789
2017-10-06 10:51 hgbot Status scheduled => resolved
2017-10-06 10:51 hgbot Resolution open => fixed
2017-10-06 10:51 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.integration.alfresco/rev/924b950b4c53af694c00ba41488bed4b5619e7e4 [^]
2017-10-06 12:11 inigosanchez Review Assigned To => alostale
2017-10-06 12:11 inigosanchez Note Added: 0099790
2017-10-06 13:08 alostale Note Added: 0099798
2017-10-06 13:08 alostale Status resolved => closed


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker