Showing posts with label object. Show all posts
Showing posts with label object. Show all posts

Sunday, March 25, 2012

Can't assign connection manager object to DataReader Source

I'm trying to create a DataReader source object using a working ADO.NET Oracle Client connection object that exists in the connection manager.

Problem:

When I open the editor the DataReaderSrc component shows only one row under the Connection Managers tab:

Name=IDbConnection
Connection Manager=blank
Description=Managed connection manager

I cannot assign the ADO.NET connection (or any connections). I see a warning at the bottom of the Connection Managers tab:

"Not all connection managers have been set. Set all connection managers."

When I click refresh the warning message changes to:

"The runtime connection manager with the ID "" cannot be found. Verify that the connection manager collection has a connection manager with that ID."

I am prevented from removing the IDbConnection or assigning my Connection Manager object to the DataReader Source.

Thanks, -- Mike

I also have the same problem, I'm sure it must be some tiny detail somewhere / something very basic, but I have been unable to fix it. Can someone help? Thanks!

Hector

|||

I had the same problem because I was using the wrong Provider when specifying my Data Source.

Hope it helps,

Nuno

|||

I had the same problem. In my case the 'advanced editor for datareader source' is very, very confusing. First of all, you have to create a connection manager, which I did already. But, it was not at all intuitive that you have to click on the box under 'connection manager' and select a connection manager. By default the box is black and grayed out like both the other fields which you cannot change. Gee, thanks redmond.

|||Thanks for taking the time to post this answer. I finally learned this last week at a SQL Server training class. The instructor pointed out that you actually need to change the disabled looking box.|||

Hello.

I read that you found a solution, but I didn't understand it very well.

Could you tell me more how to resolve this problem. I have create the connection manager and a cant set it into the DataReader Source

Thank you.

|||

Data Reader source accepts connection manager of Type ADO.NET only.

so First you have to create a Connection Manager to your Data Base using ADO.net Provider ONLY.

open the advanced editior of data reader source, go to connection managers tab, you will see IdbConnection , beside that there will be another column named connection manger, select your created connection manager there (ADO.Net one). Then go to Component properties tab and in sql command enter your sql query. go to columns mapping tab ..now you can see your columns.

|||thank you for your reply. i resolve the problem.|||

hello,

i thought that I resolve the problem of the connection but there was another problem that didn't permit me to save the connection to the advanced editor.

the error is "Component is already connected. The component needs to be disconnected before attempting to connect it."

Can you help me?

Can't assign connection manager object to DataReader Source

I'm trying to create a DataReader source object using a working ADO.NET Oracle Client connection object that exists in the connection manager.

Problem:

When I open the editor the DataReaderSrc component shows only one row under the Connection Managers tab:

Name=IDbConnection
Connection Manager=blank
Description=Managed connection manager

I cannot assign the ADO.NET connection (or any connections). I see a warning at the bottom of the Connection Managers tab:

"Not all connection managers have been set. Set all connection managers."

When I click refresh the warning message changes to:

"The runtime connection manager with the ID "" cannot be found. Verify that the connection manager collection has a connection manager with that ID."

I am prevented from removing the IDbConnection or assigning my Connection Manager object to the DataReader Source.

Thanks, -- Mike

I also have the same problem, I'm sure it must be some tiny detail somewhere / something very basic, but I have been unable to fix it. Can someone help? Thanks!

Hector

|||

I had the same problem because I was using the wrong Provider when specifying my Data Source.

Hope it helps,

Nuno

|||

I had the same problem. In my case the 'advanced editor for datareader source' is very, very confusing. First of all, you have to create a connection manager, which I did already. But, it was not at all intuitive that you have to click on the box under 'connection manager' and select a connection manager. By default the box is black and grayed out like both the other fields which you cannot change. Gee, thanks redmond.

|||Thanks for taking the time to post this answer. I finally learned this last week at a SQL Server training class. The instructor pointed out that you actually need to change the disabled looking box.|||

Hello.

I read that you found a solution, but I didn't understand it very well.

Could you tell me more how to resolve this problem. I have create the connection manager and a cant set it into the DataReader Source

Thank you.

|||

Data Reader source accepts connection manager of Type ADO.NET only.

so First you have to create a Connection Manager to your Data Base using ADO.net Provider ONLY.

open the advanced editior of data reader source, go to connection managers tab, you will see IdbConnection , beside that there will be another column named connection manger, select your created connection manager there (ADO.Net one). Then go to Component properties tab and in sql command enter your sql query. go to columns mapping tab ..now you can see your columns.

|||thank you for your reply. i resolve the problem.|||

hello,

i thought that I resolve the problem of the connection but there was another problem that didn't permit me to save the connection to the advanced editor.

the error is "Component is already connected. The component needs to be disconnected before attempting to connect it."

Can you help me?

Can't assign connection manager object to DataReader Source

I'm trying to create a DataReader source object using a working ADO.NET Oracle Client connection object that exists in the connection manager.

Problem:

When I open the editor the DataReaderSrc component shows only one row under the Connection Managers tab:

Name=IDbConnection
Connection Manager=blank
Description=Managed connection manager

I cannot assign the ADO.NET connection (or any connections). I see a warning at the bottom of the Connection Managers tab:

"Not all connection managers have been set. Set all connection managers."

When I click refresh the warning message changes to:

