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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0045729
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] Y. DBSourceManagerminorhave not tried2021-01-13 17:522021-01-13 17:54
ReportershuehnerView Statuspublic 
Assigned Toplatform 
PrioritynormalResolutionopenFixed in Version
StatusnewFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseOracleJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0045729: export.database fails with some views on oracle with: An invalid XML character (Unicode: 0x0) was found in the CDATA section.

DescriptionProblem was found in one specific environment for 3 specific views.

Running export.database with the module in development containing those views fails with:
     [java] Caused by: org.apache.ddlutils.DdlUtilsException: An invalid XML character (Unicode: 0x0) was found in the CDATA section. : /srv/ci/workspace/mod-simple-ci34.18102/modules/org.openbravo.cashposition/src-db/database/model/views/OBCP_ACTUALS_V.xml
     [java] at org.apache.ddlutils.io.DatabaseIO.readplain(DatabaseIO.java:226)
     [java] at org.openbravo.ddlutils.task.DatabaseUtils.readDatabaseNoChecks(DatabaseUtils.java:300)
     [java] at org.openbravo.ddlutils.task.DatabaseUtils.readDatabaseNoChecks(DatabaseUtils.java:289)
     [java] at org.openbravo.ddlutils.task.DatabaseUtils.readDatabaseNoChecks(DatabaseUtils.java:289)
     [java] at org.openbravo.ddlutils.task.DatabaseUtils.getMergedDatabaseAndInitialize(DatabaseUtils.java:230)
     [java] at org.openbravo.ddlutils.task.DatabaseUtils.readDatabase(DatabaseUtils.java:207)
     [java] at org.openbravo.ddlutils.task.DatabaseUtils.readDatabaseModel(DatabaseUtils.java:450)
     [java] at org.openbravo.ddlutils.task.ExportDatabase.execute(ExportDatabase.java:211)

Technically errors comes from code inside export.database re-reading the just exported xml definition files and failing the the export did write wrong data into them.

Comparing diff of the wrong view to earlier state shows that 1 or 3 0x0 byte '0' are added just after the view definition itself inside the CDATA section.

The attached diff shows the wrong data.

Trigger for when this error is happening + cause of adding 1 or 3 of those bytes is currently unclear.
Problem can be reproduced 100% reliably in one environment.

This code-snapshot file and revision can reproduce the problem:
https://gitlab.com/obcustomers/ob_ob/snapshots/-/blob/a4c6300f70768f2c35e49fe39925f64b2b1d6a4a/Snapshot_Dev_HACK [^]
Steps To ReproduceClone above code-snapshot
run install.source on oracle
run all modules with type <>'T' into development
run export.database

Probably just exporting this specific module: "org.openbravo.cashposition" is enough to reproduce the problem
TagsNo tags attached.
Attached Filesdiff file icon oracle-export.database-problem.diff [^] (1,480 bytes) 2021-01-13 17:52 [Show Content]
xml file icon OBCP_ACTUALS_V.xml [^] (10,722 bytes) 2021-01-13 17:53
xml file icon OBCP_CASHPOSDETAIL_INT_V.xml [^] (1,408 bytes) 2021-01-13 17:53
xml file icon OBCP_CASHPOSDETAIL_V.xml [^] (1,748 bytes) 2021-01-13 17:53

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0125436)
shuehner (administrator)
2021-01-13 17:54

The 3 xml files attached are the 3 views triggering the problem (just for easy access. They are contained in the code-snapshot referenced above)

- Issue History
Date Modified Username Field Change
2021-01-13 17:52 shuehner New Issue
2021-01-13 17:52 shuehner Assigned To => platform
2021-01-13 17:52 shuehner File Added: oracle-export.database-problem.diff
2021-01-13 17:52 shuehner Modules => Core
2021-01-13 17:52 shuehner Triggers an Emergency Pack => No
2021-01-13 17:53 shuehner File Added: OBCP_ACTUALS_V.xml
2021-01-13 17:53 shuehner File Added: OBCP_CASHPOSDETAIL_INT_V.xml
2021-01-13 17:53 shuehner File Added: OBCP_CASHPOSDETAIL_V.xml
2021-01-13 17:54 shuehner Note Added: 0125436


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker