Buscar

Why is my standard report queuing when it has never done so before?

Environment: 

Standard Reports
Oracle B2C Service Analytics, All versions

Issue:

One of our standard reports now processes too much data and wants to queue every time it is run. We would like to fix.

Resolution:

This behavior is likely because the report has been set to "deferred execution".  It will be set to deferred execution any time the report takes longer than 60 seconds to run and will remain deferred until an individual manually disables this option within the report. 

For a standard report, it is also possible to change the data source. Running reports from the Report Database allows them to run larger queries (i.e. historical month- or year-end reports).

For sites on version 24D and higher, Admins/Analytics admins can un-defer reports using BUI by accessing Report Management either directly from your navigation set in BUI or from the Administration tiles.  Screenshots and steps are shown in the 24D What's New Feature Analytics: Un-defer reports from BUI from Report Management.

Alternatively, use the steps outlined below to change the deferred and data source options using the .NET console:

1.  Open the standard report in Edit mode (right-click > Edit from Explorer or Edit Report Definitions from navigation area)
2.  From the ribbon, select 'More Options. 
3.  In the "Edit Settings" pop-up window, uncheck "Set report to deferred execution"
4.  Set Data Source as needed
5.  Click "OK"
6.  Save the report

NOTE:  If the report becomes deferred again, please ensure your agents have not adjusted the search filters in a way that would cause the report to process too much data and thus want to queue.

For information on modifying the deferred or data source options for custom reports, refer to Answer ID 4493: Custom report always queues now, when it has not in the past.

Para obtener información adicional, consulte la sección 'Queuing reports' en la documentación en línea para la versión que su sitio está ejecutando actualmente. Para acceder a los manuales y la documentación en línea de Oracle B2C Service, consulte la Documentación de los productos de Oracle B2C Service.