Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0055292Openbravo ERPA. Platformpublic2024-04-23 11:242024-05-22 12:12
Reportercharlotte_vasseur 
Assigned Tomeriem_azaf 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionPR24Q3 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression levelPackaging and release
Regression date2024-02-12
Regression introduced in releasemain
Regression introduced by commithttps://gitlab.com/openbravo/product/openbravo/-/commit/8069e182437fc9573ea241f6c467f6635e0acd16 [^]
Triggers an Emergency PackNo
Summary0055292: [24Q2] [BO] Error when importing Inventory via CSV file in Business API Data Load
DescriptionWhen importing an Inventory via CSV file in window Business API Data Load, an error "The Process request could not be performed. Please check the log for additional info" is displayed
Steps To ReproducePrepare a CSV file based on this:
organization,warehouse,inventoryType,countSlotTime,name,date,description,inventoryReason
ex: Vall Blanca Store,VBS/001,T,E,Count01,2024-04-24,Test desc,

File in attachment

Log in Openbravo backoffice and use a proper role to create total physical inventory
Go to 'Business API Data Load' window
Select 'Inventory' in 'Entity'
Upload the CSV previously prepared
Click on 'Done'

=> An error "The Process request could not be performed. Please check the log for additional info" is displayed (see Error import Inventory Business API Data Load.png)

2024-04-26 15:30:29,049 [http-nio-8181-exec-10] ERROR org.openbravo.client.kernel.KernelServlet - Error executing action org.openbravo.api.file.ImportFileActionHandler error: org.openbravo.base.exception.OBException: Request failed while parsing multipart parameters
java.lang.IllegalStateException: org.openbravo.base.exception.OBException: Request failed while parsing multipart parameters
    at org.openbravo.client.kernel.BaseActionHandler.execute(BaseActionHandler.java:75) ~[classes/:?]
    ...
Caused by: org.openbravo.base.exception.OBException: Request failed while parsing multipart parameters
    at org.openbravo.client.application.process.BaseProcessActionHandler.parseMultipartParameters(BaseProcessActionHandler.java:298) ~[classes/:?]
    at org.openbravo.client.application.process.BaseProcessActionHandler.extractParametersFromRequest(BaseProcessActionHandler.java:240) ~[classes/:?]
    at org.openbravo.client.kernel.BaseActionHandler.execute(BaseActionHandler.java:56) ~[classes/:?]
    ... 51 more
Caused by: org.apache.commons.fileupload.FileCountLimitExceededException: attachment
    at org.apache.commons.fileupload.FileUploadBase.parseRequest(FileUploadBase.java:367) ~[commons-fileupload-1.5.jar:1.5]
    at org.apache.commons.fileupload.servlet.ServletFileUpload.parseRequest(ServletFileUpload.java:113) ~[commons-fileupload-1.5.jar:1.5]
    at org.openbravo.client.application.process.BaseProcessActionHandler.parseMultipartParameters(BaseProcessActionHandler.java:277) ~[classes/:?]
    at org.openbravo.client.application.process.BaseProcessActionHandler.extractParametersFromRequest(BaseProcessActionHandler.java:240) ~[classes/:?]
    at org.openbravo.client.kernel.BaseActionHandler.execute(BaseActionHandler.java:56) ~[classes/:?]
    ... 51 more
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0055347PR24Q2 closed meriem_azaf [24Q2] [BO] Error when importing Inventory via CSV file in Business API Data Load 
caused by defect 0052268 closed meriem_azaf Update fileUpload library is outdated and should be updated to the latest release to use FileUploadBase#setFileCountMax 
has duplicate defect 0055542 closed Triage Platform Base Error when trying to import data from CSV file to an entity with the Business API Data Load process 
Attached Filescsv BO_STOCKINV_001 Generate massively total physical inventories.csv (216) 2024-04-23 11:24
https://issues.openbravo.com/file_download.php?file_id=19689&type=bug
png Error import Inventory Business API Data Load.png (78,780) 2024-04-23 11:24
https://issues.openbravo.com/file_download.php?file_id=19690&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2024-04-23 11:24charlotte_vasseurNew Issue
2024-04-23 11:24charlotte_vasseurAssigned To => Triage Platform Conn
2024-04-23 11:24charlotte_vasseurFile Added: BO_STOCKINV_001 Generate massively total physical inventories.csv
2024-04-23 11:24charlotte_vasseurRegression level => QA functional test
2024-04-23 11:24charlotte_vasseurTriggers an Emergency Pack => No
2024-04-23 11:24charlotte_vasseurFile Added: Error import Inventory Business API Data Load.png
2024-04-26 15:33alostaleRelationship addedcaused by 0052268
2024-04-26 15:34alostaleRegression introduced in release => main
2024-04-26 15:34alostaleRegression introduced by commit => https://gitlab.com/openbravo/product/openbravo/-/commit/8069e182437fc9573ea241f6c467f6635e0acd16 [^]
2024-04-26 15:35alostaleRegression date => 2024-02-12
2024-04-26 15:36alostaleSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=27899#r27899
2024-04-26 15:37alostaleProjectRetail Modules => Openbravo ERP
2024-04-26 15:37alostaleModules => Core
2024-04-26 15:37alostaleCategoryRetail API => A. Platform
2024-04-26 15:38alostaleStatusnew => scheduled
2024-04-26 15:38alostaleAssigned ToTriage Platform Conn => meriem_azaf
2024-04-29 07:25plujanRegression levelQA functional test => Packaging and release
2024-04-29 17:50hgbotNote Added: 0163916
2024-05-22 09:36AugustoMauchRelationship addedhas duplicate 0055542
2024-05-22 12:12hgbotNote Added: 0164955
2024-05-22 12:12hgbotResolutionopen => fixed
2024-05-22 12:12hgbotStatusscheduled => closed
2024-05-22 12:12hgbotFixed in Version => PR24Q3
2024-05-22 12:12hgbotNote Added: 0164956

Notes
(0163916)
hgbot   
2024-04-29 17:50   
Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/1218 [^]
(0164955)
hgbot   
2024-05-22 12:12   
Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/1218 [^]
(0164956)
hgbot   
2024-05-22 12:12   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: 8554c5c8baf4cf5a3054836f70f24c197aa86bee
Author: Meriem Azaf <m.azaf@orisha.com>
Date: 22-05-2024 09:26:34
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/8554c5c8baf4cf5a3054836f70f24c197aa86bee [^]

Fixes ISSUE-55292: Error when importing Inventory via CSV file in Business API Data Load

The problem here first was a problem of the maximum file count limit has been exceeded during the parsing of the multipart request. For this first we just increase the NUMBER_OF_FIXED_PARAMS to 5 and after we had a second problem related to csrfToken that is invalid, when we search we found that this parameter was added to formData instead of paramValues because we get the csrfToken from those.

So we removed all the new changes related to first phase and we keep just the second ones.

---
M modules/org.openbravo.client.application/web/org.openbravo.client.application/js/process/ob-parameter-window-view.js
---