Error running report: additional

Showing posts with label additional. Show all posts

Monday, March 19, 2012

Error When Creating Maintenance Plan after SP2

Exception has been thrown by the target of an invocation (mscorlib)
Additional information:
Creating instance of the COM component with CLSID
{E80FE1DB-D1AA-4D6B-BA7E-040D424A925C} from iClassFactory failed due
to the following
error: c001f011. (Microsoft.SQLServer.ManagedDTS)
IClassFactory
Microsoft.SQLServer.ManagedDTS
... any ideas?You could try the 3152 cumulative hotfix, which corrected a few issues with
maintenance plans that SP2 either introduced or didn't address.
http://support.microsoft.com/kb/933097/
There is also another GDR / QFE coming soon. See:
http://sqlblog.com/blogs/aaron_bertrand/default.aspx
--
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
<michad76@.gmail.com> wrote in message
news:1174571688.759138.320150@.o5g2000hsb.googlegroups.com...
> Exception has been thrown by the target of an invocation (mscorlib)
> Additional information:
> Creating instance of the COM component with CLSID
> {E80FE1DB-D1AA-4D6B-BA7E-040D424A925C} from iClassFactory failed due
> to the following
> error: c001f011. (Microsoft.SQLServer.ManagedDTS)
>
> IClassFactory
> Microsoft.SQLServer.ManagedDTS
> ... any ideas?
>

Error When Creating Maintenance Plan after SP2

Exception has been thrown by the target of an invocation (mscorlib)
Additional information:
Creating instance of the COM component with CLSID
{E80FE1DB-D1AA-4D6B-BA7E-040D424A925C} from iClassFactory failed due
to the following
error: c001f011. (Microsoft.SQLServer.ManagedDTS)
IClassFactory
Microsoft.SQLServer.ManagedDTS
... any ideas?You could try the 3152 cumulative hotfix, which corrected a few issues with
maintenance plans that SP2 either introduced or didn't address.
http://support.microsoft.com/kb/933097/
There is also another GDR / QFE coming soon. See:
http://sqlblog.com/blogs/aaron_bertrand/default.aspx
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
<michad76@.gmail.com> wrote in message
news:1174571688.759138.320150@.o5g2000hsb.googlegroups.com...
> Exception has been thrown by the target of an invocation (mscorlib)
> Additional information:
> Creating instance of the COM component with CLSID
> {E80FE1DB-D1AA-4D6B-BA7E-040D424A925C} from iClassFactory failed due
> to the following
> error: c001f011. (Microsoft.SQLServer.ManagedDTS)
>
> IClassFactory
> Microsoft.SQLServer.ManagedDTS
> ... any ideas?
>

Friday, March 9, 2012

Error when attempting to backup to a second disk file

In SQL Server 2005, via the GUI, I wish to backup a database to an additional disk file (there is already an existing backup disk file for this database), so that I can have more than one backup. I've added the new disk file name, highlighted it, and clicked OK.

I get an immediate error (see below). Note, the 2nd error message is specifying the existing backup disk file, not the new one I'm attempting to create.

"Backup failed for Server 'WCS-DEV-TPA'. (Microsoft.SqlServer.Smo)"

"System.Data.SqlClient.SqlError: The volume on device 'D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\WCS_ADV_Longmont.bak' is not part of a multiple family media set. BACKUP WITH FORMAT can be used to form a new media set. (Microsoft.SqlServer.Smo)"

Does anyone know what causes this and how to correct it?

Try removing all but the new disk file name. Also you can just copy the first backup(s) to another drive.|||

While that would be a good workaround, it won't meet my needs.

(a) The users will need to make multiple backups and retain several older versions in order to be able to restore a specific version if necessary. (b) The users who will be making the backups will not have access to the file system on the computer that will host the backup disk files.

