Error running report: creating

Showing posts with label creating. Show all posts

Monday, March 26, 2012

Error when programmatically creating a data driven subscription

Hi,
any ideas what causes this?
An internal error occurred on the report server. See the error log for more
details. --> An internal error occurred on the report server. See the error
log for more details. --> Subquery returned more than 1 value. This is not
permitted when the subquery follows =, !=, <, <= , >, >= or when
the subquery is used as an expression.
The statement has been terminated.
The log file shows
aspnet_wp!library!8c0!7/09/2004-09:08:27:: Using folder C:\Program
Files\Microsoft SQL Server\MSSQL\Reporting Services\RSTempFiles for
temporary files.
aspnet_wp!library!8c0!7/09/2004-09:08:27:: i INFO: Cleaned 0 batch records,
0 policies, 0 sessions, 0 cache entries, 1 snapshots, 4 chunks, 0 running
jobs
aspnet_wp!library!88c!09/07/2004-09:12:32:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details. --> System.Data.SqlClient.SqlException: Subquery returned more
than 1 value. This is not permitted when the subquery follows =, !=, <, <= ,
>, >= or when the subquery is used as an expression.
The statement has been terminated.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at
Microsoft.ReportingServices.Library.InstrumentedSqlCommand.ExecuteNonQuery()
at
Microsoft.ReportingServices.Library.SubscriptionDB.CreateSubscription(Subscr
iptionImpl subscription)
-- End of inner exception stack trace --
thanks
MattActually, this is also occuring when trying to create a subscription via
report manager. I wonder if the reporting service installation is stuffed.
Any suggestions?
thanks
"Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
news:OxffpsHlEHA.3428@.TK2MSFTNGP14.phx.gbl...
> Hi,
> any ideas what causes this?
> An internal error occurred on the report server. See the error log for
more
> details. --> An internal error occurred on the report server. See the
error
> log for more details. --> Subquery returned more than 1 value. This is not
> permitted when the subquery follows =, !=, <, <= , >, >= or
when
> the subquery is used as an expression.
> The statement has been terminated.
> The log file shows
> aspnet_wp!library!8c0!7/09/2004-09:08:27:: Using folder C:\Program
> Files\Microsoft SQL Server\MSSQL\Reporting Services\RSTempFiles for
> temporary files.
> aspnet_wp!library!8c0!7/09/2004-09:08:27:: i INFO: Cleaned 0 batch
records,
> 0 policies, 0 sessions, 0 cache entries, 1 snapshots, 4 chunks, 0 running
> jobs
> aspnet_wp!library!88c!09/07/2004-09:12:32:: e ERROR: Throwing
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
more
> details., ;
> Info:
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
more
> details. --> System.Data.SqlClient.SqlException: Subquery returned more
> than 1 value. This is not permitted when the subquery follows =, !=, <, <=,
> >, >= or when the subquery is used as an expression.
> The statement has been terminated.
> at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
> cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
> at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
> at
>
Microsoft.ReportingServices.Library.InstrumentedSqlCommand.ExecuteNonQuery()
> at
>
Microsoft.ReportingServices.Library.SubscriptionDB.CreateSubscription(Subscr
> iptionImpl subscription)
> -- End of inner exception stack trace --
> thanks
> Matt
>

Friday, March 23, 2012

Error when installing SQL 2000 clustering

See error below
"An error occurred while creating virtual server
resources for clustering. The system cannot find the file
specified."
The failure occured during the creation of the virtual server resources (which this error indicates). You must view Cluster.log (in the WINNT\Cluster folder) or Sqlclstr.log (or both). At this stage, you are past the
unattended setup processes, so you will typically see the "Installation Succeeded" messages in the Sqlstp<N>.log files.
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx

Monday, March 19, 2012

Error when creating Stored Procedure

I am trying to create a new stored procedure:
****************************************
***************
CREATE PROCEDURE XXX_GetInfo AS
select cast(info.id as varchar) refno, info.begindt, enddt, info.company,
info.type, info.weight
from info info
union
select cast(test.id as varchar) refno, test.begindt, enddt, test.company,
test.type, info.weight
from link1.test.dbo.test test
order by begindt,enddt
****************************************
***************
link1 is a linked server
When I check syntax, sql comes back and says that syntax is correct.
When I try to create the stored procedure, I get an:
[Microsoft SQL-DMO (ODBC SQLState: 42000)]
Error 7405: Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS
options to be set for the connection. This ensures consistent query
semantics. Enable these options and then reissue your query.
I have checked that ANSI_NULLS, ANSI_WARNINGS, and ANSI Padding is
configured as on for both servers.
When Setting up the linked server :
General Tab
Linked server - link1
Other data source - Provider Name - Microsoft OLE DB Provider for
SQL Server
Product name -
Data source - ip address of the server
Provider string -
catalog - test
Security Tab
Be made using this security context - sa of the remote machine
Any help or insight as to why it will not allow me to create the stored
procedure will be greatly appreciated.
Thanks in Advance
VinceServer settings are overridden by tool settings which are overriden by
explicit SET settings. So just issue the appropriate SET statements in the
same query window where you are executing the create proc statement.
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Vince,
Thank you for using MSDN Newsgroup! It's my pleasure to assist you with this
issue.
I think Cindy has pointed out the root cause that the server settings are ov
eridden. To explicit
that settings in either Enterprise Manager or Query Analyzer, you should iss
ue the SET within
the CREATE PROCEDURE so that these setting will not be affected by SQL state
ments in
anohter Client Tools . Otherwise, the life span of these settings ends with
the batch finishes
and they may be OFF before you create your procedure.
Please look through the following script and see if it works on your side. I
f there is anything
more we can do to assist you, please feel free to post it in the group.
---
CREATE PROCEDURE XXX_GetInfo
AS
SET ANSI_NULLS ON
SET ANSI_WARNINGS ON
GO
select cast(info.id as varchar) refno, info.begindt, enddt, info.company,
info.type, info.weight
from info info
union
select cast(test.id as varchar) refno, test.begindt, enddt, test.company,
test.type, info.weight
from link1.test.dbo.test test
order by begindt,enddt
GO
---
Best regards,
Billy Yao
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.

