Getting Column Name When Processing Error Ouput

Nov 10, 2006

I am working on a SSIS package. I want error records to be redirected to a different table. Natively, the package passes the Error Code and Column Code (don't know what to call it, but it's a number). I found a script to get the error description, but can't find an equivalent to get the Column name.

Any ideas?



Row.ErrorDescription = _

Me.ComponentMetaData.GetErrorDescription(Row.ErrorCode)

View 3 Replies


ADVERTISEMENT

Row Vs Column Processing Help!!

Jun 15, 2005

Hello friends,
I needed a suggestion, I am currently working on a reporting website that generates reports and i need to store all the reports in the database.

I usually go by row wise processing as it can be easily controlled but the problem is there will be a lot of reports, that is an estimation of 30,000 rows in a month and i m not sure if sql server can hold more than 2 billion rows per table.

Please Help!!

View 2 Replies View Related

It's A Computed Column Processing Bug?

Sep 25, 2007



Hello everybody!

I have question about indexed and not indexed Persisted columns on sql server 2005. It's a bug?

First?, my version of SQL Server is
Microsoft SQL Server 2005 - 9.00.3186.00 (Intel X86) Aug 11 2007 03:13:58 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)


Now I create two tables and try four select queries:


Code Snippet
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
SET ARITHABORT ON
SET CONCAT_NULL_YIELDS_NULL ON
SET NUMERIC_ROUNDABORT OFF
SET QUOTED_IDENTIFIER ON
GO
create table t1 (id int primary key, id_bigint as cast(id as bigint))
GO
create table t2 (id int primary key, id_bigint as cast(id as bigint) persisted)
GO
select * from t1 -- (1)
-- Clustered index scan with two times Compute Scalar
GO
select * from t2 -- (2)
-- Clustered index scan with one times Compute Scalar
GO
create index IX_t2 on t2 (id_bigint)
GO
select * from t2 -- (3)
-- Index Scan with one times Compute Scalar
GO
select * from t2 where id_bigint = 0 -- (4)
-- Index Seek with one times Compute Scalar
GO
drop table t1
GO
drop table t2
GO
SET ANSI_PADDING OFF



1. I don't understand why access to computed column raise scalar computation wto times?
2. I don't understand why access to persisted computed column raise any scalar computation?
3. I don't understand why access to persisted computed column over index required any scalar computations?

Can anyone from Microsoft SQL Server Team told me about this mistake?
It's a BUG or I incorrect understand value of the "PERSISTED" word?


--
Thanks with avanced.
WBR, Roman S. Golubin
grominc[at]gmail.com

View 3 Replies View Related

CLR Integration And Complex Column Processing

Oct 18, 2007

Hi,

I have to implement a complex algorithm that processes each row and each column.I have bunch complex steps at the end of which a table gets populated with the processed columns.

My question is whether it is possible and feasible to do this kind of processing using CLR integration or should I stick to T-SQL ?

One of the steps of processing involved per column is as follows:-
1)For each column,find successive invalid values from the start of the column.Invalid value= any value <0
2)find the invalid value depth of each column(no of successive invalid values from start)
3)If after these invalid vlaues,there is a valid value and another invalid value,replace current invalid value with valid value.
ie replace invalid value only if it has a valid value above it.
4)find the column with maximum invalue value depth and delete that many rows from the table.

Here's an example:-
Suppose there are 2 columsn colA and ColB.The columns have different datatypes eg decimal,int,string etc.
For simplicity colA and colB are ints.
RowID is keeping track of the row number.

suppose colA has the following data

RowID ColA
-----------
1 0
2 -5
3 -3
4 1
5 4
6 -9
7 5
8 8

Step1)successive invalid values from start=0,-5,-3
Step2)Invalid value depth=3(because there are 3 rows from step 1)
Step3)0,-5,-3 do not have any valid value above them.But -9 has a valid value 4 above it.So replace -9 with 4.

so colA after the algo will look as follows
RowID ColA
------------
1 0
2 -5
3 -3
4 1
5 4
6 4(replaced -9 with 4)
7 5
8 8

Now do the next column colB
RowID ColA
------------
1 -6
2 0
3 0
4 -7
5 4
6 8
7 -5
8 -8

Step1)successive invalid values from start=-6,0,0,-7
Step2)depth of invalid values=4
Step3)Next invalid value -5 occurs at RowID 7
and has a valid value 8 above it.
Replace -5 with previous valid vlaue ie 8.

