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: [email protected] [mailto:[email protected]] 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 nnnn FILEMAP (where nnnn 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: [email protected] Web: www.rocketsoftware.com/u2 -----Original Message----- From: [email protected] [mailto:[email protected]] 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: [email protected] [mailto:[email protected]] 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: [email protected] [mailto:[email protected]] 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: [email protected] [mailto:[email protected]] 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: [email protected] [mailto:[email protected]] 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 [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users <html> <body> ________________________________ Dave Davis Team Lead, R&D P: 614-875-4910 x108 F: 614-875-4088 E: [email protected] [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 [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users <html> <body> ________________________________ Dave Davis Team Lead, R&D P: 614-875-4910 x108 F: 614-875-4088 E: [email protected] [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 [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
