Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0053940ModulesFrench Fiscalpublic2023-11-15 10:032023-11-22 08:28
Reporteregoitz 
Assigned Tovmromanos 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Statusapproved
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Support ticket
OBNetwork customerGold
Regression introduced in release
Summary0053940: Improve performance FrenchFiscalSecurityManager
DescriptionIn a HV environment the following queries have been detected as slow and consuming lot of disk.

select distinct obcfr_tick0_.Obpos_Applications_ID as col_0_0_ from OBCFR_Ticket obcfr_tick0_ where obcfr_tick0_.AD_Client_ID=$1
 select distinct obcfr_tick0_.Obpos_Applications_ID as col_0_0_ from OBCFR_TicketTax obcfr_tick0_ where obcfr_tick0_.AD_Client_ID=$1
 select distinct obcfr_tick0_.Obpos_Applications_ID as col_0_0_ from OBCFR_TicketReprint obcfr_tick0_ where obcfr_tick0_.AD_Client_ID=$1
 select distinct obcfr_term0_.Obpos_Applications_ID as col_0_0_ from OBCFR_TerminalMonitor obcfr_term0_ where obcfr_term0_.AD_Client_ID=$1
 select distinct obcfr_tick0_.Obpos_Applications_ID as col_0_0_ from OBCFR_Ticket_AggDay obcfr_tick0_ where obcfr_tick0_.AD_Client_ID=$1
 select distinct obcfr_tick0_.Obpos_Applications_ID as col_0_0_ from OBCFR_Ticket_AggMonth obcfr_tick0_ where obcfr_tick0_.AD_Client_ID=$1
 select distinct obcfr_tick0_.Obpos_Applications_ID as col_0_0_ from OBCFR_Ticket_AggYear obcfr_tick0_ where obcfr_tick0_.AD_Client_ID=$1

These queries are related to the FrenchFiscalSecurityManager class
Steps To ReproduceCheck databse staticstics of any big customers.

that is affecting several customers.
Proposed SolutionThe fixed on the issue 47331 are not enough.
If the goal is to identify the terminals used for the localization,. a new flag should be defined on the terminal like used Y/N and do the query on the applicaitons table.



Additional Information
TagsNo tags attached.
Relationships
related to defect 0047331 closed vmromanos Improve performance FrenchFiscalSecurityManager 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2023-11-15 10:03egoitzNew Issue
2023-11-15 10:03egoitzAssigned To => vmromanos
2023-11-15 10:03egoitzOBNetwork customer => No
2023-11-15 10:03egoitzIssue generated from0047331
2023-11-15 10:03egoitzRelationship addedrelated to 0047331
2023-11-15 10:04egoitzAssigned Tovmromanos => Triage Omni OMS
2023-11-15 10:04egoitzOBNetwork customerNo => Gold
2023-11-17 09:58vmromanosStatusnew => scheduled
2023-11-17 09:58vmromanosAssigned ToTriage Omni OMS => vmromanos
2023-11-17 10:00hgbotMerge Request Status => open
2023-11-17 10:00hgbotNote Added: 0157269
2023-11-17 15:38hgbotMerge Request Statusopen => approved
2023-11-17 15:39hgbotMerge Request Statusapproved => open
2023-11-21 17:33hgbotMerge Request Statusopen => approved
2023-11-22 08:28hgbotNote Added: 0157443
2023-11-22 08:28hgbotResolutionopen => fixed
2023-11-22 08:28hgbotStatusscheduled => closed
2023-11-22 08:28hgbotNote Added: 0157444

Notes
(0157269)
hgbot   
2023-11-17 10:00   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.certification.france/-/merge_requests/14 [^]
(0157443)
hgbot   
2023-11-22 08:28   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.certification.france/-/merge_requests/14 [^]
(0157444)
hgbot   
2023-11-22 08:28   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.certification.france [^]
Changeset: 79d0b7d9d9d9dafe4c384a95bed8a50b3b3a64fd
Author: Víctor Martínez Romanos <victor.martinez@openbravo.com>
Date: 22-11-2023 07:27:51
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.certification.france/-/commit/79d0b7d9d9d9dafe4c384a95bed8a50b3b3a64fd [^]

Fixed ISSUE-53940: Unschedule Security Background by default

The French Fiscal Security Background process is unscheduled by default,
as everybody using the French Fiscal module is in our Cloud.
Therefore the System Level dataset is removed and its AD's configuration.

The OBCFR_PROCESS_REQUEST_TRG trigger is removed because there is no
need anymore to avoid the possibility to unschedule the process.

In the future we might consider to delete the French Fiscal Security Background
process itself too.

---
M src-db/database/sourcedata/AD_DATASET.xml
M src-db/database/sourcedata/AD_DATASET_TABLE.xml
R referencedata/standard/SystemLevel.xml
R src-db/database/model/triggers/OBCFR_PROCESS_REQUEST_TRG.xml
---