Showing posts with label nodes. Show all posts
Showing posts with label nodes. Show all posts

Friday, March 23, 2012

Error on SQL cluster install

I

am trying to install SQL 2005 in a 2-node Windows 2003 cluster. I set the cluster up through Virtual Server 2005 with 2 virtual nodes and one virtual domain. The nodes can connect to each other as well as the physical machine. When I try to install a fresh copy of SQL 2005 on my cluster, I get an error every time. The

error stops the installation while checking system configuration after

installing prerequisites. The log file entry is as follows:

*******************************************
Setup Consistency Check Report for Machine: --SERVERNAME--
*******************************************
Article: WMI Service Requirement, Result: CheckPassed
Article: MSXML Requirement, Result: CheckPassed
Article: Operating System Minimum Level Requirement, Result: CheckPassed
Article: Operating System Service Pack Level Requirement, Result: CheckPassed
Article: SQL Compatibility With Operating System, Result: CheckPassed
Article: Minimum Hardware Requirement, Result: CheckPassed
Article: IIS Feature Requirement, Result: Warning
Description:

IIS is not installed, therefore Report Server feature will be disabled

Action: Install IIS in order for Report Server feature to be enabled
Article: Pending Reboot Requirement, Result: CheckPassed
Article: Performance Monitor Counter Requirement, Result: CheckPassed
Article: Default Installation Path Permission Requirement, Result: CheckPassed
Article: Internet Explorer Requirement, Result: CheckPassed
Article: Check COM+ Catalogue, Result: CheckPassed
Article: ASP.Net Registration Requirement, Result: CheckPassed
Article: Minimum MDAC Version Requirement, Result: CheckPassed
<Func Name='PerformDetections'>
1
Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\sqlsval.dll Version:2005.90.1399.0
Error: Action "InvokeSqlSetupDllAction" threw an exception during execution. Error information reported during run:
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "ComputerList" {"SqlComputers", "", ""} in cache
Source File Name: datastore\clusterinfocollector.cpp
Compiler Timestamp: Fri Sep 16 13:20:12 2005
Function Name: ClusterInfoCollector::collectClusterVSInfo
Source Line Number: 883
-
Failed to detect VS info due to datastore exception.
Source File Name: datastore\clustergroupsproperties.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: ClusterGroupScope.SharedDisks
Source Line Number: 56
-
Failed to find a cluster group that owned shared disk: J:
WinException : 2
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.

Source File Name: datastore\clustergroupsproperties.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: ClusterGroupScope.SharedDisks
Source Line Number: 56

This question is perhaps better answered in SQL setup forum.|||Exceptions are difficult to troubleshoot through emails. So isolate the problem by disabling your J drive and see if the problem persists.|||The only problem with disabling that drive is that it's the virtual shared array that I created for the install. If I disable it, then I won't have a shared drive to use.|||I ran into a very similar error. I found it was the fact that I had taken the disk in question offline (even though I was not going to use it for the sql instance, just a spare disk that I had taken offline) Once I brought the disk back online and ran setup again it bypassed this error.|||

Hello we have faced the same problem. Using your problem desciption helped us find the drive letter which is not configured correctly.

In our case the drive letter was used by a previous de installed SQL Server configuration. The de install was not completed as it should. To solve the problem, we removed the MSSQL.x (x is a number between 1 and 100) containing sub keys with a value point to the drive missing. You can find these MSSQL.x keys in HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server

The installation completed correctly after deleteing the keys.

Kind regards

Marcel

sql

Error on SQL cluster install

I am trying to install SQL 2005 in a 2-node Windows 2003 cluster. I set the cluster up through Virtual Server 2005 with 2 virtual nodes and one virtual domain. The nodes can connect to each other as well as the physical machine. When I try to install a fresh copy of SQL 2005 on my cluster, I get an error every time. The error stops the installation while checking system configuration after installing prerequisites. The log file entry is as follows:

*******************************************
Setup Consistency Check Report for Machine: --SERVERNAME--
*******************************************
Article: WMI Service Requirement, Result: CheckPassed
Article: MSXML Requirement, Result: CheckPassed
Article: Operating System Minimum Level Requirement, Result: CheckPassed
Article: Operating System Service Pack Level Requirement, Result: CheckPassed
Article: SQL Compatibility With Operating System, Result: CheckPassed
Article: Minimum Hardware Requirement, Result: CheckPassed
Article: IIS Feature Requirement, Result: Warning
Description: IIS is not installed, therefore Report Server feature will be disabled Action: Install IIS in order for Report Server feature to be enabled
Article: Pending Reboot Requirement, Result: CheckPassed
Article: Performance Monitor Counter Requirement, Result: CheckPassed
Article: Default Installation Path Permission Requirement, Result: CheckPassed
Article: Internet Explorer Requirement, Result: CheckPassed
Article: Check COM+ Catalogue, Result: CheckPassed
Article: ASP.Net Registration Requirement, Result: CheckPassed
Article: Minimum MDAC Version Requirement, Result: CheckPassed
<Func Name='PerformDetections'>
1
Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\sqlsval.dll Version:2005.90.1399.0
Error: Action "InvokeSqlSetupDllAction" threw an exception during execution. Error information reported during run:
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "ComputerList" {"SqlComputers", "", ""} in cache
Source File Name: datastore\clusterinfocollector.cpp
Compiler Timestamp: Fri Sep 16 13:20:12 2005
Function Name: ClusterInfoCollector::collectClusterVSInfo
Source Line Number: 883
-
Failed to detect VS info due to datastore exception.
Source File Name: datastore\clustergroupsproperties.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: ClusterGroupScope.SharedDisks
Source Line Number: 56
-
Failed to find a cluster group that owned shared disk: J:
WinException : 2
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.

Source File Name: datastore\clustergroupsproperties.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: ClusterGroupScope.SharedDisks
Source Line Number: 56

This question is perhaps better answered in SQL setup forum.|||Exceptions are difficult to troubleshoot through emails. So isolate the problem by disabling your J drive and see if the problem persists.|||The only problem with disabling that drive is that it's the virtual shared array that I created for the install. If I disable it, then I won't have a shared drive to use.|||I ran into a very similar error. I found it was the fact that I had taken the disk in question offline (even though I was not going to use it for the sql instance, just a spare disk that I had taken offline) Once I brought the disk back online and ran setup again it bypassed this error.|||

Hello we have faced the same problem. Using your problem desciption helped us find the drive letter which is not configured correctly.

In our case the drive letter was used by a previous de installed SQL Server configuration. The de install was not completed as it should. To solve the problem, we removed the MSSQL.x (x is a number between 1 and 100) containing sub keys with a value point to the drive missing. You can find these MSSQL.x keys in HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server

The installation completed correctly after deleteing the keys.

Kind regards

Marcel

Monday, March 12, 2012

Error occurred retrieving child nodes

AS 2005 April CTP.
I have deployed a solution which works fine in other computer. But know in cubes with calculated measures didn't work.
It tells me The dimension '[Measures]' was not found in the cube when the string [Measures].[My Calculation], was parsed.
If I remove the calculated measures the cube works fine but of course I need the calculations.
Any ideas?
Thanks in advance.I'm thinking that it's a problem with collation. I put view code in calculations and change [MEASURES] with [Measures] and it works.
But in AS isn't defined CASE SENSITIVE.
What can I do?

Wednesday, March 7, 2012

Error Messages Cluster

I have a Windows 2000 Advanced Server with SQL Server 2000 Cluster. There
are only two nodes on this cluster.
Two days ago I tried to move one of my resource groups to the other node.
It failed each time I tried. I am presently in the WINNT\cluster.log file
but there is only several hours of data. The event viewer did not list any
errors when the resource group would not move.
Please help me determine the reason my cluster would not move one of my
resource groups to the other server.
Thanks,
Did it at least try to fail over and then immediately fail back? If so,
generally a network card not being available can cause this.
Also check if the other node is a possible failover target for the resource.
Have you rebooted the passive node to see if it works after that?
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Joe K." <JoeK@.discussions.microsoft.com> wrote in message
news:76A1B367-7CC2-4824-BC9F-FD05D418FB81@.microsoft.com...
> I have a Windows 2000 Advanced Server with SQL Server 2000 Cluster. There
> are only two nodes on this cluster.
> Two days ago I tried to move one of my resource groups to the other node.
> It failed each time I tried. I am presently in the WINNT\cluster.log file
> but there is only several hours of data. The event viewer did not list any
> errors when the resource group would not move.
> Please help me determine the reason my cluster would not move one of my
> resource groups to the other server.
> Thanks,