Re: [U2] UniVerse 10.3 with Domain Controller Failure

[David Wolverton]

Yes - I guess that is the case -- they are not on 11.1, and just got word
that's where it's got fixed. The only choice under this release per the case
is to "cease the domain controller".  I think they meant 'seize' the
controller.  [And I just notices that 'seize' violates the I before E rule,
by the way!]

So the client is going to do the 'seize' tomorrow.  And then we'll load 11.1
when it's more convenient!

Thanks for the thoughts here - at least I know we did everything we could
and that it was actually a Rocket issue.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Holt, Jake
Sent: Thursday, September 15, 2011 3:30 PM
To: U2 Users List
Subject: Re: [U2] UniVerse 10.3 with Domain Controller Failure

And I meant to add...

If the PDC emulator was on the other DC (which I would assume it is) and
you can't restore it you will have to seize the fsmo role.

It's pretty simple, but it's also a last resort type of a deal.

Instructions are here:
http://technet.microsoft.com/en-us/library/cc785114%28WS.10%29.aspx



-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Holt, Jake
Sent: Thursday, September 15, 2011 3:21 PM
To: U2 Users List
Subject: Re: [U2] UniVerse 10.3 with Domain Controller Failure

Does this version of Universe pre-date the PDC emulator fix? 

If not you will not be able to login to UniVerse if the database cannot
access the server with the PDC Emulator FSMO role.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Thursday, September 15, 2011 1:16 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] UniVerse 10.3 with Domain Controller Failure


If you can get to TCL as a local user and cannot as a domain user, then
I would suggest a permissions setting is wrong.
Your domain user can't "open" some file that Universe is trying to open.
For example uvtemp or something, who knows.
The "local" user would most likely own all the files.

But go to TCL and make sure what users are logged in.
For example nine hundred sessions trying to lock the uv.accounts
file.






-Original Message-
From: David Wolverton 
To: 'U2 Users List' 
Sent: Thu, Sep 15, 2011 11:03 am
Subject: Re: [U2] UniVerse 10.3 with Domain Controller Failure


Correct -- the screen opens and what you would normally see next is the
niVerse 'banner' - the cursor just blinks...  Nothing.
But the 'shell screen' is 'open' and 'trying' to connect.
And for DNS -- if the other applications were 'dead' as well on the
machine, gain, I'd suspect something 'outside' -- But it's sounding more
like a ocket support call than anything, so may have to ask the vendor
to see what hey say.

-Original Message-
rom: u2-users-boun...@listserver.u2ug.org
mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
ent: Thursday, September 15, 2011 12:29 PM
o: u2-users@listserver.u2ug.org
ubject: Re: [U2] UniVerse 10.3 with Domain Controller Failure

hat exactly do you mean by the statement that uvshell "hangs"
o you mean it opens the uvshell application but will not give you any
essage at all?  so its just a blank gray screen?
r do you mean it won't even open the application window?
If you can run uvshell as a local user, can you LISTU to see if the
default ackground processes are running?
 mean the uvdlock, the phantom processer, the console, etc



Original Message-
rom: John Thompson 
o: U2 Users List 
ent: Thu, Sep 15, 2011 10:19 am
ubject: Re: [U2] UniVerse 10.3 with Domain Controller Failure

erhaps the Domain Controller that failed also had DNS running on it?
erhaps its a DNS issue... you say one Unidata server takes a while and
nally logs in...
nother shot in the dark.
n Thu, Sep 15, 2011 at 1:15 PM, David Wolverton 
wrote:
 See, I would suspect something like this as well, but the %LOGONSERVER%
is 'up', and Great Plains running on the same server as the UniVerse
server is working A-OK.  (I hate the fact they have 3 different
databases on this machine, but it is illustrative that it's 'only
UniVerse' as both the Great Plains and the Oracle databases are running
without a glitch since the failover, so I'm looking at what I can do to
'fix' Universe.)  -Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson
Sent: Thursday, September 15, 2011 12:11 PM
To: U2 Users List
Subject: Re: [U2] UniVerse 10.3 with Domain Controller Failure  This is
a wild guess...  So my disclaimer is, "Try at your own risk"
 Part of my hatred for Windows Active Directory resides with this very
issue, but, I digress...
 I have seen servers and workstations not talk to the backup domain
controller before, especially after a primary domain controller failure.
 SO, IF, the Primary Domain Controller has failed

Re: [U2] UniVerse 10.3 with Domain Controller Failure

[Holt, Jake]

And I meant to add...

If the PDC emulator was on the other DC (which I would assume it is) and
you can't restore it you will have to seize the fsmo role.

It's pretty simple, but it's also a last resort type of a deal.

Instructions are here:
http://technet.microsoft.com/en-us/library/cc785114%28WS.10%29.aspx



-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Holt, Jake
Sent: Thursday, September 15, 2011 3:21 PM
To: U2 Users List
Subject: Re: [U2] UniVerse 10.3 with Domain Controller Failure

Does this version of Universe pre-date the PDC emulator fix? 

If not you will not be able to login to UniVerse if the database cannot
access the server with the PDC Emulator FSMO role.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Thursday, September 15, 2011 1:16 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] UniVerse 10.3 with Domain Controller Failure


If you can get to TCL as a local user and cannot as a domain user, then
I would suggest a permissions setting is wrong.
Your domain user can't "open" some file that Universe is trying to open.
For example uvtemp or something, who knows.
The "local" user would most likely own all the files.

But go to TCL and make sure what users are logged in.
For example nine hundred sessions trying to lock the uv.accounts
file.






-Original Message-
From: David Wolverton 
To: 'U2 Users List' 
Sent: Thu, Sep 15, 2011 11:03 am
Subject: Re: [U2] UniVerse 10.3 with Domain Controller Failure


Correct -- the screen opens and what you would normally see next is the
niVerse 'banner' - the cursor just blinks...  Nothing.
But the 'shell screen' is 'open' and 'trying' to connect.
And for DNS -- if the other applications were 'dead' as well on the
machine, gain, I'd suspect something 'outside' -- But it's sounding more
like a ocket support call than anything, so may have to ask the vendor
to see what hey say.

-Original Message-
rom: u2-users-boun...@listserver.u2ug.org
mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
ent: Thursday, September 15, 2011 12:29 PM
o: u2-users@listserver.u2ug.org
ubject: Re: [U2] UniVerse 10.3 with Domain Controller Failure

hat exactly do you mean by the statement that uvshell "hangs"
o you mean it opens the uvshell application but will not give you any
essage at all?  so its just a blank gray screen?
r do you mean it won't even open the application window?
If you can run uvshell as a local user, can you LISTU to see if the
default ackground processes are running?
 mean the uvdlock, the phantom processer, the console, etc



Original Message-
rom: John Thompson 
o: U2 Users List 
ent: Thu, Sep 15, 2011 10:19 am
ubject: Re: [U2] UniVerse 10.3 with Domain Controller Failure

erhaps the Domain Controller that failed also had DNS running on it?
erhaps its a DNS issue... you say one Unidata server takes a while and
nally logs in...
nother shot in the dark.
n Thu, Sep 15, 2011 at 1:15 PM, David Wolverton 
wrote:
 See, I would suspect something like this as well, but the %LOGONSERVER%
is 'up', and Great Plains running on the same server as the UniVerse
server is working A-OK.  (I hate the fact they have 3 different
databases on this machine, but it is illustrative that it's 'only
UniVerse' as both the Great Plains and the Oracle databases are running
without a glitch since the failover, so I'm looking at what I can do to
'fix' Universe.)  -Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson
Sent: Thursday, September 15, 2011 12:11 PM
To: U2 Users List
Subject: Re: [U2] UniVerse 10.3 with Domain Controller Failure  This is
a wild guess...  So my disclaimer is, "Try at your own risk"
 Part of my hatred for Windows Active Directory resides with this very
