Error removing a view

I have developer who created a view on a database in SQL MSDE 2000 and for some reason it was created without an owner. When I try to DROP this view I get the following error message:
Cannot drop the view 'V_RATE_CATEGORY', because it does not exist in the system catalog.
Any help on how I can get this view would dropped would be greatly appreciated
Thanks,
Jerry
hi,
"Jerbear64" <Jerbear64@.discussions.microsoft.com> ha scritto nel messaggio
news:77383992-90E5-4220-9866-01EDDAC0ADDF@.microsoft.com...
> I have developer who created a view on a database in SQL MSDE 2000 and for
>some reason it was created without an owner. When I try to DROP this view
I get
> the following error message:
> Cannot drop the view 'V_RATE_CATEGORY', because it does not exist in the
system
>catalog.
> Any help on how I can get this view would dropped would be greatly
appreciated
it's actually not possible the object not having an owner... it will inherit
the creator owner name...
if you logged in with a different login that not maps to that user, try
locating it with it's owner name in the form , owner_name.object_name
if his user name in the database is minnie, try
minnie.V_RATE_CATEGORY
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Jerry,
A similar question was just raised in the .server group. Do you know what
tool the developer was using? (I have only seen this when developing using
Access 2000 ADPs. But that may not be the only cause. That is why I am
curious.)
Russell Fields
"Jerbear64" <anonymous@.discussions.microsoft.com> wrote in message
news:27d5901c46449$0f74ce80$a601280a@.phx.gbl...[vbcol=seagreen]
> Modify the table sysobjects field UID and change it from a
> 11 to 1 and then I was able to remove the view.
> Jerry
>
> MSDE 2000 and for some reason it was created without an
> owner. When I try to DROP this view I get the following
> error message:
> not exist in the system catalog.
> be greatly appreciated
|||I know it should not be possible, but the owner came up showing a "null" value. How it happen I don't but it did.
Jerry
"Andrea Montanari" wrote:

> hi,
> "Jerbear64" <Jerbear64@.discussions.microsoft.com> ha scritto nel messaggio
> news:77383992-90E5-4220-9866-01EDDAC0ADDF@.microsoft.com...
> I get
> system
> appreciated
> it's actually not possible the object not having an owner... it will inherit
> the creator owner name...
> if you logged in with a different login that not maps to that user, try
> locating it with it's owner name in the form , owner_name.object_name
> if his user name in the database is minnie, try
> minnie.V_RATE_CATEGORY
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>

Error Relational and OLAP Engine

Hi Edward,

What is wrong with my cube?

The dbo.Prescription table is in the data source view.

Please advice

Ronald

You are receiving a message during processing of one of your partitions: 'Prescrition'

The error indicates your server cannot find the source table for your partition.

In the previous post I suggested you modify source table for partition 'Prescrition'.

Have you tried it? Did it work?

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

error opening table in Enterprise MGR

I am getting an error message when I try to open (to view the rows of) any
table in any of the databases on a SQL 7 server from the server where the
databases actually reside- it says:
"An unexpected error happened during this operation. [Query] - Query
Designer encountered a query error: Unspecified error
This error is new; I am able to query and get results from the tables in
query analyzer and I am able to view the tables through Enterprise Manager
when I link to these databases from another computer. I restarted SQL server
without any luck. Do you think it needs to be reinstalled?
Check the following article which addresses the issue:
FIX: Enterprise Manager Returns Unexpected Error on Table or
View
http://support.microsoft.com/?id=273472
-Sue
On Wed, 26 Jan 2005 07:47:03 -0800, "PatW"
<PatW@.discussions.microsoft.com> wrote:

>I am getting an error message when I try to open (to view the rows of) any
>table in any of the databases on a SQL 7 server from the server where the
>databases actually reside- it says:
>"An unexpected error happened during this operation. [Query] - Query
>Designer encountered a query error: Unspecified error
>This error is new; I am able to query and get results from the tables in
>query analyzer and I am able to view the tables through Enterprise Manager
>when I link to these databases from another computer. I restarted SQL server
>without any luck. Do you think it needs to be reinstalled?
sql

error opening table in Enterprise MGR

I am getting an error message when I try to open (to view the rows of) any
table in any of the databases on a SQL 7 server from the server where the
databases actually reside- it says:
"An unexpected error happened during this operation. [Query] - Query
Designer encountered a query error: Unspecified error
This error is new; I am able to query and get results from the tables in
query analyzer and I am able to view the tables through Enterprise Manager
when I link to these databases from another computer. I restarted SQL serve
r
without any luck. Do you think it needs to be reinstalled?Check the following article which addresses the issue:
FIX: Enterprise Manager Returns Unexpected Error on Table or
View
http://support.microsoft.com/?id=273472
-Sue
On Wed, 26 Jan 2005 07:47:03 -0800, "PatW"
<PatW@.discussions.microsoft.com> wrote:

>I am getting an error message when I try to open (to view the rows of) any
>table in any of the databases on a SQL 7 server from the server where the
>databases actually reside- it says:
>"An unexpected error happened during this operation. [Query] - Query
>Designer encountered a query error: Unspecified error
>This error is new; I am able to query and get results from the tables in
>query analyzer and I am able to view the tables through Enterprise Manager
>when I link to these databases from another computer. I restarted SQL serv
er
>without any luck. Do you think it needs to be reinstalled?

error opening table in Enterprise MGR

I am getting an error message when I try to open (to view the rows of) any
table in any of the databases on a SQL 7 server from the server where the
databases actually reside- it says:
"An unexpected error happened during this operation. [Query] - Query
Designer encountered a query error: Unspecified error
This error is new; I am able to query and get results from the tables in
query analyzer and I am able to view the tables through Enterprise Manager
when I link to these databases from another computer. I restarted SQL server
without any luck. Do you think it needs to be reinstalled?Check the following article which addresses the issue:
FIX: Enterprise Manager Returns Unexpected Error on Table or
View
http://support.microsoft.com/?id=273472
-Sue
On Wed, 26 Jan 2005 07:47:03 -0800, "PatW"
<PatW@.discussions.microsoft.com> wrote:
>I am getting an error message when I try to open (to view the rows of) any
>table in any of the databases on a SQL 7 server from the server where the
>databases actually reside- it says:
>"An unexpected error happened during this operation. [Query] - Query
>Designer encountered a query error: Unspecified error
>This error is new; I am able to query and get results from the tables in
>query analyzer and I am able to view the tables through Enterprise Manager
>when I link to these databases from another computer. I restarted SQL server
>without any luck. Do you think it needs to be reinstalled?

Error on a view

I am getting an error when I open a view err is:

Could not allocate ancillary table for view or function resolution. The maximum number of tables in a query (260) was exceeded.

How do I work aorund this issue?

On the assumption that you are using SQL Server 2000, there are a couple of KB articles on this:

http://support.microsoft.com/kb/818406
http://support.microsoft.com/kb/828269

Either way, it seems that the solution is to upgrade to SQL Server 2000 SP4.

Chris

|||

Chris,

That would be a long term fix. Is there any shortterm workaorund for this? pl let me know.

|||

Well, according to the second link I posted:

"If you still receive the "Msg 4414" error message, you may have to break up the query so that a lower number of tables or views are referenced in the query. You may change the view definition that is referenced in the problematic query to lower the number of tables that are referenced in the view."

Chris

Error occurs when tried to view table design in Enterprise Manager

