Yesterday it was a cloudy day here in sunny San Diego, everyone here at the office busy as always all of the sudden an email came to support. The customer could not generate their report book from Report Manager in FRx.
The error in question was found after FRx Service pack 10 was released and it was fixed on FRx Service pack 11. But our customer is on 10, and it worked the previous month so something changed between last month and current month that triggered this error.
The error says: “FRx Error 988672 Access denied because another caller has the file open and locked”, my first reaction was to ask the customer if in fact they had the file open, but it was not, my sherlock holmes identity came out and I went to their server, pulled out Task Manager, verified all open instances of excel (found none), then I went to my toolbox and pulled Process Explorer from sysinternals, I tried running the report book again, same error.
This time I searched for all open handles for that particular file, being found once while FRx was showing up the error, the handle was released after I clicked OK button to make the error go away. I reached out to my toolbox again and pulled Process monitor, I placed some filters around the user instance on the server I tried again the report with error results.
Process Monitor did not gave me the solution either, I went to my default search engine (BING) and found a case on the SL community, Microsoft states that this error is resolved by installing FRx SP11, but it was working before… and my client was not on the mood for a software update at this time.
To aid in my investigation I did the following tests:
- Open Frx Designer and run the report –> Result: Report Generates
- Open Report Manager: On the book definition, right click and Generate –> Result: Report Generates
- Open Report Manager: On the book definition, Generate the reports automatically –> Result: Report Fails
After almost being done with all the report ID’s that made the Report book, I found 1 report that was not valid, I searched for the catalog id in report designer but I couldn’t find it. Once I changed it to the correct report I was still getting the error.
So I had the user do the following:
- Log out from GP
- Log out from FRx
- Close Report Manager
- Log out from Citrix
- I was still in citrix as administrator and deleted the users profile temp folder
- had the user log back in and everything worked.
Please give it a try, let me know if this temp solution avoids the install of SP 11 when you can’t do it, but eventually install it.
Francisco G. Hillyer