"The runtime connection manager with the ID "" cannot be found. Verify that the connection manager collection has a connection manager with that ID."

I am prevented from removing the IDbConnection or assigning my Connection Manager object to the DataReader Source.

Thanks, -- Mike

I also have the same problem, I'm sure it must be some tiny detail somewhere / something very basic, but I have been unable to fix it. Can someone help? Thanks!

Hector

|||

I had the same problem because I was using the wrong Provider when specifying my Data Source.

Hope it helps,

Nuno

|||

I had the same problem. In my case the 'advanced editor for datareader source' is very, very confusing. First of all, you have to create a connection manager, which I did already. But, it was not at all intuitive that you have to click on the box under 'connection manager' and select a connection manager. By default the box is black and grayed out like both the other fields which you cannot change. Gee, thanks redmond.

|||Thanks for taking the time to post this answer. I finally learned this last week at a SQL Server training class. The instructor pointed out that you actually need to change the disabled looking box.|||

Hello.

I read that you found a solution, but I didn't understand it very well.

Could you tell me more how to resolve this problem. I have create the connection manager and a cant set it into the DataReader Source

Thank you.

|||

Data Reader source accepts connection manager of Type ADO.NET only.

so First you have to create a Connection Manager to your Data Base using ADO.net Provider ONLY.

open the advanced editior of data reader source, go to connection managers tab, you will see IdbConnection , beside that there will be another column named connection manger, select your created connection manager there (ADO.Net one). Then go to Component properties tab and in sql command enter your sql query. go to columns mapping tab ..now you can see your columns.

|||thank you for your reply. i resolve the problem.|||

hello,

i thought that I resolve the problem of the connection but there was another problem that didn't permit me to save the connection to the advanced editor.

the error is "Component is already connected. The component needs to be disconnected before attempting to connect it."

Can you help me?

Can't assign connection manager object to DataReader Source

I'm trying to create a DataReader source object using a working ADO.NET Oracle Client connection object that exists in the connection manager.

Problem:

When I open the editor the DataReaderSrc component shows only one row under the Connection Managers tab:

Name=IDbConnection
Connection Manager=blank
Description=Managed connection manager

I cannot assign the ADO.NET connection (or any connections). I see a warning at the bottom of the Connection Managers tab:

"Not all connection managers have been set. Set all connection managers."

When I click refresh the warning message changes to:

"The runtime connection manager with the ID "" cannot be found. Verify that the connection manager collection has a connection manager with that ID."

I am prevented from removing the IDbConnection or assigning my Connection Manager object to the DataReader Source.

Thanks, -- Mike

I also have the same problem, I'm sure it must be some tiny detail somewhere / something very basic, but I have been unable to fix it. Can someone help? Thanks!

Hector

|||

I had the same problem because I was using the wrong Provider when specifying my Data Source.

Hope it helps,

Nuno

|||

I had the same problem. In my case the 'advanced editor for datareader source' is very, very confusing. First of all, you have to create a connection manager, which I did already. But, it was not at all intuitive that you have to click on the box under 'connection manager' and select a connection manager. By default the box is black and grayed out like both the other fields which you cannot change. Gee, thanks redmond.

|||Thanks for taking the time to post this answer. I finally learned this last week at a SQL Server training class. The instructor pointed out that you actually need to change the disabled looking box.|||

Hello.

I read that you found a solution, but I didn't understand it very well.

Could you tell me more how to resolve this problem. I have create the connection manager and a cant set it into the DataReader Source

Thank you.

|||

Data Reader source accepts connection manager of Type ADO.NET only.

so First you have to create a Connection Manager to your Data Base using ADO.net Provider ONLY.

open the advanced editior of data reader source, go to connection managers tab, you will see IdbConnection , beside that there will be another column named connection manger, select your created connection manager there (ADO.Net one). Then go to Component properties tab and in sql command enter your sql query. go to columns mapping tab ..now you can see your columns.

|||thank you for your reply. i resolve the problem.|||

hello,

i thought that I resolve the problem of the connection but there was another problem that didn't permit me to save the connection to the advanced editor.

the error is "Component is already connected. The component needs to be disconnected before attempting to connect it."

Can you help me?

Can't assign connection manager object to DataReader Source

I'm trying to create a DataReader source object using a working ADO.NET Oracle Client connection object that exists in the connection manager.

Problem:

When I open the editor the DataReaderSrc component shows only one row under the Connection Managers tab:

Name=IDbConnection
Connection Manager=blank
Description=Managed connection manager

I cannot assign the ADO.NET connection (or any connections). I see a warning at the bottom of the Connection Managers tab:

"Not all connection managers have been set. Set all connection managers."

When I click refresh the warning message changes to:

"The runtime connection manager with the ID "" cannot be found. Verify that the connection manager collection has a connection manager with that ID."

I am prevented from removing the IDbConnection or assigning my Connection Manager object to the DataReader Source.

Thanks, -- Mike

I also have the same problem, I'm sure it must be some tiny detail somewhere / something very basic, but I have been unable to fix it. Can someone help? Thanks!

Hector

|||

I had the same problem because I was using the wrong Provider when specifying my Data Source.

Hope it helps,

Nuno

|||

I had the same problem. In my case the 'advanced editor for datareader source' is very, very confusing. First of all, you have to create a connection manager, which I did already. But, it was not at all intuitive that you have to click on the box under 'connection manager' and select a connection manager. By default the box is black and grayed out like both the other fields which you cannot change. Gee, thanks redmond.

