ERROR: Subreport: manager

Showing posts with label manager. Show all posts

Thursday, March 22, 2012

ERwin

Hi,
I have just installed ERwin data modeler and can't seem to get past
the 'connection manager'. In 'Master dafatase' I have put: master but
it is saying invalid object master..m7License. I have enteretd the
license keys during installation. Do I have to make any changes in the
database too?
Thanks
It looks like the problem was either with your installation, your
configuration, or your rights. (I have not installed any of the more recent
versions of ERwin, so just things to look for.)
Installation: The installation apparently should have created the table
m7License in the master database, but perhaps that step failed.
Configuration: The table m7License was successfully created in another
database, but the ERwin application configuration does not know where the
table is.
Rights: Everything is where it should be, but you personally do not have
rights to the m7License table in master.
FWIW,
RLF
<othellomy@.yahoo.com> wrote in message
news:1175056298.365698.98030@.d57g2000hsg.googlegro ups.com...
> Hi,
> I have just installed ERwin data modeler and can't seem to get past
> the 'connection manager'. In 'Master dafatase' I have put: master but
> it is saying invalid object master..m7License. I have enteretd the
> license keys during installation. Do I have to make any changes in the
> database too?
> Thanks
>

ERwin

Hi,
I have just installed ERwin data modeler and can't seem to get past
the 'connection manager'. In 'Master dafatase' I have put: master but
it is saying invalid object master..m7License. I have enteretd the
license keys during installation. Do I have to make any changes in the
database too?
ThanksIt looks like the problem was either with your installation, your
configuration, or your rights. (I have not installed any of the more recent
versions of ERwin, so just things to look for.)
Installation: The installation apparently should have created the table
m7License in the master database, but perhaps that step failed.
Configuration: The table m7License was successfully created in another
database, but the ERwin application configuration does not know where the
table is.
Rights: Everything is where it should be, but you personally do not have
rights to the m7License table in master.
FWIW,
RLF
<othellomy@.yahoo.com> wrote in message
news:1175056298.365698.98030@.d57g2000hsg.googlegroups.com...
> Hi,
> I have just installed ERwin data modeler and can't seem to get past
> the 'connection manager'. In 'Master dafatase' I have put: master but
> it is saying invalid object master..m7License. I have enteretd the
> license keys during installation. Do I have to make any changes in the
> database too?
> Thanks
>

ERwin

Hi,
I have just installed ERwin data modeler and can't seem to get past
the 'connection manager'. In 'Master dafatase' I have put: master but
it is saying invalid object master..m7License. I have enteretd the
license keys during installation. Do I have to make any changes in the
database too?
ThanksIt looks like the problem was either with your installation, your
configuration, or your rights. (I have not installed any of the more recent
versions of ERwin, so just things to look for.)
Installation: The installation apparently should have created the table
m7License in the master database, but perhaps that step failed.
Configuration: The table m7License was successfully created in another
database, but the ERwin application configuration does not know where the
table is.
Rights: Everything is where it should be, but you personally do not have
rights to the m7License table in master.
FWIW,
RLF
<othellomy@.yahoo.com> wrote in message
news:1175056298.365698.98030@.d57g2000hsg.googlegroups.com...
> Hi,
> I have just installed ERwin data modeler and can't seem to get past
> the 'connection manager'. In 'Master dafatase' I have put: master but
> it is saying invalid object master..m7License. I have enteretd the
> license keys during installation. Do I have to make any changes in the
> database too?
> Thanks
>

Monday, March 19, 2012

ERRORS on Insert/Update DB2 from SQL Enterprise Manager (linked server)

I've set up an AS400/DB2 as a linked server, all standard configs (V4R5) on a SQL server 2000 machine and can select all day long. When I go to update or insert it throws an error referencing my driver. I'm using the HIS/OLEDB2 driver. Any ideas? Someone mentioned turning on Journaling on the 400?

Anything at this point would helpRE:
Q1 I'm using the HIS/OLEDB2 driver and can select all day long. When I go to update or insert it throws an error referencing my driver. Any ideas? Anything at this point would help

A1 Perhaps DB2 Connect provides a better odbc driver? Per IBM, DB2 Connect: "Provides extensive application programming tools for developing client-server and web applications using industry standard APIs such as ODBC, ADO, OLE DB, JDBC, SQLJ, DB2 CLI and Embedded SQL."

See: http://www-3.ibm.com/software/data/db2/db2connect/|||I found an answer that worked from a colleague. Thanks.

Errors in the trace from Enterprise manager

Hi,
I was running a trace for few hours and noticed bunch of
exception events. I cannot find descriptions for most of
these exceptions. One was especially frequent, coming
from enterprise manager:
Error: 208, Severity: 16, State: 1.
What was that about?
By the way, in the BOL I read that for exception events,
severity, error, and state columns should be included in
the trace, for getting meaningful result. However, I
found that including these columns has no significance,
because text column contains everything that is contained
in these 3 columns anyway.
Thanks
OJ
OJ wrote:
> Hi,
> I was running a trace for few hours and noticed bunch of
> exception events. I cannot find descriptions for most of
> these exceptions. One was especially frequent, coming
> from enterprise manager:
> Error: 208, Severity: 16, State: 1.
> What was that about?
> By the way, in the BOL I read that for exception events,
> severity, error, and state columns should be included in
> the trace, for getting meaningful result. However, I
> found that including these columns has no significance,
> because text column contains everything that is contained
> in these 3 columns anyway.
> Thanks
> OJ
You can ignore most of them. They are "object not found" errors which
are often raised when a procedure accesses a temp table. The error is
important, but in order to figure out if it's relevant, you need to
examine the SQL statement running prior to the error.
David Gugick
Imceda Software
www.imceda.com

Errors in the metadata manager while running "SQL Server 2005 Data Mining Configuration Wiz

Hi,

When I'm running Getting Started "Microsoft SQL Server 2005 Data Mining Add-Ins for Office 2005" for Excel and

1. choose "Use an existing instance of Microsoft SQL Server 2005 Analysis Services that I administer"

2. Click "Next"

3. To run the Server Configuration Utility, Click on link provided:

C:\Program Files\Microsoft SQL Server 2005 DM Add-Ins\Microsoft.SqlServer.DataMining.Office.ServerConfiguration.exe

4.This opens a new configuration wizard - SQL Server 2005 Data Mining Configuration Wizard

i. Click Next

ii. Select Server Name "localhost" and Clicked Next

iii. Checked "Allow creating temporary mining models" and Clicked Next

vi. In Step 3, By default radio button "Create New Database" is selected and Database Name is "DMAddinsDB"

Here, I've got following error in the message box :

Errors in the metadata manager. The dimension with ID of 'Dim Employee', Name of 'Dim Employee' referenced by the 'Adventure Works DW' cube, does not exist. Errors in the metadata manager. An error occurred when loading the Adventure Works DW cube, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Analysis Services Project1.0.db\Adventure Works DW.5.cub.xml'.

I've droped existing "Adventureworks" and "AdventureworksDW" databases and recreated again but still i'm getting the same problem.

Please help to resolve this problem

Thanks!

Regards,

K. Sandeep

It seems that the "Analysis Services Project1" database on your server is corrupted. Could you try to remove that database, then re-run the ...ServerConfiguration.exe application?

Errors in the metadata manager

Good afternoon,

I'm having the following error when I run my mining model.

Errors in the metadata manager. The dimension with the ID of 'TMP ~MC-ID' cannot be found in the '' database.

I think the error is in caseprocessor.cpp at the ProcessCase method. There's a code snippet below:

The intention of the following code snippet is to run over the attributes of a case and put them on a vector that holds all the cases.

