Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0034571Openbravo ERPA. Platformpublic2016-11-17 17:512016-12-16 18:38
ReporterJONHM 
Assigned Toalostale 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version3.0PR17Q1 
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
Summary0034571: Cannot attach xlsx files
DescriptionCannot attach xlsx files to any record
Steps To Reproduce1) Open G/L Journal and select some record
2) Press Attachments/Add and add the attached file (Book1.xlsx)
-> It shows error: dataType: Value (application/vnd.openxmlformats-officedocument.spreadsheetml.sheet) is too long, it has length 65, the maximum allowed length is 32
Proposed SolutionIt appears to be related to the length of the String, because xlsx files type is "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" and the default String of the column is only 32 characters length.
Additional Information
TagsNo tags attached.
Relationships
related to feature request 0029862 closed caristu Ability to generate excel reports with more than 65532 rows 
has duplicate defect 0035196 closed collazoandy4 Error when attaching an Excel file in Simple G/L Journal Window 
Attached Filesxlsx Book1.xlsx (7,874) 2016-11-17 17:51
https://issues.openbravo.com/file_download.php?file_id=10067&type=bug
Issue History
Date ModifiedUsernameFieldChange
2016-11-17 17:51JONHMNew Issue
2016-11-17 17:51JONHMAssigned To => platform
2016-11-17 17:51JONHMFile Added: Book1.xlsx
2016-11-17 17:51JONHMModules => Core
2016-11-17 17:51JONHMTriggers an Emergency Pack => No
2016-11-17 17:56jfrancesIssue Monitored: jfrances
2016-11-21 15:22alostaleAssigned Toplatform => alostale
2016-11-21 15:22alostaleReview Assigned To => caristu
2016-11-21 15:30hgbotCheckin
2016-11-21 15:30hgbotNote Added: 0091704
2016-11-21 15:31hgbotStatusnew => resolved
2016-11-21 15:31hgbotResolutionopen => fixed
2016-11-21 15:31hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/82b271d48d3de85a54e6d5aaeb32872891fc509e [^]
2016-11-21 18:10hgbotCheckin
2016-11-21 18:10hgbotNote Added: 0091719
2016-11-21 18:13caristuNote Added: 0091720
2016-11-21 18:13caristuStatusresolved => closed
2016-11-21 18:13caristuFixed in Version => 3.0PR17Q1
2016-11-21 18:14caristuRelationship addedrelated to 0029862
2016-12-16 18:38hudsonbotCheckin
2016-12-16 18:38hudsonbotNote Added: 0092648
2016-12-16 18:38hudsonbotCheckin
2016-12-16 18:38hudsonbotNote Added: 0092649
2017-02-08 17:10egoitzRelationship addedhas duplicate 0035196

Notes
(0091704)
hgbot   
2016-11-21 15:30   
Repository: erp/devel/pi
Changeset: 82b271d48d3de85a54e6d5aaeb32872891fc509e
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Mon Nov 21 15:28:27 2016 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/82b271d48d3de85a54e6d5aaeb32872891fc509e [^]

fixed bug 34571: Cannot attach xlsx files

  It was failing because tyka detected type is too long for column size.

  In case type is longer than this size, it will not be saved, this is a purely
  informational field with no functional effect, so it is save not to store it.

  Resizing column, would require a table recreation which could be problematic
  because its volume is pontentially high.

---
M modules/org.openbravo.client.application/src/org/openbravo/client/application/attachment/AttachImplementationManager.java
---
(0091719)
hgbot   
2016-11-21 18:10   
Repository: erp/devel/pi
Changeset: 64b44ea14896a47c9b567f42ec2c1de7b05cbd9b
Author: Carlos Aristu <carlos.aristu <at> openbravo.com>
Date: Mon Nov 21 18:00:55 2016 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/64b44ea14896a47c9b567f42ec2c1de7b05cbd9b [^]

related to issue 34571: removed duplicated semicolon

---
M modules/org.openbravo.client.application/src/org/openbravo/client/application/attachment/AttachImplementationManager.java
---
(0091720)
caristu   
2016-11-21 18:13   
Code reviewed + tested OK: files whose data type is larger than 32 can now be uploaded.
(0092648)
hudsonbot   
2016-12-16 18:38   
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/dc8bf00badd0 [^]
Maturity status: Test
(0092649)
hudsonbot   
2016-12-16 18:38   
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/dc8bf00badd0 [^]
Maturity status: Test