January 3, 2013 at 12:20 pm
hi All, Some one deleted the internal folders of the 'C:\Users\' and I'm facing issues opening the Url.
I'm getting the below error when i try to open the report Manager Url.
Could not find a part of the path 'C:\Users\BICLDP\AppData\Local\Tempvq2groi.tmp'.
We have Yearly report that we build and saved on that Url.
It is our Prod Environment so can some please help me create that temp File ASAP.
January 3, 2013 at 12:40 pm
Rerun the report or the subscription.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 3, 2013 at 12:52 pm
OK I resolved this issue. I'm able to open the Report manager URl now.
But when I try to open the reports in it says Invalid Object name 'My Table Name'. So, Then I deleted the existing report and uploaded a new RDL File and still the same error.
Can some please help on this error.
January 3, 2013 at 12:55 pm
I mean I build the report in the same server where the SSRS Configuration manager is set up. And in the Visual studio, I'm able to view the report preview and but when I copy the same RDL File on to the Report manager Url, I set this error. What might have hapenned before and after because the object that report is looking for exists and is valid.
January 3, 2013 at 1:04 pm
Ok I have just figured out a work around for that as well. I have not chosen a data source in the report manager. Instead I have used the datasource connection string to open the report. then every thing went fine.
But I still wanna know why I'm getting invalid Object error when I use a datasource that us hosted in the report manager.
January 3, 2013 at 1:16 pm
Try validating the DS in report manager. A setting may have changed with it or a password may have expired.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 3, 2013 at 4:52 pm
Yes its all resolved now. I connecttion string in the datasource was not correct.
January 7, 2013 at 9:47 pm
Mac1986 (1/3/2013)
Yes its all resolved now. I connecttion string in the datasource was not correct.
Good to hear.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply