Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0036792Openbravo ERP02. Master data managementpublic2017-09-05 16:262019-11-14 01:11
ReporterJONHM 
Assigned Tomarkmm82 
PrioritynormalSeverityminorReproducibilitysometimes
StatusfeedbackResolutionopen 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket47948
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0036792: 'Wrong sales invoice' alert has bad performance in environments with high volumes of data
Description'Wrong sales invoice' alert has bad performance in environments with high volumes of data.

fin_payment_scheduledetail -> 490639 records
fin_payment_schedule -> 912676 records
Steps To Reproduce** Ask environment to Support

Option 1:

1) Open 'Process Request' window and create a new record:
 - Process: 'Alert Process'
 - Timing: 'Run inmediately'
2) Schedule the process

Option 2:
Run the SQL query related to the Wrong sales invoice process

The query ends in about 1:20 minutes
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2017-09-05 16:26JONHMNew Issue
2017-09-05 16:26JONHMAssigned To => Triage Finance
2017-09-05 16:26JONHMOBNetwork customer => Yes
2017-09-05 16:26JONHMModules => Core
2017-09-05 16:26JONHMSupport ticket => 47948
2017-09-05 16:26JONHMTriggers an Emergency Pack => No
2017-09-05 16:27JONHMSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=15817#r15817
2017-09-05 17:13PracticsIssue Monitored: Practics
2019-11-12 01:54markmm82Assigned ToTriage Finance => markmm82
2019-11-12 01:54markmm82Statusnew => scheduled
2019-11-14 01:11markmm82Statusscheduled => feedback

There are no notes attached to this issue.