|||Thanks for taking the time to post this answer. I finally learned this last week at a SQL Server training class. The instructor pointed out that you actually need to change the disabled looking box.|||

Hello.

I read that you found a solution, but I didn't understand it very well.

Could you tell me more how to resolve this problem. I have create the connection manager and a cant set it into the DataReader Source

Thank you.

|||

Data Reader source accepts connection manager of Type ADO.NET only.

so First you have to create a Connection Manager to your Data Base using ADO.net Provider ONLY.

open the advanced editior of data reader source, go to connection managers tab, you will see IdbConnection , beside that there will be another column named connection manger, select your created connection manager there (ADO.Net one). Then go to Component properties tab and in sql command enter your sql query. go to columns mapping tab ..now you can see your columns.

|||thank you for your reply. i resolve the problem.|||

hello,

i thought that I resolve the problem of the connection but there was another problem that didn't permit me to save the connection to the advanced editor.

the error is "Component is already connected. The component needs to be disconnected before attempting to connect it."

Can you help me?

sql

Cant allocate space for object

Hi!
I'm running mssql 6.5 and I've got a problem with a pretty basic errormessage. I've managed this scenario before, but I't doesnt seem to work this time...
The message is:

Can't allocate space for object '-482' in database 'tempdb' because the 'system' segment is full. If you ran out of space in Syslogs, dump the transaction log. Otherwise, use ALTER DATABASE or sp_extendsegment to increase the size of the segment. (Message

What I've done so far is:
dump transaction tempdb with truncate_only
Dump master ...
I've expanded the tempdb device (alter database)

Now I'm starting to run out of ideas...
What's this '-482' (I've also got an error on -386 once)
Anybody have any idea what to do next?

Thanks!!That is the ObjectId of the table in the database.

Thursday, March 22, 2012

cant access the datasource control

When I put a sqldatasource in my page and want to configure it and add a new connection to it I recieve this error : "object reference not set to an instance of an object" . Do you have any idea about solving this problem. please help me Thanks

Hi,

when asking a question about code or when you get an error always try to provide therelevant pieces of code and the error message that you get. This helps the people around here to better help you out.

Grz, Kris.

|||

My program has only a simple datagrid that should get data from a sql table and show it.This is only a test after changing the IIS settings. You can see my code here:

When I run this program I don't recieve any error but the explorer shows the blank page. When I try making connectionstring via sqldatasource I recieve that error:"the object reference...".thanks for helping

public

partialclassado1 : System.Web.UI.Page

{

privatevoid bindgrid()

{

string conStr ="Data Source=.;Initial Catalog=Northwind;Persist Security Info=True;User ID=sa";SqlConnection conn =newSqlConnection(conStr);// Open the connection

conn.Open();

// Create a data adapter objectSqlDataAdapter adapter =newSqlDataAdapter("SELECT * FROM testt", conn);DataSet ds =newDataSet();

adapter.Fill(ds);

GridView1.DataBind();

conn.Close();

}

protectedvoid Page_Load(object sender,EventArgs e)

{

if (!IsPostBack)

{

bindgrid();

}}}

///////////////////////////////

the body of aspx file is here:

<

body><formid="form1"runat="server"><div> <asp:SqlDataSourceID="SqlDataSource1"runat="server"></asp:SqlDataSource><asp:GridViewID="GridView1"runat="server"></asp:GridView></div></form>

</

body>

/////////////////////////////////////

|||

Hi,

hsharifi:

publicpartialclassado1 : System.Web.UI.Page

{

privatevoid bindgrid()

{

string conStr ="Data Source=.;Initial Catalog=Northwind;Persist Security Info=True;User ID=sa";

SqlConnection conn =newSqlConnection(conStr);

// Open the connection

conn.Open();

// Create a data adapter objectSqlDataAdapter adapter =newSqlDataAdapter("SELECT * FROM testt", conn);DataSet ds =newDataSet();

adapter.Fill(ds);

GridView1.DataBind();

conn.Close();

}

protectedvoid Page_Load(object sender,EventArgs e)

{

if (!IsPostBack)

{

bindgrid();

}}}

///////////////////////////////

the body of aspx file is here:

<

body><formid="form1"runat="server"><div> <asp:SqlDataSourceID="SqlDataSource1"runat="server"></asp:SqlDataSource><asp:GridViewID="GridView1"runat="server"></asp:GridView></div></form>

</

body>

/////////////////////////////////////

it seems like you're trying to do 2 things here: you want to use code & the SqlDataSource control together, that's a no go.

Get rid of the SqlDataSource control on your page and in the codefile, just before you call the DataBind() method place this line:

GridView1.DataSource = ds;
GridView1.DataBind();

Grz, Kris.

|||

Hi Xlll ,and thank you for replying me.

I did the thing that you said but my problem is still going on. After running my program the browser shows a blank page. I had to change many settings in IIS, do you think this problem is related to these changes or may be I should reinstall vs.net after that.

I would be glad to hear your opinion. Thanks

|||

Hi,

before re?nstalling you can first let the aspnet_regiis -i tool do its work to set the correct settings for the correct framework in IIS.

Something else that you can try: place a TextBox, Button and Label control on a webform. In the Button Click event you place this code:

