When attempting to export to Excel from report manager we get the error
"Internet Explorer cannot download Format=Ecels from reports.server"
Internet Explorer was not able to open this Internet site. The requested
site is either unavailable or cannot be found. Please try again later."
This only happens when the person accessing reports manager is not a local
administrator. Local administrator privileges make the problem go away.
What is report manager trying to access that I need to give my user access
to? I cannot make the user a local admin.The problem does not just occur if exporting to excel. It's all file types.
Any file type we try to export to from report manager kicks back essentially
the same error we were getting when trying to export to excel. Oddly enough,
the development server which uses 2k3 server doesn't do this. The production
server that is running Server 2K does.
"Valleri_Collins" wrote:
> When attempting to export to Excel from report manager we get the error
> "Internet Explorer cannot download Format=Excel from reports.server"
> Internet Explorer was not able to open this Internet site. The requested
> site is either unavailable or cannot be found. Please try again later."
> This only happens when the person accessing reports manager is not a local
> administrator. Local administrator privileges make the problem go away.
> What is report manager trying to access that I need to give my user access
> to? I cannot make the user a local admin.
Showing posts with label reports. Show all posts
Showing posts with label reports. Show all posts
Thursday, March 29, 2012
Tuesday, March 27, 2012
Cannot edit RS reports...!
I'm new at using RS, so please bear with me...
I need to make small changes to existing reports. I'm able to execute
the reports and view the report list through the Report Manager, but I
don't ge the "Edit" options for the reports.
What security options must I have to be able to edit the reports?
Also, are the RDLs stored in the Catalog table? I ask because I can't
find an RDL on the report server to save my life...
Thanks!The edit button allows saving the RDL out to a file. Then you use the
designer to modify it and then deploy it back to the server. You should
install the designer on your local machine.
Are you getting prompted for a place to save the file when you click on the
edit button. If not then it is a security issue and you need to be added to
the appropriate role in Reporting Services.
RS stores the RDL in the database but you should not go directly against the
database. I haven't bothered to look but I doubt if it is in a readable
format anyway.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Kerc" <jkercado@.gmail.com> wrote in message
news:1128533548.040646.285220@.g44g2000cwa.googlegroups.com...
> I'm new at using RS, so please bear with me...
> I need to make small changes to existing reports. I'm able to execute
> the reports and view the report list through the Report Manager, but I
> don't ge the "Edit" options for the reports.
> What security options must I have to be able to edit the reports?
> Also, are the RDLs stored in the Catalog table? I ask because I can't
> find an RDL on the report server to save my life...
> Thanks!
>|||I'm not getting the "Edit" button...I just get the "General" tab with
the information...That's why I asked about security settings, something
is preventing me from getting the report source.|||When you click on properties you say you see the General tab. There should
be a section on that page that says Report Definition and has a link that
says Edit.
You have to click on the report (i.e. one by one) and then do properties for
that repor. You cannot do a whole directory.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Kerc" <jkercado@.gmail.com> wrote in message
news:1128538895.020947.111580@.f14g2000cwb.googlegroups.com...
> I'm not getting the "Edit" button...I just get the "General" tab with
> the information...That's why I asked about security settings, something
> is preventing me from getting the report source.
>
I need to make small changes to existing reports. I'm able to execute
the reports and view the report list through the Report Manager, but I
don't ge the "Edit" options for the reports.
What security options must I have to be able to edit the reports?
Also, are the RDLs stored in the Catalog table? I ask because I can't
find an RDL on the report server to save my life...
Thanks!The edit button allows saving the RDL out to a file. Then you use the
designer to modify it and then deploy it back to the server. You should
install the designer on your local machine.
Are you getting prompted for a place to save the file when you click on the
edit button. If not then it is a security issue and you need to be added to
the appropriate role in Reporting Services.
RS stores the RDL in the database but you should not go directly against the
database. I haven't bothered to look but I doubt if it is in a readable
format anyway.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Kerc" <jkercado@.gmail.com> wrote in message
news:1128533548.040646.285220@.g44g2000cwa.googlegroups.com...
> I'm new at using RS, so please bear with me...
> I need to make small changes to existing reports. I'm able to execute
> the reports and view the report list through the Report Manager, but I
> don't ge the "Edit" options for the reports.
> What security options must I have to be able to edit the reports?
> Also, are the RDLs stored in the Catalog table? I ask because I can't
> find an RDL on the report server to save my life...
> Thanks!
>|||I'm not getting the "Edit" button...I just get the "General" tab with
the information...That's why I asked about security settings, something
is preventing me from getting the report source.|||When you click on properties you say you see the General tab. There should
be a section on that page that says Report Definition and has a link that
says Edit.
You have to click on the report (i.e. one by one) and then do properties for
that repor. You cannot do a whole directory.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Kerc" <jkercado@.gmail.com> wrote in message
news:1128538895.020947.111580@.f14g2000cwb.googlegroups.com...
> I'm not getting the "Edit" button...I just get the "General" tab with
> the information...That's why I asked about security settings, something
> is preventing me from getting the report source.
>
Cannot edit RS reports...!
You need the Manage reports task. You can get this on a default report server installation by having the Content Manager role.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
--Original Message--
From: Kerc
Posted At: Wednesday, October 05, 2005 10:32 AM
Posted To: microsoft.public.sqlserver.reportingsvcs
Conversation: Cannot edit RS reports...!!!
Subject: Cannot edit RS reports...!!!
I'm new at using RS, so please bear with me...
I need to make small changes to existing reports. I'm able to execute
the reports and view the report list through the Report Manager, but I
don't ge the "Edit" options for the reports.
What security options must I have to be able to edit the reports?
Also, are the RDLs stored in the Catalog table? I ask because I can't
find an RDL on the report server to save my life...
Thanks!I just verified and I do have the "Content Manager" role. So far my
experience with RS has been pretty frustrating...
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
--Original Message--
From: Kerc
Posted At: Wednesday, October 05, 2005 10:32 AM
Posted To: microsoft.public.sqlserver.reportingsvcs
Conversation: Cannot edit RS reports...!!!
Subject: Cannot edit RS reports...!!!
I'm new at using RS, so please bear with me...
I need to make small changes to existing reports. I'm able to execute
the reports and view the report list through the Report Manager, but I
don't ge the "Edit" options for the reports.
What security options must I have to be able to edit the reports?
Also, are the RDLs stored in the Catalog table? I ask because I can't
find an RDL on the report server to save my life...
Thanks!I just verified and I do have the "Content Manager" role. So far my
experience with RS has been pretty frustrating...
Sunday, March 25, 2012
Cannot Deploy Reports Using Custom Assembly - "Access is Denied"
We have a custom assembly that worked fine with SSRS 2000. Now that we have upgraded to SQL 2005 we get an "Access is denied" error when attempting to deploy reports that reference this assembly. I could swear that when we first attempted it it worked. We decided to make a minor change to the assembly code and that's when the problem started, even though I've since reverted back to the original code to make certain that the minor change wasn't the issue. The assembly is in the proper folder - C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer\bin - and the reports are referencing the current version. I've searched high and low on the web for an answer but have found nothing even remotely helpful. All this code does is return a string...it's not doing anything that should require any additional security; and even then I doubt if there would be a problem when deploying.
The full text of the error is:
Error while loading code module: ‘Reporting, Version=1.0.2778.12272, Culture=neutral, PublicKeyToken=null’. Details: Could not load file or assembly 'Reporting, Version=1.0.2778.12272, Culture=neutral, PublicKeyToken=null' or one of its dependencies. Access is denied.
Any ideas? Anyone? I'm at my wit's end on this!
Thanks,
Mike
Please read this.
http://www.codeproject.com/useritems/Reporting_Services.asp
Priyank
|||Have you deployed your assemby dll to the GAC or it is in the File System.If you have it in the files system be sure it is also in the folder. Install path / ReportingServices/ReportServer/bin and / ReportingServices/ReportManager/bin|||
Thanks, but I've tried this and it made no difference.
The code was originally developed in VS2003 and deployed to a SQL 2000 server, just as in the linked article. All we did was copy the dll to the appropriate folder on the server and it worked. The difference now is that we're using VS2005 and SQL 2005. The only other difference is that formerly SRSS and our SQL db's all resided on the same server and now they are on separate servers. I've copied the dll only to the SRSS server. Should it also be on the db server?
|||
gatharia wrote:
Have you deployed your assemby dll to the GAC or it is in the File System.
If you have it in the files system be sure it is also in the folder. Install path / ReportingServices/ReportServer/bin and / ReportingServices/ReportManager/bin
It's in the file system and resides in the appropriate folder. It's exactly as it was when we were using VS2003 and SQL 2000. I can't help but think it's server related, because the only difference (other than the aforementioned versions) is that we've migrated to new servers and whereas we formerly had only the one server with SRSS and our db's, they now reside on different servers.
|||I do not think you should copy to the db server. When moving your code to VS 2005 did you create a different strong name? If so then your public token may be different and this may cause issues. If the public token is different or same be sure that you have added a strong name blob to the following files. Installpath/ReportServer/rssvpolicy.config and Installpath/reportmanager/rsmgrpolicy.config. To do so bakup your config files, open the files in your editor and locate the last entry of </CodeGroup></CodeGroup>
Above this add a code group above the above lines like
<CodeGroup
class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust"
Name="CustomAssembly"
Description="This code group grants My cusstom Assembly permissions. ">
<IMembershipCondition
class="StrongNameMembershipCondition"
version="1"
PublicKeyBlob="0x0024000004800000940000000602000000240000525341310004000001000100AFEAEE95A2C6AE85CCAD6B8FA54E79514BB1690FD4803F93B0033B101A90107873E90511CF5A89BF624961DDAC82B1D10E89F991403B98F18C2CFCF87B8C09CCFA4AF20C9B3DF1DD6DBCA4A3AE2854030DDCE3313B1B9610F922B9881C9ABE05EC2AE451F1C20D42FE753F05E278EC964C5B9580E04090507C2A8B336BE3C7B5"
/>
</CodeGroup>
You MUST replace the PublicKeyBlob with the blob for your assembly. To get this blob use the command
SECUTIL.EXE -s assemblyname.dll > blob.txt
This send the blob to the file blob.txt
Add your assembly to the GAC instead of file system. Stop the RS process and restart.
Cannot Deploy Reports to Report Server
I am in desperate need of help.
We have just set up SQL Server (2005, SP2) with RS on a Windows 2003 server.
None of us have ever deployed RS before. To make matters worse, all of our
network operations have been outsourced, so we do not have control of the
machine and the people who do don't know what they're doing either.
I can browse to <servername>\reports and to
<servername>\reportexecution2005.asmx. However when I try to browse to
<servername>\reportserver or try to deploy reports from VS2003, I get the
following error: The permissions granted to user 'ADSDOMAIN\ERichardson' are
insufficient for performing this operation. (rsAccessDenied) .
a)How should the permissions be set up so that I can deploy and manage the
reports?
b)How should the permissions be set up so that certain users can access the
Report Manager?
c)How should the permission be set up so that the majority of users can
access reports through links in the VS.Net application?
I know this is a lot of material to cover at once. We've got the blind
leading the blind here. Maybe we could start with how to grant me access to
deploy and manage the reports and then take it from there.
I would appreciate any help I can get. These outsourced people aren't going
to make the effort to figure this out. We're going to have to spoonfeed
them:-)
LizOn Sep 10, 12:40 pm, Liz <L...@.discussions.microsoft.com> wrote:
> I am in desperate need of help.
> We have just set up SQL Server (2005, SP2) with RS on a Windows 2003 server.
> None of us have ever deployed RS before. To make matters worse, all of our
> network operations have been outsourced, so we do not have control of the
> machine and the people who do don't know what they're doing either.
> I can browse to <servername>\reports and to
> <servername>\reportexecution2005.asmx. However when I try to browse to
> <servername>\reportserver or try to deploy reports from VS2003, I get the
> following error: The permissions granted to user 'ADSDOMAIN\ERichardson' are
> insufficient for performing this operation. (rsAccessDenied) .
> a)How should the permissions be set up so that I can deploy and manage the
> reports?
> b)How should the permissions be set up so that certain users can access the
> Report Manager?
> c)How should the permission be set up so that the majority of users can
> access reports through links in the VS.Net application?
> I know this is a lot of material to cover at once. We've got the blind
> leading the blind here. Maybe we could start with how to grant me access to
> deploy and manage the reports and then take it from there.
> I would appreciate any help I can get. These outsourced people aren't going
> to make the effort to figure this out. We're going to have to spoonfeed
> them:-)
> Liz
For Item (a), you may want to check the security on the Reports and
ReportServer Virtual Directories. You may want to change the Directory
Security (via right-clicking the virtual directories in IIS ->
Properties -> Directory Security tab -> Edit... button -> select
'Anonymous access' and 'Integrated Windows Authentication').
For Item (b), you set the user permissions in the Report Manager in
the second tab on the main page (I don't remember the name of it). You
can allow Browse, Publish, etc for various users that you add (note
that the standard windows format is: DOMAIN\User).
For Item (c), Browse permissions should be sufficient for most users
(refer to Item (b) response).
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant
We have just set up SQL Server (2005, SP2) with RS on a Windows 2003 server.
None of us have ever deployed RS before. To make matters worse, all of our
network operations have been outsourced, so we do not have control of the
machine and the people who do don't know what they're doing either.
I can browse to <servername>\reports and to
<servername>\reportexecution2005.asmx. However when I try to browse to
<servername>\reportserver or try to deploy reports from VS2003, I get the
following error: The permissions granted to user 'ADSDOMAIN\ERichardson' are
insufficient for performing this operation. (rsAccessDenied) .
a)How should the permissions be set up so that I can deploy and manage the
reports?
b)How should the permissions be set up so that certain users can access the
Report Manager?
c)How should the permission be set up so that the majority of users can
access reports through links in the VS.Net application?
I know this is a lot of material to cover at once. We've got the blind
leading the blind here. Maybe we could start with how to grant me access to
deploy and manage the reports and then take it from there.
I would appreciate any help I can get. These outsourced people aren't going
to make the effort to figure this out. We're going to have to spoonfeed
them:-)
LizOn Sep 10, 12:40 pm, Liz <L...@.discussions.microsoft.com> wrote:
> I am in desperate need of help.
> We have just set up SQL Server (2005, SP2) with RS on a Windows 2003 server.
> None of us have ever deployed RS before. To make matters worse, all of our
> network operations have been outsourced, so we do not have control of the
> machine and the people who do don't know what they're doing either.
> I can browse to <servername>\reports and to
> <servername>\reportexecution2005.asmx. However when I try to browse to
> <servername>\reportserver or try to deploy reports from VS2003, I get the
> following error: The permissions granted to user 'ADSDOMAIN\ERichardson' are
> insufficient for performing this operation. (rsAccessDenied) .
> a)How should the permissions be set up so that I can deploy and manage the
> reports?
> b)How should the permissions be set up so that certain users can access the
> Report Manager?
> c)How should the permission be set up so that the majority of users can
> access reports through links in the VS.Net application?
> I know this is a lot of material to cover at once. We've got the blind
> leading the blind here. Maybe we could start with how to grant me access to
> deploy and manage the reports and then take it from there.
> I would appreciate any help I can get. These outsourced people aren't going
> to make the effort to figure this out. We're going to have to spoonfeed
> them:-)
> Liz
For Item (a), you may want to check the security on the Reports and
ReportServer Virtual Directories. You may want to change the Directory
Security (via right-clicking the virtual directories in IIS ->
Properties -> Directory Security tab -> Edit... button -> select
'Anonymous access' and 'Integrated Windows Authentication').
For Item (b), you set the user permissions in the Report Manager in
the second tab on the main page (I don't remember the name of it). You
can allow Browse, Publish, etc for various users that you add (note
that the standard windows format is: DOMAIN\User).
For Item (c), Browse permissions should be sufficient for most users
(refer to Item (b) response).
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant
Thursday, March 22, 2012
Cannot deploy new report
I been not been uploading any new reports for a while but reporting services is running fine on our network.
I added a new report via Visual studio 2003 today but got the following error when trying to deploy
a connection cannot be made to the report server.
Im not sure if sql server 2000 user has been taken off as I was doing a spring clean and may have remove the vital user. This is just a worry, maybe not true.
What users shoulod I have on SQL server to enable deploying of reports, or has anyone come across this problem?
Many thanks in advance
Scott
If anyone else has this problem, I have figured it out for me..
The SSL needed re-importing. Work fine after this. When importing into IE I allowed the system to decided where to put it rather than selecting myself. Hope that helps anyone else
Scott
sqlCannot deploy data source DataSource to the server because it already exists and OverwriteDataSo
When I deploy the reports I get the following warning
Cannot deploy data source DataSource1 to the server because it already exists and OverwriteDataSources is not specified
Is there any way of specifying Overwrite data source.
Any suggestion is highly appreciated.
Its in the properties of the report project...|||Thanks I got that.Cannot deploy
Hello, I attempted to deploy my reports to a remote web server where RS
is installed. The two RS databases exist, as do the two virtuals.
Anyone seen the error below or have any procedure for diagnosing it?
Thanks,
-KJ
************************** error follows ***************
TITLE: Microsoft Report Designer
--
A connection could not be made to the report server
http://10.12.48.97/ReportServer.
--
ADDITIONAL INFORMATION:
Client found response content type of 'text/html; charset=utf-8', but
expected 'text/xml'.
The request failed with the error message:
--
<html>
<head>
<title>
SQL Server Reporting Services
</title><meta name="Generator" content="Microsoft SQL Server
Reporting Services 9.00.2047.00" />
<meta name="HTTP Status" content="500" />
<meta name="ProductLocaleID" content="9" />
<meta name="CountryLocaleID" content="1033" />
<style>
BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt;
COLOR:black}
H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}
LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt;
DISPLAY:inline}
.ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt;
COLOR:gray}
A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC;
TEXT-DECORATION:none}
A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300;
TEXT-DECORATION:underline}
A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC;
TEXT-DECORATION:none}
A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300;
TEXT-DECORATION:underline}
</style>
</head><body bgcolor="white">
<h1>
Reporting Services Error<hr width="100%" size="1" color="silver" />
</h1><ul>
<li>The report server has encountered a configuration error. See the
report server log files for more information.
(rsServerConfigurationError) </li><ul>
<li>For more information about this error navigate to the report
server on the local server machine, or enable remote errors</li>
</ul><hr width="100%" size="1" color="silver" /><span
class="ProductInfo">SQL Server Reporting Services</span>
</ul>
</body>
--. (Microsoft.ReportingServices.Designer)
--
BUTTONS:
OK
--Cancel this request; after much ado, I got it up and running.
n_o_s_p_a__m@.mail.com wrote:
> Hello, I attempted to deploy my reports to a remote web server where RS
> is installed. The two RS databases exist, as do the two virtuals.
> Anyone seen the error below or have any procedure for diagnosing it?
> Thanks,
> -KJ
> ************************** error follows ***************
> TITLE: Microsoft Report Designer
> --
> A connection could not be made to the report server
> http://10.12.48.97/ReportServer.
> --
> ADDITIONAL INFORMATION:
> Client found response content type of 'text/html; charset=utf-8', but
> expected 'text/xml'.
> The request failed with the error message:
> --
> <html>
> <head>
> <title>
> SQL Server Reporting Services
> </title><meta name="Generator" content="Microsoft SQL Server
> Reporting Services 9.00.2047.00" />
> <meta name="HTTP Status" content="500" />
> <meta name="ProductLocaleID" content="9" />
> <meta name="CountryLocaleID" content="1033" />
> <style>
> BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt;
> COLOR:black}
> H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}
> LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt;
> DISPLAY:inline}
> .ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt;
> COLOR:gray}
> A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC;
> TEXT-DECORATION:none}
> A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300;
> TEXT-DECORATION:underline}
> A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC;
> TEXT-DECORATION:none}
> A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300;
> TEXT-DECORATION:underline}
> </style>
> </head><body bgcolor="white">
> <h1>
> Reporting Services Error<hr width="100%" size="1" color="silver" />
> </h1><ul>
> <li>The report server has encountered a configuration error. See the
> report server log files for more information.
> (rsServerConfigurationError) </li><ul>
> <li>For more information about this error navigate to the report
> server on the local server machine, or enable remote errors</li>
> </ul><hr width="100%" size="1" color="silver" /><span
> class="ProductInfo">SQL Server Reporting Services</span>
> </ul>
> </body>
> --. (Microsoft.ReportingServices.Designer)
> --
> BUTTONS:
> OK
> --
is installed. The two RS databases exist, as do the two virtuals.
Anyone seen the error below or have any procedure for diagnosing it?
Thanks,
-KJ
************************** error follows ***************
TITLE: Microsoft Report Designer
--
A connection could not be made to the report server
http://10.12.48.97/ReportServer.
--
ADDITIONAL INFORMATION:
Client found response content type of 'text/html; charset=utf-8', but
expected 'text/xml'.
The request failed with the error message:
--
<html>
<head>
<title>
SQL Server Reporting Services
</title><meta name="Generator" content="Microsoft SQL Server
Reporting Services 9.00.2047.00" />
<meta name="HTTP Status" content="500" />
<meta name="ProductLocaleID" content="9" />
<meta name="CountryLocaleID" content="1033" />
<style>
BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt;
COLOR:black}
H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}
LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt;
DISPLAY:inline}
.ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt;
COLOR:gray}
A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC;
TEXT-DECORATION:none}
A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300;
TEXT-DECORATION:underline}
A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC;
TEXT-DECORATION:none}
A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300;
TEXT-DECORATION:underline}
</style>
</head><body bgcolor="white">
<h1>
Reporting Services Error<hr width="100%" size="1" color="silver" />
</h1><ul>
<li>The report server has encountered a configuration error. See the
report server log files for more information.
(rsServerConfigurationError) </li><ul>
<li>For more information about this error navigate to the report
server on the local server machine, or enable remote errors</li>
</ul><hr width="100%" size="1" color="silver" /><span
class="ProductInfo">SQL Server Reporting Services</span>
</ul>
</body>
--. (Microsoft.ReportingServices.Designer)
--
BUTTONS:
OK
--Cancel this request; after much ado, I got it up and running.
n_o_s_p_a__m@.mail.com wrote:
> Hello, I attempted to deploy my reports to a remote web server where RS
> is installed. The two RS databases exist, as do the two virtuals.
> Anyone seen the error below or have any procedure for diagnosing it?
> Thanks,
> -KJ
> ************************** error follows ***************
> TITLE: Microsoft Report Designer
> --
> A connection could not be made to the report server
> http://10.12.48.97/ReportServer.
> --
> ADDITIONAL INFORMATION:
> Client found response content type of 'text/html; charset=utf-8', but
> expected 'text/xml'.
> The request failed with the error message:
> --
> <html>
> <head>
> <title>
> SQL Server Reporting Services
> </title><meta name="Generator" content="Microsoft SQL Server
> Reporting Services 9.00.2047.00" />
> <meta name="HTTP Status" content="500" />
> <meta name="ProductLocaleID" content="9" />
> <meta name="CountryLocaleID" content="1033" />
> <style>
> BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt;
> COLOR:black}
> H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}
> LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt;
> DISPLAY:inline}
> .ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt;
> COLOR:gray}
> A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC;
> TEXT-DECORATION:none}
> A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300;
> TEXT-DECORATION:underline}
> A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC;
> TEXT-DECORATION:none}
> A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300;
> TEXT-DECORATION:underline}
> </style>
> </head><body bgcolor="white">
> <h1>
> Reporting Services Error<hr width="100%" size="1" color="silver" />
> </h1><ul>
> <li>The report server has encountered a configuration error. See the
> report server log files for more information.
> (rsServerConfigurationError) </li><ul>
> <li>For more information about this error navigate to the report
> server on the local server machine, or enable remote errors</li>
> </ul><hr width="100%" size="1" color="silver" /><span
> class="ProductInfo">SQL Server Reporting Services</span>
> </ul>
> </body>
> --. (Microsoft.ReportingServices.Designer)
> --
> BUTTONS:
> OK
> --
cannot delete user & shrink log file
Hello... I'm facing two problems:
1. When I try to delete a user from a specific database,
it reports that that user cannot be dropped as it owns
objects. The db_owner is 'sa' not this user.
2. When I try to shrink the size of my log file, it
reports, "Cannot shrink log file 2 (cms1_log) because all
logical log files are in use."
Please help. Thanks.1. My guess is that the user own some objects. If you are used to
Enterprise Manager then expand each objects list and see if the user own
anything like "tables", "views", "store procedure", "user defined functions"
...
2. What is your recovery model? Right click server in EM, then click
properties, then options
"Rob" <rhchin@.hotmail.com> wrote in message
news:5d8901c35784$5b35fbf0$a001280a@.phx.gbl...
> Hello... I'm facing two problems:
> 1. When I try to delete a user from a specific database,
> it reports that that user cannot be dropped as it owns
> objects. The db_owner is 'sa' not this user.
> 2. When I try to shrink the size of my log file, it
> reports, "Cannot shrink log file 2 (cms1_log) because all
> logical log files are in use."
> Please help. Thanks.|||Rob,
#1..It could also be that that the user owns other objects like table,
stored procedures etc.Using the below query, you can find out the objects:
SELECT [name]
FROM sysobjects
WHERE uid=USER_ID('<user_name>')
Once there, try to change the ownership to another user, using
sp_changeobjectowner.
#2.Refer
INF: How to Shrink the SQL Server 7.0 Transaction Log
http://support.microsoft.com/support/kb/Articles/q256/6/50.asp
INF: Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE
http://support.microsoft.com/support/kb/Articles/q272/3/18.asp
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Rob" <rhchin@.hotmail.com> wrote in message
news:5d8901c35784$5b35fbf0$a001280a@.phx.gbl...
> Hello... I'm facing two problems:
> 1. When I try to delete a user from a specific database,
> it reports that that user cannot be dropped as it owns
> objects. The db_owner is 'sa' not this user.
> 2. When I try to shrink the size of my log file, it
> reports, "Cannot shrink log file 2 (cms1_log) because all
> logical log files are in use."
> Please help. Thanks.|||Thanks for your response...
>Once there, try to change the ownership to another user,
using
>sp_changeobjectowner.
I can see many objects owned by the user I wish to drop.
However, when I try to use the sp_changeobjectowner sproc,
it tells me that the object does not exist or is not a
valid object for this operation.
Thanks again.
1. When I try to delete a user from a specific database,
it reports that that user cannot be dropped as it owns
objects. The db_owner is 'sa' not this user.
2. When I try to shrink the size of my log file, it
reports, "Cannot shrink log file 2 (cms1_log) because all
logical log files are in use."
Please help. Thanks.1. My guess is that the user own some objects. If you are used to
Enterprise Manager then expand each objects list and see if the user own
anything like "tables", "views", "store procedure", "user defined functions"
...
2. What is your recovery model? Right click server in EM, then click
properties, then options
"Rob" <rhchin@.hotmail.com> wrote in message
news:5d8901c35784$5b35fbf0$a001280a@.phx.gbl...
> Hello... I'm facing two problems:
> 1. When I try to delete a user from a specific database,
> it reports that that user cannot be dropped as it owns
> objects. The db_owner is 'sa' not this user.
> 2. When I try to shrink the size of my log file, it
> reports, "Cannot shrink log file 2 (cms1_log) because all
> logical log files are in use."
> Please help. Thanks.|||Rob,
#1..It could also be that that the user owns other objects like table,
stored procedures etc.Using the below query, you can find out the objects:
SELECT [name]
FROM sysobjects
WHERE uid=USER_ID('<user_name>')
Once there, try to change the ownership to another user, using
sp_changeobjectowner.
#2.Refer
INF: How to Shrink the SQL Server 7.0 Transaction Log
http://support.microsoft.com/support/kb/Articles/q256/6/50.asp
INF: Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE
http://support.microsoft.com/support/kb/Articles/q272/3/18.asp
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Rob" <rhchin@.hotmail.com> wrote in message
news:5d8901c35784$5b35fbf0$a001280a@.phx.gbl...
> Hello... I'm facing two problems:
> 1. When I try to delete a user from a specific database,
> it reports that that user cannot be dropped as it owns
> objects. The db_owner is 'sa' not this user.
> 2. When I try to shrink the size of my log file, it
> reports, "Cannot shrink log file 2 (cms1_log) because all
> logical log files are in use."
> Please help. Thanks.|||Thanks for your response...
>Once there, try to change the ownership to another user,
using
>sp_changeobjectowner.
I can see many objects owned by the user I wish to drop.
However, when I try to use the sp_changeobjectowner sproc,
it tells me that the object does not exist or is not a
valid object for this operation.
Thanks again.
Cannot Delete Report
I have been using Reporting Services 2000 for a couple of years with
no issues. Now have verion 2005 installed and building some reports. I
created a report that no longer want and when I went to delete it by
"showing details", selecting the correct checkbox and clicking delete,
I am prompted to confirm that I want to delete but am getting the
following error: "An internal error has occured on the Report Server.
See the error log for more details. (rsInternalError)."
I checked the logs and have the following but it does not seem to
specify the reason for throwing the error:
System.Web.Services.Protocols.SoapException:
System.Web.Services.Protocols.SoapException: An internal error
occurred on the report server. See the error log for more details. --
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details.
at
Microsoft.ReportingServices.Diagnostics.Utilities.RSTraceInternal.Assert(Boolean
condition, String componentName)
at
Microsoft.ReportingServices.Diagnostics.Utilities.RSTrace.Assert(Boolean
condition)
at
Microsoft.ReportingServices.Library.DeleteItemAction.PerformActionNow()
at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
at
Microsoft.ReportingServices.WebServer.ReportingService2005Impl.DeleteItem(String
Item)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.WebServer.ReportingService2005Impl.DeleteItem(String
Item)
at
Microsoft.ReportingServices.WebServer.ReportingService2005.DeleteItem(String
Item)
at
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
message, WebResponse response, Stream responseStream, Boolean
asyncCall)
at
System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters)
at
Microsoft.SqlServer.ReportingServices2005.ReportingService2005.DeleteItem(String
Item)
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.DeleteItem(String
Item)
at Microsoft.ReportingServices.UI.BaseProperties.DoDelete()
at
Microsoft.ReportingServices.UI.BaseProperties.DeleteBtn_Click(Object
sender, EventArgs e)
at Microsoft.ReportingServices.UI.ScriptButton.OnClick(EventArgs e)
at
Microsoft.ReportingServices.UI.ScriptButton.RaisePostBackEvent(String
eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection
postData)
at System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)On Sep 25, 4:13 pm, daves...@.gmail.com wrote:
> I have been using Reporting Services 2000 for a couple of years with
> no issues. Now have verion 2005 installed and building some reports. I
> created a report that no longer want and when I went to delete it by
> "showing details", selecting the correct checkbox and clicking delete,
> I am prompted to confirm that I want to delete but am getting the
> following error: "An internal error has occured on the Report Server.
> See the error log for more details. (rsInternalError)."
> I checked the logs and have the following but it does not seem to
> specify the reason for throwing the error:
> System.Web.Services.Protocols.SoapException:
> System.Web.Services.Protocols.SoapException: An internal error
> occurred on the report server. See the error log for more details. --
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more details.
> at
> Microsoft.ReportingServices.Diagnostics.Utilities.RSTraceInternal.Assert(Boolean
> condition, String componentName)
> at
> Microsoft.ReportingServices.Diagnostics.Utilities.RSTrace.Assert(Boolean
> condition)
> at
> Microsoft.ReportingServices.Library.DeleteItemAction.PerformActionNow()
> at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
> at
> Microsoft.ReportingServices.WebServer.ReportingService2005Impl.DeleteItem(String
> Item)
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.WebServer.ReportingService2005Impl.DeleteItem(String
> Item)
> at
> Microsoft.ReportingServices.WebServer.ReportingService2005.DeleteItem(String
> Item)
> at
> System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
> message, WebResponse response, Stream responseStream, Boolean
> asyncCall)
> at
> System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> methodName, Object[] parameters)
> at
> Microsoft.SqlServer.ReportingServices2005.ReportingService2005.DeleteItem(String
> Item)
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.DeleteItem(String
> Item)
> at Microsoft.ReportingServices.UI.BaseProperties.DoDelete()
> at
> Microsoft.ReportingServices.UI.BaseProperties.DeleteBtn_Click(Object
> sender, EventArgs e)
> at Microsoft.ReportingServices.UI.ScriptButton.OnClick(EventArgs e)
> at
> Microsoft.ReportingServices.UI.ScriptButton.RaisePostBackEvent(String
> eventArgument)
> at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
> sourceControl, String eventArgument)
> at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection
> postData)
> at System.Web.UI.Page.ProcessRequestMain(Boolean
> includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
If you have not yet installed SP1 or SP2 for SQL Server 2005, you will
want to install it on the Report Server. This link might provide some
insight. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Sep 25, 5:27 pm, EMartinez <emartinez...@.gmail.com> wrote:
> On Sep 25, 4:13 pm, daves...@.gmail.com wrote:
>
>
> > I have been using Reporting Services 2000 for a couple of years with
> > no issues. Now have verion 2005 installed and building some reports. I
> > created a report that no longer want and when I went to delete it by
> > "showing details", selecting the correct checkbox and clicking delete,
> > I am prompted to confirm that I want to delete but am getting the
> > following error: "An internal error has occured on the Report Server.
> > See the error log for more details. (rsInternalError)."
> > I checked the logs and have the following but it does not seem to
> > specify the reason for throwing the error:
> > System.Web.Services.Protocols.SoapException:
> > System.Web.Services.Protocols.SoapException: An internal error
> > occurred on the report server. See the error log for more details. --
> > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogExcept=ion:
> > An internal error occurred on the report server. See the error log for
> > more details.
> > at
> > Microsoft.ReportingServices.Diagnostics.Utilities.RSTraceInternal.Asser=t(Bo=ADolean
> > condition, String componentName)
> > at
> > Microsoft.ReportingServices.Diagnostics.Utilities.RSTrace.Assert(Boolean
> > condition)
> > at
> > Microsoft.ReportingServices.Library.DeleteItemAction.PerformActionNow()
> > at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
> > at
> > Microsoft.ReportingServices.WebServer.ReportingService2005Impl.DeleteIt=em(S=ADtring
> > Item)
> > -- End of inner exception stack trace --
> > at
> > Microsoft.ReportingServices.WebServer.ReportingService2005Impl.DeleteIt=em(S=ADtring
> > Item)
> > at
> > Microsoft.ReportingServices.WebServer.ReportingService2005.DeleteItem(S=trin=ADg
> > Item)
> > at
> > System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapC=lien=ADtMessage
> > message, WebResponse response, Stream responseStream, Boolean
> > asyncCall)
> > at
> > System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> > methodName, Object[] parameters)
> > at
> > Microsoft.SqlServer.ReportingServices2005.ReportingService2005.DeleteIt=em(S=ADtring
> > Item)
> > at
> > Microsoft.SqlServer.ReportingServices2005.RSConnection.DeleteItem(String
> > Item)
> > at Microsoft.ReportingServices.UI.BaseProperties.DoDelete()
> > at
> > Microsoft.ReportingServices.UI.BaseProperties.DeleteBtn_Click(Object
> > sender, EventArgs e)
> > at Microsoft.ReportingServices.UI.ScriptButton.OnClick(EventArgs e)
> > at
> > Microsoft.ReportingServices.UI.ScriptButton.RaisePostBackEvent(String
> > eventArgument)
> > at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
> > sourceControl, String eventArgument)
> > at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection
> > postData)
> > at System.Web.UI.Page.ProcessRequestMain(Boolean
> > includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
> If you have not yet installed SP1 or SP2 for SQL Server 2005, you will
> want to install it on the Report Server. This link might provide some
> insight. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant- Hide quoted text -
> - Show quoted text -
We did apply SP2 but it did not help the issue.|||I've seen the same thing, and I think it is a bug. Just click Edit from the
details view, and use the Delete function on that page.
--
Tom Garth
"davestub@.gmail.com" wrote:
> On Sep 25, 5:27 pm, EMartinez <emartinez...@.gmail.com> wrote:
> > On Sep 25, 4:13 pm, daves...@.gmail.com wrote:
> >
> >
> >
> >
> >
> > > I have been using Reporting Services 2000 for a couple of years with
> > > no issues. Now have verion 2005 installed and building some reports. I
> > > created a report that no longer want and when I went to delete it by
> > > "showing details", selecting the correct checkbox and clicking delete,
> > > I am prompted to confirm that I want to delete but am getting the
> > > following error: "An internal error has occured on the Report Server.
> > > See the error log for more details. (rsInternalError)."
> >
> > > I checked the logs and have the following but it does not seem to
> > > specify the reason for throwing the error:
> >
> > > System.Web.Services.Protocols.SoapException:
> > > System.Web.Services.Protocols.SoapException: An internal error
> > > occurred on the report server. See the error log for more details. --
> >
> > > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> > > An internal error occurred on the report server. See the error log for
> > > more details.
> > > at
> > > Microsoft.ReportingServices.Diagnostics.Utilities.RSTraceInternal.Assert(Bo-olean
> > > condition, String componentName)
> > > at
> > > Microsoft.ReportingServices.Diagnostics.Utilities.RSTrace.Assert(Boolean
> > > condition)
> > > at
> > > Microsoft.ReportingServices.Library.DeleteItemAction.PerformActionNow()
> > > at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
> > > at
> > > Microsoft.ReportingServices.WebServer.ReportingService2005Impl.DeleteItem(S-tring
> > > Item)
> > > -- End of inner exception stack trace --
> > > at
> > > Microsoft.ReportingServices.WebServer.ReportingService2005Impl.DeleteItem(S-tring
> > > Item)
> > > at
> > > Microsoft.ReportingServices.WebServer.ReportingService2005.DeleteItem(Strin-g
> > > Item)
> > > at
> > > System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClien-tMessage
> > > message, WebResponse response, Stream responseStream, Boolean
> > > asyncCall)
> > > at
> > > System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> > > methodName, Object[] parameters)
> > > at
> > > Microsoft.SqlServer.ReportingServices2005.ReportingService2005.DeleteItem(S-tring
> > > Item)
> > > at
> > > Microsoft.SqlServer.ReportingServices2005.RSConnection.DeleteItem(String
> > > Item)
> > > at Microsoft.ReportingServices.UI.BaseProperties.DoDelete()
> > > at
> > > Microsoft.ReportingServices.UI.BaseProperties.DeleteBtn_Click(Object
> > > sender, EventArgs e)
> > > at Microsoft.ReportingServices.UI.ScriptButton.OnClick(EventArgs e)
> > > at
> > > Microsoft.ReportingServices.UI.ScriptButton.RaisePostBackEvent(String
> > > eventArgument)
> > > at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
> > > sourceControl, String eventArgument)
> > > at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection
> > > postData)
> > > at System.Web.UI.Page.ProcessRequestMain(Boolean
> > > includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
> >
> > If you have not yet installed SP1 or SP2 for SQL Server 2005, you will
> > want to install it on the Report Server. This link might provide some
> > insight. Hope this helps.
> >
> > Regards,
> >
> > Enrique Martinez
> > Sr. Software Consultant- Hide quoted text -
> >
> > - Show quoted text -
> We did apply SP2 but it did not help the issue.
>|||On Sep 26, 9:36 am, Tom Garth <TomGa...@.discussions.microsoft.com>
wrote:
> I've seen the same thing, and I think it is a bug. Just click Edit from t=he
> details view, and use the Delete function on that page.
> --
> Tom Garth
>
> "daves...@.gmail.com" wrote:
> > On Sep 25, 5:27 pm, EMartinez <emartinez...@.gmail.com> wrote:
> > > On Sep 25, 4:13 pm, daves...@.gmail.com wrote:
> > > > I have been using Reporting Services 2000 for a couple of years with
> > > > no issues. Now have verion 2005 installed and building some reports=. I
> > > > created a report that no longer want and when I went to delete it by
> > > > "showing details", selecting the correct checkbox and clicking dele=te,
> > > > I am prompted to confirm that I want to delete but am getting the
> > > > following error: "An internal error has occured on the Report Serve=r=2E
> > > > See the error log for more details. (rsInternalError)."
> > > > I checked the logs and have the following but it does not seem to
> > > > specify the reason for throwing the error:
> > > > System.Web.Services.Protocols.SoapException:
> > > > System.Web.Services.Protocols.SoapException: An internal error
> > > > occurred on the report server. See the error log for more details. =--
> > > > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogEx=ception:
> > > > An internal error occurred on the report server. See the error log =for
> > > > more details.
> > > > at
> > > > Microsoft.ReportingServices.Diagnostics.Utilities.RSTraceInternal.A=ssert(Bo=AD-olean
> > > > condition, String componentName)
> > > > at
> > > > Microsoft.ReportingServices.Diagnostics.Utilities.RSTrace.Assert(Bo=olean
> > > > condition)
> > > > at
> > > > Microsoft.ReportingServices.Library.DeleteItemAction.PerformActionN=ow()
> > > > at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
> > > > at
> > > > Microsoft.ReportingServices.WebServer.ReportingService2005Impl.Dele=teItem(S=AD-tring
> > > > Item)
> > > > -- End of inner exception stack trace --
> > > > at
> > > > Microsoft.ReportingServices.WebServer.ReportingService2005Impl.Dele=teItem(S=AD-tring
> > > > Item)
> > > > at
> > > > Microsoft.ReportingServices.WebServer.ReportingService2005.DeleteIt=em(Strin=AD-g
> > > > Item)
> > > > at
> > > > System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(S=oapClien=AD-tMessage
> > > > message, WebResponse response, Stream responseStream, Boolean
> > > > asyncCall)
> > > > at
> > > > System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> > > > methodName, Object[] parameters)
> > > > at
> > > > Microsoft.SqlServer.ReportingServices2005.ReportingService2005.Dele=teItem(S=AD-tring
> > > > Item)
> > > > at
> > > > Microsoft.SqlServer.ReportingServices2005.RSConnection.DeleteItem(S=tring
> > > > Item)
> > > > at Microsoft.ReportingServices.UI.BaseProperties.DoDelete()
> > > > at
> > > > Microsoft.ReportingServices.UI.BaseProperties.DeleteBtn_Click(Object
> > > > sender, EventArgs e)
> > > > at Microsoft.ReportingServices.UI.ScriptButton.OnClick(EventArgs= e)
> > > > at
> > > > Microsoft.ReportingServices.UI.ScriptButton.RaisePostBackEvent(Stri=ng
> > > > eventArgument)
> > > > at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
> > > > sourceControl, String eventArgument)
> > > > at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection
> > > > postData)
> > > > at System.Web.UI.Page.ProcessRequestMain(Boolean
> > > > includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
> > > If you have not yet installed SP1 or SP2 for SQL Server 2005, you will
> > > want to install it on the Report Server. This link might provide some
> > > insight. Hope this helps.
> > > Regards,
> > > Enrique Martinez
> > > Sr. Software Consultant- Hide quoted text -
> > > - Show quoted text -
> > We did apply SP2 but it did not help the issue.- Hide quoted text -
> - Show quoted text -
Just tried to delete from the properties page and received the same
error. Thanks for the suggestion.|||You have global "NOCOUNT" turned on on the SQL Server. Turn that off.
Reporting Services requires NOCOUNT off so that it knows that items/records
were actually deleted.
--
SQL Server Developer Support Engineer
"davestub@.gmail.com" wrote:
> I have been using Reporting Services 2000 for a couple of years with
> no issues. Now have verion 2005 installed and building some reports. I
> created a report that no longer want and when I went to delete it by
> "showing details", selecting the correct checkbox and clicking delete,
> I am prompted to confirm that I want to delete but am getting the
> following error: "An internal error has occured on the Report Server.
> See the error log for more details. (rsInternalError)."
> I checked the logs and have the following but it does not seem to
> specify the reason for throwing the error:
> System.Web.Services.Protocols.SoapException:
> System.Web.Services.Protocols.SoapException: An internal error
> occurred on the report server. See the error log for more details. --
> >
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more details.
> at
> Microsoft.ReportingServices.Diagnostics.Utilities.RSTraceInternal.Assert(Boolean
> condition, String componentName)
> at
> Microsoft.ReportingServices.Diagnostics.Utilities.RSTrace.Assert(Boolean
> condition)
> at
> Microsoft.ReportingServices.Library.DeleteItemAction.PerformActionNow()
> at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
> at
> Microsoft.ReportingServices.WebServer.ReportingService2005Impl.DeleteItem(String
> Item)
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.WebServer.ReportingService2005Impl.DeleteItem(String
> Item)
> at
> Microsoft.ReportingServices.WebServer.ReportingService2005.DeleteItem(String
> Item)
> at
> System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
> message, WebResponse response, Stream responseStream, Boolean
> asyncCall)
> at
> System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> methodName, Object[] parameters)
> at
> Microsoft.SqlServer.ReportingServices2005.ReportingService2005.DeleteItem(String
> Item)
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.DeleteItem(String
> Item)
> at Microsoft.ReportingServices.UI.BaseProperties.DoDelete()
> at
> Microsoft.ReportingServices.UI.BaseProperties.DeleteBtn_Click(Object
> sender, EventArgs e)
> at Microsoft.ReportingServices.UI.ScriptButton.OnClick(EventArgs e)
> at
> Microsoft.ReportingServices.UI.ScriptButton.RaisePostBackEvent(String
> eventArgument)
> at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
> sourceControl, String eventArgument)
> at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection
> postData)
> at System.Web.UI.Page.ProcessRequestMain(Boolean
> includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
>
no issues. Now have verion 2005 installed and building some reports. I
created a report that no longer want and when I went to delete it by
"showing details", selecting the correct checkbox and clicking delete,
I am prompted to confirm that I want to delete but am getting the
following error: "An internal error has occured on the Report Server.
See the error log for more details. (rsInternalError)."
I checked the logs and have the following but it does not seem to
specify the reason for throwing the error:
System.Web.Services.Protocols.SoapException:
System.Web.Services.Protocols.SoapException: An internal error
occurred on the report server. See the error log for more details. --
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details.
at
Microsoft.ReportingServices.Diagnostics.Utilities.RSTraceInternal.Assert(Boolean
condition, String componentName)
at
Microsoft.ReportingServices.Diagnostics.Utilities.RSTrace.Assert(Boolean
condition)
at
Microsoft.ReportingServices.Library.DeleteItemAction.PerformActionNow()
at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
at
Microsoft.ReportingServices.WebServer.ReportingService2005Impl.DeleteItem(String
Item)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.WebServer.ReportingService2005Impl.DeleteItem(String
Item)
at
Microsoft.ReportingServices.WebServer.ReportingService2005.DeleteItem(String
Item)
at
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
message, WebResponse response, Stream responseStream, Boolean
asyncCall)
at
System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters)
at
Microsoft.SqlServer.ReportingServices2005.ReportingService2005.DeleteItem(String
Item)
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.DeleteItem(String
Item)
at Microsoft.ReportingServices.UI.BaseProperties.DoDelete()
at
Microsoft.ReportingServices.UI.BaseProperties.DeleteBtn_Click(Object
sender, EventArgs e)
at Microsoft.ReportingServices.UI.ScriptButton.OnClick(EventArgs e)
at
Microsoft.ReportingServices.UI.ScriptButton.RaisePostBackEvent(String
eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection
postData)
at System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)On Sep 25, 4:13 pm, daves...@.gmail.com wrote:
> I have been using Reporting Services 2000 for a couple of years with
> no issues. Now have verion 2005 installed and building some reports. I
> created a report that no longer want and when I went to delete it by
> "showing details", selecting the correct checkbox and clicking delete,
> I am prompted to confirm that I want to delete but am getting the
> following error: "An internal error has occured on the Report Server.
> See the error log for more details. (rsInternalError)."
> I checked the logs and have the following but it does not seem to
> specify the reason for throwing the error:
> System.Web.Services.Protocols.SoapException:
> System.Web.Services.Protocols.SoapException: An internal error
> occurred on the report server. See the error log for more details. --
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more details.
> at
> Microsoft.ReportingServices.Diagnostics.Utilities.RSTraceInternal.Assert(Boolean
> condition, String componentName)
> at
> Microsoft.ReportingServices.Diagnostics.Utilities.RSTrace.Assert(Boolean
> condition)
> at
> Microsoft.ReportingServices.Library.DeleteItemAction.PerformActionNow()
> at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
> at
> Microsoft.ReportingServices.WebServer.ReportingService2005Impl.DeleteItem(String
> Item)
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.WebServer.ReportingService2005Impl.DeleteItem(String
> Item)
> at
> Microsoft.ReportingServices.WebServer.ReportingService2005.DeleteItem(String
> Item)
> at
> System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
> message, WebResponse response, Stream responseStream, Boolean
> asyncCall)
> at
> System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> methodName, Object[] parameters)
> at
> Microsoft.SqlServer.ReportingServices2005.ReportingService2005.DeleteItem(String
> Item)
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.DeleteItem(String
> Item)
> at Microsoft.ReportingServices.UI.BaseProperties.DoDelete()
> at
> Microsoft.ReportingServices.UI.BaseProperties.DeleteBtn_Click(Object
> sender, EventArgs e)
> at Microsoft.ReportingServices.UI.ScriptButton.OnClick(EventArgs e)
> at
> Microsoft.ReportingServices.UI.ScriptButton.RaisePostBackEvent(String
> eventArgument)
> at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
> sourceControl, String eventArgument)
> at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection
> postData)
> at System.Web.UI.Page.ProcessRequestMain(Boolean
> includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
If you have not yet installed SP1 or SP2 for SQL Server 2005, you will
want to install it on the Report Server. This link might provide some
insight. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Sep 25, 5:27 pm, EMartinez <emartinez...@.gmail.com> wrote:
> On Sep 25, 4:13 pm, daves...@.gmail.com wrote:
>
>
> > I have been using Reporting Services 2000 for a couple of years with
> > no issues. Now have verion 2005 installed and building some reports. I
> > created a report that no longer want and when I went to delete it by
> > "showing details", selecting the correct checkbox and clicking delete,
> > I am prompted to confirm that I want to delete but am getting the
> > following error: "An internal error has occured on the Report Server.
> > See the error log for more details. (rsInternalError)."
> > I checked the logs and have the following but it does not seem to
> > specify the reason for throwing the error:
> > System.Web.Services.Protocols.SoapException:
> > System.Web.Services.Protocols.SoapException: An internal error
> > occurred on the report server. See the error log for more details. --
> > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogExcept=ion:
> > An internal error occurred on the report server. See the error log for
> > more details.
> > at
> > Microsoft.ReportingServices.Diagnostics.Utilities.RSTraceInternal.Asser=t(Bo=ADolean
> > condition, String componentName)
> > at
> > Microsoft.ReportingServices.Diagnostics.Utilities.RSTrace.Assert(Boolean
> > condition)
> > at
> > Microsoft.ReportingServices.Library.DeleteItemAction.PerformActionNow()
> > at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
> > at
> > Microsoft.ReportingServices.WebServer.ReportingService2005Impl.DeleteIt=em(S=ADtring
> > Item)
> > -- End of inner exception stack trace --
> > at
> > Microsoft.ReportingServices.WebServer.ReportingService2005Impl.DeleteIt=em(S=ADtring
> > Item)
> > at
> > Microsoft.ReportingServices.WebServer.ReportingService2005.DeleteItem(S=trin=ADg
> > Item)
> > at
> > System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapC=lien=ADtMessage
> > message, WebResponse response, Stream responseStream, Boolean
> > asyncCall)
> > at
> > System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> > methodName, Object[] parameters)
> > at
> > Microsoft.SqlServer.ReportingServices2005.ReportingService2005.DeleteIt=em(S=ADtring
> > Item)
> > at
> > Microsoft.SqlServer.ReportingServices2005.RSConnection.DeleteItem(String
> > Item)
> > at Microsoft.ReportingServices.UI.BaseProperties.DoDelete()
> > at
> > Microsoft.ReportingServices.UI.BaseProperties.DeleteBtn_Click(Object
> > sender, EventArgs e)
> > at Microsoft.ReportingServices.UI.ScriptButton.OnClick(EventArgs e)
> > at
> > Microsoft.ReportingServices.UI.ScriptButton.RaisePostBackEvent(String
> > eventArgument)
> > at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
> > sourceControl, String eventArgument)
> > at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection
> > postData)
> > at System.Web.UI.Page.ProcessRequestMain(Boolean
> > includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
> If you have not yet installed SP1 or SP2 for SQL Server 2005, you will
> want to install it on the Report Server. This link might provide some
> insight. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant- Hide quoted text -
> - Show quoted text -
We did apply SP2 but it did not help the issue.|||I've seen the same thing, and I think it is a bug. Just click Edit from the
details view, and use the Delete function on that page.
--
Tom Garth
"davestub@.gmail.com" wrote:
> On Sep 25, 5:27 pm, EMartinez <emartinez...@.gmail.com> wrote:
> > On Sep 25, 4:13 pm, daves...@.gmail.com wrote:
> >
> >
> >
> >
> >
> > > I have been using Reporting Services 2000 for a couple of years with
> > > no issues. Now have verion 2005 installed and building some reports. I
> > > created a report that no longer want and when I went to delete it by
> > > "showing details", selecting the correct checkbox and clicking delete,
> > > I am prompted to confirm that I want to delete but am getting the
> > > following error: "An internal error has occured on the Report Server.
> > > See the error log for more details. (rsInternalError)."
> >
> > > I checked the logs and have the following but it does not seem to
> > > specify the reason for throwing the error:
> >
> > > System.Web.Services.Protocols.SoapException:
> > > System.Web.Services.Protocols.SoapException: An internal error
> > > occurred on the report server. See the error log for more details. --
> >
> > > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> > > An internal error occurred on the report server. See the error log for
> > > more details.
> > > at
> > > Microsoft.ReportingServices.Diagnostics.Utilities.RSTraceInternal.Assert(Bo-olean
> > > condition, String componentName)
> > > at
> > > Microsoft.ReportingServices.Diagnostics.Utilities.RSTrace.Assert(Boolean
> > > condition)
> > > at
> > > Microsoft.ReportingServices.Library.DeleteItemAction.PerformActionNow()
> > > at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
> > > at
> > > Microsoft.ReportingServices.WebServer.ReportingService2005Impl.DeleteItem(S-tring
> > > Item)
> > > -- End of inner exception stack trace --
> > > at
> > > Microsoft.ReportingServices.WebServer.ReportingService2005Impl.DeleteItem(S-tring
> > > Item)
> > > at
> > > Microsoft.ReportingServices.WebServer.ReportingService2005.DeleteItem(Strin-g
> > > Item)
> > > at
> > > System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClien-tMessage
> > > message, WebResponse response, Stream responseStream, Boolean
> > > asyncCall)
> > > at
> > > System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> > > methodName, Object[] parameters)
> > > at
> > > Microsoft.SqlServer.ReportingServices2005.ReportingService2005.DeleteItem(S-tring
> > > Item)
> > > at
> > > Microsoft.SqlServer.ReportingServices2005.RSConnection.DeleteItem(String
> > > Item)
> > > at Microsoft.ReportingServices.UI.BaseProperties.DoDelete()
> > > at
> > > Microsoft.ReportingServices.UI.BaseProperties.DeleteBtn_Click(Object
> > > sender, EventArgs e)
> > > at Microsoft.ReportingServices.UI.ScriptButton.OnClick(EventArgs e)
> > > at
> > > Microsoft.ReportingServices.UI.ScriptButton.RaisePostBackEvent(String
> > > eventArgument)
> > > at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
> > > sourceControl, String eventArgument)
> > > at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection
> > > postData)
> > > at System.Web.UI.Page.ProcessRequestMain(Boolean
> > > includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
> >
> > If you have not yet installed SP1 or SP2 for SQL Server 2005, you will
> > want to install it on the Report Server. This link might provide some
> > insight. Hope this helps.
> >
> > Regards,
> >
> > Enrique Martinez
> > Sr. Software Consultant- Hide quoted text -
> >
> > - Show quoted text -
> We did apply SP2 but it did not help the issue.
>|||On Sep 26, 9:36 am, Tom Garth <TomGa...@.discussions.microsoft.com>
wrote:
> I've seen the same thing, and I think it is a bug. Just click Edit from t=he
> details view, and use the Delete function on that page.
> --
> Tom Garth
>
> "daves...@.gmail.com" wrote:
> > On Sep 25, 5:27 pm, EMartinez <emartinez...@.gmail.com> wrote:
> > > On Sep 25, 4:13 pm, daves...@.gmail.com wrote:
> > > > I have been using Reporting Services 2000 for a couple of years with
> > > > no issues. Now have verion 2005 installed and building some reports=. I
> > > > created a report that no longer want and when I went to delete it by
> > > > "showing details", selecting the correct checkbox and clicking dele=te,
> > > > I am prompted to confirm that I want to delete but am getting the
> > > > following error: "An internal error has occured on the Report Serve=r=2E
> > > > See the error log for more details. (rsInternalError)."
> > > > I checked the logs and have the following but it does not seem to
> > > > specify the reason for throwing the error:
> > > > System.Web.Services.Protocols.SoapException:
> > > > System.Web.Services.Protocols.SoapException: An internal error
> > > > occurred on the report server. See the error log for more details. =--
> > > > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogEx=ception:
> > > > An internal error occurred on the report server. See the error log =for
> > > > more details.
> > > > at
> > > > Microsoft.ReportingServices.Diagnostics.Utilities.RSTraceInternal.A=ssert(Bo=AD-olean
> > > > condition, String componentName)
> > > > at
> > > > Microsoft.ReportingServices.Diagnostics.Utilities.RSTrace.Assert(Bo=olean
> > > > condition)
> > > > at
> > > > Microsoft.ReportingServices.Library.DeleteItemAction.PerformActionN=ow()
> > > > at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
> > > > at
> > > > Microsoft.ReportingServices.WebServer.ReportingService2005Impl.Dele=teItem(S=AD-tring
> > > > Item)
> > > > -- End of inner exception stack trace --
> > > > at
> > > > Microsoft.ReportingServices.WebServer.ReportingService2005Impl.Dele=teItem(S=AD-tring
> > > > Item)
> > > > at
> > > > Microsoft.ReportingServices.WebServer.ReportingService2005.DeleteIt=em(Strin=AD-g
> > > > Item)
> > > > at
> > > > System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(S=oapClien=AD-tMessage
> > > > message, WebResponse response, Stream responseStream, Boolean
> > > > asyncCall)
> > > > at
> > > > System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> > > > methodName, Object[] parameters)
> > > > at
> > > > Microsoft.SqlServer.ReportingServices2005.ReportingService2005.Dele=teItem(S=AD-tring
> > > > Item)
> > > > at
> > > > Microsoft.SqlServer.ReportingServices2005.RSConnection.DeleteItem(S=tring
> > > > Item)
> > > > at Microsoft.ReportingServices.UI.BaseProperties.DoDelete()
> > > > at
> > > > Microsoft.ReportingServices.UI.BaseProperties.DeleteBtn_Click(Object
> > > > sender, EventArgs e)
> > > > at Microsoft.ReportingServices.UI.ScriptButton.OnClick(EventArgs= e)
> > > > at
> > > > Microsoft.ReportingServices.UI.ScriptButton.RaisePostBackEvent(Stri=ng
> > > > eventArgument)
> > > > at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
> > > > sourceControl, String eventArgument)
> > > > at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection
> > > > postData)
> > > > at System.Web.UI.Page.ProcessRequestMain(Boolean
> > > > includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
> > > If you have not yet installed SP1 or SP2 for SQL Server 2005, you will
> > > want to install it on the Report Server. This link might provide some
> > > insight. Hope this helps.
> > > Regards,
> > > Enrique Martinez
> > > Sr. Software Consultant- Hide quoted text -
> > > - Show quoted text -
> > We did apply SP2 but it did not help the issue.- Hide quoted text -
> - Show quoted text -
Just tried to delete from the properties page and received the same
error. Thanks for the suggestion.|||You have global "NOCOUNT" turned on on the SQL Server. Turn that off.
Reporting Services requires NOCOUNT off so that it knows that items/records
were actually deleted.
--
SQL Server Developer Support Engineer
"davestub@.gmail.com" wrote:
> I have been using Reporting Services 2000 for a couple of years with
> no issues. Now have verion 2005 installed and building some reports. I
> created a report that no longer want and when I went to delete it by
> "showing details", selecting the correct checkbox and clicking delete,
> I am prompted to confirm that I want to delete but am getting the
> following error: "An internal error has occured on the Report Server.
> See the error log for more details. (rsInternalError)."
> I checked the logs and have the following but it does not seem to
> specify the reason for throwing the error:
> System.Web.Services.Protocols.SoapException:
> System.Web.Services.Protocols.SoapException: An internal error
> occurred on the report server. See the error log for more details. --
> >
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more details.
> at
> Microsoft.ReportingServices.Diagnostics.Utilities.RSTraceInternal.Assert(Boolean
> condition, String componentName)
> at
> Microsoft.ReportingServices.Diagnostics.Utilities.RSTrace.Assert(Boolean
> condition)
> at
> Microsoft.ReportingServices.Library.DeleteItemAction.PerformActionNow()
> at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
> at
> Microsoft.ReportingServices.WebServer.ReportingService2005Impl.DeleteItem(String
> Item)
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.WebServer.ReportingService2005Impl.DeleteItem(String
> Item)
> at
> Microsoft.ReportingServices.WebServer.ReportingService2005.DeleteItem(String
> Item)
> at
> System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
> message, WebResponse response, Stream responseStream, Boolean
> asyncCall)
> at
> System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> methodName, Object[] parameters)
> at
> Microsoft.SqlServer.ReportingServices2005.ReportingService2005.DeleteItem(String
> Item)
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.DeleteItem(String
> Item)
> at Microsoft.ReportingServices.UI.BaseProperties.DoDelete()
> at
> Microsoft.ReportingServices.UI.BaseProperties.DeleteBtn_Click(Object
> sender, EventArgs e)
> at Microsoft.ReportingServices.UI.ScriptButton.OnClick(EventArgs e)
> at
> Microsoft.ReportingServices.UI.ScriptButton.RaisePostBackEvent(String
> eventArgument)
> at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
> sourceControl, String eventArgument)
> at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection
> postData)
> at System.Web.UI.Page.ProcessRequestMain(Boolean
> includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
>
Cannot Delete or Overwrite reports
I cannot delete the first report I created. The Server CPU goes to 100%
utlisation and practically cripples the server (simple sql queries take
forever). Eventually the delete operation times out. I have managed to delete
other reports with success. I see some other people are having the same
problem. I have tried creating a report with the same name and overwriting
but then the designer times out also when I try to deploy it over the old
report.
What sort of behaviour is this? A simple DELETE operation does not work! Is
this product fundamentally flawed or what?Can you post the RDL file which reproduces the behavior? Which version of
Reporting Services are you using?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Hyper" <Hyper@.discussions.microsoft.com> wrote in message
news:1D2BF7D1-FE58-4280-BA9A-1F4699CF3619@.microsoft.com...
> I cannot delete the first report I created. The Server CPU goes to 100%
> utlisation and practically cripples the server (simple sql queries take
> forever). Eventually the delete operation times out. I have managed to
delete
> other reports with success. I see some other people are having the same
> problem. I have tried creating a report with the same name and overwriting
> but then the designer times out also when I try to deploy it over the old
> report.
> What sort of behaviour is this? A simple DELETE operation does not work!
Is
> this product fundamentally flawed or what?sql
utlisation and practically cripples the server (simple sql queries take
forever). Eventually the delete operation times out. I have managed to delete
other reports with success. I see some other people are having the same
problem. I have tried creating a report with the same name and overwriting
but then the designer times out also when I try to deploy it over the old
report.
What sort of behaviour is this? A simple DELETE operation does not work! Is
this product fundamentally flawed or what?Can you post the RDL file which reproduces the behavior? Which version of
Reporting Services are you using?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Hyper" <Hyper@.discussions.microsoft.com> wrote in message
news:1D2BF7D1-FE58-4280-BA9A-1F4699CF3619@.microsoft.com...
> I cannot delete the first report I created. The Server CPU goes to 100%
> utlisation and practically cripples the server (simple sql queries take
> forever). Eventually the delete operation times out. I have managed to
delete
> other reports with success. I see some other people are having the same
> problem. I have tried creating a report with the same name and overwriting
> but then the designer times out also when I try to deploy it over the old
> report.
> What sort of behaviour is this? A simple DELETE operation does not work!
Is
> this product fundamentally flawed or what?sql
Tuesday, March 20, 2012
Cannot create user on Report Server 2005
Hi, we installed SQL Server 2005 & Reporting Services on a box that had been
running 2000.
I launched the reports website.
When I try to do New System Role Assignment, I type in a domain user and
select a role and click OK, nothing at all happens. No error message, no
response, nothing.
Does anyone have any idea what might be going on?What I tend to do is create a local group and add my domain users to the
local group. Two things to try. Did you put the domain in front of the user?
I.e. MyDomain\Username
Second, are you in the local administrators group. Perhaps you don't have
rights to be doing this.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"RebeccaTS" <RebeccaTS@.discussions.microsoft.com> wrote in message
news:730D7944-B019-4E7A-8B9C-EA7EEB33486A@.microsoft.com...
> Hi, we installed SQL Server 2005 & Reporting Services on a box that had
> been
> running 2000.
> I launched the reports website.
> When I try to do New System Role Assignment, I type in a domain user and
> select a role and click OK, nothing at all happens. No error message, no
> response, nothing.
> Does anyone have any idea what might be going on?
running 2000.
I launched the reports website.
When I try to do New System Role Assignment, I type in a domain user and
select a role and click OK, nothing at all happens. No error message, no
response, nothing.
Does anyone have any idea what might be going on?What I tend to do is create a local group and add my domain users to the
local group. Two things to try. Did you put the domain in front of the user?
I.e. MyDomain\Username
Second, are you in the local administrators group. Perhaps you don't have
rights to be doing this.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"RebeccaTS" <RebeccaTS@.discussions.microsoft.com> wrote in message
news:730D7944-B019-4E7A-8B9C-EA7EEB33486A@.microsoft.com...
> Hi, we installed SQL Server 2005 & Reporting Services on a box that had
> been
> running 2000.
> I launched the reports website.
> When I try to do New System Role Assignment, I type in a domain user and
> select a role and click OK, nothing at all happens. No error message, no
> response, nothing.
> Does anyone have any idea what might be going on?
Cannot create subscriptions from Management Studio
I cannot create any subscriptions from Management Studio.
Reports have shared Data Source with stored credentials
SQL Agent is up and running
In surface area configuration "Scheduling and delivery" for SSRS are enabled
SSRS Execution account has been set up
E-mail settings are fine
I'm logged in as Admin, able to everything, but...
When I right-click on report/subscriptions folder, both "New subscription"
and "New data driven subscription" are DISABLED.
What's wrong? That's driving me crazy!
DmitryHello Dmitry,
I would like to know, when you try to use the Report Manager Via web
interface,
If you try to use the Report Manager via web and create the subscription,
what's the result?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:sOpkHyeGIHA.4268@.TK2MSFTNGHUB02.phx.gbl...
> Hello Dmitry,
> I would like to know, when you try to use the Report Manager Via web
> interface,
> If you try to use the Report Manager via web and create the subscription,
> what's the result?
I am using custom (forms) security and the admin can only log in through
Management Studio. For security purposes (this is internet-faced
application) no separate login pages for SSRS exist.
Regular users (authenticated and authorized) can see the reports inside web
application via ReportViewer control, which is getting the instance of
IReportServerCredentials.
Regards,
Dmitry|||Hello Dmitry,
Well, since you are using the form authentication, the management studio
may not connect to the reporting services correctly.
I would like to know whether the admin account you use have the proper
permission of reporting services.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:bIg%23C9rGIHA.4200@.TK2MSFTNGHUB02.phx.gbl...
> Hello Dmitry,
> Well, since you are using the form authentication, the management studio
> may not connect to the reporting services correctly.
> I would like to know whether the admin account you use have the proper
> permission of reporting services.
Yes, the admin is in any possible role. I already mentioned that in my
initial message. I'm able to do everything that's not subscriptions related.
Subscription-related menu items are simply disabled and I need to know why.
Dmitry.|||Hello Dmitry,
The admin you use is a domain account or a form authentication account?
Have you checked what's the role of this account on the reporting services?
Is it a System admin ?
Also, for the report, does it have the Manage all subscriptions permission?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:2rG$mH3GIHA.540@.TK2MSFTNGHUB02.phx.gbl...
> Hello Dmitry,
> The admin you use is a domain account or a form authentication account?
There's no such account technically. Admin is authenticated by
username/password inside forms security extension and after that it is given
unlimited access in any CheckAccess method...
> Have you checked what's the role of this account on the reporting
> services?
I answered this question already:
System User
System Administrator
Browser
Content Manager
Publisher
Report Builder
> Is it a System admin ?
Yes.
> Also, for the report, does it have the Manage all subscriptions
> permission?
Through Content Manager role, yes
As a matter of fact I have just installed the second instance of RS with
standard security and all the defaults. And I observe the same damn thing:
subscription related menu items are disabled in Management studio, but I can
create subscriptions using the same Windows credentials in the browser.
Which tells me the original issue may be not related to my custom security
extension at all.
Regards,
Dmitry|||Hello Dmitry,
Could you please let me know the config file content?
rsreportserver.config and RSWebApplication.config under the ReportManager
and Reporserver folder is appreicated.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:p$%23GYM5GIHA.5176@.TK2MSFTNGHUB02.phx.gbl...
> Hello Dmitry,
> Could you please let me know the config file content?
> rsreportserver.config and RSWebApplication.config under the ReportManager
> and Reporserver folder is appreicated.
E-mail delivery of those files failed. Please provide valid e-mail address.
The following message to <weilu@.online.microsoft.com> was undeliverable.
The reason for the problem:
5.1.2 - Bad destination host 'DNS Hard Error looking up online.microsoft.com
(MX): NXDomain'|||Hello Dmitry,
Please remove the ONLINE in my display email.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello Dmitry,
I get your email.
I would like to suggest you check the web services account you use.
Could you please change it to the network services?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:7mWE3N4HIHA.7444@.TK2MSFTNGHUB02.phx.gbl...
> Hello Dmitry,
> I get your email.
> I would like to suggest you check the web services account you use.
> Could you please change it to the network services?
Please advise WHERE EXACTLY this change to be made.
D.|||Hello Dmitry,
There is an element in the reportserver.config file:
<WebServiceAccount>NT Authority\NetworkService</WebServiceAccount>
Please modify it like this.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:R78DbCCIIHA.7444@.TK2MSFTNGHUB02.phx.gbl...
> Hello Dmitry,
> There is an element in the reportserver.config file:
> <WebServiceAccount>NT Authority\NetworkService</WebServiceAccount>
> Please modify it like this.
It is configured to be running as MYPCNAME\ASPNET
If I modify "like this" I'm getting the following message while trying to
navigate to any folder in Management Studio:
TITLE: Microsoft SQL Server Management Studio
--
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
--
ADDITIONAL INFORMATION:
The Report Server Web Service is unable to access secure information in the
report server. Please verify that the WebServiceAccount is specified
correctly in the report server config file. (rsAccessDeniedToSecureData)
(Report Services SOAP Proxy Source)
--
The Report Server Web Service is unable to access secure information in the
report server. Please verify that the WebServiceAccount is specified
correctly in the report server config file. (rsAccessDeniedToSecureData)
(Microsoft.ReportingServices.Diagnostics)
D.|||Hello Dmitry,
I am performing some test on my side. I appreciate your patience.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello Dima,
I would like to know whether you have applied the latest service pack of
sql server and have you stored the credential for the report.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:K1afiFOLIHA.6908@.TK2MSFTNGHUB02.phx.gbl...
> Hello Dima,
> I would like to know whether you have applied the latest service pack of
> sql server
It is 9.00.3054.00
> and have you stored the credential for the report.
There is no such thing as "stored credential for the report"
If you mean "stored credentials for the DATA SOURCE", yes that's the case.
Dmitry|||Hello Dmitry,
Could you lease send me an email and that I may involve other resources?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:j33I7UmMIHA.4380@.TK2MSFTNGHUB02.phx.gbl...
> Hello Dmitry,
> Could you lease send me an email and that I may involve other resources?
Wei,
I sent you the e-mail a week ago. Where are those "other resourses"?
D.|||Hello,
My colleague is Out of Office. Once he is back, I will escalate this issue.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.
Reports have shared Data Source with stored credentials
SQL Agent is up and running
In surface area configuration "Scheduling and delivery" for SSRS are enabled
SSRS Execution account has been set up
E-mail settings are fine
I'm logged in as Admin, able to everything, but...
When I right-click on report/subscriptions folder, both "New subscription"
and "New data driven subscription" are DISABLED.
What's wrong? That's driving me crazy!
DmitryHello Dmitry,
I would like to know, when you try to use the Report Manager Via web
interface,
If you try to use the Report Manager via web and create the subscription,
what's the result?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:sOpkHyeGIHA.4268@.TK2MSFTNGHUB02.phx.gbl...
> Hello Dmitry,
> I would like to know, when you try to use the Report Manager Via web
> interface,
> If you try to use the Report Manager via web and create the subscription,
> what's the result?
I am using custom (forms) security and the admin can only log in through
Management Studio. For security purposes (this is internet-faced
application) no separate login pages for SSRS exist.
Regular users (authenticated and authorized) can see the reports inside web
application via ReportViewer control, which is getting the instance of
IReportServerCredentials.
Regards,
Dmitry|||Hello Dmitry,
Well, since you are using the form authentication, the management studio
may not connect to the reporting services correctly.
I would like to know whether the admin account you use have the proper
permission of reporting services.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:bIg%23C9rGIHA.4200@.TK2MSFTNGHUB02.phx.gbl...
> Hello Dmitry,
> Well, since you are using the form authentication, the management studio
> may not connect to the reporting services correctly.
> I would like to know whether the admin account you use have the proper
> permission of reporting services.
Yes, the admin is in any possible role. I already mentioned that in my
initial message. I'm able to do everything that's not subscriptions related.
Subscription-related menu items are simply disabled and I need to know why.
Dmitry.|||Hello Dmitry,
The admin you use is a domain account or a form authentication account?
Have you checked what's the role of this account on the reporting services?
Is it a System admin ?
Also, for the report, does it have the Manage all subscriptions permission?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:2rG$mH3GIHA.540@.TK2MSFTNGHUB02.phx.gbl...
> Hello Dmitry,
> The admin you use is a domain account or a form authentication account?
There's no such account technically. Admin is authenticated by
username/password inside forms security extension and after that it is given
unlimited access in any CheckAccess method...
> Have you checked what's the role of this account on the reporting
> services?
I answered this question already:
System User
System Administrator
Browser
Content Manager
Publisher
Report Builder
> Is it a System admin ?
Yes.
> Also, for the report, does it have the Manage all subscriptions
> permission?
Through Content Manager role, yes
As a matter of fact I have just installed the second instance of RS with
standard security and all the defaults. And I observe the same damn thing:
subscription related menu items are disabled in Management studio, but I can
create subscriptions using the same Windows credentials in the browser.
Which tells me the original issue may be not related to my custom security
extension at all.
Regards,
Dmitry|||Hello Dmitry,
Could you please let me know the config file content?
rsreportserver.config and RSWebApplication.config under the ReportManager
and Reporserver folder is appreicated.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:p$%23GYM5GIHA.5176@.TK2MSFTNGHUB02.phx.gbl...
> Hello Dmitry,
> Could you please let me know the config file content?
> rsreportserver.config and RSWebApplication.config under the ReportManager
> and Reporserver folder is appreicated.
E-mail delivery of those files failed. Please provide valid e-mail address.
The following message to <weilu@.online.microsoft.com> was undeliverable.
The reason for the problem:
5.1.2 - Bad destination host 'DNS Hard Error looking up online.microsoft.com
(MX): NXDomain'|||Hello Dmitry,
Please remove the ONLINE in my display email.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello Dmitry,
I get your email.
I would like to suggest you check the web services account you use.
Could you please change it to the network services?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:7mWE3N4HIHA.7444@.TK2MSFTNGHUB02.phx.gbl...
> Hello Dmitry,
> I get your email.
> I would like to suggest you check the web services account you use.
> Could you please change it to the network services?
Please advise WHERE EXACTLY this change to be made.
D.|||Hello Dmitry,
There is an element in the reportserver.config file:
<WebServiceAccount>NT Authority\NetworkService</WebServiceAccount>
Please modify it like this.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:R78DbCCIIHA.7444@.TK2MSFTNGHUB02.phx.gbl...
> Hello Dmitry,
> There is an element in the reportserver.config file:
> <WebServiceAccount>NT Authority\NetworkService</WebServiceAccount>
> Please modify it like this.
It is configured to be running as MYPCNAME\ASPNET
If I modify "like this" I'm getting the following message while trying to
navigate to any folder in Management Studio:
TITLE: Microsoft SQL Server Management Studio
--
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
--
ADDITIONAL INFORMATION:
The Report Server Web Service is unable to access secure information in the
report server. Please verify that the WebServiceAccount is specified
correctly in the report server config file. (rsAccessDeniedToSecureData)
(Report Services SOAP Proxy Source)
--
The Report Server Web Service is unable to access secure information in the
report server. Please verify that the WebServiceAccount is specified
correctly in the report server config file. (rsAccessDeniedToSecureData)
(Microsoft.ReportingServices.Diagnostics)
D.|||Hello Dmitry,
I am performing some test on my side. I appreciate your patience.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello Dima,
I would like to know whether you have applied the latest service pack of
sql server and have you stored the credential for the report.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:K1afiFOLIHA.6908@.TK2MSFTNGHUB02.phx.gbl...
> Hello Dima,
> I would like to know whether you have applied the latest service pack of
> sql server
It is 9.00.3054.00
> and have you stored the credential for the report.
There is no such thing as "stored credential for the report"
If you mean "stored credentials for the DATA SOURCE", yes that's the case.
Dmitry|||Hello Dmitry,
Could you lease send me an email and that I may involve other resources?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:j33I7UmMIHA.4380@.TK2MSFTNGHUB02.phx.gbl...
> Hello Dmitry,
> Could you lease send me an email and that I may involve other resources?
Wei,
I sent you the e-mail a week ago. Where are those "other resourses"?
D.|||Hello,
My colleague is Out of Office. Once he is back, I will escalate this issue.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.
Cannot Create Subscription
Using RS Standard, SP2, I am prevented from creating a subscription on
reports that I am able to schedule for snapshots. The error message says
"Subscriptions cannot be created because the credentials used to run the
report are not stored, the report is using user-defined parameter values, or
if a linked report, the report is no longer valid." There are no linked
reports involved, and there are both report parameters and query parameters,
but all have supplied values or defaults. (Since a snapshot works fine, it
would seem that criteria for a subscription would be satisfied). This is a
major problem for my users who believe subscription delivery is an essential
feature. Please help!
--
Bob RogersThen the only part of the error message your response didn't cover is the
credentials... They must be stored securely in the database... Go to the
datasource, and you may set the connection stuff to be stored in the
database... Then subscriptions can be made.
--
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
"Bob Rogers" <BobRogers@.discussions.microsoft.com> wrote in message
news:1D97E909-7A7A-4617-ABF0-0610CF43B863@.microsoft.com...
> Using RS Standard, SP2, I am prevented from creating a subscription on
> reports that I am able to schedule for snapshots. The error message says
> "Subscriptions cannot be created because the credentials used to run the
> report are not stored, the report is using user-defined parameter values,
> or
> if a linked report, the report is no longer valid." There are no linked
> reports involved, and there are both report parameters and query
> parameters,
> but all have supplied values or defaults. (Since a snapshot works fine,
> it
> would seem that criteria for a subscription would be satisfied). This is
> a
> major problem for my users who believe subscription delivery is an
> essential
> feature. Please help!
> --
> Bob Rogers|||Thanks for your reply. The database credentials were good; the problem
turned out to be user id being included in the template for report footer --
user id is apparently considered a parameter.
--
Bob Rogers
"Wayne Snyder" wrote:
> Then the only part of the error message your response didn't cover is the
> credentials... They must be stored securely in the database... Go to the
> datasource, and you may set the connection stuff to be stored in the
> database... Then subscriptions can be made.
> --
> 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
> "Bob Rogers" <BobRogers@.discussions.microsoft.com> wrote in message
> news:1D97E909-7A7A-4617-ABF0-0610CF43B863@.microsoft.com...
> > Using RS Standard, SP2, I am prevented from creating a subscription on
> > reports that I am able to schedule for snapshots. The error message says
> > "Subscriptions cannot be created because the credentials used to run the
> > report are not stored, the report is using user-defined parameter values,
> > or
> > if a linked report, the report is no longer valid." There are no linked
> > reports involved, and there are both report parameters and query
> > parameters,
> > but all have supplied values or defaults. (Since a snapshot works fine,
> > it
> > would seem that criteria for a subscription would be satisfied). This is
> > a
> > major problem for my users who believe subscription delivery is an
> > essential
> > feature. Please help!
> > --
> > Bob Rogers
>
>
reports that I am able to schedule for snapshots. The error message says
"Subscriptions cannot be created because the credentials used to run the
report are not stored, the report is using user-defined parameter values, or
if a linked report, the report is no longer valid." There are no linked
reports involved, and there are both report parameters and query parameters,
but all have supplied values or defaults. (Since a snapshot works fine, it
would seem that criteria for a subscription would be satisfied). This is a
major problem for my users who believe subscription delivery is an essential
feature. Please help!
--
Bob RogersThen the only part of the error message your response didn't cover is the
credentials... They must be stored securely in the database... Go to the
datasource, and you may set the connection stuff to be stored in the
database... Then subscriptions can be made.
--
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
"Bob Rogers" <BobRogers@.discussions.microsoft.com> wrote in message
news:1D97E909-7A7A-4617-ABF0-0610CF43B863@.microsoft.com...
> Using RS Standard, SP2, I am prevented from creating a subscription on
> reports that I am able to schedule for snapshots. The error message says
> "Subscriptions cannot be created because the credentials used to run the
> report are not stored, the report is using user-defined parameter values,
> or
> if a linked report, the report is no longer valid." There are no linked
> reports involved, and there are both report parameters and query
> parameters,
> but all have supplied values or defaults. (Since a snapshot works fine,
> it
> would seem that criteria for a subscription would be satisfied). This is
> a
> major problem for my users who believe subscription delivery is an
> essential
> feature. Please help!
> --
> Bob Rogers|||Thanks for your reply. The database credentials were good; the problem
turned out to be user id being included in the template for report footer --
user id is apparently considered a parameter.
--
Bob Rogers
"Wayne Snyder" wrote:
> Then the only part of the error message your response didn't cover is the
> credentials... They must be stored securely in the database... Go to the
> datasource, and you may set the connection stuff to be stored in the
> database... Then subscriptions can be made.
> --
> 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
> "Bob Rogers" <BobRogers@.discussions.microsoft.com> wrote in message
> news:1D97E909-7A7A-4617-ABF0-0610CF43B863@.microsoft.com...
> > Using RS Standard, SP2, I am prevented from creating a subscription on
> > reports that I am able to schedule for snapshots. The error message says
> > "Subscriptions cannot be created because the credentials used to run the
> > report are not stored, the report is using user-defined parameter values,
> > or
> > if a linked report, the report is no longer valid." There are no linked
> > reports involved, and there are both report parameters and query
> > parameters,
> > but all have supplied values or defaults. (Since a snapshot works fine,
> > it
> > would seem that criteria for a subscription would be satisfied). This is
> > a
> > major problem for my users who believe subscription delivery is an
> > essential
> > feature. Please help!
> > --
> > Bob Rogers
>
>
Sunday, March 11, 2012
Cannot create compound unique index - server reports duplicate rows but there are none
Hi
I am using SQL Server 2000. I have a simple table (only 6 columns)
which currently contains a few hundred rows. There are two fields:
SupplierGroupID and RateAdjustmentDate, the combination of which
should never be repeated.
I am trying to create an index with these two fields specified and the
'Create Unique' box ticked, however, when I try to do this I get an
error saying that duplicate data was found.
There are no duplicates in the table. I have confirmed this by running
the SQL:
Select SupplierGroupID, RateAdjustmentDate, Count(SupplierGroupID)
from tblInvoiceRateAdjustment
Group By SupplierGroupID, RateAdjustmentID
All records report a count of 1.
I have tried this on two instances of SQL Server on two different
servers and get the same error with both.
Why is SQL Server reporting that this is duplicate data when there is
none?
TIA
Paul
Hi
http://dimantdatabasesolutions.blogspot.com/2007/02/dealing-with-duplicates.html
<pd_oflaherty@.hotmail.com> wrote in message
news:1172758648.458249.68170@.n33g2000cwc.googlegro ups.com...
> Hi
> I am using SQL Server 2000. I have a simple table (only 6 columns)
> which currently contains a few hundred rows. There are two fields:
> SupplierGroupID and RateAdjustmentDate, the combination of which
> should never be repeated.
> I am trying to create an index with these two fields specified and the
> 'Create Unique' box ticked, however, when I try to do this I get an
> error saying that duplicate data was found.
> There are no duplicates in the table. I have confirmed this by running
> the SQL:
> Select SupplierGroupID, RateAdjustmentDate, Count(SupplierGroupID)
> from tblInvoiceRateAdjustment
> Group By SupplierGroupID, RateAdjustmentID
> All records report a count of 1.
> I have tried this on two instances of SQL Server on two different
> servers and get the same error with both.
> Why is SQL Server reporting that this is duplicate data when there is
> none?
> TIA
> Paul
>
|||Thanks for posting but these links don't help me in this situation -
the issue is that there are NO duplicates of the field combination for
which I want to create a compound unique index.
I am certain there are no duplicates but still SQL will not allow the
index to be created.
On 1 Mar, 14:21, "Uri Dimant" <u...@.iscar.co.il> wrote:
> Hihttp://dimantdatabasesolutions.blogspot.com/2007/02/dealing-with-dupl...
> <pd_oflahe...@.hotmail.com> wrote in message
> news:1172758648.458249.68170@.n33g2000cwc.googlegro ups.com...
>
>
>
>
>
>
> - Show quoted text -
|||pd_oflaherty@.hotmail.com,
You should try:
Select SupplierGroupID, RateAdjustmentDate, Count(*)
from tblInvoiceRateAdjustment
Group By SupplierGroupID, RateAdjustmentDate
having count(*) > 1
go
AMB
"pd_oflaherty@.hotmail.com" wrote:
> Hi
> I am using SQL Server 2000. I have a simple table (only 6 columns)
> which currently contains a few hundred rows. There are two fields:
> SupplierGroupID and RateAdjustmentDate, the combination of which
> should never be repeated.
> I am trying to create an index with these two fields specified and the
> 'Create Unique' box ticked, however, when I try to do this I get an
> error saying that duplicate data was found.
> There are no duplicates in the table. I have confirmed this by running
> the SQL:
> Select SupplierGroupID, RateAdjustmentDate, Count(SupplierGroupID)
> from tblInvoiceRateAdjustment
> Group By SupplierGroupID, RateAdjustmentID
> All records report a count of 1.
> I have tried this on two instances of SQL Server on two different
> servers and get the same error with both.
> Why is SQL Server reporting that this is duplicate data when there is
> none?
> TIA
> Paul
>
|||Forget it - I'm being a numpty - there is a duplicate, just didn't see
it despite flagging with a count and repeated scrolling. I either need
new specs or a bigger screen!
On 1 Mar, 14:55, pd_oflahe...@.hotmail.com wrote:
> Thanks for posting but these links don't help me in this situation -
> the issue is that there are NO duplicates of the field combination for
> which I want to create acompounduniqueindex.
> I am certain there are no duplicates but still SQL will not allow theindexto be created.
> On 1 Mar, 14:21, "Uri Dimant" <u...@.iscar.co.il> wrote:
>
>
>
>
>
>
>
>
> - Show quoted text -
I am using SQL Server 2000. I have a simple table (only 6 columns)
which currently contains a few hundred rows. There are two fields:
SupplierGroupID and RateAdjustmentDate, the combination of which
should never be repeated.
I am trying to create an index with these two fields specified and the
'Create Unique' box ticked, however, when I try to do this I get an
error saying that duplicate data was found.
There are no duplicates in the table. I have confirmed this by running
the SQL:
Select SupplierGroupID, RateAdjustmentDate, Count(SupplierGroupID)
from tblInvoiceRateAdjustment
Group By SupplierGroupID, RateAdjustmentID
All records report a count of 1.
I have tried this on two instances of SQL Server on two different
servers and get the same error with both.
Why is SQL Server reporting that this is duplicate data when there is
none?
TIA
Paul
Hi
http://dimantdatabasesolutions.blogspot.com/2007/02/dealing-with-duplicates.html
<pd_oflaherty@.hotmail.com> wrote in message
news:1172758648.458249.68170@.n33g2000cwc.googlegro ups.com...
> Hi
> I am using SQL Server 2000. I have a simple table (only 6 columns)
> which currently contains a few hundred rows. There are two fields:
> SupplierGroupID and RateAdjustmentDate, the combination of which
> should never be repeated.
> I am trying to create an index with these two fields specified and the
> 'Create Unique' box ticked, however, when I try to do this I get an
> error saying that duplicate data was found.
> There are no duplicates in the table. I have confirmed this by running
> the SQL:
> Select SupplierGroupID, RateAdjustmentDate, Count(SupplierGroupID)
> from tblInvoiceRateAdjustment
> Group By SupplierGroupID, RateAdjustmentID
> All records report a count of 1.
> I have tried this on two instances of SQL Server on two different
> servers and get the same error with both.
> Why is SQL Server reporting that this is duplicate data when there is
> none?
> TIA
> Paul
>
|||Thanks for posting but these links don't help me in this situation -
the issue is that there are NO duplicates of the field combination for
which I want to create a compound unique index.
I am certain there are no duplicates but still SQL will not allow the
index to be created.
On 1 Mar, 14:21, "Uri Dimant" <u...@.iscar.co.il> wrote:
> Hihttp://dimantdatabasesolutions.blogspot.com/2007/02/dealing-with-dupl...
> <pd_oflahe...@.hotmail.com> wrote in message
> news:1172758648.458249.68170@.n33g2000cwc.googlegro ups.com...
>
>
>
>
>
>
> - Show quoted text -
|||pd_oflaherty@.hotmail.com,
You should try:
Select SupplierGroupID, RateAdjustmentDate, Count(*)
from tblInvoiceRateAdjustment
Group By SupplierGroupID, RateAdjustmentDate
having count(*) > 1
go
AMB
"pd_oflaherty@.hotmail.com" wrote:
> Hi
> I am using SQL Server 2000. I have a simple table (only 6 columns)
> which currently contains a few hundred rows. There are two fields:
> SupplierGroupID and RateAdjustmentDate, the combination of which
> should never be repeated.
> I am trying to create an index with these two fields specified and the
> 'Create Unique' box ticked, however, when I try to do this I get an
> error saying that duplicate data was found.
> There are no duplicates in the table. I have confirmed this by running
> the SQL:
> Select SupplierGroupID, RateAdjustmentDate, Count(SupplierGroupID)
> from tblInvoiceRateAdjustment
> Group By SupplierGroupID, RateAdjustmentID
> All records report a count of 1.
> I have tried this on two instances of SQL Server on two different
> servers and get the same error with both.
> Why is SQL Server reporting that this is duplicate data when there is
> none?
> TIA
> Paul
>
|||Forget it - I'm being a numpty - there is a duplicate, just didn't see
it despite flagging with a count and repeated scrolling. I either need
new specs or a bigger screen!
On 1 Mar, 14:55, pd_oflahe...@.hotmail.com wrote:
> Thanks for posting but these links don't help me in this situation -
> the issue is that there are NO duplicates of the field combination for
> which I want to create acompounduniqueindex.
> I am certain there are no duplicates but still SQL will not allow theindexto be created.
> On 1 Mar, 14:21, "Uri Dimant" <u...@.iscar.co.il> wrote:
>
>
>
>
>
>
>
>
> - Show quoted text -
Cannot create compound unique index - server reports duplicate rows but there are none
Hi
I am using SQL Server 2000. I have a simple table (only 6 columns)
which currently contains a few hundred rows. There are two fields:
SupplierGroupID and RateAdjustmentDate, the combination of which
should never be repeated.
I am trying to create an index with these two fields specified and the
'Create Unique' box ticked, however, when I try to do this I get an
error saying that duplicate data was found.
There are no duplicates in the table. I have confirmed this by running
the SQL:
Select SupplierGroupID, RateAdjustmentDate, Count(SupplierGroupID)
from tblInvoiceRateAdjustment
Group By SupplierGroupID, RateAdjustmentID
All records report a count of 1.
I have tried this on two instances of SQL Server on two different
servers and get the same error with both.
Why is SQL Server reporting that this is duplicate data when there is
none?
TIA
PaulHi
http://dimantdatabasesolutions.blogspot.com/2007/02/dealing-with-duplicates.html
<pd_oflaherty@.hotmail.com> wrote in message
news:1172758648.458249.68170@.n33g2000cwc.googlegroups.com...
> Hi
> I am using SQL Server 2000. I have a simple table (only 6 columns)
> which currently contains a few hundred rows. There are two fields:
> SupplierGroupID and RateAdjustmentDate, the combination of which
> should never be repeated.
> I am trying to create an index with these two fields specified and the
> 'Create Unique' box ticked, however, when I try to do this I get an
> error saying that duplicate data was found.
> There are no duplicates in the table. I have confirmed this by running
> the SQL:
> Select SupplierGroupID, RateAdjustmentDate, Count(SupplierGroupID)
> from tblInvoiceRateAdjustment
> Group By SupplierGroupID, RateAdjustmentID
> All records report a count of 1.
> I have tried this on two instances of SQL Server on two different
> servers and get the same error with both.
> Why is SQL Server reporting that this is duplicate data when there is
> none?
> TIA
> Paul
>|||Thanks for posting but these links don't help me in this situation -
the issue is that there are NO duplicates of the field combination for
which I want to create a compound unique index.
I am certain there are no duplicates but still SQL will not allow the
index to be created.
On 1 Mar, 14:21, "Uri Dimant" <u...@.iscar.co.il> wrote:
> Hihttp://dimantdatabasesolutions.blogspot.com/2007/02/dealing-with-dupl...
> <pd_oflahe...@.hotmail.com> wrote in message
> news:1172758648.458249.68170@.n33g2000cwc.googlegroups.com...
>
> > Hi
> > I am using SQL Server 2000. I have a simple table (only 6 columns)
> > which currently contains a few hundred rows. There are two fields:
> > SupplierGroupID and RateAdjustmentDate, the combination of which
> > should never be repeated.
> > I am trying to create an index with these two fields specified and the
> > 'Create Unique' box ticked, however, when I try to do this I get an
> > error saying that duplicate data was found.
> > There are no duplicates in the table. I have confirmed this by running
> > the SQL:
> > Select SupplierGroupID, RateAdjustmentDate, Count(SupplierGroupID)
> > from tblInvoiceRateAdjustment
> > Group By SupplierGroupID, RateAdjustmentID
> > All records report a count of 1.
> > I have tried this on two instances of SQL Server on two different
> > servers and get the same error with both.
> > Why is SQL Server reporting that this is duplicate data when there is
> > none?
> > TIA
> > Paul- Hide quoted text -
> - Show quoted text -|||pd_oflaherty@.hotmail.com,
You should try:
Select SupplierGroupID, RateAdjustmentDate, Count(*)
from tblInvoiceRateAdjustment
Group By SupplierGroupID, RateAdjustmentDate
having count(*) > 1
go
AMB
"pd_oflaherty@.hotmail.com" wrote:
> Hi
> I am using SQL Server 2000. I have a simple table (only 6 columns)
> which currently contains a few hundred rows. There are two fields:
> SupplierGroupID and RateAdjustmentDate, the combination of which
> should never be repeated.
> I am trying to create an index with these two fields specified and the
> 'Create Unique' box ticked, however, when I try to do this I get an
> error saying that duplicate data was found.
> There are no duplicates in the table. I have confirmed this by running
> the SQL:
> Select SupplierGroupID, RateAdjustmentDate, Count(SupplierGroupID)
> from tblInvoiceRateAdjustment
> Group By SupplierGroupID, RateAdjustmentID
> All records report a count of 1.
> I have tried this on two instances of SQL Server on two different
> servers and get the same error with both.
> Why is SQL Server reporting that this is duplicate data when there is
> none?
> TIA
> Paul
>|||Forget it - I'm being a numpty - there is a duplicate, just didn't see
it despite flagging with a count and repeated scrolling. I either need
new specs or a bigger screen!
On 1 Mar, 14:55, pd_oflahe...@.hotmail.com wrote:
> Thanks for posting but these links don't help me in this situation -
> the issue is that there are NO duplicates of the field combination for
> which I want to create acompounduniqueindex.
> I am certain there are no duplicates but still SQL will not allow theindexto be created.
> On 1 Mar, 14:21, "Uri Dimant" <u...@.iscar.co.il> wrote:
>
> > Hihttp://dimantdatabasesolutions.blogspot.com/2007/02/dealing-with-dupl...
> > <pd_oflahe...@.hotmail.com> wrote in message
> >news:1172758648.458249.68170@.n33g2000cwc.googlegroups.com...
> > > Hi
> > > I am using SQL Server 2000. I have a simple table (only 6 columns)
> > > which currently contains a few hundred rows. There are two fields:
> > > SupplierGroupID and RateAdjustmentDate, the combination of which
> > > should never be repeated.
> > > I am trying to create an index with these two fields specified and the
> > > 'Create Unique' box ticked, however, when I try to do this I get an
> > > error saying that duplicate data was found.
> > > There are no duplicates in the table. I have confirmed this by running
> > > the SQL:
> > > Select SupplierGroupID, RateAdjustmentDate, Count(SupplierGroupID)
> > > from tblInvoiceRateAdjustment
> > > Group By SupplierGroupID, RateAdjustmentID
> > > All records report a count of 1.
> > > I have tried this on two instances of SQL Server on two different
> > > servers and get the same error with both.
> > > Why is SQL Server reporting that this is duplicate data when there is
> > > none?
> > > TIA
> > > Paul- Hide quoted text -
> > - Show quoted text -- Hide quoted text -
> - Show quoted text -
I am using SQL Server 2000. I have a simple table (only 6 columns)
which currently contains a few hundred rows. There are two fields:
SupplierGroupID and RateAdjustmentDate, the combination of which
should never be repeated.
I am trying to create an index with these two fields specified and the
'Create Unique' box ticked, however, when I try to do this I get an
error saying that duplicate data was found.
There are no duplicates in the table. I have confirmed this by running
the SQL:
Select SupplierGroupID, RateAdjustmentDate, Count(SupplierGroupID)
from tblInvoiceRateAdjustment
Group By SupplierGroupID, RateAdjustmentID
All records report a count of 1.
I have tried this on two instances of SQL Server on two different
servers and get the same error with both.
Why is SQL Server reporting that this is duplicate data when there is
none?
TIA
PaulHi
http://dimantdatabasesolutions.blogspot.com/2007/02/dealing-with-duplicates.html
<pd_oflaherty@.hotmail.com> wrote in message
news:1172758648.458249.68170@.n33g2000cwc.googlegroups.com...
> Hi
> I am using SQL Server 2000. I have a simple table (only 6 columns)
> which currently contains a few hundred rows. There are two fields:
> SupplierGroupID and RateAdjustmentDate, the combination of which
> should never be repeated.
> I am trying to create an index with these two fields specified and the
> 'Create Unique' box ticked, however, when I try to do this I get an
> error saying that duplicate data was found.
> There are no duplicates in the table. I have confirmed this by running
> the SQL:
> Select SupplierGroupID, RateAdjustmentDate, Count(SupplierGroupID)
> from tblInvoiceRateAdjustment
> Group By SupplierGroupID, RateAdjustmentID
> All records report a count of 1.
> I have tried this on two instances of SQL Server on two different
> servers and get the same error with both.
> Why is SQL Server reporting that this is duplicate data when there is
> none?
> TIA
> Paul
>|||Thanks for posting but these links don't help me in this situation -
the issue is that there are NO duplicates of the field combination for
which I want to create a compound unique index.
I am certain there are no duplicates but still SQL will not allow the
index to be created.
On 1 Mar, 14:21, "Uri Dimant" <u...@.iscar.co.il> wrote:
> Hihttp://dimantdatabasesolutions.blogspot.com/2007/02/dealing-with-dupl...
> <pd_oflahe...@.hotmail.com> wrote in message
> news:1172758648.458249.68170@.n33g2000cwc.googlegroups.com...
>
> > Hi
> > I am using SQL Server 2000. I have a simple table (only 6 columns)
> > which currently contains a few hundred rows. There are two fields:
> > SupplierGroupID and RateAdjustmentDate, the combination of which
> > should never be repeated.
> > I am trying to create an index with these two fields specified and the
> > 'Create Unique' box ticked, however, when I try to do this I get an
> > error saying that duplicate data was found.
> > There are no duplicates in the table. I have confirmed this by running
> > the SQL:
> > Select SupplierGroupID, RateAdjustmentDate, Count(SupplierGroupID)
> > from tblInvoiceRateAdjustment
> > Group By SupplierGroupID, RateAdjustmentID
> > All records report a count of 1.
> > I have tried this on two instances of SQL Server on two different
> > servers and get the same error with both.
> > Why is SQL Server reporting that this is duplicate data when there is
> > none?
> > TIA
> > Paul- Hide quoted text -
> - Show quoted text -|||pd_oflaherty@.hotmail.com,
You should try:
Select SupplierGroupID, RateAdjustmentDate, Count(*)
from tblInvoiceRateAdjustment
Group By SupplierGroupID, RateAdjustmentDate
having count(*) > 1
go
AMB
"pd_oflaherty@.hotmail.com" wrote:
> Hi
> I am using SQL Server 2000. I have a simple table (only 6 columns)
> which currently contains a few hundred rows. There are two fields:
> SupplierGroupID and RateAdjustmentDate, the combination of which
> should never be repeated.
> I am trying to create an index with these two fields specified and the
> 'Create Unique' box ticked, however, when I try to do this I get an
> error saying that duplicate data was found.
> There are no duplicates in the table. I have confirmed this by running
> the SQL:
> Select SupplierGroupID, RateAdjustmentDate, Count(SupplierGroupID)
> from tblInvoiceRateAdjustment
> Group By SupplierGroupID, RateAdjustmentID
> All records report a count of 1.
> I have tried this on two instances of SQL Server on two different
> servers and get the same error with both.
> Why is SQL Server reporting that this is duplicate data when there is
> none?
> TIA
> Paul
>|||Forget it - I'm being a numpty - there is a duplicate, just didn't see
it despite flagging with a count and repeated scrolling. I either need
new specs or a bigger screen!
On 1 Mar, 14:55, pd_oflahe...@.hotmail.com wrote:
> Thanks for posting but these links don't help me in this situation -
> the issue is that there are NO duplicates of the field combination for
> which I want to create acompounduniqueindex.
> I am certain there are no duplicates but still SQL will not allow theindexto be created.
> On 1 Mar, 14:21, "Uri Dimant" <u...@.iscar.co.il> wrote:
>
> > Hihttp://dimantdatabasesolutions.blogspot.com/2007/02/dealing-with-dupl...
> > <pd_oflahe...@.hotmail.com> wrote in message
> >news:1172758648.458249.68170@.n33g2000cwc.googlegroups.com...
> > > Hi
> > > I am using SQL Server 2000. I have a simple table (only 6 columns)
> > > which currently contains a few hundred rows. There are two fields:
> > > SupplierGroupID and RateAdjustmentDate, the combination of which
> > > should never be repeated.
> > > I am trying to create an index with these two fields specified and the
> > > 'Create Unique' box ticked, however, when I try to do this I get an
> > > error saying that duplicate data was found.
> > > There are no duplicates in the table. I have confirmed this by running
> > > the SQL:
> > > Select SupplierGroupID, RateAdjustmentDate, Count(SupplierGroupID)
> > > from tblInvoiceRateAdjustment
> > > Group By SupplierGroupID, RateAdjustmentID
> > > All records report a count of 1.
> > > I have tried this on two instances of SQL Server on two different
> > > servers and get the same error with both.
> > > Why is SQL Server reporting that this is duplicate data when there is
> > > none?
> > > TIA
> > > Paul- Hide quoted text -
> > - Show quoted text -- Hide quoted text -
> - Show quoted text -
Cannot create compound unique index - server reports duplicate rows but there are none
Hi
I am using SQL Server 2000. I have a simple table (only 6 columns)
which currently contains a few hundred rows. There are two fields:
SupplierGroupID and RateAdjustmentDate, the combination of which
should never be repeated.
I am trying to create an index with these two fields specified and the
'Create Unique' box ticked, however, when I try to do this I get an
error saying that duplicate data was found.
There are no duplicates in the table. I have confirmed this by running
the SQL:
Select SupplierGroupID, RateAdjustmentDate, Count(SupplierGroupID)
from tblInvoiceRateAdjustment
Group By SupplierGroupID, RateAdjustmentID
All records report a count of 1.
I have tried this on two instances of SQL Server on two different
servers and get the same error with both.
Why is SQL Server reporting that this is duplicate data when there is
none?
TIA
PaulHi
[url]http://dimantdatabasesolutions.blogspot.com/2007/02/dealing-with-duplicates.html[/
url]
<pd_oflaherty@.hotmail.com> wrote in message
news:1172758648.458249.68170@.n33g2000cwc.googlegroups.com...
> Hi
> I am using SQL Server 2000. I have a simple table (only 6 columns)
> which currently contains a few hundred rows. There are two fields:
> SupplierGroupID and RateAdjustmentDate, the combination of which
> should never be repeated.
> I am trying to create an index with these two fields specified and the
> 'Create Unique' box ticked, however, when I try to do this I get an
> error saying that duplicate data was found.
> There are no duplicates in the table. I have confirmed this by running
> the SQL:
> Select SupplierGroupID, RateAdjustmentDate, Count(SupplierGroupID)
> from tblInvoiceRateAdjustment
> Group By SupplierGroupID, RateAdjustmentID
> All records report a count of 1.
> I have tried this on two instances of SQL Server on two different
> servers and get the same error with both.
> Why is SQL Server reporting that this is duplicate data when there is
> none?
> TIA
> Paul
>|||Thanks for posting but these links don't help me in this situation -
the issue is that there are NO duplicates of the field combination for
which I want to create a compound unique index.
I am certain there are no duplicates but still SQL will not allow the
index to be created.
On 1 Mar, 14:21, "Uri Dimant" <u...@.iscar.co.il> wrote:
> Hihttp://dimantdatabasesolutions.blogspot.com/2007/02/dealing-with-dupl...
> <pd_oflahe...@.hotmail.com> wrote in message
> news:1172758648.458249.68170@.n33g2000cwc.googlegroups.com...
>
>
>
>
>
>
>
>
>
>
> - Show quoted text -|||Forget it - I'm being a numpty - there is a duplicate, just didn't see
it despite flagging with a count and repeated scrolling. I either need
new specs or a bigger screen!
On 1 Mar, 14:55, pd_oflahe...@.hotmail.com wrote:
> Thanks for posting but these links don't help me in this situation -
> the issue is that there are NO duplicates of the field combination for
> which I want to create acompounduniqueindex.
> I am certain there are no duplicates but still SQL will not allow theindex
to be created.
> On 1 Mar, 14:21, "Uri Dimant" <u...@.iscar.co.il> wrote:
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> - Show quoted text -
I am using SQL Server 2000. I have a simple table (only 6 columns)
which currently contains a few hundred rows. There are two fields:
SupplierGroupID and RateAdjustmentDate, the combination of which
should never be repeated.
I am trying to create an index with these two fields specified and the
'Create Unique' box ticked, however, when I try to do this I get an
error saying that duplicate data was found.
There are no duplicates in the table. I have confirmed this by running
the SQL:
Select SupplierGroupID, RateAdjustmentDate, Count(SupplierGroupID)
from tblInvoiceRateAdjustment
Group By SupplierGroupID, RateAdjustmentID
All records report a count of 1.
I have tried this on two instances of SQL Server on two different
servers and get the same error with both.
Why is SQL Server reporting that this is duplicate data when there is
none?
TIA
PaulHi
[url]http://dimantdatabasesolutions.blogspot.com/2007/02/dealing-with-duplicates.html[/
url]
<pd_oflaherty@.hotmail.com> wrote in message
news:1172758648.458249.68170@.n33g2000cwc.googlegroups.com...
> Hi
> I am using SQL Server 2000. I have a simple table (only 6 columns)
> which currently contains a few hundred rows. There are two fields:
> SupplierGroupID and RateAdjustmentDate, the combination of which
> should never be repeated.
> I am trying to create an index with these two fields specified and the
> 'Create Unique' box ticked, however, when I try to do this I get an
> error saying that duplicate data was found.
> There are no duplicates in the table. I have confirmed this by running
> the SQL:
> Select SupplierGroupID, RateAdjustmentDate, Count(SupplierGroupID)
> from tblInvoiceRateAdjustment
> Group By SupplierGroupID, RateAdjustmentID
> All records report a count of 1.
> I have tried this on two instances of SQL Server on two different
> servers and get the same error with both.
> Why is SQL Server reporting that this is duplicate data when there is
> none?
> TIA
> Paul
>|||Thanks for posting but these links don't help me in this situation -
the issue is that there are NO duplicates of the field combination for
which I want to create a compound unique index.
I am certain there are no duplicates but still SQL will not allow the
index to be created.
On 1 Mar, 14:21, "Uri Dimant" <u...@.iscar.co.il> wrote:
> Hihttp://dimantdatabasesolutions.blogspot.com/2007/02/dealing-with-dupl...
> <pd_oflahe...@.hotmail.com> wrote in message
> news:1172758648.458249.68170@.n33g2000cwc.googlegroups.com...
>
>
>
>
>
>
>
>
>
>
> - Show quoted text -|||Forget it - I'm being a numpty - there is a duplicate, just didn't see
it despite flagging with a count and repeated scrolling. I either need
new specs or a bigger screen!
On 1 Mar, 14:55, pd_oflahe...@.hotmail.com wrote:
> Thanks for posting but these links don't help me in this situation -
> the issue is that there are NO duplicates of the field combination for
> which I want to create acompounduniqueindex.
> I am certain there are no duplicates but still SQL will not allow theindex
to be created.
> On 1 Mar, 14:21, "Uri Dimant" <u...@.iscar.co.il> wrote:
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> - Show quoted text -
Cannot create an instance of OLE DB Provider "MSDAC"
Hey Guys,
I'm trying to query a couple of Excel 2007 spreadsheets for some reports
using OpenDataSource in my query to pull in the data.
Everything is find with the preview inside the IDE, but when I deploy my
report I recieve the following error:
An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for data set 'Regression'.
(rsErrorExecutingCommand)
Cannot create an instance of OLE DB provider "MSDASC" for linked
server "(null)".
I've installed 2007 Data Connectivity Components on the report server and
this allowed me to query the data while developing. I'm at a loss why this is
not working after I deploy.
The SQL I'm using to query the data is:
SELECT *
FROM OPENDATASOURCE('Microsoft.ACE.OLEDB.12.0',
'Data Source="\\server\document.xlsm";Extended Properties="Excel 12.0
Macro;HDR=YES"')...Sheet1$
Any ideas/suggestions?My guess if this works in development and not in deployment that it has to
do with file security. The report is executed under a different user account
and that account doesn't have rights to the folder where the Excel data
resides. Just a guess because I have never done this.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"shaggydog" <shaggydog@.discussions.microsoft.com> wrote in message
news:55853C99-FB58-422B-8FB7-EECD3EF37715@.microsoft.com...
> Hey Guys,
> I'm trying to query a couple of Excel 2007 spreadsheets for some reports
> using OpenDataSource in my query to pull in the data.
> Everything is find with the preview inside the IDE, but when I deploy my
> report I recieve the following error:
> An error has occurred during report processing. (rsProcessingAborted)
> Query execution failed for data set 'Regression'.
> (rsErrorExecutingCommand)
> Cannot create an instance of OLE DB provider "MSDASC" for linked
> server "(null)".
> I've installed 2007 Data Connectivity Components on the report server and
> this allowed me to query the data while developing. I'm at a loss why this
> is
> not working after I deploy.
> The SQL I'm using to query the data is:
> SELECT *
> FROM OPENDATASOURCE('Microsoft.ACE.OLEDB.12.0',
> 'Data Source="\\server\document.xlsm";Extended Properties="Excel 12.0
> Macro;HDR=YES"')...Sheet1$
>
> Any ideas/suggestions?
>|||Thanks for your response, while not directly related to file security, it was
a security problem. Here's what I did to solve my problem in case anyone
comes across this thread in the future...
I was using a shared data source which connected using windows
authentication. No matter how I tweaked and fiddled around I could not get
windows authentication to work.
So I setup a SQL account with limited rights. Then provided me with a new
error message stating:
Ad hoc access to OLE DB provider 'Microsoft.ACE.OLEDB.12.0' has been denied.
You must access this provider through a linked server.
While I have Ad hoc access enabled via Surface Configuration, it would not
allow me to perform an ad hoc query if the user account wasn't a sysadmin to
the SQL Server. Ugh!
I played around with tweaking the DisallowAdhocAccess registry setting for
the provider, but I didn't find a way to allow non-sysadmin accounts the
ability to perform ad hoc queries.
In the end using a SQL authentication with a sysadmin account allowed
OpenDataSource to pull in the external data.
For what it's worth....
"Bruce L-C [MVP]" wrote:
> My guess if this works in development and not in deployment that it has to
> do with file security. The report is executed under a different user account
> and that account doesn't have rights to the folder where the Excel data
> resides. Just a guess because I have never done this.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "shaggydog" <shaggydog@.discussions.microsoft.com> wrote in message
> news:55853C99-FB58-422B-8FB7-EECD3EF37715@.microsoft.com...
> > Hey Guys,
> >
> > I'm trying to query a couple of Excel 2007 spreadsheets for some reports
> > using OpenDataSource in my query to pull in the data.
> >
> > Everything is find with the preview inside the IDE, but when I deploy my
> > report I recieve the following error:
> >
> > An error has occurred during report processing. (rsProcessingAborted)
> > Query execution failed for data set 'Regression'.
> > (rsErrorExecutingCommand)
> > Cannot create an instance of OLE DB provider "MSDASC" for linked
> > server "(null)".
> >
> > I've installed 2007 Data Connectivity Components on the report server and
> > this allowed me to query the data while developing. I'm at a loss why this
> > is
> > not working after I deploy.
> >
> > The SQL I'm using to query the data is:
> > SELECT *
> > FROM OPENDATASOURCE('Microsoft.ACE.OLEDB.12.0',
> > 'Data Source="\\server\document.xlsm";Extended Properties="Excel 12.0
> > Macro;HDR=YES"')...Sheet1$
> >
> >
> > Any ideas/suggestions?
> >
>
>
I'm trying to query a couple of Excel 2007 spreadsheets for some reports
using OpenDataSource in my query to pull in the data.
Everything is find with the preview inside the IDE, but when I deploy my
report I recieve the following error:
An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for data set 'Regression'.
(rsErrorExecutingCommand)
Cannot create an instance of OLE DB provider "MSDASC" for linked
server "(null)".
I've installed 2007 Data Connectivity Components on the report server and
this allowed me to query the data while developing. I'm at a loss why this is
not working after I deploy.
The SQL I'm using to query the data is:
SELECT *
FROM OPENDATASOURCE('Microsoft.ACE.OLEDB.12.0',
'Data Source="\\server\document.xlsm";Extended Properties="Excel 12.0
Macro;HDR=YES"')...Sheet1$
Any ideas/suggestions?My guess if this works in development and not in deployment that it has to
do with file security. The report is executed under a different user account
and that account doesn't have rights to the folder where the Excel data
resides. Just a guess because I have never done this.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"shaggydog" <shaggydog@.discussions.microsoft.com> wrote in message
news:55853C99-FB58-422B-8FB7-EECD3EF37715@.microsoft.com...
> Hey Guys,
> I'm trying to query a couple of Excel 2007 spreadsheets for some reports
> using OpenDataSource in my query to pull in the data.
> Everything is find with the preview inside the IDE, but when I deploy my
> report I recieve the following error:
> An error has occurred during report processing. (rsProcessingAborted)
> Query execution failed for data set 'Regression'.
> (rsErrorExecutingCommand)
> Cannot create an instance of OLE DB provider "MSDASC" for linked
> server "(null)".
> I've installed 2007 Data Connectivity Components on the report server and
> this allowed me to query the data while developing. I'm at a loss why this
> is
> not working after I deploy.
> The SQL I'm using to query the data is:
> SELECT *
> FROM OPENDATASOURCE('Microsoft.ACE.OLEDB.12.0',
> 'Data Source="\\server\document.xlsm";Extended Properties="Excel 12.0
> Macro;HDR=YES"')...Sheet1$
>
> Any ideas/suggestions?
>|||Thanks for your response, while not directly related to file security, it was
a security problem. Here's what I did to solve my problem in case anyone
comes across this thread in the future...
I was using a shared data source which connected using windows
authentication. No matter how I tweaked and fiddled around I could not get
windows authentication to work.
So I setup a SQL account with limited rights. Then provided me with a new
error message stating:
Ad hoc access to OLE DB provider 'Microsoft.ACE.OLEDB.12.0' has been denied.
You must access this provider through a linked server.
While I have Ad hoc access enabled via Surface Configuration, it would not
allow me to perform an ad hoc query if the user account wasn't a sysadmin to
the SQL Server. Ugh!
I played around with tweaking the DisallowAdhocAccess registry setting for
the provider, but I didn't find a way to allow non-sysadmin accounts the
ability to perform ad hoc queries.
In the end using a SQL authentication with a sysadmin account allowed
OpenDataSource to pull in the external data.
For what it's worth....
"Bruce L-C [MVP]" wrote:
> My guess if this works in development and not in deployment that it has to
> do with file security. The report is executed under a different user account
> and that account doesn't have rights to the folder where the Excel data
> resides. Just a guess because I have never done this.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "shaggydog" <shaggydog@.discussions.microsoft.com> wrote in message
> news:55853C99-FB58-422B-8FB7-EECD3EF37715@.microsoft.com...
> > Hey Guys,
> >
> > I'm trying to query a couple of Excel 2007 spreadsheets for some reports
> > using OpenDataSource in my query to pull in the data.
> >
> > Everything is find with the preview inside the IDE, but when I deploy my
> > report I recieve the following error:
> >
> > An error has occurred during report processing. (rsProcessingAborted)
> > Query execution failed for data set 'Regression'.
> > (rsErrorExecutingCommand)
> > Cannot create an instance of OLE DB provider "MSDASC" for linked
> > server "(null)".
> >
> > I've installed 2007 Data Connectivity Components on the report server and
> > this allowed me to query the data while developing. I'm at a loss why this
> > is
> > not working after I deploy.
> >
> > The SQL I'm using to query the data is:
> > SELECT *
> > FROM OPENDATASOURCE('Microsoft.ACE.OLEDB.12.0',
> > 'Data Source="\\server\document.xlsm";Extended Properties="Excel 12.0
> > Macro;HDR=YES"')...Sheet1$
> >
> >
> > Any ideas/suggestions?
> >
>
>
Thursday, March 8, 2012
Cannot create a report - VS 2005/SQL 2005
I cannot seem to create a Report based on an SQL Server 2005 database. The
IDE and the database server are on the same machine. The reports server is
installed and running. During both installations (VS and SQL Server 2005 ) I opted for the complete install.
I create a reports project - when I right click the reports folder and select
Add New Item > Report - nothing happens.
When I invoke the Report wizard and continue till the last step - pressing
finish generates the following exception :
at Microsoft.DataWarehouse.VsIntegration.Shell.Project.FileProjectHierarchy.OnHierarchyNodeAppending(IHierarchyNode
node, IHierarchyNode parentNode)
at Microsoft.DataWarehouse.VsIntegration.Hierarchy.Hierarchy.Add(IHierarchyNode
node, IHierarchyNode parentNode)
at Microsoft.DataWarehouse.VsIntegration.Shell.Project.FileProjectHierarchy.AddExistingFileToProject(IFileProjectNode&
parentNode, String name, String fullPath, VSADDITEMOPERATION dwAddItemOperation)
at Microsoft.DataWarehouse.VsIntegration.Shell.Project.Extensibility.ProjectItemsExt.AddFromFile(String
FileName)
at Microsoft.ReportDesigner.Wizards.ReportWizardForm.OnFinish(CancelEventArgs
e)
I have Refactor installed ! However, report creation generates an error even when there is only a BI project in the solution and no VB project.
Sumeet|||
However, on another machine and with the exactly the same stuff intalled VS2005/SQL 2005 without refactor pro - I have exactly the same problem in creating BI projects.
Sumeet|||
in my case 2 pc's are now fixed!!! Great!!!!|||
I have the same problem.
can you point me to the URL of the Refactor 1.0.30 to download
thanks
"Error 1001: The SavedState Dictionary contains inconsistent
IDE and the database server are on the same machine. The reports server is
installed and running. During both installations (VS and SQL Server 2005 ) I opted for the complete install.
I create a reports project - when I right click the reports folder and select
Add New Item > Report - nothing happens.
When I invoke the Report wizard and continue till the last step - pressing
finish generates the following exception :
===================================
Exception of type 'System.Runtime.InteropServices.COMException' was thrown. (Microsoft Visual Studio)
Program Location:at Microsoft.DataWarehouse.VsIntegration.Shell.Project.FileProjectHierarchy.OnHierarchyNodeAppending(IHierarchyNode
node, IHierarchyNode parentNode)
at Microsoft.DataWarehouse.VsIntegration.Hierarchy.Hierarchy.Add(IHierarchyNode
node, IHierarchyNode parentNode)
at Microsoft.DataWarehouse.VsIntegration.Shell.Project.FileProjectHierarchy.AddExistingFileToProject(IFileProjectNode&
parentNode, String name, String fullPath, VSADDITEMOPERATION dwAddItemOperation)
at Microsoft.DataWarehouse.VsIntegration.Shell.Project.Extensibility.ProjectItemsExt.AddFromFile(String
FileName)
at Microsoft.ReportDesigner.Wizards.ReportWizardForm.OnFinish(CancelEventArgs
e)
Is anyone else having the same problem?
Any help will be appreciated.
Thanks
Sumeetsame error here.... anyone got a work around or a fix?|||
We are currently investigating a conflict with DevExpress Refactor. Do you have Refactor! installed? Do you work with VB projects and BI projects in the same instance of VS? Once Refactor! has been loaded into VS, any attempt to add files to a BI project will fail. The workaround is to work with BI projects and VB projects in separate instances of VS.
-Albert
|||Hi Albert,I have Refactor installed ! However, report creation generates an error even when there is only a BI project in the solution and no VB project.
Sumeet|||
A new version of Refactor! (1.0.30, 12/7/2005) is available which may fix the problem. Give it a try.
-Albert
|||Will do.However, on another machine and with the exactly the same stuff intalled VS2005/SQL 2005 without refactor pro - I have exactly the same problem in creating BI projects.
Sumeet|||
Albert Yen - MS wrote:
We are currently investigating a conflict with DevExpress Refactor. Do you have Refactor! installed? Do you work with VB projects and BI projects in the same instance of VS? Once Refactor! has been loaded into VS, any attempt to add files to a BI project will fail. The workaround is to work with BI projects and VB projects in separate instances of VS.
-Albert
I will check this out as I also have Refactor! installed.
the behavior matches my problem, adding new files is the failure point.
what A pain!
I was thinking it was Team Related ( Version contol etc...) but I shall see.|||
We are currently investigating a conflict with DevExpress Refactor. Do you have Refactor! installed? Do you work with VB projects and BI projects in the same instance of VS? Once Refactor! has been loaded into VS, any attempt to add files to a BI project will fail. The workaround is to work with BI projects and VB projects in separate instances of VS.
-Albert
I will check this out as I also have Refactor! installed.
the behavior matches my problem, adding new files is the failure point.
what A pain!
I was thinking it was Team Related ( Version contol etc...) but I shall see.
in my case 2 pc's are now fixed!!! Great!!!!|||
Updated to the new versions of Refactor and CodeRush - The problem is fixed !
Thanks Albert for pointing the conflict out.
Sumeet
I have the same problem.
can you point me to the URL of the Refactor 1.0.30 to download
thanks
|||
The latest version of Refactor and CodeRush both is 2.0.1
Both can be downloaded from www.devexpress.com
Sumeet
|||I downloaded the software. I tried to install it , but it could not be installed due to error:"Error 1001: The SavedState Dictionary contains inconsistent
data and might have corrupted."
I traced the propblem until i found that DXCore (software provided by same company of refactor) was the reason.
I removed DXcore , and every thing in reporting service in visual studio 2005 become working well !!!..
Is it a bug in DXcore ?
Thanks to you and all contributors in that post.
M. Hassan
Cannot create a report - VS 2005/SQL 2005
I cannot seem to create a Report based on an SQL Server 2005 database. The
IDE and the database server are on the same machine. The reports server is
installed and running. During both installations (VS and SQL Server 2005 ) I opted for the complete install.
I create a reports project - when I right click the reports folder and select
Add New Item > Report - nothing happens.
When I invoke the Report wizard and continue till the last step - pressing
finish generates the following exception :
at Microsoft.DataWarehouse.VsIntegration.Shell.Project.FileProjectHierarchy.OnHierarchyNodeAppending(IHierarchyNode
node, IHierarchyNode parentNode)
at Microsoft.DataWarehouse.VsIntegration.Hierarchy.Hierarchy.Add(IHierarchyNode
node, IHierarchyNode parentNode)
at Microsoft.DataWarehouse.VsIntegration.Shell.Project.FileProjectHierarchy.AddExistingFileToProject(IFileProjectNode&
parentNode, String name, String fullPath, VSADDITEMOPERATION dwAddItemOperation)
at Microsoft.DataWarehouse.VsIntegration.Shell.Project.Extensibility.ProjectItemsExt.AddFromFile(String
FileName)
at Microsoft.ReportDesigner.Wizards.ReportWizardForm.OnFinish(CancelEventArgs
e)
I have Refactor installed ! However, report creation generates an error even when there is only a BI project in the solution and no VB project.
Sumeet|||
However, on another machine and with the exactly the same stuff intalled VS2005/SQL 2005 without refactor pro - I have exactly the same problem in creating BI projects.
Sumeet|||
in my case 2 pc's are now fixed!!! Great!!!!|||
I have the same problem.
can you point me to the URL of the Refactor 1.0.30 to download
thanks
"Error 1001: The SavedState Dictionary contains inconsistent data and might have corrupted."
I traced the propblem until i found that DXCore (software provided by same company of refactor) was the reason.
I removed DXcore , and every thing in reporting service in visual studio 2005 become working well !!!..
Is it a bug in DXcore ?
Thanks to you and all contributors in that post.
M. Hassan
IDE and the database server are on the same machine. The reports server is
installed and running. During both installations (VS and SQL Server 2005 ) I opted for the complete install.
I create a reports project - when I right click the reports folder and select
Add New Item > Report - nothing happens.
When I invoke the Report wizard and continue till the last step - pressing
finish generates the following exception :
===================================
Exception of type 'System.Runtime.InteropServices.COMException' was thrown. (Microsoft Visual Studio)
Program Location:at Microsoft.DataWarehouse.VsIntegration.Shell.Project.FileProjectHierarchy.OnHierarchyNodeAppending(IHierarchyNode
node, IHierarchyNode parentNode)
at Microsoft.DataWarehouse.VsIntegration.Hierarchy.Hierarchy.Add(IHierarchyNode
node, IHierarchyNode parentNode)
at Microsoft.DataWarehouse.VsIntegration.Shell.Project.FileProjectHierarchy.AddExistingFileToProject(IFileProjectNode&
parentNode, String name, String fullPath, VSADDITEMOPERATION dwAddItemOperation)
at Microsoft.DataWarehouse.VsIntegration.Shell.Project.Extensibility.ProjectItemsExt.AddFromFile(String
FileName)
at Microsoft.ReportDesigner.Wizards.ReportWizardForm.OnFinish(CancelEventArgs
e)
Is anyone else having the same problem?
Any help will be appreciated.
Thanks
Sumeet
same error here.... anyone got a work around or a fix?|||
We are currently investigating a conflict with DevExpress Refactor. Do you have Refactor! installed? Do you work with VB projects and BI projects in the same instance of VS? Once Refactor! has been loaded into VS, any attempt to add files to a BI project will fail. The workaround is to work with BI projects and VB projects in separate instances of VS.
-Albert
|||Hi Albert,I have Refactor installed ! However, report creation generates an error even when there is only a BI project in the solution and no VB project.
Sumeet|||
A new version of Refactor! (1.0.30, 12/7/2005) is available which may fix the problem. Give it a try.
-Albert
|||Will do.However, on another machine and with the exactly the same stuff intalled VS2005/SQL 2005 without refactor pro - I have exactly the same problem in creating BI projects.
Sumeet|||
We are currently investigating a conflict with DevExpress Refactor. Do you have Refactor! installed? Do you work with VB projects and BI projects in the same instance of VS? Once Refactor! has been loaded into VS, any attempt to add files to a BI project will fail. The workaround is to work with BI projects and VB projects in separate instances of VS.
-Albert
I will check this out as I also have Refactor! installed.
the behavior matches my problem, adding new files is the failure point.
what A pain!
I was thinking it was Team Related ( Version contol etc...) but I shall see.|||
We are currently investigating a conflict with DevExpress Refactor. Do you have Refactor! installed? Do you work with VB projects and BI projects in the same instance of VS? Once Refactor! has been loaded into VS, any attempt to add files to a BI project will fail. The workaround is to work with BI projects and VB projects in separate instances of VS.
-Albert
I will check this out as I also have Refactor! installed.
the behavior matches my problem, adding new files is the failure point.
what A pain!
I was thinking it was Team Related ( Version contol etc...) but I shall see.
in my case 2 pc's are now fixed!!! Great!!!!|||
Updated to the new versions of Refactor and CodeRush - The problem is fixed !
Thanks Albert for pointing the conflict out.
Sumeet
I have the same problem.
can you point me to the URL of the Refactor 1.0.30 to download
thanks
|||
The latest version of Refactor and CodeRush both is 2.0.1
Both can be downloaded from www.devexpress.com
Sumeet
|||I downloaded the software. I tried to install it , but it could not be installed due to error:"Error 1001: The SavedState Dictionary contains inconsistent data and might have corrupted."
I traced the propblem until i found that DXCore (software provided by same company of refactor) was the reason.
I removed DXcore , and every thing in reporting service in visual studio 2005 become working well !!!..
Is it a bug in DXcore ?
Thanks to you and all contributors in that post.
M. Hassan
Subscribe to:
Posts (Atom)