Dear All,
I have a problem
When I tried to view the table design throught Enterprise Manager's "Design
Table" function
If prompted
Table "XXXXX" could not be loaded
ODBC error: [Microsoft][ODBC SQL Server Driver]Communication link fa
ilure
What's happen?
Thanks~~Have both the server instance and your client tools been patched with at
least SP3a? Are you connected to Enterprise Manager on the same machine as
the database, or are you accessing it from a remote machine? Is your server
registration set up using windows auth or sql auth? Have you considered
managing objects using Query Analyzer?
http://www.aspfaq.com/
(Reverse address to reply.)
"Utada P.W. SIU" <wing0508@.hotmail.com> wrote in message
news:OHNwtHV7EHA.3120@.TK2MSFTNGP12.phx.gbl...
> Dear All,
> I have a problem
> When I tried to view the table design throught Enterprise Manager's
"Design
> Table" function
> If prompted
> Table "XXXXX" could not be loaded
> ODBC error: [Microsoft][ODBC SQL Server Driver]Communication link
failure
> What's happen?
> Thanks~~
>|||My client pc haven't patch sp3a yet
however, when I using that sql server's Enterprise Manager to view the table
design, it prompt the same error to me...
Any idea'
Thanks~|||> Any idea'
Yes, install SP3a?
http://www.aspfaq.com/
(Reverse address to reply.)|||Installed...but still cannot view table design....
oh!!! how come!!!
it is very hard to create table by using sql statement...change table field
type by sql statement
add/delete/update field info by sql statement...
oh!!!|||> it is very hard to create table by using sql statement...change table
field
> type by sql statement
Have you looked at CREATE TABLE and ALTER TABLE in Books Online?
http://www.aspfaq.com/
(Reverse address to reply.)|||Of course
I mean that it is too trouble to using code to create table or alter table
structure,...
hehe~

Error occurs when tried to view table design in Enterprise Manager

Dear All,
I have a problem
When I tried to view the table design throught Enterprise Manager's "Design
Table" function
If prompted
Table "XXXXX" could not be loaded
ODBC error: [Microsoft][ODBC SQL Server Driver]Communication link failure
What's happen?
Thanks~~Have both the server instance and your client tools been patched with at
least SP3a? Are you connected to Enterprise Manager on the same machine as
the database, or are you accessing it from a remote machine? Is your server
registration set up using windows auth or sql auth? Have you considered
managing objects using Query Analyzer?
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Utada P.W. SIU" <wing0508@.hotmail.com> wrote in message
news:OHNwtHV7EHA.3120@.TK2MSFTNGP12.phx.gbl...
> Dear All,
> I have a problem
> When I tried to view the table design throught Enterprise Manager's
"Design
> Table" function
> If prompted
> Table "XXXXX" could not be loaded
> ODBC error: [Microsoft][ODBC SQL Server Driver]Communication link failure
> What's happen?
> Thanks~~
>|||My client pc haven't patch sp3a yet
however, when I using that sql server's Enterprise Manager to view the table
design, it prompt the same error to me...
Any idea'
Thanks~|||> Any idea'
Yes, install SP3a?
--
http://www.aspfaq.com/
(Reverse address to reply.)|||Installed...but still cannot view table design....
oh!!! how come!!!
it is very hard to create table by using sql statement...change table field
type by sql statement
add/delete/update field info by sql statement...
oh!!!|||> it is very hard to create table by using sql statement...change table
field
> type by sql statement
Have you looked at CREATE TABLE and ALTER TABLE in Books Online?
--
http://www.aspfaq.com/
(Reverse address to reply.)|||Of course
I mean that it is too trouble to using code to create table or alter table
structure,...
hehe~

Error Msg 8618 with Indexed View

