RE: [U2] connection from UniBasic to a SQL database

2005-10-19 Thread Bob Witney
Kathy

This is how you do it

ODBC OpenLink Installation


The installation of ODBC multi-tier software requires the following steps;

Download the following files from the OpenLink website;

1.) Data Source Administrator  Samples(taz)(recommended)Web-based Data Source 
Administrator  JDBC Samples:
ftp://download.openlinksw.com/uda/open52/a5l5adzz.taz
 
2.) iODBC SDK(taz) (required):
ftp://download.openlinksw.com/uda/open52/a5ko.taz
 
3.) ODBC Client only (taz)(required):
ftp://download.openlinksw.com/uda/open52/a5oc.taz
 
4.) Request Broker (taz)(required):
ftp://download.openlinksw.com/uda/open52/a5br.taz
 
5.) SQLServer Database agent (taz)(required):
ftp://download.openlinksw.com/uda/open52/a5ammzzz.taz
 
6.) Unix Installation Shell Script (required):
ftp://download.openlinksw.com/uda/open52/install.sh 



Once you have download and place these file in the installation
Directory, perform the following steps:

a) Run the command below to install the new components in this location:
 
 sh install.sh
 
b) Run the following command to set the necessary OpenLink  environment 
variables for this installation:
 
 . ./openlink.sh
 
c) Place the OpenLink oplrqb.lic license file in the bin directory of  
the OpenLink directory.
 
d) Change directory to the 'bin' directory of your installation
   and run the command:
 
 ./oplrqb -fd   to run it in the debug mode on your terminal
 
or

 ./oplrqb -vto run it in detached mode

The -fd option should produce output of the following form:
 
 OpenLink Request Broker
 Version 2.41 as of Tue Feb 01 2005 (Release 5.2 cvsid 00076).
 Compiled for AIX 3 (powerpc-ibm-aix4.3.3.0-32)
 Copyright (C) OpenLink Software.
 
 Registered to OpenLink Internal Use
 with product serial number opl-internal
 Issued by OpenLink Data Access Support (UK)
 This license will expire on Wed Feb 01 18:00:00 2006 GMT
 
 oplrqb: using rulebook
 /dbs6/openlink/32bit/v52/tsuite/tmp/bin/oplrqb.ini
 oplrqb: bound UDP protocol to 0.0.0.0.60001
 oplrqb: bound TCP protocol to 0.0.0.0.5432
 oplrqb: using UDP address 192.168.11.114.0 for IPC
 oplrqb: request broker started by openlink
 oplrqb: spawning
 /dbs6/openlink/32bit/v52/tsuite/tmp/bin/w3config/www_sv www_sv
 +debug
 www_sv: started http://oplusaix2.usnet.private:8765
 oplrqb: started persistent www_sv (pid=30068)
 oplrqb: rendezvous thread started
 oplrqb: rendezvous registration SQLServer (oplusaix2)
 
 e) Assuming the www_sv persistence service is started successfully you should 
then be able to access it on the URL specified in the Broker start log above.
 
 d) You can then choose to configure a DSN to connection to SQLServer, either 
via the Admin Assitant interface or manually using the connection parameters 
oplrqb.ini and odbc.ini.


To configure the odbc.ini manually, set the following parameters to;


[OpenLink]
Driver  = /opt/OPENLINK/lib/oplodbc.so
ServerType  = SQLServer 2000
Username= tlogtest
Password= pa55word
Database= synopsys
Options = -S 172.16.0.34 -P 1434 -V 8.0
FetchBufferSize = 99
ReadOnly=
DeferLongFetch  =
Host= localhost:5000
Description = ODBC sqlserver
UseSSL  =
NoLoginBox  =
SqlDbmsName =


To configure the oplrqb.ini manually, set the following parameters to;

[Environment SQLSERVER]
FREETDSCONF= /opt/OPENLINK/bin/freetds.conf
DSQUERY= SQLSERVER  ; Load this section from freetds.conf
TDSHOST= sql2   ; Point this to your SQLServer machine
TDSPORT= 1434
TDSVER = 2000
CURSOR_SENSITIVITY = LOW; Set to HIGH after loading oplrvc.sql
To run the admin assistance;

From your browser run the following; 
http://travellog.exploreworldwide.com:9002/


To test the sqlserver manually, run;

/opt/OPENLINK/samples/ODBC/iodbctest

You will get the following prompt;

iODBC Demonstration program
This program shows an interactive SQL processor
Driver Manager: 03.52.0205.0201

Enter ODBC connect string (? shows list): ?

Then type OpenLink

You should get a SQL prompt for a successful connection, and you've then 
connected to the SQL server.

Bob

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Vance, Kathy
Sent: 18 October 2005 16:52
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] connection from UniBasic to a SQL database


Hi Bob, I hope I did not miss your reply. We have the problem to make
SQL 2000 communicate with Universe 10 or 11 with IBM Universe ODBC
driver. Based on its document, this driver seems do not support the SQL
server.

Could you share your experience on the way of using OpenLink ODBC driver
for SQL server?

Thanks,

Kathy

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Peter Gonzalez
Sent: Friday, October 14, 2005 12:25 PM
To: 

RE: [U2] ODBC

2005-10-19 Thread Bob Witney
Yes

We use OpenLink ODBC drivers across to MS SQL Server 2000

No problems at all once you prise the correct driver out of OpenLink

This is how you do it

ODBC OpenLink Installation


The installation of ODBC multi-tier software requires the following steps;

Download the following files from the OpenLink website;

1.) Data Source Administrator  Samples(taz)(recommended)Web-based Data Source 
Administrator  JDBC Samples:
ftp://download.openlinksw.com/uda/open52/a5l5adzz.taz
 
2.) iODBC SDK(taz) (required):
ftp://download.openlinksw.com/uda/open52/a5ko.taz
 
3.) ODBC Client only (taz)(required):
ftp://download.openlinksw.com/uda/open52/a5oc.taz
 
4.) Request Broker (taz)(required):
ftp://download.openlinksw.com/uda/open52/a5br.taz
 
5.) SQLServer Database agent (taz)(required):
ftp://download.openlinksw.com/uda/open52/a5ammzzz.taz
 
6.) Unix Installation Shell Script (required):
ftp://download.openlinksw.com/uda/open52/install.sh 