issue, but, I digress...
 I have seen servers and workstations not talk to the backup domain
controller before, especially after a primary domain controller failure.
 SO, IF, the Primary Domain Controller has failed... and the Backup is
now controlling things, and the primary is still not up and running...
 You might be able to do the following to fix your login issue:
 1) Remove the UV server from the domain completely
2) Reboot
3) Re-join the UV server to the domain
4) Reboot
5) Check whatever UV uses (which I have no knowledge of) to login to the
domain and make sure its not a hardcoded hostname pointer kind of thing
to the domain controller that is not online.
 Like I said.  A wild guess, but, I've seen it work with other servers
and workstations when a "Primary Domain Controller" would fail and the
backup would pick up.  Don't ask me why...  I'm not a MCSE guy.
 On Thu, Sep 15, 2011 at 1:03 PM, David Wolverton 
wrote:
 > If I log into the actual server after logging in as a "LOCAL" user,
the

Re: [U2] UniVerse 10.3 with Domain Controller Failure

[Holt, Jake]

Does this version of Universe pre-date the PDC emulator fix? 

If not you will not be able to login to UniVerse if the database cannot
access the server with the PDC Emulator FSMO role.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Thursday, September 15, 2011 1:16 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] UniVerse 10.3 with Domain Controller Failure


If you can get to TCL as a local user and cannot as a domain user, then
I would suggest a permissions setting is wrong.
Your domain user can't "open" some file that Universe is trying to open.
For example uvtemp or something, who knows.
The "local" user would most likely own all the files.

But go to TCL and make sure what users are logged in.
For example nine hundred sessions trying to lock the uv.accounts
file.






-Original Message-
From: David Wolverton 
To: 'U2 Users List' 
Sent: Thu, Sep 15, 2011 11:03 am
Subject: Re: [U2] UniVerse 10.3 with Domain Controller Failure


Correct -- the screen opens and what you would normally see next is the
niVerse 'banner' - the cursor just blinks...  Nothing.
But the 'shell screen' is 'open' and 'trying' to connect.
And for DNS -- if the other applications were 'dead' as well on the
machine, gain, I'd suspect something 'outside' -- But it's sounding more
like a ocket support call than anything, so may have to ask the vendor
to see what hey say.

-Original Message-
rom: u2-users-boun...@listserver.u2ug.org
mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
ent: Thursday, September 15, 2011 12:29 PM
o: u2-users@listserver.u2ug.org
ubject: Re: [U2] UniVerse 10.3 with Domain Controller Failure

hat exactly do you mean by the statement that uvshell "hangs"
o you mean it opens the uvshell application but will not give you any
essage at all?  so its just a blank gray screen?
r do you mean it won't even open the application window?
If you can run uvshell as a local user, can you LISTU to see if the
default ackground processes are running?
 mean the uvdlock, the phantom processer, the console, etc



Original Message-
rom: John Thompson 
o: U2 Users List 
ent: Thu, Sep 15, 2011 10:19 am
ubject: Re: [U2] UniVerse 10.3 with Domain Controller Failure

erhaps the Domain Controller that failed also had DNS running on it?
erhaps its a DNS issue... you say one Unidata server takes a while and
nally logs in...
nother shot in the dark.
n Thu, Sep 15, 2011 at 1:15 PM, David Wolverton 
wrote:
 See, I would suspect something like this as well, but the %LOGONSERVER%
is 'up', and Great Plains running on the same server as the UniVerse
server is working A-OK.  (I hate the fact they have 3 different
databases on this machine, but it is illustrative that it's 'only
UniVerse' as both the Great Plains and the Oracle databases are running
without a glitch since the failover, so I'm looking at what I can do to
'fix' Universe.)  -Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson
Sent: Thursday, September 15, 2011 12:11 PM
To: U2 Users List
Subject: Re: [U2] UniVerse 10.3 with Domain Controller Failure  This is
a wild guess...  So my disclaimer is, "Try at your own risk"
 Part of my hatred for Windows Active Directory resides with this very
issue, but, I digress...
 I have seen servers and workstations not talk to the backup domain
controller before, especially after a primary domain controller failure.
 SO, IF, the Primary Domain Controller has failed... and the Backup is
now controlling things, and the primary is still not up and running...
 You might be able to do the following to fix your login issue:
 1) Remove the UV server from the domain completely
2) Reboot
3) Re-join the UV server to the domain
4) Reboot
5) Check whatever UV uses (which I have no knowledge of) to login to the
domain and make sure its not a hardcoded hostname pointer kind of thing
to the domain controller that is not online.
 Like I said.  A wild guess, but, I've seen it work with other servers
and workstations when a "Primary Domain Controller" would fail and the
backup would pick up.  Don't ask me why...  I'm not a MCSE guy.
 On Thu, Sep 15, 2011 at 1:03 PM, David Wolverton 
wrote:
 > If I log into the actual server after logging in as a "LOCAL" user,
the UV
> Shell starts up.
>
> If I log into the actual server after logging in as a "DOMAIN" user, 
> the
UV
> Shell just hangs.
>
> This is after MANY reboots, so I know the UniVerse services are 
> cleanly restarted.
>
>
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
> Sent: Thursday, September 15, 2011 11:57 AM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] UniVerse 10.3 with Domain Controller Failure
>
>
> Local login script on Universe is doing something funky.
> Try to co

Re: [U2] UniVerse 10.3 with Domain Controller Failure

[Wjhonson]

If you can get to TCL as a local user and cannot as a domain user, then I would 
suggest a permissions setting is wrong.
Your domain user can't "open" some file that Universe is trying to open.
For example uvtemp or something, who knows.
The "local" user would most likely own all the files.

But go to TCL and make sure what users are logged in.
For example nine hundred sessions trying to lock the uv.accounts file.






-Original Message-
From: David Wolverton 
To: 'U2 Users List' 
Sent: Thu, Sep 15, 2011 11:03 am
Subject: Re: [U2] UniVerse 10.3 with Domain Controller Failure


Correct -- the screen opens and what you would normally see next is the
niVerse 'banner' - the cursor just blinks...  Nothing.
But the 'shell screen' is 'open' and 'trying' to connect.
And for DNS -- if the other applications were 'dead' as well on the machine,
gain, I'd suspect something 'outside' -- But it's sounding more like a
ocket support call than anything, so may have to ask the vendor to see what
hey say.

-Original Message-
rom: u2-users-boun...@listserver.u2ug.org
mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
ent: Thursday, September 15, 2011 12:29 PM
o: u2-users@listserver.u2ug.org
ubject: Re: [U2] UniVerse 10.3 with Domain Controller Failure

hat exactly do you mean by the statement that uvshell "hangs"
o you mean it opens the uvshell application but will not give you any
essage at all?  so its just a blank gray screen?
r do you mean it won't even open the application window?
If you can run uvshell as a local user, can you LISTU to see if the default
ackground processes are running?
 mean the uvdlock, the phantom processer, the console, etc



Original Message-
rom: John Thompson 
o: U2 Users List 
ent: Thu, Sep 15, 2011 10:19 am
ubject: Re: [U2] UniVerse 10.3 with Domain Controller Failure

erhaps the Domain Controller that failed also had DNS running on it?
erhaps its a DNS issue... you say one Unidata server takes a while and
nally logs in...
nother shot in the dark.
n Thu, Sep 15, 2011 at 1:15 PM, David Wolverton  wrote:
 See, I would suspect something like this as well, but the %LOGONSERVER% is
'up', and Great Plains running on the same server as the UniVerse server is
working A-OK.  (I hate the fact they have 3 different databases on this
machine, but it is illustrative that it's 'only UniVerse' as both the Great
Plains and the Oracle databases are running without a glitch since the
failover, so I'm looking at what I can do to 'fix' Universe.)
 -Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson
Sent: Thursday, September 15, 2011 12:11 PM
To: U2 Users List
Subject: Re: [U2] UniVerse 10.3 with Domain Controller Failure
 This is a wild guess...  So my disclaimer is, "Try at your own risk"
 Part of my hatred for Windows Active Directory resides with this very
issue,
but, I digress...
 I have seen servers and workstations not talk to the backup domain
controller before, especially after a primary domain controller failure.
 SO, IF, the Primary Domain Controller has failed... and the Backup is now
controlling things, and the primary is still not up and running...
 You might be able to do the following to fix your login issue:
 1) Remove the UV server from the domain completely
2) Reboot
3) Re-join the UV server to the domain
4) Reboot
5) Check whatever UV uses (which I have no knowledge of) to login to the
domain and make sure its not a hardcoded hostname pointer kind of thing to
the domain controller that is not online.
 Like I said.  A wild guess, but, I've seen it work with other servers
and workstations when a "Primary Domain Controller" would fail and the
backup would pick up.  Don't ask me why...  I'm not a MCSE guy.
 On Thu, Sep 15, 2011 at 1:03 PM, David Wolverton 
wrote:
 > If I log into the actual server after logging in as a "LOCAL" user, the
UV
> Shell starts up.
>
> If I log into the actual server after logging in as a "DOMAIN" user, the
UV
> Shell just hangs.
>
> This is after MANY reboots, so I know the UniVerse services are cleanly
> restarted.
>
>
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
> Sent: Thursday, September 15, 2011 11:57 AM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] UniVerse 10.3 with Domain Controller Failure
>
>
> Local login script on Universe is doing something funky.
> Try to connect using the Universe Shell application directly on the UV
> server in the computer room, not locally from your PC
>
>
>
>
>
>
> -Original Message-
> From: David Wolverton 
> To: 'U2 Users List' 
> Sent: Thu, Sep 15, 2011 9:51 am
> Subject: [U2] UniVerse 10.3 with Domain Controller Failure
>
>
> The domain controller failed. The Backup took over.
> Universe 10.3 appears to hang on login - just dead.
> UniData on the same site (on another server) hangs f

Re: [U2] UniVerse 10.3 with Domain Controller Failure

[David Wolverton]

Correct -- the screen opens and what you would normally see next is the
UniVerse 'banner' - the cursor just blinks...  Nothing.

But the 'shell screen' is 'open' and 'trying' to connect.

And for DNS -- if the other applications were 'dead' as well on the machine,
again, I'd suspect something 'outside' -- But it's sounding more like a
Rocket support call than anything, so may have to ask the vendor to see what
they say.



-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Thursday, September 15, 2011 12:29 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] UniVerse 10.3 with Domain Controller Failure


What exactly do you mean by the statement that uvshell "hangs"
Do you mean it opens the uvshell application but will not give you any
message at all?  so its just a blank gray screen?
Or do you mean it won't even open the application window?

If you can run uvshell as a local user, can you LISTU to see if the default
background processes are running?
I mean the uvdlock, the phantom processer, the console, etc






-Original Message-
From: John Thompson 
To: U2 Users List 
Sent: Thu, Sep 15, 2011 10:19 am
Subject: Re: [U2] UniVerse 10.3 with Domain Controller Failure


Perhaps the Domain Controller that failed also had DNS running on it?
Perhaps its a DNS issue... you say one Unidata server takes a while and
inally logs in...
Another shot in the dark.
On Thu, Sep 15, 2011 at 1:15 PM, David Wolverton  wrote:
> See, I would suspect something like this as well, but the %LOGONSERVER% is
 'up', and Great Plains running on the same server as the UniVerse server is
 working A-OK.  (I hate the fact they have 3 different databases on this
 machine, but it is illustrative that it's 'only UniVerse' as both the Great
 Plains and the Oracle databases are running without a glitch since the
 failover, so I'm looking at what I can do to 'fix' Universe.)

 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson
 Sent: Thursday, September 15, 2011 12:11 PM
 To: U2 Users List
 Subject: Re: [U2] UniVerse 10.3 with Domain Controller Failure

 This is a wild guess...  So my disclaimer is, "Try at your own risk"

 Part of my hatred for Windows Active Directory resides with this very
 issue,
 but, I digress...

 I have seen servers and workstations not talk to the backup domain
 controller before, especially after a primary domain controller failure.

 SO, IF, the Primary Domain Controller has failed... and the Backup is now
 controlling things, and the primary is still not up and running...

 You might be able to do the following to fix your login issue:

 1) Remove the UV server from the domain completely
 2) Reboot
 3) Re-join the UV server to the domain
 4) Reboot
 5) Check whatever UV uses (which I have no knowledge of) to login to the
 domain and make sure its not a hardcoded hostname pointer kind of thing to
 the domain controller that is not online.

 Like I said.  A wild guess, but, I've seen it work with other servers
 and workstations when a "Primary Domain Controller" would fail and the
 backup would pick up.  Don't ask me why...  I'm not a MCSE guy.

 On Thu, Sep 15, 2011 at 1:03 PM, David Wolverton 
 wrote:

 > If I log into the actual server after logging in as a "LOCAL" user, the
 UV
 > Shell starts up.
 >
 > If I log into the actual server after logging in as a "DOMAIN" user, the
 UV
 > Shell just hangs.
 >
 > This is after MANY reboots, so I know the UniVerse services are cleanly
 > restarted.
 >
 >
 > -Original Message-
 > From: u2-users-boun...@listserver.u2ug.org
 > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
 > Sent: Thursday, September 15, 2011 11:57 AM
 > To: u2-users@listserver.u2ug.org
 > Subject: Re: [U2] UniVerse 10.3 with Domain Controller Failure
 >
 >
 > Local login script on Universe is doing something funky.
 > Try to connect using the Universe Shell application directly on the UV
 > server in the computer room, not locally from your PC
 >
 >
 >
 >
 >
 >
 > -Original Message-
 > From: David Wolverton 
 > To: 'U2 Users List' 
 > Sent: Thu, Sep 15, 2011 9:51 am
 > Subject: [U2] UniVerse 10.3 with Domain Controller Failure
 >
 >
 > The domain controller failed. The Backup took over.
 > Universe 10.3 appears to hang on login - just dead.
 > UniData on the same site (on another server) hangs for a moment and
 > complains', but completes the login and runs correctly - so it appears
 that
 > t 'finds' the backup controller.
 > What's the story with UniVerse?
 > One other piece:  There are TWO BDCs, the UniVerse box appears to look at
 > ne (as do other machines) while the UniData box looks at another (as do
 > ther machines there) -- UniData and UniVerse are the ONLY applications
 > hrowing issues right now -- all other items (SQL Server, Great Plains,
 etc)
 > eem to be hummi

Re: [U2] UniVerse 10.3 with Domain Controller Failure

[Wjhonson]

What exactly do you mean by the statement that uvshell "hangs"
Do you mean it opens the uvshell application but will not give you any message 
at all?  so its just a blank gray screen?
Or do you mean it won't even open the application window?

If you can run uvshell as a local user, can you LISTU to see if the default 
background processes are running?
I mean the uvdlock, the phantom processer, the console, etc