Error when creating script to copy Stored Procedures

Our DB has around 30 SProcs - I need to move them into a script, so that it can be easily added to another server. The way I'm creating the script is to highlight all the SProcs, then copy - in my notepad screen, I paste, which gives me one script, which includes all the individual creation scripts for the Sprocs.

However, I'm getting an error when I create the script -

Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'SP_MySproc'. The stored procedure will still be created.

So - what's a good, and/or easy way to structure the script, so that I can easily find WHERE to put Which SProc Script, in the list?

Hey,

You could follow those steps:

Right click Database in Sql Server Management Studio -> Tasks->Generate Scripts->choose databse ->...->check Stored Procedure->next...

|||

That still gives me the same error - I guess what I'm asking is:

how can I figure out what order the Stored Procedures need to be scripted, so this error doesn't happen?

|||

The generate script option only guarantees that the script can pass compile and the order is determined by design.

If you don't mind you could execute script twice and error should go away in the second time.

Hope this helps.

|||

Hi,

If you are sure that all procedures you need are in your script do not worry about the errors, procedures will be created and will work. The only problem will be if you call procedures from another table which are not scripted or if you script your procedures into another database (with different name) and you used call like exec [Sourcedatabase].[dbo].[Procedurename] so it is possible in this case that your procedures will not work if database [Sourcedatabase] is not visible on your server from inside your destination database so check your script for "long" calls.

If you would like to have procedures in correct order you can write TSQL script which will script procedures for you in correct order, I hear about application which can do it for you and you can do it by hands by ordering your procedures in the script the way that procedure is defined before is called by another procedure.

Thanks

JPazgier

Error when creating schedule in Report Manager

Hello,

Scenario:

I am trying to set up a shared schedule in report manager after successfully deploying the reports to my server. I have set up the linked reports and AD permissions, however when I want to either set up a shared schedule, or an individual schedule I encounter the error below.

System details:

Report Manager Error:

An internal error occurred on the report server. See the error log for more details. (rsInternalError) The specified @.category_id ('100') does not exist.

The error log does not contain any infor regarding this error, and I've searched for this error extensively in Google as well as microsoft.com, however can't seem to find a resolution for it.

I have also tried to create the schedule in SQL Server Management Studio. The complete error message is as follows:

An internal error occurred on the report server. See the error log for more details. (rsInternalError) (Report Services SOAP Proxy Source)

Additional information:

An internal error occurred on the report server. See the error log for more details. (rsInternalError) (ReportingServicesLibrary)

The specified @.category_id ('100') does not exist. () (.Net SqlClient Data Provider)

Please could you send me any further info about how to solve this problem and resolve the error.

Thank you

Sune de Vos

Hi,
It looks like you did not have permission to setup category on database server in msdb.
try this:
use msdb

set IDENTITY_INSERT syscategories ON
insert into syscategories(category_id,category_class,category_type,name) values(100,1,1,'Report Server')
set IDENTITY_INSERT syscategories OFF

you need to be sysadmin to run this.
It seems to work after that - did not test how it will behave later, so be careful.
Best Regards

Error when creating new database user

