PROBLEM REGARDING VARIABLE PASSING TO STORED PROCEDURE

Hi

I am WORKING IN AN APPLICATION USING SQL SERVER 2000 AND VB6

I'VE A PROBLEM REGARDING VARIABLE PASSING TO STORED PROCEDURE

I WILL EXPLAIN WITH AN EXAMPLE

TABLE STRUCTURE

AccAccounts

Accid(Numeric) AccName(Varchar)

-

1 Cash A/c

2 Students A/c

3 HDFC Bank A/c

my Application will pass the "Accid" as a string format to Stored Procedure

STORED PROCEDURE

--

CREATE PROCEDURE GetAccName
@.Accid Varchar(100)
AS
Select * from Accaccount where accid in (@.Accid)

when i run this SP

declare @.Accid Varchar(100)
set @.Accid ='1,2'

exec GetAccName @.Accid

i get the following error

Server: Msg 8114, Level 16, State 5, Procedure GetAccName, Line 4
Error converting data type varchar to numeric.

please "ANY ONE" help me!!.

The above example is only an example

REGARDS

JAMES

Hi,

You can not use the @.Variable which holds the multiple accountids in Static SQL statement.. you need to use dynamic sql..

Code Snippet

CREATE PROCEDURE GetAccName
@.Accid Varchar(100)
AS
Declare @.cmd varchar(4000)

Set @.Cmd = 'Select * from Accaccount where accid in (' + @.Accid')'

exec (@.cmd)

But would suggest you to go through the following link to see the advantages and disadvantages..

http://www.sommarskog.se/dynamic_sql.html

Regards,

|||

You can also do this without dynamic sql.

Code Snippet

CREATE PROCEDURE GetAccName
@.Accid Varchar(100)
AS
Select *
from AccAccounts
where charindex(','+convert(varchar,accid)+',',','+@.Accid+',')>0

|||

THANK U VERY MUCH

|||

Hi James

You shouldn't pass comma separated values to the stored procedure, like: '1,2,3' . Because when you call the sproc it is trying to convert your value(because accid is numeric in your table) to varchar implicitly and due to the ',' in your data the conversion is going to fail and throws an error. You need to write some other logic to get it done.

Thanks & Regards,

Kiran.Y

|||

HI

THX FOR REPLY

WHAT IN CASE IF I NEED A QRY

Select * from AccAccounts where Accid Not in (1,2)

|||

>0 means a match is found

=0 means no match.

Code Snippet

CREATE PROCEDURE GetAccName
@.Accid Varchar(100)
AS
Select *
from AccAccounts
where charindex(','+convert(varchar,accid)+',',','+@.Accid+',') = 0

|||

Thx

Problem Printing

Hi

I have a problem when I try print a document from a normal user (no work station administrator) the user can't print the report, but when I try print from a administrator I can't print the report without problems.

thanks and greetings.

HI,

I am not sure about this "can't print the report without problems.". Do you mean you also meet some problems when you act as a administrator? If so , What is the exact error or problems you have when you try to print it.

I hope the above information will be helpful. If you have any issues or concerns, please let me know. It's my pleasure to be of assistance

|||

Hi,

I review and the cause of problem they were the permissions of the user over his machine, I give administrator permisions and there is no more the problem, I try found exactly the reason.

greetings.

sql

Problem on ## table

Hi
I have a stored procedure , wherein i create a ## table and get values in
it, i have 3 more procedures which i call from the original procedure which
use the ##table.
When i execute the stored procedure for first time i get the desired
results. when i re-run it again it says the ## table exists . so when i
delete the ## table from tempdb and then re-run it again it works.
Is there a way to delete this ## table right in the begining of execution of
the stored procedure. when i try drop table ## it says the table does not
exists for the first time of execution, if i put the code if (exist whis
table = ##) even this does not work, if i say delte from tempdb.dbo.## even
this does not work
any suggestionTry,
if object_id('tempdb..##t') is not null
drop table ##t
...
AMB
"Rodger" wrote:

> Hi
> I have a stored procedure , wherein i create a ## table and get values in
> it, i have 3 more procedures which i call from the original procedure whic
h
> use the ##table.
> When i execute the stored procedure for first time i get the desired
> results. when i re-run it again it says the ## table exists . so when i
> delete the ## table from tempdb and then re-run it again it works.
> Is there a way to delete this ## table right in the begining of execution
of
> the stored procedure. when i try drop table ## it says the table does not
> exists for the first time of execution, if i put the code if (exist whis
> table = ##) even this does not work, if i say delte from tempdb.dbo.## eve
n
> this does not work
> any suggestion|||It sounds like you should use a local temp table rather than a global
temp table. Specify #tablename rather than ##tablename. Put the DROP
statement at the END of your code that uses the table so that it cleans
up there rather than at the beginning.
David Portas
SQL Server MVP
--|||1) If the stored Procedure is not running multiple instances concurrently,
(i,e., two processes calling it at the same time or overlappiing) Then why
don't you delete it at the end, when the stored Proc is done?
Drop Table ##TableName
or
2) Make it a permanent table and just delete all therecords in it a tteh
beginning (And maybe also at the end) of the stored proc.
or, if the SPs DO run concurrently, you could
3) change the data structure of the temp table so that records being
inserted can be identified as to which instance of the SP they were created
from, (Add an "Instance" or "RunNo" Column) and then modify all other
statements in the SP to affect only those records,
"Rodger" wrote:

> Hi
> I have a stored procedure , wherein i create a ## table and get values in
> it, i have 3 more procedures which i call from the original procedure whic
h
> use the ##table.
> When i execute the stored procedure for first time i get the desired
> results. when i re-run it again it says the ## table exists . so when i
> delete the ## table from tempdb and then re-run it again it works.
> Is there a way to delete this ## table right in the begining of execution
of
> the stored procedure. when i try drop table ## it says the table does not
> exists for the first time of execution, if i put the code if (exist whis
> table = ##) even this does not work, if i say delte from tempdb.dbo.## eve
n
> this does not work
> any suggestion|||You might want to consider writing a single procedure that replaces
this chain of calls. I have found that temp tables can often be
replaced with VIEWs, derived tables or CTEs.
Programming with temp tables in SQL Server is usually a sign that the
programmer is mimicking a procedural file system model of data in which
each of a series of procedural steps is written to a temp table (aka
"Scratch tape") and processed sequentially.

Problem of adding trusted accounts to reporting services: 'Some or all identity references

Hi

I created a new database called "TestReportServer" as mentioned in the installation instruction but I didn't
see (or could select) the option "Create the report server database in SharePoint integrated mode".
How can I select this option? Do I need to remove the reporing services and reinstall it again? Any suggestions?

After creating the database I get the error 'Some or all identity references could not be translated'.

The user I selected is a local administrator and has permission to all groups starting with wss.

I guess the database is not created as a sharepoint integration mode as I can start Server Management Studio
and see the database. Is that a correct assumption?

I hope somebody out there can help as I am strating to bang my head towards my desk right now :-)

What is the version of report server?

|||It is reporting services 2005.|||Do you know build number?|||How and where can I check that?|||It is Microsoft SQL Server Reporting Services Version 9.00.1399.00|||

