Hi,
I had trouble getting reporting services going. I would
get the configuration error. If I restart the IIS Admin
the reporting services works fine but my other aspx pages
get the same configuration error. Something about
Microsoft.Office.Interop.Owc. If I restart IIS Admin
again the other aspx pages work but reporting services
does not.
What is going on here?
Can't Reporting Services and other .NET pages co-exist?
Please help.
-Marciaapplications can co-exist, but not in the same virtual folder.
maybe you can try to create a new application pool dedicated to reporting
services. (this is required when installing reporting services and
sharepoint on the same server)
I've already installed RS on some computer and I never get any error.
What is the content of your web.config files? (under the RS folders and un
der parent folder)
"Marcia Gorby" <anonymous@.discussions.microsoft.com> a écrit dans le message
de news:5ffc01c48174$eb0e7840$a401280a@.phx.gbl...
> Hi,
> I had trouble getting reporting services going. I would
> get the configuration error. If I restart the IIS Admin
> the reporting services works fine but my other aspx pages
> get the same configuration error. Something about
> Microsoft.Office.Interop.Owc. If I restart IIS Admin
> again the other aspx pages work but reporting services
> does not.
> What is going on here?
> Can't Reporting Services and other .NET pages co-exist?
> Please help.
> -Marcia
Showing posts with label trouble. Show all posts
Showing posts with label trouble. Show all posts
Friday, March 30, 2012
Wednesday, March 21, 2012
Reporting Services - The underlying connection was closed: The remote name could not be re
Hi, Help, I am having trouble getting SQL Server 2000 Reporting
Services to work on my laptop computer. I have gotten it to work in
office/development environments several times, so it's not just
beginner cluelessness.
Installing onto Windows XP professional, 384 MB RAM, SQL Server 2000
Developer's Edition with SP 3a, ASP.NET 1.1, VS.NET 2003, not connected
to any network or even internet/wireless.
Installation ran fine, no error messages. Designer works fine, I can
select queries from my local NorthWind connecting as "sa". (I know
about not using sa, but this is for simplicity's sake)
Deploy seems to work fine. However, when I hit F5 (Play) or open IE
and navigate to localhost/Reports/Pages/Folder.aspx, I see this...
(X) Error
---
The underlying connection was closed: The remote name could not be
resolved.
Home
--
What can I do to fix this?
Thanks.
Jason
ps - localhost/reportserver?... works just fine. But the Report
Manager doesn't come up.First thing I would do is check my proxy settings in your browser. Ensure
you have selected to bypass the proxy for local request.
Next I would ensure that the machine name of your comptuer is the same as it
was when you intalled report server (the setup uses that value when forming
the URL).
Next, check that in the file rswebapplication.config under the report
manager install folder, you should find the entry reportserverurl. Ensure
the URL references your actual machinename.
If that fails, try to remove the reportserverurl element and replace it with
a reportservervirtualdirectory element and set the value to the path
"/reportserver". This should mean the report manager will look for the
report server on whatever path you access it on (e..g if you type
http://localhost/reports in the address bar, report manager will look at
http://localhost/reportserver to find the URL.
-Lukasz
--
This posting is provided "AS IS" with no warranties, and confers no rights.
<jason_wisdom@.yahoo.com> wrote in message
news:1108157981.898349.110400@.l41g2000cwc.googlegroups.com...
> Hi, Help, I am having trouble getting SQL Server 2000 Reporting
> Services to work on my laptop computer. I have gotten it to work in
> office/development environments several times, so it's not just
> beginner cluelessness.
> Installing onto Windows XP professional, 384 MB RAM, SQL Server 2000
> Developer's Edition with SP 3a, ASP.NET 1.1, VS.NET 2003, not connected
> to any network or even internet/wireless.
> Installation ran fine, no error messages. Designer works fine, I can
> select queries from my local NorthWind connecting as "sa". (I know
> about not using sa, but this is for simplicity's sake)
> Deploy seems to work fine. However, when I hit F5 (Play) or open IE
> and navigate to localhost/Reports/Pages/Folder.aspx, I see this...
>
> (X) Error
> ---
> The underlying connection was closed: The remote name could not be
> resolved.
> Home
> --
>
> What can I do to fix this?
> Thanks.
> Jason
> ps - localhost/reportserver?... works just fine. But the Report
> Manager doesn't come up.
>
Services to work on my laptop computer. I have gotten it to work in
office/development environments several times, so it's not just
beginner cluelessness.
Installing onto Windows XP professional, 384 MB RAM, SQL Server 2000
Developer's Edition with SP 3a, ASP.NET 1.1, VS.NET 2003, not connected
to any network or even internet/wireless.
Installation ran fine, no error messages. Designer works fine, I can
select queries from my local NorthWind connecting as "sa". (I know
about not using sa, but this is for simplicity's sake)
Deploy seems to work fine. However, when I hit F5 (Play) or open IE
and navigate to localhost/Reports/Pages/Folder.aspx, I see this...
(X) Error
---
The underlying connection was closed: The remote name could not be
resolved.
Home
--
What can I do to fix this?
Thanks.
Jason
ps - localhost/reportserver?... works just fine. But the Report
Manager doesn't come up.First thing I would do is check my proxy settings in your browser. Ensure
you have selected to bypass the proxy for local request.
Next I would ensure that the machine name of your comptuer is the same as it
was when you intalled report server (the setup uses that value when forming
the URL).
Next, check that in the file rswebapplication.config under the report
manager install folder, you should find the entry reportserverurl. Ensure
the URL references your actual machinename.
If that fails, try to remove the reportserverurl element and replace it with
a reportservervirtualdirectory element and set the value to the path
"/reportserver". This should mean the report manager will look for the
report server on whatever path you access it on (e..g if you type
http://localhost/reports in the address bar, report manager will look at
http://localhost/reportserver to find the URL.
-Lukasz
--
This posting is provided "AS IS" with no warranties, and confers no rights.
<jason_wisdom@.yahoo.com> wrote in message
news:1108157981.898349.110400@.l41g2000cwc.googlegroups.com...
> Hi, Help, I am having trouble getting SQL Server 2000 Reporting
> Services to work on my laptop computer. I have gotten it to work in
> office/development environments several times, so it's not just
> beginner cluelessness.
> Installing onto Windows XP professional, 384 MB RAM, SQL Server 2000
> Developer's Edition with SP 3a, ASP.NET 1.1, VS.NET 2003, not connected
> to any network or even internet/wireless.
> Installation ran fine, no error messages. Designer works fine, I can
> select queries from my local NorthWind connecting as "sa". (I know
> about not using sa, but this is for simplicity's sake)
> Deploy seems to work fine. However, when I hit F5 (Play) or open IE
> and navigate to localhost/Reports/Pages/Folder.aspx, I see this...
>
> (X) Error
> ---
> The underlying connection was closed: The remote name could not be
> resolved.
> Home
> --
>
> What can I do to fix this?
> Thanks.
> Jason
> ps - localhost/reportserver?... works just fine. But the Report
> Manager doesn't come up.
>
Reporting Services - Overload and OutofMemoryException - Workaround?
We're having a good bit of trouble with a deployed report overloading
the server during times of heavy use. The report renders directly
from an external app to Excel, running the report by way of URL. I
haven't found any tuning that helps us - we have about 1200 clients
who try to run the report in a 2-hour span. Sometimes it seems like
they're all hitting it in the same 10 minutes. I can see the activity
in the performance monitor. Once active report requests reach 40 or
so, we usually get an OutOfMemory exception and RS recycles. It picks
back up, but the users who were waiting all get errors.
I couldn't find a metering option to force requests into a 'holding'
queue if active requests reach a threshold, so I'm trying to build a
workaround. I'm posting the basics of it here, in case it might help
anyone else.
' This code will go into the page that redirects users
' to the report. The page will either prompt the user
' to refresh or will have a refresh META tag
Dim rs As New sqlrpts.ReportingService
rs.Credentials = New System.Net.NetworkCredential _
("userid", "password", "domain")
' or - System.Net.CredentialCache.DefaultCredentials()
Dim jobs As sqlrpts.Job
Dim intx As Int16 = 0
For Each jobs In rs.ListJobs
intx = intx + 1
Next
' If intx is above the threshold we'll set (probably 25-30),
' we'll display a 'please wait' message. Otherwise, we'll
' redirect to the report URL
If anyone knows a better way around this, please reply on this thread
or email me.
Thanks!
Tim ShayHi Tim,
Just need to check with you quickly, which counter are you using to
determine the OutOfMemory exception and RS recycle?
Also, have you tried using ACT to test the report URL and see how many
RPS it can process? Coz we're having similar problem and is wondering
why RS cannot process concurrent user requests for the web application
we're developing.
Appreciate your input, thanks!
CCC
tshay@.foodlion.com (TShay) wrote in message news:<1fe4fd2c.0409100828.795a3ae3@.posting.google.com>...
> We're having a good bit of trouble with a deployed report overloading
> the server during times of heavy use. The report renders directly
> from an external app to Excel, running the report by way of URL. I
> haven't found any tuning that helps us - we have about 1200 clients
> who try to run the report in a 2-hour span. Sometimes it seems like
> they're all hitting it in the same 10 minutes. I can see the activity
> in the performance monitor. Once active report requests reach 40 or
> so, we usually get an OutOfMemory exception and RS recycles. It picks
> back up, but the users who were waiting all get errors.
> I couldn't find a metering option to force requests into a 'holding'
> queue if active requests reach a threshold, so I'm trying to build a
> workaround. I'm posting the basics of it here, in case it might help
> anyone else.
> ' This code will go into the page that redirects users
> ' to the report. The page will either prompt the user
> ' to refresh or will have a refresh META tag
> Dim rs As New sqlrpts.ReportingService
> rs.Credentials = New System.Net.NetworkCredential _
> ("userid", "password", "domain")
> ' or - System.Net.CredentialCache.DefaultCredentials()
> Dim jobs As sqlrpts.Job
> Dim intx As Int16 = 0
> For Each jobs In rs.ListJobs
> intx = intx + 1
> Next
> ' If intx is above the threshold we'll set (probably 25-30),
> ' we'll display a 'please wait' message. Otherwise, we'll
> ' redirect to the report URL
> If anyone knows a better way around this, please reply on this thread
> or email me.
> Thanks!
> Tim Shay
the server during times of heavy use. The report renders directly
from an external app to Excel, running the report by way of URL. I
haven't found any tuning that helps us - we have about 1200 clients
who try to run the report in a 2-hour span. Sometimes it seems like
they're all hitting it in the same 10 minutes. I can see the activity
in the performance monitor. Once active report requests reach 40 or
so, we usually get an OutOfMemory exception and RS recycles. It picks
back up, but the users who were waiting all get errors.
I couldn't find a metering option to force requests into a 'holding'
queue if active requests reach a threshold, so I'm trying to build a
workaround. I'm posting the basics of it here, in case it might help
anyone else.
' This code will go into the page that redirects users
' to the report. The page will either prompt the user
' to refresh or will have a refresh META tag
Dim rs As New sqlrpts.ReportingService
rs.Credentials = New System.Net.NetworkCredential _
("userid", "password", "domain")
' or - System.Net.CredentialCache.DefaultCredentials()
Dim jobs As sqlrpts.Job
Dim intx As Int16 = 0
For Each jobs In rs.ListJobs
intx = intx + 1
Next
' If intx is above the threshold we'll set (probably 25-30),
' we'll display a 'please wait' message. Otherwise, we'll
' redirect to the report URL
If anyone knows a better way around this, please reply on this thread
or email me.
Thanks!
Tim ShayHi Tim,
Just need to check with you quickly, which counter are you using to
determine the OutOfMemory exception and RS recycle?
Also, have you tried using ACT to test the report URL and see how many
RPS it can process? Coz we're having similar problem and is wondering
why RS cannot process concurrent user requests for the web application
we're developing.
Appreciate your input, thanks!
CCC
tshay@.foodlion.com (TShay) wrote in message news:<1fe4fd2c.0409100828.795a3ae3@.posting.google.com>...
> We're having a good bit of trouble with a deployed report overloading
> the server during times of heavy use. The report renders directly
> from an external app to Excel, running the report by way of URL. I
> haven't found any tuning that helps us - we have about 1200 clients
> who try to run the report in a 2-hour span. Sometimes it seems like
> they're all hitting it in the same 10 minutes. I can see the activity
> in the performance monitor. Once active report requests reach 40 or
> so, we usually get an OutOfMemory exception and RS recycles. It picks
> back up, but the users who were waiting all get errors.
> I couldn't find a metering option to force requests into a 'holding'
> queue if active requests reach a threshold, so I'm trying to build a
> workaround. I'm posting the basics of it here, in case it might help
> anyone else.
> ' This code will go into the page that redirects users
> ' to the report. The page will either prompt the user
> ' to refresh or will have a refresh META tag
> Dim rs As New sqlrpts.ReportingService
> rs.Credentials = New System.Net.NetworkCredential _
> ("userid", "password", "domain")
> ' or - System.Net.CredentialCache.DefaultCredentials()
> Dim jobs As sqlrpts.Job
> Dim intx As Int16 = 0
> For Each jobs In rs.ListJobs
> intx = intx + 1
> Next
> ' If intx is above the threshold we'll set (probably 25-30),
> ' we'll display a 'please wait' message. Otherwise, we'll
> ' redirect to the report URL
> If anyone knows a better way around this, please reply on this thread
> or email me.
> Thanks!
> Tim Shay
Tuesday, March 20, 2012
Reporting Services
Anyone running Reporting Services?
I need to get it deployed and but I'm having trouble getting my brain around how it gets installed. We have a Production SQL Server instance (2000 Standard Edition) running our Main APPS and then a Sharepoint Instance on another box. Today I'm installing yet another Instance on the Shareport Database Server for CRM -
I am going to want to report against Sharepoint, CRM and Probably Exchange.. Where would Reporting Services Server get installed? On one of my SQL Servers? on a Seperate Admin Server? on my Web Server? Do I need a seperate Instance for my Reporting Services Backend Database?
Also, I have Reporting Services 2000 Developer Edition on our MSDN Subscription CDs.. Is this what I use in my Production Environment and if not, where can I download Reporting Services from? I can't find it on the MS Site.. Thanks for your help!I have set this up a few times. Total pain in the ass. You are going to need Standard or Enterprise. Standard only works on the same machine SQL Server is installed. Enterpise you can install on a web server seperate from your db server but it requires a seperate sql server liscense.
Please read the installation section of the reporting services books online as well as the read me file and the Server Deployment Checklist in the Reporting Services books Online. And there are some seperate steps when runing sharepoint and RS on the same box. You can expect some errors. some of which you will not be able to find in Google or Google groups.
have fun.|||Thank you Sean. I'm trying to see where I can get the Media from now.. We have SQL Server Standard (2000) on all of our SQL Servers... Sounds I will need to Install Reporting Services Standard on each Database Server??? what about reporting against Exchange?
I need to get it deployed and but I'm having trouble getting my brain around how it gets installed. We have a Production SQL Server instance (2000 Standard Edition) running our Main APPS and then a Sharepoint Instance on another box. Today I'm installing yet another Instance on the Shareport Database Server for CRM -
I am going to want to report against Sharepoint, CRM and Probably Exchange.. Where would Reporting Services Server get installed? On one of my SQL Servers? on a Seperate Admin Server? on my Web Server? Do I need a seperate Instance for my Reporting Services Backend Database?
Also, I have Reporting Services 2000 Developer Edition on our MSDN Subscription CDs.. Is this what I use in my Production Environment and if not, where can I download Reporting Services from? I can't find it on the MS Site.. Thanks for your help!I have set this up a few times. Total pain in the ass. You are going to need Standard or Enterprise. Standard only works on the same machine SQL Server is installed. Enterpise you can install on a web server seperate from your db server but it requires a seperate sql server liscense.
Please read the installation section of the reporting services books online as well as the read me file and the Server Deployment Checklist in the Reporting Services books Online. And there are some seperate steps when runing sharepoint and RS on the same box. You can expect some errors. some of which you will not be able to find in Google or Google groups.
have fun.|||Thank you Sean. I'm trying to see where I can get the Media from now.. We have SQL Server Standard (2000) on all of our SQL Servers... Sounds I will need to Install Reporting Services Standard on each Database Server??? what about reporting against Exchange?
Tuesday, February 21, 2012
Reporting on blank fields in Crystal
Hi,
having a bit of trouble trying to get my Crystal report to give me a count of the blank fields in a database field...any ideas?What do you mean by 'blank'? Empty or NULL?|||use a formula
if isnull(field) then
1
else
0|||I suppose the field will be null, I will try the formula to test for this. Thanks.
having a bit of trouble trying to get my Crystal report to give me a count of the blank fields in a database field...any ideas?What do you mean by 'blank'? Empty or NULL?|||use a formula
if isnull(field) then
1
else
0|||I suppose the field will be null, I will try the formula to test for this. Thanks.
Subscribe to:
Posts (Atom)