Reports are NOT being generated sometimes due to some error

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,    
   @LangID       NVARCHAR(10)=NULL,  
   @ConnectionKey NVARCHAR(150) = NULL  
)  

Open in new window

ReportError.jpg
LVL 16
Easwaran ParamasivamAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Gustav BrockCIOCommented:
".. being used by another process". Which process could that be? One of yours?

/gustav
Easwaran ParamasivamAuthor Commented:
There is no clue which process it is. That what I need help here.
Gustav BrockCIOCommented:
Well, if you run other processes, it could be one of yours; if you don't, it is something else.

/gustav
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

Franck GaspozSoftware Architect, Technical ExpertCommented:
you could try to use the free program: "unlocker" (http://filehippo.com/fr/download_unlocker/) in order to find what is the program which has already open the file and thus which lock it (right click on the file and select "unlock")
Gustav BrockCIOCommented:
Or call:

     tasklist /m yourlogfile.log

If you have anti-virus scanning active, try disabling this.

/gustav
Easwaran ParamasivamAuthor Commented:
@Gustav Brock: The tasklist command do not say the given file is being used by which processor. Could you please suggest correct command? Thanks.
Gustav BrockCIOCommented:
No, sorry.
However, I think this is side tracked. What you should study is the processes running in the SQL Server:

Monitoring running processes in SQL Server 2008 R2

/gustav

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Easwaran ParamasivamAuthor Commented:
@Gustav Brock - the link you suggested does not fulfill my requirement. Could you please help to identify what are the processors being used a file in question?
Gustav BrockCIOCommented:
It's not processors but processes. As the article suggests, it is blocking processes to watch for - if any, as I don't know if a blocking process is what could block reporting services.

/gustav
Easwaran ParamasivamAuthor Commented:
Thanks.
Gustav BrockCIOCommented:
You are welcome!

/gustav
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
C#

From novice to tech pro — start learning today.