In production sometimes attached error is logged. SSRS 2008 R2 is used in production. After that none of the reports got generated. After the SSRS Reporting service restart the report get generated successfully. Could you please help to identify the cause and suggest solution to solve the issue?
The specified ds consume below SP which takes parameter as given below
CREATE PROCEDURE [dbo].[XXXXXX]
@KeyID NVARCHAR (100) ,
@DefaultValue NVARCHAR (MAX) = NULL,
@ConnectionKey NVARCHAR(150) = NULL