Label1.Text = TextBox1.Text

and see if it executes well on your server. It's probably something stupid but I like to use such scenario's to quickly test out if ASP.NET is installed properly on a machine.

Grz, Kris.

Tuesday, March 20, 2012

Can't Access clusResource.OwnerNode Property

I cannot get any values from the OwnerNode property from the clusResource
class. An error appears: Object doesn't support this property or method
I can successfully obtain the Name, State and other properties from the
clusResource class.
How do i determine the owner of a given resource programatically using MS
Cluster Service Automation Classes? Using VB6...
Thanks in advance.
Chris
Found it. The OwnerNode property returns a clusNode object.
Set clusNode = clusResource.OwnerNode
debug.print clusNode.Name
Chris
"Chris" wrote:

> I cannot get any values from the OwnerNode property from the clusResource
> class. An error appears: Object doesn't support this property or method
> I can successfully obtain the Name, State and other properties from the
> clusResource class.
> How do i determine the owner of a given resource programatically using MS
> Cluster Service Automation Classes? Using VB6...
> Thanks in advance.
> Chris

Monday, March 19, 2012

cannot view wsdl of endpoint.

i created this endpoint in SSMS:

Code Snippet

/****** Object: Endpoint [first_Endpoint] Script Date: 06/19/2007 16:39:22 ******/

CREATEENDPOINT [first_Endpoint]

AUTHORIZATION [Domain\username]--scrubbed my username out of post!

STATE=STARTED

ASHTTP(PATH=N'/sql',

PORTS=(CLEAR),

AUTHENTICATION=(NTLM,KERBEROS,INTEGRATED),

SITE=N'sitename,

CLEAR_PORT= 80,

COMPRESSION=DISABLED)

FORSOAP(

WEBMETHOD 'provideInfo'(NAME=N'[adventureworks].[dbo].[uspGetBillOfMaterials]'

,SCHEMA=DEFAULT

, FORMAT=ALL_RESULTS),BATCHES=DISABLED,

SESSIONS=DISABLED,SESSION_TIMEOUT=60,

DATABASE=N'AdventureWorks',

NAMESPACE=N'http://tempuri.org/',

SCHEMA=STANDARD,

CHARACTER_SET=XML)

When i type http://localhost/sql/provideinfo?wsdl into internet explorer, i just get a 404 page cannot be found error.

When i type http://server/sql/provideinfo?wsdl in to the browser i get a Page cannot be displayd error.

I get the same when i type http://myServerName/sql/provideinfo?wsdl

I get the same when i type http://sitename/sql/provideinfo?wsdl

Sql server is running under an account with admin access to the box and sa access to the sql server. what am i doing wrong here that i cannot view my wsdl. oh, the OS is vista.

Could it be a configuration issue that im not seeing?

Can you try the following?
http://localhost/sql?wsdl

See also http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1372924&SiteID=1|||i tried http://localhost/sql?wsdl but still get a 401 not found error. as i am not getting the error speicifed in the link you provided, it would make me think that it is unrelated to my issue. thanks for the reply though.|||

when i use http://server/sql?wsdl i get a 502 error, a connection could not be made as the server actively refused it.

Are there some network settings i should change on my machine possibly?

|||Is server here the same name which you specified in SITE?|||no. the server and the site have different names. I have tried the url both ways though. when i specify the servername in the url, i get an iis page not found error. when i try with the sitename, i get a page cannot be displayed error.|||

The way the 'SITE' keyword value is treated is that it is passed to the OS HTTP.sys service. The HTTP.sys service uses a combination of information to determine which process to redirect the HTTP request to. In this scenario, only HTTP requests send to http://sitename/sql are redirected to this SQL Server endpoint. So, unless machine running SQL Server is named 'sitename', it is very unlikely that the HTTP request will get to SQL Server.

If possible, I recommend changing the SITE value to '*' or the actual machine name.

BTW, I believe the default value for the WSDL generation is NONE, so ?wsdl will get you a 502 HTTP error.

Jimmy

|||

Hi Jimmy.


That indeed was the problem!!! i dropped the endpoint, changed the site name to the name of the pc the endpoint is hosted upon and bingo!!!! cant believe i was so stupid in the first place!!!! it makes total sense now that i look at it! I expected to see the page that comes up when you view the definition of an enpoint in IE, but i also realise that that wont happen. i just see a lot of xml making up the wsdl file, and thats what i required. Thanks for the help and suggestions everyone, and Jimmy, for the answer that gave me the required results.

Cannot view sql server object properties in vstudio .net 2003

Hi!

Sudenly I stoped being able to view sql server object properties in the visual studio properties window . When I selected an sql server object in the server explorer i could see its properties in the prop. window . Now I can't see them anymore, the properties window apears blank.

Can anyone tell what do I need to do to be able to view them again.

Thanks & Best Regards
Pedro CostaHey-

I'm having this exact same problem. I'm researching to see if I can find anything, so if you beat me to it, please post the fix here. I'll do the same.|||What has changed between the time you COULD see them and right now? Did you install something? Apply a service pack? Remove something?|||I uninstalled VS.NET and installed VS.NET 2003. I'm using MSDE, BTW. I'm currently uninstalling and reinstalling MSDE, just for kicks. We'll see if it makes any difference. I'm wondering if the issue is permissions related somehow? But I'm logged in as a user with full admin rights on this machine, and I was under the impression that the IDE uses windows auth to connect to the database. Is this correct?
I've poked throught the environment preferences and I don't see anything that looks pertinent.

