Openbravo Issue Tracking System - Modules
View Issue Details
0057092ModulesOpenbravo Business APIpublic2024-11-14 07:552024-11-18 17:23
alostale 
Triage Platform Conn 
normalminorhave not tried
closedfixed 
5
 
 
0057092: cannot import with API with System role
Roles with access only to System client cannot launch import APIs.
1. Give webservice access to System Admin role
2. Create a user with this role as default
3. Try to create a user using the ws/org.openbravo.api.ImportService/User endpoint

ERROR:
HTTP 500
Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1; statement executed: update C_IMPORT_ENTRY set AD_Client_ID=?, AD_Org_ID=?, Isactive=?, Created=?, Createdby=?, Updated=?, Updatedby=?, Imported=?, Jsoninfo=?, ImportStatus=?, Typeofdata=?, Errorinfo=?, AD_Role_ID=?, Createdtimestamp=?, EM_Obpos_Applications_ID=?, Responseinfo=?, Isnonblocking=? where C_IMPORT_ENTRY_ID=?

No tags attached.
Issue History
2024-11-14 07:55alostaleNew Issue
2024-11-14 07:55alostaleAssigned To => Triage Platform Conn
2024-11-14 08:00hgbotNote Added: 0171956
2024-11-18 17:23hgbotResolutionopen => fixed
2024-11-18 17:23hgbotStatusnew => closed
2024-11-18 17:23hgbotFixed in Version => PR25Q1
2024-11-18 17:23hgbotNote Added: 0172188
2024-11-18 17:23hgbotNote Added: 0172189

Notes
(0171956)
hgbot   
2024-11-14 08:00   
Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/1439 [^]
(0172188)
hgbot   
2024-11-18 17:23   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: bcbe631ef12c2ce2b0c4fc9dff769d8de458086a
Author: Asier Lostalé <a.lostale@orisha.com>
Date: 18-11-2024 16:22:53
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/bcbe631ef12c2ce2b0c4fc9dff769d8de458086a [^]

fixed BUG-57092: cannot import with API with System role

C_Import_Entry and C_Import_Entry_Archive tables' access level has been changed
from Client/Organization to All allowing thus entries in System client.

---
M src-db/database/sourcedata/AD_TABLE.xml
---
(0172189)
hgbot   
2024-11-18 17:23   
Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/1439 [^]