Help needed to trobleshoot opening Report manager Url

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services » Help needed to trobleshoot opening Report...

Help needed to trobleshoot opening Report manager Url

Rate Topic

Display Mode

Topic Options

Author

Message

Mac1986

Posted Thursday, January 03, 2013 12:20 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 2:33 AM
Points: 180, Visits: 512

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.

Post #1402502

SQLRNNR

Posted Thursday, January 03, 2013 12:40 PM

SSCoach

Group: General Forum Members
Last Login: Monday, May 20, 2013 1:07 PM
Points: 18,733, Visits: 12,332

Rerun the report or the subscription.

Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp

Post #1402514

Mac1986

Posted Thursday, January 03, 2013 12:52 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 2:33 AM
Points: 180, Visits: 512

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.

Post #1402518

Mac1986

Posted Thursday, January 03, 2013 12:55 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 2:33 AM
Points: 180, Visits: 512

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.

Post #1402519

Mac1986

Posted Thursday, January 03, 2013 1:04 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 2:33 AM
Points: 180, Visits: 512

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.

Post #1402522

SQLRNNR

Posted Thursday, January 03, 2013 1:16 PM

SSCoach

Group: General Forum Members
Last Login: Monday, May 20, 2013 1:07 PM
Points: 18,733, Visits: 12,332

Try validating the DS in report manager. A setting may have changed with it or a password may have expired.

Post #1402524

Mac1986

Posted Thursday, January 03, 2013 4:52 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 2:33 AM
Points: 180, Visits: 512

Yes its all resolved now. I connecttion string in the datasource was not correct.

Post #1402615

SQLRNNR

Posted Monday, January 07, 2013 9:47 PM

SSCoach

Group: General Forum Members
Last Login: Monday, May 20, 2013 1:07 PM
Points: 18,733, Visits: 12,332

Mac1986 (1/3/2013)

Yes its all resolved now. I connecttion string in the datasource was not correct.

Good to hear.

Post #1403958

« Prev Topic | Next Topic »

Permissions