-Original Message-
From: John Thompson 
To: U2 Users List 
Sent: Thu, Sep 15, 2011 10:19 am
Subject: Re: [U2] UniVerse 10.3 with Domain Controller Failure


Perhaps the Domain Controller that failed also had DNS running on it?
Perhaps its a DNS issue... you say one Unidata server takes a while and
inally logs in...
Another shot in the dark.
On Thu, Sep 15, 2011 at 1:15 PM, David Wolverton  wrote:
> See, I would suspect something like this as well, but the %LOGONSERVER% is
 'up', and Great Plains running on the same server as the UniVerse server is
 working A-OK.  (I hate the fact they have 3 different databases on this
 machine, but it is illustrative that it's 'only UniVerse' as both the Great
 Plains and the Oracle databases are running without a glitch since the
 failover, so I'm looking at what I can do to 'fix' Universe.)

 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson
 Sent: Thursday, September 15, 2011 12:11 PM
 To: U2 Users List
 Subject: Re: [U2] UniVerse 10.3 with Domain Controller Failure

 This is a wild guess...  So my disclaimer is, "Try at your own risk"

 Part of my hatred for Windows Active Directory resides with this very
 issue,
 but, I digress...

 I have seen servers and workstations not talk to the backup domain
 controller before, especially after a primary domain controller failure.

 SO, IF, the Primary Domain Controller has failed... and the Backup is now
 controlling things, and the primary is still not up and running...

 You might be able to do the following to fix your login issue:

 1) Remove the UV server from the domain completely
 2) Reboot
 3) Re-join the UV server to the domain
 4) Reboot
 5) Check whatever UV uses (which I have no knowledge of) to login to the
 domain and make sure its not a hardcoded hostname pointer kind of thing to
 the domain controller that is not online.

 Like I said.  A wild guess, but, I've seen it work with other servers
 and workstations when a "Primary Domain Controller" would fail and the
 backup would pick up.  Don't ask me why...  I'm not a MCSE guy.

 On Thu, Sep 15, 2011 at 1:03 PM, David Wolverton 
 wrote:

 > If I log into the actual server after logging in as a "LOCAL" user, the
 UV
 > Shell starts up.
 >
 > If I log into the actual server after logging in as a "DOMAIN" user, the
 UV
 > Shell just hangs.
 >
 > This is after MANY reboots, so I know the UniVerse services are cleanly
 > restarted.
 >
 >
 > -Original Message-
 > From: u2-users-boun...@listserver.u2ug.org
 > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
 > Sent: Thursday, September 15, 2011 11:57 AM
 > To: u2-users@listserver.u2ug.org
 > Subject: Re: [U2] UniVerse 10.3 with Domain Controller Failure
 >
 >
 > Local login script on Universe is doing something funky.
 > Try to connect using the Universe Shell application directly on the UV
 > server in the computer room, not locally from your PC
 >
 >
 >
 >
 >
 >
 > -Original Message-
 > From: David Wolverton 
 > To: 'U2 Users List' 
 > Sent: Thu, Sep 15, 2011 9:51 am
 > Subject: [U2] UniVerse 10.3 with Domain Controller Failure
 >
 >
 > The domain controller failed. The Backup took over.
 > Universe 10.3 appears to hang on login - just dead.
 > UniData on the same site (on another server) hangs for a moment and
 > complains', but completes the login and runs correctly - so it appears
 that
 > t 'finds' the backup controller.
 > What's the story with UniVerse?
 > One other piece:  There are TWO BDCs, the UniVerse box appears to look at
 > ne (as do other machines) while the UniData box looks at another (as do
 > ther machines there) -- UniData and UniVerse are the ONLY applications
 > hrowing issues right now -- all other items (SQL Server, Great Plains,
 etc)
 > eem to be humming along.
 > Thoughts appreciated!
 >
 >
 > __
 > 2-Users mailing list
 > 2-us...@listserver.u2ug.org
 > ttp://listserver.u2ug.org/mailman/listinfo/u2-users
 >
 > ___
 > U2-Users mailing list
 > U2-Users@listserver.u2ug.org
 > http://listserver.u2ug.org/mailman/listinfo/u2-users
 >
 >
 > ___
 > U2-Users mailing list
 > U2-Users@listserver.u2ug.org
 > http://listserver.u2ug.org/mailman/listinfo/u2-users
 >



 --
 John Thompson
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/lis

Re: [U2] UniVerse 10.3 with Domain Controller Failure

[John Thompson]

Perhaps the Domain Controller that failed also had DNS running on it?

Perhaps its a DNS issue... you say one Unidata server takes a while and
finally logs in...

Another shot in the dark.

On Thu, Sep 15, 2011 at 1:15 PM, David Wolverton  wrote:

> See, I would suspect something like this as well, but the %LOGONSERVER% is
> 'up', and Great Plains running on the same server as the UniVerse server is
> working A-OK.  (I hate the fact they have 3 different databases on this
> machine, but it is illustrative that it's 'only UniVerse' as both the Great
> Plains and the Oracle databases are running without a glitch since the
> failover, so I'm looking at what I can do to 'fix' Universe.)
>
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson
> Sent: Thursday, September 15, 2011 12:11 PM
> To: U2 Users List
> Subject: Re: [U2] UniVerse 10.3 with Domain Controller Failure
>
> This is a wild guess...  So my disclaimer is, "Try at your own risk"
>
> Part of my hatred for Windows Active Directory resides with this very
> issue,
> but, I digress...
>
> I have seen servers and workstations not talk to the backup domain
> controller before, especially after a primary domain controller failure.
>
> SO, IF, the Primary Domain Controller has failed... and the Backup is now
> controlling things, and the primary is still not up and running...
>
> You might be able to do the following to fix your login issue:
>
> 1) Remove the UV server from the domain completely
> 2) Reboot
> 3) Re-join the UV server to the domain
> 4) Reboot
> 5) Check whatever UV uses (which I have no knowledge of) to login to the
> domain and make sure its not a hardcoded hostname pointer kind of thing to
> the domain controller that is not online.
>
> Like I said.  A wild guess, but, I've seen it work with other servers
> and workstations when a "Primary Domain Controller" would fail and the
> backup would pick up.  Don't ask me why...  I'm not a MCSE guy.
>
> On Thu, Sep 15, 2011 at 1:03 PM, David Wolverton 
> wrote:
>
> > If I log into the actual server after logging in as a "LOCAL" user, the
> UV
> > Shell starts up.
> >
> > If I log into the actual server after logging in as a "DOMAIN" user, the
> UV
> > Shell just hangs.
> >
> > This is after MANY reboots, so I know the UniVerse services are cleanly
> > restarted.
> >
> >
> > -Original Message-
> > From: u2-users-boun...@listserver.u2ug.org
> > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
> > Sent: Thursday, September 15, 2011 11:57 AM
> > To: u2-users@listserver.u2ug.org
> > Subject: Re: [U2] UniVerse 10.3 with Domain Controller Failure
> >
> >
> > Local login script on Universe is doing something funky.
> > Try to connect using the Universe Shell application directly on the UV
> > server in the computer room, not locally from your PC
> >
> >
> >
> >
> >
> >
> > -Original Message-
> > From: David Wolverton 
> > To: 'U2 Users List' 
> > Sent: Thu, Sep 15, 2011 9:51 am
> > Subject: [U2] UniVerse 10.3 with Domain Controller Failure
> >
> >
> > The domain controller failed. The Backup took over.
> > Universe 10.3 appears to hang on login - just dead.
> > UniData on the same site (on another server) hangs for a moment and
> > complains', but completes the login and runs correctly - so it appears
> that
> > t 'finds' the backup controller.
> > What's the story with UniVerse?
> > One other piece:  There are TWO BDCs, the UniVerse box appears to look at
> > ne (as do other machines) while the UniData box looks at another (as do
> > ther machines there) -- UniData and UniVerse are the ONLY applications
> > hrowing issues right now -- all other items (SQL Server, Great Plains,
> etc)
> > eem to be humming along.
> > Thoughts appreciated!
> >
> >
> > __
> > 2-Users mailing list
> > 2-us...@listserver.u2ug.org
> > ttp://listserver.u2ug.org/mailman/listinfo/u2-users
> >
> > ___
> > U2-Users mailing list
> > U2-Users@listserver.u2ug.org
> > http://listserver.u2ug.org/mailman/listinfo/u2-users
> >
> >
> > ___
> > U2-Users mailing list
> > U2-Users@listserver.u2ug.org
> > http://listserver.u2ug.org/mailman/listinfo/u2-users
> >
>
>
>
> --
> John Thompson
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>
>
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>



-- 
John Thompson
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] UniVerse 10.3 with Domain Controller Failure

[David Wolverton]

See, I would suspect something like this as well, but the %LOGONSERVER% is
'up', and Great Plains running on the same server as the UniVerse server is
working A-OK.  (I hate the fact they have 3 different databases on this
machine, but it is illustrative that it's 'only UniVerse' as both the Great
Plains and the Oracle databases are running without a glitch since the
failover, so I'm looking at what I can do to 'fix' Universe.)

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson
Sent: Thursday, September 15, 2011 12:11 PM
To: U2 Users List
Subject: Re: [U2] UniVerse 10.3 with Domain Controller Failure

This is a wild guess...  So my disclaimer is, "Try at your own risk"

Part of my hatred for Windows Active Directory resides with this very issue,
but, I digress...

I have seen servers and workstations not talk to the backup domain
controller before, especially after a primary domain controller failure.

SO, IF, the Primary Domain Controller has failed... and the Backup is now
controlling things, and the primary is still not up and running...

You might be able to do the following to fix your login issue:

1) Remove the UV server from the domain completely
2) Reboot
3) Re-join the UV server to the domain
4) Reboot
5) Check whatever UV uses (which I have no knowledge of) to login to the
domain and make sure its not a hardcoded hostname pointer kind of thing to
the domain controller that is not online.

Like I said.  A wild guess, but, I've seen it work with other servers
and workstations when a "Primary Domain Controller" would fail and the
backup would pick up.  Don't ask me why...  I'm not a MCSE guy.

On Thu, Sep 15, 2011 at 1:03 PM, David Wolverton  wrote:

> If I log into the actual server after logging in as a "LOCAL" user, the UV
> Shell starts up.
>
> If I log into the actual server after logging in as a "DOMAIN" user, the
UV
> Shell just hangs.
>
> This is after MANY reboots, so I know the UniVerse services are cleanly
> restarted.
>
>
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
> Sent: Thursday, September 15, 2011 11:57 AM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] UniVerse 10.3 with Domain Controller Failure
>
>
> Local login script on Universe is doing something funky.
> Try to connect using the Universe Shell application directly on the UV
> server in the computer room, not locally from your PC
>
>
>
>
>
>
> -Original Message-
> From: David Wolverton 
> To: 'U2 Users List' 
> Sent: Thu, Sep 15, 2011 9:51 am
> Subject: [U2] UniVerse 10.3 with Domain Controller Failure
>
>
> The domain controller failed. The Backup took over.
> Universe 10.3 appears to hang on login - just dead.
> UniData on the same site (on another server) hangs for a moment and
> complains', but completes the login and runs correctly - so it appears
that
> t 'finds' the backup controller.
> What's the story with UniVerse?
> One other piece:  There are TWO BDCs, the UniVerse box appears to look at
> ne (as do other machines) while the UniData box looks at another (as do
> ther machines there) -- UniData and UniVerse are the ONLY applications
> hrowing issues right now -- all other items (SQL Server, Great Plains,
etc)
> eem to be humming along.
> Thoughts appreciated!
>
>
> __
> 2-Users mailing list
> 2-us...@listserver.u2ug.org
> ttp://listserver.u2ug.org/mailman/listinfo/u2-users
>
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>
>
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>



-- 
John Thompson
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] UniVerse 10.3 with Domain Controller Failure

[John Thompson]

This is a wild guess...  So my disclaimer is, "Try at your own risk"

Part of my hatred for Windows Active Directory resides with this very issue,
but, I digress...

I have seen servers and workstations not talk to the backup domain
controller before, especially after a primary domain controller failure.

SO, IF, the Primary Domain Controller has failed... and the Backup is now
controlling things, and the primary is still not up and running...

You might be able to do the following to fix your login issue:

1) Remove the UV server from the domain completely
2) Reboot
3) Re-join the UV server to the domain
4) Reboot
5) Check whatever UV uses (which I have no knowledge of) to login to the
domain and make sure its not a hardcoded hostname pointer kind of thing to
the domain controller that is not online.

Like I said.  A wild guess, but, I've seen it work with other servers
and workstations when a "Primary Domain Controller" would fail and the
backup would pick up.  Don't ask me why...  I'm not a MCSE guy.

On Thu, Sep 15, 2011 at 1:03 PM, David Wolverton  wrote:

> If I log into the actual server after logging in as a "LOCAL" user, the UV
> Shell starts up.
>
> If I log into the actual server after logging in as a "DOMAIN" user, the UV
> Shell just hangs.
>
> This is after MANY reboots, so I know the UniVerse services are cleanly
> restarted.
>
>
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
> Sent: Thursday, September 15, 2011 11:57 AM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] UniVerse 10.3 with Domain Controller Failure
>
>
> Local login script on Universe is doing something funky.
> Try to connect using the Universe Shell application directly on the UV
> server in the computer room, not locally from your PC
>
>
>
>
>
>
> -Original Message-
> From: David Wolverton 
> To: 'U2 Users List' 
> Sent: Thu, Sep 15, 2011 9:51 am
> Subject: [U2] UniVerse 10.3 with Domain Controller Failure
>
>
> The domain controller failed. The Backup took over.
> Universe 10.3 appears to hang on login - just dead.
> UniData on the same site (on another server) hangs for a moment and
> complains', but completes the login and runs correctly - so it appears that
> t 'finds' the backup controller.
> What's the story with UniVerse?
> One other piece:  There are TWO BDCs, the UniVerse box appears to look at
> ne (as do other machines) while the UniData box looks at another (as do
> ther machines there) -- UniData and UniVerse are the ONLY applications
> hrowing issues right now -- all other items (SQL Server, Great Plains, etc)
> eem to be humming along.
> Thoughts appreciated!
>
>
> __
> 2-Users mailing list
> 2-us...@listserver.u2ug.org
> ttp://listserver.u2ug.org/mailman/listinfo/u2-users
>
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>
>
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>



-- 
John Thompson
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] UniVerse 10.3 with Domain Controller Failure

[David Wolverton]

If I log into the actual server after logging in as a "LOCAL" user, the UV
Shell starts up.

If I log into the actual server after logging in as a "DOMAIN" user, the UV
Shell just hangs.

This is after MANY reboots, so I know the UniVerse services are cleanly
restarted. 


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Thursday, September 15, 2011 11:57 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] UniVerse 10.3 with Domain Controller Failure


Local login script on Universe is doing something funky.
Try to connect using the Universe Shell application directly on the UV
server in the computer room, not locally from your PC