This is SQL Server 2005 RTM. Please install SP2 Nov CTP ( http://www.microsoft.com/downloads/details.aspx?FamilyID=d2da6579-d49c-4b25-8f8a-79d14145500d&DisplayLang=en )

Problem installing sql2k Cluster on Win2k3 server

Hi:
I cannot install SQL 2000 on a win2k3 cluster, I get the
error: Setup Failed to Perform Required Operations on the
Cluster Nodes.
Here is the SQLSTP.log file:
13:22:32 Begin Setup
13:22:32 8.00.194
13:22:32 Mode = Normal
13:22:32 ModeType = NORMAL
13:22:32 GetDefinitionEx returned: 0, Extended: 0x0
13:22:32 ValueFTS returned: 1
13:22:32 ValuePID returned: 1
13:22:32 ValueLic returned: 1
13:22:32 System: Windows NT Enterprise Server
13:22:32 SQL Server ProductType: Enterprise Edition [0x3]
13:22:32 IsNTCluster returned: 1
13:22:32 Begin Action: SetupInitialize
13:22:32 End Action SetupInitialize
13:22:32 Begin Action: SetupInstall
13:22:32 Reading
Software\Microsoft\Windows\CurrentVersion\CommonFi lesDir ..
..
13:22:32 CommonFilesDir=C:\Program Files\Common Files
13:22:32 Windows Directory=C:\WINDOWS\
13:22:32 Program Files=C:\Program Files\
13:22:32 TEMPDIR=C:\WINDOWS\TEMP\
13:22:32 Begin Action: SetupInstall
13:22:32 digpid size : 256
13:22:32 digpid size : 164
13:22:32 Begin Action: CheckFixedRequirements
13:22:32 Platform ID: 0xf00000
13:22:32 Version: 5.2.3790
13:22:32 File Version - C:\WINDOWS\system32\shdocvw.dll:
6.0.3790.0
13:22:32 End Action: CheckFixedRequirements
13:22:32 Begin Action: ShowDialogs
13:22:32 Initial Dialog Mask: 0x183000f7, Disable Back=0x1
13:22:32 Begin Action ShowDialogsHlpr: 0x1
13:22:32 Begin Action: DialogShowSdWelcome
13:22:33 End Action DialogShowSdWelcome
13:22:33 Dialog 0x1 returned: 1
13:22:33 End Action ShowDialogsHlpr
13:22:33 ShowDialogsGetDialog returned:
nCurrent=0x2,index=1
13:22:33 Begin Action ShowDialogsHlpr: 0x2
13:22:33 Begin Action: DialogShowSdMachineName
13:22:42 ShowDlgMachine returned: 1
13:22:42 Name = AVL, Type = 0x10000008
13:22:42 Begin Action: CheckRequirements
13:22:42 Processor Architecture: x86 (Pentium)
13:22:42 ComputerName: AVLNODO1
13:22:42 User Name: Administrator
13:22:42 IsAllAccessAllowed returned: 1
13:22:42 OS Language: 0x409
13:22:42 End Action CheckRequirements
13:22:42 This combination of Package and Operating System
allows a full product install.
13:22:42 End Action DialogShowSdMachineName
13:22:42 begin ShowDialogsUpdateMask
13:22:42 nFullMask = 0x183000f7, nCurrent = 0x2,
nDirection = 0
13:22:42 Updated Dialog Mask: 0xbf3c037, Disable Back = 0x1
13:22:42 Dialog 0x2 returned: 0
13:22:42 End Action ShowDialogsHlpr
13:22:42 ShowDialogsGetDialog returned:
nCurrent=0x4,index=2
13:22:42 Begin Action ShowDialogsHlpr: 0x4
13:22:42 Begin Action: DialogShowSdInstallMode
13:22:42 InstallMode : 0x1
13:22:42 End Action DialogShowSdInstallMode
13:22:42 begin ShowDialogsUpdateMask
13:22:42 nFullMask = 0xbf3c037, nCurrent = 0x4, nDirection
= 1
13:22:42 Updated Dialog Mask: 0x1bf7c037, Disable Back =
0x1
13:22:42 Dialog 0x4 returned: 1
13:22:42 End Action ShowDialogsHlpr
13:22:42 ShowDialogsGetDialog returned:
nCurrent=0x10,index=4
13:22:42 Begin Action ShowDialogsHlpr: 0x10
13:22:42 Begin Action: DialogShowSdRegisterUserEx
13:22:43 End Action DialogShowSdRegisterUserEx
13:22:43 begin ShowDialogsUpdateMask
13:22:43 nFullMask = 0x1bf7c037, nCurrent = 0x10,
nDirection = 1
13:22:43 Updated Dialog Mask: 0x1bf7c037, Disable Back =
0x1
13:22:43 Dialog 0x10 returned: 1
13:22:43 End Action ShowDialogsHlpr
13:22:43 ShowDialogsGetDialog returned:
nCurrent=0x20,index=5
13:22:43 Begin Action ShowDialogsHlpr: 0x20
13:22:43 Begin Action: DialogShowSdLicense
13:22:45 End Action DialogShowSdLicense
13:22:45 Dialog 0x20 returned: 1
13:22:45 End Action ShowDialogsHlpr
13:22:45 ShowDialogsGetDialog returned:
nCurrent=0x4000,index=14
13:22:45 Begin Action ShowDialogsHlpr: 0x4000
13:22:45 Begin Action: DialogShowSdVirtualServer
13:22:58 ShowDlgVirtualServer returned: 0
13:22:58 Ipaddress = 192.168.0.80,255.255.255.0,Public
13:22:58 szNewList = 192.168.0.80,255.255.255.0,Public
13:22:58 szModifiedList =
13:22:58 szRemovedList =
13:22:58 End Action DialogShowSdVirtualServer
13:22:58 begin ShowDialogsUpdateMask
13:22:58 nFullMask = 0x1bf7c037, nCurrent = 0x4000,
nDirection = 1
13:22:58 Updated Dialog Mask: 0x1bf7c037, Disable Back =
0x1
13:22:58 Dialog 0x4000 returned: 1
13:22:58 End Action ShowDialogsHlpr
13:22:58 ShowDialogsGetDialog returned:
nCurrent=0x8000,index=15
13:22:58 Begin Action ShowDialogsHlpr: 0x8000
13:22:58 Begin Action : DialogShowSdDiskGroups
13:23:00 ShowDlgDiskGroups returned: 1
13:23:00 Disk Group = DATABASE
13:23:00 End Action : DialogShowSdDiskGroups
13:23:00 begin ShowDialogsUpdateMask
13:23:00 nFullMask = 0x1bf7c037, nCurrent = 0x8000,
nDirection = 1
13:23:00 Updated Dialog Mask: 0x1bf7c037, Disable Back =
0x1
13:23:00 Dialog 0x8000 returned: 1
13:23:00 End Action ShowDialogsHlpr
13:23:00 ShowDialogsGetDialog returned:
nCurrent=0x10000,index=16
13:23:00 Begin Action ShowDialogsHlpr: 0x10000
13:23:00 Begin Action: DialogShowSdClusterDef
13:23:05 ShowDlgClusterDef returned: 1
13:23:05 PrefOwners = AVLNODO1,AVLNODO2, NumIp = 2
13:23:05 Begin Action : ValidateNodeActions
13:23:05 Begin Action : ValidateNodeActions
13:23:05 End Action : ValidateNodeActions
13:23:05 End Action : ValidateNodeActions
13:23:05 End Action DialogShowSdClusterDef
13:23:05 begin ShowDialogsUpdateMask
13:23:05 nFullMask = 0x1bf7c037, nCurrent = 0x10000,
nDirection = 1
13:23:05 Updated Dialog Mask: 0x1bf7c037, Disable Back =
0x1
13:23:05 Dialog 0x10000 returned: 1
13:23:05 End Action ShowDialogsHlpr
13:23:05 ShowDialogsGetDialog returned:
nCurrent=0x20000,index=17
13:23:05 Begin Action ShowDialogsHlpr: 0x20000
13:23:05 Begin Action : Cluster Security - DlgAcct
13:23:14 ShowDlgAcct returned: 1
13:23:14 [DlgAccount]
13:23:14 Domain = AVL-CWP
13:23:14 DomainAcct = Administrator
13:23:14 DomainPwd
13:23:14 Result = 1
13:23:14 End Action : Cluster Security - DlgAcct
13:23:14 begin ShowDialogsUpdateMask
13:23:14 nFullMask = 0x1bf7c037, nCurrent = 0x20000,
nDirection = 1
13:23:14 Updated Dialog Mask: 0x1bf7c037, Disable Back =
0x1
13:23:14 Dialog 0x20000 returned: 1
13:23:14 End Action ShowDialogsHlpr
13:23:14 ShowDialogsGetDialog returned:
nCurrent=0x40000,index=18
13:23:14 Begin Action ShowDialogsHlpr: 0x40000
13:23:14 Begin Action: DialogShowSdCliSvr
13:23:14 DisplaySystemPreReq
13:23:14 ShowDlgClientServerSelect returned: 1
13:23:14 Type : 0x2
13:23:14 End Action DialogShowSdCliSvr
13:23:14 begin ShowDialogsUpdateMask
13:23:14 nFullMask = 0x1bf7c037, nCurrent = 0x40000,
nDirection = 1
13:23:14 Updated Dialog Mask: 0x1bffc037, Disable Back =
0x1
13:23:14 Dialog 0x40000 returned: 1
13:23:14 End Action ShowDialogsHlpr
13:23:14 ShowDialogsGetDialog returned:
nCurrent=0x80000,index=19
13:23:14 Begin Action ShowDialogsHlpr: 0x80000
13:23:14 Begin Action: DialogShowSdInstanceName
13:23:14 Begin Action: ShowDlgInstanceName
13:23:15 End Action: ShowDlgInstanceName
13:23:15 ShowDlgInstanceName returned : 1
13:23:15 InstanceName : MSSQLSERVER
13:23:20 CreateSetupTopology(AVL), Handle : 0x1194098,
returned : 0
13:23:20 CreateSetupTopology returned : 0, Handle :
0x1194098
13:23:20 Topology Type : 34, Return Value : 0
13:23:20 ST_GetPhysicalNode returned : 0, PNHandle :
0x11940e8
13:23:20 PN_EnumerateEx returned : 0
13:23:20 PN_GetSQLStates returned : 0, SqlStates : 0x0
13:23:20 PN_StartScan [0x11940e8] returned : 0
13:23:20 PN_GetNext [0x11940e8] returned : 18, Handle:
[0x0]
13:23:20 No more items in enumeration.
13:23:20 ReleaseSetupTopology
13:23:20 End Action DialogShowSdInstanceName
13:23:20 begin ShowDialogsUpdateMask
13:23:20 nFullMask = 0x1bffc037, nCurrent = 0x80000,
nDirection = 1
13:23:20 Updated Dialog Mask: 0x1bffc037, Disable Back =
0x1
13:23:20 Dialog 0x80000 returned: 1
13:23:20 End Action ShowDialogsHlpr
13:23:20 ShowDialogsGetDialog returned:
nCurrent=0x100000,index=20
13:23:20 Begin Action ShowDialogsHlpr: 0x100000
13:23:20 Begin Action: DialogShowSdSetupType
13:23:20 Begin Action: Setup Type
13:23:24 SQL program folder: C:\Program Files\Microsoft
SQL Server
13:23:24 SQL data folder: D:\Program Files\Microsoft SQL
Server
13:23:24 Windows system folder: C:\WINDOWS\system32\
13:23:24 Prog req: 38205, Data req: 34432, Sys req: 183105
13:23:24 Prog avail: 32618500, Data avail: 137948088, Sys
avail: 32618500
13:23:24 Prog req vs. avail, 221310, 32618500
13:23:24 Data req vs. avail, 34432, 137948088
13:23:24 Sys req vs. avail, 183105, 32618500
13:23:24 DisplaySystemPreReq
13:23:24 [SetupTypeSQL]
13:23:24 szDir = C:\Program Files\Microsoft SQL Server
13:23:24 szDir = C:\Program Files\Microsoft SQL Server
13:23:24 Result = 301
13:23:24 szDataDir = D:\Program Files\Microsoft SQL Server
13:23:24 szDataDir = D:\Program Files\Microsoft SQL Server
13:23:24 End Action: Setup Type
13:23:24 Setup Type: Typical (301)
13:23:24 End Action DialogShowSdSetupType
13:23:24 begin ShowDialogsUpdateMask
13:23:24 nFullMask = 0x1bffc037, nCurrent = 0x100000,
nDirection = 301
13:23:24 Updated Dialog Mask: 0x1bdfc037, Disable Back =
0x1
13:23:24 Dialog 0x100000 returned: 301
13:23:24 End Action ShowDialogsHlpr
13:23:24 ShowDialogsGetDialog returned:
nCurrent=0x400000,index=22
13:23:24 Begin Action ShowDialogsHlpr: 0x400000
13:23:24 Begin Action: DlgServices
13:23:34 ShowDlgServices returned: 1
13:23:34 [DlgServices]
13:23:34 Local-Domain= 61680
13:23:34 AutoStart= 0
13:23:34 SQLDomain= AVL-CWP
13:23:34 SQLDomainAcct= _sqlmanager
13:23:34 SQLDomainPwd
13:23:34 AgtDomain= AVL-CWP
13:23:34 AgtDomainAcct= _sqlmanager
13:23:34 AgtDomainPwd
13:23:34 Result= 1
13:23:34 End Action DlgServices
13:23:34 begin ShowDialogsUpdateMask
13:23:34 nFullMask = 0x1bdfc037, nCurrent = 0x400000,
nDirection = 1
13:23:34 Updated Dialog Mask: 0x1bdfc037, Disable Back =
0x1
13:23:34 Dialog 0x400000 returned: 1
13:23:34 End Action ShowDialogsHlpr
13:23:34 ShowDialogsGetDialog returned:
nCurrent=0x800000,index=23
13:23:34 Begin Action ShowDialogsHlpr: 0x800000
13:23:34 Begin Action: DlgSQLSecurity
13:23:35 ShowDlgSQLSecurity returned: 1
13:23:35 LoginMode = 1,szPwd
13:23:35 End Action DlgSQLSecurity
13:23:35 begin ShowDialogsUpdateMask
13:23:35 nFullMask = 0x1bdfc037, nCurrent = 0x800000,
nDirection = 1
13:23:35 Updated Dialog Mask: 0x1bdfc037, Disable Back =
0x1
13:23:35 Dialog 0x800000 returned: 1
13:23:35 End Action ShowDialogsHlpr
13:23:35 ShowDialogsGetDialog returned:
nCurrent=0x1000000,index=24
13:23:35 Begin Action ShowDialogsHlpr: 0x1000000
13:23:35 Begin Action: DlgCollation
13:23:40 ShowDlgCollation returned: 1
13:23:40 collation_name =
SQL_Latin1_General_CP1_CI_AS,locale_name =
Latin1_General,lcid = 0x409,SortId = 52,dwCompFlags =
0x30001
13:23:40 End Action DlgCollation
13:23:40 begin ShowDialogsUpdateMask
13:23:40 nFullMask = 0x1bdfc037, nCurrent = 0x1000000,
nDirection = 1
13:23:40 Updated Dialog Mask: 0x1bdfc037, Disable Back =
0x1
13:23:40 Dialog 0x1000000 returned: 1
13:23:40 End Action ShowDialogsHlpr
13:23:40 ShowDialogsGetDialog returned:
nCurrent=0x2000000,index=25
13:23:40 Begin Action ShowDialogsHlpr: 0x2000000
13:23:40 Begin Action: DlgNetwork
13:23:40 ShowDlgNetwork returned: 1
13:23:40 [DlgServerNetwork]
13:23:40 NetworkLibs = 255
13:23:40 TCPPort = 1433
13:23:40 TCPPrxy = Default
13:23:40 NMPPipeName = \\.\pipe\sql\query
13:23:40 Result = 1
13:23:40 End Action DlgNetwork
13:23:40 begin ShowDialogsUpdateMask
13:23:40 nFullMask = 0x1bdfc037, nCurrent = 0x2000000,
nDirection = 1
13:23:40 Updated Dialog Mask: 0x1bdfc037, Disable Back =
0x1
13:23:40 Dialog 0x2000000 returned: 1
13:23:40 End Action ShowDialogsHlpr
13:23:40 ShowDialogsGetDialog returned:
nCurrent=0x8000000,index=27
13:23:40 Begin Action ShowDialogsHlpr: 0x8000000
13:23:40 Begin Action: DialogShowSdStartCopy
13:23:41 End Action DialogShowSdStartCopy
13:23:41 begin ShowDialogsUpdateMask
13:23:41 nFullMask = 0x1bdfc037, nCurrent = 0x8000000,
nDirection = 1
13:23:41 Updated Dialog Mask: 0x1bdfc037, Disable Back =
0x1
13:23:41 Dialog 0x8000000 returned: 1
13:23:41 End Action ShowDialogsHlpr
13:23:41 ShowDialogsGetDialog returned:
nCurrent=0x10000000,index=28
13:23:41 Begin Action ShowDialogsHlpr: 0x10000000
13:23:41 Begin Action: DialogShowSdLicenseMode
13:23:45 ShowDlgLicense returned: 1
13:23:45 ShowDlgLicense returned: LicenseMode = 0,
LicenseLimit = 2
13:23:45 End Action DialogShowSdLicenseMode
13:23:45 Dialog 0x10000000 returned: 1
13:23:45 End Action ShowDialogsHlpr
13:23:45 ShowDialogsGetDialog returned:
nCurrent=0x0,index=0
13:23:45 End Action ShowDialogs
13:23:45 Setup is installing Microsoft Distributed
Transaction Coordinator (MSDTC) ...
13:23:45 C:\WINDOWS\TEMP\SqlSetup\Bin\cldtcstp.exe -
SupportDir "C:\WINDOWS\TEMP\SqlSetup\Bin" -DTCPkg "E:\x86
\Other\dtcsetup.exe" -LogFile "C:\WINDOWS\sqlstp.log" -
CtxAcct "AVL-CWP\Administrator" -CtxEPwd
13:23:47 Process Exit Code: (0)
13:23:47 Begin Action : ClusterSetupHelper
13:23:47 Begin Action : CreateClustISSFiles
13:23:47 End Action : CreateClustISSFiles
13:23:47 Begin Action : ClusterWriteRemIni
13:23:47 End Action : ClusterWriteRemIni
13:23:47 Begin Action : Run setup on cluster nodes
[args]
NumRemoteServers=2
Server.1=AVLNODO1
Server.2=AVLNODO2
[Server.1]
NumRemoteServices=1
1.app=\\AVLNODO1\E$\x86\setup\setupsql.exe
1.server=AVLNODO1
1.script=\\AVLNODO1\admin$\AVLNODO1_MSSQLSERVER.is s
1.cmdlineformat=%s k=Nb k=Rm k=Cl -SMS -s -f "\\AVLNODO1
\E$\x86\setup\setup.ins" -f1 %s -f2 "\\AVLNODO1
\admin$\setup.log" -e "stpsilnt._ex" -b -
x "C:\WINDOWS\TEMP\"
1.user=AVL-CWP\Administrator
1.password=095c53b158d550021ef0
1.name=SQLSetup1
1.sqlsetup=Y
1.copyexe=cnvsvc1.exe
[Server.2]
NumRemoteServices=1
1.app=\\AVLNODO1\E$\x86\setup\setupsql.exe
1.server=AVLNODO2
1.script=\\AVLNODO1\admin$\AVLNODO2_MSSQLSERVER.is s
1.cmdlineformat=%s k=ClSec k=Rm k=Cl -SMS -s -f "\\AVLNODO1
\E$\x86\setup\setup.ins" -f1 %s -f2 "\\AVLNODO2
\admin$\setup.log" -e "stpsilnt._ex" -x "C:\"
1.user=AVL-CWP\Administrator
1.password=095c53b158d550021ef0
1.name=SQLSetup2
1.sqlsetup=Y
1.copyexe=cnvsvc2.exe
13:23:48 Setup is performing required operations on
cluster nodes. This may take a few minutes...
13:23:48 C:\WINDOWS\TEMP\SqlSetup\Bin\remsetup.exe
C:\WINDOWS\remsetup.ini
13:25:06 Process Exit Code: (2) The system cannot find the
file specified.
13:25:06 Begin Action : GetRemsetupRetCode
13:25:06 Installation return status on AVLNODO1 : 2
13:25:06 Installation return status on AVLNODO2 : 2
13:25:06 End Action : GetRemsetupRetCode
#### SQL Server Remote Setup - Start Time 09/24/04
13:23:48 ####
CThreadPool::RunUntilCompleteHlpr create thread, index=0
CThread::Run thread [0x64] created for execution.
CThread::Process [0x64]
CThreadPool::RunUntilCompleteHlpr create thread, index=1
Running '\\AVLNODO1\E$\x86\setup\setupsql.exe k=Nb k=Rm
k=Cl -SMS -s -f "\\AVLNODO1\E$\x86\setup\setup.ins" -f1
\\AVLNODO1\admin$\AVLNODO1_MSSQLSERVER.iss -f2 "\\AVLNODO1
\admin$\setup.log" -e "stpsilnt._ex" -b -
x "C:\WINDOWS\TEMP\"' (AVLNODO1) ...
CThread::Run thread [0x68] created for execution.
CThread::Process [0x68]
CThreadPool::RunUntilCompleteHlpr start thread
[0x64],index=0
CThreadPool::RunUntilCompleteHlpr start thread
[0x68],index=1
Script file copied to '\\AVLNODO2
\ADMIN$\AVLNODO2_MSSQLSERVER.iss' successfully.
Installing remote service (AVLNODO2)...
Running '\\AVLNODO1\E$\x86\setup\setupsql.exe k=ClSec k=Rm
k=Cl -SMS -s -f "\\AVLNODO1\E$\x86\setup\setup.ins" -f1
\\AVLNODO2\ADMIN$\AVLNODO2_MSSQLSERVER.iss -f2 "\\AVLNODO2
\admin$\setup.log" -e "stpsilnt._ex" -x "C:\"'
(AVLNODO2) ...
CProcess::RunUntilComplete [0x64] exit code: 2
Remote process exit code was '2' (AVLNODO1).
CThreadPool::RunUntilCompleteHlpr WaitForMultipleObjects
returned: 0
CThreadPool::RunUntilCompleteHlpr signaled thread [0x64]
Thread [0x64] exit code: [0x2]
CRemoteProcess::RunUntilComplete [0x68] exit code: 2
Remote process exit code was '2' (AVLNODO2).
CThreadPool::RunUntilCompleteHlpr WaitForMultipleObjects
returned: 2
CThreadPool::RunUntilCompleteHlpr signaled thread [0x68]
Thread [0x68] exit code: [0x2]
CThreadPool::RunUntilComplete returned 2
CThreadPool::RunUntilComplete execution level=1, need
execution: 0
One or more errors occurred while running the
remote/unattended setups.
Disconnecting from remote machine (AVLNODO1)...
Service removed successfully.
Remote files could not be removed.
#### SQL Server Remote Setup - Stop Time 09/24/04 13:24:49
####
Disconnecting from remote machine (AVLNODO2)...
Service removed successfully.
Remote files removed successfully.
#### SQL Server Remote Setup - Stop Time 09/24/04 13:25:06
####

13:25:06 End Action : Run setup on cluster nodes
13:25:06 One or more errors occurred while running remote
setup on the clustered machines.
13:28:20 Setup failed to perform required operations on
the cluster nodes.
13:28:20 Begin Action : ClusterErrorCleanup
13:28:20 End Action : ClusterErrorCleanup
13:28:20 End Action : ClusterSetupHelper
Any idea?
check KB815431 and 321063 to see if that helps.
Jeff
"Edd" <anonymous@.discussions.microsoft.com> wrote in message
news:0be701c4a265$3815dcd0$a501280a@.phx.gbl...
> Hi:
> I cannot install SQL 2000 on a win2k3 cluster, I get the
> error: Setup Failed to Perform Required Operations on the
> Cluster Nodes.
> Here is the SQLSTP.log file:
> 13:22:32 Begin Setup
> 13:22:32 8.00.194
> 13:22:32 Mode = Normal
> 13:22:32 ModeType = NORMAL
> 13:22:32 GetDefinitionEx returned: 0, Extended: 0x0
> 13:22:32 ValueFTS returned: 1
> 13:22:32 ValuePID returned: 1
> 13:22:32 ValueLic returned: 1
> 13:22:32 System: Windows NT Enterprise Server
> 13:22:32 SQL Server ProductType: Enterprise Edition [0x3]
> 13:22:32 IsNTCluster returned: 1
> 13:22:32 Begin Action: SetupInitialize
> 13:22:32 End Action SetupInitialize
> 13:22:32 Begin Action: SetupInstall
> 13:22:32 Reading
> Software\Microsoft\Windows\CurrentVersion\CommonFi lesDir ..
> .
> 13:22:32 CommonFilesDir=C:\Program Files\Common Files
> 13:22:32 Windows Directory=C:\WINDOWS\
> 13:22:32 Program Files=C:\Program Files\
> 13:22:32 TEMPDIR=C:\WINDOWS\TEMP\
> 13:22:32 Begin Action: SetupInstall
> 13:22:32 digpid size : 256
> 13:22:32 digpid size : 164
> 13:22:32 Begin Action: CheckFixedRequirements
> 13:22:32 Platform ID: 0xf00000
> 13:22:32 Version: 5.2.3790
> 13:22:32 File Version - C:\WINDOWS\system32\shdocvw.dll:
> 6.0.3790.0
> 13:22:32 End Action: CheckFixedRequirements
> 13:22:32 Begin Action: ShowDialogs
> 13:22:32 Initial Dialog Mask: 0x183000f7, Disable Back=0x1
> 13:22:32 Begin Action ShowDialogsHlpr: 0x1
> 13:22:32 Begin Action: DialogShowSdWelcome
> 13:22:33 End Action DialogShowSdWelcome
> 13:22:33 Dialog 0x1 returned: 1
> 13:22:33 End Action ShowDialogsHlpr
> 13:22:33 ShowDialogsGetDialog returned:
> nCurrent=0x2,index=1
> 13:22:33 Begin Action ShowDialogsHlpr: 0x2
> 13:22:33 Begin Action: DialogShowSdMachineName
> 13:22:42 ShowDlgMachine returned: 1
> 13:22:42 Name = AVL, Type = 0x10000008
> 13:22:42 Begin Action: CheckRequirements
> 13:22:42 Processor Architecture: x86 (Pentium)
> 13:22:42 ComputerName: AVLNODO1
> 13:22:42 User Name: Administrator
> 13:22:42 IsAllAccessAllowed returned: 1
> 13:22:42 OS Language: 0x409
> 13:22:42 End Action CheckRequirements
> 13:22:42 This combination of Package and Operating System
> allows a full product install.
> 13:22:42 End Action DialogShowSdMachineName
> 13:22:42 begin ShowDialogsUpdateMask
> 13:22:42 nFullMask = 0x183000f7, nCurrent = 0x2,
> nDirection = 0
> 13:22:42 Updated Dialog Mask: 0xbf3c037, Disable Back = 0x1
> 13:22:42 Dialog 0x2 returned: 0
> 13:22:42 End Action ShowDialogsHlpr
> 13:22:42 ShowDialogsGetDialog returned:
> nCurrent=0x4,index=2
> 13:22:42 Begin Action ShowDialogsHlpr: 0x4
> 13:22:42 Begin Action: DialogShowSdInstallMode
> 13:22:42 InstallMode : 0x1
> 13:22:42 End Action DialogShowSdInstallMode
> 13:22:42 begin ShowDialogsUpdateMask
> 13:22:42 nFullMask = 0xbf3c037, nCurrent = 0x4, nDirection
> = 1
> 13:22:42 Updated Dialog Mask: 0x1bf7c037, Disable Back =
> 0x1
> 13:22:42 Dialog 0x4 returned: 1
> 13:22:42 End Action ShowDialogsHlpr
> 13:22:42 ShowDialogsGetDialog returned:
> nCurrent=0x10,index=4
> 13:22:42 Begin Action ShowDialogsHlpr: 0x10
> 13:22:42 Begin Action: DialogShowSdRegisterUserEx
> 13:22:43 End Action DialogShowSdRegisterUserEx
> 13:22:43 begin ShowDialogsUpdateMask
> 13:22:43 nFullMask = 0x1bf7c037, nCurrent = 0x10,
> nDirection = 1
> 13:22:43 Updated Dialog Mask: 0x1bf7c037, Disable Back =
> 0x1
> 13:22:43 Dialog 0x10 returned: 1
> 13:22:43 End Action ShowDialogsHlpr
> 13:22:43 ShowDialogsGetDialog returned:
> nCurrent=0x20,index=5
> 13:22:43 Begin Action ShowDialogsHlpr: 0x20
> 13:22:43 Begin Action: DialogShowSdLicense
> 13:22:45 End Action DialogShowSdLicense
> 13:22:45 Dialog 0x20 returned: 1
> 13:22:45 End Action ShowDialogsHlpr
> 13:22:45 ShowDialogsGetDialog returned:
> nCurrent=0x4000,index=14
> 13:22:45 Begin Action ShowDialogsHlpr: 0x4000
> 13:22:45 Begin Action: DialogShowSdVirtualServer
> 13:22:58 ShowDlgVirtualServer returned: 0
> 13:22:58 Ipaddress = 192.168.0.80,255.255.255.0,Public
> 13:22:58 szNewList = 192.168.0.80,255.255.255.0,Public
> 13:22:58 szModifiedList =
> 13:22:58 szRemovedList =
> 13:22:58 End Action DialogShowSdVirtualServer
> 13:22:58 begin ShowDialogsUpdateMask
> 13:22:58 nFullMask = 0x1bf7c037, nCurrent = 0x4000,
> nDirection = 1
> 13:22:58 Updated Dialog Mask: 0x1bf7c037, Disable Back =
> 0x1
> 13:22:58 Dialog 0x4000 returned: 1
> 13:22:58 End Action ShowDialogsHlpr
> 13:22:58 ShowDialogsGetDialog returned:
> nCurrent=0x8000,index=15
> 13:22:58 Begin Action ShowDialogsHlpr: 0x8000
> 13:22:58 Begin Action : DialogShowSdDiskGroups
> 13:23:00 ShowDlgDiskGroups returned: 1
> 13:23:00 Disk Group = DATABASE
> 13:23:00 End Action : DialogShowSdDiskGroups
> 13:23:00 begin ShowDialogsUpdateMask
> 13:23:00 nFullMask = 0x1bf7c037, nCurrent = 0x8000,
> nDirection = 1
> 13:23:00 Updated Dialog Mask: 0x1bf7c037, Disable Back =
> 0x1
> 13:23:00 Dialog 0x8000 returned: 1
> 13:23:00 End Action ShowDialogsHlpr
> 13:23:00 ShowDialogsGetDialog returned:
> nCurrent=0x10000,index=16
> 13:23:00 Begin Action ShowDialogsHlpr: 0x10000
> 13:23:00 Begin Action: DialogShowSdClusterDef
> 13:23:05 ShowDlgClusterDef returned: 1
> 13:23:05 PrefOwners = AVLNODO1,AVLNODO2, NumIp = 2
> 13:23:05 Begin Action : ValidateNodeActions
> 13:23:05 Begin Action : ValidateNodeActions
> 13:23:05 End Action : ValidateNodeActions
> 13:23:05 End Action : ValidateNodeActions
> 13:23:05 End Action DialogShowSdClusterDef
> 13:23:05 begin ShowDialogsUpdateMask
> 13:23:05 nFullMask = 0x1bf7c037, nCurrent = 0x10000,
> nDirection = 1
> 13:23:05 Updated Dialog Mask: 0x1bf7c037, Disable Back =
> 0x1
> 13:23:05 Dialog 0x10000 returned: 1
> 13:23:05 End Action ShowDialogsHlpr
> 13:23:05 ShowDialogsGetDialog returned:
> nCurrent=0x20000,index=17
> 13:23:05 Begin Action ShowDialogsHlpr: 0x20000
> 13:23:05 Begin Action : Cluster Security - DlgAcct
> 13:23:14 ShowDlgAcct returned: 1
> 13:23:14 [DlgAccount]
> 13:23:14 Domain = AVL-CWP
> 13:23:14 DomainAcct = Administrator
> 13:23:14 DomainPwd
> 13:23:14 Result = 1
> 13:23:14 End Action : Cluster Security - DlgAcct
> 13:23:14 begin ShowDialogsUpdateMask
> 13:23:14 nFullMask = 0x1bf7c037, nCurrent = 0x20000,
> nDirection = 1
> 13:23:14 Updated Dialog Mask: 0x1bf7c037, Disable Back =
> 0x1
> 13:23:14 Dialog 0x20000 returned: 1
> 13:23:14 End Action ShowDialogsHlpr
> 13:23:14 ShowDialogsGetDialog returned:
> nCurrent=0x40000,index=18
> 13:23:14 Begin Action ShowDialogsHlpr: 0x40000
> 13:23:14 Begin Action: DialogShowSdCliSvr
> 13:23:14 DisplaySystemPreReq
> 13:23:14 ShowDlgClientServerSelect returned: 1
> 13:23:14 Type : 0x2
> 13:23:14 End Action DialogShowSdCliSvr
> 13:23:14 begin ShowDialogsUpdateMask
> 13:23:14 nFullMask = 0x1bf7c037, nCurrent = 0x40000,
> nDirection = 1
> 13:23:14 Updated Dialog Mask: 0x1bffc037, Disable Back =
> 0x1
> 13:23:14 Dialog 0x40000 returned: 1
> 13:23:14 End Action ShowDialogsHlpr
> 13:23:14 ShowDialogsGetDialog returned:
> nCurrent=0x80000,index=19
> 13:23:14 Begin Action ShowDialogsHlpr: 0x80000
> 13:23:14 Begin Action: DialogShowSdInstanceName
> 13:23:14 Begin Action: ShowDlgInstanceName
> 13:23:15 End Action: ShowDlgInstanceName
> 13:23:15 ShowDlgInstanceName returned : 1
> 13:23:15 InstanceName : MSSQLSERVER
> 13:23:20 CreateSetupTopology(AVL), Handle : 0x1194098,
> returned : 0
> 13:23:20 CreateSetupTopology returned : 0, Handle :
> 0x1194098
> 13:23:20 Topology Type : 34, Return Value : 0
> 13:23:20 ST_GetPhysicalNode returned : 0, PNHandle :
> 0x11940e8
> 13:23:20 PN_EnumerateEx returned : 0
> 13:23:20 PN_GetSQLStates returned : 0, SqlStates : 0x0
> 13:23:20 PN_StartScan [0x11940e8] returned : 0
> 13:23:20 PN_GetNext [0x11940e8] returned : 18, Handle:
> [0x0]
> 13:23:20 No more items in enumeration.
> 13:23:20 ReleaseSetupTopology
> 13:23:20 End Action DialogShowSdInstanceName
> 13:23:20 begin ShowDialogsUpdateMask
> 13:23:20 nFullMask = 0x1bffc037, nCurrent = 0x80000,
> nDirection = 1
> 13:23:20 Updated Dialog Mask: 0x1bffc037, Disable Back =
> 0x1
> 13:23:20 Dialog 0x80000 returned: 1
> 13:23:20 End Action ShowDialogsHlpr
> 13:23:20 ShowDialogsGetDialog returned:
> nCurrent=0x100000,index=20
> 13:23:20 Begin Action ShowDialogsHlpr: 0x100000
> 13:23:20 Begin Action: DialogShowSdSetupType
> 13:23:20 Begin Action: Setup Type
> 13:23:24 SQL program folder: C:\Program Files\Microsoft
> SQL Server
> 13:23:24 SQL data folder: D:\Program Files\Microsoft SQL
> Server
> 13:23:24 Windows system folder: C:\WINDOWS\system32\
> 13:23:24 Prog req: 38205, Data req: 34432, Sys req: 183105
> 13:23:24 Prog avail: 32618500, Data avail: 137948088, Sys
> avail: 32618500
> 13:23:24 Prog req vs. avail, 221310, 32618500
> 13:23:24 Data req vs. avail, 34432, 137948088
> 13:23:24 Sys req vs. avail, 183105, 32618500
> 13:23:24 DisplaySystemPreReq
> 13:23:24 [SetupTypeSQL]
> 13:23:24 szDir = C:\Program Files\Microsoft SQL Server
> 13:23:24 szDir = C:\Program Files\Microsoft SQL Server
> 13:23:24 Result = 301
> 13:23:24 szDataDir = D:\Program Files\Microsoft SQL Server
> 13:23:24 szDataDir = D:\Program Files\Microsoft SQL Server
> 13:23:24 End Action: Setup Type
> 13:23:24 Setup Type: Typical (301)
> 13:23:24 End Action DialogShowSdSetupType
> 13:23:24 begin ShowDialogsUpdateMask
> 13:23:24 nFullMask = 0x1bffc037, nCurrent = 0x100000,
> nDirection = 301
> 13:23:24 Updated Dialog Mask: 0x1bdfc037, Disable Back =
> 0x1
> 13:23:24 Dialog 0x100000 returned: 301
> 13:23:24 End Action ShowDialogsHlpr
> 13:23:24 ShowDialogsGetDialog returned:
> nCurrent=0x400000,index=22
> 13:23:24 Begin Action ShowDialogsHlpr: 0x400000
> 13:23:24 Begin Action: DlgServices
> 13:23:34 ShowDlgServices returned: 1
> 13:23:34 [DlgServices]
> 13:23:34 Local-Domain = 61680
> 13:23:34 AutoStart = 0
> 13:23:34 SQLDomain = AVL-CWP
> 13:23:34 SQLDomainAcct = _sqlmanager
> 13:23:34 SQLDomainPwd
> 13:23:34 AgtDomain = AVL-CWP
> 13:23:34 AgtDomainAcct = _sqlmanager
> 13:23:34 AgtDomainPwd
> 13:23:34 Result = 1
> 13:23:34 End Action DlgServices
> 13:23:34 begin ShowDialogsUpdateMask
> 13:23:34 nFullMask = 0x1bdfc037, nCurrent = 0x400000,
> nDirection = 1
> 13:23:34 Updated Dialog Mask: 0x1bdfc037, Disable Back =
> 0x1
> 13:23:34 Dialog 0x400000 returned: 1
> 13:23:34 End Action ShowDialogsHlpr
> 13:23:34 ShowDialogsGetDialog returned:
> nCurrent=0x800000,index=23
> 13:23:34 Begin Action ShowDialogsHlpr: 0x800000
> 13:23:34 Begin Action: DlgSQLSecurity
> 13:23:35 ShowDlgSQLSecurity returned: 1
> 13:23:35 LoginMode = 1,szPwd
> 13:23:35 End Action DlgSQLSecurity
> 13:23:35 begin ShowDialogsUpdateMask
> 13:23:35 nFullMask = 0x1bdfc037, nCurrent = 0x800000,
> nDirection = 1
> 13:23:35 Updated Dialog Mask: 0x1bdfc037, Disable Back =
> 0x1
> 13:23:35 Dialog 0x800000 returned: 1
> 13:23:35 End Action ShowDialogsHlpr
> 13:23:35 ShowDialogsGetDialog returned:
> nCurrent=0x1000000,index=24
> 13:23:35 Begin Action ShowDialogsHlpr: 0x1000000
> 13:23:35 Begin Action: DlgCollation
> 13:23:40 ShowDlgCollation returned: 1
> 13:23:40 collation_name =
> SQL_Latin1_General_CP1_CI_AS,locale_name =
> Latin1_General,lcid = 0x409,SortId = 52,dwCompFlags =
> 0x30001
> 13:23:40 End Action DlgCollation
> 13:23:40 begin ShowDialogsUpdateMask
> 13:23:40 nFullMask = 0x1bdfc037, nCurrent = 0x1000000,
> nDirection = 1
> 13:23:40 Updated Dialog Mask: 0x1bdfc037, Disable Back =
> 0x1
> 13:23:40 Dialog 0x1000000 returned: 1
> 13:23:40 End Action ShowDialogsHlpr
> 13:23:40 ShowDialogsGetDialog returned:
> nCurrent=0x2000000,index=25
> 13:23:40 Begin Action ShowDialogsHlpr: 0x2000000
> 13:23:40 Begin Action: DlgNetwork
> 13:23:40 ShowDlgNetwork returned: 1
> 13:23:40 [DlgServerNetwork]
> 13:23:40 NetworkLibs = 255
> 13:23:40 TCPPort = 1433
> 13:23:40 TCPPrxy = Default
> 13:23:40 NMPPipeName = \\.\pipe\sql\query
> 13:23:40 Result = 1
> 13:23:40 End Action DlgNetwork
> 13:23:40 begin ShowDialogsUpdateMask
> 13:23:40 nFullMask = 0x1bdfc037, nCurrent = 0x2000000,
> nDirection = 1
> 13:23:40 Updated Dialog Mask: 0x1bdfc037, Disable Back =
> 0x1
> 13:23:40 Dialog 0x2000000 returned: 1
> 13:23:40 End Action ShowDialogsHlpr
> 13:23:40 ShowDialogsGetDialog returned:
> nCurrent=0x8000000,index=27
> 13:23:40 Begin Action ShowDialogsHlpr: 0x8000000
> 13:23:40 Begin Action: DialogShowSdStartCopy
> 13:23:41 End Action DialogShowSdStartCopy
> 13:23:41 begin ShowDialogsUpdateMask
> 13:23:41 nFullMask = 0x1bdfc037, nCurrent = 0x8000000,
> nDirection = 1
> 13:23:41 Updated Dialog Mask: 0x1bdfc037, Disable Back =
> 0x1
> 13:23:41 Dialog 0x8000000 returned: 1
> 13:23:41 End Action ShowDialogsHlpr
> 13:23:41 ShowDialogsGetDialog returned:
> nCurrent=0x10000000,index=28
> 13:23:41 Begin Action ShowDialogsHlpr: 0x10000000
> 13:23:41 Begin Action: DialogShowSdLicenseMode
> 13:23:45 ShowDlgLicense returned: 1
> 13:23:45 ShowDlgLicense returned: LicenseMode = 0,
> LicenseLimit = 2
> 13:23:45 End Action DialogShowSdLicenseMode
> 13:23:45 Dialog 0x10000000 returned: 1
> 13:23:45 End Action ShowDialogsHlpr
> 13:23:45 ShowDialogsGetDialog returned:
> nCurrent=0x0,index=0
> 13:23:45 End Action ShowDialogs
> 13:23:45 Setup is installing Microsoft Distributed
> Transaction Coordinator (MSDTC) ...
> 13:23:45 C:\WINDOWS\TEMP\SqlSetup\Bin\cldtcstp.exe -
> SupportDir "C:\WINDOWS\TEMP\SqlSetup\Bin" -DTCPkg "E:\x86
> \Other\dtcsetup.exe" -LogFile "C:\WINDOWS\sqlstp.log" -
> CtxAcct "AVL-CWP\Administrator" -CtxEPwd
> 13:23:47 Process Exit Code: (0)
> 13:23:47 Begin Action : ClusterSetupHelper
> 13:23:47 Begin Action : CreateClustISSFiles
> 13:23:47 End Action : CreateClustISSFiles
> 13:23:47 Begin Action : ClusterWriteRemIni
> 13:23:47 End Action : ClusterWriteRemIni
> 13:23:47 Begin Action : Run setup on cluster nodes
> [args]
> NumRemoteServers=2
> Server.1=AVLNODO1
> Server.2=AVLNODO2
> [Server.1]
> NumRemoteServices=1
> 1.app=\\AVLNODO1\E$\x86\setup\setupsql.exe
> 1.server=AVLNODO1
> 1.script=\\AVLNODO1\admin$\AVLNODO1_MSSQLSERVER.is s
> 1.cmdlineformat=%s k=Nb k=Rm k=Cl -SMS -s -f "\\AVLNODO1
> \E$\x86\setup\setup.ins" -f1 %s -f2 "\\AVLNODO1
> \admin$\setup.log" -e "stpsilnt._ex" -b -
> x "C:\WINDOWS\TEMP\"
> 1.user=AVL-CWP\Administrator
> 1.password=095c53b158d550021ef0
> 1.name=SQLSetup1
> 1.sqlsetup=Y
> 1.copyexe=cnvsvc1.exe
> [Server.2]
> NumRemoteServices=1
> 1.app=\\AVLNODO1\E$\x86\setup\setupsql.exe
> 1.server=AVLNODO2
> 1.script=\\AVLNODO1\admin$\AVLNODO2_MSSQLSERVER.is s
> 1.cmdlineformat=%s k=ClSec k=Rm k=Cl -SMS -s -f "\\AVLNODO1
> \E$\x86\setup\setup.ins" -f1 %s -f2 "\\AVLNODO2
> \admin$\setup.log" -e "stpsilnt._ex" -x "C:\"
> 1.user=AVL-CWP\Administrator
> 1.password=095c53b158d550021ef0
> 1.name=SQLSetup2
> 1.sqlsetup=Y
> 1.copyexe=cnvsvc2.exe
> 13:23:48 Setup is performing required operations on
> cluster nodes. This may take a few minutes...
> 13:23:48 C:\WINDOWS\TEMP\SqlSetup\Bin\remsetup.exe
> C:\WINDOWS\remsetup.ini
> 13:25:06 Process Exit Code: (2) The system cannot find the
> file specified.
> 13:25:06 Begin Action : GetRemsetupRetCode
> 13:25:06 Installation return status on AVLNODO1 : 2
> 13:25:06 Installation return status on AVLNODO2 : 2
> 13:25:06 End Action : GetRemsetupRetCode
> #### SQL Server Remote Setup - Start Time 09/24/04
> 13:23:48 ####
> CThreadPool::RunUntilCompleteHlpr create thread, index=0
> CThread::Run thread [0x64] created for execution.
> CThread::Process [0x64]
> CThreadPool::RunUntilCompleteHlpr create thread, index=1
> Running '\\AVLNODO1\E$\x86\setup\setupsql.exe k=Nb k=Rm
> k=Cl -SMS -s -f "\\AVLNODO1\E$\x86\setup\setup.ins" -f1
> \\AVLNODO1\admin$\AVLNODO1_MSSQLSERVER.iss -f2 "\\AVLNODO1
> \admin$\setup.log" -e "stpsilnt._ex" -b -
> x "C:\WINDOWS\TEMP\"' (AVLNODO1) ...
> CThread::Run thread [0x68] created for execution.
> CThread::Process [0x68]
> CThreadPool::RunUntilCompleteHlpr start thread
> [0x64],index=0
> CThreadPool::RunUntilCompleteHlpr start thread
> [0x68],index=1
> Script file copied to '\\AVLNODO2
> \ADMIN$\AVLNODO2_MSSQLSERVER.iss' successfully.
> Installing remote service (AVLNODO2)...
> Running '\\AVLNODO1\E$\x86\setup\setupsql.exe k=ClSec k=Rm
> k=Cl -SMS -s -f "\\AVLNODO1\E$\x86\setup\setup.ins" -f1
> \\AVLNODO2\ADMIN$\AVLNODO2_MSSQLSERVER.iss -f2 "\\AVLNODO2
> \admin$\setup.log" -e "stpsilnt._ex" -x "C:\"'
> (AVLNODO2) ...
> CProcess::RunUntilComplete [0x64] exit code: 2
> Remote process exit code was '2' (AVLNODO1).
> CThreadPool::RunUntilCompleteHlpr WaitForMultipleObjects
> returned: 0
> CThreadPool::RunUntilCompleteHlpr signaled thread [0x64]
> Thread [0x64] exit code: [0x2]
> CRemoteProcess::RunUntilComplete [0x68] exit code: 2
> Remote process exit code was '2' (AVLNODO2).
> CThreadPool::RunUntilCompleteHlpr WaitForMultipleObjects
> returned: 2
> CThreadPool::RunUntilCompleteHlpr signaled thread [0x68]
> Thread [0x68] exit code: [0x2]
> CThreadPool::RunUntilComplete returned 2
> CThreadPool::RunUntilComplete execution level=1, need
> execution: 0
> One or more errors occurred while running the
> remote/unattended setups.
> Disconnecting from remote machine (AVLNODO1)...
> Service removed successfully.
> Remote files could not be removed.
> #### SQL Server Remote Setup - Stop Time 09/24/04 13:24:49
> ####
> Disconnecting from remote machine (AVLNODO2)...
> Service removed successfully.
> Remote files removed successfully.
> #### SQL Server Remote Setup - Stop Time 09/24/04 13:25:06
> ####
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> 13:25:06 End Action : Run setup on cluster nodes
> 13:25:06 One or more errors occurred while running remote
> setup on the clustered machines.
> 13:28:20 Setup failed to perform required operations on
> the cluster nodes.
> 13:28:20 Begin Action : ClusterErrorCleanup
> 13:28:20 End Action : ClusterErrorCleanup
> 13:28:20 End Action : ClusterSetupHelper
>
> Any idea?
>
|||From the sqlstp.log it is clear that the unattended installation on both the nodes failed with return code 2

> 13:25:06 Installation return status on AVLNODO1 : 2
> 13:25:06 Installation return status on AVLNODO2 : 2
Error code 2 ==> "The system cannot find the file specified."
Next step will be to go the AVLNODO1 and AVLNODO1 and review the sqlstpN.log where N is an integer.
Cut and paste the sqlstpN.log if you need more help.
Additional Information:
Troubleshooting SQL 2000 Virtual Server and Service Pack Setups for Failover Clustering
http://support.microsoft.com/default...lurb020703.asp
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

Problem inserting Now() into a datetime field

Hi

I am trying to insert value retrieved from Now() into a datetime field in my MSDE database, but I am getting the following error, and I have no idea what is going wrong.

Arithmetic overflow error converting expression to data type datetime.
The statement has been terminated.

Here is the code I am using:

Dim user As String = MyContext.User.Identity.Name.ToString
Dim TimeDate As DateTime = Now()
Dim status As String = "Pending"

With SqlOrders.InsertParameters
.Item("UserName").DefaultValue = user
.Item("OrderDate").DefaultValue = TimeDate
.Item("Status").DefaultValue = status
End With
SqlOrders.Insert()

The date is being returned in this format23/03/2006 02:01:52, which is the same format as it should appear in the database.

could anyone please tell me where I am going wrong?
Datetimes don't have a format. Varchar/strings that represent a datetime have a format. Make sure your OrderDate parameter is set to a datetime datatype, and your problem should go away, probably.|||Thankyou, I added .Item("OrderDate").Type = TypeCode.DateTime and it works fine now :)