Once you have download and place these file in the installation
Directory, perform the following steps:

a) Run the command below to install the new components in this location:
 
 sh install.sh
 
b) Run the following command to set the necessary OpenLink  environment 
variables for this installation:
 
 . ./openlink.sh
 
c) Place the OpenLink oplrqb.lic license file in the bin directory of  
the OpenLink directory.
 
d) Change directory to the 'bin' directory of your installation
   and run the command:
 
 ./oplrqb -fd   to run it in the debug mode on your terminal
 
or

 ./oplrqb -vto run it in detached mode

The -fd option should produce output of the following form:
 
 OpenLink Request Broker
 Version 2.41 as of Tue Feb 01 2005 (Release 5.2 cvsid 00076).
 Compiled for AIX 3 (powerpc-ibm-aix4.3.3.0-32)
 Copyright (C) OpenLink Software.
 
 Registered to OpenLink Internal Use
 with product serial number opl-internal
 Issued by OpenLink Data Access Support (UK)
 This license will expire on Wed Feb 01 18:00:00 2006 GMT
 
 oplrqb: using rulebook
 /dbs6/openlink/32bit/v52/tsuite/tmp/bin/oplrqb.ini
 oplrqb: bound UDP protocol to 0.0.0.0.60001
 oplrqb: bound TCP protocol to 0.0.0.0.5432
 oplrqb: using UDP address 192.168.11.114.0 for IPC
 oplrqb: request broker started by openlink
 oplrqb: spawning
 /dbs6/openlink/32bit/v52/tsuite/tmp/bin/w3config/www_sv www_sv
 +debug
 www_sv: started http://oplusaix2.usnet.private:8765
 oplrqb: started persistent www_sv (pid=30068)
 oplrqb: rendezvous thread started
 oplrqb: rendezvous registration SQLServer (oplusaix2)
 
 e) Assuming the www_sv persistence service is started successfully you should 
then be able to access it on the URL specified in the Broker start log above.
 
 d) You can then choose to configure a DSN to connection to SQLServer, either 
via the Admin Assitant interface or manually using the connection parameters 
oplrqb.ini and odbc.ini.


To configure the odbc.ini manually, set the following parameters to;


[OpenLink]
Driver  = /opt/OPENLINK/lib/oplodbc.so
ServerType  = SQLServer 2000
Username= tlogtest
Password= pa55word
Database= synopsys
Options = -S 172.16.0.34 -P 1434 -V 8.0
FetchBufferSize = 99
ReadOnly=
DeferLongFetch  =
Host= localhost:5000
Description = ODBC sqlserver
UseSSL  =
NoLoginBox  =
SqlDbmsName =


To configure the oplrqb.ini manually, set the following parameters to;

[Environment SQLSERVER]
FREETDSCONF= /opt/OPENLINK/bin/freetds.conf
DSQUERY= SQLSERVER  ; Load this section from freetds.conf
TDSHOST= sql2   ; Point this to your SQLServer machine
TDSPORT= 1434
TDSVER = 2000
CURSOR_SENSITIVITY = LOW; Set to HIGH after loading oplrvc.sql
To run the admin assistance;

From your browser run the following; 
http://travellog.exploreworldwide.com:9002/


To test the sqlserver manually, run;

/opt/OPENLINK/samples/ODBC/iodbctest

You will get the following prompt;

iODBC Demonstration program
This program shows an interactive SQL processor
Driver Manager: 03.52.0205.0201

Enter ODBC connect string (? shows list): ?

Then type OpenLink

You should get a SQL prompt for a successful connection, and you've then 
connected to the SQL server.

Bob

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Cooper, Rudy
Sent: 18 October 2005 23:11
To: u2-users@listserver.u2ug.org
Subject: [U2] ODBC


Has anyone been successful in creating an odbc connection from sqlserver
to UV running on a W2k platform ?



If so and you don't mind could you give a brief explanation on what you
did to get it to work or direct me to a source ?

I understand that I can use DTS, but I'm looking to update, delete,
insert from sqlserver to UV.



Thx,



Rudy





Rudy Cooper
Information Technology
Project Technical Lead


Re: [U2] Strange $INCLUDE behavior

2005-10-19 Thread Mats Carlid

Bob Woodward wrote:


I just wanted to report back to everyone that the problem seems to have
disappeared.  I wanted to go back and try some suggestions but I now
can't seem to duplicate the problem.  Everything is back to the way it
was, including the OKAY$ variable, and it all compiles without a hitch.
shoulder shrug



muttering as I walk away, shaking my head  Maybe I should ask them to
increase the dosage of my medicine


 


Don't panic !

I've seen programs unexpectedly start to behave funny where a
recompile and recatalog has cured it.

Yes I checked that the source was not altered after the object code.


In one instance we now know  it was the first warning of an
faulty disk drive  soon thereafter to be replaced...

-- mats
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] ODBC

2005-10-19 Thread gerry-u2ug
isn't this the exact opposite of what was asked ?
this explains how to setup uv to sql server , the question was sql server to uv.



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Bob Witney
Sent: Wednesday, October 19, 2005 03:58 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] ODBC


Yes

We use OpenLink ODBC drivers across to MS SQL Server 2000

No problems at all once you prise the correct driver out of OpenLink

This is how you do it

ODBC OpenLink Installation


The installation of ODBC multi-tier software requires the following steps;

Download the following files from the OpenLink website;

1.) Data Source Administrator  Samples(taz)(recommended)Web-based Data Source 
Administrator  JDBC Samples:
ftp://download.openlinksw.com/uda/open52/a5l5adzz.taz
 
2.) iODBC SDK(taz) (required):
ftp://download.openlinksw.com/uda/open52/a5ko.taz
 
3.) ODBC Client only (taz)(required):
ftp://download.openlinksw.com/uda/open52/a5oc.taz
 
4.) Request Broker (taz)(required):
ftp://download.openlinksw.com/uda/open52/a5br.taz
 
5.) SQLServer Database agent (taz)(required):
ftp://download.openlinksw.com/uda/open52/a5ammzzz.taz
 
6.) Unix Installation Shell Script (required):
ftp://download.openlinksw.com/uda/open52/install.sh 



Once you have download and place these file in the installation
Directory, perform the following steps:

a) Run the command below to install the new components in this location:
 
 sh install.sh
 