-Original Message-
From: David Wolverton 
To: 'U2 Users List' 
Sent: Thu, Sep 15, 2011 9:51 am
Subject: [U2] UniVerse 10.3 with Domain Controller Failure


The domain controller failed. The Backup took over.
Universe 10.3 appears to hang on login - just dead.
UniData on the same site (on another server) hangs for a moment and
complains', but completes the login and runs correctly - so it appears that
t 'finds' the backup controller.
What's the story with UniVerse?
One other piece:  There are TWO BDCs, the UniVerse box appears to look at
ne (as do other machines) while the UniData box looks at another (as do
ther machines there) -- UniData and UniVerse are the ONLY applications
hrowing issues right now -- all other items (SQL Server, Great Plains, etc)
eem to be humming along.
Thoughts appreciated!


__
2-Users mailing list
2-us...@listserver.u2ug.org
ttp://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] UniVerse 10.3 with Domain Controller Failure

[Wjhonson]

Local login script on Universe is doing something funky.
Try to connect using the Universe Shell application directly on the UV server 
in the computer room, not locally from your PC






-Original Message-
From: David Wolverton 
To: 'U2 Users List' 
Sent: Thu, Sep 15, 2011 9:51 am
Subject: [U2] UniVerse 10.3 with Domain Controller Failure


The domain controller failed. The Backup took over.
Universe 10.3 appears to hang on login - just dead.
UniData on the same site (on another server) hangs for a moment and
complains', but completes the login and runs correctly - so it appears that
t 'finds' the backup controller.
What's the story with UniVerse?
One other piece:  There are TWO BDCs, the UniVerse box appears to look at
ne (as do other machines) while the UniData box looks at another (as do
ther machines there) -- UniData and UniVerse are the ONLY applications
hrowing issues right now -- all other items (SQL Server, Great Plains, etc)
eem to be humming along.
Thoughts appreciated!


__
2-Users mailing list
2-us...@listserver.u2ug.org
ttp://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] UniVerse 10.3 with Domain Controller Failure

[Jeff Schasny]

I'd try stopping and restarting Universe.

David Wolverton wrote:

The domain controller failed. The Backup took over.

Universe 10.3 appears to hang on login - just dead.

UniData on the same site (on another server) hangs for a moment and
'complains', but completes the login and runs correctly - so it appears that
it 'finds' the backup controller.

What's the story with UniVerse?

One other piece:  There are TWO BDCs, the UniVerse box appears to look at
one (as do other machines) while the UniData box looks at another (as do
other machines there) -- UniData and UniVerse are the ONLY applications
throwing issues right now -- all other items (SQL Server, Great Plains, etc)
seem to be humming along.

Thoughts appreciated!




___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

  


--

Jeff Schasny - Denver, Co, USA
jschasny at gmail dot com

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

[U2] UniVerse 10.3 with Domain Controller Failure

[David Wolverton]

The domain controller failed. The Backup took over.

Universe 10.3 appears to hang on login - just dead.

UniData on the same site (on another server) hangs for a moment and
'complains', but completes the login and runs correctly - so it appears that
it 'finds' the backup controller.

What's the story with UniVerse?

One other piece:  There are TWO BDCs, the UniVerse box appears to look at
one (as do other machines) while the UniData box looks at another (as do
other machines there) -- UniData and UniVerse are the ONLY applications
throwing issues right now -- all other items (SQL Server, Great Plains, etc)
seem to be humming along.

Thoughts appreciated!




___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] I-type Subvalue question

[Charles Stevenson]

Bob,
Here is an example.
Suppose US phone numbers stored as
 123-456-7890   (area code 123)
or 123-4567   (area code 'unk'nown)

DICT ... AREA.CODE
01: I
02: PHONE; COUNT( @, '-' ); IF @ > 1 THEN @1[ '-', 1, 1] ELSE 'unk'
same as
02: PHONE; COUNT( @1, '-' );  IF @2 > 1 THEN @1[ '-',1,1] ELSE 'unk'

Not the best algorithm, but it illustrates.


Wols,

You gotta give an example,  of a nested I-descriptor successfully 
referencing another with multiple ";"-separated expressions.


cds

On 9/15/2011 11:18 AM, Woodward, Bob wrote:

Wait a minute... How do you point to the previous expression?  @<-1>

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists
Sent: Thursday, September 15, 2011 9:05 AM
To: U2 Users List
Subject: Re: [U2] I-type Subvalue question

On 15/09/11 14:38, Charles Stevenson wrote:

Allows you to reference this I-descriptor from another I-descriptor
in the future.
UV doesn't let you do that if there are multiple expressions
separated by semi-colons.
There is no good reason for that restriction other than internal,
how it was implemented.

I think Prime might have had the same restriction. But it's because UV
doesn't reference one I-descriptor from another, it expands it and all
the @s end up pointing to the wrong place. Actually, so if your @ merely
points at the previous expression, it should work. It's as soon as you
use @1 @2 etc that it'll blow up.

Cheers,
Wol



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] I-type Subvalue question

[Wjhonson]

To expand and clarify
The first expression is 1
The second expression is 2
There are no negative values used






-Original Message-
From: Charles Stevenson 
To: U2 Users List 
Sent: Thu, Sep 15, 2011 9:33 am
Subject: Re: [U2] I-type Subvalue question


@  w/o a number means previous expression.
hese 2 mean the same thing:
TRANS('ORDERS', ORDKEY, LINES, 'X'); @<1,1,2>
TRANS('ORDERS', ORDKEY, LINES, 'X'); @1<1,1,2>

On 9/15/2011 11:18 AM, Woodward, Bob wrote:
 Wait a minute... How do you point to the previous expression?  @<-1>

 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists
 Sent: Thursday, September 15, 2011 9:05 AM
 To: U2 Users List
 Subject: Re: [U2] I-type Subvalue question

 On 15/09/11 14:38, Charles Stevenson wrote:
> Allows you to reference this I-descriptor from another I-descriptor
> in the future.
> UV doesn't let you do that if there are multiple expressions
> separated by semi-colons.
> There is no good reason for that restriction other than internal,
> how it was implemented.
 I think Prime might have had the same restriction. But it's because UV
 doesn't reference one I-descriptor from another, it expands it and all
 the @s end up pointing to the wrong place. Actually, so if your @ merely
 points at the previous expression, it should work. It's as soon as you
 use @1 @2 etc that it'll blow up.

 Cheers,
 Wol
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users

___
2-Users mailing list
2-us...@listserver.u2ug.org
ttp://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] I-type Subvalue question

[Charles Stevenson]

@  w/o a number means previous expression.
These 2 mean the same thing:

   TRANS('ORDERS', ORDKEY, LINES, 'X'); @<1,1,2>

   TRANS('ORDERS', ORDKEY, LINES, 'X'); @1<1,1,2>



On 9/15/2011 11:18 AM, Woodward, Bob wrote:

Wait a minute... How do you point to the previous expression?  @<-1>

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists
Sent: Thursday, September 15, 2011 9:05 AM
To: U2 Users List
Subject: Re: [U2] I-type Subvalue question

On 15/09/11 14:38, Charles Stevenson wrote:

Allows you to reference this I-descriptor from another I-descriptor
in the future.
UV doesn't let you do that if there are multiple expressions
separated by semi-colons.
There is no good reason for that restriction other than internal,
how it was implemented.

I think Prime might have had the same restriction. But it's because UV
doesn't reference one I-descriptor from another, it expands it and all
the @s end up pointing to the wrong place. Actually, so if your @ merely
points at the previous expression, it should work. It's as soon as you
use @1 @2 etc that it'll blow up.

