Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0053940
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Modules] French Fiscalmajoralways2023-11-15 10:032023-11-22 08:28
ReporteregoitzView Statuspublic 
Assigned Tovmromanos 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Regression introduced in release
Summary

0053940: 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.



TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0047331 closedvmromanos Improve performance FrenchFiscalSecurityManager 

-  Notes
(0157269)
hgbot (developer)
2023-11-17 10:00

 Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.certification.france/-/merge_requests/14 [^]
(0157443)
hgbot (developer)
2023-11-22 08:28

 Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.certification.france/-/merge_requests/14 [^]
(0157444)
hgbot (developer)
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
---

- Issue History
Date Modified Username Field Change
2023-11-15 10:03 egoitz New Issue
2023-11-15 10:03 egoitz Assigned To => vmromanos
2023-11-15 10:03 egoitz Issue generated from 0047331
2023-11-15 10:03 egoitz Relationship added related to 0047331
2023-11-15 10:04 egoitz Assigned To vmromanos => Triage Omni OMS
2023-11-17 09:58 vmromanos Status new => scheduled
2023-11-17 09:58 vmromanos Assigned To Triage Omni OMS => vmromanos
2023-11-17 10:00 hgbot Note Added: 0157269
2023-11-22 08:28 hgbot Note Added: 0157443
2023-11-22 08:28 hgbot Resolution open => fixed
2023-11-22 08:28 hgbot Status scheduled => closed
2023-11-22 08:28 hgbot Note Added: 0157444

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker