Clearing LOG Files: encountered

Showing posts with label encountered. Show all posts

Sunday, March 25, 2012

cluster installing also have some errors

When i tried to install a virtue sql server on just one node(the other was
evicted and shutdown), i also encountered the same errors just as before.
So i'm confused.
I have read a lot of docs about sql cluster, and most of them told me that
it's simple to install sql cluster after the mscs and msdtc r installed.
hp proliant dl580+ raid array 4100 / 2 xeon cpus(so the hypethreading may
appear 4 cups and i have tried 2-cpu licence and 4-cpu licence, both fails)
win2k ad
Thanks
"Rand Boyd [MSFT]" <rboyd@.onlinemicrosoft.com> д?
news:6kS2Lo%23REHA.2260@.cpmsftngxa10.phx.gbl...
> There should be other sqlstp.logs on the systems. Possibly SQLstp0.log.
> Each node should have one. If you can post these we can get a better idea
> of what went wrong.
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
>
"Sanjoy Wong" <sanjoy@.sinolines.com> д?
news:uEqMA4JSEHA.628@.TK2MSFTNGP11.phx.gbl...
> When i tried to install a virtue sql server on just one node(the other was
> evicted and shutdown), i also encountered the same errors just as before.
> So i'm confused.
> I have read a lot of docs about sql cluster, and most of them told me that
> it's simple to install sql cluster after the mscs and msdtc r installed.
> hp proliant dl580+ raid array 4100 / 2 xeon cpus(so the hypethreading may
> appear 4 cups and i have tried 2-cpu licence and 4-cpu licence, both
fails)[vbcol=seagreen]
> win2k ad
>
> Thanks
> "Rand Boyd [MSFT]" <rboyd@.onlinemicrosoft.com> д?
> news:6kS2Lo%23REHA.2260@.cpmsftngxa10.phx.gbl...
idea[vbcol=seagreen]
rights.
>
begin 666 sqlstp.log
M,C Z,3 Z,3<@.0F5G:6X@.4V5T=7 -"C(P.C$P.C$W(#@.N,# N,3DT#0HR,#HQ
M,#HQ-R!-;V1E(#T@.3F]R;6%L#0HR,#HQ,#HQ-R!-;V1E5'EP92 ]($Y/4DU!
M3 T*,C Z,3 Z,3@.@.1V5T1&5F:6YI=&EO;D5X(')E='5R;F5D.B P+"!%>'1E
M;F1E9#H@.,'@.P#0HR,#HQ,#HQ."!686QU94944R!R971U<FYE9 #H@.,0T*,C Z
M,3 Z,3@.@.5F%L=650240@.<F5T=7)N960Z(#$-"C(P.C$P.C$X(%9A;'5E3&EC
M(')E='5R;F5D.B Q#0HR,#HQ,#HQ."!3>7-T96TZ(%=I;F1O=W,@.3E0@.16YT
M97)P<FES92!397)V97(-"C(P.C$P.C$X(%-13"!397)V97(@.4')O9'5C=%1Y
M<&4Z($5N=&5R<')I<V4@.161I=&EO;B!;,'@.S70T*,C Z,3 Z,3@.@.27-.5$-L
M=7-T97(@.<F5T=7)N960Z(#$-"C(P.C$P.C$X($)E9VEN($%C=&EO;CH@.4V5T
M=7!);FET:6%L:7IE( T*,C Z,3 Z,3@.@.16YD($%C=&EO;B!3971U<$EN:71I
M86QI>F4-"C(P.C$P.C$X($)E9VEN($%C=&EO;CH@.(%-E='5P26YS=&%L; T*
M,C Z,3 Z,3@.@.4F5A9&EN9R!3;V9T=V%R95Q-:6-R;W-O9G1<5VEN9&]W<UQ#
M=7)R96YT5F5R<VEO;EQ#;VUM;VY&:6QE<T1I<B N+BX-"C(P.C$P.C$X($-O
M;6UO;D9I;&5S1&ER/4,Z7%!R;V=R86T@.1FEL97-<0V]M;6]N($9I;&5S#0HR
M,#HQ,#HQ."!7:6YD;W=S($1I<F5C=&]R>3U#.EQ724Y.5%P-"C(P.C$P.C$X
M(%!R;V=R86T@.1FEL97,]0SI<4')O9W)A;2!&:6QE<UP-"C(P.C$P.C$X(%1%
M35!$25(]0SI<5TE.3E1<5$5-4%P-"C(P.C$P.C$X($)E9VEN($%C=&EO;CH@.
M(%-E='5P26YS=&%L; T*,C Z,3 Z,3@.@.9&EG<&ED('-I>F4@..B R-38-"C(P
M.C$P.C$X(&1I9W!I9"!S:7IE(#H@.,38T#0HR,#HQ,#HQ."!"9 6=I;B!!8W1I
M;VXZ("!#:&5C:T9I>&5D4F5Q=6ER96UE;G1S#0HR,#HQ,#HQ. "!0;&%T9F]R
M;2!)1#H@.,'AF,# P,# -"C(P.C$P.C$X(%9E<G-I;VXZ(#4N,"XR,3DU#0HR
M,#HQ,#HQ."!&:6QE(%9E<G-I;VX@.+2!#.EQ724Y.5%QS>7-T96TS,EQS:&1O
M8W9W+F1L;#H@.-2XP+C,W,# N-C8V. T*,C Z,3 Z,3@.@.16YD($%C=&EO;CH@.
M($-H96-K1FEX961297%U:7)E;65N=',-"C(P.C$P.C$X($)E9VEN($%C=&EO
M;CH@.(%-H;W=$:6%L;V=S#0HR,#HQ,#HQ."!);FET:6%L($1I86QO9R!-87-K
M.B P>#$X,S P,&8W+"!$:7-A8FQE($)A8VL],'@.Q#0HR,#HQ,#HQ."!"96=I
M;B!!8W1I;VX@.4VAO=T1I86QO9W-(;'!R.B P>#$-"C(P.C$P.C$X($)E9VEN
M($%C=&EO;CH@.($1I86QO9U-H;W=39%=E;&-O;64-"C(P.C$P.C$Y($5N9"!!
M8W1I;VX@.($1I86QO9U-H;W=39%=E;&-O;64-"C(P.C$P.C$Y($1I86QO9R P
M>#$@.<F5T=7)N960Z(#$-"C(P.C$P.C$Y($5N9"!!8W1I;VX@.4VAO=T1I86QO
M9W-(;'!R#0HR,#HQ,#HQ.2!3:&]W1&EA;&]G<T=E=$1I86QO9R!R971U<FYE
M9#H@.;D-U<G)E;G0],'@.R+&EN9&5X/3$-"C(P.C$P.C$Y($)E9VEN($%C=&EO
M;B!3:&]W1&EA;&]G<TAL<'(Z(#!X,@.T*,C Z,3 Z,3D@.0F5G:6X@.06-T:6]N
M.B @.1&EA;&]G4VAO=U-D36%C:&EN94YA;64-"C(P.C$P.C(V(%-H;W=$;&=-
M86-H:6YE(')E='5R;F5D.B Q#0HR,#HQ,#HR-B!.86UE(#T@.4U%,5$535"P@.
M5'EP92 ](#!X,3 P,# P,#@.-"C(P.C$P.C(V($)E9VEN($%C=&EO;CH@.($-H
M96-K4F5Q=6ER96UE;G1S#0HR,#HQ,#HR-B!0<F]C97-S;W(@.07)C:&ET96-T
M=7)E.B!X.#8@.*%!E;G1I=6TI#0HR,#HQ,#HR-B!397)V:6-E(%!A8VLZ(" Q
M,#(T#0HR,#HQ,#HR-B!#;VUP=71E<DYA;64Z($$-"C(P.C$P.C(V(%5S97(@.
M3F%M93H@.061M:6YI<W1R871O<@.T*,C Z,3 Z,C8@.27-!;&Q!8V-E<W-!;&QO
M=V5D(')E='5R;F5D.B Q#0HR,#HQ,#HR-B!/4R!,86YG=6%G93H@.,'@.X,#0-
M"C(P.C$P.C(V($5N9"!!8W1I;VX@.0VAE8VM297%U:7)E;65N= ',-"C(P.C$P
M.C(V(%1H:7,@.8V]M8FEN871I;VX@.;V8@.4&%C:V%G92!A;F0@.3W!E<F%T:6YG
M(%-Y<W1E;2!A;&QO=W,@.82!F=6QL('!R;V1U8W0@.:6YS=&%L;"X-"C(P.C$P
M.C(V($5N9"!!8W1I;VX@.($1I86QO9U-H;W=39$UA8VAI;F5.86UE#0HR,#HQ
M,#HR-B!B96=I;B!3:&]W1&EA;&]G<U5P9&%T94UA<VL-"C(P.C$P.C(V(&Y&
M=6QL36%S:R ](#!X,3@.S,# P9C<L(&Y#=7)R96YT(#T@.,'@.R+"!N1&ER96-T
M:6]N(#T@., T*,C Z,3 Z,C8@.57!D871E9"!$:6%L;V<@.36%S:SH@.,'AB9C-C
M,#,W+"!$:7-A8FQE($)A8VL@./2 P>#$-"C(P.C$P.C(V($1I86QO9R P>#(@.
M<F5T=7)N960Z(# -"C(P.C$P.C(V($5N9"!!8W1I;VX@.4VAO=T1I86QO9W-(
M;'!R#0HR,#HQ,#HR-B!3:&]W1&EA;&]G<T=E=$1I86QO9R!R971U<FYE9#H@.
M;D-U<G)E;G0],'@.T+&EN9&5X/3(-"C(P.C$P.C(V($)E9VEN($%C=&EO;B!3
M:&]W1&EA;&]G<TAL<'(Z(#!X- T*,C Z,3 Z,C8@.0F5G:6X@.06-T:6]N.B @.
M1&EA;&]G4VAO=U-D26YS=&%L;$UO9&4-"C(P.C$P.C(V($EN<W1A;&Q-;V1E
M(#H@.,'@.Q#0HR,#HQ,#HR-B!%;F0@.06-T:6]N("!$:6%L;V=3:&]W4V1);G-T
M86QL36]D90T*,C Z,3 Z,C8@.8F5G:6X@.4VAO=T1I86QO9W-5<&1A=&5-87-K
M#0HR,#HQ,#HR-B!N1G5L;$UA<VL@./2 P>&)F,V,P,S<L(&Y#=7)R96YT(#T@.
M,'@.T+"!N1&ER96-T:6]N(#T@.,0T*,C Z,3 Z,C8@.57!D871E9"!$:6%L;V<@.
M36%S:SH@.,'@.Q8F8W8S S-RP@.1&ES86)L92!"86-K(#T@.,'@.Q#0HR,#HQ,#HR
M-B!$:6%L;V<@.,'@.T(')E='5R;F5D.B Q#0HR,#HQ,#HR-B!%;F0@.06-T:6]N
M(%-H;W=$:6%L;V=S2&QP<@.T*,C Z,3 Z,C8@.4VAO=T1I86QO9W-'971$:6%L
M;V<@.<F5T=7)N960Z(&Y#=7)R96YT/3!X,3 L:6YD97@.]- T*,C Z,3 Z,C8@.
M0F5G:6X@.06-T:6]N(%-H;W=$:6%L;V=S2&QP<CH@.,'@.Q, T*,C Z,3 Z,C8@.
M0F5G:6X@.06-T:6]N.B @.1&EA;&]G4VAO=U-D4F5G:7-T97)5<V5R17@.-"C(P
M.C$P.C(W($5N9"!!8W1I;VX@.1&EA;&]G4VAO=U-D4F5G:7-T97)5<V5R17@.-
M"C(P.C$P.C(W(&)E9VEN(%-H;W=$:6%L;V=S57!D871E36%S:PT*,C Z,3 Z
M,C<@.;D9U;&Q-87-K(#T@.,'@.Q8F8W8S S-RP@.;D-U<G)E;G0@./2 P>#$P+"!N
M1&ER96-T:6]N(#T@.,0T*,C Z,3 Z,C<@.57!D871E9"!$:6%L;V<@.36%S:SH@.
M,'@.Q8F8W8S S-RP@.1&ES86)L92!"86-K(#T@.,'@.Q#0HR,#HQ,#HR-R!$:6%L
M;V<@.,'@.Q,"!R971U<FYE9#H@.,0T*,C Z,3 Z,C<@.16YD($%C=&EO;B!3:&]W
M1&EA;&]G<TAL<'(-"C(P.C$P.C(W(%-H;W=$:6%L;V=S1V5T1&EA;&]G(')E
M='5R;F5D.B!N0W5R<F5N=#TP>#(P+&EN9&5X/34-"C(P.C$P.C(W($)E9VEN
M($%C=&EO;B!3:&]W1&EA;&]G<TAL<'(Z(#!X,C -"C(P.C$P.C(W($)E9VEN
M($%C=&EO;CH@.($1I86QO9U-H;W=39$QI8V5N<V4-"C(P.C$P.C(X($5N9"!!
M8W1I;VX@.1&EA;&]G4VAO=U-D3&EC96YS90T*,C Z,3 Z,C@.@.1&EA;&]G(#!X
M,C @.<F5T=7)N960Z(#$-"C(P.C$P.C(X($5N9"!!8W1I;VX@.4VAO=T1I86QO
M9W-(;'!R#0HR,#HQ,#HR."!3:&]W1&EA;&]G<T=E=$1I86QO9R!R971U<FYE
M9#H@.;D-U<G)E;G0],'@.T,# P+&EN9&5X/3$T#0HR,#HQ,#HR."!"96=I;B!!
M8W1I;VX@.4VAO=T1I86QO9W-(;'!R.B P>#0P,# -"C(P.C$P.C(X($)E9VEN
M($%C=&EO;CH@.($1I86QO9U-H;W=39%9I<G1U86Q397)V97(-"C(P.C$P.C0W
M(%-H;W=$;&=6:7)T=6%L4V5R=F5R(')E='5R;F5D.B P#0HR,#HQ,#HT-R!)
M<&%D9')E<W,@./2 Q.3(N,38X+C N,C$P+#(U-2XR-34N,C4U+C L<'5B;&EC
M#0HR,#HQ,#HT-R!S>DYE=TQI<W0@./2 Q.3(N,38X+C N,C$P+#(U-2XR-34N
M,C4U+C L<'5B;&EC#0HR,#HQ,#HT-R!S>DUO9&EF:65D3&ES=" ]( T*,C Z
M,3 Z-#<@.<WI296UO=F5D3&ES=" ]( T*,C Z,3 Z-#<@.16YD($%C=&EO;B @.
M1&EA;&]G4VAO=U-D5FER='5A;%-E<G9E<@.T*,C Z,3 Z-#<@.8F5G:6X@.4VAO
M=T1I86QO9W-5<&1A=&5-87-K#0HR,#HQ,#HT-R!N1G5L;$UA<VL@./2 P>#%B
M9C=C,#,W+"!N0W5R<F5N=" ](#!X-# P,"P@.;D1I<F5C=&EO;B ](#$-"C(P
M.C$P.C0W(%5P9&%T960@.1&EA;&]G($UA<VLZ(#!X,6)F-V,P,S<L($1I<V%B
M;&4@.0F%C:R ](#!X,0T*,C Z,3 Z-#<@.1&EA;&]G(#!X-# P,"!R971U<FYE
M9#H@.,0T*,C Z,3 Z-#<@.16YD($%C=&EO;B!3:&]W1&EA;&]G<TAL<'(-"C(P
M.C$P.C0W(%-H;W=$:6%L;V=S1V5T1&EA;&]G(')E='5R;F5D.B!N0W5R<F5N
M=#TP>#@.P,# L:6YD97@.],34-"C(P.C$P.C0W($)E9VEN($%C=&EO;B!3:&]W
M1&EA;&]G<TAL<'(Z(#!X.# P, T*,C Z,3 Z-#<@.0F5G:6X@.06-T:6]N(#H@.
M($1I86QO9U-H;W=39$1I<VM'<F]U<',-"C(P.C$P.C4P(%-H;W=$;&=$:7-K
M1W)O=7!S(')E='5R;F5D.B Q#0HR,#HQ,#HU,"!$:7-K($=R;W5P(#T@.1&ES
M:R!'<F]U<" Q#0HR,#HQ,#HU,"!%;F0@.06-T:6]N(#H@.($1I86QO9U-H;W=3
M9$1I<VM'<F]U<',-"C(P.C$P.C4P(&)E9VEN(%-H;W=$:6%L;V=S57!D871E
M36%S:PT*,C Z,3 Z-3 @.;D9U;&Q-87-K(#T@.,'@.Q8F8W8S S-RP@.;D-U<G)E
M;G0@./2 P>#@.P,# L(&Y$:7)E8W1I;VX@./2 Q#0HR,#HQ,#HU,"!5<&1A=&5D
M($1I86QO9R!-87-K.B P>#%B9C=C,#,W+"!$:7-A8FQE($)A8VL@./2 P>#$-
M"C(P.C$P.C4P($1I86QO9R P>#@.P,# @.<F5T=7)N960Z(#$-"C(P.C$P.C4P
M($5N9"!!8W1I;VX@.4VAO=T1I86QO9W-(;'!R#0HR,#HQ,#HU,"!3:&]W1&EA
M;&]G<T=E=$1I86QO9R!R971U<FYE9#H@.;D-U<G)E;G0],'@.Q,# P,"QI;F1E
M>#TQ-@.T*,C Z,3 Z-3 @.0F5G:6X@.06-T:6]N(%-H;W=$:6%L;V=S2&QP<CH@.
M,'@.Q,# P, T*,C Z,3 Z-3 @.0F5G:6X@.06-T:6]N.B @.1&EA;&]G4VAO=U-D
M0VQU<W1E<D1E9@.T*,C Z,3 Z-3$@.4VAO=T1L9T-L=7-T97)$968@.<F5T=7)N
M960Z(#$-"C(P.C$P.C4Q(%!R969/=VYE<G,@./2!!+"!.=6U)<" ](#$-"C(P
M.C$P.C4Q($)E9VEN($%C=&EO;B Z(%9A;&ED871E3F]D94%C=&EO;G,-"C(P
M.C$P.C4Q($)E9VEN($%C=&EO;B Z(%9A;&ED871E3F]D94%C=&EO;G,-"C(P
M.C$P.C4Q($5N9"!!8W1I;VX@..B!686QI9&%T94YO9&5!8W1I; VYS#0HR,#HQ
M,#HU,2!%;F0@.06-T:6]N(#H@.5F%L:61A=&5.;V1E06-T:6]N<PT*,C Z,3 Z
M-3$@.16YD($%C=&EO;B @.1&EA;&]G4VAO=U-D0VQU<W1E<D1E9@.T*,C Z,3 Z
M-3$@.8F5G:6X@.4VAO=T1I86QO9W-5<&1A=&5-87-K#0HR,#HQ,#HU,2!N1G5L
M;$UA<VL@./2 P>#%B9C=C,#,W+"!N0W5R<F5N=" ](#!X,3 P,# L(&Y$:7)E
M8W1I;VX@./2 Q#0HR,#HQ,#HU,2!5<&1A=&5D($1I86QO9R!-87-K.B P>#%B
M9C=C,#,W+"!$:7-A8FQE($)A8VL@./2 P>#$-"C(P.C$P.C4Q($1I86QO9R P
M>#$P,# P(')E='5R;F5D.B Q#0HR,#HQ,#HU,2!%;F0@.06-T:6]N(%-H;W=$
M:6%L;V=S2&QP<@.T*,C Z,3 Z-3$@.4VAO=T1I86QO9W-'971$:6%L;V<@.<F5T
M=7)N960Z(&Y#=7)R96YT/3!X,C P,# L:6YD97@.],3<-"C(P.C$P.C4Q($)E
M9VEN($%C=&EO;B!3:&]W1&EA;&]G<TAL<'(Z(#!X,C P,# -"C(P.C$P.C4Q
M($)E9VEN($%C=&EO;B Z($-L=7-T97(@.4V5C=7)I='D@.+2!$;&=!8V-T#0HR
M,#HQ,3HP,B!3:&]W1&QG06-C="!R971U<FYE9#H@.,0T*,C Z,3$Z,#(@.6T1L
M9T%C8V]U;G1=#0HR,#HQ,3HP,B!$;VUA:6X@./2!324Y/3$E.15,-"C(P.C$Q
M.C R($1O;6%I;D%C8W0@./2!C;'5S=&5R#0HR,#HQ,3HP,B!$;VUA:6Y0=V0-
M"C(P.C$Q.C R(%)E<W5L=" ](#$-"C(P.C$Q.C R($5N9"!!8W1I;VX@..B!#
M;'5S=&5R(%-E8W5R:71Y("T@.1&QG06-C= T*,C Z,3$Z,#(@.8F5G:6X@.4VAO
M=T1I86QO9W-5<&1A=&5-87-K#0HR,#HQ,3HP,B!N1G5L;$UA<VL@./2 P>#%B
M9C=C,#,W+"!N0W5R<F5N=" ](#!X,C P,# L(&Y$:7)E8W1I;VX@./2 Q#0HR
M,#HQ,3HP,B!5<&1A=&5D($1I86QO9R!-87-K.B P>#%B9C=C,#,W+"!$:7-A
M8FQE($)A8VL@./2 P>#$-"C(P.C$Q.C R($1I86QO9R P>#(P,# P(')E='5R
M;F5D.B Q#0HR,#HQ,3HP,B!%;F0@.06-T:6]N(%-H;W=$:6%L;V=S2&QP<@.T*
M,C Z,3$Z,#(@.4VAO=T1I86QO9W-'971$:6%L;V<@.<F5T=7)N960Z(&Y#=7)R
M96YT/3!X-# P,# L:6YD97@.],3@.-"C(P.C$Q.C R($)E9VEN($%C=&EO;B!3
M:&]W1&EA;&]G<TAL<'(Z(#!X-# P,# -"C(P.C$Q.C R($)E9VEN($%C=&EO
M;CH@.($1I86QO9U-H;W=39$-L:5-V<@.T*,C Z,3$Z,#(@.1&ES<&QA>5-Y<W1E
M;5!R95)E<0T*,C Z,3$Z,#(@.4VAO=T1L9T-L:65N=%-E<G9E<E-E;&5C="!R
M971U<FYE9#H@.,0T*,C Z,3$Z,#(@.5'EP92 Z(#!X,@.T*,C Z,3$Z,#(@.16YD
M($%C=&EO;B @.1&EA;&]G4VAO=U-D0VQI4W9R#0HR,#HQ,3HP,B!B96=I;B!3
M:&]W1&EA;&]G<U5P9&%T94UA<VL-"C(P.C$Q.C R(&Y&=6QL36%S:R ](#!X
M,6)F-V,P,S<L(&Y#=7)R96YT(#T@.,'@.T,# P,"P@.;D1I<F5C=&EO;B ](#$-
M"C(P.C$Q.C R(%5P9&%T960@.1&EA;&]G($UA<VLZ(#!X,6)F9F,P,S<L($1I
M<V%B;&4@.0F%C:R ](#!X,0T*,C Z,3$Z,#(@.1&EA;&]G(#!X-# P,# @.<F5T
M=7)N960Z(#$-"C(P.C$Q.C R($5N9"!!8W1I;VX@.4VAO=T1I86QO9W-(;'!R
M#0HR,#HQ,3HP,B!3:&]W1&EA;&]G<T=E=$1I86QO9R!R971U<FYE9#H@.;D-U
M<G)E;G0],'@.X,# P,"QI;F1E>#TQ.0T*,C Z,3$Z,#(@.0F5G:6X@.06-T:6]N
M(%-H;W=$:6%L;V=S2&QP<CH@.,'@.X,# P, T*,C Z,3$Z,#(@.0F5G:6X@.06-T
M:6]N.B @.1&EA;&]G4VAO=U-D26YS=&%N8V5.86UE#0HR,#HQ,3HP,B!"96=I
M;B!!8W1I;VXZ(%-H;W=$;&=);G-T86YC94YA;64-"C(P.C$Q.C S($5N9"!!
M8W1I;VXZ(%-H;W=$;&=);G-T86YC94YA;64-"C(P.C$Q.C S(%-H;W=$;&=)
M;G-T86YC94YA;64@.<F5T=7)N960@..B Q#0HR,#HQ,3HP,R!);G-T86YC94YA
M;64@..B!-4U-13%-%4E9%4@.T*,C Z,3$Z,#8@.0W)E871E4V5T=7!4;W!O;&]G
M>2A344Q415-4*2P@.2&%N9&QE(#H@.,'@.Q.3@.T,&8P+"!R971U<FYE9" Z(# -
M"C(P.C$Q.C V($-R96%T95-E='5P5&]P;VQO9WD@.<F5T=7)N960@..B P+"!(
M86YD;&4@..B P>#$Y.#0P9C -"C(P.C$Q.C V(%1O<&]L;V=Y(%1Y<&4@..B S
M-"P@.4F5T=7)N(%9A;'5E(#H@., T*,C Z,3$Z,#8@.4U1?1V5T4&AY<VEC86Q.
M;V1E(')E='5R;F5D(#H@.,"P@.4$Y(86YD;&4@..B P>#$Y.#0Q,3@.-"C(P.C$Q
M.C V(%!.7T5N=6UE<F%T945X(')E='5R;F5D(#H@., T*,C Z,3$Z,#8@.4$Y?
M1V5T4U%,4W1A=&5S(')E='5R;F5D(#H@.,"P@.4W%L4W1A=&5S( #H@.,'@.P#0HR
M,#HQ,3HP-B!03E]3=&%R=%-C86X@.6S!X,3DX-#$Q.%T@.<F5T=7)N960@..B P
M#0HR,#HQ,3HP-B!03E]'971.97AT(%LP>#$Y.#0Q,3A=(')E='5R;F5D(#H@.
M,3@.L($AA;F1L93H@.6S!X,%T-"C(P.C$Q.C V($YO(&UO<F4@.:71E;7,@.:6X@.
M96YU;65R871I;VXN#0HR,#HQ,3HP-B!296QE87-E4V5T=7!4;W!O;&]G>0T*
M,C Z,3$Z,#8@.16YD($%C=&EO;B @.1&EA;&]G4VAO=U-D26YS=&%N8V5.86UE
M#0HR,#HQ,3HP-B!B96=I;B!3:&]W1&EA;&]G<U5P9&%T94UA<VL-"C(P.C$Q
M.C V(&Y&=6QL36%S:R ](#!X,6)F9F,P,S<L(&Y#=7)R96YT(#T@.,'@.X,# P
M,"P@.;D1I<F5C=&EO;B ](#$-"C(P.C$Q.C V(%5P9&%T960@.1&EA;&]G($UA
M<VLZ(#!X,6)F9F,P,S<L($1I<V%B;&4@.0F%C:R ](#!X,0T*,C Z,3$Z,#8@.
M1&EA;&]G(#!X.# P,# @.<F5T=7)N960Z(#$-"C(P.C$Q.C V($5N9"!!8W1I
M;VX@.4VAO=T1I86QO9W-(;'!R#0HR,#HQ,3HP-B!3:&]W1&EA;&]G<T=E=$1I
M86QO9R!R971U<FYE9#H@.;D-U<G)E;G0],'@.Q,# P,# L:6YD97@.],C -"C(P
M.C$Q.C V($)E9VEN($%C=&EO;B!3:&]W1&EA;&]G<TAL<'(Z(#!X,3 P,# P
M#0HR,#HQ,3HP-B!"96=I;B!!8W1I;VXZ("!$:6%L;V=3:&]W4V13971U<%1Y
M<&4-"C(P.C$Q.C V($)E9VEN($%C=&EO;CH@.4V5T=7 @.5'EP90T*,C Z,3$Z
M,#<@.4U%,('!R;V=R86T@.9F]L9&5R.B!#.EQ0<F]G<F%M($9I;&5S7$UI8W)O
M<V]F="!344P@.4V5R=F5R#0HR,#HQ,3HP-R!344P@.9&%T82!F;VQD97(Z(%HZ
M7%!R;V=R86T@.1FEL97-<36EC<F]S;V9T(%-13"!397)V97(-"C(P.C$Q.C W
M(%=I;F1O=W,@.<WES=&5M(&9O;&1E<CH@.0SI<5TE.3E1<<WES= &5M,S)<#0HR
M,#HQ,3HP-R!0<F]G(')E<3H@.,S@.R,#4L($1A=&$@.<F5Q.B S-C4T-"P@.4WES
M(')E<3H@.,3DS-3<Y#0HR,#HQ,3HP-R!0<F]G(&%V86EL.B Q,C T,34U-BP@.
M1&%T82!A=F%I;#H@.,30R,3@.U,3DV+"!3>7,@.879A:6PZ(#$R, #0Q-34V#0HR
M,#HQ,3HP-R!0<F]G(')E<2!V<RX@.879A:6PL(#(S,3<X-"P@.,3(P-#$U-38-
M"C(P.C$Q.C W($1A=&$@.<F5Q('9S+B!A=F%I;"P@.,S8U-#0L(#$T,C$X-3$Y
M-@.T*,C Z,3$Z,#<@.4WES(')E<2!V<RX@.879A:6PL(#$Y,S4W.2P@.,3(P-#$U
M-38-"C(P.C$Q.C W($1I<W!L87E3>7-T96U0<F5297$-"C(P.C$Q.C W(%M3
M971U<%1Y<&5344Q=#0HR,#HQ,3HP-R!S>D1I<B ]($,Z7%!R;V=R86T@.1FEL
M97-<36EC<F]S;V9T(%-13"!397)V97(-"C(P.C$Q.C W('-Z1&ER(#T@.0SI<
M4')O9W)A;2!&:6QE<UQ-:6-R;W-O9G0@.4U%,(%-E<G9E<@.T*,C Z,3$Z,#<@.
M4F5S=6QT(#T@.,S Q#0HR,#HQ,3HP-R!S>D1A=&%$:7(@./2!:.EQ0<F]G<F%M
M($9I;&5S7$UI8W)O<V]F="!344P@.4V5R=F5R#0HR,#HQ,3HP-R!S>D1A=&%$
M:7(@./2!:.EQ0<F]G<F%M($9I;&5S7$UI8W)O<V]F="!344P@.4V5R=F5R#0HR
M,#HQ,3HP-R!%;F0@.06-T:6]N.B!3971U<"!4>7!E#0HR,#HQ,3HP-R!3971U
M<"!4>7!E.B!4>7!I8V%L("@.S,#$I#0HR,#HQ,3HP-R!%;F0@.06-T:6]N("!$
M:6%L;V=3:&]W4V13971U<%1Y<&4-"C(P.C$Q.C W(&)E9VEN(%-H;W=$:6%L
M;V=S57!D871E36%S:PT*,C Z,3$Z,#<@.;D9U;&Q-87-K(#T@.,'@.Q8F9F8S S
M-RP@.;D-U<G)E;G0@./2 P>#$P,# P,"P@.;D1I<F5C=&EO;B ](#,P,0T*,C Z
M,3$Z,#<@.57!D871E9"!$:6%L;V<@.36%S:SH@.,'@.Q8F1F8S S-RP@.1&ES86)L
M92!"86-K(#T@.,'@.Q#0HR,#HQ,3HP-R!$:6%L;V<@.,'@.Q,# P,# @.<F5T=7)N
M960Z(#,P,0T*,C Z,3$Z,#<@.16YD($%C=&EO;B!3:&]W1&EA;&]G<TAL<'(-
M"C(P.C$Q.C W(%-H;W=$:6%L;V=S1V5T1&EA;&]G(')E='5R;F5D.B!N0W5R
M<F5N=#TP>#0P,# P,"QI;F1E>#TR,@.T*,C Z,3$Z,#<@.0F5G:6X@.06-T:6]N
M(%-H;W=$:6%L;V=S2&QP<CH@.,'@.T,# P,# -"C(P.C$Q.C W($)E9VEN($%C
M=&EO;CH@.($1L9U-E<G9I8V5S#0HR,#HQ,3HQ-R!3:&]W1&QG4V5R=FEC97,@.
M<F5T=7)N960Z(#$-"C(P.C$Q.C$W(%M$;&=397)V:6-E<UT-"C(P.C$Q.C$W
M($QO8V%L+41O;6%I;@.D](#8Q-C@.P#0HR,#HQ,3HQ-R!!=71O4W1A<G0)"3T@.
M, T*,C Z,3$Z,3<@.4U%,1&]M86EN"0D](%-)3D],24Y%4PT*,C Z,3$Z,3<@.
M4U%,1&]M86EN06-C= D](&-L=7-T97(-"C(P.C$Q.C$W(%-13$1O;6%I;E!W
M9 T*,C Z,3$Z,3<@.06=T1&]M86EN"0D](%-)3D],24Y%4PT*,C Z,3$Z,3<@.
M06=T1&]M86EN06-C= D](&-L=7-T97(-"C(P.C$Q.C$W($%G=$1O;6%I;E!W
M9 T*,C Z,3$Z,3<@.4F5S=6QT"3T@.,0T*,C Z,3$Z,3<@.16YD($%C=&EO;B!$
M;&=397)V:6-E<PT*,C Z,3$Z,3<@.8F5G:6X@.4VAO=T1I86QO9W-5<&1A=&5-
M87-K#0HR,#HQ,3HQ-R!N1G5L;$UA<VL@./2 P>#%B9&9C,#,W+"!N0W5R<F5N
M=" ](#!X-# P,# P+"!N1&ER96-T:6]N(#T@.,0T*,C Z,3$Z,3<@.57!D871E
M9"!$:6%L;V<@.36%S:SH@.,'@.Q8F1F8S S-RP@.1&ES86)L92!"86-K(#T@.,'@.Q
M#0HR,#HQ,3HQ-R!$:6%L;V<@.,'@.T,# P,# @.<F5T=7)N960Z(#$-"C(P.C$Q
M.C$W($5N9"!!8W1I;VX@.4VAO=T1I86QO9W-(;'!R#0HR,#HQ,3HQ-R!3:&]W
M1&EA;&]G<T=E=$1I86QO9R!R971U<FYE9#H@.;D-U<G)E;G0],'@.X,# P,# L
M:6YD97@.],C,-"C(P.C$Q.C$W($)E9VEN($%C=&EO;B!3:&]W1&EA;&]G<TAL
M<'(Z(#!X.# P,# P#0HR,#HQ,3HQ-R!"96=I;B!!8W1I;VXZ("!$;&=344Q3
M96-U<FET>0T*,C Z,3$Z,C0@.4VAO=T1L9U-13%-E8W5R:71Y(')E='5R;F5D
M.B Q#0HR,#HQ,3HR-"!,;V=I;DUO9&4@./2 R+'-Z4'=D#0HR,#HQ,3HR-"!%
M;F0@.06-T:6]N($1L9U-13%-E8W5R:71Y#0HR,#HQ,3HR-"!B96=I;B!3:&]W
M1&EA;&]G<U5P9&%T94UA<VL-"C(P.C$Q.C(T(&Y&=6QL36%S:R ](#!X,6)D
M9F,P,S<L(&Y#=7)R96YT(#T@.,'@.X,# P,# L(&Y$:7)E8W1I;VX@./2 Q#0HR
M,#HQ,3HR-"!5<&1A=&5D($1I86QO9R!-87-K.B P>#%B9&9C,#,W+"!$:7-A
M8FQE($)A8VL@./2 P>#$-"C(P.C$Q.C(T($1I86QO9R P>#@.P,# P,"!R971U
M<FYE9#H@.,0T*,C Z,3$Z,C0@.16YD($%C=&EO;B!3:&]W1&EA;&]G<TAL<'(-
M"C(P.C$Q.C(T(%-H;W=$:6%L;V=S1V5T1&EA;&]G(')E='5R;F5D.B!N0W5R
M<F5N=#TP>#$P,# P,# L:6YD97@.],C0-"C(P.C$Q.C(T($)E9VEN($%C=&EO
M;B!3:&]W1&EA;&]G<TAL<'(Z(#!X,3 P,# P, T*,C Z,3$Z,C0@.0F5G:6X@.
M06-T:6]N.B @.1&QG0V]L;&%T:6]N#0HR,#HQ,3HR-R!3:&]W1&QG0V]L;&%T
M:6]N(')E='5R;F5D.B Q#0HR,#HQ,3HR-R!C;VQL871I;VY?;F%M92 ]($-H
M:6YE<V5?4%)#7T-)7T%3+&QO8V%L95]N86UE(#T@.0VAI;F5S95]04D,L;&-I
M9" ](#!X.# T+%-O<G1)9" ](# L9'=#;VUP1FQA9W,@./2 P>#,P,# Q#0HR
M,#HQ,3HR-R!%;F0@.06-T:6]N($1L9T-O;&QA=&EO;@.T*,C Z,3$Z,C<@.8F5G
M:6X@.4VAO=T1I86QO9W-5<&1A=&5-87-K#0HR,#HQ,3HR-R!N1G5L;$UA<VL@.
M/2 P>#%B9&9C,#,W+"!N0W5R<F5N=" ](#!X,3 P,# P,"P@.;D1I<F5C=&EO
M;B ](#$-"C(P.C$Q.C(W(%5P9&%T960@.1&EA;&]G($UA<VLZ(#!X,6)D9F,P
M,S<L($1I<V%B;&4@.0F%C:R ](#!X,0T*,C Z,3$Z,C<@.1&EA;&]G(#!X,3 P
M,# P,"!R971U<FYE9#H@.,0T*,C Z,3$Z,C<@.16YD($%C=&EO;B!3:&]W1&EA
M;&]G<TAL<'(-"C(P.C$Q.C(W(%-H;W=$:6%L;V=S1V5T1&EA;&]G(')E='5R
M;F5D.B!N0W5R<F5N=#TP>#(P,# P,# L:6YD97@.],C4-"C(P.C$Q.C(W($)E
M9VEN($%C=&EO;B!3:&]W1&EA;&]G<TAL<'(Z(#!X,C P,# P, T*,C Z,3$Z
M,C<@.0F5G:6X@.06-T:6]N.B @.1&QG3F5T=V]R:PT*,C Z,3$Z,C<@.4VAO=T1L
M9TYE='=O<FL@.<F5T=7)N960Z(#$-"C(P.C$Q.C(W(%M$;&=397)V97).971W
M;W)K70T*,C Z,3$Z,C<@.3F5T=V]R:TQI8G,@./2 R-34-"C(P.C$Q.C(W(%1#
M4%!O<G0@./2 Q-#,S#0HR,#HQ,3HR-R!40U!0<GAY(#T@.1&5F875L= T*,C Z
M,3$Z,C<@.3DU04&EP94YA;64@./2!<7"Y<<&EP95QS<6Q<<75E<GD-"C(P.C$Q
M.C(W(%)E<W5L=" ](#$-"C(P.C$Q.C(W($5N9"!!8W1I;VX@.1&QG3F5T=V]R
M:PT*,C Z,3$Z,C<@.8F5G:6X@.4VAO=T1I86QO9W-5<&1A=&5-87-K#0HR,#HQ
M,3HR-R!N1G5L;$UA<VL@./2 P>#%B9&9C,#,W+"!N0W5R<F5N=" ](#!X,C P
M,# P,"P@.;D1I<F5C=&EO;B ](#$-"C(P.C$Q.C(W(%5P9&%T960@.1&EA;&]G
M($UA<VLZ(#!X,6)D9F,P,S<L($1I<V%B;&4@.0F%C:R ](#!X,0T*,C Z,3$Z
M,C<@.1&EA;&]G(#!X,C P,# P,"!R971U<FYE9#H@.,0T*,C Z,3$Z,C<@.16YD
M($%C=&EO;B!3:&]W1&EA;&]G<TAL<'(-"C(P.C$Q.C(W(%-H;W=$:6%L;V=S
M1V5T1&EA;&]G(')E='5R;F5D.B!N0W5R<F5N=#TP>#@.P,# P,# L:6YD97@.]
M,C<-"C(P.C$Q.C(W($)E9VEN($%C=&EO;B!3:&]W1&EA;&]G<TAL<'(Z(#!X
M.# P,# P, T*,C Z,3$Z,C<@.0F5G:6X@.06-T:6]N.B @.1&EA;&]G4VAO=U-D
M4W1A<G1#;W!Y#0HR,#HQ,3HR."!%;F0@.06-T:6]N($1I86QO9U-H;W=39%-T
M87)T0V]P>0T*,C Z,3$Z,C@.@.8F5G:6X@.4VAO=T1I86QO9W-5<&1A=&5-87-K
M#0HR,#HQ,3HR."!N1G5L;$UA<VL@./2 P>#%B9&9C,#,W+"!N0W5R<F5N=" ]
M(#!X.# P,# P,"P@.;D1I<F5C=&EO;B ](#$-"C(P.C$Q.C(X(%5P9&%T960@.
M1&EA;&]G($UA<VLZ(#!X,6)D9F,P,S<L($1I<V%B;&4@.0F%C:R ](#!X,0T*
M,C Z,3$Z,C@.@.1&EA;&]G(#!X.# P,# P,"!R971U<FYE9#H@.,0T*,C Z,3$Z
M,C@.@.16YD($%C=&EO;B!3:&]W1&EA;&]G<TAL<'(-"C(P.C$Q.C(X(%-H;W=$
M:6%L;V=S1V5T1&EA;&]G(')E='5R;F5D.B!N0W5R<F5N=#TP>#$P,# P,# P
M+&EN9&5X/3(X#0HR,#HQ,3HR."!"96=I;B!!8W1I;VX@.4VAO=T1I86QO9W-(
M;'!R.B P>#$P,# P,# P#0HR,#HQ,3HR."!"96=I;B!!8W1I;VXZ("!$:6%L
M;V=3:&]W4V1,:6-E;G-E36]D90T*,C Z,3$Z,S @.4VAO=T1L9TQI8V5N<V4@.
M<F5T=7)N960Z(#$-"C(P.C$Q.C,P(%-H;W=$;&=,:6-E;G-E(')E='5R;F5D
M.B!,:6-E;G-E36]D92 ](#(L($QI8V5N<V5,:6UI=" ](#(-"C(P.C$Q.C,P
M($5N9"!!8W1I;VX@.1&EA;&]G4VAO=U-D3&EC96YS94UO9&4-"C(P.C$Q.C,P
M($1I86QO9R P>#$P,# P,# P(')E='5R;F5D.B Q#0HR,#HQ,3HS,"!%;F0@.
M06-T:6]N(%-H;W=$:6%L;V=S2&QP<@.T*,C Z,3$Z,S @.4VAO=T1I86QO9W-'
M971$:6%L;V<@.<F5T=7)N960Z(&Y#=7)R96YT/3!X,"QI;F1E>#TP#0HR,#HQ
M,3HS,"!%;F0@.06-T:6]N(%-H;W=$:6%L;V=S#0HR,#HQ,3HS,"!.;W<@.8F5G
M:6X@.:6YS=&%L;&EN9R!-:6-R;W-O9G0@.1&ES=')I8G5T960@.5')A;G-A8W1I
M;VX@.0V]O<F1I;F%T;W(@.*$U31%1#*2 N+BX-"C(P.C$Q.C,P("!#.EQ724Y.
M5%Q414U07%-Q;%-E='5P7$)I;EQC;&1T8W-T<"YE>&4@.+5-U<'!O<G1$:7(@.
M(D,Z7%=)3DY47%1%35!<4W%L4V5T=7!<0FEN(B M1%1#4&MG(")#.EQ%3E1<
M>#@.V7$]T:&5R7&1T8W-E='5P+F5X92(@.+4QO9T9I;&4@.(D,Z7%=)3DY47'-Q
M;'-T<"YL;V<B("U#='A!8V-T(")324Y/3$E.15-<8VQU<W1E<B(@.+4-T>$50
M=V0-"C(P.C$Q.C,P(%!R;V-E<W,@.17AI="!#;V1E.B H,"D@.#0HR,#HQ,3HS
M,"!"96=I;B!!8W1I;VX@..B!#;'5S=&5R4V5T=7!(96QP97( -"C(P.C$Q.C,P
M($)E9VEN($%C=&EO;B Z($-R96%T94-L=7-T25-31FEL97,-"C(P.C$Q.C,P
M($5N9"!!8W1I;VX@..B!#<F5A=&5#;'5S=$E34T9I;&5S#0HR, #HQ,3HS,"!"
M96=I;B!!8W1I;VX@..B!#;'5S=&5R5W)I=&5296U);FD-"C(P.C$Q.C,P($5N
M9"!!8W1I;VX@..B!#;'5S=&5R5W)I=&5296U);FD-"C(P.C$Q.C,P($)E9VEN
M($%C=&EO;B Z(%)U;B!S971U<"!O;B!C;'5S=&5R(&YO9&5S#0I;87)G<UT-
M"DYU;5)E;6]T95-E<G9E<G,],@.T*6U-E<G9E<BXQ70T*3G5M4F5M;W1E4V5R
M=FEC97,],0T*,2YA<' ]7%Q!7$,D7$5.5%QX.#9<<V5T=7!<<V5T=7!S<6PN
M97AE#0HQ+G-C<FEP=#U<7$%<861M:6XD7%]-4U-13%-%4E9%4BYI<W,-"C$N
M8VUD;&EN969O<FUA=#TE<R!K/4-L4V5C(&L]4FT@.:SU#;" M4TU3("US("UF
M,2 E<R M;R B<W%L<W1P+F5X92(@.#0HQ+G5S97(]4TE.3TQ)3D537&-L=7-T
M97(-"C$N<&%S<W=O<F0],3,W8S4R8S8Q,V5A8C-B,6$Y-6$W-35A-#)C9 T*
M,2YN86UE/5-13%-E='5P,0T*,2YS<6QS971U<#U9#0HQ+F-O<'EE>&4]8VYV
M<W9C,2YE>&4-"EM397)V97(N,ET-"DYU;5)E;6]T95-E<G9I8V5S/3$-"C$N
M87!P/5Q<05Q#)%Q%3E1<>#@.V7'-E='5P7'-E='5P<W%L+F5X90T*,2YS8W)I
M<'0]7%Q!7&%D;6EN)%Q?35-344Q315)615(N:7-S#0HQ+F-M9&QI;F5F;W)M
M870])7,@.:SU#;%-E8R!K/5)M(&L]0VP@.+5--4R M<R M9B B7%Q!7$,D7$5.
M5%QX.#9<<V5T=7!<<V5T=7 N:6YS(B M9C$@.)7,@.+68R(")<7%QA9&UI;B1<
M<V5T=7 N;&]G(B M92 B<W1P<VEL;G0N7V5X(B @.+7@.@.(D,Z7"(-"C$N=7-E
M<CU324Y/3$E.15-<8VQU<W1E<@.T*,2YP87-S=V]R9#TQ,S=C-3)C-C$S96%B
M,V(Q83DU83<U-6$T,F-D#0HQ+FYA;64]4U%,4V5T=7 R#0HQ+G-Q;'-E='5P
M/5D-"C$N8V]P>65X93UC;G9S=F,R+F5X90T*,C Z,3$Z,S @.($EN<W1A;&QS
M:&EE;&0@.:7,@.:6YS=&%L;&EN9R!S;VUE('!R;V=R86T@.;VX@.= &AE(&YO9&4L
M('1H:7,@.;6%Y(&YE960@.<V]M92!M:6YU=&5S*+"RU["SS-#RU?W4VLBZO*^]
MVK7CR<_6M-#0T.C2JK7$LMG7]Z&CU>*_R<3<T.C2JLK]M];6TRXN+BD-"C(P
M.C$Q.C,P("!#.EQ724Y.5%Q414U07%-Q;%-E='5P7$)I;EQR96US971U<"YE
M>&4@.0SI<5TE.3E1<<F5M<V5T=7 N:6YI#0HR,#HQ,3HS,"!0<F]C97-S($5X
M:70@.0V]D93H@.*"TQ*2 -"C(P.C$Q.C,P($)E9VEN($%C=&EO;B Z($=E=%)E
M;7-E='5P4F5T0V]D90T*,C Z,3$Z,S @.26YS=&%L;&%T:6]N(')E='5R;B!S
M=&%T=7,@.;VX@.(#H@.+3$-"C(P.C$Q.C,P($EN<W1A;&QA=&EO;B!R971U<FX@.
M<W1A='5S(&]N(" Z("TQ#0HR,#HQ,3HS,"!%;F0@.06-T:6]N(#H@.1V5T4F5M
M<V5T=7!2971#;V1E#2,C(R,@.4U%,(%-E<G9E<B#4MK/,L++7L+/,T/(@.H:H@.
MOZK*O,JQO.0@.,#8O,#(O,#0@.,C Z,3$Z,S @.(R,C(PT*#0IT:&4@.9VEV96X@.
M87)G=6UE;G1S(&%R92!I;G9A;&ED*,OYS.&YJ;7$RN3(Z]:USM[0IRFCH0T*
M#0K+^=*JQ_.UQ++.ROT@.4V5R=F5R+C$@.U-J]VJ.H87)G<Z.IUM##N]/0U=*U
MO:.A#0I4:&4@.<F5Q=65S=&5D(&%R9W5M96YT('-E<G9E<BYS(&-A;FYO="!B
M92!F;W5N9"!I;B!A<F=S#0K+^<SAN:FUQ,KDR.O6M<[>T*>CH 0T*#0K+^=*J
MQ_.UQ++.ROT@.4V5R=F5R+C(@.U-J]VJ.H87)G<Z.IUM##N]/0U=*UO:.A#0H-
M"M3:U,O0T-2VL\POSM[6M;NDL++7L+/,T/+*L;>BR?K2N[CVN_*VX+CVM.W.
M\Z&C#0H-"B @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.
M(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.
M(" @.(" @.(" @.(" -"C(P.C$Q.C,P($5N9"!!8W1I;VX@..B!2=6X@.<V5T=7 @.
M;VX@.8VQU<W1E<B!N;V1E<PT*,C Z,3$Z,S @.96YC;W5N=&5R(&]N92!O<B!S
M;VUE(&9A=6QT<R!W:&5N(')U;B!S;VUE(')E;6]T92!P<F]G<F%M;65S(-3:
MR+J\K[7$O,;+X[OZR<_4R]#0U+:SS+"RU["SS-#RRK&CK+/VS];2N[CVN_*V
MX+CVM.W.\Z&C#0HR,#HQ,3HS,2!3971U<"!F86EL960@.=&\@.< &5R9F]R;2!T
M:&4@.<F5Q=6ER960@.;W!E<F%T:6]N(&]N('1H92!C;'5S=&5R(&YO9&5S(+"R
MU["SS-#RU-K(NKROO=JUX\G/UK30T-*JQ_.UQ++9U_?*I[#<H:,-"C(P.C$Q
M.C,Q($)E9VEN($%C=&EO;B Z($-L=7-T97)%<G)O<D-L96%N=7 -"C(P.C$Q
M.C,Q($5N9"!!8W1I;VX@..B!#;'5S=&5R17)R;W)#;&5A;G5P# 0HR,#HQ,3HS
C,2!%;F0@.06-T:6]N(#H@.0VQU<W1E<E-E='5P2&5L<&5R#0H`
`
end

Wednesday, March 7, 2012

Closing gaps in Celko-tree

Hello
I've been using that nested modeltree that Celko uses, and it's superb, but
I've encountered a problem with a table (some unforseen things happened when
i tried to move subtrees from A to B), and a really huge tree ended up with
gaps, structure of tree isnt messed up or anything, just has gaps here and
there.
I got SQL For Smarties (which is a great book btw..) but I cant get that
code to work no matter how I try in sql 2000.
Any of you guys got some neat update or something?
/LasseWhy does it matter if there are gaps?
In the one project I've used that technique on, we actually implemented gaps
on purpose in order to reduce the number of updates that would have to take
place any time a new row was inserted... Gaps do not change the behavior of
the mathematics.
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"Lasse Edsvik" <lasse@.nospam.com> wrote in message
news:%23PZl6YfFGHA.1288@.TK2MSFTNGP09.phx.gbl...
> Hello
> I've been using that nested modeltree that Celko uses, and it's superb,
> but
> I've encountered a problem with a table (some unforseen things happened
> when
> i tried to move subtrees from A to B), and a really huge tree ended up
> with
> gaps, structure of tree isnt messed up or anything, just has gaps here and
> there.
> I got SQL For Smarties (which is a great book btw..) but I cant get that
> code to work no matter how I try in sql 2000.
> Any of you guys got some neat update or something?
> /Lasse
>|||Adam,
i dont quite agree, first of all, its easier to see if the tree is "valid"
(for debugging), 2nd, you dont have to have some subquery to determine if
its the last node in tree since lft-rgt=1 then (or x0 and x1 as i call them
in my design). And 3rd when you acctually going to use the values to display
a graph, it'd looked messed up.
sure it may work, but i'm allergic to "works but not quite correct", i'm
sure a Dell server with 2 xeon cpu's and 4gb ram can handle a few updates to
fix the gaps.
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:u2URrdfFGHA.2704@.TK2MSFTNGP15.phx.gbl...
> Why does it matter if there are gaps?
> In the one project I've used that technique on, we actually implemented
gaps
> on purpose in order to reduce the number of updates that would have to
take
> place any time a new row was inserted... Gaps do not change the behavior
of
> the mathematics.
>
> --
> Adam Machanic
> Pro SQL Server 2005, available now
> http://www.apress.com/book/bookDisplay.html?bID=457
> --
>
> "Lasse Edsvik" <lasse@.nospam.com> wrote in message
> news:%23PZl6YfFGHA.1288@.TK2MSFTNGP09.phx.gbl...
and
>|||Lasse Edsvik wrote:
> Adam,
> i dont quite agree, first of all, its easier to see if the tree is "valid"
> (for debugging), 2nd, you dont have to have some subquery to determine if
> its the last node in tree since lft-rgt=1 then (or x0 and x1 as i call the
m
> in my design). And 3rd when you acctually going to use the values to displ
ay
> a graph, it'd looked messed up.
> sure it may work, but i'm allergic to "works but not quite correct", i'm
> sure a Dell server with 2 xeon cpu's and 4gb ram can handle a few updates
to
> fix the gaps.
>
Hi Lasse,
Just thrown this together, test first:
create table Numbers (
Num int not null
)
go
insert into Numbers (Num)
select a.a * 100 + b.b * 10 + c.c
from
(select 0 as a union select 1 union select 2 union select 3 union
select 4 union select 5 union select 6 union select 7 union select 8
union select 9) a,
(select 0 as b union select 1 union select 2 union select 3 union
select 4 union select 5 union select 6 union select 7 union select 8
union select 9) b,
(select 0 as c union select 1 union select 2 union select 3 union
select 4 union select 5 union select 6 union select 7 union select 8
union select 9) c
go
create table Blah (
ID int not null,
X0 int not null,
X1 int not null,
CONSTRAINT CK_Valid CHECK(0 <= X0 and X0 < X1)
)
go
insert into Blah (ID,X0,X1)
select 1,0,500 union all
select 2,2,250 union all
select 3,251,499 union all
select 4,55,56 union all
select 5,90,94 union all
select 6,300,400
go
update
Blah
set X0 = b.X0 - decr.DecX0,
X1 = b.X1 - decr.DecX1
from
Blah b
inner join
(select
ID,X0,X1,
(select count(*) from Numbers where Num < b.X0 and Num not in (select
X0 from Blah) and Num not in (select X1 from Blah)) as DecX0,
(select count(*) from Numbers where Num < b.X1 and Num not in (select
X1 from Blah) and Num not in (select X0 from Blah)) as DecX1
from
Blah b) decr
on
b.ID = decr.ID
go
select * from Blah
go
drop table Blah
go
drop table Numbers
go
course if you've already got a numbers table, I'd take out the first
and last steps. If you don't, create one (course, you might need a
larger range, depending on your system). If you do have one, I'd
recommend removing some bits from my script (like the drop...)
Damien|||CREATE VIEW LftRgt(seq)
AS SELECT lft FROM Tree
UNION ALL
SELECT rgt FROM Tree;
UPDATE Tree
SET lft = (SELECT COUNT(*)
FROM LftRgt
WHERE seq <= lft),
rgt = (SELECT COUNT(*)
FROM LftRgt
WHERE seq <= rgt);
This will preserve the algebriac property that (rgt-lft +1)/2 = size of
subtree rooted at this node.
--CELKO--
Please post DDL in a human-readable format and not a machine-generated
one. This way people do not have to guess what the keys, constraints,
DRI, datatypes, etc. in your schema are. Sample data is also a good
idea, along with clear specifications.
*** Sent via Developersdex http://www.examnotes.net ***|||>> Why does it matter if there are gaps? In the one project I've used
that technique on, we actually implemented gaps on purpose in order to
reduce the number of updates that would have to take place any time a
new row was inserted... Gaps do not change the behavior of
the mathematics <<
Not quite. The "between-ness" property is handy for structural queries.
But the "algebraic" property (contigous lft-rgt numbering) provides a
simple validation of the tree and give you the size of the subtree at
that node = (rgt-lft+1)/2.
I have some material on using gaps to speed up updates in TREES &
HIERARCHY IN SQL.
--CELKO--
Please post DDL in a human-readable format and not a machine-generated
one. This way people do not have to guess what the keys, constraints,
DRI, datatypes, etc. in your schema are. Sample data is also a good
idea, along with clear specifications.
*** Sent via Developersdex http://www.examnotes.net ***|||--CELKO-- wrote:
> the "algebraic" property (contigous lft-rgt numbering) provides a
> simple validation of the tree
Can this constraint be written formally?|||Celko,
well, im not sure if i'm way off, but when I run that update lft and rgt
gets same values...
view looks like this:
seq
1
2
3
9
11
14
22
8
4
10
16
15
Not sure if you or me need a coffee here :) I'll have one extra atleast :)
"--CELKO--" <remove.jcelko212@.earthlink.net> wrote in message
news:epclMltFGHA.3100@.tk2msftngp13.phx.gbl...
> CREATE VIEW LftRgt(seq)
> AS SELECT lft FROM Tree
> UNION ALL
> SELECT rgt FROM Tree;
> UPDATE Tree
> SET lft = (SELECT COUNT(*)
> FROM LftRgt
> WHERE seq <= lft),
> rgt = (SELECT COUNT(*)
> FROM LftRgt
> WHERE seq <= rgt);
> This will preserve the algebriac property that (rgt-lft +1)/2 = size of
> subtree rooted at this node.
>
> --CELKO--
> Please post DDL in a human-readable format and not a machine-generated
> one. This way people do not have to guess what the keys, constraints,
> DRI, datatypes, etc. in your schema are. Sample data is also a good
> idea, along with clear specifications.
>
> *** Sent via Developersdex http://www.examnotes.net ***|||Did you select from the view with an ORDER BY clause?
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"Lasse Edsvik" <lasse@.nospam.com> wrote in message
news:%23vtw$X1FGHA.2300@.TK2MSFTNGP15.phx.gbl...
> Celko,
> well, im not sure if i'm way off, but when I run that update lft and rgt
> gets same values...
> view looks like this:
> seq
> 1
> 2
> 3
> 9
> 11
> 14
> 22
> 8
> 4
> 10
> 16
> 15
> Not sure if you or me need a coffee here :) I'll have one extra atleast :)
>
> "--CELKO--" <remove.jcelko212@.earthlink.net> wrote in message
> news:epclMltFGHA.3100@.tk2msftngp13.phx.gbl...
>|||Adam,
I dont see how:
SELECT COUNT(*)
FROM LftRgt
WHERE seq <= rgt
and...
SELECT COUNT(*)
FROM LftRgt
WHERE seq <= lft
would get different values with an order by clause
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:O5A9Hr3FGHA.1760@.TK2MSFTNGP10.phx.gbl...
> Did you select from the view with an ORDER BY clause?
>
> --
> Adam Machanic
> Pro SQL Server 2005, available now
> http://www.apress.com/book/bookDisplay.html?bID=457
> --
>
> "Lasse Edsvik" <lasse@.nospam.com> wrote in message
> news:%23vtw$X1FGHA.2300@.TK2MSFTNGP15.phx.gbl...
:)
>

Tuesday, February 14, 2012

Client Failover Problems

Hi,

I encountered 2 problems when my application reconnects to the mirror database after the principle database is not available.

My Connection String:

Data Source=ServerA;Failover Partner=ServerB;Initial Catalog=TestFailover;Persist Security Info=True;User ID=sa;Connect Timeout=45

Firstly, the following exception will be prompted when failover occurs:

A transport-level error has ocurred when received results from the server. The specified network name is no longer available

Q1: Is it normal to have this exception? Otherwise, how can I avoid this exception?

Secondly, I tried to capture the exception and retry the operation, then failover successed but the time is very slow. A simple update operation takes about 2 mins to complete which can be finished within a second under normal situation. I tried to set the Connect Timeout to 30s, but the application pending for long long time.

Q2: How can I improve the time need for failover?

A1: I don't know if you can avoid the exception.

A2: What version of the software are you using? Sounds like there is a timeout that is taking its time, either a connection timeout or a Tcp timeout. How are you testing the redirect? Try crashing the principal server with a SHUTDOWN WITH NOWAIT command.

Thanks,

Mark

|||

If you are on RTM, then upgrading to SP1 should fix your problem. In RTM a dead machine caused a stall in TCP waiting for a default TCP timeout of 30 secs which is longer than the default login timeout of 15 secs.

Thanks to Chris for the information.