RowID 8 has invalid value -8 .Its previous invalid value(-5) got replaced by a valid value 8.So replace RowID8 also with value of RowID 7 ie 8

Output at the end of these steps
RowID ColA
------------
1 -6
2 0
3 0
4 -7
5 4
6 8
7 8(replaced -5 with 8)
8 8(replaced -8 with 8)

Step4:Get the maximum invalid value depth
In this case ColB had depth=4 which is greater than ColA which had dept=3.
So delete 4 rows from the beginning of the table
So the output will be

RowID colA colB
----------------------------------------
5 4 4
6 4(replaced -9 with 4) 8
7 5 8 (replaced -5 with 8)
8 8 8(replaced -8 with 8)

Thanks in advance for your help

coolaqua

View 1 Replies View Related

Derived Column Not Processing Any Records

Apr 11, 2007

Hi,



I have built a package in which i use a derived column to create a new set of columns and then pass the same to another target transformation.

The issue now what I am facing is, the re are certain number of records coming from source(16 rows) and gets processed before the Derived Column transformation, but after that, no records gets processed after the derived column transformation.

The package status shows as Success, but there is no records being written in the target table.



Any idea what could be the issue here?



Thanks,

Manish

View 7 Replies View Related

Complex Column Processing Question

Oct 19, 2007


Hi,

I have to implement a complex algorithm that processes each row and each column.I have bunch complex steps at the end of which a table gets populated with the processed columns.


How do I do this using CLR integration?

One of the steps of processing involved per column is as follows:-
1)For each column,find successive invalid values from the start of the column.Invalid value= any value <0
2)find the invalid value depth of each column(no of successive invalid values from start)
3)If after these invalid vlaues,there is a valid value and another invalid value,replace current invalid value with valid value.
ie replace invalid value only if it has a valid value above it.
4)find the column with maximum invalue value depth and delete that many rows from the table.

Here's am example:-
Suppose there are 2 columsn colA and ColB.The columns have different datatypes eg decimal,int,string etc.
For simplicity colA and colB are ints.
RowID is keeping track of the row number.

suppose colA has the following data

RowID ColA
-----------
1 0
2 -5
3 -3
4 1
5 4
6 -9
7 5
8 8

Step1)successive invalid values from start=0,-5,-3
Step2)Invalid value depth=3(because there are 3 rows from step 1)
Step3)0,-5,-3 do not have any valid value above them.But -9 has a valid value 4 above it.So replace -9 with 4.

so colA after the algo will look as follows
RowID ColA
------------
1 0
2 -5
3 -3
4 1
5 4
6 4(replaced -9 with 4)
7 5
8 8

Now do the next column colB
RowID ColA
------------
1 -6
2 0
3 0
4 -7
5 4
6 8
7 -5
8 -8

Step1)successive invalid values from start=-6,0,0,-7
Step2)depth of invalid values=4
Step3)Next invalid value -5 occurs at RowID 7
and has a valid value 8 above it.
Replace -5 with previous valid vlaue ie 8.

RowID 8 has invalid value -8 .Its previous invalid value(-5) got replaced by a valid value 8.So replace RowID8 also with value of RowID 7 ie 8

Output at the end of these steps
RowID ColA
------------
1 -6
2 0
3 0
4 -7
5 4
6 8
7 8(replaced -5 with 8)
8 8(replaced -8 with 8)

Step4:Get the maximum invalid value depth
In this case ColB had depth=4 which is greater than ColA which had dept=3.so delete 4 rows from the beginning of the table
So the table will be

RowID colA colB
----------------------------------------
5 4 4
6 4(replaced -9 with 4) 8
7 5 8 (replaced -5 with 8)
8 8 8(replaced -8 with 8)

Thanks in advance for your help

coolaqua


View 1 Replies View Related

Subscription Error : Failure Sending Mail: An Error Has Occurred During Report Processing

Nov 16, 2007



Hello,

On the development server, I am trying to work with subscriptions . Report Server is windows authenticated.

When no paramters exist for the report, the sucbscription is successful.
But if there are paramters for the report, email delivery fails.

These are not data driven subscriptions.

Did anyone face the same problem ? Can anyone tell me where to start debugging since logfiles just say failure to send the email.

Thanks,
SqlNew

View 2 Replies View Related

Internal Error: An Unexpected Error Occurred In Analysis Services Processing

Apr 8, 2008



Hi There,

