What's the solution for a timeout issue for a report registered as a page in DSP?

DSP User

• January 24, 2018 13:58

I have a timeout issue for the report that is registered as a page in DSP (page type is Report) . The report execution time in the back end is less than 1 min. Some reports just hang in there in DSP and some are reported with timeout issue with the command: timeout 30. Any suggestions?

1

• 

  DSP User

  • February 02, 2018 12:21

  The recommendation from BOA Support is to write a stored procedure to insert the 30-second result set of the base view into a staging table. Then a new report view can  SELECT * FROM that staging table. The performance should be fine after that. The stored procedure can be registered to a scheduled download in Collect or even a Target in Transform (to make it more automated/scheduled).

  0

Please sign in to leave a comment.