Mining Structures

I am using the wizard to create a new mining structure and getting the error at the time of selecting the datamining technique like either microsoft decision tree or microsoft timeseries etc.,

"Unable to retrieve a list of supported data mining algorithms. Make sure you are connected to the correct Analysis Services server instance and the Analysis Services server named localhost is running and configured properly. You can continue with a default list of data mining algorithms."

What is that means?

Thanks in advance,

Got it. I need to start the AS from Control Panel/Administrative tools etc etc., before doning this.

I think the default is Manual to start the service.

|||Right-click on the Analysis Service project and select Properties - under Configuration Properties->Deployment, check what you have under Target->Server. The value of the Server property should be the name of the Analysis Services instance that you want the project to connect/deploy to. When you try to select a data mining technique, we try to connect to the Target Server to fetch the list of supported techniques. If you have "localhost" in this property, check Control Panel->Administrative Services->Services to confirm that the "SQL Server Analysis Services" service is running. If you specified a named instance (servername\instancename), check that the corresponding instance (SQL Server Analysis Services (instancename)" as well as the "SQL Server Browser" service is running.sql

Migration Wizard Fails Interop.DSO.IDBGroup90Ex

I am attempting to convert several 2000 AS databases to AS 2005. I have not been able to successfully convert any databases. The error message is:

Unable to cast COM object of type 'System.__ComObject' to interface type 'Interop.Dso.IDbGroup90Ex'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{CE55E9E9-9597-4214-B21F-30C7683467B1}' failed due
to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).

I have attempted to convert the FoodMart sample database and it also fails to convert. I have unregistered and registered all DSO related dlls. The problem still persists. I have attempted to convert at least 4 other databases and they all fail. The failure point occurs during the conversion of the Cubes.

Thanks

Ron Cotton

Problem solved. Unfortunately, I am not sure which step actually solved the problem. I will state both here.

1. I registered all of the dlls associated with DSO, which reside in the directory: C:\Program Files\Common Files\Microsoft Shared\DSO using regsvr32. BTW, I don't believe that this solve the problem, but I have state it here because of item 2.

2. I downloaded and installed Service Pack 2 for SQL 2005. The Service Pack installation forced a reboot so I not exactly sure that it was the cure. My gut says that it was an not option 1.

Anyway, I hope that this helps anyone that has been struggling with this issue.

Thanks

Ron Cotton

Migration Wizard Error

Hi !,

The migration of OLAP cubes with aggregations to SSAS, generate the following error:

"Another 'Aggregation' object has the '31 3314' ID."

and then the migration process stops.

The dimension structure is changed during the process and a posible solution is deleting all the aggregation before migration.

But I would like to know if it is really a bug or there is a known reason for getting such error.

Thanks in advance !!!

Leandro

Looks like you somewhow got 2 aggregations in AS2000 with the same name.

Now, when trying to migrate AS2005 trying to create aggregations for you and stops at the point when meets aggregation with the duplicate name.

Several options.

Try and get rid of the duplicate aggregation using Parition Manager sample application shipped with SQL Server 2000 resource kit.

Try re-desingn aggregations using Analysis Manager.

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

|||

That's right.

So Instead of migrating directly from a production server, would it be better to copy AS2000 objects to another database/server, clean all duplicate aggregations, and then run the migration wizard ?.

We have high volume partitions, but fortunately users dont browse freely the cubes. An application runs a lot of specific MDX queries. So we decided to design aggregations manually because generating an aditional one was too costly and it was better to define a lower-level aggregation that serves two similar types of MDX queries, than adding two aggregations by using the Usage Based Optimization.

I dont know If the last algorithm was optimized to support such type of aggregations design criteria.

Thanks very much.

Leandro

Thanks Edward,

|||

I would definitely try make sure that any modifications are done in the test environment.

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

Migration Wizard Error

When I attempt to migrate any AS2000 database to AS2005, I get an error during the "Validating Databases" step, during the Cube validation, as follows:

Unable to cast COM object of type 'System.__ComObject' to interface type 'Interop.Dso.IPartition90Ex'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{F82195C2-53A0-41B5-B7D8-7D087BAE32CF}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).

Needless to say, this prevents me from performing the migration. I have even created a super-simple cube with one dimension, and I still get the same error. I have tried this using 3 different source servers. Any suggestions on where to look? I'm running SSMS and Analysis Manager on a workstation, not the server itself.

Gary

This could be related to the order you installed your components. Try uninstalling and re-installing SQL Server 2005 components on your workstation.

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

|||Thank you. I uninstalled and re-installed SQL Server 2005 on the workstation and that solved the problem.

migration sql Server 2000 to sqlServer2005

hi,

i must convert my SqlServer2000 to SqlServer2005. I just do it on my Computer and i run a component "SQL Server upgrade wizard" it convert my SQLServer.
But now i must do it on my Server Web and if i run that component it give me an error : "must run SQL 6.5" and i don't installed it.

Can i download it with all right migration?

thank you

If you get such error you may have inherited a database upgraded from 6.5 to 2000 with a wizard that could be a problem because I always advice 6.5 migration should be manual done by a skilled SQL Server expert. So create a blank database and run the SSIS(sql server integration services) and the error will go away. Hope this helps.

Migration of SQL Serve r2000 packages

Hi,

In SQL Server 2005, when I tried to migrate existing SQL Server 2000 DTS packages using Migration Wizard, I ran into the following error message.

"Index was out of range.Must be non-negative and less than the size of the collection.

Parameter name: index[mscorlib]"

Please help!

Thanks,

KP

Please take a look at this earlier thread:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=130931&SiteID=1
|||Hi there,

Can you describe the problem you're seeing in detail so we can try reproducing it and fixing it?

Thanks,
Silviu

SQL Server team|||

Please check your packages for a space before or (more likely) after the name of the package. This causes the error described.

Unfortunately this problem is not currently detected by Upgrade Advisor when it scans package names for invalid characters.

-Doug

Migration of SQL Serve r2000 packages

Hi,

In SQL Server 2005, when I tried to migrate existing SQL Server 2000 DTS packages using Migration Wizard, I ran into the following error message.

"Index was out of range.Must be non-negative and less than the size of the collection.

Parameter name: index[mscorlib]"

Please help!

Thanks,

KP

Please take a look at this earlier thread:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=130931&SiteID=1|||Hi there,

Can you describe the problem you're seeing in detail so we can try reproducing it and fixing it?

Thanks,
Silviu

SQL Server team|||

Please check your packages for a space before or (more likely) after the name of the package. This causes the error described.

Unfortunately this problem is not currently detected by Upgrade Advisor when it scans package names for invalid characters.

-Doug

Migration of DTS to SSIS

Well..

Have migrated my SQL 2000 DTS packages to SSIS packages through the package migration Wizard.Also, the hurdle to schedule it as a job has been resolved.But, the concern is the package contains entries\lins for old dataserver.

Is it possible to edit the SSIS pckage using management studio or integration services?

Please move this question to the " SQL Server Integration Services forum" .

Thanks

Migration of DTS to SSIS

Well..

Have migrated my SQL 2000 DTS packages to SSIS packages through the package migration Wizard.Also, the hurdle to schedule it as a job has been resolved.But, the concern is the package contains entries\lins for old dataserver.

Is it possible to edit the SSIS pckage using management studio or integration services?

Please move this question to the " SQL Server Integration Services forum" .

Thanks

Migration form MS access reports to Sql server reports

Does any of the free dowloadable reporting packs come with Reporting Services wizard to migrate data and reports from MS-Access?

Does SQL Server reporting tools come integrated with any of the VS 2005 tools?

Yes, if you are dealing with the 2000 version than have your service packs up to date and you have to have Access 2003 for the option to show up in your designer. Once you have Access 2003 it will give you the option under "project" --> "import reports".

I believe in 2005 it is under the same location: "project" --> "import reports"

I hope this helps.

|||I need to convert from MS Access 97 to .NET 2005.
Is this possible with Reporting tool?|||It may be, but with what is built into Reporting Services you have to have Access 2003. This doesn't mean you couldn't open the Access 97 database with a 2003 version of Access.

Migration exceptions

Hi,
How should one deal with exceptions generated by the DTS to SSIS conversion wizard in sql server 2005?
ThanksWhat exceptions are you getting? That would be a good place to start.

Migration ACCESS --> SQL date field

Hi,
I import an access table with date field in SQL with DTS import/export
wizard.
I got error : data overflow on date field. There is another way to do it ?In the DTS package, transform that column to varchar, and then run isdate()
against the new table to determine which rows need to be repaired.
"Sylvain Provencher" <sylvain.provencher@.nobelia.com> wrote in message
news:uZybbSLpDHA.2268@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I import an access table with date field in SQL with DTS import/export
> wizard.
> I got error : data overflow on date field. There is another way to do it ?
>