I've got this error coming up while running the sql job for AS processing. I can't find anything about it on google or anywhere else. Has anyone had issues like this?




Code Snippet
Executed as user: xyzsvc_sqlsvr. Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 1:21:02 PM Error: 2008-04-04 13:21:07.41 Code: 0xC1000000 Source: Analysis Services Processing Task Analysis Services Execute DDL Task Description: Internal error: An unexpected error occurred (file 'mdprocessdim.cpp', line 3429, function 'MDProcessPropertyJob::OnLaunch'). End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 1:21:02 PM Finished: 1:21:07 PM Elapsed: 5.141 seconds. The package execution failed. The step failed.





Thanks

Vivek

View 5 Replies View Related

Ouput Of Difference In Two Strings

Oct 31, 2005

Hi, I need an ouput of difference in two Strings

Declare @StringA varchar(100), @StringB varchar(100)

@StringA = 'A,B,C'
@StringB = 'A,C,C'

The values are seperated in the strings by ','

Since B value in first string changed to C value in the second string
I want to return the difference between the two strings as 'B,C'

Can anyone help me with this.

Thanks

View 2 Replies View Related

Multiple Ouput Parameter

Aug 8, 2007

is it possible to return multiple output values in stored prcodeure
for eg.
Create Proc XYZ
( @x int output,@y int output,@z int ouput)
As
Begin
SET @X= Select from table
SEt @Y=SELECT from table
set @z=slect from table
end

View 3 Replies View Related

When Asynchronous Processing=true, I Get Provider: SQL Network Interfaces, Error: 26 - Error Locating Server/Instance Specified

Sep 26, 2007

This problem happens on this particular machine and doesn't happen on other machines that I have. And I think this problem belongs to this forum. Because the problem is triggered by a special setting in the connection string.
I followed the steps of threads including Xinwei Hong's instruction for fixing this error(26) but has no luck.

The problem occurs when I call SqlConnection.Open().

I am using window xp, sql2000. the named instance is on local machine, my connection string is like

"Data Source=MSL-1417762\SQL2000;Initial Catalog=PopulateForeignKeys_MSL_1417762_2_5984;Integrated Security=True;Pooling=False;Asynchronous Processing=true"

Whenever I change Asynchronous Processing=true into Asynchronous Processing=false, the problem is gone.

This problem also occurs when I use Visual Studio - Server Explorer - Add Connection dialog - Advanced button - Advanced Properties window where you can set Asynchronous Processing property to true.

Can you please help?

Thanks,

View 1 Replies View Related

Reusing A Generated Column To Avoid Over Processing

Oct 22, 2007

Hi,I'm constructing a query that will performs a lot o datetimecalculumns to generate columns.All that operations are dependent of a base calculum that is performedon the query and its result is stored in a columna returned.I wanna find a way of reusing this generated column, to avoidreprocessing that calculumn to perform the other operations, causethat query will be used in a critical application, and all saving isfew.Thanks a lot.

View 2 Replies View Related

Ouput Parameter In &#34;select * From @tablename&#34;

Aug 30, 2000

Hi all.
I want something like this :
create proc myProc ( @num int ,@name varchar(80))
as
select @num = max(field1) from @name


but there is a problem that the @name is a varchar and the error is :
Server: Msg 170, Level 15, State 1, Procedure sp_myProc, Line 3
Line 3: Incorrect syntax near '@name'.

I tried
select @num = max(field1) from object_id(@name)
and the error was the same

is ther another way than :
exec ("declare @num int select @num = max(field1) insert into anotherTable values( @num) " ) ?
thx
Eyal Peleg

View 1 Replies View Related

Store Ouput From Select Statement

Aug 25, 2004

I am running a select statment which retruns one row how I can assign that results to a memory variable ?

thanks

View 2 Replies View Related

Ouput Based On Order Date

Jun 2, 2008

Hi all,
I have 2 tables, Order and Payment

Order
Order_NumberCust_NumberOrder_Date
10001 C1 23-May
10002 C2 24-May
10003 C1 25-May
10004 C3 28-May

Payment
Order_Number|Card_Type|Card_#|Merchant
10001 Gift Card1234null
10001 Gift Card1235null
10001 Gift Card 1236null
10001 Credit Cardxxxxprd
10002 Credit Cardxxxxprd
10003 Credit Card xxxxprd
10004 Credit Card xxxx prod

I have to populate th below table to track last gift card used for each cust_number.
1. last gift card used for each customer, each order
2. In a single order , if card used is gift card, last gift card used is gift card itself. if card used is a credit card, then the max gift card number from with in the order.
3. First time if a customer uses a credit card, then last gift card used is defaulted to 99 for merchant = prd and 88 for merchant = prod
4. In a new order, a past customer only uses a gift card, then last gift card used is gift card from his previous order.

[b]Last_Gift_Card
Cust_No|Order_number|card_number|last_gift_card

C11000112431234
C11000112351235
C11000112361236
C110001xxxx1236
C210002xxxx99
C110003xxxx1236
C310004xxxx88


Please help me with the sql.
I tried this using subqueries to find the max gift card for a customer for an order and could get the last gift card used correctly for credit cards for an order, but not able to insert the gift card from a previous order if the new order has only credit card as in for customer C1.

Thanks.

View 6 Replies View Related

Connect Multi Parameter To Ouput

May 31, 2007

I'm just starting to get a handle on parameters. I now want to create a parameter that is "multi-value". How do I get this to work? I have the report parameter set up, I just don't know how to actually get the report to use it.

Does it go in my dataset query? ie select 1,2,3 from table where 1 = @1

if so, how do you do this for a multi?

View 3 Replies View Related

Really Challenging Complex Column Level Processing Question

Oct 19, 2007

Hi,

I have to implement a complex algorithm that processes each row and each column.I have bunch complex steps at the end of which a table gets populated with the processed columns.


My question is as to what is the best way to do this?CLR integration or T-SQL?
Also I would appreciate any ideas as to how to go about using either approaches.

One of the steps of processing involved per column is as follows:-
1)For each column,find successive invalid values from the start of the column.Invalid value= any value <0
2)find the invalid value depth of each column(no of successive invalid values from start)
3)If after these invalid vlaues,there is a valid value and another invalid value,replace current invalid value with valid value.
ie replace invalid value only if it has a valid value above it.
4)find the column with maximum invalue value depth and delete that many rows from the table.

Here's am example:-
Suppose there are 2 columsn colA and ColB.The columns have different datatypes eg decimal,int,string etc.
For simplicity colA and colB are ints.
RowID is keeping track of the row number.

suppose colA has the following data

RowID ColA
-----------
1 0
2 -5
3 -3
4 1
5 4
6 -9
7 5
8 8

Step1)successive invalid values from start=0,-5,-3
Step2)Invalid value depth=3(because there are 3 rows from step 1)
Step3)0,-5,-3 do not have any valid value above them.But -9 has a valid value 4 above it.So replace -9 with 4.

so colA after the algo will look as follows
RowID ColA
------------
1 0
2 -5
3 -3
4 1
5 4
6 4(replaced -9 with 4)
7 5
8 8

Now do the next column colB
RowID ColA
------------
1 -6
2 0
3 0
4 -7
5 4
6 8
7 -5
8 -8

Step1)successive invalid values from start=-6,0,0,-7
Step2)depth of invalid values=4
Step3)Next invalid value -5 occurs at RowID 7
and has a valid value 8 above it.
Replace -5 with previous valid vlaue ie 8.

RowID 8 has invalid value -8 .Its previous invalid value(-5) got replaced by a valid value 8.So replace RowID8 also with value of RowID 7 ie 8

Output at the end of these steps
RowID ColA
------------
1 -6
2 0
3 0
4 -7
5 4
6 8
7 8(replaced -5 with 8)
8 8(replaced -8 with 8)

Step4:Get the maximum invalid value depth
In this case ColB had depth=4 which is greater than ColA which had dept=3.so delete 4 rows from the beginning of the table
So the table will be

RowID colA colB
----------------------------------------
5 4 4
6 4(replaced -9 with 4) 8
7 5 8 (replaced -5 with 8)
8 8 8(replaced -8 with 8)

Thanks in advance for your help

coolaqua


View 8 Replies View Related

Saving Store Procedure Ouput Into A Table

Feb 22, 2001

Does anyone know how to save the output of a stored procedure into a table? I would like to be able to use some procedures such as the sp_helpfile and dbcc sqlperf(logspace) and save to output into a table. Does anyone have any ideas?

View 2 Replies View Related

Processing Cube Error 211

Aug 14, 2000

When I process a new cube I recieve an error "Error (211): Unknown dimension member ' 8'; Time: 8/11/00 1:09:45 PM". Any ideas about what this error is about ?

View 2 Replies View Related

Cube Processing Error

Apr 14, 2004

Hi,
I am trying to Process a analysis server Cube and I am getting an error message saying

syntax error converting the varchar value A.H to column of type int.; 22018.

Can somebody tell me how to remove this error.

Thanks,
Praveen

View 2 Replies View Related

Error During Report Processing.

Mar 12, 2008




Any ideas.........

An error has occurred during report processing. (rsProcessingAborted)

Cannot create a connection to data source 'CRM'. (rsErrorOpeningConnection)


For more information about this error navigate to the report server on the local server machine, or enable remote errors

View 14 Replies View Related

Error During Report Processing

Apr 17, 2008

Hi all,
I have created a report on the client and want to deploy it on the server. I am able to deploy the report on the Server but whern i am trying to see that report from the server i am getting error.

The Error Is : -


An error has occurred during report processing. (rsProcessingAborted)

Cannot create a connection to data source 'DataSource1'. (rsErrorOpeningConnection)

For more information about this error navigate to the report server on the local server machine, or enable remote errors



Could you please help me?

View 4 Replies View Related

Reports Processing Error

Mar 4, 2008

Hi All,


I created a report using visual studio and published it in dev server which is in another machine. Then I connected a shared data source which was already publisehd earlier by someone else. I use a stored proceedure for the report which has two FromDate and Todate parameters. But once I deploy the report, i can not see it on report manager. When I try to view it, I get the following error

.

An error has occurred during report processing.

Query execution failed for data set 'DataSet1'.

For more information about this error navigate to the report server on the local server machine, or enable remote errors

Can anyone help me how to fix this error?

Thanks

View 3 Replies View Related

Error Processing A Cube

May 16, 2008



I just started getting a new error message to me:

Errors in the high-level relational engine. The data source view does not contain a definition for the 'WeightRecieved' column in the 'dbo_factPurchases' table or view.





The problem is WeightReceived IS defined in my DSV so I don't know what to do about this error.

Any suggestions?

View 4 Replies View Related

Question Concerning Error Processing.

Dec 4, 2007

Whenever OnError is triggered I send an email out notifying the appropiate personel. Is there a way I can capture and include the error message in the subject of the email easily? Thanks in Advance.

View 1 Replies View Related

Error For Processing Model

Feb 15, 2008


In the previous thread I said when I want to create a model and structure, in process time one error appeared that I said.
Now I think this error is because of my structure now I€˜ve one request i send my project and please see that and say what is this error?
Thanks a lot.
For creating mining structure and mining model I use the code of chapter14 file that one person had put for me

Please run this project and then say whay when I process my model ,the process do incorrectly.
in this code button 1 is for showing the anme of data bsase and table and column of that in currenyt server and then with button 2 i want ot creat model and struture and data source data source view
now please run this code and then say whay i have error for process model .
please run and answer me
thanks a lot


string last;

int ts;

string[] items;

string ky;

string t;

string dbnam;

string tblnam;

public Form1()

{

InitializeComponent();

}

private void button1_Click(object sender, EventArgs e)

{

SqlConnection con = new SqlConnection("Data Source=localhost;Integrated Security=True");

con.Open();

SqlCommand cmd1 = new SqlCommand(" EXEC sp_databases;", con);

DataSet ds = new DataSet();

SqlDataAdapter da1 = new SqlDataAdapter();

da1.SelectCommand = cmd1;

da1.Fill(ds, "1");

this.comboBox1.DisplayMember = "database_name";

this.comboBox1.ValueMember = "database_name";

this.comboBox1.DataSource = ds.Tables["1"];

SqlCommand cmd2 = new SqlCommand("USE " + comboBox1.Text.ToString() + " EXEC sp_tables @table_owner ='dbo';", con);

SqlDataAdapter da2 = new SqlDataAdapter();

da2.SelectCommand = cmd2;

da2.Fill(ds, "2");

this.comboBox2.DisplayMember = "table_name";

this.comboBox2.ValueMember = "table_name";

this.comboBox2.DataSource = ds.Tables["2"];

SqlCommand cmd3 = new SqlCommand("USE " + comboBox1.Text.ToString() + " EXEC sp_columns @table_name = N'" + comboBox2.Text.ToString() + "', @table_owner = N'DBO';", con);

SqlDataAdapter da3 = new SqlDataAdapter();

da3.SelectCommand = cmd3;

da3.Fill(ds, "3");

DataTable dt = new DataTable();

dt.Columns.Add("column_name");

dt.Columns.Add("data_type");

for (int i = 0; i < ds.Tables["3"].Rows.Count; i++)

{

DataRow dr = ds.Tables["3"].Rows;

dt.Rows.Add(dr[3], dr[5]);



}

con.Close();

dataGridView1.Columns.Clear();

dataGridView1.DataSource = dt;

DataGridViewCheckBoxColumn DVCC = new DataGridViewCheckBoxColumn();

DVCC.Name = "key";

dataGridView1.Columns.Add(DVCC);

DataGridViewCheckBoxColumn DVCC2 = new DataGridViewCheckBoxColumn();

DVCC2.Name = "input";

dataGridView1.Columns.Add(DVCC2);

DataGridViewCheckBoxColumn DVCC3 = new DataGridViewCheckBoxColumn();

DVCC3.Name = "predict";

dataGridView1.Columns.Add(DVCC3);



}

private void Form1_Load(object sender, EventArgs e)

{

}

private void button2_Click(object sender, EventArgs e)

{

dbnam = comboBox1.Text;

tblnam = comboBox2.Text;

Microsoft.AnalysisServices.Server srv = new Server();

srv.Connect("data source=localhost");

string dbname;

dbname = comboBox1.Text;



Database dbNew = new Database(dbname,

Utils.GetSyntacticallyValidID(dbname, typeof(Database)));

srv.Databases.Add(dbNew);

dbNew.Update();

//***************************//

string DataSourcename;

DataSourcename = comboBox1.Text;

RelationalDataSource dsNew = new RelationalDataSource(

DataSourcename,

Utils.GetSyntacticallyValidID(

DataSourcename,

typeof(RelationalDataSource)));

dsNew.ConnectionString = "Provider=SQLNCLI;Data Source=localhost;" +

"Initial Catalog="+comboBox1.Text+";Integrated Security=SSPI"; ;

dbNew.DataSources.Add(dsNew);

dsNew.Update();

//**************************//





DataSet dset = new DataSet();

SqlConnection cn = new SqlConnection("Data Source=localhost;" +

"Initial Catalog="+comboBox1.Text+";Integrated Security=true");

SqlDataAdapter da = new SqlDataAdapter("select * from "+comboBox2.Text,cn);



da.FillSchema(dset, SchemaType.Mapped, comboBox2.Text);

DataSourceView dsv = new DataSourceView(comboBox1.Text, comboBox1.Text);

dsv.DataSourceID = comboBox1.Text ;

dsv.Schema = dset.Clone();

dbNew.DataSourceViews.Add(dsv);

dbNew.Update(UpdateOptions.ExpandFull);







MiningStructure ms = dbNew.MiningStructures.Add(comboBox2.Text, Utils.GetSyntacticallyValidID(comboBox2.Text,

typeof(MiningStructure)));

ms.Source = new DataSourceViewBinding(comboBox1.Text);

ms.CaseTableName = comboBox2.Text;



int count = dataGridView1.Rows.Count;

for (int i = 0; i < count - 1; i++)

{







if (Convert.ToBoolean(dataGridView1.Rows.Cells["key"].Value) | Convert.ToBoolean(dataGridView1.Rows.Cells["input"].Value) | Convert.ToBoolean(dataGridView1.Rows.Cells["predict"].Value))

{

string X;





X = Convert.ToString(dataGridView1[0, i].Value);

ScalarMiningStructureColumn I;

I = new ScalarMiningStructureColumn(X,

Utils.GetSyntacticallyValidID(X, typeof(ScalarMiningStructureColumn)));

if (!Convert.ToBoolean(dataGridView1[2, i].Value))

{



I.IsKey = false;

I.Type = conv(Convert.ToString(dataGridView1[1, i].Value));

I.Content = "Continuous";



}

else

{

ky = X;

I.IsKey = true;

I.Content = "Key";

I.KeyColumns.Add(comboBox2.Text, X, OleDbType.Integer);

}

ms.Columns.Add(I);



}

// //****************************************************************************************************************************************//

}

ms.Update();

MiningModel mm = ms.MiningModels.Add(comboBox2.Text,

Utils.GetSyntacticallyValidID(comboBox2.Text, typeof(MiningModel)));

mm.Algorithm = "Microsoft_Time_Series";

for (int i = 0; i < count - 1; i++)

{

if (Convert.ToBoolean(dataGridView1.Rows.Cells["key"].Value) | Convert.ToBoolean(dataGridView1.Rows.Cells["input"].Value) | Convert.ToBoolean(dataGridView1.Rows.Cells["predict"].Value))

{

string X;

X = Convert.ToString(dataGridView1[0, i].Value);

MiningModelColumn mc = new MiningModelColumn(X,

Utils.GetSyntacticallyValidID(X, typeof(MiningModelColumn)));

mc.SourceColumnID = ms.Columns[X].ID;

if (Convert.ToBoolean(dataGridView1[2, i].Value))

mc.Usage = "Key";

else

if ((Convert.ToBoolean(dataGridView1[3, i].Value)) && (Convert.ToBoolean(dataGridView1[4, i].Value)))

mc.Usage = "Predict";

else

mc.Usage = "PredictOnly";

mm.Columns.Add(mc);

}

}

mm.Update();

ms.Process(ProcessType.ProcessStructure);

mm.Process(ProcessType.ProcessDefault);



srv.Disconnect();

SqlDataAdapter da2 = new SqlDataAdapter("select " + ky + " from " + comboBox2.Text, cn);

DataTable dt=new DataTable();

da2.Fill(dt);

ts = dt.Rows.Count;

items = new string[ts+10];

for (int i = 0; i < ts; i++)

{DataRow dr = dt.Rows;

items=dr[0].ToString();



}

last = items[ts-1];



}

private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)

{



SqlConnection con = new SqlConnection("Data Source=localhost;Integrated Security=True");

SqlCommand cmd2 = new SqlCommand("USE " + comboBox1.Text.ToString() + " EXEC sp_tables @table_owner ='dbo';", con);

con.Open();

SqlDataAdapter da2 = new SqlDataAdapter();

da2.SelectCommand = cmd2;

DataSet ds = new DataSet();

da2.Fill(ds, "2");

con.Close();

this.comboBox2.DisplayMember = "table_name";

this.comboBox2.ValueMember = "table_name";

this.comboBox2.DataSource = ds.Tables["2"];



if (comboBox2.Items.Count > 0)

{

comboBox2.SelectedIndex = 0;

}





}

private void comboBox2_SelectedIndexChanged(object sender, EventArgs e)

{

SqlConnection con = new SqlConnection("Data Source=localhost;Integrated Security=True");

SqlCommand cmd3 = new SqlCommand("USE " + comboBox1.Text.ToString() + " EXEC sp_columns @table_name = N'" + comboBox2.Text.ToString() + "', @table_owner = N'DBO';", con);

con.Open();

SqlDataAdapter da3 = new SqlDataAdapter();

da3.SelectCommand = cmd3;

DataSet ds = new DataSet();

da3.Fill(ds,"3");

con.Close();

dataGridView1.DataSource = "empty";



con.Close();

DataTable dt = new DataTable();

dt.Columns.Add("column_name");

dt.Columns.Add("data_type");



for (int i = 0; i < ds.Tables["3"].Rows.Count; i++)

{

DataRow dr = ds.Tables["3"].Rows;



dt.Rows.Add(dr[3], dr[5]);

}

dataGridView1.Columns.Clear();

dataGridView1.DataSource = dt;

DataGridViewCheckBoxColumn DVCC = new DataGridViewCheckBoxColumn();

DVCC.Name = "key";

dataGridView1.Columns.Add(DVCC);

DataGridViewCheckBoxColumn DVCC2 = new DataGridViewCheckBoxColumn();

DVCC2.Name = "input";

dataGridView1.Columns.Add(DVCC2);

DataGridViewCheckBoxColumn DVCC3 = new DataGridViewCheckBoxColumn();

DVCC3.Name = "predict";

dataGridView1.Columns.Add(DVCC3);



}

public string conv(string data_type)

{



if (data_type == "int" | data_type == "tinyint" | data_type == "smallint" | data_type == "bigint")

t = "Long";

else

if (data_type == "char" | data_type == "nchar" | data_type == "varchar" | data_type == "nvarchar" | data_type == "binary" | data_type == "varbinary" | data_type == "image" | data_type == "text" | data_type == "ntext" | data_type == "timestamp" | data_type == "uniqueidentifier")

t = "text";

else

if (data_type == "decimal" | data_type == "float" | data_type == "money" | data_type == "smallmoney" | data_type == "numeric" | data_type == "real")

t = "Double";

else

if (data_type == "datetime" | data_type == "smalldatetime")

t = "Date";

else

if(data_type=="bit")

t="Boolean";

return t;

}



}

}