Server version is:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Been having some challenges with the use of an indexed view. We've worked
most of them out, but this one hit us today, and I haven't got a clue.
Dropping the view instantly made the error go away, so we're positive the
error is caused by the presence of the view.
Came up dry in the MS KB, with one reference in the fixlist for SQL 7 SP2. A
google search turned up a couple of unanswered threads, where the core cause
was the table rowsize obviously too big. Neither of those appear to apply in
this case.
ERROR MESSAGE:
Msg 8618, Level 16, State 2, Line 1
Warning: The query processor could not produce a query plan from the
optimizer because the total length of all the columns in the GROUP BY or
ORDER BY clause exceeds 8000 bytes.
CAUSED BY THIS UPDATE QUERY:
update tblAnswer
set answer = null
where row_ordinal = 5559208
CREATE TABLE [dbo].[tblAnswer] (
[ROW_ORDINAL] [decimal](38, 0) IDENTITY(1,1) NOT NULL,
[SurveyOrdinal] [int] NOT NULL,
[UserID] [varchar](40) NOT NULL,
[QuestionNumber] [nchar](50) NOT NULL,
[Answer] [nchar](2000) NULL,
[SurveyID] [int] NOT NULL,
[EntryDate] [datetime] NOT NULL,
[Change] [bit] NULL,
CONSTRAINT [PK_tblANSWER] PRIMARY KEY NONCLUSTERED
(
[ROW_ORDINAL] ASC
) ON [PRIMARY]
) ON [PRIMARY]
The table tblAnswer contains 554,127 rows as of today.
Because of the high volume of hits against the Answer column, and the
(unfortunate, but necessary) declaration of that column as 'nchar 2000', as
well as the high incidence of NULL values in that column, which we
(historically) have filtered since we don't really care about non-responses,
I opted to create an indexed view on a subset of the columns, where Answer
is not null. Note, also, that I'm trimming the 'nchar 2000' Answer column to
a 'varchar 400', so that the column can be used in the index.
This is the view definition:
set ansi_nulls on
go
set ansi_padding on
go
set ansi_warnings on
go
set arithabort on
go
set concat_null_yields_null on
go
set quoted_identifier on
go
set numeric_roundabort off
go
set nocount on
go
create view vwAnswerCurrent
with schemabinding
as
select row_ordinal, userid, questionnumber, rtrim(left(answer,400)) as
answer, surveyid
from dbo.tblAnswer
where change is null
go
create unique clustered index idxRowOrd
on vwAnswerCurrent (row_ordinal)
go
create nonclustered index idxUSQ
on vwAnswerCurrent (userid, surveyid, questionnumber)
go
create nonclustered index idxAnswer
on vwAnswerCurrent (answer)
go
In addition, because of a high volume of data access to this table, and the
presence of the view, via ASP.NET v1.1 code, we opted to SET ARITHABORT = ON
for the entire database, using 'ALTER DATABASE SET ARITHABORT = ON'. This
resolved our access issues via ASP.NET, and no other issues occurred since
enabling the ARITHABORT flag early last w. Until Today.
So.. my question is: What the heck am I missing, or misunderstanding, about
the use of indexed views that's not working here.
(p.s. Don't ask why the PK on Row_Ordinal is not clustered. I don't know,
but if I had my choice, it would be! But, it's not, in the table, but it is,
in my view declaration. <g> )"Lawrence Garvin" <onsitech@.news.postalias> wrote in message
news:u%23bVpMeJGHA.2036@.TK2MSFTNGP14.phx.gbl...
> Server version is:
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
> Been having some challenges with the use of an indexed view. We've worked
> most of them out, but this one hit us today, and I haven't got a clue.
> Dropping the view instantly made the error go away, so we're positive the
> error is caused by the presence of the view.
> Came up dry in the MS KB, with one reference in the fixlist for SQL 7 SP2.
> A google search turned up a couple of unanswered threads, where the core
> cause was the table rowsize obviously too big. Neither of those appear to
> apply in this case.
>
> ERROR MESSAGE:
> Msg 8618, Level 16, State 2, Line 1
> Warning: The query processor could not produce a query plan from the
> optimizer because the total length of all the columns in the GROUP BY or
> ORDER BY clause exceeds 8000 bytes.
> CAUSED BY THIS UPDATE QUERY:
> update tblAnswer
> set answer = null
> where row_ordinal = 5559208
> CREATE TABLE [dbo].[tblAnswer] (
> [ROW_ORDINAL] [decimal](38, 0) IDENTITY(1,1) NOT NULL,
> [SurveyOrdinal] [int] NOT NULL,
> [UserID] [varchar](40) NOT NULL,
> [QuestionNumber] [nchar](50) NOT NULL,
> [Answer] [nchar](2000) NULL,
> [SurveyID] [int] NOT NULL,
> [EntryDate] [datetime] NOT NULL,
> [Change] [bit] NULL,
> CONSTRAINT [PK_tblANSWER] PRIMARY KEY NONCLUSTERED
> (
> [ROW_ORDINAL] ASC
> ) ON [PRIMARY]
> ) ON [PRIMARY]
>
For what it's worth,
First, I have no idea what's really going on.
Second, this does not repro on SQL 2005.
Third the cause is QuestionNumber, not Answer.
[QuestionNumber] [nchar](50) NOT NULL,
Is a highly questionable choice of data type. Answer is variable length,
but QuestionNumber will always occupy 100 bytes on the page, no matter how
much data is in it.
Changing QuestionNumber to
[QuestionNumber] [nvarcharchar](50) NOT NULL,
Resolves the issue.
David|||"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
message news:O9LaaVfJGHA.1132@.TK2MSFTNGP10.phx.gbl...