Cheers,
Wol
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] UniOleDB / UniODBC / HS.ADMIN

[Alspach, Vance]

On the same topic, we are trying to return 5 million rows, but the select fails 
at about 2 million rows.

Is there a limitation on how many rows can be returned through UniOleDB or 
through the UniRPC service?


Uniiverse 10.2.4
AIX Unix 5.3

We have been using UniODBC to run our DTS jobs (to our DataWarehouse) since 
before I began working here.  I have been told by our VAR that our setup is not 
typical.  We are now attempting to change from UniODBC to UniOleDB using SSIS.

The problem that I am encountering is the SQL statement will not recognize the 
visible files in the same manner.  We have a file MO-GL-DET and using ODBC, we 
have to refer to the file as MO_GL_DET in the SQL statement.  But with the 
OleDB connection the file does not exist.  I created a new voc (alias) without 
the hyphens (MOGLDET) and everything works (even without running 
HS.UPDATE.FILEINFO).

I have been unable locate any documentation regarding UniOleDB and file name 
constraints.

Has anybody else discovered similar discrepancies?

Vance



CONFIDENTIALITY. This electronic mail and any files transmitted with it may 
contain information proprietary to Deere & Company, or one of its subsidiaries 
or affiliates, and are intended solely for the use of the individual or entity 
to whom they are addressed, shall be maintained in confidence and not disclosed 
to third parties without the written consent of the sender. If you are not the 
intended recipient or the person responsible for delivering the electronic mail 
to the intended recipient, be advised that you have received this electronic 
mail in error and that any use, dissemination, forwarding, printing, or copying 
of this electronic mail is strictly prohibited. If you have received this 
electronic mail in error, please immediately notify the sender by return mail.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] I-type Subvalue question

[Woodward, Bob]

Wait a minute... How do you point to the previous expression?  @<-1>

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists
Sent: Thursday, September 15, 2011 9:05 AM
To: U2 Users List
Subject: Re: [U2] I-type Subvalue question

On 15/09/11 14:38, Charles Stevenson wrote:
> Allows you to reference this I-descriptor from another I-descriptor
>in the future.
>UV doesn't let you do that if there are multiple expressions
>separated by semi-colons.
>There is no good reason for that restriction other than internal,
>how it was implemented.

I think Prime might have had the same restriction. But it's because UV
doesn't reference one I-descriptor from another, it expands it and all
the @s end up pointing to the wrong place. Actually, so if your @ merely
points at the previous expression, it should work. It's as soon as you
use @1 @2 etc that it'll blow up.

Cheers,
Wol
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] I-type Subvalue question

[Wols Lists]

On 15/09/11 14:38, Charles Stevenson wrote:
> Allows you to reference this I-descriptor from another I-descriptor
>in the future.
>UV doesn't let you do that if there are multiple expressions
>separated by semi-colons.
>There is no good reason for that restriction other than internal,
>how it was implemented.

I think Prime might have had the same restriction. But it's because UV
doesn't reference one I-descriptor from another, it expands it and all
the @s end up pointing to the wrong place. Actually, so if your @ merely
points at the previous expression, it should work. It's as soon as you
use @1 @2 etc that it'll blow up.

Cheers,
Wol
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] I-type Subvalue question

[John Thompson]

Thanks for the info.  Good to know.

On Thu, Sep 15, 2011 at 9:38 AM, Charles Stevenson  wrote:

