Re: [U2] Migrating UniVerse 10.1.20 on HP-UX to UV 11.x on Redhat Linux
If we are talking about migration between endians, I usually just move the lot via tar or system-to-system RSYNC then use fnuxi to perform the endian conversion in batch like this: cd /path/to/where/accounts/live find . -name * -exec /path/to/uv/bin/fnuxi {} \; This targets everything in /path/to/where/accounts/live including hashed files that live in sub-sub directories. It targets files that are not universe and have no need for a fnuxi conversion. fnuxi seems to check the header of the file and determine if its a universe hashed file and, if not, skips it. The technique relies on fnuxi's discrimination. It blows a lot of stuff to the screen as it tells you that it's not going to process many of the file files it encounters because they are not hashed files. In the end it will have traversed everything you laid down into that directory and it's subdirectories and performed a fnuxi conversion on everything hashed. I've not tried this with dynamic files but I think it will work with those too. Of course, one would be wise to perform a backup of the lot before attempting any enmasse data conversion... just in case. -BD On 1/7/2014 11:34 PM, Hona, David wrote: Did you use format.conv (UNIX / DOS/Windows command) or FORMAT.CONV (TCL command) on the HPUX sourced files that restored - post-restore? This will convert them into the format required for the target system... There are many options to choose from...see Admin.pdf (In the UV11.1 edition, see section 15-21 - PDF page 362 or do a TCL HELP FORMAT.CONV) A quick google would've revealed to you the following thread... which could be useful as well... http://u2-universe-unidata.1073795.n5.nabble.com/UniVerse-On-RedHat-td7144.html -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of mburgun Sent: Wednesday, 8 January 2014 4:56 PM To: u2-users@listserver.u2ug.org Subject: [U2] Migrating UniVerse 10.1.20 on HP-UX to UV 11.x on Redhat Linux Hi, The general consensus seems to be that when migrating UniVerse across platforms the best approach is to use UVBACKUP on the old platform and then UVRESTORE on the target platform and all platform issues are taken care of. We, however have just attempted this process in migrating UniVerse 10.1.20 on HP-UX to UV 11.x on Redhat Linux and have come across the following problem ... UVBACKUP seemed to worked OK (we were able to restore on old platform UVRESTORE seemed to work OK on target platform http://u2-universe-unidata.1073795.n5.nabble.com/file/n42468/uvscreen.png In the above screenshot the directory contains UniVerse files but UniVerse doesn’t recognise them. UniVerse can’t run in this directory without its essential database files. Answering “Y” to the question also won’t work as UniVerse is unable to initialise the directory while it contains rubbish files having the same names as the required UniVerse files. Does anyone have any ideas? Thanks! Michael -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/Migrating-UniVerse-10-1-20-on-HP-UX-to-UV-11-x-on-Redhat-Linux-tp42468.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ 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
[U2] USERS command in Universe
The HELP USERS doesn't really say anything useful. When I do a LISTU I count 87 sessions USERS says there are 74 users logged on the system That's close to what I might say are the unique users, since some people have more than one session. But I can't get it exact. Does USERS count phantoms? console jobs? jobs like that uvdlock and uvcleanup and uvsmm? How about jobs from Uniobjects making it's brief connections (uvcs), are those USERS for the purpose of this verb? And if there's any better documentation about exactly what USERS is doing, can you point it at me? Thanks. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] USERS command in Universe
Wil, As we all already know, there is no help for users! They are truly helpless. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, January 08, 2014 2:22 PM To: u2-users@listserver.u2ug.org Subject: [U2] USERS command in Universe The HELP USERS doesn't really say anything useful. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Migrating UniVerse 10.1.20 on HP-UX to UV 11.x on Redhat Linux
On 08/01/2014 06:34, Hona, David wrote: Did you use format.conv (UNIX / DOS/Windows command) or FORMAT.CONV (TCL command) on the HPUX sourced files that restored - post-restore? This will convert them into the format required for the target system... I hate to say it, but I think you've missed something crucial ... iirc FORMAT.CONV doesn't affect file format, rather it changes the date format from American to European, so that's the wrong command. HOWEVER the OP used UVBACKUP / UVRESTORE, the whold point of which is to *avoid* all these endian problems! UVBACKUP dumps the database as *text*, and then UVRESTORE puts it back. So the file should be created on the new system in the new endian format without any problems. There are many options to choose from...see Admin.pdf (In the UV11.1 edition, see section 15-21 - PDF page 362 or do a TCL HELP FORMAT.CONV) A quick google would've revealed to you the following thread... which could be useful as well... http://u2-universe-unidata.1073795.n5.nabble.com/UniVerse-On-RedHat-td7144.html Bearing in mind I've never done this, what I would try is ... Do a UVBACKUP at the account level to save the account on the old system. Delete the contents of the account directory on the new system, then run UV to create a new empty account. UVRESTORE your backup into the directory. A lot more hassle than a global UVBACKUP / UVRESTORE if you have multiple accounts, but it might work. The other thing is to put a fault call into Rocket, because this ought to work! I wonder ... could it be because the new system has a newer version of UV, and somehow the account upgrade mechanism is cutting in and messing up? Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Migrating UniVerse 10.1.20 on HP-UX to UV 11.x on Redhat Linux
No David is correct, you are thinking of DATE.FORMAT -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Anthonys Lists Sent: Thursday, 9 January 2014 11:11 a.m. To: U2 Users List Subject: Re: [U2] Migrating UniVerse 10.1.20 on HP-UX to UV 11.x on Redhat Linux On 08/01/2014 06:34, Hona, David wrote: Did you use format.conv (UNIX / DOS/Windows command) or FORMAT.CONV (TCL command) on the HPUX sourced files that restored - post-restore? This will convert them into the format required for the target system... I hate to say it, but I think you've missed something crucial ... iirc FORMAT.CONV doesn't affect file format, rather it changes the date format from American to European, so that's the wrong command. HOWEVER the OP used UVBACKUP / UVRESTORE, the whold point of which is to *avoid* all these endian problems! UVBACKUP dumps the database as *text*, and then UVRESTORE puts it back. So the file should be created on the new system in the new endian format without any problems. There are many options to choose from...see Admin.pdf (In the UV11.1 edition, see section 15-21 - PDF page 362 or do a TCL HELP FORMAT.CONV) A quick google would've revealed to you the following thread... which could be useful as well... http://u2-universe-unidata.1073795.n5.nabble.com/UniVerse-On-RedHat-td 7144.html Bearing in mind I've never done this, what I would try is ... Do a UVBACKUP at the account level to save the account on the old system. Delete the contents of the account directory on the new system, then run UV to create a new empty account. UVRESTORE your backup into the directory. A lot more hassle than a global UVBACKUP / UVRESTORE if you have multiple accounts, but it might work. The other thing is to put a fault call into Rocket, because this ought to work! I wonder ... could it be because the new system has a newer version of UV, and somehow the account upgrade mechanism is cutting in and messing up? Cheers, Wol ___ 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] USERS command in Universe
Running universe 11.1.4 on AIX 6.3 with all users using telnet including users with multiple logins USERS and LISTU match on my system If I run uvlictool in AIX it shows I also have Packages in use: UVCS has 1 processes. iPHANTOM has 3 processes. USER total plus the 4 processes above match the number of licenses in use according to uvlictool. I have a total of 10 phantoms running. Jon Card VP Special Projects Combined Transport, Inc. 541-618-6565 Fax 541-826-9787 www.combinedtransport.com Division of Combined Transport Logistics Group, Inc ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Sales EDI Question...
Hi Robert, Although I'm still just exploring, I added the Sales tag to the Subject to be politically correct. We offer a map-based EDI translator for installation and integration with your backend software. EDI Purchase Orders (850, 875) convert to Sales Orders using the same business rules used to create Sales Orders in your backend software. ASN's convert to EDI ASN's (856). Invoices convert to EDI Invoices (810, 880). EDI Cash Receipts (820) convert to Cash Receipts and post against Invoices. etc. Maps can be cloned in a matter of seconds and then modified to meet specific Trading Partner requirements. This product was originally developed on Advanced Pick and has been running for about 15 years on mvBase. It is also installed inhouse on Universe and can be ported to Unidata using the PICK flavor for the EDI accounts. It interfaces with serial, ftp and AS2 van services and did interface with the Softshare van some years ago when it was running on Advanced Pick. If you'd like to explore this option further, please let me know and I'll contact you directly, or you may contact me if you prefer. Best wishes, Dave Taylor, CEO Sysmark Information Systems, Inc. 49 Aspen Way Rolling Hills Estates, CA 90274 800-SYSMARK (800-797-6275) www.sysmarkinfo.com We are using Dataflo from epicor, Unidata, Kore Kourier electronic forms rand Redback for our storfront application - Original Message - From: da...@sysmarkinfo.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Thursday, January 02, 2014 6:50 PM Subject: Re: [U2] EDI Question... Robert, What database are you running your backend software on? What's more affordable as an inhouse product or cloud-based service? Happy New Year, Dave On 2013-12-31 08:46, Robert Frailey wrote: EDI brings up a whole can of worms for me in the new year. We currently use softshare as our van, I would really like to do EDI in house or find something more affordable. Does anyone have any suggestions. Thank You Robert Frailey Manager Information Systems Utah Medical Products Inc. Utah Medical Products Ltd. Femcare-Nikomed Ltd. Femcare Australia rfrai...@utahmed.com 801-569-4016 - Original Message - From: Peter S. Goldberger pet...@eoftech.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tuesday, December 31, 2013 8:55 AM Subject: Re: [U2] EDI Question... ISA (IEA) and GS (GE) control numbers should be consecutive per trading partner. The Receiver COMM ID and the control number together are what the VAN looks at. George Gallen wrote: The control numbers for the ISA/GS/ST segments, do they need to be unique only on a trading partner scale, or on a VAN scale? So if two trading partners are going through the same VAN, can they both have say a ISA control # of 1? George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.comhttp://www.wyanokegroup.com/ ___ 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 ___ 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 ___ 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
[U2] Anyone have a copy of XFER2OI or XFR2OI?
There is a program that I got from a gentleman by the name of Robert Catalano called XFER2OI or XFR2OI (I forget the exact spelling). I used it at the time to transfer files from ADVANCED REVELATION to OPENINSIGHT and I thought it was pretty slick. Anyone know which source repository or archives have that program? I like to use existing utility programs rather than write them from scratch sometimes, especially when trying to get a project out the door quickly. Thanks, Robert Norman ROBERT NORMAN AND ASSOCIATES 23441 Golden Springs Dr., #289, Diamond Bar, CA 91765 (951) 541-1668 i...@keyway.net mailto:i...@keyway.net http://users.keyway.net/~ice/ http://users.keyway.net/%7Eice/ Affordable computer consulting services and computer programming for UNIVERSE, UNIDATA, U2, PICK/BASIC, DATA/BASIC, UniVerseBasic, UniBasic, R/BASIC, jBC. Ask about our $55 discounted rate. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users