Is there a way to correct this problem so that we can have multiple disk backups via the GUI? (The users in question won't be knowledgeable (or privileged) enough to create SQL scripts to do the backups on this 'ad-hoc' basis.)

|||

From another post:

You can use the UI to create a Maintenance Plan(s) with multiple backups. If these are adhoc backups they'll have to be separately.

Kevin Farlee

Posts 224

Answer Re: Backup error - not part of a multiple family media set
Was this post helpful ?

When you back up to two files, you are creating a stripe set. The restriction is that all backups sent to a media set must have the same number of stripes. That's the meaning of your error.

You need to create a media set with the number of stripes you want to use. You can't add members later.

The method for creating a new media set is to use the WITH FORMAT option on your backup command. This is the equivalent of reformatting a tape for backups. It wipes out any previous data in the file(s), and sets up the headers correctly.

So, if you issue the same command in your script, adding WITH FORMAT for ONE TIME ONLY, the first time you use that media family, you should be good to go. From then on, you can just use it as your script is now.

Microsoft SQL Server Storage Engine PM

|||

[1] This is for use in ad-hoc backups and need to be done by fairly inexperienced users as desired before running application software that will modify the database.

[2] We don't want to backup the database to a multiple disk file set - we want to be able to specify a new disk file to receive the database backup, giving us the capability of seeing multiple versions of the database (based on the backup snapshot in each disk file) and restoring (if necessary) from any one of the backup disk files. Doing this through the GUI is necessary because of this will be done with less privileged and knowledgeable users.

|||

Sorry I can't be of more help.

The only solution I can see is for your users to use the UI to back up to only one "location" at a time. They will just have to use the UI to twice, each time backing up to one location.

|||Does this mean that the problem I'm reporting is a known flaw (bug?) in the SQL Server management GUI? It can't be corrected to allow the specification of several backup disk files?|||

I would just say that the Backup Database dialog only allows for one backup at a time to either a single file or device or a multiple family media set. It has to be used two times for two backups.

You can use the Maintenance Plan UI to create a plan with two backup tasks, to two different folders, that run in series and you can schedule that plan.

The UI for the Maintenance Plan - Backup Database Task is similiar to the Backup Database dialog.:

|||

OK, I see. It looks like we'll have to re-evaluate how the permissions will be allocated to users in consideration of this. Thank you (all of y'all) for your help.

Regards,

Douglas

|||

Help me understand more about what you're trying to accomplish:

Are you trying to get two files, each containing exactly the same backup content?

or are you wanting to have a collection of backups of the same database at different times?

If you want the former, you want to use the MIRROR TO clause in the Backup command. I can't find a button on the GUI for it, but if you set up a backup, and specify two files, then click on the "script" button, you'll get a backup command with two disk files separated by a comma. i.e.

BACKUP DATABASE foo TO DISK = N'C:\somefile.bak', DISK = N'D:\AnotherFile.BAK' WITH FORMAT;

if you replace the comma with 'MIRROR TO', as in

BACKUP DATABASE foo TO DISK = N'C:\somefile.bak' MIRROR TO DISK = N'AnotherFile.BAK' WITH FORMAT;

then hit "GO" you'll get two copies of a backup of database foo instead of a stripe set.

|||We're wanting to "have a collection of backups of the same database at different times".

Friday, February 24, 2012

Error trying to connect to Reporting Services

When I try to connect to RS through SQL management I get this...

TITLE: Connect to Server

Cannot connect to UKCINT\UKCAZOSQL.

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" />
<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:#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>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.2047.00" target="_blank">Get Online Help</a></li><ul>
<li>Could not load type 'Microsoft.Web.Services.ScriptHandlerFactory'. (c:\inetpub\wwwroot\web.config line 45)</li><ul>
<li>Could not load type 'Microsoft.Web.Services.ScriptHandlerFactory'.</li>
</ul>
</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:

I can connect to other services and Reporting Services has worked in the past. I have tried to directly connect through the web browser and it works fine.

Thanks for any suggestions.

I encountered the same error as well. The environment is SQL Server 2005 on Windows 2003 Server. Looking for the cause and a solution.|||

I had this problem also. It turned out I had installed SSRS with an account without enough privilages. I re-installed with a account with higher privilages on the server and it worked.

Hope this helps!

|||The only change I made was we recently installed BizTalk to try it out. I wonder if that did something to cause this problem.|||