> For what it's worth,
> First, I have no idea what's really going on.
> Second, this does not repro on SQL 2005.
This is good news. :-)

> Third the cause is QuestionNumber, not Answer.
Interesting!

> [QuestionNumber] [nchar](50) NOT NULL,
> Is a highly questionable choice of data type.
Yes, well, unfortunately, the /schema/ is not something I have a lot of
choice in the matter about. Whether the field needs to be Unicode, or
whether the field needs to be fixed length, are both points I'd probably
agree with you in a debate. Unfortunately, it's what I have to work with.

> Answer is variable length,
Actually, answer is 'nchar 2000' -- also fixed length.
The history of these column specs is a function of the -source- database,
which is an Oracle database on the back-end of a web front-end. The SQL
Server is being used for analysis and reporting.

> but QuestionNumber will always occupy 100 bytes on the page, no matter how
> much data is in it.
> Changing QuestionNumber to
> [QuestionNumber] [nvarcharchar](50) NOT NULL,
> Resolves the issue.
Thank you for the tip. I'll try reproducing this 'fix' on my development
server.

> David
>|||"Lawrence Garvin" <onsitech@.news.postalias> wrote in message
news:%23iAAGRqJGHA.2668@.tk2msftngp13.phx.gbl...
> "David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
> message news:O9LaaVfJGHA.1132@.TK2MSFTNGP10.phx.gbl...
>
> This is good news. :-)
>
> Interesting!
>
> Yes, well, unfortunately, the /schema/ is not something I have a lot of
> choice in the matter about. Whether the field needs to be Unicode, or
> whether the field needs to be fixed length, are both points I'd probably
> agree with you in a debate. Unfortunately, it's what I have to work with.
>
> Actually, answer is 'nchar 2000' -- also fixed length.
>
No nullable char or nchar are actually variable length columns. That's a
SQL Server engine technical detail, but I suspect it's somehow at the root
of the problem here.
David|||The view that you are trying to create is not valid for an indexed
view.
Note the error from database engine :
Warning: The optimizer cannot use the index because the select list of
the view contains a non-aggregate expression.
Cheers,
Arun|||Gee.. thanks, Arun.
Do you have a WHY to go along with your statement?
The view -is- created, and it -is- usable, and it -did- cause errors when
certain other issues were not set correctly, -and- David's suggestion to
make questionnumber a nvarchar field -did- eliminate the reported error
message.
<arun.ns@.gmail.com> wrote in message
news:1138795905.429665.271770@.g43g2000cwa.googlegroups.com...
> The view that you are trying to create is not valid for an indexed
> view.
> Note the error from database engine :
> Warning: The optimizer cannot use the index because the select list of
> the view contains a non-aggregate expression.
>
> Cheers,
> Arun
>

Error Message: Must declare variable @ID

I'm having trouble with a datalist. The default view is the Item Template which has an Edit button. When I click the Edit button, I run the following code (for the EditCommand of the Datalist):

DataList1.EditItemIndex = e.Item.ItemIndex

DataBind()

It errors out with the message "Must declare variable @.ID".

I've used this process on other pages without problem.

The primary key for the recordsource that populates this datalist is a field named "AutoID". There is another field named ID that ties these records to a master table. The list of rows returned in the datalist is based off the ID field matching a value in a dropdown list on the page (outside of the datalist). So my SQLdatasource has a parameter to match the ID field to @.ID. For some reason, it's not finding it and I cannot determine why. I haven't had this issue on other pages.