for (UINT iAttribute = 0; iAttribute < _cAttribute; iAttribute++) {

if(iAttribute == 0)

continue;

if(iAttribute == 1)

continue;

if(iAttribute == 2)

continue;

if(iAttribute == 3) {

vet_termos.push_back(rgdmstatevalue[iAttribute].ch);

continue;

if(iAttribute == 4)

vet_dados.push_back(rgdmstatevalue[iAttribute].r8);

DBL dblValue = 0;

if (_vbCategorical[iAttribute]) {

dblValue = (_bMissingAtRandom)

? ::DblCategoricalMAR(rgdmstatevalue[iAttribute])

: ::DblCategorical(rgdmstatevalue[iAttribute]);

}

if (_viewtype == CASEREADER::viewtypeSparse) {

if (dblValue != dblMissing) {

CHECK_STL_MEM(_vdblValue.push_back(dblValue));

CHECK_STL_MEM(_viAttribute.push_back(iAttribute));

}

else {

_vdblValue[iAttribute] = dblValue;

}

The attributes of the table are like following:

Index (iAttribute) == 0 -> This is an auto-incremental ID and is the primary key. Integer.

Index (iAttribute) == 1 -> Another ID. Non-key on this table. It is Integer.

Index (iAttribute) == 2 -> Another ID. Non-key on this table. It is integer.

Index (iAttribute) == 3 -> A term. It's a word. This is non-key and the type is varchar.

Index (iAttribute) == 4 -> Weight of the word. Non-key and type double.

As you can notice I also changed the union DM_STATE_VALUE definition on dmalgo.h to accept the reading of a string (if (iAttribute == 3)) :

typedef /* [public][public][public][public][public][public][public] */ union __MIDLMIDL_itf_dmalgo_0000_0002 {

DM_STATE_INDEX si;

DOUBLE r8;

char* ch;

} DM_STATE_VALUE;

So... Does anyone can help me with the error I discribed on the metadata manager ? I would be very pleased with any help.

Thanks a lot for your attention.

-Renan Souza

Good afternoon,

I've tryed to run the Microsoft Clustering algorithm on this table and I've got the following error:

Error 1 Error (Data mining): The source OLAP object for the 'ID' column of the 'TMP' model cannot be found. 0 0

So... I think the error is, somehow, on the table structure, or somethig like that...

Any ideas on how to fix this problem ?

Thanks a lot once more,

-Renan

|||

Hello

First, could you please try a Process Full on the mining structure?

If that does not work, is it possible for you to send the definition of your structure? (Right-click on the structure in the SQL Server Management Studio, select Script as Create and send the script to "bogdanc at sqlserverdatamining dot com")

|||

Dear Mr. Crivat,

Thanks for your prompt reply.

I get this error when I try to deply the model, before I choose the Process Full option: Error 1 Error (Data mining): The source OLAP object for the 'ID' column of the 'TMP' model cannot be found. 0 0

When I get this error a window prompts and asks me if I wish to continue anyway. I click 'yes' but the process fails when I run the model.

This second error is the one I discribed earlyer, as following:

Errors in the metadata manager. The dimension with the ID of 'TMP ~MC-ID' cannot be found in the '' database.

Any clues ?

Thanks a lot once more,

-Renan

|||Could you please send me (or post here) the DDL script for your mining structure ? (I included my email in my previous post)|||

Dear Mr. Drivat,

Here's the script. I also sent it to your e-mail.

USE [BM_TEXTOS]

/****** Object: Table [dbo].[TMP] Script Date: 10/03/2001 10:23:50 ******/

SETANSI_NULLSON

SETQUOTED_IDENTIFIERON

SETANSI_PADDINGON

CREATETABLE [dbo].[TMP](

[ID] [int] NOTNULL,

[ID_DOC] [int] NOTNULL,

[ID_TERMO] [int] NOTNULL,

[TERMO] [varchar](max)COLLATE SQL_Latin1_General_CP1_CI_AS NOTNULL,

[FREQ] [real] NOTNULL,

PRIMARYKEYCLUSTERED

(

[ID] ASC

)WITH(IGNORE_DUP_KEY =OFF)ON [PRIMARY]

)ON [PRIMARY]

SETANSI_PADDINGOFF

Thanks a lot once more,

-Renan

|||

Hi
I meant, for the Analysis Services mining structure and model. This seems to be for the relational table that contains the training data

thanks

|||

Sorry... Forgive my mistake. Here's the script:

<DatabaseID>Analysis Services Project3</DatabaseID>

</ParentObject>

<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:CaseTableName</Name>

</Annotation>

<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:ShowFriendlyNames</Name>

</Annotation>

<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramLayout</Name>

<Value>

</mouseicon>

</diagram>

</layoutmanager>

</control>

</ddsxmlobj>

</layoutobject>

</ddscontrol>

</dds>

</Value>

</Annotation>

<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:ShowRelationshipNames</Name>

<Value>false</Value>

</Annotation>

<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:UseDiagramDefaultLayout</Name>

</Annotation>

<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramViewPortLeft</Name>

</Annotation>

<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramViewPortTop</Name>

</Annotation>

<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramBoundingLeft</Name>

</Annotation>

<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramBoundingTop</Name>

</Annotation>

<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramZoom</Name>

</Annotation>

</Annotations>

<DataSourceViewID>BM TEXTOS</DataSourceViewID>

</Source>

<Collation>Latin1_General_CI_AS</Collation>

<Type>Double</Type>

<Content>Continuous</Content>

<DataType>Single</DataType>

</Source>

</KeyColumn>

</KeyColumns>

</Column>

<DataType>Integer</DataType>

</Source>

</KeyColumn>

</KeyColumns>

</Column>

<Content>Continuous</Content>

<DataType>Integer</DataType>

</Source>

</KeyColumn>

</KeyColumns>

</Column>

<ID>ID TERMO</ID>

<Name>ID TERMO</Name>

<Content>Continuous</Content>

<DataType>Integer</DataType>

<ColumnID>ID_TERMO</ColumnID>

</Source>

</KeyColumn>

</KeyColumns>

</Column>

<ID>TERMO</ID>

<Name>TERMO</Name>

<Content>Discrete</Content>

<DataType>WChar</DataType>

<ColumnID>TERMO</ColumnID>

</Source>

</KeyColumn>

</KeyColumns>

</Column>

</Columns>

<Algorithm>PBM_K-MEANS</Algorithm>

<Usage>Predict</Usage>

<ModelingFlag>REGRESSOR</ModelingFlag>

</ModelingFlags>

</Column>

</Column>

<Usage>Predict</Usage>

<ModelingFlag>REGRESSOR</ModelingFlag>

</ModelingFlags>

</Column>

<ID>ID TERMO</ID>

<Name>ID TERMO</Name>

<SourceColumnID>ID TERMO</SourceColumnID>

<Usage>Predict</Usage>

<ModelingFlag>REGRESSOR</ModelingFlag>

</ModelingFlags>

</Column>

<ID>TERMO</ID>

<Name>TERMO</Name>

<SourceColumnID>TERMO</SourceColumnID>

<Usage>Predict</Usage>

</Column>

</Columns>

<Collation>Latin1_General_CI_AS</Collation>

</MiningModel>

</MiningModels>

</MiningStructure>

</ObjectDefinition>

</Create>

Thanks a lot once more,

-Renan

|||

Hello

The one unexpected thing I see in your structure is that the key column of the structure, ID, is marked as Key Time. Is this the intention? Key Time columns are modeled, inside the structure, differently than other columns. The Key Time modeling is intended for Time Series models, where the Key Time (the time slice) is an actual modeling attribute. Was that the intention?

If you only intend to keep ID as a Key (i.e. row identifier, used at most in drillthrough), then I'd suggest to change it to Key (instead of Key Time) and maybe remove the support for Key Time from your algorithm

Does this help?

|||

Dear Mr. Crivat,

Your explanations were very helpful, as usual.

I thought about this time key matter, so when I'm creating the mining structure using the wizard, I manually set the ID collumn as key (it first appears as time key) on the "Specify Column's Contents and Data Types" page.

But when I do it I get the following error when deploying: Error 1 Error (Data mining): The source OLAP object for the 'ID' column of the 'TMP' model cannot be found. 0 0

I realized that it happens because somewhere the ID column is set as"time key" and when I try to deploy it as "key, it crashes.

I'm creating the table on a external Java program that runs the following code:

CREATE TABLE TMP (ID INT NOT NULL, ID_DOC INT NOT NULL, ID_TERMO INT NOT NULL, TERMO VARCHAR(MAX) NOT NULL, FREQ REAL NOT NULL)

GO
ALTER TABLE TMP ADD PRIMARY KEY(ID ASC);

Is there some reason for the key's content is been created as time key ? How to fix it ?

Thanks a lot again,

-Renan

|||

First, make sure your algorithm supports Key and does not support key time. For this, in your metadata class, make sure that GetSupInputContentTypes includes DM_MININGCOLUMN_CONTENT_KEY and does not include DM_MININGCOLUMN_CONTENT_KEY_TIME.

This should fix the problem you are seeing. However, KEY_TIME is not supported by your algorithm, then one thing you could try is the following:

- create (using the wizard) a Decision Tree model on your data.

- in the newly created structure, add a related model using your algorithm

- remove the DT model

The creation of the DT model will configure the key properly at the structure level.

|||

Problem solved.

Thanks a lot again. But I've got a new one I'm posting on a new thread.

Errors in the metadata manager

Good afternoon,

I'm having the following error when I run my mining model.

Errors in the metadata manager. The dimension with the ID of 'TMP ~MC-ID' cannot be found in the '' database.

I think the error is in caseprocessor.cpp at the ProcessCase method. There's a code snippet below:

The intention of the following code snippet is to run over the attributes of a case and put them on a vector that holds all the cases.

for (UINT iAttribute = 0; iAttribute < _cAttribute; iAttribute++) {

if(iAttribute == 0)

continue;

if(iAttribute == 1)

continue;

if(iAttribute == 2)

continue;

if(iAttribute == 3) {

vet_termos.push_back(rgdmstatevalue[iAttribute].ch);

continue;

if(iAttribute == 4)

vet_dados.push_back(rgdmstatevalue[iAttribute].r8);

DBL dblValue = 0;

if (_vbCategorical[iAttribute]) {

dblValue = (_bMissingAtRandom)

? ::DblCategoricalMAR(rgdmstatevalue[iAttribute])

: ::DblCategorical(rgdmstatevalue[iAttribute]);

}

if (_viewtype == CASEREADER::viewtypeSparse) {

if (dblValue != dblMissing) {

CHECK_STL_MEM(_vdblValue.push_back(dblValue));

CHECK_STL_MEM(_viAttribute.push_back(iAttribute));

}

else {

_vdblValue[iAttribute] = dblValue;

}

The attributes of the table are like following:

Index (iAttribute) == 0 -> This is an auto-incremental ID and is the primary key. Integer.

Index (iAttribute) == 1 -> Another ID. Non-key on this table. It is Integer.

Index (iAttribute) == 2 -> Another ID. Non-key on this table. It is integer.

Index (iAttribute) == 3 -> A term. It's a word. This is non-key and the type is varchar.

Index (iAttribute) == 4 -> Weight of the word. Non-key and type double.

As you can notice I also changed the union DM_STATE_VALUE definition on dmalgo.h to accept the reading of a string (if (iAttribute == 3)) :

typedef /* [public][public][public][public][public][public][public] */ union __MIDLMIDL_itf_dmalgo_0000_0002 {

DM_STATE_INDEX si;

DOUBLE r8;

char* ch;

} DM_STATE_VALUE;

So... Does anyone can help me with the error I discribed on the metadata manager ? I would be very pleased with any help.

Thanks a lot for your attention.

-Renan Souza

Good afternoon,

I've tryed to run the Microsoft Clustering algorithm on this table and I've got the following error:

Error 1 Error (Data mining): The source OLAP object for the 'ID' column of the 'TMP' model cannot be found. 0 0

So... I think the error is, somehow, on the table structure, or somethig like that...

Any ideas on how to fix this problem ?

Thanks a lot once more,

-Renan

|||

Hello

First, could you please try a Process Full on the mining structure?

|||

Dear Mr. Crivat,

Thanks for your prompt reply.

When I get this error a window prompts and asks me if I wish to continue anyway. I click 'yes' but the process fails when I run the model.

This second error is the one I discribed earlyer, as following:

Errors in the metadata manager. The dimension with the ID of 'TMP ~MC-ID' cannot be found in the '' database.

Any clues ?

Thanks a lot once more,

-Renan

|||Could you please send me (or post here) the DDL script for your mining structure ? (I included my email in my previous post)|||

Dear Mr. Drivat,

Here's the script. I also sent it to your e-mail.

USE [BM_TEXTOS]

/****** Object: Table [dbo].[TMP] Script Date: 10/03/2001 10:23:50 ******/

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

SET ANSI_PADDING ON

CREATE TABLE [dbo].[TMP](

[ID] [int] NOT NULL,

[ID_DOC] [int] NOT NULL,

[ID_TERMO] [int] NOT NULL,

[TERMO] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[FREQ] [real] NOT NULL,

PRIMARY KEY CLUSTERED

(

[ID] ASC

)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]

) ON [PRIMARY]

SET ANSI_PADDING OFF

Thanks a lot once more,

-Renan

|||

Hi
I meant, for the Analysis Services mining structure and model. This seems to be for the relational table that contains the training data

thanks

|||

Sorry... Forgive my mistake. Here's the script:

<DatabaseID>Analysis Services Project3</DatabaseID>

</ParentObject>

<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:CaseTableName</Name>

</Annotation>

<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:ShowFriendlyNames</Name>

</Annotation>

<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramLayout</Name>

<Value>

</mouseicon>

</diagram>

</layoutmanager>

</control>

</ddsxmlobj>

</layoutobject>

</ddscontrol>

</dds>

</Value>

</Annotation>

<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:ShowRelationshipNames</Name>

<Value>false</Value>

</Annotation>

<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:UseDiagramDefaultLayout</Name>

</Annotation>

<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramViewPortLeft</Name>

</Annotation>

<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramViewPortTop</Name>

</Annotation>

<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramBoundingLeft</Name>

</Annotation>

<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramBoundingTop</Name>

</Annotation>

<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramZoom</Name>

</Annotation>

</Annotations>

<DataSourceViewID>BM TEXTOS</DataSourceViewID>

</Source>

<Collation>Latin1_General_CI_AS</Collation>

<Type>Double</Type>

<Content>Continuous</Content>

<DataType>Single</DataType>

</Source>

</KeyColumn>

</KeyColumns>

</Column>

<DataType>Integer</DataType>

</Source>

</KeyColumn>

</KeyColumns>

</Column>

<Content>Continuous</Content>

<DataType>Integer</DataType>

</Source>

</KeyColumn>

</KeyColumns>

</Column>

<ID>ID TERMO</ID>

<Name>ID TERMO</Name>

<Content>Continuous</Content>

<DataType>Integer</DataType>

<ColumnID>ID_TERMO</ColumnID>

</Source>

</KeyColumn>

</KeyColumns>

</Column>

<ID>TERMO</ID>

<Name>TERMO</Name>

<Content>Discrete</Content>

<DataType>WChar</DataType>

<ColumnID>TERMO</ColumnID>

</Source>

</KeyColumn>

</KeyColumns>

</Column>

</Columns>

<Algorithm>PBM_K-MEANS</Algorithm>

<Usage>Predict</Usage>

<ModelingFlag>REGRESSOR</ModelingFlag>

</ModelingFlags>

</Column>

</Column>

<Usage>Predict</Usage>

<ModelingFlag>REGRESSOR</ModelingFlag>

</ModelingFlags>

</Column>

<ID>ID TERMO</ID>

<Name>ID TERMO</Name>

<SourceColumnID>ID TERMO</SourceColumnID>

<Usage>Predict</Usage>

<ModelingFlag>REGRESSOR</ModelingFlag>

</ModelingFlags>

</Column>

<ID>TERMO</ID>

<Name>TERMO</Name>

<SourceColumnID>TERMO</SourceColumnID>

<Usage>Predict</Usage>

</Column>

</Columns>

<Collation>Latin1_General_CI_AS</Collation>

</MiningModel>

</MiningModels>

</MiningStructure>

</ObjectDefinition>

</Create>

Thanks a lot once more,

-Renan

|||

Hello

Does this help?

|||

Dear Mr. Crivat,

Your explanations were very helpful, as usual.

But when I do it I get the following error when deploying: Error 1 Error (Data mining): The source OLAP object for the 'ID' column of the 'TMP' model cannot be found. 0 0

I realized that it happens because somewhere the ID column is set as"time key" and when I try to deploy it as "key, it crashes.

I'm creating the table on a external Java program that runs the following code:

CREATE TABLE TMP (ID INT NOT NULL, ID_DOC INT NOT NULL, ID_TERMO INT NOT NULL, TERMO VARCHAR(MAX) NOT NULL, FREQ REAL NOT NULL)

GO
ALTER TABLE TMP ADD PRIMARY KEY(ID ASC);

Is there some reason for the key's content is been created as time key ? How to fix it ?

Thanks a lot again,

-Renan

|||

This should fix the problem you are seeing. However, KEY_TIME is not supported by your algorithm, then one thing you could try is the following:

- create (using the wizard) a Decision Tree model on your data.

- in the newly created structure, add a related model using your algorithm

- remove the DT model

The creation of the DT model will configure the key properly at the structure level.

|||

Problem solved.

Thanks a lot again. But I've got a new one I'm posting on a new thread.

Errors in the metadata manager

Good afternoon,

I'm having the following error when I run my mining model.

Errors in the metadata manager. The dimension with the ID of 'TMP ~MC-ID' cannot be found in the '' database.

I think the error is in caseprocessor.cpp at the ProcessCase method. There's a code snippet below:

The intention of the following code snippet is to run over the attributes of a case and put them on a vector that holds all the cases.

for (UINT iAttribute = 0; iAttribute < _cAttribute; iAttribute++) {

if(iAttribute == 0)

continue;

if(iAttribute == 1)

continue;

if(iAttribute == 2)

continue;

if(iAttribute == 3) {

vet_termos.push_back(rgdmstatevalue[iAttribute].ch);

continue;

if(iAttribute == 4)

vet_dados.push_back(rgdmstatevalue[iAttribute].r8);

DBL dblValue = 0;

if (_vbCategorical[iAttribute]) {

dblValue = (_bMissingAtRandom)

? ::DblCategoricalMAR(rgdmstatevalue[iAttribute])

: ::DblCategorical(rgdmstatevalue[iAttribute]);

}

if (_viewtype == CASEREADER::viewtypeSparse) {

if (dblValue != dblMissing) {

CHECK_STL_MEM(_vdblValue.push_back(dblValue));

CHECK_STL_MEM(_viAttribute.push_back(iAttribute));

}

else {

_vdblValue[iAttribute] = dblValue;

}

The attributes of the table are like following:

Index (iAttribute) == 0 -> This is an auto-incremental ID and is the primary key. Integer.

Index (iAttribute) == 1 -> Another ID. Non-key on this table. It is Integer.

Index (iAttribute) == 2 -> Another ID. Non-key on this table. It is integer.

Index (iAttribute) == 3 -> A term. It's a word. This is non-key and the type is varchar.

Index (iAttribute) == 4 -> Weight of the word. Non-key and type double.

As you can notice I also changed the union DM_STATE_VALUE definition on dmalgo.h to accept the reading of a string (if (iAttribute == 3)) :

typedef /* [public][public][public][public][public][public][public] */ union __MIDLMIDL_itf_dmalgo_0000_0002 {

DM_STATE_INDEX si;

DOUBLE r8;

char* ch;

} DM_STATE_VALUE;

So... Does anyone can help me with the error I discribed on the metadata manager ? I would be very pleased with any help.

Thanks a lot for your attention.

-Renan Souza

Good afternoon,

I've tryed to run the Microsoft Clustering algorithm on this table and I've got the following error:

Error 1 Error (Data mining): The source OLAP object for the 'ID' column of the 'TMP' model cannot be found. 0 0

So... I think the error is, somehow, on the table structure, or somethig like that...

Any ideas on how to fix this problem ?

Thanks a lot once more,

-Renan

|||

Hello

First, could you please try a Process Full on the mining structure?

|||

Dear Mr. Crivat,

Thanks for your prompt reply.

When I get this error a window prompts and asks me if I wish to continue anyway. I click 'yes' but the process fails when I run the model.

This second error is the one I discribed earlyer, as following:

Errors in the metadata manager. The dimension with the ID of 'TMP ~MC-ID' cannot be found in the '' database.

Any clues ?

Thanks a lot once more,

-Renan

|||Could you please send me (or post here) the DDL script for your mining structure ? (I included my email in my previous post)|||

Dear Mr. Drivat,

Here's the script. I also sent it to your e-mail.

USE [BM_TEXTOS]

/****** Object: Table [dbo].[TMP] Script Date: 10/03/2001 10:23:50 ******/

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

SET ANSI_PADDING ON

CREATE TABLE [dbo].[TMP](

[ID] [int] NOT NULL,

[ID_DOC] [int] NOT NULL,

[ID_TERMO] [int] NOT NULL,

[TERMO] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[FREQ] [real] NOT NULL,

PRIMARY KEY CLUSTERED

(

[ID] ASC

)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]

) ON [PRIMARY]

SET ANSI_PADDING OFF

Thanks a lot once more,

-Renan

|||

Hi
I meant, for the Analysis Services mining structure and model. This seems to be for the relational table that contains the training data

thanks

|||

Sorry... Forgive my mistake. Here's the script:

<DatabaseID>Analysis Services Project3</DatabaseID>

</ParentObject>

<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:CaseTableName</Name>

</Annotation>

<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:ShowFriendlyNames</Name>

</Annotation>

<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramLayout</Name>

<Value>

</mouseicon>

</diagram>

</layoutmanager>

</control>

</ddsxmlobj>

</layoutobject>

</ddscontrol>

</dds>

</Value>

</Annotation>

<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:ShowRelationshipNames</Name>

<Value>false</Value>

</Annotation>

<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:UseDiagramDefaultLayout</Name>

</Annotation>

<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramViewPortLeft</Name>

</Annotation>

<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramViewPortTop</Name>

</Annotation>

<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramBoundingLeft</Name>

</Annotation>

<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramBoundingTop</Name>

</Annotation>

<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramZoom</Name>

</Annotation>

</Annotations>

<DataSourceViewID>BM TEXTOS</DataSourceViewID>

</Source>

<Collation>Latin1_General_CI_AS</Collation>

<Type>Double</Type>

<Content>Continuous</Content>

<DataType>Single</DataType>

</Source>

</KeyColumn>

</KeyColumns>

</Column>

<DataType>Integer</DataType>

</Source>

</KeyColumn>

</KeyColumns>

</Column>

<Content>Continuous</Content>

<DataType>Integer</DataType>

</Source>

</KeyColumn>

</KeyColumns>

</Column>

<ID>ID TERMO</ID>

<Name>ID TERMO</Name>

<Content>Continuous</Content>

<DataType>Integer</DataType>

<ColumnID>ID_TERMO</ColumnID>

</Source>

</KeyColumn>

</KeyColumns>

</Column>

<ID>TERMO</ID>

<Name>TERMO</Name>

<Content>Discrete</Content>

<DataType>WChar</DataType>

<ColumnID>TERMO</ColumnID>

</Source>

</KeyColumn>

</KeyColumns>

</Column>

</Columns>

<Algorithm>PBM_K-MEANS</Algorithm>

<Usage>Predict</Usage>

<ModelingFlag>REGRESSOR</ModelingFlag>

</ModelingFlags>

</Column>

</Column>

<Usage>Predict</Usage>

<ModelingFlag>REGRESSOR</ModelingFlag>

</ModelingFlags>

</Column>

<ID>ID TERMO</ID>

<Name>ID TERMO</Name>

<SourceColumnID>ID TERMO</SourceColumnID>

<Usage>Predict</Usage>

<ModelingFlag>REGRESSOR</ModelingFlag>

</ModelingFlags>

</Column>

<ID>TERMO</ID>

<Name>TERMO</Name>

<SourceColumnID>TERMO</SourceColumnID>

<Usage>Predict</Usage>

</Column>

</Columns>

<Collation>Latin1_General_CI_AS</Collation>

</MiningModel>

</MiningModels>

</MiningStructure>

</ObjectDefinition>

</Create>

Thanks a lot once more,

-Renan

|||

Hello

Does this help?

|||

Dear Mr. Crivat,

Your explanations were very helpful, as usual.

But when I do it I get the following error when deploying: Error 1 Error (Data mining): The source OLAP object for the 'ID' column of the 'TMP' model cannot be found. 0 0

I realized that it happens because somewhere the ID column is set as"time key" and when I try to deploy it as "key, it crashes.

I'm creating the table on a external Java program that runs the following code:

CREATE TABLE TMP (ID INT NOT NULL, ID_DOC INT NOT NULL, ID_TERMO INT NOT NULL, TERMO VARCHAR(MAX) NOT NULL, FREQ REAL NOT NULL)

GO
ALTER TABLE TMP ADD PRIMARY KEY(ID ASC);

Is there some reason for the key's content is been created as time key ? How to fix it ?

Thanks a lot again,

-Renan

|||

This should fix the problem you are seeing. However, KEY_TIME is not supported by your algorithm, then one thing you could try is the following:

- create (using the wizard) a Decision Tree model on your data.

- in the newly created structure, add a related model using your algorithm

- remove the DT model

The creation of the DT model will configure the key properly at the structure level.

|||

Problem solved.

Thanks a lot again. But I've got a new one I'm posting on a new thread.

Errors in the metadata manager

Hello,
I'm trying to process a cube and i'm getting the following error message. I'm not working in Analysis Services Project 4, i created another project. I deleted Analysis Services Project 4 and every project i try to execute i get this error message.

"Error 1 File system error: Error opening file; \\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Analysis Services Project4.0.db\TBLE~MC.0.cub.xml is not a disk file or file is not accessible. Errors in the metadata manager. An error occurred when loading the TBLE~MC cube, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Analysis Services Project4.0.db\TBLE~MC.0.cub.xml'. File system error: The following error occurred while writing to the file 'MSSQLServerOLAPService': The event log file is full. . 0 0 "

Any ideas how to solve this problem?

Thank you in advance.

Looks like the data folder is corrupted. Could you please try the following steps:

1. Stop the Analysis Services service
2. Delete everything in your C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\%YOUR_PROJECTNAME% folder
3. Restart the Analysis Services service
4. Re-deploy your project

Hope this helps,

Artur

|||

I already try this but without stopping the analysis services and didn't work.

I will try it again... thanks for the help:)

|||

You should really stop Analysis Server :)

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

Sunday, March 11, 2012

Errors in scripting from Enterprise Manager

Has anybody ever had problems with strange characters appearing in the names
of tables or constraints when scripting a database? I'm on SQL Serv2000 +
sp3a and I've never known this happen before.
Philyou might want to try the free scripter (also does data) from Innovartis.
http://www.innovartis.co.uk/Evaluation.aspx
"Philip Turtle" wrote:

> Has anybody ever had problems with strange characters appearing in the nam
es
> of tables or constraints when scripting a database? I'm on SQL Serv2000 +
> sp3a and I've never known this happen before.
> Phil
>
>

Errors in scripting from Enterprise Manager

Has anybody ever had problems with strange characters appearing in the names
of tables or constraints when scripting a database? I'm on SQL Serv2000 +
sp3a and I've never known this happen before.
Phil
you might want to try the free scripter (also does data) from Innovartis.
http://www.innovartis.co.uk/Evaluation.aspx
"Philip Turtle" wrote:

> Has anybody ever had problems with strange characters appearing in the names
> of tables or constraints when scripting a database? I'm on SQL Serv2000 +
> sp3a and I've never known this happen before.
> Phil
>
>

Errors in scripting from Enterprise Manager

Has anybody ever had problems with strange characters appearing in the names
of tables or constraints when scripting a database? I'm on SQL Serv2000 +
sp3a and I've never known this happen before.
Philyou might want to try the free scripter (also does data) from Innovartis.
http://www.innovartis.co.uk/Evaluation.aspx
"Philip Turtle" wrote:
> Has anybody ever had problems with strange characters appearing in the names
> of tables or constraints when scripting a database? I'm on SQL Serv2000 +
> sp3a and I've never known this happen before.
> Phil
>
>

Errors Importing From Enterprise Manager

Hi,
I am attempting to import objects from one database to another, including co
nstraints. However, the operation keeps failing. How do I find out the spe
cific reason for the failure? Enterprise Manager does not provide specifics
in the error message.
Thanks,
MarkIf you are using the wizard, you can find out more specifics by
double-clicking the line that says "error occurred"...
http://www.aspfaq.com/
(Reverse address to reply.)
"mark" <mark@.discussions.microsoft.com> wrote in message
news:4FE6D4E5-7285-4A01-927D-B47C4F4C3AE6@.microsoft.com...
> Hi,
> I am attempting to import objects from one database to another, including
> constraints. However, the operation keeps failing. How do I find out the
> specific reason for the failure? Enterprise Manager does not provide
> specifics in the error message.
> Thanks,
> Mark

Errors Importing From Enterprise Manager

Hi,
I am attempting to import objects from one database to another, including constraints. However, the operation keeps failing. How do I find out the specific reason for the failure? Enterprise Manager does not provide specifics in the error message.
Thanks,
Mark
If you are using the wizard, you can find out more specifics by
double-clicking the line that says "error occurred"...
http://www.aspfaq.com/
(Reverse address to reply.)
"mark" <mark@.discussions.microsoft.com> wrote in message
news:4FE6D4E5-7285-4A01-927D-B47C4F4C3AE6@.microsoft.com...
> Hi,
> I am attempting to import objects from one database to another, including
> constraints. However, the operation keeps failing. How do I find out the
> specific reason for the failure? Enterprise Manager does not provide
> specifics in the error message.
> Thanks,
> Mark

Errors Importing From Enterprise Manager

Hi,
I am attempting to import objects from one database to another, including constraints. However, the operation keeps failing. How do I find out the specific reason for the failure? Enterprise Manager does not provide specifics in the error message.
Thanks,
MarkIf you are using the wizard, you can find out more specifics by
double-clicking the line that says "error occurred"...
--
http://www.aspfaq.com/
(Reverse address to reply.)
"mark" <mark@.discussions.microsoft.com> wrote in message
news:4FE6D4E5-7285-4A01-927D-B47C4F4C3AE6@.microsoft.com...
> Hi,
> I am attempting to import objects from one database to another, including
> constraints. However, the operation keeps failing. How do I find out the
> specific reason for the failure? Enterprise Manager does not provide
> specifics in the error message.
> Thanks,
> Mark

Wednesday, March 7, 2012

Errorlogs

Hello All,
I have a SQL server 2000 with sp 3 running on Windows 2000. In the
enterprise manager, when I go to look at errorlogs, it only displays the
most current errorlog and then log # 6. It is not showing any of the
other errorlog files between the current and the number 6. Also, when I
run the command sp_cycle_errorlog, it is not cycling it. My current
errorlog has grown to 321 MB and I want to cycle it.
Have any ideas.
Thanks,
Raziq.
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!I am not sure how to address the missing errorlogs or the sp_cycle_errorlog
problem but if you truly want to recycle the SQL Server errorlog, plan a
time to stop and then restart SQL Server. This should recycle the log.
Rand
This posting is provided "as is" with no warranties and confers no rights.

Errorlog increase Message Field

quote:

> Is there away to increase the number of characters the
> line displays or writes out in the Message field within
> SQL Server Enterprise Manager 2000. It would be very
> helpful to resolve locking problems.
> Thank You,
> Dan
>
>

|||Hi,
Best idea is to run the below command from Query Analyzer, This will display
the entire contents of current SQL error log.
xp_readerrorlog
Thanks
Hari
MCDBA
"Dan" <anonymous@.discussions.microsoft.com> wrote in message
news:76ad01c3e762$f3c39bc0$a501280a@.phx.gbl...

quote:

> Is there away to increase the number of characters the
> line displays or writes out in the Message field within
> SQL Server Enterprise Manager 2000. It would be very
> helpful to resolve locking problems.
> Thank You,
> Dan
>
>

Errorlog increase Message Field

Is there away to increase the number of characters the
line displays or writes out in the Message field within
SQL Server Enterprise Manager 2000. It would be very
helpful to resolve locking problems.
Thank You,
DanRight Click on the Message and choose properties option - it should display
the full text.
Else you can directly open the file from C:\Program Files\Microsoft SQL
Server\MSSQL\LOG.
Please replace the directory structure as per your installation.
--
HTH
Satish Balusa
Corillian Corp.
"Dan" <anonymous@.discussions.microsoft.com> wrote in message
news:76ad01c3e762$f3c39bc0$a501280a@.phx.gbl...
> Is there away to increase the number of characters the
> line displays or writes out in the Message field within
> SQL Server Enterprise Manager 2000. It would be very
> helpful to resolve locking problems.
> Thank You,
> Dan
>
>|||Hi,
Best idea is to run the below command from Query Analyzer, This will display
the entire contents of current SQL error log.
xp_readerrorlog
Thanks
Hari
MCDBA
"Dan" <anonymous@.discussions.microsoft.com> wrote in message
news:76ad01c3e762$f3c39bc0$a501280a@.phx.gbl...
> Is there away to increase the number of characters the
> line displays or writes out in the Message field within
> SQL Server Enterprise Manager 2000. It would be very
> helpful to resolve locking problems.
> Thank You,
> Dan
>
>

Friday, February 24, 2012

ERROR: Using Flat File Connection Manager Editor with delimited format

Hello everyone:

I am new with SSIS and I have a problem that I don’t know solving it.

I have a simple package with a delimited flat file source which is loaded into a table in a SQL Server database.

Below is the import format:

- Row delimiter: carriage return and line feed {CR/LF}

- Column delimiter: Comma {,}

- Text qualifier: “

In the source file, the data looks like this:

“string1”, 34, “”, , ,” string2 “text1” string2” , ““,

This package with DTS works, but now with SSIS does not, when I see the “previous rows” in the Flat File Connection Manager Editor, the last column has incorrect information and when I create a new file without spaces and without twice “” in the same string, it works. I don’t know what I am missing with SSIS.

Regards,

Fanny Tejera

Well, technically double quotes inside a field should be escaped with another double quote.

"string1 ", 34, "", , , "string2 ""text1"" continued string2", " ",|||

Yes, but I do not have the control of the information that contains these source files. Can I fix this problem with the Flat File Connection Manager Editor? Am I missing something with SSIS?

|||

See below post where Donald Farmer answered a similar question

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=546729&SiteID=1

SSIS does not support embedded text qualifiers in this version.

However, you can look at these sample components that I mentioned elsewhere recently ...

http://www.microsoft.com/downloads/details.aspx?familyid=b51463e9-2907-4b82-a353-e15016486e1d

http://www.microsoft.com/downloads/details.aspx?FamilyID=9c624eab-6893-4734-b5dd-f80d0d487aa1

http://www.microsoft.com/downloads/details.aspx?familyid=91e24d1d-acf0-45b1-a9a5-9ea1c7bd0463

Donald

Donald Farmer, Microsoft -- www.pamboli.com -- www.beyeblogs.com/donaldfarmer

- Ranjeeta

|||

Thank you so much!

Fanny Tejera

|||

Hi Fanny,

Even i too have the same problem with delimiter.

I tried it by using the same links.

but i am getting the error right at the source file during validation. can you please explain me how to use the Undouble component.

Thanks in advance,

Anand kumar

|||

even i too have the same problem. I tried it with the same links you have provided. But i am getting the same error at flat source file.

i have downloaded, installed and build the components.

when i am using the undouble or undouble component it could not remove the ", i am getting the error at flat file source during validation itself. can you please reply me as soon as possible.

can you please tell me how and where to use the undouble component.

Thanks in advance,

Anand

|||

I installed the undouble but getting the error that i can't use it with DT_NTEXT?

How to solve this or is there a other solution. I must place it in DT_NTEXT because the field is longer then 8000.

In access i can import it in a memo field without any problems.

Thursday, March 22, 2012

ERwin

ERwin

ERwin

Monday, March 19, 2012

ERRORS on Insert/Update DB2 from SQL Enterprise Manager (linked server)

Errors in the trace from Enterprise manager

Errors in the metadata manager while running "SQL Server 2005 Data Mining Configuration Wiz

Errors in the metadata manager

Errors in the metadata manager

Errors in the metadata manager

Errors in the metadata manager

Sunday, March 11, 2012

Errors in scripting from Enterprise Manager

Errors in scripting from Enterprise Manager

Errors in scripting from Enterprise Manager

Errors Importing From Enterprise Manager

Errors Importing From Enterprise Manager

Errors Importing From Enterprise Manager

Wednesday, March 7, 2012

Errorlogs

Errorlog increase Message Field

Errorlog increase Message Field

Friday, February 24, 2012

ERROR: Using Flat File Connection Manager Editor with delimited format

ERROR: Subreport

Blog Archive

About Me