I uninstalled the BizTalk and still the same error message. I am getting this message from both the direct RS server and a remote client connecting to the server and now all of our reports on our intranet are getting the same error message.

Should I just reinstall Reporting Services?

The error that I am getting trying to connect from a remote machine is: "No Connection could be made because the target machine actively refused it (server)."

|||

I don't know if I found the solution, however I am now able to connect. What I did is to comment out the following lines in the web.config file that resides in the wwwroot folder for IIS:

<!--

</httpHandlers>

-->

UPDATE: Actually, this did not work. This has allowed my SQL Management Studio to now connect to Reporting Services, but our intranet is giving me more error messages:

The Report Viewer Web Control HTTP Handler has not been registered in the application's web.config file. Add <add verb="*" path="Reserved.ReportViewerWebControl.axd" type = "Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" /> to the system.web/httpHandlers section of the web.config file.

|||

More information:

This problem is driving me nuts. I checked out the Configure Report Server on another machine and the box next to Initialization is check, however greyed-out. For the server instance that is actually having the problem this box is X'ed out and greyed out even though the application says that this instance has been started.

Wednesday, February 15, 2012

Error S1003 ... Program Type Out Of Range

quote:

> I am receiving an "S1003 ... Program Type Out Of Range" error when retrieving data but can
not find

any additional documented help on it's meaning nor a solution to the problem.

quote:

> Any and all help is greatly appreciated.
> Thanks,
> Jim.

|||The ODBC Error comes up exactly as follows:
Select Error: SQLSTATE = S1003
[Microsoft][ODBC Driver Manager] Program Type Out of range
The Select works fine with other ODBC drivers (Sybase, Oracle, ...) but fail
s with SQL Server.
-- Tibor Karaszi wrote: --
This doesn't look like a SQL Server error. I suggest you ask the vendor of t
he application what this
means.
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ls
erver
"JimJNH" <anonymous@.discussions.microsoft.com> wrote in message
news:722C411A-6C52-439B-87C8-8F697A2BA05B@.microsoft.com...

quote:

> I am receiving an "S1003 ... Program Type Out Of Range" error when retrieving data but can
not find

any additional documented help on it's meaning nor a solution to the problem.[QUOTE][color=darkred
]

Error S1003 ... Program Type Out Of Range

I am receiving an "S1003 ... Program Type Out Of Range" error when retrieving data but cannot find any additional documented help on it's meaning nor a solution to the problem.
Any and all help is greatly appreciated.
Thanks,
Jim.This doesn't look like a SQL Server error. I suggest you ask the vendor of the application what this
means.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"JimJNH" <anonymous@.discussions.microsoft.com> wrote in message
news:722C411A-6C52-439B-87C8-8F697A2BA05B@.microsoft.com...
> I am receiving an "S1003 ... Program Type Out Of Range" error when retrieving data but cannot find
any additional documented help on it's meaning nor a solution to the problem.
> Any and all help is greatly appreciated.
> Thanks,
> Jim.|||The ODBC Error comes up exactly as follows:
Select Error: SQLSTATE = S1003
[Microsoft][ODBC Driver Manager] Program Type Out of range
The Select works fine with other ODBC drivers (Sybase, Oracle, ...) but fails with SQL Server.
-- Tibor Karaszi wrote: --
This doesn't look like a SQL Server error. I suggest you ask the vendor of the application what this
means.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"JimJNH" <anonymous@.discussions.microsoft.com> wrote in message
news:722C411A-6C52-439B-87C8-8F697A2BA05B@.microsoft.com...
> I am receiving an "S1003 ... Program Type Out Of Range" error when retrieving data but cannot find
any additional documented help on it's meaning nor a solution to the problem.
>> Any and all help is greatly appreciated.
>> Thanks,
>> Jim.

Monday, March 19, 2012

Error When Creating Maintenance Plan after SP2

Error When Creating Maintenance Plan after SP2

Friday, March 9, 2012

Error when attempting to backup to a second disk file

Friday, February 24, 2012

Error trying to connect to Reporting Services

Wednesday, February 15, 2012

Error S1003 ... Program Type Out Of Range

Error S1003 ... Program Type Out Of Range

Error running report

Blog Archive

About Me