Here's my markup of the SQLDataSource and the Datalist/Edit Template:

<asp:SqlDataSourceID="SqlDataSource4"runat="server"ConnectionString="<%$ ConnectionStrings:SMARTConnectionString%>"

DeleteCommand="DELETE FROM [tblSalesSupport] WHERE [NBID] = @.NBID"

InsertCommand="INSERT INTO [tblSalesSupport] ([ID], [NBNC], [NBEC], [Description], [Estimate], [CompanyID], [CompanyName], [ProjectNumber]) VALUES (@.ID, @.NBNC, @.NBEC, @.Description, @.Estimate, @.CompanyID, @.CompanyName, @.ProjectNumber)"

SelectCommand="SELECT * FROM [tblSalesSupport] WHERE ([ID] = @.ID)"

UpdateCommand="UPDATE [tblSalesSupport] SET [ID] = @.ID, [NBNC] = @.NBNC, [NBEC] = @.NBEC, [Description] = @.Description, [Estimate] = @.Estimate, [CompanyID] = @.CompanyID, [CompanyName] = @.CompanyName, [ProjectNumber] = @.ProjectNumber WHERE [NBID] = @.NBID">

<DeleteParameters>

<asp:ParameterName="NBID"Type="Int32"/>

</DeleteParameters>

<UpdateParameters>

<asp:ParameterName="ID"Type="Int32"/>

<asp:ParameterName="NBNC"Type="Boolean"/>

<asp:ParameterName="NBEC"Type="Boolean"/>

<asp:ParameterName="Description"Type="String"/>

<asp:ParameterName="Estimate"Type="Decimal"/>

<asp:ParameterName="CompanyID"Type="Int32"/>

<asp:ParameterName="CompanyName"Type="String"/>

<asp:ParameterName="ProjectNumber"Type="String"/>

<asp:ParameterName="NBID"Type="Int32"/>

</UpdateParameters>

<SelectParameters>

<asp:ControlParameterControlID="ddlFind"Name="ID"PropertyName="SelectedValue"Type="Int32"/>

</SelectParameters>

<InsertParameters>

<asp:ParameterName="ID"Type="Int32"/>

<asp:ParameterName="NBNC"Type="Boolean"/>

<asp:ParameterName="NBEC"Type="Boolean"/>

<asp:ParameterName="Description"Type="String"/>

<asp:ParameterName="Estimate"Type="Decimal"/>

<asp:ParameterName="CompanyID"Type="Int32"/>

<asp:ParameterName="CompanyName"Type="String"/>

<asp:ParameterName="ProjectNumber"Type="String"/>

</InsertParameters>

</asp:SqlDataSource>

<asp:DataListCssClass="MainFormDisplay"ID="DataList1"runat="server"DataKeyField="NBID"DataSourceID="SqlDataSource1"width="100%">

<HeaderTemplate>….</HeaderTemplate>

<ItemTemplate>….</ItemTemplate>

<EditItemTemplate>

<tableborder="0" style="width: 100%">

<trclass="MainFormDisplay" valign="top">

<tdcolspan="8">

<asp:TextBoxID="txtNBID"runat="server"Text='<%# Eval("NBID")%>'Visible="true"></asp:TextBox>

<asp:TextBoxID="txtID"runat="server"Text='<%# Bind("ID")%>'Visible="True"></asp:TextBox></td>

</tr>

<trclass="MainFormDisplay">

<tdvalign="top"style="width: 100px"><asp:CheckboxID="chkNBNC"runat="server"Checked='<%# Bind("NBNC")%>'/></td>

<tdstyle="width: 100"><asp:CheckBoxID="chkNBEC"runat="server"Checked='<%# Bind("NBEC")%>'Width="100px"/></td>

<tdstyle="width: 100px"><asp:TextBoxID="txtCompanyName"runat="server"Text='<%# Bind("CompanyName")%>'Width="100px"></asp:TextBox></td>