Sunday, March 11, 2012

Cannot use the reserved user or role name db_datareader.

Hi, I have got a problem. When I try to access my database table Users, I get the following error:
SELECT permission denied on object 'Users', database 'Users', owner 'dbo'.
SoI tried to grand this select command in MS Web Data Administration, butit doesnt work. When I try to grand db_datareader role to dbo, I getthe following error
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot use the reserved user or role name 'db_datareader'.

Does someone have an idea where could be a problem?

You don't need to be granting db_datareader to dbo, you need to beputting the user that you're accessing the database with in that role,or at least giving it SELECT permissions on that table, or better yet,giving it EXECUTE permissions on a stored proc that selects from thattable.

Thursday, March 8, 2012

Cannot update. Database or object are read-only

I have to build application Excel (interface) - SQL Server (backend)

I've created Data Source File "test.dsn" and tested succesfully.
SQL Server database in on the other machine.
This is a code that I am using.

And error message I am geting is "Cannot update. Database or object are read-only".

Dim cn As ADODB.Connection
Dim strSQL As String

Set cn = New ADODB.Connection
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\Documents and Settings\pd\Desktop\Development\test.xls;" & _
"Extended Properties=Excel 8.0"


strSQL = "INSERT INTO [DSN = test.dsn].Region Values(5, 'ab');"


cn.Execute strSQL

cn.Close
Set cn = Nothing

Read-only of databse properties is not selected.If I get it right you're attempting to insert a row into excel. As long as I know it's not possible because you cannot update, insert records throught Jet provider. mojza|||Your query is unclear . Understanding you are trying to update region table In sql database .
if that's case you should then rather open an ODBC or OLE DB connection to SQL server

cn.Provider = "sqloledb"
cn.Properties("Data Source") = ServerName
cn.Properties("Initial Catalog") = DatabaseName

' If Windows NT authentication.
cn.Properties("Integrated Security")= "SSPI"

'If SQL Authentication
cn.Properties("User ID")= UserID
cn.Properties("Password") = pwd

' Open the database.
cn.Open

Dim strSQL as string

strSQL "INSERT INTO dbo.Region Values(5, 'ab')"

cn.execute strSQL

cn.close
set cn = nothing

Cannot update the table in SQL Analyzer

I want to update the table
se.g update myTable set t1=0,t2= 0
However, i got the following error
Could not allocate space for object '(SYSTEM table id: -631615181)' in
database 'TEMPDB' because the 'DEFAULT' filegroup is full.Looks like you're either out of hard drive space on the SQL Server, or the
filegroup where your tempdb (and probably master, etc.) are. Check and make
sure you have enough drive space, and maybe run some dbcc on your database
once you're sure you have at least 10% hard drive space free.
- Nevyn
"Agnes" <agnes@.dynamictech.com.hk> wrote in message
news:%23w1JmfNCFHA.3976@.tk2msftngp13.phx.gbl...
>I want to update the table
> se.g update myTable set t1=0,t2= 0
> However, i got the following error
> Could not allocate space for object '(SYSTEM table id: -631615181)' in
> database 'TEMPDB' because the 'DEFAULT' filegroup is full.
>|||Agnes
1) Restart SQL Server (It will create a new TEMPDB)
2) DBCC SHRINKFILE
"Agnes" <agnes@.dynamictech.com.hk> wrote in message
news:%23w1JmfNCFHA.3976@.tk2msftngp13.phx.gbl...
> I want to update the table
> se.g update myTable set t1=0,t2= 0
> However, i got the following error
> Could not allocate space for object '(SYSTEM table id: -631615181)' in
> database 'TEMPDB' because the 'DEFAULT' filegroup is full.
>

Wednesday, March 7, 2012

Cannot transfer schemabound object - error

I am trying to alter the AdventureWorks database to transfer ownership from one schema to another...

Alter schema dbo transfer Person.CountryRegion

I get the following error..

"Cannot transfer a schemabound object."

Any help would be appreciated.Person.CountryRegion has foreign key references and an indexed view referencing it. So you need to resolve those before trying to transfer ownership. In this case, it looks like you have to drop the index on the view, perform the transfer and create the index back.

Sunday, February 19, 2012

Cannot show editor for this task in SQL 2005 Management Studio

Hi,

I have setup a db backup maintenance plan with the SQL 2005 Mgmt Studio tool. When I double-clicked the 'Back up Database Task' object I got the following error message. My SQL 2005 client has been patched with SQL 2005 SP2. Does someone know about this problem? Thanks - Joe

Cannot show editor for this task.

Additional information:

Value of '4/17/2007 12:00:00 AM' is not valid for Value'. Value should be between 'MinDate' and 'MaxDate'. Parameter name: Value(System.Windows.Forms)

I haven't heard of this one before. Please file a defect report for this issue at http://connect.microsoft.com/sqlserver. Issues reported on the Connect site go directly into our internal issue tracking system so we don't lose any information. Be sure to note whether the maintenance plan existed before your updated to SP2 or if the plan is new.

Thanks,

Steve

|||I'm getting this as well. Did you get an idea when this might be fixed.|||I'm getting this also. Did you get an idea when this might be fixed.|||

