Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0035094Openbravo ERP00. Application dictionarypublic2017-01-31 08:502017-03-15 20:18
Reportervmromanos 
Assigned Toalostale 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR17Q2 
Merge Request Status
Review Assigned Tocaristu
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0035094: DBConsistency issues in OBUIAPP_Report table (Oracle only)
DescriptionRecords in OBUIAPP_Report table are exported including the audit info.
When exporting the table in Oracle, a db consistency issue is raised in datetime related columns (CREATED and UPDATED):

diff -r 53692de33d76 src-db/database/sourcedata/OBUIAPP_REPORT.xml
--- a/src-db/database/sourcedata/OBUIAPP_REPORT.xml Mon Jan 30 17:42:05 2017 +0100
+++ b/src-db/database/sourcedata/OBUIAPP_REPORT.xml Mon Jan 30 19:30:22 2017 +0000
@@ -5,9 +5,9 @@
 <!--68A8BDCCDCC54B4E8D2D780334B6FF1D--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
 <!--68A8BDCCDCC54B4E8D2D780334B6FF1D--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--68A8BDCCDCC54B4E8D2D780334B6FF1D--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--68A8BDCCDCC54B4E8D2D780334B6FF1D--> <CREATED><![CDATA[2016-07-28 16:54:13.15]]></CREATED>
+<!--68A8BDCCDCC54B4E8D2D780334B6FF1D--> <CREATED><![CDATA[2016-07-28 16:54:13.0]]></CREATED>
 <!--68A8BDCCDCC54B4E8D2D780334B6FF1D--> <CREATEDBY><![CDATA[100]]></CREATEDBY>
-<!--68A8BDCCDCC54B4E8D2D780334B6FF1D--> <UPDATED><![CDATA[2017-01-30 15:12:50.765]]></UPDATED>
+<!--68A8BDCCDCC54B4E8D2D780334B6FF1D--> <UPDATED><![CDATA[2017-01-30 15:12:50.0]]></UPDATED>
 <!--68A8BDCCDCC54B4E8D2D780334B6FF1D--> <UPDATEDBY><![CDATA[100]]></UPDATEDBY>
 <!--68A8BDCCDCC54B4E8D2D780334B6FF1D--> <OBUIAPP_PROCESS_ID><![CDATA[0D37A9F6109549DEB058373EF2DAEB6A]]></OBUIAPP_PROCESS_ID>
 <!--68A8BDCCDCC54B4E8D2D780334B6FF1D--> <PDF_TEMPLATE><![CDATA[src-loc/design/org/openbravo/erpCommon/ad_reports/AgingSchedulePDF.jrxml]]></PDF_TEMPLATE>
@@ -22,9 +22,9 @@
 <!--A05C13349F194901A01A6D0D63B0113B--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
 <!--A05C13349F194901A01A6D0D63B0113B--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--A05C13349F194901A01A6D0D63B0113B--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--A05C13349F194901A01A6D0D63B0113B--> <CREATED><![CDATA[2016-07-19 14:24:01.749]]></CREATED>
+<!--A05C13349F194901A01A6D0D63B0113B--> <CREATED><![CDATA[2016-07-19 14:24:01.0]]></CREATED>
 <!--A05C13349F194901A01A6D0D63B0113B--> <CREATEDBY><![CDATA[100]]></CREATEDBY>
-<!--A05C13349F194901A01A6D0D63B0113B--> <UPDATED><![CDATA[2017-01-30 15:13:12.202]]></UPDATED>
+<!--A05C13349F194901A01A6D0D63B0113B--> <UPDATED><![CDATA[2017-01-30 15:13:12.0]]></UPDATED>
 <!--A05C13349F194901A01A6D0D63B0113B--> <UPDATEDBY><![CDATA[100]]></UPDATEDBY>
 <!--A05C13349F194901A01A6D0D63B0113B--> <OBUIAPP_PROCESS_ID><![CDATA[EB4C4053F3B94A17A08D1DD7E89CEB7E]]></OBUIAPP_PROCESS_ID>
 <!--A05C13349F194901A01A6D0D63B0113B--> <PDF_TEMPLATE><![CDATA[src-loc/design/org/openbravo/erpCommon/ad_reports/AgingSchedulePDF.jrxml]]></PDF_TEMPLATE>
Steps To ReproduceSee https://ci.openbravo.com/job/try-dbcons-oracle/4966/console [^]

IN POSTGRESQL:
As system admin
Go to Process Definition and create a new record. UI Pattern = Report
In Report Definition tab create and save any record
Export Database and save the diff

IN ORACLE:
Apply the diff previously created and run smartbuild -Dlocal=no
Now export database and realized there is a db consistency issue
Proposed SolutionSet Exclude Audit Info = Y in "AD" Dataset, "OBUIAPP_Report" Table
Additional Information
TagsNo tags attached.
Relationships
blocks feature request 00350893.0PR17Q2 closed nonofrancisco Integrate module Aging Balance Report into Openbravo 3 distribution 
Attached Filesdiff dbconsistency.diff (1,251) 2017-01-31 08:50
https://issues.openbravo.com/file_download.php?file_id=10360&type=bug
Issue History
Date ModifiedUsernameFieldChange
2017-01-31 08:50vmromanosNew Issue
2017-01-31 08:50vmromanosAssigned To => platform
2017-01-31 08:50vmromanosFile Added: dbconsistency.diff
2017-01-31 08:50vmromanosModules => Core
2017-01-31 08:50vmromanosTriggers an Emergency Pack => No
2017-01-31 08:54vmromanosRelationship addedblocks 0035089
2017-01-31 08:59alostaleAssigned Toplatform => alostale
2017-01-31 08:59hgbotCheckin
2017-01-31 08:59hgbotNote Added: 0093954
2017-01-31 08:59hgbotStatusnew => resolved
2017-01-31 08:59hgbotResolutionopen => fixed
2017-01-31 08:59hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/2e2a9ff7c64467c3dd5959dd45cefdbff944cfc1 [^]
2017-01-31 09:00alostaleReview Assigned To => caristu
2017-01-31 18:15caristuNote Added: 0093967
2017-01-31 18:15caristuStatusresolved => closed
2017-01-31 18:15caristuFixed in Version => 3.0PR17Q2
2017-03-15 20:18hudsonbotCheckin
2017-03-15 20:18hudsonbotNote Added: 0095146

Notes
(0093954)
hgbot   
2017-01-31 08:59   
Repository: erp/devel/pi
Changeset: 2e2a9ff7c64467c3dd5959dd45cefdbff944cfc1
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Tue Jan 31 08:59:00 2017 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/2e2a9ff7c64467c3dd5959dd45cefdbff944cfc1 [^]

fixed bug 35094: DBConsistency issues in OBUIAPP_Report table

  Records in OBUIAPP_Report table where exported including audit information.

---
M modules/org.openbravo.client.application/src-db/database/sourcedata/AD_DATASET_TABLE.xml
---
(0093967)
caristu   
2017-01-31 18:15   
Code reviewed + tested OK: audit columns of OBUIAPP_Report table are not exported into the AD dataset.

Tested in pi@a71a3822d5e5
(0095146)
hudsonbot   
2017-03-15 20:18   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/54e102bef53e [^]
Maturity status: Test