When I try to create a new database user (on any database) I get this error
message: Cannot resolve
collation conflict for equal to operation.
I Use SQL_Danish_Pref_CP1_CI_AS as the default collation. Only one user
database has another collation: Danish_Norwegian_CI_AI and the tempdb
database. I don't know why the tempdb has this collation, and if that is the
problem?I'd start checking the collation for below databases:
master
model
tempdb
msdb
If they aren't the same, you have a problem. It isn't supported to have different collations for the
system databases. Somebody made a "hack" to get you there. You would need to sort it out. Suitable
actions depend on what collation each system database has.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"blaairis" <blaairis@.discussions.microsoft.com> wrote in message
news:EC58D0F5-4199-4353-8576-81B6F6BAF41F@.microsoft.com...
> When I try to create a new database user (on any database) I get this error
> message: Cannot resolve
> collation conflict for equal to operation.
> I Use SQL_Danish_Pref_CP1_CI_AS as the default collation. Only one user
> database has another collation: Danish_Norwegian_CI_AI and the tempdb
> database. I don't know why the tempdb has this collation, and if that is the
> problem?|||The master and msdb is ok, but tempdb and model have Danish_Norwegian_CI_AI
It is not possible to change collation in tempdb with alter
database...because it is a system database. What can I do?
"Tibor Karaszi" wrote:
> I'd start checking the collation for below databases:
> master
> model
> tempdb
> msdb
> If they aren't the same, you have a problem. It isn't supported to have different collations for the
> system databases. Somebody made a "hack" to get you there. You would need to sort it out. Suitable
> actions depend on what collation each system database has.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "blaairis" <blaairis@.discussions.microsoft.com> wrote in message
> news:EC58D0F5-4199-4353-8576-81B6F6BAF41F@.microsoft.com...
> > When I try to create a new database user (on any database) I get this error
> > message: Cannot resolve
> > collation conflict for equal to operation.
> > I Use SQL_Danish_Pref_CP1_CI_AS as the default collation. Only one user
> > database has another collation: Danish_Norwegian_CI_AI and the tempdb
> > database. I don't know why the tempdb has this collation, and if that is the
> > problem?
>|||Probably somebody moved files for the model database from another installation. Tempdb is created
based on model on each startup. Hunt down database files from an installation that matches system
and msdb for your model database. You can try to just stop SQL Server and replace the files (backup
first, and save a copy of original model database files).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"blaairis" <blaairis@.discussions.microsoft.com> wrote in message
news:2155EF0D-3115-4B69-854B-1DD0C7A02EDC@.microsoft.com...
> The master and msdb is ok, but tempdb and model have Danish_Norwegian_CI_AI
> It is not possible to change collation in tempdb with alter
> database...because it is a system database. What can I do?
> "Tibor Karaszi" wrote:
>> I'd start checking the collation for below databases:
>> master
>> model
>> tempdb
>> msdb
>> If they aren't the same, you have a problem. It isn't supported to have different collations for
>> the
>> system databases. Somebody made a "hack" to get you there. You would need to sort it out.
>> Suitable
>> actions depend on what collation each system database has.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "blaairis" <blaairis@.discussions.microsoft.com> wrote in message
>> news:EC58D0F5-4199-4353-8576-81B6F6BAF41F@.microsoft.com...
>> > When I try to create a new database user (on any database) I get this error
>> > message: Cannot resolve
>> > collation conflict for equal to operation.
>> > I Use SQL_Danish_Pref_CP1_CI_AS as the default collation. Only one user
>> > database has another collation: Danish_Norwegian_CI_AI and the tempdb
>> > database. I don't know why the tempdb has this collation, and if that is the
>> > problem?
>>|||Also, you could try bringing up the instance in master recovery only and
then attempt to modify the collation using the ALTER DATABASE command.
-T3608
ALTER DATABASE model
COLLATE <collation name>
This may only be a pseudo fix, if it works at all. You will probably need
to do as Tibor suggest, but it is worth a shot if you have trouble finding
such a database.
Another way to acquire a model database with the collation you want would be
to install SQL Server Developer Edition on your workstation and specifying
the collation of the system databases during the installation. You would
then need to patch you workstation installation to the same level as your
production database before you tried to copy the files from your workstation
to the server.
Hope this helps.
Sincerely,
Anthony Thomas
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%239R%23RH3ZFHA.1040@.TK2MSFTNGP10.phx.gbl...
Probably somebody moved files for the model database from another
installation. Tempdb is created
based on model on each startup. Hunt down database files from an
installation that matches system
and msdb for your model database. You can try to just stop SQL Server and
replace the files (backup
first, and save a copy of original model database files).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"blaairis" <blaairis@.discussions.microsoft.com> wrote in message
news:2155EF0D-3115-4B69-854B-1DD0C7A02EDC@.microsoft.com...
> The master and msdb is ok, but tempdb and model have
Danish_Norwegian_CI_AI
> It is not possible to change collation in tempdb with alter
> database...because it is a system database. What can I do?
> "Tibor Karaszi" wrote:
>> I'd start checking the collation for below databases:
>> master
>> model
>> tempdb
>> msdb
>> If they aren't the same, you have a problem. It isn't supported to have
different collations for
>> the
>> system databases. Somebody made a "hack" to get you there. You would need
to sort it out.
>> Suitable
>> actions depend on what collation each system database has.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "blaairis" <blaairis@.discussions.microsoft.com> wrote in message
>> news:EC58D0F5-4199-4353-8576-81B6F6BAF41F@.microsoft.com...
>> > When I try to create a new database user (on any database) I get this
error
>> > message: Cannot resolve
>> > collation conflict for equal to operation.
>> > I Use SQL_Danish_Pref_CP1_CI_AS as the default collation. Only one user
>> > database has another collation: Danish_Norwegian_CI_AI and the tempdb
>> > database. I don't know why the tempdb has this collation, and if that
is the
>> > problem?
>>

Error when creating new connection in DTS Designer

64b SQL2005 EE and all clent tools installed on the same server. Im trying to create a new connection in DTS Designer but after succesful test of the connection it errors out with

The new connection manager couldnt be created. Additional info : Exeption from HRESULT 0xC0010014

Any idea whats the problem here?

This might be caused by a problem described here:

http://support.microsoft.com/kb/913817

|||Im logged in with local admin account. Does that count? Still SSIS is running under Network Servise|||Usually the service does the component enumeration and caches the results, so this is performed without admin rights. You can check if this is an issue by temporary disabling the service, and trying this again (restart BIDS first). If this is caused by permission issue, you'll likely succeed because BIDS will do the component enumeration itself (this harms performance, but avoids Network Service restrictions).

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?
>

Error when creating DMX query

On screen states [Error loading mining model metadata: No Metadata found]

and on the functions states [Error loading functions: no functions found]

This also occures when trying to use the Data mining wizard, it will just not respond.

Have deleted and removed all references to SQL2005 Standard and reloaded and still get same errors

Could someone please advise, have sent errors to Microsoft with no responce back yet.

I assume you are using the DMX query in SQL Management Studio?

These results occur when you have a database selected that doesn't contain any mining models. If you select a database in the database selector on the toolbar that contains models, you will get the list of models in the database in that pane of the user interface.