hello I have got the same problem, but in spanish.

The mantenience plan was created before updating to SP2, and now I can't edit the BackUp task.

I tryed diferent MSSMS Clients with the same server, and it always fails, so I assume this is from the server.

Error: (spanish)

No se puede mostrar el editor para esta tarea.

Información adicional:

El valor de '02/05/2007 0:00:00' no es válido para 'Value'. 'Value' debería estar entre 'MinDate' y 'MaxDate'.

Nombre del parámetro: Value (System.Windows.Forms)

|||

Strangely on my side, the day after having this error, everything was ok.

Did not apply any new service pack or correction att all.

Carl

|||

Solved same way, yesterday I created again one of the tasks, and today I can edit all them.

Summary: Solution, wait until tomorrow.

|||

Hello everyone,

Thanks for reporting this issue. The problem is that once the expiration date is reached, the UI cannot be displayed because the date value is earlier than what is allowed. While a solution is being worked out and will be available in a major release, a few work-arounds have been identified:

1. If no action is taken, on the day after the original expiration date, the "backup set will expire" option will be reset to a date that is 14 days from the current date and the task will be editable as usual.

2. If editing the task is required on the day it was set to expire, then one of the following two solutions can be used:

Solution A: The new task can be created in place of the existing task.

Solution B: The Backup Database task can be made editable by changing the “Backup set will expire” property in BIDS and importing the package back to the Maintenance Plan designer. Here are the steps to follow:

Edit your Maintenance Plan in the Server Business Intelligence Development Studio (BIDS)

· Find SQL Server Business Intelligence Development Studio on the Start menu under Microsoft SQL Server 2005.

· From the File menu, create a New Project of type “Integration Services Project”.

· To import your Maintenance Plan into your new project, in the Solution Explorer window, right click on the ‘SSIS Packages’ folder and choose the ‘Add Existing Package’ option.

· In the “Add Copy of Existing Package” dialog

o Set the Package Location to SQL Server

o Provide authentication for your server.

o In the Package Path field , click the browse button to display the packages on your server.

o Navigate to ‘SSIS Package’, then ‘Maintenance Plans’.

o Select your Maintenance Plan and click OK. You see the Maintenance Plan that you just imported under the ‘SSIS Packages’ folder.

· Right-Click the Backup Database Task and select Properties.

· In the list of properties, navigate to the “ExpireDate” option and change the date to be at least one day ahead of the current date.

· Save the Package.

· In the Solution Explorer window, click on the name of the package. In the Properties panel, locate the Full Path to the package’s .dtsx file. Select the path and copy it to the clipboard.

· Exit the Business Intelligence Development Studio.

Re-import the Edited Package

· In Management Studio, click the Connect button and choose “Integration Services…” and connect to your server.

· Under Stored Packages open “MSDB”.

· Right click on the “Maintenance Plans” folder and select “Import Package”.

o Select “File System”.

o In the Package Path text box, paste in the previously copied .dtsx file path.

o Click in the Package Name text box to set the name, and click OK.

· When prompted to overwrite the existing package, say “Yes”.

Given these updates, the Backup Database Task should be editable from the Maintenance Plan designer.

Sorry for the inconvenience.

-Sirish

Cannot show editor for this task in SQL 2005 Management Studio

Hi,

I have setup a db backup maintenance plan with the SQL 2005 Mgmt Studio tool. When I double-clicked the 'Back up Database Task' object I got the following error message. My SQL 2005 client has been patched with SQL 2005 SP2. Does someone know about this problem? Thanks - Joe

Cannot show editor for this task.

Additional information:

Value of '4/17/2007 12:00:00 AM' is not valid for Value'. Value should be between 'MinDate' and 'MaxDate'. Parameter name: Value(System.Windows.Forms)

I haven't heard of this one before. Please file a defect report for this issue at http://connect.microsoft.com/sqlserver. Issues reported on the Connect site go directly into our internal issue tracking system so we don't lose any information. Be sure to note whether the maintenance plan existed before your updated to SP2 or if the plan is new.

Thanks,

Steve

|||I'm getting this as well. Did you get an idea when this might be fixed.|||I'm getting this also. Did you get an idea when this might be fixed.|||

hello I have got the same problem, but in spanish.

The mantenience plan was created before updating to SP2, and now I can't edit the BackUp task.

I tryed diferent MSSMS Clients with the same server, and it always fails, so I assume this is from the server.

Error: (spanish)

No se puede mostrar el editor para esta tarea.

Información adicional:

El valor de '02/05/2007 0:00:00' no es válido para 'Value'. 'Value' debería estar entre 'MinDate' y 'MaxDate'.

Nombre del parámetro: Value (System.Windows.Forms)

|||

Strangely on my side, the day after having this error, everything was ok.

Did not apply any new service pack or correction att all.

Carl

|||

Solved same way, yesterday I created again one of the tasks, and today I can edit all them.

Summary: Solution, wait until tomorrow.

|||

Hello everyone,

Thanks for reporting this issue. The problem is that once the expiration date is reached, the UI cannot be displayed because the date value is earlier than what is allowed. While a solution is being worked out and will be available in a major release, a few work-arounds have been identified:

1. If no action is taken, on the day after the original expiration date, the "backup set will expire" option will be reset to a date that is 14 days from the current date and the task will be editable as usual.

