[U2] SB Error
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 blowing up with the following: In /usr/igi/sb54/SB.DEFN/DM/_SB.PROCESS at line 76 Can not access unopened file. File variable not used in file operation In /usr/igi/sb54/SB.DEFN/DM/_SB.PROCESS at line 76 Fatal error: READ error Obviously I do not have the source code for SB, so I can not see what file it trying to access. Does anyone have a clue as to what I need to open OUTSIDE of SB so that I can call SB.PROCESS? John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH 45342 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SB Error
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 web interface run through the same account as the SB+ side? If not, are all those files in the other account's VOC? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Tuesday, June 07, 2011 11:03 AM To: 'U2 Users List' Subject: [U2] SB Error 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 blowing up with the following: In /usr/igi/sb54/SB.DEFN/DM/_SB.PROCESS at line 76 Can not access unopened file. File variable not used in file operation In /usr/igi/sb54/SB.DEFN/DM/_SB.PROCESS at line 76 Fatal error: READ error Obviously I do not have the source code for SB, so I can not see what file it trying to access. Does anyone have a clue as to what I need to open OUTSIDE of SB so that I can call SB.PROCESS? John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH 45342 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html body Dave Davis Team Lead, Ramp;D P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif] 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. /body /html ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] [UniData] UniRPCD
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 day) see this exception. [39207] occurred on server. Possible client-side licensing failure. Just after I see it, I run the same program from my terminal. I can connect to the destination UniData host without a problem. We have more than enough udt licenses. Also, I am not using connection pooling. netstat -sp tcp in UniData host shows me this: 0 connect requests dropped due to full queue. So I think our tcp socket setup on the UniData host should be ok. I can work around this problem by changing my code (sleep and try again.). But... asjava.zip I use currently contains classes from 12-07-06 ( I think this guy came with UD 7.1 client package. But I am not positive...). However, classes in asjava.zip I found in $UDTHOME/unishared/uojskd/lib on the host has time stamp of 09-10-04 (contains 49 files)... I wonder one I am using is not compatible with 7.1.23 (contains 52 files). Do I suppose to use asjava.zip from 09-10-04? Or do you think unirpcd or programs executed from it may have some issues? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SB Error
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. It obviously is not a common condition because we just recently encountered this problem for the first time. My new stand-alone program gets about 1500 records into the loop before hitting the error below (which is NOT the error I was actually trying to solve). 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 Dave Davis Sent: Tuesday, June 07, 2011 11:12 AM To: U2 Users List Subject: Re: [U2] SB Error 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 web interface run through the same account as the SB+ side? If not, are all those files in the other account's VOC? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Tuesday, June 07, 2011 11:03 AM To: 'U2 Users List' Subject: [U2] SB Error 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 blowing up with the following: In /usr/igi/sb54/SB.DEFN/DM/_SB.PROCESS at line 76 Can not access unopened file. File variable not used in file operation In /usr/igi/sb54/SB.DEFN/DM/_SB.PROCESS at line 76 Fatal error: READ error Obviously I do not have the source code for SB, so I can not see what file it trying to access. Does anyone have a clue as to what I need to open OUTSIDE of SB so that I can call SB.PROCESS? John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH 45342 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html body Dave Davis Team Lead, Ramp;D P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif] 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. /body /html ___ 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] SB Error
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: Tuesday, June 07, 2011 11:30 AM To: 'U2 Users List' Subject: Re: [U2] SB Error 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. It obviously is not a common condition because we just recently encountered this problem for the first time. My new stand-alone program gets about 1500 records into the loop before hitting the error below (which is NOT the error I was actually trying to solve). 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 Dave Davis Sent: Tuesday, June 07, 2011 11:12 AM To: U2 Users List Subject: Re: [U2] SB Error 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 web interface run through the same account as the SB+ side? If not, are all those files in the other account's VOC? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Tuesday, June 07, 2011 11:03 AM To: 'U2 Users List' Subject: [U2] SB Error 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 blowing up with the following: In /usr/igi/sb54/SB.DEFN/DM/_SB.PROCESS at line 76 Can not access unopened file. File variable not used in file operation In /usr/igi/sb54/SB.DEFN/DM/_SB.PROCESS at line 76 Fatal error: READ error Obviously I do not have the source code for SB, so I can not see what file it trying to access. Does anyone have a clue as to what I need to open OUTSIDE of SB so that I can call SB.PROCESS? John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH 45342 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html body Dave Davis Team Lead, Ramp;D P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif] 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. /body /html ___ 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 html body Dave Davis Team Lead, Ramp;D P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif] 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. /body /html ___ U2-Users
Re: [U2] SB Error
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 Street, Suite 1100 ..Denver, CO 80237 ..USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Tuesday, June 07, 2011 9:56 AM To: 'U2 Users List' Subject: Re: [U2] SB Error The new stand-alone program is truly a program. It loops through the records, and for each record, populates the arguments as if it were called via the subroutine behind the web page, then calls the shared subroutine. I don't think it would be hitting the MAX_OPEN_FILE limit, though that is a thought. How would I actually capture the number of files that are open? I could throw a CRT into my stand-along program if I know that info. This thing is so obscure that I am not even sure what program is doing the calling to SB.PROCESS, though obviously it must be somewhere in the chain of subroutines called in the SB account. It works fine for 1500+ records before blowing up. 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 Dave Davis Sent: Tuesday, June 07, 2011 11:42 AM To: U2 Users List Subject: Re: [U2] SB Error 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: Tuesday, June 07, 2011 11:30 AM To: 'U2 Users List' Subject: Re: [U2] SB Error 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. It obviously is not a common condition because we just recently encountered this problem for the first time. My new stand-alone program gets about 1500 records into the loop before hitting the error below (which is NOT the error I was actually trying to solve). 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 Dave Davis Sent: Tuesday, June 07, 2011 11:12 AM To: U2 Users List Subject: Re: [U2] SB Error 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 web interface run through the same account as the SB+ side? If not, are all those files in the other account's VOC? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Tuesday, June 07, 2011 11:03 AM To: 'U2 Users List' Subject: [U2] SB Error 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 blowing up with the following: In /usr/igi/sb54/SB.DEFN/DM/_SB.PROCESS at line 76 Can not access unopened file. File variable not used in file operation In /usr/igi/sb54/SB.DEFN/DM/_SB.PROCESS at line 76 Fatal error: READ error Obviously I do not have the source code for SB, so I can not see what file it trying to access. Does anyone have a clue as to what I need to open OUTSIDE of SB so that I can call SB.PROCESS? John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH 45342 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html body Dave Davis Team Lead, Ramp;D P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif] 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to
Re: [U2] SB Error
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 Terhune Sent: Tuesday, June 07, 2011 11:59 AM To: U2 Users List Subject: Re: [U2] SB Error 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 Street, Suite 1100 ..Denver, CO 80237 ..USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Tuesday, June 07, 2011 9:56 AM To: 'U2 Users List' Subject: Re: [U2] SB Error The new stand-alone program is truly a program. It loops through the records, and for each record, populates the arguments as if it were called via the subroutine behind the web page, then calls the shared subroutine. I don't think it would be hitting the MAX_OPEN_FILE limit, though that is a thought. How would I actually capture the number of files that are open? I could throw a CRT into my stand-along program if I know that info. This thing is so obscure that I am not even sure what program is doing the calling to SB.PROCESS, though obviously it must be somewhere in the chain of subroutines called in the SB account. It works fine for 1500+ records before blowing up. 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 Dave Davis Sent: Tuesday, June 07, 2011 11:42 AM To: U2 Users List Subject: Re: [U2] SB Error 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: Tuesday, June 07, 2011 11:30 AM To: 'U2 Users List' Subject: Re: [U2] SB Error 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. It obviously is not a common condition because we just recently encountered this problem for the first time. My new stand-alone program gets about 1500 records into the loop before hitting the error below (which is NOT the error I was actually trying to solve). 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 Dave Davis Sent: Tuesday, June 07, 2011 11:12 AM To: U2 Users List Subject: Re: [U2] SB Error 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 web interface run through the same account as the SB+ side? If not, are all those files in the other account's VOC? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Tuesday, June 07, 2011 11:03 AM To: 'U2 Users List' Subject: [U2] SB Error 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 blowing up with the following: In /usr/igi/sb54/SB.DEFN/DM/_SB.PROCESS at line 76 Can not access unopened file. File variable not used in file operation In /usr/igi/sb54/SB.DEFN/DM/_SB.PROCESS at line 76 Fatal error: READ error Obviously I do not have the source code for SB, so I can not see what file it trying to access. Does anyone have a clue as to what I need to open OUTSIDE of SB so that I can call SB.PROCESS? John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH 45342 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html body
Re: [U2] SB Error
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 45342 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Tuesday, June 07, 2011 12:13 PM To: 'U2 Users List' Subject: Re: [U2] SB Error 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 Terhune Sent: Tuesday, June 07, 2011 11:59 AM To: U2 Users List Subject: Re: [U2] SB Error 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 Street, Suite 1100 ..Denver, CO 80237 ..USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Tuesday, June 07, 2011 9:56 AM To: 'U2 Users List' Subject: Re: [U2] SB Error The new stand-alone program is truly a program. It loops through the records, and for each record, populates the arguments as if it were called via the subroutine behind the web page, then calls the shared subroutine. I don't think it would be hitting the MAX_OPEN_FILE limit, though that is a thought. How would I actually capture the number of files that are open? I could throw a CRT into my stand-along program if I know that info. This thing is so obscure that I am not even sure what program is doing the calling to SB.PROCESS, though obviously it must be somewhere in the chain of subroutines called in the SB account. It works fine for 1500+ records before blowing up. 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 Dave Davis Sent: Tuesday, June 07, 2011 11:42 AM To: U2 Users List Subject: Re: [U2] SB Error 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: Tuesday, June 07, 2011 11:30 AM To: 'U2 Users List' Subject: Re: [U2] SB Error 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. It obviously is not a common condition because we just recently encountered this problem for the first time. My new stand-alone program gets about 1500 records into the loop before hitting the error below (which is NOT the error I was actually trying to solve). 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 Dave Davis Sent: Tuesday, June 07, 2011 11:12 AM To: U2 Users List Subject: Re: [U2] SB Error 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 web interface run through the same account as the SB+ side? If not, are all those files in the other account's VOC? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Tuesday, June 07, 2011 11:03 AM To: 'U2 Users List' Subject: [U2] SB Error 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 blowing up with the following: In /usr/igi/sb54/SB.DEFN/DM/_SB.PROCESS at line 76 Can not access unopened file. File variable not used in file operation In
Re: [U2] SB Error
...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 Message - *From:* wterh...@rocketsoftware.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 6/7/2011 8:59 AM *Subject:* Re: [U2] SB Error 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 Street, Suite 1100 ..Denver, CO 80237 ..USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Tuesday, June 07, 2011 9:56 AM To: 'U2 Users List' Subject: Re: [U2] SB Error The new stand-alone program is truly a program. It loops through the records, and for each record, populates the arguments as if it were called via the subroutine behind the web page, then calls the shared subroutine. I don't think it would be hitting the MAX_OPEN_FILE limit, though that is a thought. How would I actually capture the number of files that are open? I could throw a CRT into my stand-along program if I know that info. This thing is so obscure that I am not even sure what program is doing the calling to SB.PROCESS, though obviously it must be somewhere in the chain of subroutines called in the SB account. It works fine for 1500+ records before blowing up. 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 Dave Davis Sent: Tuesday, June 07, 2011 11:42 AM To: U2 Users List Subject: Re: [U2] SB Error 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: Tuesday, June 07, 2011 11:30 AM To: 'U2 Users List' Subject: Re: [U2] SB Error 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. It obviously is not a common condition because we just recently encountered this problem for the first time. My new stand-alone program gets about 1500 records into the loop before hitting the error below (which is NOT the error I was actually trying to solve). 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 Dave Davis Sent: Tuesday, June 07, 2011 11:12 AM To: U2 Users List Subject: Re: [U2] SB Error 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 web interface run through the same account as the SB+ side? If not, are all those files in the other account's VOC? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Tuesday, June 07, 2011 11:03 AM To: 'U2 Users List' Subject: [U2] SB Error 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 blowing up with the following: In /usr/igi/sb54/SB.DEFN/DM/_SB.PROCESS at line 76 Can not access unopened file. File variable not used in file operation In /usr/igi/sb54/SB.DEFN/DM/_SB.PROCESS at line 76 Fatal error: READ error Obviously I do not have the source code for SB, so I can not see what file it trying to access. Does anyone have a clue as to what I need to open OUTSIDE of SB so that I can call SB.PROCESS? John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH 45342 ___ U2-Users mailing list U2-Users@listserver.u2ug.org
Re: [U2] SB Error
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 reference to one of the SB+ common variables - which weren't set when called from outside - but were when I ran my test routine It was looking at something in a dimensioned array which was coming across as 0 instead of . In my case it was using the variable to determine the mv position and the 0 was pulling back the whole attribute instead of just the correct mv. You may also want to check your SB+ files.opened variables. Good luck Colin Alfke Calgary, Canada -Original Message- From: Israel, John R. The new stand-alone program is truly a program. It loops through the records, and for each record, populates the arguments as if it were called via the subroutine behind the web page, then calls the shared subroutine. I don't think it would be hitting the MAX_OPEN_FILE limit, though that is a thought. How would I actually capture the number of files that are open? I could throw a CRT into my stand-along program if I know that info. This thing is so obscure that I am not even sure what program is doing the calling to SB.PROCESS, though obviously it must be somewhere in the chain of subroutines called in the SB account. It works fine for 1500+ records before blowing up. John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH 45342 -Original Message- From: 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. It obviously is not a common condition because we just recently encountered this problem for the first time. My new stand-alone program gets about 1500 records into the loop before hitting the error below (which is NOT the error I was actually trying to solve). John Israel -Original Message- From: 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 web interface run through the same account as the SB+ side? If not, are all those files in the other account's VOC? -Original Message- From: 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 blowing up with the following: In /usr/igi/sb54/SB.DEFN/DM/_SB.PROCESS at line 76 Can not access unopened file. File variable not used in file operation In /usr/igi/sb54/SB.DEFN/DM/_SB.PROCESS at line 76 Fatal error: READ error Obviously I do not have the source code for SB, so I can not see what file it trying to access. Does anyone have a clue as to what I need to open OUTSIDE of SB so that I can call SB.PROCESS? John Israel ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SB Error
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 problems. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Tuesday, June 07, 2011 11:56 AM To: 'U2 Users List' Subject: Re: [U2] SB Error The new stand-alone program is truly a program. It loops through the records, and for each record, populates the arguments as if it were called via the subroutine behind the web page, then calls the shared subroutine. I don't think it would be hitting the MAX_OPEN_FILE limit, though that is a thought. How would I actually capture the number of files that are open? I could throw a CRT into my stand-along program if I know that info. This thing is so obscure that I am not even sure what program is doing the calling to SB.PROCESS, though obviously it must be somewhere in the chain of subroutines called in the SB account. It works fine for 1500+ records before blowing up. 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 Dave Davis Sent: Tuesday, June 07, 2011 11:42 AM To: U2 Users List Subject: Re: [U2] SB Error 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: Tuesday, June 07, 2011 11:30 AM To: 'U2 Users List' Subject: Re: [U2] SB Error 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. It obviously is not a common condition because we just recently encountered this problem for the first time. My new stand-alone program gets about 1500 records into the loop before hitting the error below (which is NOT the error I was actually trying to solve). 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 Dave Davis Sent: Tuesday, June 07, 2011 11:12 AM To: U2 Users List Subject: Re: [U2] SB Error 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 web interface run through the same account as the SB+ side? If not, are all those files in the other account's VOC? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Tuesday, June 07, 2011 11:03 AM To: 'U2 Users List' Subject: [U2] SB Error 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 blowing up with the following: In /usr/igi/sb54/SB.DEFN/DM/_SB.PROCESS at line 76 Can not access unopened file. File variable not used in file operation In /usr/igi/sb54/SB.DEFN/DM/_SB.PROCESS at line 76 Fatal error: READ error Obviously I do not have the source code for SB, so I can not see what file it trying to access. Does anyone have a clue as to what I need to open OUTSIDE of SB so that I can call SB.PROCESS? John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH 45342 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html body Dave Davis Team Lead, Ramp;D P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif] 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or
Re: [U2] SB Error
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-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Tuesday, June 07, 2011 11:30 AM To: 'U2 Users List' Subject: Re: [U2] SB Error 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. It obviously is not a common condition because we just recently encountered this problem for the first time. My new stand-alone program gets about 1500 records into the loop before hitting the error below (which is NOT the error I was actually trying to solve). 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 Dave Davis Sent: Tuesday, June 07, 2011 11:12 AM To: U2 Users List Subject: Re: [U2] SB Error 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 web interface run through the same account as the SB+ side? If not, are all those files in the other account's VOC? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Tuesday, June 07, 2011 11:03 AM To: 'U2 Users List' Subject: [U2] SB Error 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 blowing up with the following: In /usr/igi/sb54/SB.DEFN/DM/_SB.PROCESS at line 76 Can not access unopened file. File variable not used in file operation In /usr/igi/sb54/SB.DEFN/DM/_SB.PROCESS at line 76 Fatal error: READ error Obviously I do not have the source code for SB, so I can not see what file it trying to access. Does anyone have a clue as to what I need to open OUTSIDE of SB so that I can call SB.PROCESS? John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH 45342 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html body Dave Davis Team Lead, Ramp;D P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif] 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. /body /html ___ 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 html body Dave Davis Team Lead, Ramp;D P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif] 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately
[U2] UniOLEDB and Windows 2008/SQL 2008
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 U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SB Error
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 emulate a non SB+ login. (fiddy cents worth) Stuart -Original Message- From: Dave Davis Sent: Wednesday, 8 June 2011 3:42 To: U2 Users List Subject: Re: [U2] SB Error 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-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Tuesday, June 07, 2011 11:30 AM To: 'U2 Users List' Subject: Re: [U2] SB Error 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. It obviously is not a common condition because we just recently encountered this problem for the first time. My new stand-alone program gets about 1500 records into the loop before hitting the error below (which is NOT the error I was actually trying to solve). 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 Dave Davis Sent: Tuesday, June 07, 2011 11:12 AM To: U2 Users List Subject: Re: [U2] SB Error 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 web interface run through the same account as the SB+ side? If not, are all those files in the other account's VOC? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Tuesday, June 07, 2011 11:03 AM To: 'U2 Users List' Subject: [U2] SB Error 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 blowing up with the following: In /usr/igi/sb54/SB.DEFN/DM/_SB.PROCESS at line 76 Can not access unopened file. File variable not used in file operation In /usr/igi/sb54/SB.DEFN/DM/_SB.PROCESS at line 76 Fatal error: READ error Obviously I do not have the source code for SB, so I can not see what file it trying to access. Does anyone have a clue as to what I need to open OUTSIDE of SB so that I can call SB.PROCESS? John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH 45342 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html body Dave Davis Team Lead, Ramp;D P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif] 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. /body /html ___ 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 html body Dave Davis Team Lead, Ramp;D P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif] 6110 Enterprise Parkway Grove City, OH 43123
Re: [U2] [UniData] UniRPCD
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 Eclipse based Resizing and Editor for U2 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