<tdstyle="width: 100px"><asp:TextBoxID="txtProjectNumber"runat="server"Text='<%# Bind("ProjectNumber")%>'Width="100px"></asp:TextBox></td>

<tdstyle="width: 100px"><asp:TextBoxID="txtDescription"runat="server"Text='<%# Bind("Description")%>'Width="100px"></asp:TextBox></td>

<tdstyle="width: 100px"><asp:TextBoxID="txtEstimate"runat="server"Text='<%# Bind("Estimate","{0:N2}")%>'Width="100px"></asp:TextBox></td>

<tdstyle="width: 55px"><asp:CheckBoxID="ckDeleteFlag"runat="server"/></td>

<tdstyle="width: 100px"><asp:ButtonID="ItemSaveButton"runat="server"CommandName="Update"Text="Save"/>

<asp:ButtonID="ItemCancelButton"runat="server"CommandName="Cancel"Text="Cancel"/></td>

</tr>

</table>

</EditItemTemplate>

</asp:DataList><br/>

You need to replace

<asp:ParameterName="ID"Type="Int32"/>

in your UpdateParameters with

<asp:ControlParameterControlID="ddlFind"Name="ID"PropertyName="SelectedValue"Type="Int32"/>

|||

Thank you very much for your reply. I have tried this though and I still get the same error.

I believe it's because it's not running the UpdateCommand at all at this point. When I click the Edit button, it simply flips it from ItemTemplate to EditTemplate, passing the index of the row that the user click on so that while in EditTemplate mode, the user can make changes to data, click save and update. The code that runs when the Edit button is clicked is the following: (This

Protected Sub DataList1_EditCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataListCommandEventArgs) Handles DataList1.EditCommand
DataList1.EditItemIndex = e.Item.ItemIndex
DataBind()
End Sub

Error message: Data mining Query builder cannot....

Hello,

I wrote a data mining plug-in algorithm in SSAS and now I am trying to view the lift chart in Management Studio. The studio gives the following error:

"The Data Mining Query builder control cannot be initialized due to the following problem:
Deserialization failed: Multiple definition of element 'Column12' causes the content model to become ambigious. A content model must be formed such that during validation of an element information item sequence, the particle contained directly, indirectly or implicitly therein with which to attempt to validate each item in the sequence in turn can be uniquely determined without examining the content or attributes of that item, and without any information about the items in the remainder of the sequence."

I really do not understand what i did wrong. Can anybody help me?

Thanks, Joris

Can you describe the model you built and list the steps you went through to get the lift chart?

Also, what type of algorithm does your plug-in provide? Does it support discrete or continuous predictable columns?

|||

My algorithm is a support vector machine and the predictable columns are only discrete. The dataset i used is the wdbc dataset of the UCI repository.

I tried to get the lift chart by right-clicking on the build model in SQL Server Management Studio and select "View Lift Chart". When I try to get the lift chart in VS Business Intelligence Studio, VS BI shows the lift chart.

|||