2. If editing the task is required on the day it was set to expire, then one of the following two solutions can be used:

Solution A: The new task can be created in place of the existing task.

Solution B: The Backup Database task can be made editable by changing the “Backup set will expire” property in BIDS and importing the package back to the Maintenance Plan designer. Here are the steps to follow:

Edit your Maintenance Plan in the Server Business Intelligence Development Studio (BIDS)

· Find SQL Server Business Intelligence Development Studio on the Start menu under Microsoft SQL Server 2005.

· From the File menu, create a New Project of type “Integration Services Project”.

· To import your Maintenance Plan into your new project, in the Solution Explorer window, right click on the ‘SSIS Packages’ folder and choose the ‘Add Existing Package’ option.

· In the “Add Copy of Existing Package” dialog

o Set the Package Location to SQL Server

o Provide authentication for your server.

o In the Package Path field , click the browse button to display the packages on your server.

o Navigate to ‘SSIS Package’, then ‘Maintenance Plans’.

o Select your Maintenance Plan and click OK. You see the Maintenance Plan that you just imported under the ‘SSIS Packages’ folder.

· Right-Click the Backup Database Task and select Properties.

· In the list of properties, navigate to the “ExpireDate” option and change the date to be at least one day ahead of the current date.

· Save the Package.

· In the Solution Explorer window, click on the name of the package. In the Properties panel, locate the Full Path to the package’s .dtsx file. Select the path and copy it to the clipboard.

· Exit the Business Intelligence Development Studio.

Re-import the Edited Package

· In Management Studio, click the Connect button and choose “Integration Services…” and connect to your server.

· Under Stored Packages open “MSDB”.

· Right click on the “Maintenance Plans” folder and select “Import Package”.

o Select “File System”.

o In the Package Path text box, paste in the previously copied .dtsx file path.

o Click in the Package Name text box to set the name, and click OK.

· When prompted to overwrite the existing package, say “Yes”.

Given these updates, the Backup Database Task should be editable from the Maintenance Plan designer.

Sorry for the inconvenience.

-Sirish

Cannot show editor for this task in SQL 2005 Management Studio

Hi,

I have setup a db backup maintenance plan with the SQL 2005 Mgmt Studio tool. When I double-clicked the 'Back up Database Task' object I got the following error message. My SQL 2005 client has been patched with SQL 2005 SP2. Does someone know about this problem? Thanks - Joe

Cannot show editor for this task.

Additional information:

Value of '4/17/2007 12:00:00 AM' is not valid for Value'. Value should be between 'MinDate' and 'MaxDate'. Parameter name: Value(System.Windows.Forms)

I haven't heard of this one before. Please file a defect report for this issue at http://connect.microsoft.com/sqlserver. Issues reported on the Connect site go directly into our internal issue tracking system so we don't lose any information. Be sure to note whether the maintenance plan existed before your updated to SP2 or if the plan is new.

Thanks,

Steve

|||I'm getting this as well. Did you get an idea when this might be fixed.|||I'm getting this also. Did you get an idea when this might be fixed.|||

hello I have got the same problem, but in spanish.

The mantenience plan was created before updating to SP2, and now I can't edit the BackUp task.

I tryed diferent MSSMS Clients with the same server, and it always fails, so I assume this is from the server.

Error: (spanish)

No se puede mostrar el editor para esta tarea.

Información adicional:

El valor de '02/05/2007 0:00:00' no es válido para 'Value'. 'Value' debería estar entre 'MinDate' y 'MaxDate'.

Nombre del parámetro: Value (System.Windows.Forms)

|||

Strangely on my side, the day after having this error, everything was ok.

Did not apply any new service pack or correction att all.

Carl

|||

Solved same way, yesterday I created again one of the tasks, and today I can edit all them.

Summary: Solution, wait until tomorrow.

|||

Hello everyone,

Thanks for reporting this issue. The problem is that once the expiration date is reached, the UI cannot be displayed because the date value is earlier than what is allowed. While a solution is being worked out and will be available in a major release, a few work-arounds have been identified:

1. If no action is taken, on the day after the original expiration date, the "backup set will expire" option will be reset to a date that is 14 days from the current date and the task will be editable as usual.

2. If editing the task is required on the day it was set to expire, then one of the following two solutions can be used:

Solution A: The new task can be created in place of the existing task.

Solution B: The Backup Database task can be made editable by changing the “Backup set will expire” property in BIDS and importing the package back to the Maintenance Plan designer. Here are the steps to follow:

Edit your Maintenance Plan in the Server Business Intelligence Development Studio (BIDS)

· Find SQL Server Business Intelligence Development Studio on the Start menu under Microsoft SQL Server 2005.

· From the File menu, create a New Project of type “Integration Services Project”.

· To import your Maintenance Plan into your new project, in the Solution Explorer window, right click on the ‘SSIS Packages’ folder and choose the ‘Add Existing Package’ option.

· In the “Add Copy of Existing Package” dialog

o Set the Package Location to SQL Server

o Provide authentication for your server.

o In the Package Path field , click the browse button to display the packages on your server.

o Navigate to ‘SSIS Package’, then ‘Maintenance Plans’.

o Select your Maintenance Plan and click OK. You see the Maintenance Plan that you just imported under the ‘SSIS Packages’ folder.

· Right-Click the Backup Database Task and select Properties.