Also you could just do

"CREATE MINING MODEL foo ( custid LONG KEY, MyColumn LONG CONTINUOUS) USING Microsoft_Clustering"

and that would create a model in the current database that should show up in the metadata browser.

Given that you have issues using the wizard as well, it sounds like there may be some other issues. Can you provide more details?

Thanks,

-Jamie

Error when creating a view

Hello,

I'm getting the following error when I try to excute a view against my SQL 7.0 database:

The query processor encountered an unexpected error during execution.

When I click the help button this is what I get:

An ODBC error has been generated. You might have deleted a record that has a foreign key value related to it, or you might have violated a check constraint.

The view I'm trying to create is a query between a table and another view. Here is the other view:

SELECT CSQLocation.Location_ID, CSQMeasure.Measure_ID,
CSQLocation.Location, CSQMeasure.Measure_Name
FROM CSQLocation, CSQMeasure

Here is the view that I'm getting the error on

SELECT ISNULL(CSQObjective.Objective, 0) AS Objective,
vw_getLocationMeasure.Location,
vw_getLocationMeasure.Measure_Name,
vw_getLocationMeasure.Measure_ID
FROM CSQObjective RIGHT OUTER JOIN
vw_getLocationMeasure ON
CSQObjective.Location_ID = vw_getLocationMeasure.Location_ID
AND
CSQObjective.Measure_ID = vw_getLocationMeasure.Measure_ID

Does anyone have any ideas?

Thanks,
RyanWhy you need to use the other view (getLocationMeasure)? It seems the view doesn't add any value. Why don't you just use the two original tables? Just a thought.|||The reason I'm querying a view is because I wasn't able to get the information I was needed with one query and joins. Here is a break down of my db and what I need

MEASURE TABLE
Measure_ID
Measure_Name

LOCATION TABLE
Location_ID
Location

OBJECTIVE TABLE
Objective_ID
Location_ID
Measure_ID
Objective

There are 4 measures, there are about 100 locations, and there is 1 objective per measure per location. Does that make sense? So there will be about 400 obectives in the objective table. What I was trying to do is to return all the Locations, and all the Measures even if there was not and Objective associated with them. If there are no objectives I would like to return a 0, that is where the ISNULL came from. This is the output I would like to have

LOCATION - MEASURE - OBJECTIVE
Chicago - Clean Air - 78.8
Chicago - Clean Water - 75
Chicago - Clean Dumps - 0
Chicago - Clean Roads - 0
Dallas - Clean Air - 90
Dallas - Clean Water - 70
Dallas - Clean Dumps - 25
Dallas - Clean Roads - 0

etc... Does that make sense? With all the joins I've done I have only been able to return the Locations and Measures where there is acutally a value for the Objective. I would like to return 0 if there is no objective.

Thanks
Ryan

Error when creating a table based function

I'm trying to create a table based function using SMO. The problem is that I get an error saying that I need to set the DataType property on the function before it can be created. However, the documentation clearly says that the DataType property is null for Table based functions. I can't even set this value to null either!

Here's a code snippet that shows what I'm trying to do.

if (returnType.ToLower() != "table")

{

Type clrDataType = Type.GetType(returnType);

returnSqlDataType = GetSqlDataType(clrDataType);

function.FunctionType = Smo.UserDefinedFunctionType.Scalar;

function.DataType = returnSqlDataType;

}

else