b) Run the following command to set the necessary OpenLink  environment 
variables for this installation:
 
 . ./openlink.sh
 
c) Place the OpenLink oplrqb.lic license file in the bin directory of  
the OpenLink directory.
 
d) Change directory to the 'bin' directory of your installation
   and run the command:
 
 ./oplrqb -fd   to run it in the debug mode on your terminal
 
or

 ./oplrqb -vto run it in detached mode

The -fd option should produce output of the following form:
 
 OpenLink Request Broker
 Version 2.41 as of Tue Feb 01 2005 (Release 5.2 cvsid 00076).
 Compiled for AIX 3 (powerpc-ibm-aix4.3.3.0-32)
 Copyright (C) OpenLink Software.
 
 Registered to OpenLink Internal Use
 with product serial number opl-internal
 Issued by OpenLink Data Access Support (UK)
 This license will expire on Wed Feb 01 18:00:00 2006 GMT
 
 oplrqb: using rulebook
 /dbs6/openlink/32bit/v52/tsuite/tmp/bin/oplrqb.ini
 oplrqb: bound UDP protocol to 0.0.0.0.60001
 oplrqb: bound TCP protocol to 0.0.0.0.5432
 oplrqb: using UDP address 192.168.11.114.0 for IPC
 oplrqb: request broker started by openlink
 oplrqb: spawning
 /dbs6/openlink/32bit/v52/tsuite/tmp/bin/w3config/www_sv www_sv
 +debug
 www_sv: started http://oplusaix2.usnet.private:8765
 oplrqb: started persistent www_sv (pid=30068)
 oplrqb: rendezvous thread started
 oplrqb: rendezvous registration SQLServer (oplusaix2)
 
 e) Assuming the www_sv persistence service is started successfully you should 
then be able to access it on the URL specified in the Broker start log above.
 
 d) You can then choose to configure a DSN to connection to SQLServer, either 
via the Admin Assitant interface or manually using the connection parameters 
oplrqb.ini and odbc.ini.


To configure the odbc.ini manually, set the following parameters to;


[OpenLink]
Driver  = /opt/OPENLINK/lib/oplodbc.so
ServerType  = SQLServer 2000
Username= tlogtest
Password= pa55word
Database= synopsys
Options = -S 172.16.0.34 -P 1434 -V 8.0
FetchBufferSize = 99
ReadOnly=
DeferLongFetch  =
Host= localhost:5000
Description = ODBC sqlserver
UseSSL  =
NoLoginBox  =
SqlDbmsName =


To configure the oplrqb.ini manually, set the following parameters to;

[Environment SQLSERVER]
FREETDSCONF= /opt/OPENLINK/bin/freetds.conf
DSQUERY= SQLSERVER  ; Load this section from freetds.conf
TDSHOST= sql2   ; Point this to your SQLServer machine
TDSPORT= 1434
TDSVER = 2000
CURSOR_SENSITIVITY = LOW; Set to HIGH after loading oplrvc.sql
To run the admin assistance;

From your browser run the following; 
http://travellog.exploreworldwide.com:9002/


To test the sqlserver manually, run;

/opt/OPENLINK/samples/ODBC/iodbctest

You will get the following prompt;

iODBC Demonstration program
This program shows an interactive SQL processor
Driver Manager: 03.52.0205.0201

Enter ODBC connect string (? shows list): ?

Then type OpenLink

You should get a SQL prompt for a successful connection, and you've then 
connected to the SQL server.

Bob

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Cooper, Rudy
Sent: 18 October 2005 23:11
To: u2-users@listserver.u2ug.org
Subject: [U2] ODBC


Has anyone been successful in creating an odbc connection from sqlserver
to 

RE: [U2] [UV] Problems with uniobjects and windows 2003 server

2005-10-19 Thread César Riba Cervera
Thanks you for you help, we have, tried this and unfortunately it doesn't
work, do you have my other suggestions.



 -Mensaje original-
 De: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] nombre de David Jordan
 Enviado el: martes, 18 de octubre de 2005 22:53
 Para: u2-users@listserver.u2ug.org
 Asunto: RE: [U2] [UV] Problems with uniobjects and windows 2003 server


 This may be related to a problem with the U2 Services.  This issue with
 services has be identified before.  One possible action is to
 click ON allow
 interaction with the Desktop under the logon tab in the properties in the
 services management console particularly for the unirpc service.

 Regards

 David Jordan
 Managing Consultant

 [EMAIL PROTECTED]
 Mobile: 0428 669 730

 DACONO Holdings Pty Ltd
 www.dacono.com.au

 PO Box 909
 Lane Cove
 NSW 2066
 Australia

 Phn: 61 2 9418 8320
 Fax: 61 2 9427 2371

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] On Behalf Of Cisar
 Riba Cervera
 Sent: Wednesday, 19 October 2005 2:17 AM
 To: u2-users@listserver.u2ug.org
 Subject: [U2] [UV] Problems with uniobjects and windows 2003 server

 Hello

   We worked with windows NT and it runned well all, and now we have
 changed
 the server to windows 2003 and we have a problem that appear everyday, we
 receive an error of Uniobjects (30114) and in windows 2003
 generate the next
 error:

  (UniVerse error: Unhandled Exception raised at address 0x00404CC3; Access
 violation. Attempted to read from address 0x00B4A000. Binary data is
 processor CONTEXT structure..)


   Can help me somebody, this problem force to reinitiate the server
 every
 day.

 Best regards

 Cesar Riba
 Spain
 --
 No virus found in this outgoing message.
 Checked by AVG Anti-Virus.
 Version: 7.0.344 / Virus Database: 267.12.2/140 - Release Date: 18/10/2005
 ---
 u2-users mailing list
 u2-users@listserver.u2ug.org
 To unsubscribe please visit http://listserver.u2ug.org/
 ---
 u2-users mailing list
 u2-users@listserver.u2ug.org
 To unsubscribe please visit http://listserver.u2ug.org/

 --
 No virus found in this incoming message.
 Checked by AVG Anti-Virus.
 Version: 7.0.344 / Virus Database: 267.12.2/140 - Release Date: 18/10/2005

--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.12.4/142 - Release Date: 18/10/2005
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Spell-checker?

2005-10-19 Thread Keith W. Roberts
Many *nixes actually distribute vim and make vi a link to it, running in
vi compatibility mode. :)  'which vim' or 'whereis vim' at a unix shell
prompt should tell you if that's the case.  If so, getting the latest
version (6.4) will let you use all the features (short of version 7,
which is still in beta).

If not, you can still download (g)vim somewhere where it won't interfere
with vi.

-Keith

Original Message
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Oaks, Harold
Sent: Tuesday, October 18, 2005 4:34 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Spell-checker?

 Thanks for this idea!
 
 We are running PI/open over hpux 11.11.  I will ask the
 sysadmin people
 if replacing vi is even thinkable.
 
 Harold
 
 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] On Behalf Of Keith W.
 Roberts Sent: Tuesday, October 18, 2005 3:31 PM
 To: u2-users@listserver.u2ug.org
 Subject: RE: [U2] Spell-checker?
 
 In what environment/circumstances do you need it?
 
 I use the Vim editor (Vi IMproved) for just about everything.  I can
 even use it for email (though I haven't yet loaded the Outlook plugin
 here at my new job).  It's a free, open source Vi replacement
 that works
 on every major O/S, and it has more plugins than you can shake a stick
 at ... including a (did I mention free?) spell-checker. :)
 
 -Keith
 
 Original Message
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] On Behalf Of Oaks, Harold
 Sent: Monday, October 17, 2005 4:44 PM
 To: u2-users@listserver.u2ug.org
 Subject: [U2] Spell-checker?
 
 Has anyone implemented a form of a spell-checker?  Ideally, not by
 calling a Visual Basic or VB.NET application running on each user's
 PC 
 
 - I would prefer on the main server.
 
 Doing a little web searching, I find mvWord from WordMark.
 Can anybody
 comment on this product?
 
 Thanks-
 
 Harold D. Oaks
 Sr. Analyst/Programmer
 Office of the Budget and Information Systems Clark County,
 Washington ph: (360) 397-6121 x4132 fax: (360) 397-2342
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] UV Abort

2005-10-19 Thread karlp
quote who=Clifton Oliver
 Did the second run also cause the fault?

 Is there anything in that job or job stream that could be trying to
 build a huge dynamic array? Such as trying to READ and entire report
 into a variable?

No, it executes a LIST file BY var LPTR style command... I have quite a
few similar reports that do get generated by capturing the output of the
LIST command, but none of them cause this error.

KLP



 --

 Regards,

 Clif

 ~~~
 W. Clifton Oliver, CCP
 CLIFTON OLIVER  ASSOCIATES
 Tel: +1 619 460 5678Web: www.oliver.com
 ~~~



 On Oct 18, 2005, at 3:03 PM, [EMAIL PROTECTED] wrote:

 Any ideas? Suggestions? Oh, the program DID NOT ACTUALLY ABORT. It
 completed and printed the reports correctly. HUH? Yes, I ran it
 again and
 confirmed that the reports I generated were identical to the ones
 printed
 at 2pm via cron job.
 ---
 u2-users mailing list
 u2-users@listserver.u2ug.org
 To unsubscribe please visit http://listserver.u2ug.org/



-- 
karl

 _/  _/  _/  _/_/_/      __o
_/ _/   _/  _/_/   _-\._
   _/_/_/  _/_/_/ (_)/ (_)
  _/ _/   _/  _/   ..
 _/   _/ arl _/_/_/  _/ earson[EMAIL PROTECTED]

--
IT Director, ATS Industrial Supply, Inc.
http://www.atsindustrial.com
Toll-free: 800-789-9300 x29
Direct2Desk: 801-978-4429
Facsimile: 801-972-3888
--
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] UV Abort

2005-10-19 Thread karlp
quote who=Keith W. Roberts
 What did the phantom log say?  You might DISPLAY something after the RUN
 cmd to make sure the fault occurs after the program completes.

I haven't been able to replicate this behavior. Also, the BRIEF keyword
causes the output to PH to be suppressed. I may remove that to see, but
without being able to cause the command to fail or see a pattern to the
failure will make catching the error more difficult. At least there will
be a different PH entry for each iteration of the process...

Thanks for the suggestion.

KLP


 -Keith

 Original Message
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] On Behalf Of
 [EMAIL PROTECTED]
 Sent: Tuesday, October 18, 2005 3:03 PM
 To: u2-users@listserver.u2ug.org
 Subject: [U2] UV Abort

 UV 10.1.7 on AIX 5.2.0 (5200-05)

 We have a cron job with the following line in a script:
 /u1/uv/bin/uv phantom BRIEF BO060.CRON

 a VOC entry which looks like:
 PA Daily cron process scheduled at 2pm
 RUN BP BO060

 This process picks up back-orders, thus the BOnnn name.

 Periodically, when this runs, I get the following lines in my email:
 Abnormal termination of UniVerse.
 Fault type is 11. layer type is BASIC run machine.
 Fault occurred in BASIC program BO060 at address  0.
 /u1/atsphx/bo060[3]: 634918 Segmentaion fault (coredump)

 A cursory _strings_ look at the core file shows nothing other than the
 normal shell environments stuff.

 Address 0 in a VLIST is:
 crtcrlf Running BO060

 I commented that line out and recompiled to see if running a
 phantom BRIEF
 balks (sometimes) at a CRT line. I know it shouldn't, but
 hey, I'm gonna
 try and see. Since it's rare that it happens, I'm not sure if
 I'll even
 know if that fixed it.

 Any ideas? Suggestions? Oh, the program DID NOT ACTUALLY ABORT. It
 completed and printed the reports correctly. HUH? Yes, I ran
 it again and
 confirmed that the reports I generated were identical to the
 ones printed
 at 2pm via cron job.

 --
 karl
 ---
 u2-users mailing list
 u2-users@listserver.u2ug.org
 To unsubscribe please visit http://listserver.u2ug.org/



-- 
karl

 _/  _/  _/  _/_/_/      __o
_/ _/   _/  _/_/   _-\._
   _/_/_/  _/_/_/ (_)/ (_)
  _/ _/   _/  _/   ..
 _/   _/ arl _/_/_/  _/ earson[EMAIL PROTECTED]

--
IT Director, ATS Industrial Supply, Inc.
http://www.atsindustrial.com
Toll-free: 800-789-9300 x29
Direct2Desk: 801-978-4429
Facsimile: 801-972-3888
--
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] UV Abort

