Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0011433Openbravo ERPY. DBSourceManagerpublic2009-11-20 09:452012-01-30 15:14
Reporteralostale 
Assigned Tomarvintm 
PriorityurgentSeverityminorReproducibilityhave not tried
StatusclosedResolutionout of date 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0011433: export.database adds ^M character using Oracle
Descriptionexport.database task inserts a bad new line character (^M) in some cases using Oracle.

I can reproduce it always in AD_Module license field. Not sure why it happens here and not in other text field with multiple lines.
Steps To Reproduce-Execute install.source having Oracle as rdbms.
-Execute export.database, no changes should appear but ad_module sourcedata is modified (see attached diff)
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 00122372.50MP12 closed alostale New lines include ^M character 
Attached Filesdiff module.diff (921) 2009-11-20 09:45
https://issues.openbravo.com/file_download.php?file_id=1966&type=bug
Issue History
Date ModifiedUsernameFieldChange
2009-11-20 09:45alostaleNew Issue
2009-11-20 09:45alostaleAssigned To => marvintm
2009-11-20 09:45alostaleFile Added: module.diff
2009-11-20 09:45alostaleOBNetwork customer => No
2009-11-25 10:23marvintmPrioritynormal => urgent
2009-11-25 10:27alostaleNote Added: 0022160
2010-01-05 12:19iciordiaStatusnew => scheduled
2010-01-05 12:19iciordiafix_in_branch => pi
2010-02-11 13:27shuehnerIssue Monitored: shuehner
2010-02-12 10:26alostaleRelationship addedrelated to 0012237
2012-01-30 15:14alostaleNote Added: 0044702
2012-01-30 15:14alostaleStatusscheduled => closed
2012-01-30 15:14alostaleResolutionopen => out of date

Notes
(0022160)
alostale   
2009-11-25 10:27   
This seems not to happen only in Oracle but also in postgreSQL.

The problem appears when a record that contains a text with multiple lines is edited from UI. This edition adds the ^M character. Export database maintains it but update database removes it.

The solution could be to make export database work like update database deleting this character.
(0044702)
alostale   
2012-01-30 15:14   
Fixed by 0012237