· In the list of properties, navigate to the “ExpireDate” option and change the date to be at least one day ahead of the current date.

· Save the Package.

· In the Solution Explorer window, click on the name of the package. In the Properties panel, locate the Full Path to the package’s .dtsx file. Select the path and copy it to the clipboard.

· Exit the Business Intelligence Development Studio.

Re-import the Edited Package

· In Management Studio, click the Connect button and choose “Integration Services…” and connect to your server.

· Under Stored Packages open “MSDB”.

· Right click on the “Maintenance Plans” folder and select “Import Package”.

o Select “File System”.

o In the Package Path text box, paste in the previously copied .dtsx file path.

o Click in the Package Name text box to set the name, and click OK.

· When prompted to overwrite the existing package, say “Yes”.

Given these updates, the Backup Database Task should be editable from the Maintenance Plan designer.

Sorry for the inconvenience.

-Sirish

|||

You can select the backup mainplan in the designer and press F4 to open the properties of the maintenanceplan in the designer.In the properties you can change the expiry date, this allows you to open the plan again for edit.

Cannot set Connection property of Backup database task if connection string is customized in con

I added a connection (ADO.NET) object by name testCon in the connection manager - I wanted to programmatically supply the connection string. So I used the "Expressions" property of the connection object and set the connectionstring to one DTS variable. The idea is to supply the connection string value to the variable - so that the connection object uses my connection string.

Then I added a "Backup Database Task" to my package with the name BkpTask. Now whenever I try to set the connection property of BkpTask to the testCon connection object, by typing testCon, it automatically gets cleared. I am not able to set the connection value.

Then after spending several hours I found that this is because I have customized the connection string in testCon. If I don't customize the connection string, I am able to enter the "testCon" value in the connection property of the BkpTask.

Is this an intrinsic issue?

Not quite sure what this issue is, but I tried this-

Created a ADO.Net connection and set an expression on the ConnectionString property. Evaluated value is a valid conn string.

Add a Backup DB Task, and set an expression on the Connection property. Evaluated value is name of connection created above.

Works fine, executes fine. If the Tasks' Connection property, the literal value is wrong at design-time, but will be correct at run-time when the expression is evaluated overriding the literal value, you may want to set the DelayValidation property to True for the task.

|||Thanks, this one - setting the DelayValidation was useful. What I tried was to customize the connectionstring in expression property of ConnectionManager. My issue is now solved, Thanks a lot.

Cannot set Connection property of Backup database task if connection string is customized in

I added a connection (ADO.NET) object by name testCon in the connection manager - I wanted to programmatically supply the connection string. So I used the "Expressions" property of the connection object and set the connectionstring to one DTS variable. The idea is to supply the connection string value to the variable - so that the connection object uses my connection string.

Then I added a "Backup Database Task" to my package with the name BkpTask. Now whenever I try to set the connection property of BkpTask to the testCon connection object, by typing testCon, it automatically gets cleared. I am not able to set the connection value.

Then after spending several hours I found that this is because I have customized the connection string in testCon. If I don't customize the connection string, I am able to enter the "testCon" value in the connection property of the BkpTask.

Is this an intrinsic issue?

Not quite sure what this issue is, but I tried this-

Created a ADO.Net connection and set an expression on the ConnectionString property. Evaluated value is a valid conn string.

Add a Backup DB Task, and set an expression on the Connection property. Evaluated value is name of connection created above.

Works fine, executes fine. If the Tasks' Connection property, the literal value is wrong at design-time, but will be correct at run-time when the expression is evaluated overriding the literal value, you may want to set the DelayValidation property to True for the task.

|||Thanks, this one - setting the DelayValidation was useful. What I tried was to customize the connectionstring in expression property of ConnectionManager. My issue is now solved, Thanks a lot.

Tuesday, February 14, 2012

Cannot see index in Object Explorer on Replicated Database

I have replicated all the tables from the Business Data database to my instance of SQL Server 2005. They did not create primary keys on the tables, so I am adding them on the replicated database. I was trying to save one of the tables after adding a new primary key and got this error message:

'BuildingValues' table
- Unable to create index 'PK_BuildingValues'. CREATE UNIQUE INDEX terminated because a duplicate key was found for object name 'dbo.BuildingValues' and index name 'PK_BuildingValues'. The duplicate key value is (2). Could not create constraint. See previous errors. The statement has been terminated.

The problem is that there is nothing displayed in the Indexes folder for this table in Object Viewer (or any of the other folders for this table), so how would I know an index already existed? The index shows up for this table on the Publisher database, but not the Replicated database. Is this normal?

Sounds like you only replicated the data over without transfering other objects (i.e. pk, constraints, indexes, etc.). The error here is that your current data is not qualified for a pk constraint - pk creates an unique key/constraint underneath, thus, the values cannot be duplicated.
To find the dupes, try:
select [your_pk_col]
from tb
group by [your_pk_col]
having count(*)>1
Resolve that and you should be able to create your pk.
Indexes should get created on the subscriber if you configure it during publication creation - go to the object properties.|||

Thank you very much for your answer. The articles at the Publisher were configured to replicate all the keys and constraints to the Subscriber. You were right about the cause of the problem. The index could not be created, because of duplicate values in the column on the Subscriber. Once I added another column to make it unique, the primary key worked fine. Thanks again.