0035094: DBConsistency issues in OBUIAPP_Report table (Oracle only)

Description

Records 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 @@
 <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
 <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <ISACTIVE><![CDATA[Y]]></ISACTIVE>
- <CREATED><![CDATA[2016-07-28 16:54:13.15]]></CREATED>
+ <CREATED><![CDATA[2016-07-28 16:54:13.0]]></CREATED>
 <CREATEDBY><![CDATA[100]]></CREATEDBY>
- <UPDATED><![CDATA[2017-01-30 15:12:50.765]]></UPDATED>
+ <UPDATED><![CDATA[2017-01-30 15:12:50.0]]></UPDATED>
 <UPDATEDBY><![CDATA[100]]></UPDATEDBY>
 <OBUIAPP_PROCESS_ID><![CDATA[0D37A9F6109549DEB058373EF2DAEB6A]]></OBUIAPP_PROCESS_ID>
 <PDF_TEMPLATE><![CDATA[src-loc/design/org/openbravo/erpCommon/ad_reports/AgingSchedulePDF.jrxml]]></PDF_TEMPLATE>
@@ -22,9 +22,9 @@
 <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
 <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <ISACTIVE><![CDATA[Y]]></ISACTIVE>
- <CREATED><![CDATA[2016-07-19 14:24:01.749]]></CREATED>
+ <CREATED><![CDATA[2016-07-19 14:24:01.0]]></CREATED>
 <CREATEDBY><![CDATA[100]]></CREATEDBY>
- <UPDATED><![CDATA[2017-01-30 15:13:12.202]]></UPDATED>
+ <UPDATED><![CDATA[2017-01-30 15:13:12.0]]></UPDATED>
 <UPDATEDBY><![CDATA[100]]></UPDATEDBY>
 <OBUIAPP_PROCESS_ID><![CDATA[EB4C4053F3B94A17A08D1DD7E89CEB7E]]></OBUIAPP_PROCESS_ID>
 <PDF_TEMPLATE><![CDATA[src-loc/design/org/openbravo/erpCommon/ad_reports/AgingSchedulePDF.jrxml]]></PDF_TEMPLATE>

Steps To Reproduce

See 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 Solution

Set Exclude Audit Info = Y in "AD" Dataset, "OBUIAPP_Report" Table

Tags

No tags attached.

Attached Files

dbconsistency.diff [^] (1,251 bytes) 2017-01-31 08:50 [Show Content] [Hide Content]

diff --git a/modules/org.openbravo.client.application/src-db/database/sourcedata/AD_DATASET_TABLE.xml b/modules/org.openbravo.client.application/src-db/database/sourcedata/AD_DATASET_TABLE.xml
--- a/modules/org.openbravo.client.application/src-db/database/sourcedata/AD_DATASET_TABLE.xml
+++ b/modules/org.openbravo.client.application/src-db/database/sourcedata/AD_DATASET_TABLE.xml
@@ -65,7 +65,7 @@
 <!--7AA152F1C7D340CD9C29F2D4926EBFE0-->  <AD_TABLE_ID><![CDATA[C7CAB786F3EF4DF0B5E7B9AC6EC7DED8]]></AD_TABLE_ID>
 <!--7AA152F1C7D340CD9C29F2D4926EBFE0-->  <INCLUDEALLCOLUMNS><![CDATA[Y]]></INCLUDEALLCOLUMNS>
 <!--7AA152F1C7D340CD9C29F2D4926EBFE0-->  <WHERECLAUSE><![CDATA[obuiapp_process_id in (select obuiapp_process_id from obuiapp_process where ad_module_id in (:moduleid))]]></WHERECLAUSE>
-<!--7AA152F1C7D340CD9C29F2D4926EBFE0-->  <EXCLUDEAUDITINFO><![CDATA[N]]></EXCLUDEAUDITINFO>
+<!--7AA152F1C7D340CD9C29F2D4926EBFE0-->  <EXCLUDEAUDITINFO><![CDATA[Y]]></EXCLUDEAUDITINFO>
 <!--7AA152F1C7D340CD9C29F2D4926EBFE0-->  <ISBUSINESSOBJECT><![CDATA[N]]></ISBUSINESSOBJECT>
 <!--7AA152F1C7D340CD9C29F2D4926EBFE0-->  <AD_MODULE_ID><![CDATA[9BA0836A3CD74EE4AB48753A47211BCC]]></AD_MODULE_ID>
 <!--7AA152F1C7D340CD9C29F2D4926EBFE0--></AD_DATASET_TABLE>

Relationships [ Relation Graph ] [ Dependency Graph ]

blocks

feature request

0035089

3.0PR17Q2

closed

nonofrancisco

Integrate module Aging Balance Report into Openbravo 3 distribution

Notes
(0093954) hgbot (developer) 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 (viewer) 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 (viewer) 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

Issue History
Date Modified	Username	Field	Change
2017-01-31 08:50	vmromanos	New Issue
2017-01-31 08:50	vmromanos	Assigned To	=> platform
2017-01-31 08:50	vmromanos	File Added: dbconsistency.diff
2017-01-31 08:50	vmromanos	OBNetwork customer	=> No
2017-01-31 08:50	vmromanos	Modules	=> Core
2017-01-31 08:50	vmromanos	Triggers an Emergency Pack	=> No
2017-01-31 08:54	vmromanos	Relationship added	blocks 0035089
2017-01-31 08:59	alostale	Assigned To	platform => alostale
2017-01-31 08:59	hgbot	Checkin
2017-01-31 08:59	hgbot	Note Added: 0093954
2017-01-31 08:59	hgbot	Status	new => resolved
2017-01-31 08:59	hgbot	Resolution	open => fixed
2017-01-31 08:59	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/devel/pi/rev/2e2a9ff7c64467c3dd5959dd45cefdbff944cfc1 [^]
2017-01-31 09:00	alostale	Review Assigned To	=> caristu
2017-01-31 18:15	caristu	Note Added: 0093967
2017-01-31 18:15	caristu	Status	resolved => closed
2017-01-31 18:15	caristu	Fixed in Version	=> 3.0PR17Q2
2017-03-15 20:18	hudsonbot	Checkin
2017-03-15 20:18	hudsonbot	Note Added: 0095146