[U2] SB Error

2011-06-07 Thread Israel, John R.
We are using Avanté w/ SB and a web interface for customers. On rare occasions, a web page is blowing up due to an error that is cleanly detected in Avanté/SB, but that the web side is clueless about. I am working on a pro-active program to detect these conditions, but after a while, it is

Re: [U2] SB Error

2011-06-07 Thread Dave Davis
Does the web side make use of SB+ at all? Through a derived field or indexed field or trigger? If you can, I would step through all the files in the /FC table to make sure they can be opened. This may not be a complete list of the files the app opens but it would be a place to start. Is the

[U2] [UniData] UniRPCD

2011-06-07 Thread Shin.Tanaka
We are running unidata-7.1.23 on HP-UX IA64 B.11.31. I have a JAVA UOJ program to test UniRPCD connection on a host. This program is executed on LINUX host via cron every 5-minute. It opens and closes VOC on a UniData account to check if UniRPCD is alive and working. I often (a few times a

Re: [U2] SB Error

2011-06-07 Thread Israel, John R.
Let me answer this way: my new stand-alone program selects all the parts, loops through them, and for each part, calls the same subroutines that the web site does (thus ensuring that I am running the same logic). One of these subroutines calls another subroutine that lives in an SB account.

Re: [U2] SB Error

2011-06-07 Thread Dave Davis
You're not hitting MAX_OPEN_FILE (default 500) are you? Other than that - the stand-alone program is truly a program and not a subroutine? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent:

Re: [U2] SB Error

2011-06-07 Thread Wally Terhune
To see open files for a udt process, use UniBasic SYSTEM(50) to return a dynamic array, or from another process with root permissions: PORT.STATUS PID FILEMAP (where is the process id of the problem process) Wally Terhune U2 Support Architect Rocket Software 4600 South Ulster

Re: [U2] SB Error

2011-06-07 Thread Israel, John R.
That was not it. 21 files opened for each pass. John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH  45342 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally

Re: [U2] SB Error

2011-06-07 Thread Israel, John R.
Time to drop back and punt. I added a display of each key to see which record was blowing up. I changed the select to ONLY select that one id, and it did NOT blow up. Back to the drawing board... John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH 

Re: [U2] SB Error

2011-06-07 Thread Bill Haskett
...and to see what processes are running, from another process with root permissions: PORT.STATUS PID CALL.STACK This is pretty useful when you need to find out what's running. HTH, Bill Haskett - Original

Re: [U2] SB Error

2011-06-07 Thread Colin Alfke
It's been a while since I've seen this one. IIRC in our case it was actually a problem with the data, there were control characters or something in it. The other problem I just ran across Monday was a non-SB program (through a number of twists and turns) calling a program that made a veiled

Re: [U2] SB Error

2011-06-07 Thread Dave Davis
Do the following on each file to make sure it isn't trigger or index related: LIST.TRIGGER DATA filename LIST.INDEX filename The error doesn't have to be in your program to cause the problem. If for some reason a trigger or an index used a subroutine that relied on SB+ you could get these

Re: [U2] SB Error

2011-06-07 Thread Dave Davis
I'm betting it's trying to open the xxPROCESS file or other system file - and can't because the system hasn't been initialized. The subroutine that lives in the SB account probably uses the SB+ common block and would work fine from within an SB+ session. -Original Message- From:

[U2] UniOLEDB and Windows 2008/SQL 2008

2011-06-07 Thread Louise Yang
I'm trying to migrate SSIS packages from Windows 2003/SQL 2005 to Windows 2008/SQL 2008 and all the packages use UniOLEDB provider which doesn't' work with 64-bit Windows 2008. Any suggestions? -Louise Yang ___ U2-Users mailing list

Re: [U2] SB Error

2011-06-07 Thread Boydell, Stuart
Couple of possibilities I can think of... Check any dictionaries you're calling to make sure they aren't calling SB+ expressions. One of the SBCONTROL attributes allows you to compile all OS dictionaries as Itypes... When you run your test program, make sure you CLEAR.COMMON ALL first to

Re: [U2] [UniData] UniRPCD

2011-06-07 Thread Doug Averch
Hi: The lastest version we installed of UOJ about 4 months ago is 4.1.4. It seems to work on every version of Unidata back to 6.0. Those files are quite old, it could be your problem but before jumping to into old code you need to try the latest and greatest. Regards, Doug www.u2logic.com