{

function.FunctionType = Smo.UserDefinedFunctionType.Table;

function.TableVariableName = xmlNode.Attributes["tableVariableName"].Value;

XmlNode returnTableDescription = GetChildOfParent(xmlNode, "ReturnTableDescription");

XmlNode columnsNode = GetChildOfParent(returnTableDescription, "Columns");

foreach (XmlNode columnNode in columnsNode.ChildNodes)

{

function.Columns.Add(CreateUdfColumn(function, columnNode));

}

The xmlNode that is being referenced is an XmlNode that is describing how to create the table. returnType is a variable that is set from one of the xmlNode's attributes.

When I call on function.Create() then I get the error that I posted above. Any help anyone can give is appreciated. One thing I also tried doing was to connect to an already existing Table based function and look at its SMO properties. Sure enough, its DataType property was null.

MSFT: Is this a bug?

Never mind on this post.....it was my mistake. The DataType property not being set wasn't on the function itself, but rather on the columns collection.

Problem solved.

Error when creating a maintenance plan

When using the maintenance plan wizard on SQL 2005 (RTM) when pressing
the finish button the following error occurs when trying to create the
plan.
Maintenance Plan Wizard Progress
Create maintenance plan failed.
Additional Information:
Create failed for JobStep 'Subplan'.
(Microsoft.SqlServer.MaintenancePlanTasks)
An Exception occurred while executing a Transact-SQL statement or
batch. (Microsoft.SqlServer.ConnectionInfo)
The specified '@.subsystem' is invalid (valid values are returned by
sp_enum-sqlagent_subsystems). (Microsoft SQL Server, Error 14234)
The job appears in the Job Activity Monitor but greyed out and the
maintenance plan is not listed in its section.
What has caused this issue and how can I resolve it?
You need to apply at least SP1 to your SQL Server instance to make
Maintanence Plan work properly. It'd be better if you apply SP2, it contains
lots of fixes.
Ekrem nsoy
"Robin9876" <robin9876@.hotmail.com> wrote in message
news:9c65cf4b-d7b1-4224-bc11-46da57c143c3@.i12g2000prf.googlegroups.com...
> When using the maintenance plan wizard on SQL 2005 (RTM) when pressing
> the finish button the following error occurs when trying to create the
> plan.
> Maintenance Plan Wizard Progress
> Create maintenance plan failed.
> Additional Information:
> Create failed for JobStep 'Subplan'.
> (Microsoft.SqlServer.MaintenancePlanTasks)
> An Exception occurred while executing a Transact-SQL statement or
> batch. (Microsoft.SqlServer.ConnectionInfo)
> The specified '@.subsystem' is invalid (valid values are returned by
> sp_enum-sqlagent_subsystems). (Microsoft SQL Server, Error 14234)
>
> The job appears in the Job Activity Monitor but greyed out and the
> maintenance plan is not listed in its section.
> What has caused this issue and how can I resolve it?
|||Addition: If you do not install SSIS you'll not be able to use Maintanence
Plans in RTM version of SQL Server 2005. It's possible to use Maintanence
Plans without SSIS if you apply SP2.
Ekrem nsoy
"Robin9876" <robin9876@.hotmail.com> wrote in message
news:9c65cf4b-d7b1-4224-bc11-46da57c143c3@.i12g2000prf.googlegroups.com...
> When using the maintenance plan wizard on SQL 2005 (RTM) when pressing
> the finish button the following error occurs when trying to create the
> plan.
> Maintenance Plan Wizard Progress
> Create maintenance plan failed.
> Additional Information:
> Create failed for JobStep 'Subplan'.
> (Microsoft.SqlServer.MaintenancePlanTasks)
> An Exception occurred while executing a Transact-SQL statement or
> batch. (Microsoft.SqlServer.ConnectionInfo)
> The specified '@.subsystem' is invalid (valid values are returned by
> sp_enum-sqlagent_subsystems). (Microsoft SQL Server, Error 14234)
>
> The job appears in the Job Activity Monitor but greyed out and the
> maintenance plan is not listed in its section.
> What has caused this issue and how can I resolve it?

Error when creating a maintenance plan

When using the maintenance plan wizard on SQL 2005 (RTM) when pressing
the finish button the following error occurs when trying to create the
plan.
Maintenance Plan Wizard Progress
Create maintenance plan failed.
Additional Information:
Create failed for JobStep 'Subplan'.
(Microsoft.SqlServer.MaintenancePlanTasks)
An Exception occurred while executing a Transact-SQL statement or
batch. (Microsoft.SqlServer.ConnectionInfo)
The specified '@.subsystem' is invalid (valid values are returned by
sp_enum-sqlagent_subsystems). (Microsoft SQL Server, Error 14234)
The job appears in the Job Activity Monitor but greyed out and the
maintenance plan is not listed in its section.
What has caused this issue and how can I resolve it?You need to apply at least SP1 to your SQL Server instance to make
Maintanence Plan work properly. It'd be better if you apply SP2, it contains
lots of fixes.
Ekrem nsoy
"Robin9876" <robin9876@.hotmail.com> wrote in message
news:9c65cf4b-d7b1-4224-bc11-46da57c143c3@.i12g2000prf.googlegroups.com...
> When using the maintenance plan wizard on SQL 2005 (RTM) when pressing
> the finish button the following error occurs when trying to create the
> plan.
> Maintenance Plan Wizard Progress
> Create maintenance plan failed.
> Additional Information:
> Create failed for JobStep 'Subplan'.
> (Microsoft.SqlServer.MaintenancePlanTasks)
> An Exception occurred while executing a Transact-SQL statement or
> batch. (Microsoft.SqlServer.ConnectionInfo)
> The specified '@.subsystem' is invalid (valid values are returned by
> sp_enum-sqlagent_subsystems). (Microsoft SQL Server, Error 14234)
>
> The job appears in the Job Activity Monitor but greyed out and the
> maintenance plan is not listed in its section.
> What has caused this issue and how can I resolve it?|||Addition: If you do not install SSIS you'll not be able to use Maintanence
Plans in RTM version of SQL Server 2005. It's possible to use Maintanence
Plans without SSIS if you apply SP2.
Ekrem nsoy
"Robin9876" <robin9876@.hotmail.com> wrote in message
news:9c65cf4b-d7b1-4224-bc11-46da57c143c3@.i12g2000prf.googlegroups.com...
> When using the maintenance plan wizard on SQL 2005 (RTM) when pressing
> the finish button the following error occurs when trying to create the
> plan.
> Maintenance Plan Wizard Progress
> Create maintenance plan failed.
> Additional Information:
> Create failed for JobStep 'Subplan'.
> (Microsoft.SqlServer.MaintenancePlanTasks)
> An Exception occurred while executing a Transact-SQL statement or
> batch. (Microsoft.SqlServer.ConnectionInfo)
> The specified '@.subsystem' is invalid (valid values are returned by
> sp_enum-sqlagent_subsystems). (Microsoft SQL Server, Error 14234)
>
> The job appears in the Job Activity Monitor but greyed out and the
> maintenance plan is not listed in its section.
> What has caused this issue and how can I resolve it?

Error when creating a maintenance plan

When using the maintenance plan wizard on SQL 2005 (RTM) when pressing
the finish button the following error occurs when trying to create the
plan.
Maintenance Plan Wizard Progress
Create maintenance plan failed.
Additional Information:
Create failed for JobStep 'Subplan'.
(Microsoft.SqlServer.MaintenancePlanTasks)
An Exception occurred while executing a Transact-SQL statement or
batch. (Microsoft.SqlServer.ConnectionInfo)
The specified '@.subsystem' is invalid (valid values are returned by
sp_enum-sqlagent_subsystems). (Microsoft SQL Server, Error 14234)
The job appears in the Job Activity Monitor but greyed out and the
maintenance plan is not listed in its section.
What has caused this issue and how can I resolve it?You need to apply at least SP1 to your SQL Server instance to make
Maintanence Plan work properly. It'd be better if you apply SP2, it contains
lots of fixes.
--
Ekrem Önsoy
"Robin9876" <robin9876@.hotmail.com> wrote in message
news:9c65cf4b-d7b1-4224-bc11-46da57c143c3@.i12g2000prf.googlegroups.com...
> When using the maintenance plan wizard on SQL 2005 (RTM) when pressing
> the finish button the following error occurs when trying to create the
> plan.
> Maintenance Plan Wizard Progress
> Create maintenance plan failed.
> Additional Information:
> Create failed for JobStep 'Subplan'.
> (Microsoft.SqlServer.MaintenancePlanTasks)
> An Exception occurred while executing a Transact-SQL statement or
> batch. (Microsoft.SqlServer.ConnectionInfo)
> The specified '@.subsystem' is invalid (valid values are returned by
> sp_enum-sqlagent_subsystems). (Microsoft SQL Server, Error 14234)
>
> The job appears in the Job Activity Monitor but greyed out and the
> maintenance plan is not listed in its section.
> What has caused this issue and how can I resolve it?|||Addition: If you do not install SSIS you'll not be able to use Maintanence
Plans in RTM version of SQL Server 2005. It's possible to use Maintanence
Plans without SSIS if you apply SP2.
--
Ekrem Önsoy
"Robin9876" <robin9876@.hotmail.com> wrote in message
news:9c65cf4b-d7b1-4224-bc11-46da57c143c3@.i12g2000prf.googlegroups.com...
> When using the maintenance plan wizard on SQL 2005 (RTM) when pressing
> the finish button the following error occurs when trying to create the
> plan.
> Maintenance Plan Wizard Progress
> Create maintenance plan failed.
> Additional Information:
> Create failed for JobStep 'Subplan'.
> (Microsoft.SqlServer.MaintenancePlanTasks)
> An Exception occurred while executing a Transact-SQL statement or
> batch. (Microsoft.SqlServer.ConnectionInfo)
> The specified '@.subsystem' is invalid (valid values are returned by
> sp_enum-sqlagent_subsystems). (Microsoft SQL Server, Error 14234)
>
> The job appears in the Job Activity Monitor but greyed out and the
> maintenance plan is not listed in its section.
> What has caused this issue and how can I resolve it?

Error when creating a backup job

Hello, I'm trying to do a backup of a database by creating a job for it....
I'm entering the command but when I do a Parse to ensure that the syntax is
correct, I'm getting the following error:
"TITLE: Parse Command Text
--
The following errors were detected in the command text.
--
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
--
The identifier that starts with 'EXEC sp_addumpdecive 'disk',
'backup_file1', '\\tcl-fileserver3\backups\moss-weekly\weekly'
backup database WSS_Content to back' is too long. Maximum length is 128.
(Microsoft SQL Server, Error: 103)"
Is that because of the location(
'\\tcl-fileserver3\backups\moss-weekly\weekly') I am trying to do the backup
to?
Please help.....
ThanksShelly
Run in the job's step
BACKUP DATABASE dbname TO DISK = N'\\Server\folder\dbname.BAK'
"Shelley" <Shelley@.discussions.microsoft.com> wrote in message
news:17373ED1-5AF5-48BD-9161-0D39F4207BCB@.microsoft.com...
> Hello, I'm trying to do a backup of a database by creating a job for
> it....
> I'm entering the command but when I do a Parse to ensure that the syntax
> is
> correct, I'm getting the following error:
> "TITLE: Parse Command Text
> --
> The following errors were detected in the command text.
> --
> ADDITIONAL INFORMATION:
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
> --
> The identifier that starts with 'EXEC sp_addumpdecive 'disk',
> 'backup_file1', '\\tcl-fileserver3\backups\moss-weekly\weekly'
> backup database WSS_Content to back' is too long. Maximum length is 128.
> (Microsoft SQL Server, Error: 103)"
> Is that because of the location(
> '\\tcl-fileserver3\backups\moss-weekly\weekly') I am trying to do the
> backup
> to?
> Please help.....
> Thanks
>|||HI, ,thank you so much it worked.....
But I would like to know, what is the purose of the "N"?
Also, If i want to overwrite the backup, what do I need to include in the
command?
"Uri Dimant" wrote:
> Shelly
> Run in the job's steps
> BACKUP DATABASE dbname TO DISK => N'\\Server\folder\dbname.BAK'
>
> "Shelley" <Shelley@.discussions.microsoft.com> wrote in message
> news:17373ED1-5AF5-48BD-9161-0D39F4207BCB@.microsoft.com...
> > Hello, I'm trying to do a backup of a database by creating a job for
> > it....
> >
> > I'm entering the command but when I do a Parse to ensure that the syntax
> > is
> > correct, I'm getting the following error:
> >
> > "TITLE: Parse Command Text
> > --
> >
> > The following errors were detected in the command text.
> >
> > --
> > ADDITIONAL INFORMATION:
> >
> > An exception occurred while executing a Transact-SQL statement or batch.
> > (Microsoft.SqlServer.ConnectionInfo)
> >
> > --
> >
> > The identifier that starts with 'EXEC sp_addumpdecive 'disk',
> > 'backup_file1', '\\tcl-fileserver3\backups\moss-weekly\weekly'
> > backup database WSS_Content to back' is too long. Maximum length is 128.
> > (Microsoft SQL Server, Error: 103)"
> >
> > Is that because of the location(
> > '\\tcl-fileserver3\backups\moss-weekly\weekly') I am trying to do the
> > backup
> > to?
> >
> > Please help.....
> >
> > Thanks
> >
>
>|||Hi, thank you it worked.
However I would like to know what is the purpose of the "N"?
Also, If i want to overwrite the backup, what exactly do I need to include
in the command?
"Uri Dimant" wrote:
> Shelly
> Run in the job's step
> BACKUP DATABASE dbname TO DISK => N'\\Server\folder\dbname.BAK'
>
> "Shelley" <Shelley@.discussions.microsoft.com> wrote in message
> news:17373ED1-5AF5-48BD-9161-0D39F4207BCB@.microsoft.com...
> > Hello, I'm trying to do a backup of a database by creating a job for
> > it....
> >
> > I'm entering the command but when I do a Parse to ensure that the syntax
> > is
> > correct, I'm getting the following error:
> >
> > "TITLE: Parse Command Text
> > --
> >
> > The following errors were detected in the command text.
> >
> > --
> > ADDITIONAL INFORMATION:
> >
> > An exception occurred while executing a Transact-SQL statement or batch.
> > (Microsoft.SqlServer.ConnectionInfo)
> >
> > --
> >
> > The identifier that starts with 'EXEC sp_addumpdecive 'disk',
> > 'backup_file1', '\\tcl-fileserver3\backups\moss-weekly\weekly'
> > backup database WSS_Content to back' is too long. Maximum length is 128.
> > (Microsoft SQL Server, Error: 103)"
> >
> > Is that because of the location(
> > '\\tcl-fileserver3\backups\moss-weekly\weekly') I am trying to do the
> > backup
> > to?
> >
> > Please help.....
> >
> > Thanks
> >
>
>|||Shelley
1) You do not have to use N.
http://support.microsoft.com/kb/239530
2) Use WITH INIT option of the BACKUP DATABASE command
"Shelley" <Shelley@.discussions.microsoft.com> wrote in message
news:6E0ED4AC-38AA-41C6-916A-E752D62185EF@.microsoft.com...
> HI, ,thank you so much it worked.....
> But I would like to know, what is the purose of the "N"?
> Also, If i want to overwrite the backup, what do I need to include in the
> command?
> "Uri Dimant" wrote:
>> Shelly
>> Run in the job's steps
>> BACKUP DATABASE dbname TO DISK =>> N'\\Server\folder\dbname.BAK'
>>
>> "Shelley" <Shelley@.discussions.microsoft.com> wrote in message
>> news:17373ED1-5AF5-48BD-9161-0D39F4207BCB@.microsoft.com...
>> > Hello, I'm trying to do a backup of a database by creating a job for
>> > it....
>> >
>> > I'm entering the command but when I do a Parse to ensure that the
>> > syntax
>> > is
>> > correct, I'm getting the following error:
>> >
>> > "TITLE: Parse Command Text
>> > --
>> >
>> > The following errors were detected in the command text.
>> >
>> > --
>> > ADDITIONAL INFORMATION:
>> >
>> > An exception occurred while executing a Transact-SQL statement or
>> > batch.
>> > (Microsoft.SqlServer.ConnectionInfo)
>> >
>> > --
>> >
>> > The identifier that starts with 'EXEC sp_addumpdecive 'disk',
>> > 'backup_file1', '\\tcl-fileserver3\backups\moss-weekly\weekly'
>> > backup database WSS_Content to back' is too long. Maximum length is
>> > 128.
>> > (Microsoft SQL Server, Error: 103)"
>> >
>> > Is that because of the location(
>> > '\\tcl-fileserver3\backups\moss-weekly\weekly') I am trying to do the
>> > backup
>> > to?
>> >
>> > Please help.....
>> >
>> > Thanks
>> >
>>|||Hi, thanks alot..... it worked.
"Uri Dimant" wrote:
> Shelley
> 1) You do not have to use N.
> http://support.microsoft.com/kb/239530
> 2) Use WITH INIT option of the BACKUP DATABASE command
>
> "Shelley" <Shelley@.discussions.microsoft.com> wrote in message
> news:6E0ED4AC-38AA-41C6-916A-E752D62185EF@.microsoft.com...
> > HI, ,thank you so much it worked.....
> > But I would like to know, what is the purose of the "N"?
> > Also, If i want to overwrite the backup, what do I need to include in the
> > command?
> >
> > "Uri Dimant" wrote:
> >
> >> Shelly
> >> Run in the job's steps
> >> BACKUP DATABASE dbname TO DISK => >> N'\\Server\folder\dbname.BAK'
> >>
> >>
> >> "Shelley" <Shelley@.discussions.microsoft.com> wrote in message
> >> news:17373ED1-5AF5-48BD-9161-0D39F4207BCB@.microsoft.com...
> >> > Hello, I'm trying to do a backup of a database by creating a job for
> >> > it....
> >> >
> >> > I'm entering the command but when I do a Parse to ensure that the
> >> > syntax
> >> > is
> >> > correct, I'm getting the following error:
> >> >
> >> > "TITLE: Parse Command Text
> >> > --
> >> >
> >> > The following errors were detected in the command text.
> >> >
> >> > --
> >> > ADDITIONAL INFORMATION:
> >> >
> >> > An exception occurred while executing a Transact-SQL statement or
> >> > batch.
> >> > (Microsoft.SqlServer.ConnectionInfo)
> >> >
> >> > --
> >> >
> >> > The identifier that starts with 'EXEC sp_addumpdecive 'disk',
> >> > 'backup_file1', '\\tcl-fileserver3\backups\moss-weekly\weekly'
> >> > backup database WSS_Content to back' is too long. Maximum length is
> >> > 128.
> >> > (Microsoft SQL Server, Error: 103)"
> >> >
> >> > Is that because of the location(
> >> > '\\tcl-fileserver3\backups\moss-weekly\weekly') I am trying to do the
> >> > backup
> >> > to?
> >> >
> >> > Please help.....
> >> >
> >> > Thanks
> >> >
> >>
> >>
> >>
>
>|||N makes the string Unicode.
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"Shelley" wrote:
> Hi, thank you it worked.
> However I would like to know what is the purpose of the "N"?
> Also, If i want to overwrite the backup, what exactly do I need to include
> in the command?
> "Uri Dimant" wrote:
> > Shelly
> > Run in the job's step
> > BACKUP DATABASE dbname TO DISK => > N'\\Server\folder\dbname.BAK'
> >
> >
> > "Shelley" <Shelley@.discussions.microsoft.com> wrote in message
> > news:17373ED1-5AF5-48BD-9161-0D39F4207BCB@.microsoft.com...
> > > Hello, I'm trying to do a backup of a database by creating a job for
> > > it....
> > >
> > > I'm entering the command but when I do a Parse to ensure that the syntax
> > > is
> > > correct, I'm getting the following error:
> > >
> > > "TITLE: Parse Command Text
> > > --
> > >
> > > The following errors were detected in the command text.
> > >
> > > --
> > > ADDITIONAL INFORMATION:
> > >
> > > An exception occurred while executing a Transact-SQL statement or batch.
> > > (Microsoft.SqlServer.ConnectionInfo)
> > >
> > > --
> > >
> > > The identifier that starts with 'EXEC sp_addumpdecive 'disk',
> > > 'backup_file1', '\\tcl-fileserver3\backups\moss-weekly\weekly'
> > > backup database WSS_Content to back' is too long. Maximum length is 128.
> > > (Microsoft SQL Server, Error: 103)"
> > >
> > > Is that because of the location(
> > > '\\tcl-fileserver3\backups\moss-weekly\weekly') I am trying to do the
> > > backup
> > > to?
> > >
> > > Please help.....
> > >
> > > Thanks
> > >
> >
> >
> >|||Thank you
"Mohit K. Gupta" wrote:
> N makes the string Unicode.
> --
> Mohit K. Gupta
> B.Sc. CS, Minor Japanese
> MCTS: SQL Server 2005
>
> "Shelley" wrote:
> > Hi, thank you it worked.
> > However I would like to know what is the purpose of the "N"?
> > Also, If i want to overwrite the backup, what exactly do I need to include
> > in the command?
> >
> > "Uri Dimant" wrote:
> >
> > > Shelly
> > > Run in the job's step
> > > BACKUP DATABASE dbname TO DISK => > > N'\\Server\folder\dbname.BAK'
> > >
> > >
> > > "Shelley" <Shelley@.discussions.microsoft.com> wrote in message
> > > news:17373ED1-5AF5-48BD-9161-0D39F4207BCB@.microsoft.com...
> > > > Hello, I'm trying to do a backup of a database by creating a job for
> > > > it....
> > > >
> > > > I'm entering the command but when I do a Parse to ensure that the syntax
> > > > is
> > > > correct, I'm getting the following error:
> > > >
> > > > "TITLE: Parse Command Text
> > > > --
> > > >
> > > > The following errors were detected in the command text.
> > > >
> > > > --
> > > > ADDITIONAL INFORMATION:
> > > >
> > > > An exception occurred while executing a Transact-SQL statement or batch.
> > > > (Microsoft.SqlServer.ConnectionInfo)
> > > >
> > > > --
> > > >
> > > > The identifier that starts with 'EXEC sp_addumpdecive 'disk',
> > > > 'backup_file1', '\\tcl-fileserver3\backups\moss-weekly\weekly'
> > > > backup database WSS_Content to back' is too long. Maximum length is 128.
> > > > (Microsoft SQL Server, Error: 103)"
> > > >
> > > > Is that because of the location(
> > > > '\\tcl-fileserver3\backups\moss-weekly\weekly') I am trying to do the
> > > > backup
> > > > to?
> > > >
> > > > Please help.....
> > > >
> > > > Thanks
> > > >
> > >
> > >
> > >

Monday, March 26, 2012

Error when programmatically creating a data driven subscription

Friday, March 23, 2012

Error when installing SQL 2000 clustering

Monday, March 19, 2012

Error when creating Stored Procedure

Error when creating script to copy Stored Procedures

Error when creating schedule in Report Manager

Error when creating new database user

Error when creating new database user

Error when creating new database user

Error when creating new connection in DTS Designer

Error When Creating Maintenance Plan after SP2

Error When Creating Maintenance Plan after SP2

Error when creating DMX query

Error when creating a view

Error when creating a table based function

Error when creating a maintenance plan

Error when creating a maintenance plan

Error when creating a maintenance plan

Error when creating a backup job

Error when creating a backup job

Error when creating a backup job

Error running report

Blog Archive

About Me