2005-10-19 Thread karlp
quote who=Clifton Oliver
 Did the second run also cause the fault?

[brain cramp]...  No, the second run from TCL caused no fault.


 Is there anything in that job or job stream that could be trying to
 build a huge dynamic array? Such as trying to READ and entire report
 into a variable?

Oh, and wouldn't the job fail to print if it failed because of reading the
report into a variable?

KLP



 --

 Regards,

 Clif

 ~~~
 W. Clifton Oliver, CCP
 CLIFTON OLIVER  ASSOCIATES
 Tel: +1 619 460 5678Web: www.oliver.com
 ~~~



 On Oct 18, 2005, at 3:03 PM, [EMAIL PROTECTED] wrote:

 Any ideas? Suggestions? Oh, the program DID NOT ACTUALLY ABORT. It
 completed and printed the reports correctly. HUH? Yes, I ran it
 again and
 confirmed that the reports I generated were identical to the ones
 printed
 at 2pm via cron job.
 ---
 u2-users mailing list
 u2-users@listserver.u2ug.org
 To unsubscribe please visit http://listserver.u2ug.org/



-- 
karl

 _/  _/  _/  _/_/_/      __o
_/ _/   _/  _/_/   _-\._
   _/_/_/  _/_/_/ (_)/ (_)
  _/ _/   _/  _/   ..
 _/   _/ arl _/_/_/  _/ earson[EMAIL PROTECTED]

--
IT Director, ATS Industrial Supply, Inc.
http://www.atsindustrial.com
Toll-free: 800-789-9300 x29
Direct2Desk: 801-978-4429
Facsimile: 801-972-3888
--
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] UV dead lock daemon questions

2005-10-19 Thread Hennessey, Mark F.
In reviewing my uvdlockd.log, I see that even when the deadlock daemon isn't 
running, it looks like it's being run.  Does executing uvlictool clean_lic -a 
call the deadlock process?

Also, in configuring the daemon's resolution strategy, there are three options; 
random termination, terminate newest transaction, or terminate the transaction 
with fewest locks.  I have chosen to terminate the newest, but I was little 
more than flipping a coin...  simply using the 'first come, first server' 
approach.  I can't seem to find anything in the documentation that would help 
me decide which resolution strategy I *should* employ.  Any ideas?

Mark Hennessey
State of Connecticut
DSS/MIS Child Support Systems
Voice: 860-424-5261
Fax: 860-424-4956
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] ODBC

2005-10-19 Thread Cooper, Rudy
Bob, thank you for the detailed explanation, but I was looking to go the
other way, connect from Sql Server to UV.  E.g., being in sql query
analyzer and selecting UV files, unless this works from sql server to UV
as well.

Thx,



Rudy



Date: Wed, 19 Oct 2005 08:58:26 +0100

From: Bob Witney [EMAIL PROTECTED]

Subject: RE: [U2] ODBC





Yes



We use OpenLink ODBC drivers across to MS SQL Server 2000



No problems at all once you prise the correct driver out of OpenLink

..



Rudy Cooper
Information Technology
Project Technical Lead

Sage Publications
2455 Teller Road
Thousand Oaks, California 91320

Direct (805) 410-7724
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] UV Abort

2005-10-19 Thread Keith W. Roberts
A way around the problem of creating mostly unnecessary PH logs which
require cleanup is to create a wrapper program that:

- takes [bpfile and] progname as argument(s)
- sets logname = progname:_:date():_:time()
- does a SETPTR with BANNER :logname to create a unique log file
- runs progname
- checks @SYSTEM.RETURN.CODE after the program
- if successful, EXECUTE DELETE PH :logname

Now PH is left with logs for only those runs which failed.  Of course,
you'll also have to change the paragraph to run the wrapper with
appropriate args (you won't need bpfile if you catalog the prog).

-Keith

Original Message
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Wednesday, October 19, 2005 7:55 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UV Abort

 quote who=Keith W. Roberts
 What did the phantom log say?  You might DISPLAY something after the
 RUN cmd to make sure the fault occurs after the program completes.
 
 I haven't been able to replicate this behavior. Also, the BRIEF
 keyword causes the output to PH to be suppressed. I may remove that
 to see, but without being able to cause the command to fail or see a
 pattern to the failure will make catching the error more difficult.
 At least there will be a different PH entry for each iteration of
 the process... 
 
 Thanks for the suggestion.
 
 KLP
 
 
 -Keith
 
 Original Message
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] On Behalf Of
 [EMAIL PROTECTED] Sent: Tuesday, October 18, 2005 3:03 PM
 To: u2-users@listserver.u2ug.org
 Subject: [U2] UV Abort
 
 UV 10.1.7 on AIX 5.2.0 (5200-05)
 
 We have a cron job with the following line in a script:
 /u1/uv/bin/uv phantom BRIEF BO060.CRON
 
 a VOC entry which looks like:
 PA Daily cron process scheduled at 2pm
 RUN BP BO060
 
 This process picks up back-orders, thus the BOnnn name.
 
 Periodically, when this runs, I get the following lines in my email:
 Abnormal termination of UniVerse.
 Fault type is 11. layer type is BASIC run machine.
 Fault occurred in BASIC program BO060 at address  0.
 /u1/atsphx/bo060[3]: 634918 Segmentaion fault (coredump)
 
 A cursory _strings_ look at the core file shows nothing other than
 the normal shell environments stuff.
 
 Address 0 in a VLIST is:
 crtcrlf Running BO060
 
 I commented that line out and recompiled to see if running a
 phantom BRIEF balks (sometimes) at a CRT line. I know it shouldn't,
 but 
 hey, I'm gonna
 try and see. Since it's rare that it happens, I'm not sure if I'll
 even know if that fixed it.
 
 Any ideas? Suggestions? Oh, the program DID NOT ACTUALLY ABORT. It
 completed and printed the reports correctly. HUH? Yes, I ran
 it again and
 confirmed that the reports I generated were identical to the
 ones printed
 at 2pm via cron job.
 
 --
 karl
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] ODBC

2005-10-19 Thread Rick Ward
--- Cooper, Rudy [EMAIL PROTECTED] wrote:
 Has anyone been successful in creating an odbc
 connection from sqlserver
 to UV running on a W2k platform ?

Hi Rudy,

At the University of Pennsylvania Veterinary Hospital,
we have set up a UniVerse ODBC data source as a Linked
Server on SQL Server 7 (not sure how much this will
change for newer versions of SQL Server). Our UniVerse
instance runs on RedHat Linux, but all of these steps
should apply to your instance also. This is a much
more manageable solution than using DTS (in my
experience).

Steps:
1. Configure the UniVerse account for ODBC access (see
the UniVerse ODBC Guide)
2. Install the UniVerse ODBC client on your client
machine (SQL Server)
3. Set up a machine data source on your Windows client
(once again, the machine running SQL Server).
4. In SQL Server Enterprise Manager, go to the
Security folder under the database server that you
want to connect, right click on the Linked Servers
item, select New Linked Server..., and complete the
dialogs.

Once your Linked Server has been configured, you can
query the UniVerse ODBC connection directly from
within SQL Server by using the following method:

SELECT Field1,Field2,Field3
FROM OPENQUERY(YOUR_LINKED_SERVER_NAME,
'SELECT Field1,Field2,Field3
FROM YOUR_UNIVERSE_TABLE_OR_FILE')

Once you have this going, you can use stored
procedures to do any data synchronization tasks (or
anything else). Stored procedures are faster and
easier to maintain than DTS.

WARNING: SQL Server's ODBC client is VERY sensitive to
discrepancies between the expected datatype (as
specified in your file dictionary) and the actual data
returned. Spend some time making sure your file
dictionaries specify the proper datatypes.

Good Luck!

Rick Ward
IT Director for Hospital Systems
Matthew J. Ryan Veterinary Hospital
University of Pennsylvania School of Veterinary
Medicine
rickward at vet dot upenn dot edu





__ 
Yahoo! Music Unlimited 
Access over 1 million songs. Try it free.
http://music.yahoo.com/unlimited/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] ODBC

2005-10-19 Thread Don Kibbey
This type of connection is OK for general query type stuff.  When
performing large transfers of data from UniVerse to SQL server I've
found that it's much faster to use bulk loading from DTS (or a stored
procedure).  Here's a sample of code (without the DTS part which is
just a simple bulk load job).  The commented section is a piece of
code the DTS job replaced.  The commented section took over an hour,
the bulk load DTS job takes 12 minutes.

This is used to transfer some raw budget numbers off a UniVerse based
accounting system and put them into a SQL server based budgeting
system (Aderant's Executive Office).

---begin---
namespace FHFGD {
using System;
using System.Data;
using System.Data.SqlClient;
using IBMU2.UODOTNET;
using System.IO;
using System.Collections;
using System.Text;
using System.Windows.Forms;
using C1.Common;
using C1.Win.C1FlexGrid;
using DTS = Microsoft.SQLServer.DTSPkg80;

public class BudgetLoad  : IDisposable {
// This delegate used to pass back status messages in string 
format
dlgStatus dlgMessage;
#region CodeObject Interface IDisposable implementation
// (Madinina Info) Do not edit prototype by hand : Access 
ReturnType
Name Parameters
public void Dispose() {
GC.SuppressFinalize(this);
}
#endregion  CodeObject Interface IDisposable implementation

public BudgetLoad(UniSession uSession, string NRDataConn, string
FilePath, dlgStatus dlgIn, C1.Win.C1FlexGrid.C1FlexGrid FlexG) {
///summary
/// generate budget load data for Aderant Executive 
Office Budgeting system
/// aka Keystone.
summary
this.dlgMessage = dlgIn;
dlgMessage(Begin EO Budget Import Table Build);

string AcctID = ;
string CostCenter = ;
string AccountName = ;
string AccountType = ;
string Active = ;
int svlimit = 0;
int rCnt = 1;
decimal Credit = 0;
decimal Debit = 0;
decimal MTDBalance = 0;
decimal Budget = 0; 
string CHID = ;
string TAB = \t;
StreamWriter swGL;
StreamWriter swGLAcct;
string fGL = gl.txt;
string fGLAcct = glAcct.txt;

string [] lRecIDArray;
ArrayList lRecIDList = new ArrayList(1);

swGL = new StreamWriter(@c:\ + fGL, false);
swGL.WriteLine(InputFileLineNum + TAB + Year + TAB 
+ Period +
TAB + AccountID + TAB + CostCenterID + TAB + CurrencyID + TAB +
MTDBalance + TAB + Budget + TAB + nbFlag);
swGLAcct = new StreamWriter(@c:\ + fGLAcct, false);
swGLAcct.WriteLine(AccountID + TAB + AccountName + 
TAB +
AccountType + TAB + Active);

#region Datatable initialization area

System.Data.DataTable dtGL = new 
System.Data.DataTable(GL);

DataColumn colLineNum = new DataColumn();
colLineNum.ColumnName = InputFileLineNum;
colLineNum.DataType = Type.GetType(System.Int32);
dtGL.Columns.Add(colLineNum);

DataColumn colYear = new DataColumn();
colYear.ColumnName = Year;
colYear.DataType = Type.GetType(System.Int16);
dtGL.Columns.Add(colYear);

DataColumn colPeriod = new DataColumn();
colPeriod.ColumnName = Period;
colPeriod.DataType = Type.GetType(System.Int16);
dtGL.Columns.Add(colPeriod);

DataColumn colGLAcctID = new DataColumn();
colGLAcctID.ColumnName = AccountID;
colGLAcctID.DataType = Type.GetType(System.String);
dtGL.Columns.Add(colGLAcctID);

DataColumn colCostCenter = new DataColumn();
colCostCenter.ColumnName = CostCenter;
colCostCenter.DataType = Type.GetType(System.String);
dtGL.Columns.Add(colCostCenter);

DataColumn colCurrency = new DataColumn();

Re: [U2] UV Abort

2005-10-19 Thread Clifton Oliver
Sure. Unless it dispatched the report to the spooler system and then  
was doing something like trying to read it as a record and write it  
to an archive or something.


Was tossing out straws to grasp at.


--

Regards,

Clif

On Oct 19, 2005, at 7:57 AM, [EMAIL PROTECTED] wrote:


Is there anything in that job or job stream that could be trying to
build a huge dynamic array? Such as trying to READ and entire report
into a variable?



Oh, and wouldn't the job fail to print if it failed because of  
reading the

report into a variable?

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] Re: U2 Users Digest V1 #888

2005-10-19 Thread Russ DeWitt
I will be out of the office on business, Wednesday 10/19/2005 thru Friday 
10/21/2005. During this time I will not have access to my email. If you need to 
contact me, please call me on my cell phone.

Thanks,

Russ
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] ODBC

2005-10-19 Thread Vance, Kathy
I did the same thing in SQL 2000. I created a linked server in SQL 2000
with IBM ODBC driver. I could run the query with Openquery. But I could
not see the tables and views in SQL enterprise manager. When I clicked
on the tables, I got error saying something like:
Error0: SqlDumpExceptionHandler: Process 51 generated fatal exception
C005 Exception_Access_Voliation SQL server is terminating this
process.

Based on online discussion, the error was related to the Memory setting
but I have not figured out how to fix it. Any idea or suggestions?

Also, I could not add where statement in the openquery query. As I
know, we can do so in SQL 2005.

Thanks,

Kathy





-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Rick Ward
Sent: Wednesday, October 19, 2005 12:49 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] ODBC

--- Cooper, Rudy [EMAIL PROTECTED] wrote:
 Has anyone been successful in creating an odbc
 connection from sqlserver
 to UV running on a W2k platform ?

Hi Rudy,

At the University of Pennsylvania Veterinary Hospital,
we have set up a UniVerse ODBC data source as a Linked
Server on SQL Server 7 (not sure how much this will
change for newer versions of SQL Server). Our UniVerse
instance runs on RedHat Linux, but all of these steps
should apply to your instance also. This is a much
more manageable solution than using DTS (in my
experience).

Steps:
1. Configure the UniVerse account for ODBC access (see
the UniVerse ODBC Guide)
2. Install the UniVerse ODBC client on your client
machine (SQL Server)
3. Set up a machine data source on your Windows client
(once again, the machine running SQL Server).
4. In SQL Server Enterprise Manager, go to the
Security folder under the database server that you
want to connect, right click on the Linked Servers
item, select New Linked Server..., and complete the
dialogs.

Once your Linked Server has been configured, you can
query the UniVerse ODBC connection directly from
within SQL Server by using the following method:

SELECT Field1,Field2,Field3
FROM OPENQUERY(YOUR_LINKED_SERVER_NAME,
'SELECT Field1,Field2,Field3
FROM YOUR_UNIVERSE_TABLE_OR_FILE')

Once you have this going, you can use stored
procedures to do any data synchronization tasks (or
anything else). Stored procedures are faster and
easier to maintain than DTS.

WARNING: SQL Server's ODBC client is VERY sensitive to
discrepancies between the expected datatype (as
specified in your file dictionary) and the actual data
returned. Spend some time making sure your file
dictionaries specify the proper datatypes.

Good Luck!

Rick Ward
IT Director for Hospital Systems
Matthew J. Ryan Veterinary Hospital
University of Pennsylvania School of Veterinary
Medicine
rickward at vet dot upenn dot edu





__ 
Yahoo! Music Unlimited 
Access over 1 million songs. Try it free.
http://music.yahoo.com/unlimited/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] NETWORK

2005-10-19 Thread Will
   Thanks John, Anthony and Stephen.
   The Lantronics support person, named George, implied that there is a
   listening  port  for  every  physical port on his company's terminal
   server  which  has  at  least 15 physical ports, 13 of which have dumb
   terminals  and 2 with HP printers in serial mode.  These ports numbers
   are,  according  to  George,  prefixed  by 30 and appended to the ip
   address.   With these numbers George says he can configure the devices
   to be terminals or printers.
   The  /etc/services  does not list 15 similar items of any kind.  Maybe
   they are dynamically allocated by the termserver.
   And  maybe...   just  maybe... our support is somewhere on the edge of
   reality,  a  place  with  new  dimensions of sight and sound, known to
   late-night computer chaps as: The Twilight Zone!
   Will
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] NETWORKING

2005-10-19 Thread Haas, John
We are using lantronix on HP-UX. The setup is below.  The port numbers (300x) 
correspond to the number of ports on the lanronix. We are using 8 port boxes.
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyz5 -x dcterm -p 3001 -k
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyz4 -x dcterm -p 3002 -k
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyz3 -x dcterm -p 3003 -k
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyz2 -x dcterm -p 3004 -k
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyz1 -x dcterm -p 3005 -k
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyz0 -x dcterm -p 3006 -k
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyyf -x dcterm -p 3007 -k
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyye -x dcterm -p 3008 -k
##
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyyd -x orlterm -p 3001 -k
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyyc -x orlterm -p 3002 -k
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyyb -x orlterm -p 3003 -k
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyya -x orlterm -p 3004 -k
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyy9 -x orlterm -p 3005 -k
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyy8 -x orlterm -p 3006 -k
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyy7 -x orlterm -p 3007 -k
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyy6 -x orlterm -p 3008 -k


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Will
Sent: Tuesday, October 18, 2005 8:39 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] NETWORKING


   Our  Lantronics  server  lost configuration for the off site terminals
   and  printers.  Lantronics  help  desk  says  we  must  tell  them the
   listening  port  numbers  on the HP9000 running HP-UX Universe. Anyone
   know how to determine those ports? Kind Regards, Will

   --
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


This email is intended only for the use of the party to which it is 
addressed and may contain information that is privileged, 
confidential, or protected by law.  If you are not the intended 
recipient you are hereby notified that any dissemination, copying 
or distribution of this email or its contents is strictly prohibited. 
If you have received this message in error, please notify us immediately 
by replying to the message and deleting it from your computer.

Internet communications are not assured to be secure or clear of 
inaccuracies as information could be intercepted, corrupted, lost, 
destroyed, arrive late or incomplete, or contain viruses. Therefore, 
we do not accept responsibility for any errors or omissions that are
present in this email, or any attachment, that have arisen as a result 
of e-mail transmission. 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] UV dead lock daemon questions

2005-10-19 Thread Ray Wurlod
Yes, uvlictool clean_lic does execute the same clean up code as the deadlock 
daemon, even unto logging to the same file.  I don't believe it actually starts 
a uvdlockd process, however.

There is no documentation on strategy, because none is really to be preferred 
over the others in all cases.  You need to decide what's right for you.  My 
personal preference is not to enable automatic resolution at all, but instead 
to choose victim after weighing up the circumstances.  Of course, it is then 
necessary to monitor the log to determine when a deadlock situation has been 
detected.  In two years we've not had any, other than one created deliberately 
for testing the process.

- Original Message -
From: Hennessey, Mark F. [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Subject: [U2] UV dead lock daemon questions
Date: Wed, 19 Oct 2005 11:37:10 -0400

 
 In reviewing my uvdlockd.log, I see that even when the deadlock 
 daemon isn't running, it looks like it's being run.  Does executing 
 uvlictool clean_lic -a call the deadlock process?
 
 Also, in configuring the daemon's resolution strategy, there are 
 three options; random termination, terminate newest transaction, or 
 terminate the transaction with fewest locks.  I have chosen to 
 terminate the newest, but I was little more than flipping a coin... 
   simply using the 'first come, first server' approach.  I can't 
 seem to find anything in the documentation that would help me 
 decide which resolution strategy I *should* employ.  Any ideas?
 
 Mark Hennessey
 State of Connecticut
 DSS/MIS Child Support Systems
 Voice: 860-424-5261
 Fax: 860-424-4956
 ---
 u2-users mailing list
 u2-users@listserver.u2ug.org
 To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] [UV] Problems with uniobjects and windows 2003 server

2005-10-19 Thread John Jenkins
David

interact with desktop being set cures a number of things you are quite
correct, and it is ON by default nowadays for just about everything
(though if the software is an older version it may not be set .). 

There were some specific issues which look like this (maybe) hence my
question about the exact version of UV and the clients. Timing could be an
issue as well as thee was an issue setting timeout if a connection did not
exist at the time. 

Riba: If we could have the UniVerse server software version and also the
Client version? 10.1.? server and 10.1/a/b of the client?

Regards

JayJay 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of David Jordan
Sent: 18 October 2005 21:53
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [UV] Problems with uniobjects and windows 2003 server

This may be related to a problem with the U2 Services.  This issue with
services has be identified before.  One possible action is to click ON allow
interaction with the Desktop under the logon tab in the properties in the
services management console particularly for the unirpc service.  

Regards

David Jordan
Managing Consultant
 
[EMAIL PROTECTED]
Mobile: 0428 669 730
 
DACONO Holdings Pty Ltd
www.dacono.com.au
 
PO Box 909
Lane Cove
NSW 2066
Australia
 
Phn: 61 2 9418 8320
Fax: 61 2 9427 2371
 
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Cisar Riba Cervera
Sent: Wednesday, 19 October 2005 2:17 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] [UV] Problems with uniobjects and windows 2003 server

Hello

We worked with windows NT and it runned well all, and now we have
changed
the server to windows 2003 and we have a problem that appear everyday, we
receive an error of Uniobjects (30114) and in windows 2003 generate the next
error:

 (UniVerse error: Unhandled Exception raised at address 0x00404CC3; Access
violation. Attempted to read from address 0x00B4A000. Binary data is
processor CONTEXT structure..)


Can help me somebody, this problem force to reinitiate the server
every
day.

Best regards

Cesar Riba
Spain
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.12.2/140 - Release Date: 18/10/2005
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] UV dead lock daemon questions

2005-10-19 Thread John Jenkins
It's probably running in cleanup mode for individual processes as they
terminate..

Regards

JayJay

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Hennessey, Mark F.
Sent: 19 October 2005 16:37
To: u2-users@listserver.u2ug.org
Subject: [U2] UV dead lock daemon questions

In reviewing my uvdlockd.log, I see that even when the deadlock daemon isn't
running, it looks like it's being run.  Does executing uvlictool clean_lic
-a call the deadlock process?

Also, in configuring the daemon's resolution strategy, there are three
options; random termination, terminate newest transaction, or terminate the
transaction with fewest locks.  I have chosen to terminate the newest, but I
was little more than flipping a coin...  simply using the 'first come, first
server' approach.  I can't seem to find anything in the documentation that
would help me decide which resolution strategy I *should* employ.  Any
ideas?

Mark Hennessey
State of Connecticut
DSS/MIS Child Support Systems
Voice: 860-424-5261
Fax: 860-424-4956
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] NETWORKING

2005-10-19 Thread Will
   John,
   Thanks.
   How did you get the printout you sent?
   Will
   Haas, John wrote:

We are using lantronix on HP-UX. The setup is below.  The port numbers (300x) c
orrespond to the number of ports on the lanronix. We are using 8 port boxes.
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyz5 -x dcterm -p 3001 -k
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyz4 -x dcterm -p 3002 -k
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyz3 -x dcterm -p 3003 -k
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyz2 -x dcterm -p 3004 -k
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyz1 -x dcterm -p 3005 -k
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyz0 -x dcterm -p 3006 -k
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyyf -x dcterm -p 3007 -k
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyye -x dcterm -p 3008 -k
##
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyyd -x orlterm -p 3001 -k
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyyc -x orlterm -p 3002 -k
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyyb -x orlterm -p 3003 -k
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyya -x orlterm -p 3004 -k
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyy9 -x orlterm -p 3005 -k
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyy8 -x orlterm -p 3006 -k
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyy7 -x orlterm -p 3007 -k
# /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyy6 -x orlterm -p 3008 -k

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
.org] On Behalf Of Will
Sent: Tuesday, October 18, 2005 8:39 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] NETWORKING

   Our  Lantronics  server  lost configuration for the off site terminals
   and  printers.  Lantronics  help  desk  says  we  must  tell  them the
   listening  port  numbers  on the HP9000 running HP-UX Universe. Anyone
   know how to determine those ports? Kind Regards, Will

   --
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


This email is intended only for the use of the party to which it is
addressed and may contain information that is privileged,
confidential, or protected by law.  If you are not the intended
recipient you are hereby notified that any dissemination, copying
or distribution of this email or its contents is strictly prohibited.
If you have received this message in error, please notify us immediately
by replying to the message and deleting it from your computer.

Internet communications are not assured to be secure or clear of
inaccuracies as information could be intercepted, corrupted, lost,
destroyed, arrive late or incomplete, or contain viruses. Therefore,
we do not accept responsibility for any errors or omissions that are
present in this email, or any attachment, that have arisen as a result
of e-mail transmission. ---
-
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/