Openbravo Issue Tracking System - Localization Pack: Spain
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0048440Localization Pack: SpainSIIpublic2022-01-19 17:312022-04-01 10:51
Reportervmromanos 
Assigned Tovmromanos 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Support ticket
OBNetwork customer
Regression introduced in release
Summary0048440: SendInvoicesGroupsToAEAT might have problems when sending many invoices
DescriptionThe SendInvoicesGroupsToAEAT class might have the following issues:

1. It loads into memory many DAL objects without flushing and clearing cache on a regular basis. This might create an out of memory exception if the number of invoices to load is too high.

2. If the number of invoices to send in the batch, we might exceed a limit in the AEAT side (to be confirmed if this limit exists and the exact number).
Steps To ReproduceDetected in code review.
Proposed Solution1. Flush and clear session while iterating over the invoices.

2. Add a limit to the invoices retrieved by the main query.
Additional Information
TagsNOR
Relationships
related to design defect 0048238 new psanjuan SII performance review 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2022-01-19 17:31vmromanosNew Issue
2022-01-19 17:31vmromanosAssigned To => Jorge Bravo
2022-01-19 17:31vmromanosAssigned ToJorge Bravo => vmromanos
2022-02-21 16:19rafarodaRelationship addedrelated to 0048238
2022-02-21 16:19rafarodaTag Attached: NOR
2022-03-17 20:37hgbotNote Added: 0135823
2022-03-29 18:57hgbotNote Added: 0136140
2022-03-29 19:08hgbotNote Added: 0136141
2022-04-01 10:51hgbotResolutionopen => fixed
2022-04-01 10:51hgbotStatusnew => closed
2022-04-01 10:51hgbotNote Added: 0136246
2022-04-01 10:51hgbotNote Added: 0136247

Notes
(0135823)
hgbot   
2022-03-17 20:37   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.sii/-/merge_requests/32 [^]
(0136140)
hgbot   
2022-03-29 18:57   
Merge request closed: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.sii/-/merge_requests/32 [^]
(0136141)
hgbot   
2022-03-29 19:08   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.sii/-/merge_requests/34 [^]
(0136246)
hgbot   
2022-04-01 10:51   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.sii [^]
Changeset: 1946238ec4e58fe725343704313171023537570b
Author: Roberto Carlos Toledano Gómez <rctg82@gmail.com>
Date: 01-04-2022 08:51:20
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.sii/-/commit/1946238ec4e58fe725343704313171023537570b [^]

Fixed ISSUE-48440: Fixed Performances issues related with hibernate cache management.

---
A src-db/database/sourcedata/AD_PREFERENCE.xml
M src-db/database/sourcedata/AD_MODULE.xml
M src-db/database/sourcedata/AD_REF_LIST.xml
M src/org/openbravo/module/sii/process/background/SendInvoicesGroupsToAEAT.java
M src/org/openbravo/module/sii/utils/SIIUtils.java
---
(0136247)
hgbot   
2022-04-01 10:51   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.module.sii/-/merge_requests/34 [^]