View 2 Replies View Related

SQL 2012 :: Error Processing Cubes

Aug 19, 2014

I just finished migrating SQL 2005 - 2012 and I am having issues processing my cubes. I included the error message below with generic names, but I think it should be transparent. I seem to be having an issue with one of the logins, but which one. The error message points to "domain_nameserver_name$" with a $ at the end. I am assuming this is a SQL login? I have included the error message below:

<Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<Parallel>
<Process xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2"

[code]...

View 1 Replies View Related

Error When Processing Decision Tree

Jan 9, 2008

Hi,

I'm using SQL Server 2005 Standard Edition, and when I try to process a Decision Tree with more or less 50 input variables I get the following warning:


"Informational (Data mining): Automatic feature selection has been applied to model, TREE_2 due to the large number of attributes. Set MAXIMUM_INPUT_ATTRIBUTES and/or MAXIMUM_OUTPUT_ATTRIBUTES to increase the number of attributes considered by the algorithm."

I've tried to set MAXIMUM_INPUT_ATTRIBUTES to 10 and then there's an error saying: "The 'MAXIMUM_INPUT_ATTRIBUTES' data mining parameter is not valid for the 'TREE_2' model."


Does anyone have a clue of how can I solve it?


Thank you.

View 3 Replies View Related

An Error Has Occurred During Report Processing.

Mar 11, 2008

I have created several reports and deployed them successfully. However, when I return to view the reports some time later I receive the following error message:


An error has occurred during report processing.

Query execution failed for data set 'DataSet1'.

For more information about this error navigate to the report server on the local server machine, or enable remote errors
The only way I have been able to get round the issue is to re-deploy the reports. All reports are executed from Stored Procedures.

Does anyone have any ideas why this is happening?


View 10 Replies View Related

An Error Has Occurred During Report Processing.

Jan 29, 2008

Hi,

I am getting this error, after the report has been deployed to a remote server. When I click on perticular report I am getting this error.


An error has occurred during report processing.

Query execution failed for data set 'GLSQLBIS01_ProductionGLP_Connection'.


For more information about this error navigate to the report server on the local server machine, or enable remote errors






















Thank you
Gish

View 4 Replies View Related

Analysis :: Dimension Processing Error

Mar 14, 2013

I'm getting this error during processing one dimension.OLE DB error: OLE DB or ODBC error: SQL Server blocked access to STATEMENT 'OpenRowset/ OpenDatasource' of component 'Ad Hoc Distributed Queries' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Ad Hoc Distributed Queries' by using sp_configure. For more information about enabling 'Ad Hoc Distributed Queries', see "Surface Area Configuration" in SQL Server Books Online.; 42000.my dimension contains member from two datasource table.

and in another dimension i get error;Errors in the high-level relational engine. The 'dbo_vicidial_Users' table that is required for a join cannot be reached based on the relationships in the data source view.Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Staging User', Name of 'DimUsers' was being processed.

View 4 Replies View Related

* An Error Has Occurred During Report Processing.

Sep 14, 2007

Created Report using SQL Server Business Intelligence 2005 using Visual studio 2005
MSSQL Server 2005
datasource is a filteredAppointment dbo from MS CRM 3
Shared Datasource
Report runs in visual studio 2005

deployed to ReportServer no errors
Report showing on home page in Report Server
Data source folder also on report server page

go to run report on the report server via internet explorer

getting following message



An error has occurred during report processing.

Cannot create a connection to data source 'FilteredAppointments'.

For more information about this error navigate to the report server on the local server machine, or enable remote errorsPlease can any one help!!!!!!

I am a novice to reporting services, can any one recommend a good basic to intermediate book.
have been on the Microsoft 2030A MSSQL server 2000 reporting services 4 months ago and not had a chance to use it until know

Thank you for all your time
ralph

View 4 Replies View Related

Error While Processing Cube In SSAS 2008

Nov 4, 2009

i am getting the following error when i am processing the cube in SSAS 2008...Errors in the back-end database access module. The size specified for a binding was too small, resulting in one or more column values being truncated. Errors in the OLAP storage engine: An error occurred while the 'Policy Type' attribute of the 'Policy Type' dimension from the MyDemo' database.i verified the datatype column length for policytype column in the dimension as well as all fact views.

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved