Thanks to all who replied.
I found my error. There was a program in Unidata that I had modified the day
before, that was throwing an error when run from this VB.NET program. This was
run as a Session.Command.Exec() through UniObjects. When it threw the error,
it killed the udt session for this UniObjects 'phantom' user. (I found this by
trying to run that program manually.)
Oddly enough, when that happened, UniObjects still returned an .error code of
0, meaning no error. This made it appear that my program was doing everything
correctly up to the select statement, and I had ignored it as being a possible
issue. I guess sometimes ignorance ISN'T bliss, right?
Thanks, again for your time and your support in this issue. It's all resolved
now!!!
- Dave
-----Original Message-----
From: Dave Tabor
Sent: Wednesday, March 08, 2006 11:05 AM
To: '[EMAIL PROTECTED]'
Subject: RE: [U2] UniObjects Select Error ( HELP!!! - Different error
message - 81002 )
Hi,
Unfortunately, although it was set to en_US, instead of C, it didn't appear to
have helped. I did realize that my other application, which works with
virtually the same routines, does work. This would seem to indicate that it's
not the LANG setting on my machine, as it's also en_US for that user.
I did try bypassing the select statement, and going right straight for the
statement:
SelectListObj.GetList("FSD")
to see what happened. This gives me an error 81002, which says
"UVE_RPC_NO_CONNECTION" Description reads "The connection is broken"... a lot
of help, huh?
My session is still active at this point, and I can see the user still logged
in.
Q1) Any thoughts, anyone???
Q2) How is the RPC connection different from the session?
Thanks,
Dave
-----Original Message-----
From: Piers Angliss [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 07, 2006 6:01 PM
To: Dave Tabor
Cc: U2-Users
Subject: RE: [U2] UniObjects Select Error
Dave,
I hit this with a Linux server last year and I'm hoping it's the same
problem. Pete @ Epicor UK did some research and advised that Error 39207
refers to an incorrect LANG setting on a Unix server. LANG should be set to
'C' , if it isn't you'll hit this.
My problem was that the base system LANG setting was not C, but all my
logins used a .profile script to set it to 'C' so ECL worked fine.
Unfortunately, UniObjects doesn't execute .profiles, LOGIN paras or anything
so it reverts to the base LANG (so in order for my theory to hold in your
case, somebody must have changed something in AIX)
Hth
Piers
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Dave Tabor
Sent: 07 March 2006 21:10
To: [email protected]
Subject: [U2] UniObjects Select Error
Hi,
I've got an application that is written in VB.NET which uses UniObjects to
connect to Unidata 6.0 on an AIX server.
It's been working fine for months, and today seems to have 'broken'. I've
stepped through the lines in VB.NET, and come up with what I think might be
the offending error message.
The error is error code 39207, which I have no reference as to it's meaning.
I'm getting the error right after executing this two line code:
Session.command.text = "SSELECT FSD BY DEL_DATE BY SORT_SEQ BY.DSND @ID WITH
SELECT_DATE GE """ & SelectDateStr & """ AND WITH @ID # ""moved"" AND WITH
NO PRM_DATE = ""PDt"" AND WITH NO CUST_NAME = """""
Session.command.exec()
Notes:
1) My session is open, and has no error status.
2) The actual Select Statement created here is: SSELECT FSD BY DEL_DATE BY
SORT_SEQ BY.DSND @ID WITH SELECT_DATE GE "03/1/06" AND WITH DISPLAYED # "Y"
AND WITH @ID # "moved" AND WITH NO PRM_DATE = "PDt" AND WITH NO CUST_NAME =
""
3) The Session.command.text statement works correctly, as I can cut/paste it
from the watch window to an ECL prompt and it works fine.
I'm the only IT person working with this server and VB.NET code, and as I
mentioned, I haven't changed anything in a months, so I'm not sure where to
start.
Any guess what the error code means, and/or what I could try to do to
resolve this issue?
Thanks,
Dave
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
