RE: UVODBC/OleDB job Randomly hang
You have a semaphore lock that is not being released. You do not have to reboot the system to correct this problem. Simply run UNLOCK GROUPLOCK. This will release all of the grouplocks and complain about the semaphores that cannot be released. Then issue UNLOCK GROUPLOCK SEMAPHORE ##. You will need to do this for each semaphore that won't release, usually there is only one. Unfortunately, I do not have an answer on how to prevent the hung processes. -Original Message- From: Horacio Pellegrino [mailto:[EMAIL PROTECTED] Sent: Friday, April 30, 2004 3:36 PM To: U2 Users Discussion List Subject: Re: UVODBC/OleDB job Randomly hang I've seen that in older versions of ODBC and OleDB clients, I suggest you to update to the latest one. --- Bob Gerrish <[EMAIL PROTECTED]> escribió: > > I have a client running AIX, UniVerse 9.5.1.1 and > UVODBC 3.7 which they are > connecting to via .NET / OleDB. They see occasional > hangs from their > DataReader and consequently, kill their process and > reissue a query. Now > we are seeing some hangs on the UniVerse side such > that UniVerse > performance is greatly degraded and interactive > users cannot log in. When > this happens, they have been forced to restart > UniVerse. > > They have a uvodbc user set up that is called via > the .NET calls. Most of > the processes are owned by the user uvodbc, however, > the common thread is > that there are a number that are owned by root. > They are the processes > that tend to be the ones that hang about especially > when the system slows > down. > > Has anyone seen this sort of behavior, any > suggestions? > > > Thanks, > Bob Gerrish - [EMAIL PROTECTED] > > > -- > u2-users mailing list > [EMAIL PROTECTED] > http://www.oliver.com/mailman/listinfo/u2-users Los mejores usados y las más tentadoras ofertas de 0km están en Yahoo! Autos. Comprá o vendé tu auto en http://autos.yahoo.com.ar -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users ***THIS MESSAGE IS INTENDED ONLY FOR THE USE OF THE INDIVIDUAL OR ENTITY TO WHICH IT IS ADDRESSED AND MAY CONTAIN INFORMATION THAT IS PRIVILEGED, CONFIDENTIAL, AND EXEMPT FROM DISCLOSURE UNDER APPLICABLE LAW. If the reader of this message is not the intended recipient, or the employee or agent responsible fordelivering the message to the intended recipient, you are hereby notified that any dissemination, distribution, forwarding, or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the sender immediately by e-mail or telephone, and delete the original message immediately. For more information, please visit http://www.bakerlaw.com. Thank you. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: XML or WORD Format???
Don, Although we have LMS, it has been extremely customized over the years. The line draws are part of the print program using a different character set. So you are correct that the output is just text. The graphics I am referring to are the lines and the company logo that is also just a different font. We are currently writing the text to a download file and can open it in WORD. It looses the different sized fonts that are used and we do not have any way of importing back to LMS. John. -Original Message- From: Donald Kibbey [mailto:[EMAIL PROTECTED] Sent: Thursday, April 01, 2004 9:08 AM To: [EMAIL PROTECTED] Subject: RE: XML or WORD Format??? LMS only knows raw, plain text. That's all it's putting out. Have a look at /usr/spool/uv/drv. There's probably a couple of fancy scripts in there that are installing the image for you. If not, give me a holler offline and I can point you to the subroutine that puts out the invoice. Don Kibbey Financial Systems Manager Finnegan, Henderson, Farabow, Garrett & Dunner LLP >>> [EMAIL PROTECTED] 04/01/04 09:02AM >>> Don, We are using LMS from TMC. John. -Original Message- From: Donald Kibbey [mailto:[EMAIL PROTECTED] Sent: Thursday, April 01, 2004 8:56 AM To: [EMAIL PROTECTED] Subject: RE: XML or WORD Format??? Are you running LMS from TMC?? If so, then I have a solution that will do what your after. I use a couple of perl scripts and a Word macro to allow our billing staff to get a text version of the invoice in Word, mark it up and then re-print it back to the HP-UX machine. The reprint process takes the print file and turns it into a PDF that is then stored for future reference via a web based lookup page. Don Kibbey Financial Systems Manager Finnegan, Henderson, Farabow, Garrett & Dunner LLP >>> [EMAIL PROTECTED] 04/01/04 08:48AM >>> Thanks, The goal is to have a copy of our invoice that can be opened in WORD or Excel. I only mentioned the PCL and .pdf formats because these are already produced when we create an invoice. If there is another way please let me know. We are running Universe version 9.6. John. -Original Message- From: Anthony Youngman [mailto:[EMAIL PROTECTED] Sent: Thursday, April 01, 2004 8:43 AM To: U2 Users Discussion List Subject: RE: XML or WORD Format??? In one word - it's IMPOSSIBLE. Okay, you may be able to achieve what you want, though. The thing is, the output of pdf and pcl is an image, Word and xml are structured text. You can't go automatically from a structure-free format to a structured format. I'd investigate ghostscript, and see if you can get it to throw out a text document rather than postscript (or feed the postscript through a ps2txt filter), but if your original pdf or pcl was of a graphic, then you're stuffed without an ocr filter in place. So, basically, what you're after can be achieved, but without knowing what is IN your input files, it's impossible to recommend (or even guess) what might or might not work. Cheers, Wol -----Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Haas, John Sent: 01 April 2004 14:33 To: U2 Users Discussion List Subject: XML or WORD Format??? Does Anyone know of a way to convert either .pdf or PCL formats to XML and/or WORD format that will run under HP-UX. Thanks in advance. John. *** THIS MESSAGE IS INTENDED ONLY FOR THE USE OF THE INDIVIDUAL OR ENTITY TO WHICH IT IS ADDRESSED AND MAY CONTAIN INFORMATION THAT IS PRIVILEGED, CONFIDENTIAL, AND EXEMPT FROM DISCLOSURE UNDER APPLICABLE LAW. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution, forwarding, or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the sender immediately by e-mail or telephone, and delete the original message immediately. For more information, please visit http://www.bakerlaw.com. Thank you. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are:
RE: XML or WORD Format???
Don, We are using LMS from TMC. John. -Original Message- From: Donald Kibbey [mailto:[EMAIL PROTECTED] Sent: Thursday, April 01, 2004 8:56 AM To: [EMAIL PROTECTED] Subject: RE: XML or WORD Format??? Are you running LMS from TMC?? If so, then I have a solution that will do what your after. I use a couple of perl scripts and a Word macro to allow our billing staff to get a text version of the invoice in Word, mark it up and then re-print it back to the HP-UX machine. The reprint process takes the print file and turns it into a PDF that is then stored for future reference via a web based lookup page. Don Kibbey Financial Systems Manager Finnegan, Henderson, Farabow, Garrett & Dunner LLP >>> [EMAIL PROTECTED] 04/01/04 08:48AM >>> Thanks, The goal is to have a copy of our invoice that can be opened in WORD or Excel. I only mentioned the PCL and .pdf formats because these are already produced when we create an invoice. If there is another way please let me know. We are running Universe version 9.6. John. -Original Message- From: Anthony Youngman [mailto:[EMAIL PROTECTED] Sent: Thursday, April 01, 2004 8:43 AM To: U2 Users Discussion List Subject: RE: XML or WORD Format??? In one word - it's IMPOSSIBLE. Okay, you may be able to achieve what you want, though. The thing is, the output of pdf and pcl is an image, Word and xml are structured text. You can't go automatically from a structure-free format to a structured format. I'd investigate ghostscript, and see if you can get it to throw out a text document rather than postscript (or feed the postscript through a ps2txt filter), but if your original pdf or pcl was of a graphic, then you're stuffed without an ocr filter in place. So, basically, what you're after can be achieved, but without knowing what is IN your input files, it's impossible to recommend (or even guess) what might or might not work. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Haas, John Sent: 01 April 2004 14:33 To: U2 Users Discussion List Subject: XML or WORD Format??? Does Anyone know of a way to convert either .pdf or PCL formats to XML and/or WORD format that will run under HP-UX. Thanks in advance. John. *** THIS MESSAGE IS INTENDED ONLY FOR THE USE OF THE INDIVIDUAL OR ENTITY TO WHICH IT IS ADDRESSED AND MAY CONTAIN INFORMATION THAT IS PRIVILEGED, CONFIDENTIAL, AND EXEMPT FROM DISCLOSURE UNDER APPLICABLE LAW. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution, forwarding, or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the sender immediately by e-mail or telephone, and delete the original message immediately. For more information, please visit http://www.bakerlaw.com. Thank you. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** THIS MESSAGE IS INTENDED ONLY FOR THE USE OF THE INDIVIDUAL OR ENTITY TO WHICH IT IS ADDRESSED AND MAY CONTAIN INFORMATION THAT IS PRIVILEGED, CONFIDENTIAL, AND EXEMPT FROM DISCLOSURE UNDER APPLICABLE LAW. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution, forwarding, or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the sender immediately by e-mail or telephone, and delete the original message immediately. For more information, please visit http://www.bakerlaw.com. Thank you. *** -- u2-users m
RE: XML or WORD Format???
Unfortunately, the invoices themselves have the graphics embedded. However, I can capture just the text without loosing the structure. John. -Original Message- From: Anthony Youngman [mailto:[EMAIL PROTECTED] Sent: Thursday, April 01, 2004 8:54 AM To: U2 Users Discussion List Subject: RE: XML or WORD Format??? Ah ... This looks good. Are your invoices prettied up in any way, or are they just courier on preprinted paper? If the latter, any nix programmer worth his salt ought to be able to faff about with awk, sed or similar to strip out escape sequences, make sure the right characters are used for line feeds and page throws, and convert pcl to txt. Get a pcl manual, use Midnight Commander to view the pcl in binary mode, and get playing :-) If the invoices are pretty-pretty word-processed type stuff, it gets harder ... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Haas, John Sent: 01 April 2004 14:49 To: U2 Users Discussion List Subject: RE: XML or WORD Format??? Thanks, The goal is to have a copy of our invoice that can be opened in WORD or Excel. I only mentioned the PCL and .pdf formats because these are already produced when we create an invoice. If there is another way please let me know. We are running Universe version 9.6. John. -Original Message- From: Anthony Youngman [mailto:[EMAIL PROTECTED] Sent: Thursday, April 01, 2004 8:43 AM To: U2 Users Discussion List Subject: RE: XML or WORD Format??? In one word - it's IMPOSSIBLE. Okay, you may be able to achieve what you want, though. The thing is, the output of pdf and pcl is an image, Word and xml are structured text. You can't go automatically from a structure-free format to a structured format. I'd investigate ghostscript, and see if you can get it to throw out a text document rather than postscript (or feed the postscript through a ps2txt filter), but if your original pdf or pcl was of a graphic, then you're stuffed without an ocr filter in place. So, basically, what you're after can be achieved, but without knowing what is IN your input files, it's impossible to recommend (or even guess) what might or might not work. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Haas, John Sent: 01 April 2004 14:33 To: U2 Users Discussion List Subject: XML or WORD Format??? Does Anyone know of a way to convert either .pdf or PCL formats to XML and/or WORD format that will run under HP-UX. Thanks in advance. John. *** THIS MESSAGE IS INTENDED ONLY FOR THE USE OF THE INDIVIDUAL OR ENTITY TO WHICH IT IS ADDRESSED AND MAY CONTAIN INFORMATION THAT IS PRIVILEGED, CONFIDENTIAL, AND EXEMPT FROM DISCLOSURE UNDER APPLICABLE LAW. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution, forwarding, or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the sender immediately by e-mail or telephone, and delete the original message immediately. For more information, please visit http://www.bakerlaw.com. Thank you. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** THIS MESSAGE IS INTENDED ONLY FOR THE USE OF THE INDIVIDUAL OR ENTITY TO WHICH IT IS ADDRESSED AND MAY CONTAIN INFORMATION THAT IS PRIVILEGED, CONFIDENTIAL, AND EXEMPT FROM DISCLOSURE UNDER APPLICABLE LAW. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution, forwarding, or copying of this communication is strictly prohibited. If you have received this communic
RE: XML or WORD Format???
Thanks, The goal is to have a copy of our invoice that can be opened in WORD or Excel. I only mentioned the PCL and .pdf formats because these are already produced when we create an invoice. If there is another way please let me know. We are running Universe version 9.6. John. -Original Message- From: Anthony Youngman [mailto:[EMAIL PROTECTED] Sent: Thursday, April 01, 2004 8:43 AM To: U2 Users Discussion List Subject: RE: XML or WORD Format??? In one word - it's IMPOSSIBLE. Okay, you may be able to achieve what you want, though. The thing is, the output of pdf and pcl is an image, Word and xml are structured text. You can't go automatically from a structure-free format to a structured format. I'd investigate ghostscript, and see if you can get it to throw out a text document rather than postscript (or feed the postscript through a ps2txt filter), but if your original pdf or pcl was of a graphic, then you're stuffed without an ocr filter in place. So, basically, what you're after can be achieved, but without knowing what is IN your input files, it's impossible to recommend (or even guess) what might or might not work. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Haas, John Sent: 01 April 2004 14:33 To: U2 Users Discussion List Subject: XML or WORD Format??? Does Anyone know of a way to convert either .pdf or PCL formats to XML and/or WORD format that will run under HP-UX. Thanks in advance. John. *** THIS MESSAGE IS INTENDED ONLY FOR THE USE OF THE INDIVIDUAL OR ENTITY TO WHICH IT IS ADDRESSED AND MAY CONTAIN INFORMATION THAT IS PRIVILEGED, CONFIDENTIAL, AND EXEMPT FROM DISCLOSURE UNDER APPLICABLE LAW. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution, forwarding, or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the sender immediately by e-mail or telephone, and delete the original message immediately. For more information, please visit http://www.bakerlaw.com. Thank you. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** THIS MESSAGE IS INTENDED ONLY FOR THE USE OF THE INDIVIDUAL OR ENTITY TO WHICH IT IS ADDRESSED AND MAY CONTAIN INFORMATION THAT IS PRIVILEGED, CONFIDENTIAL, AND EXEMPT FROM DISCLOSURE UNDER APPLICABLE LAW. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution, forwarding, or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the sender immediately by e-mail or telephone, and delete the original message immediately. For more information, please visit http://www.bakerlaw.com. Thank you. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
XML or WORD Format???
Does Anyone know of a way to convert either .pdf or PCL formats to XML and/or WORD format that will run under HP-UX. Thanks in advance. John. *** THIS MESSAGE IS INTENDED ONLY FOR THE USE OF THE INDIVIDUAL OR ENTITY TO WHICH IT IS ADDRESSED AND MAY CONTAIN INFORMATION THAT IS PRIVILEGED, CONFIDENTIAL, AND EXEMPT FROM DISCLOSURE UNDER APPLICABLE LAW. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution, forwarding, or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the sender immediately by e-mail or telephone, and delete the original message immediately. For more information, please visit http://www.bakerlaw.com. Thank you. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Text file to PDF
Trevor, We have many reports that are converted to .pdf and emailed daily without any intervention. We user Pcl2pdf software from Visual Software. Te product is very inexpensive. All you need to remember is the -lt:2 option on the command line. John. -Original Message- From: Trevor Ockenden [mailto:[EMAIL PROTECTED] Sent: Monday, March 29, 2004 10:36 PM To: [EMAIL PROTECTED] Subject: Text file to PDF And now for something completely different! Any help or suggestions regarding converting out text reports in the &HOLD& file to PDF files for subsequent e-mailing. Cheers Trevor Ockenden Open Systems Professionals M: +61 414 731 634 E: [EMAIL PROTECTED] --- Outgoing mail is certified Virus Free by AVG 6.0. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.642 / Virus Database: 410 - Release Date: 24/03/2004 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** THIS MESSAGE IS INTENDED ONLY FOR THE USE OF THE INDIVIDUAL OR ENTITY TO WHICH IT IS ADDRESSED AND MAY CONTAIN INFORMATION THAT IS PRIVILEGED, CONFIDENTIAL, AND EXEMPT FROM DISCLOSURE UNDER APPLICABLE LAW. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution, forwarding, or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the sender immediately by e-mail or telephone, and delete the original message immediately. For more information, please visit http://www.bakerlaw.com. Thank you. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
UVODBC - SQL DTS job Randomly hangs
I am running HP-UX 11.00 , Universe version 9.6.1.6 and Uvodbc version 3.7. I have 17 jobs scheduled in SQLAgent that run 47 DTS packages each night to refresh the data from my Universe database to my SQL 2000 database. These jobs are not being modified and the database layout is not being modified. Most of the time all of the jobs complete without any problems. Periodically, one of the jobs (never more than one) and not the same job twice in a row, will hang on the SQL server. The uvosrv process runs on the Universe server for 4 hours and then logs a message stating: 'Server shutting down: The client is not responding to keep-alive pings. Disconnecting!' The 4 hours matches the inactivity timeout of 240 minutes in the odbc configuration. The SQL job will run until it is manually canceled. I then start the process on the SQL server and it will complete without errors. I would appreciate any help concerning this situation. Thanks, Jay. *** THIS MESSAGE IS INTENDED ONLY FOR THE USE OF THE INDIVIDUAL OR ENTITY TO WHICH IT IS ADDRESSED AND MAY CONTAIN INFORMATION THAT IS PRIVILEGED, CONFIDENTIAL, AND EXEMPT FROM DISCLOSURE UNDER APPLICABLE LAW. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution, forwarding, or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the sender immediately by e-mail or telephone, and delete the original message immediately. For more information, please visit http://www.bakerlaw.com. Thank you. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users