cognos OLAP conversion to ms analysis service

Hello All,
I am new to this group. I am looking for a tool that will convert cognos
OLAp cubes into ms OLAP cubes. Anybody has an idea?
Thanks a lot
Angie..
Won't work using Replication - I'd repost in the Analysis Services/OLAP
groups....
Paul Ibison

Clustering SQL and service packs

I have a SQL 2000 cluster and have applied SP3 to it.
However, when running on one side of the cluster SQL reports a different
version to when it is running on the other side. Is this normal / expected
or has it not applied SP3 to the other node correctly?
e.g
Running on node 1
select @.@.version
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: )
SELECT SERVERPROPERTY('ProductLevel')
SP3
Running on node 2
select @.@.version
Microsoft SQL Server 2000 - 8.00.194 (Intel X86)
Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: )
SELECT SERVERPROPERTY('ProductLevel')
RTM
If this is not normal / exptected, can I just apply SP3 to node 2 on its
own?
Thanks.
Hi
SQL 2000 sp3 automatically installs itself on all nodes of a cluster. You
have a problem.
Try running it on the 2nd node and see if it will install. Was B down when
sp3 was installed?
Regards
Mike
"Stephen Aldous" wrote:

> I have a SQL 2000 cluster and have applied SP3 to it.
> However, when running on one side of the cluster SQL reports a different
> version to when it is running on the other side. Is this normal / expected
> or has it not applied SP3 to the other node correctly?
> e.g
> Running on node 1
> select @.@.version
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Enterprise Edition on Windows NT 5.2 (Build 3790: )
> --
> SELECT SERVERPROPERTY('ProductLevel')
> SP3
> --
> Running on node 2
> select @.@.version
> Microsoft SQL Server 2000 - 8.00.194 (Intel X86)
> Aug 6 2000 00:57:48
> Copyright (c) 1988-2000 Microsoft Corporation
> Enterprise Edition on Windows NT 5.2 (Build 3790: )
> SELECT SERVERPROPERTY('ProductLevel')
> RTM
>
> If this is not normal / exptected, can I just apply SP3 to node 2 on its
> own?
>
> Thanks.
>
>
|||I've tried to install SP3 on the virtual cluster name again and it crashes
to desktop with an error with _INS576._mp error.
Can I just fail it over to the second node and install SP3 on the local
machine?
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:76ECCB2C-267F-406E-B6EE-0CA05F435A2B@.microsoft.com...[vbcol=seagreen]
> Hi
> SQL 2000 sp3 automatically installs itself on all nodes of a cluster. You
> have a problem.
> Try running it on the 2nd node and see if it will install. Was B down when
> sp3 was installed?
> Regards
> Mike
> "Stephen Aldous" wrote:
expected[vbcol=seagreen]
|||Hi
Raise a case with Microsoft PSS as you need their help. Safest.
Regards
Mike
"Stephen Aldous" wrote:

> I've tried to install SP3 on the virtual cluster name again and it crashes
> to desktop with an error with _INS576._mp error.
> Can I just fail it over to the second node and install SP3 on the local
> machine?
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:76ECCB2C-267F-406E-B6EE-0CA05F435A2B@.microsoft.com...
> expected
>
>
|||Hi Steve,
This is not normal. It appears that SP3 got installed only on node 1 and not node 2. Currently your cluster nodes has mis-matched binaries. Infact, SQL Server MAY not even start on node 2 or you may get
unexpected results if you run SQL on node 2.
While SQL is running on node 1, try running SP3 setup on node 2 and see if it succeeds. If it fails then post the exact steps that you took to run the setup, exact error message and the sqlsp.log file.
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx

Clustering Service not starting right away on One Node

I just set up a cluster attached to a SAN. I have had it where the cluster
service on one of the nodes doesn't start up right away. I have checked the
services to make sure that it is set to automatic which it is. Both nodes
are current with the latest patches and security updates. I'm a little
clueless as to why this is happening. Here is the real weird part after 1
minute the cluster service starts on the node that is giving me troubles.
The other node is perfectly fine.
Hi
If you do a fail-over using cluster admin, are there any resources (that SQL
server depends on) take a long to come online?
I have seen similar issues when the devices take long to come online due to
high SAN activity.
Does the SQL Server resource come online, but take a long time until it has
done it's recovery steps?
This can occur when the other node was de-porting it's devices and still had
IO pending. This results in not all pages being fluished to SAN, so SQL
Server has to do more recovery on the database start-up.
The best guage of how quickly a resource comes online is to look at cluster
admin during the failover.
Regards
Mike
Regards
Mike
"Thomas" wrote:

> I just set up a cluster attached to a SAN. I have had it where the cluster
> service on one of the nodes doesn't start up right away. I have checked the
> services to make sure that it is set to automatic which it is. Both nodes
> are current with the latest patches and security updates. I'm a little
> clueless as to why this is happening. Here is the real weird part after 1
> minute the cluster service starts on the node that is giving me troubles.
> The other node is perfectly fine.
|||We haven't installed SQL server yet. I should've posted that first. But I
know from passed installs that SQL does take some time to come online. The
SAN doesn't have much activity on it right now
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> If you do a fail-over using cluster admin, are there any resources (that SQL
> server depends on) take a long to come online?
> I have seen similar issues when the devices take long to come online due to
> high SAN activity.
> Does the SQL Server resource come online, but take a long time until it has
> done it's recovery steps?
> This can occur when the other node was de-porting it's devices and still had
> IO pending. This results in not all pages being fluished to SAN, so SQL
> Server has to do more recovery on the database start-up.
> The best guage of how quickly a resource comes online is to look at cluster
> admin during the failover.
> Regards
> Mike
> Regards
> Mike
> "Thomas" wrote:
|||Hi
Have a look in your event logs and check the time differences between when
Node A shuts down and Node B notices it and starts up. There will be at least
15 event messages during this process. Post the information here so that I
can compare it to our big clusters.
Regards
Mike
"Thomas" wrote:
[vbcol=seagreen]
> We haven't installed SQL server yet. I should've posted that first. But I
> know from passed installs that SQL does take some time to come online. The
> SAN doesn't have much activity on it right now
> "Mike Epprecht (SQL MVP)" wrote:
|||That may be somewhat normal on a simultaneous startup. The first node grabs
the quorum device and owns the cluster but isn't talking on the network yet.
The second node tries to get the device but times out. Eventually the
service comes online and talks to the other node and agrees on who is in
charge. This is especially prevalent on SCSI-based clusters.
Check the System and Application event logs on both systems to see if there
are any unusual startup errors. Also, check what happens when the second
node is rebooted. If the cluster service does come online quickly, it is
just a device contention issue. I try and avoid powering up more than one
cluster node at a time.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Thomas" <Thomas@.discussions.microsoft.com> wrote in message
news:AF61883D-AE50-4F3F-AD3F-3F07834A2B78@.microsoft.com...
> I just set up a cluster attached to a SAN. I have had it where the
cluster
> service on one of the nodes doesn't start up right away. I have checked
the
> services to make sure that it is set to automatic which it is. Both nodes
> are current with the latest patches and security updates. I'm a little
> clueless as to why this is happening. Here is the real weird part after 1
> minute the cluster service starts on the node that is giving me troubles.
> The other node is perfectly fine.
|||Node 2 which I haven't seen the problem with having ownership of the cluster.
When I reboot node 1 is when I see the problem of it taking 1 mintue to
start the cluster service.
"Geoff N. Hiten" wrote:

> That may be somewhat normal on a simultaneous startup. The first node grabs
> the quorum device and owns the cluster but isn't talking on the network yet.
> The second node tries to get the device but times out. Eventually the
> service comes online and talks to the other node and agrees on who is in
> charge. This is especially prevalent on SCSI-based clusters.
> Check the System and Application event logs on both systems to see if there
> are any unusual startup errors. Also, check what happens when the second
> node is rebooted. If the cluster service does come online quickly, it is
> just a device contention issue. I try and avoid powering up more than one
> cluster node at a time.
>
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Thomas" <Thomas@.discussions.microsoft.com> wrote in message
> news:AF61883D-AE50-4F3F-AD3F-3F07834A2B78@.microsoft.com...
> cluster
> the
>
>
|||Node order is arbitrary in a cluster. We could use Node X and Node Y
instead of Node 1 and Node 2.
Try manually stopping and starting the cluster service on Node 1. If it
restarts quickly, then the problem likely is one of the services that the
cluster service depends on. Time service is a usual suspect for that, but
you will have to check the entire list. Again, the Application and System
event logs are your friends here.
Now is the time to deal with this issue, not after you load SQL and get this
baby into production.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Thomas" <Thomas@.discussions.microsoft.com> wrote in message
news:29B2402A-537B-4DCE-A137-FA200DD28872@.microsoft.com...
> Node 2 which I haven't seen the problem with having ownership of the
cluster.[vbcol=seagreen]
> When I reboot node 1 is when I see the problem of it taking 1 mintue to
> start the cluster service.
> "Geoff N. Hiten" wrote:
grabs[vbcol=seagreen]
yet.[vbcol=seagreen]
there[vbcol=seagreen]
second[vbcol=seagreen]
is[vbcol=seagreen]
one[vbcol=seagreen]
checked[vbcol=seagreen]
nodes[vbcol=seagreen]
little[vbcol=seagreen]
after 1[vbcol=seagreen]
troubles.[vbcol=seagreen]

Clustering Resource depencies

Hello,

With SQL2000 configured with MSCS, we had to stop the SQL service to add additional disk in the SQL Cluster group (in order to use these disks for databases for example).. this was due to the dependencies between the resources.
Do we still have the same issue with SQL2005 running on the cluster? Does the new mountpoint support help in this scenario?
Thanks
Jerome

Yes, the same issue does exist with SQL Server 2005 when adding disks. The new mountpoint support does not really help in this scenario as the mountpoint disk should also be added as a dependent disk to the resource group. It is possible to add the mountpoint without adding the disk to the resource group, but in that case the loss of the disk would not be detected by the cluster service; the SQL Server would attempt to continue running even without the disk (and mountpoint).

Thanks,

Don