> Likewise, late in the day, but on UniVerse, to extract the (lowered) 2nd
> value,
> instead of:
>  TRANS('ORDERS', ORDKEY, LINES, 'X')*_; @_*<1,1,2>
> do:
>  TRANS('ORDERS', ORDKEY, LINES, 'X')<1,1,2>
>
> Reason:
>
>   Allows you to reference this I-descriptor from another I-descriptor
>   in the future.
>   UV doesn't let you do that if there are multiple expressions
>   separated by semi-colons.
>   There is no good reason for that restriction other than internal,
>   how it was implemented.
>
>
>
>
> On 9/14/2011 7:14 PM, Kebbon Irwin wrote:
>
>> I know this is a little late in the conversation, but in Unidata you can
>> specify the value in the return code portion of the TRANS function -
>> TRANS('ORDERS', ORDKEY, LINES, 'X2') will return the second value of the
>> LINES attr in ORDERS.
>> HTH,
>> Kebbon
>>
>
> __**_
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/**mailman/listinfo/u2-users
>



-- 
John Thompson
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] I-type Subvalue question

[Charles Stevenson]

Likewise, late in the day, but on UniVerse, to extract the (lowered) 2nd 
value,

instead of:
  TRANS('ORDERS', ORDKEY, LINES, 'X')*_; @_*<1,1,2>
do:
  TRANS('ORDERS', ORDKEY, LINES, 'X')<1,1,2>

Reason:

   Allows you to reference this I-descriptor from another I-descriptor
   in the future.
   UV doesn't let you do that if there are multiple expressions
   separated by semi-colons.
   There is no good reason for that restriction other than internal,
   how it was implemented.



On 9/14/2011 7:14 PM, Kebbon Irwin wrote:

I know this is a little late in the conversation, but in Unidata you can 
specify the value in the return code portion of the TRANS function - 
TRANS('ORDERS', ORDKEY, LINES, 'X2') will return the second value of the LINES 
attr in ORDERS.
HTH,
Kebbon


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] [UV][AIX] System Management and Performance Tools

[John Thompson]

Perhaps some help...

Here is something from Rocket I just found:

http://www.rocketsoftware.com/u2/resources/media-casts/webinars/tuning-u2-on-unix.html

On Thu, Sep 15, 2011 at 9:32 AM, ggayathri  wrote:

>
> Hi Dan,
>
> I happened to read an old post of yours. I am in need of some help in
> performance analysis of UV database running on AIX and tuning it. Can you
> please help me?
>
> G
>
> Dan Fitzgerald wrote:
> >
> >
> > Look at nmon; I run it from cron, then email it to myself after midnight.
> > I also have bunches of scripts that run - some every 5 seconds, to notify
> > me if, say, paging space usage on any system exceeds 30%, file systems
> > exceed 85% full, passwords change, sudo is invoked, hosts, hosts.equiv,
> > cron, etc., changes.
> >
> > One useful thing to look at is vmstat -v | grep block. If you see the
> > values there changing over time, you'll need to do some tweaking. This is
> > part of the nmon output, so you can track it over time easily, if you use
> > nmon. Manually, try it an hour apart. if no changes, try 24 hours. keep
> > the output around, and when you're experiencing a heavy load, look again.
> > It resets to zero at boot, so big numbers mean something has happened in
> > the past (or you haven't rebooted in far too long).
> >
> > I have Mark's Hitchhiker's guide series (backed up in 6 or 7 places), but
> > I'd need his permission to send 'em. Mark? I know that when U2 was IBM,
> > whether or not Mark got to publish such over-the-top useful articles
> > depended on how many people downloaded them. Reading and understanding
> > even a few sentences any of Mark's articles makes you an instant SME, and
> > guarantees that your capability to add value is enhanced. If you come
> > across them, download them, and ask Rocket for more. More. MORE! With the
> > exception of Clif Oliver and possibly one or two others, Mark is like
> Hank
> > Williams in Leonard Cohen's "Tower of Song" - a hundred floors above us.
> >
> > Two other authors I've found useful you may want to search on are Ken
> > Milberg & Jaqui Lynch; both deal with AIX tuning. Be sure to be looking
> at
> > AIX 5.3; there were some major changes to AIX tuning between 5.1 & 5.3,
> > and some of those changes are a 180 degree change (for example, maxperm,
> > maxclient, and lru_file_repage).
> >
> > You can find a lot of the new settings in /etc/tunables/lastboot.
> >
> > I've found the truss command to be amazingly helpful, but you have to
> have
> > some understanding of system calls & error messages in order to interpret
> > it. It captures all of the system calls made by a process (the -f option
> > follows all of the forks, as well). Even without knowing what each system
> > call does, you can see if it's hanging, looping, waiting, etc.
> >
> > svmon is a good tool; svmon -U will tell you more than you want to know
> > about each user's memory map.
> >
> > FILE.USAGE is a very powerful tool in UV. It has some impact on
> > performance if you run it for a lot of files.
> >
> > Having specialized in tuning U2 on AIX for a while, I have a few docs
> (How
> > to look at topas, tuning with ioo, vmo) that I need to update & cleanup,
> > and perhaps submit to Spectrum.
> >
> > Obviously, FAST (no relation) is an excellent tool.
> >
> >  I occasionally moonlight remotely, and as I mentioned, tuning UV on
> > AIX is my specialty niche. I bring a program that exports ANALYSE.FILE
> > data & runs some analytics into an .xls file, from which we can target
> > your most poorly sized hashed files, in addition to 20 years in U2 & 15+
> > years in AIX. Usually, with the tools and knowledge transfer I leave
> > behind, you won't feel the need for outside help again.
> >
> >> From: stuart.boyd...@spotless.com.au
> >> To: u2-users@listserver.u2ug.org
> >> Date: Thu, 20 Jan 2011 16:03:36 -0800
> >> Subject: [U2] [UV][AIX] System Management and Performance Tools
> >>
> >> Hi,
> >> Just wondering if anyone has any recommendations for systems
> >> monitoring/management tools for aix5.3/uv10.2.4. I've seen occasional
> >> discussions on the topic here over the years.
> >> Ideally, what we would like to do is be able to track down those end of
> >> month type processes which bog the system down with CPU & IO bottlenecks
> >> during peak load periods.
> >> I suppose this could be done with something like topas, truss and
> >> PORT.STATUS but just wondering what is available.
> >> There was a tool called "DPMonitor" that looked like it could be
> suitable
> >> - does this exist in any form?
> >> Also, does anyone know if the "Travels with Mark: A Hitchhiker's Guide
> to
> >> the
> >> UniVerse<
> http://www.google.com/url?sa=t&source=web&cd=1&sqi=2&ved=0CBIQFjAA&url=http%3A%2F%2Fwww.mail-archive.com%2Fu2-users%40listserver.u2ug.org%2Fmsg13400.html&rct=j&q=dm-dw-dm-0512baldridge-i&ei=jMs4TavnI4mYvAOC0uiJCg&usg=AFQjCNGTQCWE14j2-XEP6lQSFjTnMi98Zg&cad=rja
> >"
> >> series on performance tuning is available anywhere. It was on the IBM
> >> dev

Re: [U2] [UV][AIX] System Management and Performance Tools

[ggayathri]

Hi Dan,

I happened to read an old post of yours. I am in need of some help in
performance analysis of UV database running on AIX and tuning it. Can you
please help me?

G

Dan Fitzgerald wrote:
> 
> 
> Look at nmon; I run it from cron, then email it to myself after midnight.
> I also have bunches of scripts that run - some every 5 seconds, to notify
> me if, say, paging space usage on any system exceeds 30%, file systems
> exceed 85% full, passwords change, sudo is invoked, hosts, hosts.equiv,
> cron, etc., changes.
>  
> One useful thing to look at is vmstat -v | grep block. If you see the
> values there changing over time, you'll need to do some tweaking. This is
> part of the nmon output, so you can track it over time easily, if you use
> nmon. Manually, try it an hour apart. if no changes, try 24 hours. keep
> the output around, and when you're experiencing a heavy load, look again.
> It resets to zero at boot, so big numbers mean something has happened in
> the past (or you haven't rebooted in far too long).
>  
> I have Mark's Hitchhiker's guide series (backed up in 6 or 7 places), but
> I'd need his permission to send 'em. Mark? I know that when U2 was IBM,
> whether or not Mark got to publish such over-the-top useful articles
> depended on how many people downloaded them. Reading and understanding
> even a few sentences any of Mark's articles makes you an instant SME, and
> guarantees that your capability to add value is enhanced. If you come
> across them, download them, and ask Rocket for more. More. MORE! With the
> exception of Clif Oliver and possibly one or two others, Mark is like Hank
> Williams in Leonard Cohen's "Tower of Song" - a hundred floors above us.
>  
> Two other authors I've found useful you may want to search on are Ken
> Milberg & Jaqui Lynch; both deal with AIX tuning. Be sure to be looking at
> AIX 5.3; there were some major changes to AIX tuning between 5.1 & 5.3,
> and some of those changes are a 180 degree change (for example, maxperm,
> maxclient, and lru_file_repage).
>  
> You can find a lot of the new settings in /etc/tunables/lastboot.
>  
> I've found the truss command to be amazingly helpful, but you have to have
> some understanding of system calls & error messages in order to interpret
> it. It captures all of the system calls made by a process (the -f option
> follows all of the forks, as well). Even without knowing what each system
> call does, you can see if it's hanging, looping, waiting, etc.
>  
> svmon is a good tool; svmon -U will tell you more than you want to know
> about each user's memory map.
>  
> FILE.USAGE is a very powerful tool in UV. It has some impact on
> performance if you run it for a lot of files.
>  
> Having specialized in tuning U2 on AIX for a while, I have a few docs (How
> to look at topas, tuning with ioo, vmo) that I need to update & cleanup,
> and perhaps submit to Spectrum.
>  
> Obviously, FAST (no relation) is an excellent tool. 
>  
>  I occasionally moonlight remotely, and as I mentioned, tuning UV on
> AIX is my specialty niche. I bring a program that exports ANALYSE.FILE
> data & runs some analytics into an .xls file, from which we can target
> your most poorly sized hashed files, in addition to 20 years in U2 & 15+
> years in AIX. Usually, with the tools and knowledge transfer I leave
> behind, you won't feel the need for outside help again.
>  
>> From: stuart.boyd...@spotless.com.au
>> To: u2-users@listserver.u2ug.org
>> Date: Thu, 20 Jan 2011 16:03:36 -0800
>> Subject: [U2] [UV][AIX] System Management and Performance Tools
>> 
>> Hi,
>> Just wondering if anyone has any recommendations for systems
>> monitoring/management tools for aix5.3/uv10.2.4. I've seen occasional
>> discussions on the topic here over the years.
>> Ideally, what we would like to do is be able to track down those end of
>> month type processes which bog the system down with CPU & IO bottlenecks
>> during peak load periods.
>> I suppose this could be done with something like topas, truss and
>> PORT.STATUS but just wondering what is available.
>> There was a tool called "DPMonitor" that looked like it could be suitable
>> - does this exist in any form?
>> Also, does anyone know if the "Travels with Mark: A Hitchhiker's Guide to
>> the
>> UniVerse"
>> series on performance tuning is available anywhere. It was on the IBM
>> developerworks site but, no more.
>> 
>> All suggestions gratefully received.
>> Thanks in advance,
>> Stuart Boydell
>> 
>> 
>> 
>> 
>> 
>> ___
>> U2-Users mailing list
>> U2-Users@listserver.u2ug.org
>> http://listserver.u2ug.org/mailman/listinfo/u2-users
> 
> ___