Friday, March 30, 2012
Report Error, Help!
I have beening trying to build a report with 2 parameters. When I run it
under VS.net, it all went well, but after I deploy it to the server, I got
the message as following: Reporting Services Error--The path of the item ''
is not valid. The full path must be less than 260 characters long, must start
with slash; other restrictions apply. Check the documentation for complete
set of restrictions. (rsInvalidItemPath) Get Online Help
what went wrong, please help. TIAYou sure have to post your URL to help you.
Jens Suessmeyer.
"wd1153" <wd1153@.discussions.microsoft.com> schrieb im Newsbeitrag
news:5138A906-7AA9-4D7A-A1B5-E3C9756BE7E1@.microsoft.com...
> Hi
> I have beening trying to build a report with 2 parameters. When I run it
> under VS.net, it all went well, but after I deploy it to the server, I got
> the message as following: Reporting Services Error--The path of the item
> ''
> is not valid. The full path must be less than 260 characters long, must
> start
> with slash; other restrictions apply. Check the documentation for complete
> set of restrictions. (rsInvalidItemPath) Get Online Help
> what went wrong, please help. TIA
>
>|||Sorry, the URL as following:
http://localhost/reportserver?%2fRev_Stats%2fRev_Stats&rs:Command=Render
"Jens Sü�meyer" wrote:
> You sure have to post your URL to help you.
> Jens Suessmeyer.
>
> "wd1153" <wd1153@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:5138A906-7AA9-4D7A-A1B5-E3C9756BE7E1@.microsoft.com...
> > Hi
> >
> > I have beening trying to build a report with 2 parameters. When I run it
> > under VS.net, it all went well, but after I deploy it to the server, I got
> > the message as following: Reporting Services Error--The path of the item
> > ''
> > is not valid. The full path must be less than 260 characters long, must
> > start
> > with slash; other restrictions apply. Check the documentation for complete
> > set of restrictions. (rsInvalidItemPath) Get Online Help
> > what went wrong, please help. TIA
> >
> >
> >
>
>
Report doesn't work when deployed
deploy it and run it in the report server I get this message:
"An error has occurred during report processing. (rsProcessingAborted)
Obtener ayuda en lÃnea
Query execution failed for data set 'All_TTs'. (rsErrorExecutingCommand)
Obtener ayuda en lÃnea
Object reference not set to an instance of an object. "
I tried recreating the data set bu it was worthless.
--
Pato Connonensure your datasource is pointing to the correct location, and that the
report uses the correct datasource. also ensure your datasource has the
correct connection information
"Pato Connon" wrote:
> I have a report that works perfectly in the development enviroment but when I
> deploy it and run it in the report server I get this message:
> "An error has occurred during report processing. (rsProcessingAborted)
> Obtener ayuda en lÃnea
> Query execution failed for data set 'All_TTs'. (rsErrorExecutingCommand)
> Obtener ayuda en lÃnea
> Object reference not set to an instance of an object. "
> I tried recreating the data set bu it was worthless.
> --
> Pato Connon|||If you are using an ODBC datasource, you might have to create the
datasource on the SSRS server as well. When you run the report in the
designer, it is looking for the ODBC connection on your computer, but
when it runs on the server, it is looking on the server.
-Josh
Pato Connon wrote:
> I have a report that works perfectly in the development enviroment but wh=en I
> deploy it and run it in the report server I get this message:
> "An error has occurred during report processing. (rsProcessingAborted)
> Obtener ayuda en l=EDnea
> Query execution failed for data set 'All_TTs'. (rsErrorExecutingCommand)
> Obtener ayuda en l=EDnea
> Object reference not set to an instance of an object. "
> I tried recreating the data set bu it was worthless.
> -- > Pato Connon
report does not come up in remote machine
I embedded the report I developed to my asp.net web page,
when I run it in my development computer it is running
fine but I the report does not come up when I call web
page in a remote machine. The rest of web page is working
only report object is not coming. What might the problem
be?
Thanks,
Jim.The account used to access report may not have sufficient permissions to
access the report. You may need to give it sufficient privileges from Report
Manager UI.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"JIM.H." <anonymous@.discussions.microsoft.com> wrote in message
news:a12801c48721$62e79070$a501280a@.phx.gbl...
> Hello,
> I embedded the report I developed to my asp.net web page,
> when I run it in my development computer it is running
> fine but I the report does not come up when I call web
> page in a remote machine. The rest of web page is working
> only report object is not coming. What might the problem
> be?
> Thanks,
> Jim.
>|||I am actually using the same user. Is report manager
Prograns-> Sql server-> Reporting Services -> Report
Manager? If yes, when I click that it goes to
Http://mylocalhost/Reports and it says "You are not
authorized to view this page"
Any solution?
>--Original Message--
>The account used to access report may not have sufficient
permissions to
>access the report. You may need to give it sufficient
privileges from Report
>Manager UI.
>--
>Ravi Mumulla (Microsoft)
>SQL Server Reporting Services
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>"JIM.H." <anonymous@.discussions.microsoft.com> wrote in
message
>news:a12801c48721$62e79070$a501280a@.phx.gbl...
>> Hello,
>> I embedded the report I developed to my asp.net web
page,
>> when I run it in my development computer it is running
>> fine but I the report does not come up when I call web
>> page in a remote machine. The rest of web page is
working
>> only report object is not coming. What might the problem
>> be?
>> Thanks,
>> Jim.
>
>.
>
Wednesday, March 28, 2012
Report Desginer Requirements?
Does anyone know if Report Designer for Reporting Services requires the full Visual Studio .NET 2003 suite, or will it run under Visual Basic .NET soo3
Thank
MattWhen you run the setup for Reporting Services, there should be a check which
requires VS.NET 2003 (any edition) to use the Report Designer. VB.NET, by
itself is not enough.
--
- Anith
( Please reply to newsgroups only )|||"Anith Sen" wrote:
> When you run the setup for Reporting Services, there should be a check
which
> requires VS.NET 2003 (any edition) to use the Report Designer. VB.NET, by
> itself is not enough.
I guess the SBS (and like) crowd must love this:~).
Happy Holidays,
www.rac4sql.net|||Right, any .NET thingy ought to be enough, remember, there are always
incentives for complexity :-)
--
- Anith
( Please reply to newsgroups only )|||"Anith Sen" wrote:
> ...there are always incentives for complexity :-)
Hmm...I remember recently reading just that phrase :~)sql
Friday, March 23, 2012
Report calling a Stored procedure taking too much time while
I have a CLR stored proceudure than runs under 2 or 3 mins when run in management studio. But when the report calls the same SP, it runs in around 30 mins and the CPU usage goes to 90 or 100% and the sqlserver service uses massive amount of memory. Previously the report worked fine, only after made a few data driven subscriptions and redeployed the reports with minor changes that it began to happen.
Please help--Iam stumped.
There are no infinite loops in the report. I checked.
I suggest you use the SQL Server Profiler to see what queries are sent to the database. Also, take a look at the ExecutionLog table in the ReportServer database to find how much time is spent in data retrieval.|||All the time is spent in data retrievel while the same SP in management studio takes far less time ? I can't understand whats happening
|||Also if i cancel the running jobs from Report Manager, they automatically restart after sometime? Any clues?
|||Perhaps, debugging the stored procedure would help to find what's happening
|||Sounds like you're running into issues with query plan; it is not uncommon to see this difference when running in Mgmt Studio vs. running in reports.
I recommend reading up on query performance:
http://msdn2.microsoft.com/en-us/library/ms187032.aspx
There are a couple of common problems people have with queries in stored procs (especially). These can often be fixed using the WITH RECOMPILE directive. This is especially true if the size of data your return from a test query is significantly different than that in the production query.
Secondly, if you reference other database objects in your query, using fully qualified names (dbo.storedProcName), you can also get some benefits.
Hope this helps,
-Lukasz
Report calling a Stored procedure taking too much time while
I have a CLR stored proceudure than runs under 2 or 3 mins when run in management studio. But when the report calls the same SP, it runs in around 30 mins and the CPU usage goes to 90 or 100% and the sqlserver service uses massive amount of memory. Previously the report worked fine, only after made a few data driven subscriptions and redeployed the reports with minor changes that it began to happen.
Please help--Iam stumped.
There are no infinite loops in the report. I checked.
I suggest you use the SQL Server Profiler to see what queries are sent to the database. Also, take a look at the ExecutionLog table in the ReportServer database to find how much time is spent in data retrieval.|||All the time is spent in data retrievel while the same SP in management studio takes far less time ? I can't understand whats happening
|||Also if i cancel the running jobs from Report Manager, they automatically restart after sometime? Any clues?
|||Perhaps, debugging the stored procedure would help to find what's happening
|||Sounds like you're running into issues with query plan; it is not uncommon to see this difference when running in Mgmt Studio vs. running in reports.
I recommend reading up on query performance:
http://msdn2.microsoft.com/en-us/library/ms187032.aspx
There are a couple of common problems people have with queries in stored procs (especially). These can often be fixed using the WITH RECOMPILE directive. This is especially true if the size of data your return from a test query is significantly different than that in the production query.
Secondly, if you reference other database objects in your query, using fully qualified names (dbo.storedProcName), you can also get some benefits.
Hope this helps,
-Lukasz
Report calling a Stored procedure taking too much time while
I have a CLR stored proceudure than runs under 2 or 3 mins when run in management studio. But when the report calls the same SP, it runs in around 30 mins and the CPU usage goes to 90 or 100% and the sqlserver service uses massive amount of memory. Previously the report worked fine, only after made a few data driven subscriptions and redeployed the reports with minor changes that it began to happen.
Please help--Iam stumped.
There are no infinite loops in the report. I checked.
I suggest you use the SQL Server Profiler to see what queries are sent to the database. Also, take a look at the ExecutionLog table in the ReportServer database to find how much time is spent in data retrieval.|||All the time is spent in data retrievel while the same SP in management studio takes far less time ? I can't understand whats happening
|||Also if i cancel the running jobs from Report Manager, they automatically restart after sometime? Any clues?
|||Perhaps, debugging the stored procedure would help to find what's happening
|||Sounds like you're running into issues with query plan; it is not uncommon to see this difference when running in Mgmt Studio vs. running in reports.
I recommend reading up on query performance:
http://msdn2.microsoft.com/en-us/library/ms187032.aspx
There are a couple of common problems people have with queries in stored procs (especially). These can often be fixed using the WITH RECOMPILE directive. This is especially true if the size of data your return from a test query is significantly different than that in the production query.
Secondly, if you reference other database objects in your query, using fully qualified names (dbo.storedProcName), you can also get some benefits.
Hope this helps,
-Lukasz
sqlReport caching
I have a report that takes about 10 minutes to run for a given date. How can
I cache it some how so that it would run lot faster for the same data input
(date) later on?
Thanks in advance.You can have the report run from the cache... ON the reporting Server,
select the report-Properties... You can set the report to run from cache and
choose the cache refresh schedule... The first person who runs the report
after the cache has expired, must wait... Others during the period get fast
response.
If you do not want to wait the first time, you may run a snapshot for the
report on a schedule and have the report rendered from the snapshot...
However The only reports which will be rendered must be snapshotted with the
appropriate report parameters...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Trisha" <trisha@.nospam.nospam> wrote in message
news:CB6AB88B-40D6-4E26-A40C-9F086B171142@.microsoft.com...
> Hi all,
> I have a report that takes about 10 minutes to run for a given date. How
> can
> I cache it some how so that it would run lot faster for the same data
> input
> (date) later on?
> Thanks in advance.|||Wayne,
What if I want to cache the report for several different input parameters.
What if I have several different reports w/several different parameters.
Would all those reports be cached on the server for each of the executed
input parameters? If thats the case, then it would put lots of load on the
server and I might have to look into a different strategy.
Thanks again..
"Wayne Snyder" wrote:
> You can have the report run from the cache... ON the reporting Server,
> select the report-Properties... You can set the report to run from cache and
> choose the cache refresh schedule... The first person who runs the report
> after the cache has expired, must wait... Others during the period get fast
> response.
> If you do not want to wait the first time, you may run a snapshot for the
> report on a schedule and have the report rendered from the snapshot...
> However The only reports which will be rendered must be snapshotted with the
> appropriate report parameters...
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Trisha" <trisha@.nospam.nospam> wrote in message
> news:CB6AB88B-40D6-4E26-A40C-9F086B171142@.microsoft.com...
> > Hi all,
> >
> > I have a report that takes about 10 minutes to run for a given date. How
> > can
> > I cache it some how so that it would run lot faster for the same data
> > input
> > (date) later on?
> >
> > Thanks in advance.
>
>
Report Builder: Date filter, Relative Date
I have a date filter, and I default it to first day this month and last day this month under relative date, when I run it it givis me error:
The Value expression for the report parameter ‘FromDate’ contains an error: [BC30456] 'Date' is not a member of 'Integer'. (rsCompilerErrorInExpression)
Can anyone fix this problem?
But it works for Today or (n)months ago.
Thanks.
Post your expressions and indicate what the data types are for the referenced field(s).|||OK, I narrow down what cause this, my date Fields are standard date type. I have 2 dates From Date and To Date, and I put those in filter with default values:
From Date : first day this month, To Date: last day this month
I also have a Textbox with value: =parameters!FromDate.Value
Because I need to display what is being filter on the output, but that is what cause the error, if I use Today or (n) months ago as default, it works.
|||So are you saying this gives the error?
=parameters!FromDate.Value
I doubt that is causing the problem unless you maybe have a number format string for the textbox?
|||If I remove the Textbox with value: =parameters!FromDate.Value, then it works fine with the From Date : first day this month, To Date: last day this month. But if I add the Textbox back with those value it gives me the above error?
|||And then if you put a new text box on the report and set the Expression to =Parameters!FromDate.Value and leave all other settings for the text box alone, what happens?Wednesday, March 21, 2012
Report Builder Problem
on the reports pages of my reporting services.
If I run
http://servername/reportserver/reportbuilder/reportbuilder.application then
it will open the report builder and I can built reports and save back to my
report server. But if I open the report server http://servername/reports.
The toolbar button is not present.
It is a SQL Server 2005 Standard edition Installation running on Windows
Server 2003 as an application server.
I created a user in Reporting Services and gave them Content Manager rights.
Any help in what I need to change for the toolbar to be visible.
MikeMike,
Make sure that the system group that the user belongs (in the site-wide
security) to has Execute Report Definitions checked.
Mike Read wrote:
> I am having trouble with the Report Builder toolbar button is not showing up
> on the reports pages of my reporting services.
> If I run
> http://servername/reportserver/reportbuilder/reportbuilder.application then
> it will open the report builder and I can built reports and save back to my
> report server. But if I open the report server http://servername/reports.
> The toolbar button is not present.
> It is a SQL Server 2005 Standard edition Installation running on Windows
> Server 2003 as an application server.
> I created a user in Reporting Services and gave them Content Manager rights.
> Any help in what I need to change for the toolbar to be visible.
> Mike
Report Builder Parameter List empty
After building a report in report builder, I've set on of the filters to prompt for user input "in this list". When I run the report I get a drop down list with nothing in it. I can manually type in a value an run the report but I'd like to be able to select the parameter from the list.
I've also tried clicking on (no values selected) and selected all the available values...however this gives me the same results.
I also have the same problem...and have been searching for an answer...I know we fixed this or had a solution for this last year...and it may have something to do with the existing cardinalities in the Roles in the model...
But I'm still looking and trying to find a definite answer....
Report Builder not working - Us Too
Hi, Running RS2005 (was running RS2000 on same system)
When trying to run Report Builder I am getting the following error;
Report Execution Error
The report might not be valid or the server could not process the data.
An attempt has been made to use a rendering extension that is not registered for this report server.
Anyone come across this error before?
Thanks in advance
Scott
anywhere I can go to get an answer to this. Excuse the pun but this renders Report Builder useless
Advaned thanks to anyone who has any idea
Scott
|||We are getting same error on our shop. Have you found resolution yet?
|||nothing from anyone....if you find anything I would appreciate anything you find.
I have searched high and low.
One person on another forum said the following;
'Did you upgrade from RS2000 to RS2005? If so, prior to the upgrade, did you have any custom controls or third party controls you may have bought installed? That error message to me seems to say that the report is trying to show a control for which a dll (control source) does not exist. This would lead me to believe - based on you saying RS2000 worked before - that when you did an upgrade, you did not setup these custom controls. '
Maybe it might help
Scott
|||I spent at lot of time on Friday getting the SelfSSL working on the system. It was set up with the name of the computer, I managed to get it working with ComputerName.domain.com/local etc.
I have just come back to Report builder and it now works!! I am writing this just incase it gives you a clue to how I managed to get it working
Thanks
Scott
Report Builder not working - Us Too
Hi, Running RS2005 (was running RS2000 on same system)
When trying to run Report Builder I am getting the following error;
Report Execution Error
The report might not be valid or the server could not process the data.
An attempt has been made to use a rendering extension that is not registered for this report server.
Anyone come across this error before?
Thanks in advance
Scott
anywhere I can go to get an answer to this. Excuse the pun but this renders Report Builder useless
Advaned thanks to anyone who has any idea
Scott
|||We are getting same error on our shop. Have you found resolution yet?
|||nothing from anyone....if you find anything I would appreciate anything you find.
I have searched high and low.
One person on another forum said the following;
'Did you upgrade from RS2000 to RS2005? If so, prior to the upgrade, did you have any custom controls or third party controls you may have bought installed? That error message to me seems to say that the report is trying to show a control for which a dll (control source) does not exist. This would lead me to believe - based on you saying RS2000 worked before - that when you did an upgrade, you did not setup these custom controls. '
Maybe it might help
Scott
|||I spent at lot of time on Friday getting the SelfSSL working on the system. It was set up with the name of the computer, I managed to get it working with ComputerName.domain.com/local etc.
I have just come back to Report builder and it now works!! I am writing this just incase it gives you a clue to how I managed to get it working
Thanks
Scott
Report Builder not working
Hi, Running RS2005 (was running RS2000 on same system)
When trying to run Report Builder I am getting the following error;
Report Execution Error
The report might not be valid or the server could not process the data.
An attempt has been made to use a rendering extension that is not registered for this report server.
Anyone come across this error before?
Thanks in advance
Scott
anywhere I can go to get an answer to this. Excuse the pun but this renders Report Builder useless
Advaned thanks to anyone who has any idea
Scott
|||We are getting same error on our shop. Have you found resolution yet?
|||nothing from anyone....if you find anything I would appreciate anything you find.
I have searched high and low.
One person on another forum said the following;
'Did you upgrade from RS2000 to RS2005? If so, prior to the upgrade, did you have any custom controls or third party controls you may have bought installed? That error message to me seems to say that the report is trying to show a control for which a dll (control source) does not exist. This would lead me to believe - based on you saying RS2000 worked before - that when you did an upgrade, you did not setup these custom controls. '
Maybe it might help
Scott
|||I spent at lot of time on Friday getting the SelfSSL working on the system. It was set up with the name of the computer, I managed to get it working with ComputerName.domain.com/local etc.
I have just come back to Report builder and it now works!! I am writing this just incase it gives you a clue to how I managed to get it working
Thanks
Scott
Report Builder not working
Hi, Running RS2005 (was running RS2000 on same system)
When trying to run Report Builder I am getting the following error;
Report Execution Error
The report might not be valid or the server could not process the data.
An attempt has been made to use a rendering extension that is not registered for this report server.
Anyone come across this error before?
Thanks in advance
Scott
anywhere I can go to get an answer to this. Excuse the pun but this renders Report Builder useless
Advaned thanks to anyone who has any idea
Scott
|||We are getting same error on our shop. Have you found resolution yet?
|||nothing from anyone....if you find anything I would appreciate anything you find.
I have searched high and low.
One person on another forum said the following;
'Did you upgrade from RS2000 to RS2005? If so, prior to the upgrade, did you have any custom controls or third party controls you may have bought installed? That error message to me seems to say that the report is trying to show a control for which a dll (control source) does not exist. This would lead me to believe - based on you saying RS2000 worked before - that when you did an upgrade, you did not setup these custom controls. '
Maybe it might help
Scott
|||I spent at lot of time on Friday getting the SelfSSL working on the system. It was set up with the name of the computer, I managed to get it working with ComputerName.domain.com/local etc.
I have just come back to Report builder and it now works!! I am writing this just incase it gives you a clue to how I managed to get it working
Thanks
Scott
sqlTuesday, March 20, 2012
Report Builder Help
I have been doing everything in Report Designer....now I just tried report Builder after using a Model I creted to create a report. When I try to run the report, it's prompting me for a username and password. Where and how can I switch this to Windows Authentification? The dataset it's supposedly using already has windows authentification as the method. But the strange thing is, when I click on View Report, it gives me another dataset name called dataset1 saying that I must first supply a username and password...where did this generic dataset name come from? What dataset is this refering to ? it certainly isn't the one I uploaded from my Model Project.
Even when I procede to input a generic username and password, then I get "The type of the data source has not been specified."
I don't want any of this, I just want the windows authentification to do it's job based on what users I have allowed permissions in Report manager to whatever needs to be set!
Your report model should be bound to a data source. That data source usually needs to use stored credentials if it connects to a separate machine, because the credentials provided by the client are only valid for one hop (i.e. from the client to the report server). Is that the problem?|||you are correct, thanks!!|||So how'd ya fix it|||I'm getting the same error message. The credentials are being stored but the reports still won't run? Help..I'm on the clock.
The type of the data source has not been specified.
-
An error has occurred during report processing.
Report Builder Help
I have been doing everything in Report Designer....now I just tried report Builder after using a Model I creted to create a report. When I try to run the report, it's prompting me for a username and password. Where and how can I switch this to Windows Authentification? The dataset it's supposedly using already has windows authentification as the method. But the strange thing is, when I click on View Report, it gives me another dataset name called dataset1 saying that I must first supply a username and password...where did this generic dataset name come from? What dataset is this refering to ? it certainly isn't the one I uploaded from my Model Project.
Even when I procede to input a generic username and password, then I get "The type of the data source has not been specified."
I don't want any of this, I just want the windows authentification to do it's job based on what users I have allowed permissions in Report manager to whatever needs to be set!
Your report model should be bound to a data source. That data source usually needs to use stored credentials if it connects to a separate machine, because the credentials provided by the client are only valid for one hop (i.e. from the client to the report server). Is that the problem?|||you are correct, thanks!!|||So how'd ya fix it|||I'm getting the same error message. The credentials are being stored but the reports still won't run? Help..I'm on the clock.
The type of the data source has not been specified.
-
An error has occurred during report processing.
Report Builder FQDN Issue
Ok this one has me stuffed.
SQL 2005 Server with all the fun stuff aswell.
HOWEVER, when attempting to run the report builder it fails when using a FQDN. (Full Qualified Domain Name)
http:\\servername\reports - No Issues
http:\\ipaddress\reports - No Issues
http:\\servername.domain.com.au\reports - Can Access, reports run fine but fails to run the report builder.
The error deatails are as follows:
ERROR DETAILS
Following errors were detected during this operation.
* [3/08/2006 11:21:37 AM] System.Deployment.Application.DeploymentDownloadException (Unknown subtype)
- Downloading http://SQLSVR.nat.company.com.au/ReportServer/ReportBuilder/ReportBuilder.application did not succeed.
- Source: System.Deployment
- Stack trace:
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
at System.Deployment.Application.SystemNetDownloader.DownloadAllFiles()
at System.Deployment.Application.FileDownloader.Download(SubscriptionState subState)
at System.Deployment.Application.DownloadManager.DownloadManifestAsRawFile(Uri& sourceUri, String targetPath, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)
at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestDirectBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)
at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options)
at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, Boolean isShortcut)
at System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object state)
Inner Exception
System.Net.WebException
- The operation has timed out
- Source: System
- Stack trace:
at System.Net.HttpWebRequest.GetResponse()
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
Further to this, i can not open the report server from the Management Studio on the local machine.
Here is the error:
===================================
Cannot connect to SQLSVR\SQL2005.
===================================
The operation has timed out (System.Web.Services)
Program Location:
at System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebRequest request)
at System.Web.Services.Protocols.HttpWebClientProtocol.GetWebResponse(WebRequest request)
at Microsoft.SqlServer.Management.UI.RSClient.RSClientConnection.GetWebResponse(WebRequest request)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at Microsoft.SqlServer.ReportingServices2005.ReportingService2005.ListSecureMethods()
at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
at Microsoft.SqlServer.Management.UI.RSClient.RSClientConnection.CreateConnection(String connectionString)
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.CreateConnectionObject()
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.RSTypeImpl.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.RSType.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()
Please Help.
Any Ideas on where to go would be very much appreciated.
Thanks in advance
Report Builder error with Cubes
I am receiving the following error when I run the report builder query. I am
able to successfully select the dimensions and measures that I am interested
in but when I run the report I get the error message.
The 'PerspectiveID' custom property for the 'query' perspective is either
not set or is not set to the string data type.
--
Semantic query execution failed.
--
Query execution failed for data set 'dataSet'.
--
An error has occurred during report processing.
I am testing this against both Adventureworks standard and enterprise cubes.
Additionally I saw this post in another forum
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=368962&SiteID=1
that seemed related but I am using reporting services in sharepoint
integrated mode so I am having a hard time trying to troubleshoot this.
Thanks for your help!On Dec 14, 2:14 am, Kodi <K...@.discussions.microsoft.com> wrote:
Hi
Whats your query ? Seems like you are using parameters which have not
been set.
Cheers
Shai
> Hi,
> I am receiving the following error when I run the report builder query. I am
> able to successfully select the dimensions and measures that I am interested
> in but when I run the report I get the error message.
> The 'PerspectiveID' custom property for the 'query' perspective is either
> not set or is not set to the string data type.
> --
> Semantic query execution failed.
> --
> Query execution failed for data set 'dataSet'.
> --
> An error has occurred during report processing.
> I am testing this against both Adventureworks standard and enterprise cubes.
> Additionally I saw this post in another forumhttp://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=368962&SiteID=1
> that seemed related but I am using reporting services in sharepoint
> integrated mode so I am having a hard time trying to troubleshoot this.
> Thanks for your help!|||Hi,
I work with kodi and he posted this for me while my subscription was in
progress.
When using Cubes with report builder the report model is generated
automatically by clicking generate a model from the data source (RDS) working
in Sharepoint in my case, Then you load that report model which opens up the
report builder and it is drag and drop from there. There are no parameter in
report builder that I know of, it is all add-hoc and you would use filters to
act like parameters.
Larry
"shaikat.das@.gmail.com" wrote:
> On Dec 14, 2:14 am, Kodi <K...@.discussions.microsoft.com> wrote:
> Hi
> Whats your query ? Seems like you are using parameters which have not
> been set.
> Cheers
> Shai
> > Hi,
> >
> > I am receiving the following error when I run the report builder query. I am
> > able to successfully select the dimensions and measures that I am interested
> > in but when I run the report I get the error message.
> >
> > The 'PerspectiveID' custom property for the 'query' perspective is either
> > not set or is not set to the string data type.
> > --
> > Semantic query execution failed.
> > --
> > Query execution failed for data set 'dataSet'.
> > --
> > An error has occurred during report processing.
> >
> > I am testing this against both Adventureworks standard and enterprise cubes.
> > Additionally I saw this post in another forumhttp://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=368962&SiteID=1
> > that seemed related but I am using reporting services in sharepoint
> > integrated mode so I am having a hard time trying to troubleshoot this.
> >
> > Thanks for your help!
>
Report Builder Error - Novice please suggest !!
Basically I have three relational tables from SQL database. one is the Master say A and other two are related tables say B and C. I joined with id1 to B from A and id2 to C from A.
A(id1) -> B(id1)
A(id2) -> C(id2)
1.Why is it asking me the enter filter?
2.Also, when I created a report based on fields from A,B and C I tried to do the click through.
I can able to click through to table B by clicking on the fields of B but similarly I am unable to do for the fields from the C.
3.Can I create a report model based on tables from different databases rather than from single database.?
I am novice to the Reporting Services arena. Your suggestions/help is greatly appreciated.
Thanks in advance.
Prakash
1. Report Builder requires you to specify a filter if Entity.InstanceSelection=MandatoryFilter in the report model. The model generation wizard will set this value if the underlying table has a very large number of rows in it. If you don't like the setting, you can change it in Model Designer.
2. Only certain fields have EnableDrillthrough=True by default. I believe the model generation wizard sets this only for highly unique fields and/or fields that are part of the primary key in the underyling table. If you want Report Builder to create Clickthrough links for more fields, you can change this property in Model Designer.
3. The DSV that describes the database over which the report model is built can only have one datasource. However, you can use linked servers to access data on other servers.
Hope that helps!
|||Thanks for your response.
Please tell me where I can find these properties. I am unable to find them(I guess I am dumb). Your help is greatly appreciated.
Thanks !!