Hey guys,
I've got serveral SQL Server 2000 (SP4) Meta Data Services Packages that
hang EM when I try to delete them. I could try using the /!D parameter of
DTSRUN but that might take a while as I'm sure there are multiple versions
for each. Is this a known issue or is there a quick way to delete these
packages (including the multiple versions for each)?
Thanks
JerryYeah...people have hit the issue. Sometimes it's due to a
corrupt repository - there is a KB article on how to rebuild
it. I'd try running the !D. If you hit issues due to the
number of versions, you would like get some error about the
cache being full...something along those lines. There are
registry hacks others have used to fix that issue. But I'd
just first try going through and deleting with !D
-Sue
On Tue, 16 May 2006 11:22:08 -0700, "Jerry Spivey"
<jspivey@.vestas-awt.com> wrote:
>Hey guys,
>I've got serveral SQL Server 2000 (SP4) Meta Data Services Packages that
>hang EM when I try to delete them. I could try using the /!D parameter of
>DTSRUN but that might take a while as I'm sure there are multiple versions
>for each. Is this a known issue or is there a quick way to delete these
>packages (including the multiple versions for each)?
>Thanks
>Jerry
>
Showing posts with label response. Show all posts
Showing posts with label response. Show all posts
Sunday, March 11, 2012
Can't Delete Meta Data Services Packages (Repost: No response on DTS SQL NG.)
Hey guys,
I've got serveral SQL Server 2000 (SP4) Meta Data Services Packages that
hang EM when I try to delete them. I could try using the /!D parameter of
DTSRUN but that might take a while as I'm sure there are multiple versions
for each. Is this a known issue or is there a quick way to delete these
packages (including the multiple versions for each)?
Thanks
JerryYeah...people have hit the issue. Sometimes it's due to a
corrupt repository - there is a KB article on how to rebuild
it. I'd try running the !D. If you hit issues due to the
number of versions, you would like get some error about the
cache being full...something along those lines. There are
registry hacks others have used to fix that issue. But I'd
just first try going through and deleting with !D
-Sue
On Tue, 16 May 2006 11:22:08 -0700, "Jerry Spivey"
<jspivey@.vestas-awt.com> wrote:
>Hey guys,
>I've got serveral SQL Server 2000 (SP4) Meta Data Services Packages that
>hang EM when I try to delete them. I could try using the /!D parameter of
>DTSRUN but that might take a while as I'm sure there are multiple versions
>for each. Is this a known issue or is there a quick way to delete these
>packages (including the multiple versions for each)?
>Thanks
>Jerry
>
I've got serveral SQL Server 2000 (SP4) Meta Data Services Packages that
hang EM when I try to delete them. I could try using the /!D parameter of
DTSRUN but that might take a while as I'm sure there are multiple versions
for each. Is this a known issue or is there a quick way to delete these
packages (including the multiple versions for each)?
Thanks
JerryYeah...people have hit the issue. Sometimes it's due to a
corrupt repository - there is a KB article on how to rebuild
it. I'd try running the !D. If you hit issues due to the
number of versions, you would like get some error about the
cache being full...something along those lines. There are
registry hacks others have used to fix that issue. But I'd
just first try going through and deleting with !D
-Sue
On Tue, 16 May 2006 11:22:08 -0700, "Jerry Spivey"
<jspivey@.vestas-awt.com> wrote:
>Hey guys,
>I've got serveral SQL Server 2000 (SP4) Meta Data Services Packages that
>hang EM when I try to delete them. I could try using the /!D parameter of
>DTSRUN but that might take a while as I'm sure there are multiple versions
>for each. Is this a known issue or is there a quick way to delete these
>packages (including the multiple versions for each)?
>Thanks
>Jerry
>
Sunday, February 12, 2012
Can''t connect to local Report server, error code....
Anyone know how to get around this?
TITLE: Connect to Server
Cannot connect to OES-XP1007.
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.3054.00" />
<meta name="HTTP Status" content="500" />
<meta name="ProductLocaleID" content="9" />
<meta name="CountryLocaleID" content="1033" />
<meta name="StackTrace" content />
<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![[:#]](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_un0woi9pKjd32yyuMHm1SjRzAgP1OZRf3_2-70TQcOuk-y_NemmxVrxYCF2ZZZGVaQ_V-AJXhk72z7inYDlHGrFXxr3bQcBJeLorkMS350rTu8eKJen-4W1ssrDsroLEmcgNWvWahlgVhe1oCaZTOkTVEbGNK1lA=s0-d){kind=small}
A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR
A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR
A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color
</style>
</head><body bgcolor="white">
<h1>
Reporting Services Error<hr width="100%" size="1" color="silver" />
</h1><ul>
<li>An internal error occurred on the report server. See the error log for more details. (rsInternalError) <a href="http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsInternalError&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.3054.00" target="_blank">Get Online Help</a></li><ul>
<li>Could not find stored procedure 'GetOneConfigurationInfo'.</li>
</ul>
</ul><hr width="100%" size="1" color="silver" /><span class="ProductInfo">SQL Server Reporting Services</span>
</body>
</html>
--. (Microsoft.SqlServer.Management.UI.RSClient)
BUTTONS:
OK
Please see this thread:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1955241&SiteID=1
Someone else has a similar problem to yours.
Subscribe to:
Posts (Atom)