What version of SQL Server 2005 are you running? (check the version for SQL Server Management Studio under the Help->About in Mgmt Studio's file menu). Did you install a CTP build of SP2?

Would you be able to send your plug-in algorithm .exe as well as the model definition to raman.iyer at microsoft.com? We might need to reproduce your problem to investigate this further.

|||

The version of SQL Server Management Studio i am running is:

Microsoft SQL Server Management Studio 9.00.3042.00
Microsoft Analysis Services Client Tools 2005.090.3042.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 7.0.5730.11
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600

I installed SP2, but the specific build, i cannot remember. But as far as I can see in my control panel it is not a CTP build.

I have to discuss whether I can send my plug-in algorithm with Avanade Netherlands. I will let you know.

Error message: Data mining Query builder cannot....

Hello,

I wrote a data mining plug-in algorithm in SSAS and now I am trying to view the lift chart in Management Studio. The studio gives the following error:

"The Data Mining Query builder control cannot be initialized due to the following problem:
Deserialization failed: Multiple definition of element 'Column12' causes the content model to become ambigious. A content model must be formed such that during validation of an element information item sequence, the particle contained directly, indirectly or implicitly therein with which to attempt to validate each item in the sequence in turn can be uniquely determined without examining the content or attributes of that item, and without any information about the items in the remainder of the sequence."

I really do not understand what i did wrong. Can anybody help me?

Thanks, Joris

Can you describe the model you built and list the steps you went through to get the lift chart?

Also, what type of algorithm does your plug-in provide? Does it support discrete or continuous predictable columns?

|||

My algorithm is a support vector machine and the predictable columns are only discrete. The dataset i used is the wdbc dataset of the UCI repository.

I tried to get the lift chart by right-clicking on the build model in SQL Server Management Studio and select "View Lift Chart". When I try to get the lift chart in VS Business Intelligence Studio, VS BI shows the lift chart.

|||

What version of SQL Server 2005 are you running? (check the version for SQL Server Management Studio under the Help->About in Mgmt Studio's file menu). Did you install a CTP build of SP2?

Would you be able to send your plug-in algorithm .exe as well as the model definition to raman.iyer at microsoft.com? We might need to reproduce your problem to investigate this further.

|||

The version of SQL Server Management Studio i am running is:

Microsoft SQL Server Management Studio 9.00.3042.00
Microsoft Analysis Services Client Tools 2005.090.3042.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 7.0.5730.11
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600

I installed SP2, but the specific build, i cannot remember. But as far as I can see in my control panel it is not a CTP build.

I have to discuss whether I can send my plug-in algorithm with Avanade Netherlands. I will let you know.

error message in view to a linked server

arno,
Here is someone about a year ago getting a very similar error:
https://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1245831&SiteID=1
It seems that datatype mapping is at the root of the problem, so perhaps
this article (and its references) will help.
http://msdn2.microsoft.com/en-us/library/ms175970.aspx
But I have never seen this error myself.
RLF
"arno" <nospam@.invalid> wrote in message
news:ey2LLfeUIHA.1208@.TK2MSFTNGP05.phx.gbl...
> Hello,
> I have a firebird 1.5 application. In my sql-server 2000 I created a
> linked server to firebird using the firebird odbc driver. I cannot query
> one table because I get the following error:
> " [Non-interface error: Column 'ERHALTENABSCHLAG' (compile-time ordinal
> 35) of object 'LVVERW' was reported to have a DBTYPE of 5 at compile time
> and 131 at run time]. (Source: Microsoft OLE DB Provider for SQL Server)
> (SQL State: 01000) (NativeError: 7300)Error -2147217900 "
> How can I solve tis problem?
> I cannot find any corrupt data in that column. I can query the table w/o
> problems from an Access Database with odbc-links to the table. I can
> Import the table into an sql-server database using the odbc-driver w/o a
> problem, it is just impossible to run a query on the table of the linked
> server.
> regards
> arno
>
arno,
I don't want to post the whole thread, but these are some of the comments.
#1 - IgorB
I found that the problem is usually in the data type of the columns defined
in the Oracle view: for example SQL 2005 doesn't like a oracle INTEGER, but
if you convert the integer columns in a NUMBER the error will disappear. The
same with the Oracle VARCHAR2.
#2 - Hans G
It occured with Oracle >= 9.2.6 (w. Sql2000 and Sql2005).It only occurs on
Querys in the format of "select * from ORASRV..USER.TABLE"; and thereby
only; if the oracle-table has fields of type "number". When I alter the
oracle-number-fields to a more precise type of e.g. number(10), the problem
is solved.
#3 - Kev dock
It appears, from reading forums, that a field defined as "TEST NUMBER" is
typeless whereas a field defined as TEST NUMBER(10,2) is not - hence ODBC or
OLEDB drivers get confused as they dont know what to convert these things
to.
RLF
"arno" <nospam@.invalid> wrote in message
news:uiVC3iCVIHA.5208@.TK2MSFTNGP04.phx.gbl...
> Hello Russel,
>
> I cannot follow the link, and cannot google the postID. Can cut/paste the
> thread?
>
> I think it does not say what to do in a case of error.
> arno
>