Re: [U2] Scrub Hangs Up
I would expect this not to work. D_INVOICE is a dictionary file so it hasn't got a dictionary. If you try copy FROM DICT INVOICE TO DICT INVOICE_TEST it should probably work. On 28/08/2012 23:39, Bill Brutzman wrote: More help is needed... 1.copy FROM DICT D_INVOICE TO DICT D_INVOICE_TEST Unable to open DICT D_INVOICE file. 2. When I try copying via Rocket's BDT (Basic Developer ToolKit)... Failed to copy... unable to open q-pointer. --Bill ___ 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] Scrub Hangs Up
Is this query related to the one you posted/resolved here: http://listserver.u2ug.org/pipermail/u2-users/2011-July/008153.html Same problem/solution? I kindly suggest that you go on a Rocket UV course to help work out how to get the best from UV. Plus the UV ODBC documentation is quite detailed on the use of HS.SCRUB. So I assume you're followed it's correct used - before you posted this request for help. BTW check this out Rocket U2 Webinar coming soon: http://www.rocketsoftware.com/u2/about/events/dictionary-cleanup-a -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Wednesday, 29 August 2012 6:16 AM To: U2 Users List Subject: Re: [U2] Scrub Hangs Up When I do a LOGTO HS.ADMIN HS.ADMIN 5. Run HS.SCRUB on a File/Table.. [F]ix Most of the files here work ok. This one (important) data file INVOICE... it starts an... Analyzing: *and then just sits there. I looked at the dictionary and purged a bunch of extraneous } characters from several the NAME fields. I expect to resize the file but... it is not like the file is badly oversized. This is on UniVerse v10.1 running on HP-Ux Itanium. Suggestions would be appreciated. --Bill ** 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
Re: [U2] Scrub Hangs Up
When I do a LOGTO HS.ADMIN HS.ADMIN 5. Run HS.SCRUB on a File/Table.. [F]ix Most of the files here work ok. This one (important) data file INVOICE... it starts an... Analyzing: *and then just sits there. I looked at the dictionary and purged a bunch of extraneous } characters from several the NAME fields. I expect to resize the file but... it is not like the file is badly oversized. This is on UniVerse v10.1 running on HP-Ux Itanium. Suggestions would be appreciated. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Scrub Hangs Up
When it hangs... I am unable to get it to terminate via Ctrl Break Break: Option (A,C,L,Q,?) = None of the break options work... --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Tuesday, August 28, 2012 4:16 PM To: U2 Users List Subject: Re: [U2] Scrub Hangs Up When I do a LOGTO HS.ADMIN HS.ADMIN 5. Run HS.SCRUB on a File/Table.. [F]ix Most of the files here work ok. This one (important) data file INVOICE... it starts an... Analyzing: *and then just sits there. I looked at the dictionary and purged a bunch of extraneous } characters from several the NAME fields. I expect to resize the file but... it is not like the file is badly oversized. This is on UniVerse v10.1 running on HP-Ux Itanium. Suggestions would be appreciated. --Bill ___ 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] Scrub Hangs Up
Port.status ... david ... David L. Wasylenko President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Tuesday, August 28, 2012 3:20 PM To: U2 Users List Subject: Re: [U2] Scrub Hangs Up When it hangs... I am unable to get it to terminate via Ctrl Break Break: Option (A,C,L,Q,?) = None of the break options work... --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Tuesday, August 28, 2012 4:16 PM To: U2 Users List Subject: Re: [U2] Scrub Hangs Up When I do a LOGTO HS.ADMIN HS.ADMIN 5. Run HS.SCRUB on a File/Table.. [F]ix Most of the files here work ok. This one (important) data file INVOICE... it starts an... Analyzing: *and then just sits there. I looked at the dictionary and purged a bunch of extraneous } characters from several the NAME fields. I expect to resize the file but... it is not like the file is badly oversized. This is on UniVerse v10.1 running on HP-Ux Itanium. Suggestions would be appreciated. --Bill ___ 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
Re: [U2] Scrub Hangs Up
The HS.Scrub option... report only option also hangs. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Tuesday, August 28, 2012 4:20 PM To: U2 Users List Subject: Re: [U2] Scrub Hangs Up When it hangs... I am unable to get it to terminate via Ctrl Break Break: Option (A,C,L,Q,?) = None of the break options work... --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Tuesday, August 28, 2012 4:16 PM To: U2 Users List Subject: Re: [U2] Scrub Hangs Up When I do a LOGTO HS.ADMIN HS.ADMIN 5. Run HS.SCRUB on a File/Table.. [F]ix Most of the files here work ok. This one (important) data file INVOICE... it starts an... Analyzing: *and then just sits there. I looked at the dictionary and purged a bunch of extraneous } characters from several the NAME fields. I expect to resize the file but... it is not like the file is badly oversized. This is on UniVerse v10.1 running on HP-Ux Itanium. Suggestions would be appreciated. --Bill ___ 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
Re: [U2] Scrub Hangs Up
port.status There are currently 6 uniVerse sessions; 5 interactive, 1 phantom Pid User name. Who. Port name. Last command processed... 25149 brutzy12 /dev/pts/tb LOGTO HS.ADMIN 26413 brutzy16 /dev/pts/te LOGTO HS.ADMIN 26541 brutzy17 /dev/pts/tf LOGTO HS.ADMIN 26559 brutzy20 /dev/pts/tj port.status 13303 color 29 /dev/pts/tq CLEARSELECT ALL [ SHIP.STATUS.LONG.R69 @ 0xA24 ] Pid User name. Printer Segment Last command processed 26538 brutzy 0xACEB9856 *HS.OLEDBINFO -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David L. Wasylenko Sent: Tuesday, August 28, 2012 4:16 PM To: U2 Users List Subject: Re: [U2] Scrub Hangs Up Port.status ... david ... David L. Wasylenko President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.commailto:d...@pickpro.com -Original Message- From: u2-users-boun...@listserver.u2ug.orgmailto:u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org]mailto:[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Tuesday, August 28, 2012 3:20 PM To: U2 Users List Subject: Re: [U2] Scrub Hangs Up When it hangs... I am unable to get it to terminate via Ctrl Break Break: Option (A,C,L,Q,?) = None of the break options work... --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.orgmailto:u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org]mailto:[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Tuesday, August 28, 2012 4:16 PM To: U2 Users List Subject: Re: [U2] Scrub Hangs Up When I do a LOGTO HS.ADMIN HS.ADMIN 5. Run HS.SCRUB on a File/Table.. [F]ix Most of the files here work ok. This one (important) data file INVOICE... it starts an... Analyzing: *and then just sits there. I looked at the dictionary and purged a bunch of extraneous } characters from several the NAME fields. I expect to resize the file but... it is not like the file is badly oversized. This is on UniVerse v10.1 running on HP-Ux Itanium. Suggestions would be appreciated. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.orgmailto: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] Scrub Hangs Up
On 28/08/12 21:16, Bill Brutzman wrote: When I do a LOGTO HS.ADMIN HS.ADMIN 5. Run HS.SCRUB on a File/Table.. [F]ix Most of the files here work ok. This one (important) data file INVOICE... it starts an... Analyzing: *and then just sits there. I looked at the dictionary and purged a bunch of extraneous } characters from several the NAME fields. I expect to resize the file but... it is not like the file is badly oversized. This is on UniVerse v10.1 running on HP-Ux Itanium. My suggestions are for 9.6 but it could be the same cause ... what file is it trying to process? Do you have a dud VOC entry? ime this sort of thing was caused by problems in the VOC. Look at the pickwiki page ... http://www.pickwiki.com/cgi-bin/wiki.pl?ODBC96 by yours truly of course. See if that helps (and if you can add any extra info to that page :-) Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Scrub Hangs Up
On 28/08/12 22:57, Bill Brutzman wrote: Wol may have nailed yet another one... All of our other files just have an F in line one. ED VOC INVOICE 3 lines long. 0001: F INVOICE FILE But this is valid syntax - F-space means a file and anything after that is a comment. This shouldn't be a problem. I know I had problems with an F-pointer to a system file called TERM, or something like that ... I know it regularly hung trying to process files that it wasn't supposed to go anywhere near (the default was don't process) That was why you want to run in verbose mode, it processed the files in the same order as LIST VOC WITH TYPE EQ 'F'. So when it hung, you knew within one or two files which one was the problem. 0002: INVOICE 0003: D_INVOICE I will change it and try it. Thanks Wol. --Bill Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Scrub Hangs Up
More help is needed... 1. copy FROM DICT D_INVOICE TO DICT D_INVOICE_TEST Unable to open DICT D_INVOICE file. 2. When I try copying via Rocket's BDT (Basic Developer ToolKit)... Failed to copy... unable to open q-pointer. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Scrub Hangs Up
It looks like the D_INVOICE (dictionary file) is corrupted. Unfortunately... this dictionary is rather large. I would rather not retype the whole dictionary from scratch and copy it back. The Unix rights to the file look righteous... 777. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Scrub Hangs Up
On 28/08/12 23:39, Bill Brutzman wrote: More help is needed... 1. copy FROM DICT D_INVOICE TO DICT D_INVOICE_TEST Unable to open DICT D_INVOICE file. 2. When I try copying via Rocket's BDT (Basic Developer ToolKit)... Failed to copy... unable to open q-pointer. Hmmm Something's seriously screwy here - your last post said that INVOICE was a local F pointer. Does the dictionary even exist? Is it readable? Any of this would bring HS.SCRUB crashing down ... Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Scrub Hangs Up
1. INVOICE is an ordinary UV file. 2. I can see the INVOICE dictionary via... LIST DICT INVOICE... and also via BDT... so yes this D_INVOICE dictionary exists and is readable. 3. D_INVOICE appears to be corrupted (whacked) in a subtle way. 4. My sense is that I have to retype the D_INVOICE dictionary from scratch and do a copy back and rename trick. 5. If there is a faster way... I am open to consider it. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Tuesday, August 28, 2012 6:47 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Scrub Hangs Up On 28/08/12 23:39, Bill Brutzman wrote: More help is needed... 1. copy FROM DICT D_INVOICE TO DICT D_INVOICE_TEST Unable to open DICT D_INVOICE file. 2. When I try copying via Rocket's BDT (Basic Developer ToolKit)... Failed to copy... unable to open q-pointer. Hmmm Something's seriously screwy here - your last post said that INVOICE was a local F pointer. Does the dictionary even exist? Is it readable? Any of this would bring HS.SCRUB crashing down ... 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] Scrub Hangs Up
What's the VOC entry for D_INVOICE look like? -Original Message- From: Bill Brutzman bi...@hkmetalcraft.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, Aug 28, 2012 3:57 pm Subject: Re: [U2] Scrub Hangs Up More help is needed... 1. copy FROM DICT D_INVOICE TO DICT D_INVOICE_TEST Unable to open DICT D_INVOICE file. 2. When I try copying via Rocket's BDT (Basic Developer ToolKit)... Failed to copy... unable to open q-pointer. --Bill ___ 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] Scrub Hangs Up
Good question... I looked into this earlier. The VOC entry for D_INVOICE is blank... but... so are all of the other VOC entries for dictionary items. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Subject: Re: [U2] Scrub Hangs Up What's the VOC entry for D_INVOICE look like? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Scrub Hangs Up
Just in case I'm not missing something does HS.SCRUB create voc entries for each dictionary? normally there is no voc item for D_anything and shouldnt the copy be COPY FROM DICT INVOICE TO whereever ALL rICH On 8/28/2012 7:21 PM, Bill Brutzman wrote: Good question... I looked into this earlier. The VOC entry for D_INVOICE is blank... but... so are all of the other VOC entries for dictionary items. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Subject: Re: [U2] Scrub Hangs Up What's the VOC entry for D_INVOICE look like? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Richard A Wilson Lakeside Systems Smithfield, RI, USA Voice 401-231-3959 Fax 206-202-2064 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Scrub Hangs Up
Rich Thanks for writing... 1. I believe that HS.SCRUB just creates SQL data types in like fields 7 and 8 of the dictionary file. 2. Yes It should be COPY FROM DICT INVOICE TO DICT INVOICE_TEST ALL... This now works... I tried it but... HS.ADMIN hangs up the same way with INVOICE_TEST. 3. I started to write a little rehydrate program... to read the DICT entries from one file and copy the DICT entries to a new clean file. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Richard Wilson Sent: Tuesday, August 28, 2012 7:25 PM To: U2 Users List Subject: Re: [U2] Scrub Hangs Up Just in case I'm not missing something does HS.SCRUB create voc entries for each dictionary? normally there is no voc item for D_anything and shouldnt the copy be COPY FROM DICT INVOICE TO whereever ALL rICH On 8/28/2012 7:21 PM, Bill Brutzman wrote: Good question... I looked into this earlier. The VOC entry for D_INVOICE is blank... but... so are all of the other VOC entries for dictionary items. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Subject: Re: [U2] Scrub Hangs Up What's the VOC entry for D_INVOICE look like? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Richard A Wilson Lakeside Systems Smithfield, RI, USA Voice 401-231-3959 Fax 206-202-2064 ___ 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] Scrub Hangs Up
On 29/08/12 00:36, Bill Brutzman wrote: Rich Thanks for writing... 1. I believe that HS.SCRUB just creates SQL data types in like fields 7 and 8 of the dictionary file. 2. Yes It should be COPY FROM DICT INVOICE TO DICT INVOICE_TEST ALL... This now works... I tried it but... HS.ADMIN hangs up the same way with INVOICE_TEST. 3. I started to write a little rehydrate program... to read the DICT entries from one file and copy the DICT entries to a new clean file. Have you got HS.SCRUB running in verbose mode? If you haven't, why not? Have you looked at the hints on the pickwiki page? Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Scrub Hangs Up
What are you trying to copy from the Dict of D_INVOICE instead of the Dict of INVOICE ? -Original Message- From: Bill Brutzman bi...@hkmetalcraft.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, Aug 28, 2012 4:53 pm Subject: Re: [U2] Scrub Hangs Up 1. INVOICE is an ordinary UV file. 2. I can see the INVOICE dictionary via... LIST DICT INVOICE... and also via BDT... so yes this D_INVOICE dictionary exists and is readable. 3. D_INVOICE appears to be corrupted (whacked) in a subtle way. 4. My sense is that I have to retype the D_INVOICE dictionary from scratch and do a copy back and rename trick. 5. If there is a faster way... I am open to consider it. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Tuesday, August 28, 2012 6:47 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Scrub Hangs Up On 28/08/12 23:39, Bill Brutzman wrote: More help is needed... 1. copy FROM DICT D_INVOICE TO DICT D_INVOICE_TEST Unable to open DICT D_INVOICE file. 2. When I try copying via Rocket's BDT (Basic Developer ToolKit)... Failed to copy... unable to open q-pointer. Hmmm Something's seriously screwy here - your last post said that INVOICE was a local F pointer. Does the dictionary even exist? Is it readable? Any of this would bring HS.SCRUB crashing down ... 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Scrub Hangs Up
Will: Yes... you are right... Richard Wilson picked up on my typing bug in an earlier post. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, August 28, 2012 8:11 PM Subject: Re: [U2] Scrub Hangs Up What are you trying to copy from the Dict of D_INVOICE instead of the Dict of INVOICE ? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Scrub Hangs Up
Can you please then regive us once more the exact VOC command you're executing and COPY to this email exactly the VOC entry for the INVOICE file -Original Message- From: Bill Brutzman bi...@hkmetalcraft.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, Aug 28, 2012 5:12 pm Subject: Re: [U2] Scrub Hangs Up It looks like the D_INVOICE (dictionary file) is corrupted. Unfortunately... this dictionary is rather large. I would rather not retype the whole dictionary from scratch and copy it back. The Unix rights to the file look righteous... 777. --Bill ___ 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] Scrub Hangs Up
Delete the VOC entry called D_INVOICE No such entry should exist -Original Message- From: Bill Brutzman bi...@hkmetalcraft.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, Aug 28, 2012 5:13 pm Subject: Re: [U2] Scrub Hangs Up Good question... I looked into this earlier. The VOC entry for D_INVOICE is blank... but... so are all of the other VOC entries for dictionary items. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Subject: Re: [U2] Scrub Hangs Up What's the VOC entry for D_INVOICE look like? ___ 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] Scrub Hangs Up
Again correct... from an earlier post... There was never any VOC entry called D_INVOICE. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, August 28, 2012 8:16 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Scrub Hangs Up Delete the VOC entry called D_INVOICE No such entry should exist ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Scrub Hangs Up
Right so if its blank like you said earlier, delete it. It shoudn't exist blank, it should be non-existent Please copy again to this email the exact voc command you are issuing. -Original Message- From: Bill Brutzman bi...@hkmetalcraft.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, Aug 28, 2012 5:19 pm Subject: Re: [U2] Scrub Hangs Up Again correct... from an earlier post... There was never any VOC entry called D_INVOICE. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, August 28, 2012 8:16 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Scrub Hangs Up Delete the VOC entry called D_INVOICE No such entry should exist ___ 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] Scrub Hangs Up
I can copy the file... and I can copy the DICT... no problem now. The problem is that HS.SCRUB hangs. --Bill __ UniVerse Server Administration 1. List activated accounts 2. Show UniVerse ODBC Config configuration for an account 3. Activate access to files in an account 4. Deactivate access to files in an account 5. Run HS.SCRUB on a File/Table 6. Update File Information Cache in an account Which would you like? ( 1 - 6 ) ? 01 ED VOC HS.SCRUB 4 lines long. 0001: Verb - Check and optionally repair SQL-related dictionary/data inconsistencies in a table or file 0002: *HS.SCRUB 0003: B 0004: N __ ed VOC INVOICE 3 lines long. 0001: F 0002: INVOICE 0003: D_INVOICE Bottom at line 3. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, August 28, 2012 8:15 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Scrub Hangs Up Can you please then regive us once more the exact VOC command you're executing and COPY to this email exactly the VOC entry for the INVOICE file -Original Message- From: Bill Brutzman bi...@hkmetalcraft.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, Aug 28, 2012 5:12 pm Subject: Re: [U2] Scrub Hangs Up It looks like the D_INVOICE (dictionary file) is corrupted. Unfortunately... this dictionary is rather large. I would rather not retype the whole dictionary from scratch and copy it back. The Unix rights to the file look righteous... 777. --Bill ___ 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
Re: [U2] Scrub Hangs Up
In my new little rehydrate program... Several of the dictionary fields that show up in BDT and LIST DICT INVOICE... do not appear. --Bill _ *R1 Bill Brutzman Aug.2012 open 'DICT', 'INVOICE' to fDictSource else null include B.BP BASELINE.R10 crt @(0) dArray = '' *-- Main.Program: gosub firstLoop gosub secondLoop go theEnd *-- *-- firstScreen: crt @(0) call *HEADER.CLEAR.R1 crt crt crt crt ' ' crt ' /\ ' crt ' \ Dict.Hydrate / ' crt ' \__/ ' crt crt crt crt crt ' [G] Go ' crt crt ' [X] eXit' crt ' ': input Ans.Rep, 1 Ans.Rep = upcase(Ans.Rep) begin case case Ans.Rep = 'G' ; null case Ans.Rep = 'X' ; go theEnd case 1 ; crt @(-1) ; sleep ; go firstScreen end case return *-- firstLoop: call *HEADER.CLEAR.R1 crt crt crt crt crt crt crt crt crt crt crt crt crt crt crt crt crt Grn : ' Hydrating...' : hush on execute clearselect ALL execute 'SELECT DICT INVOICE' hush off call *HEADER.CLEAR.R1 crt crt crt crt crt crt crt crt crt crt crt crt crt crt crt crt crt Red : ' Hydrating...' : Grn : crt crt done = false loop readnext dictID else done = true until done do read rDict from fDictSource, dictID else rDict = '' type = rDict1 field = rDict2 item3 = rDict3 item4 = rDict4 item5 = rDict5 sm= rDict6 crtStr = dictID 'L#20' : ' ' crtStr := type 'L#10' : ' ' crtStr := field 'L#10' : ' ' crtStr := item3 'L#10' : ' ' crtStr := item4 'L#10' : ' ' crtStr := item5 'L#10' : ' ' crtStr := sm 'L#10' crt crtStr begin case case type = 'D' ; gosub sortDrecords * case 1 ; dArray-1 = thisRecord end case thisRecord = '' thisRecord := field : VM thisRecord := dictID : VM thisRecord := type : VM thisRecord := item3 : VM thisRecord := item4 : VM thisRecord := item5 : VM thisRecord := sm repeat crt crt ' [] ' : *input Ans crt crt return *-- sortDrecords: locate thisRecord in dArray1 by 'AR' setting posn else null insthisRecord before dArrayposn return *-- secondLoop: totalNbrDictItems = dcount(dArray, AM) for thisCount = 1 to totalNbrDictItems newField = dArraythisCount,1 newID = dArraythisCount,2 newType = dArraythisCount,3 newField3 = dArraythisCount,4 newField4 = dArraythisCount,5 newField5 = dArraythisCount,6 newsm = dArraythisCount,7 newStr = Red newStr := thisCount 'R#3' : ' ' : Grn newStr := newField 'L#10' : ' ' newStr := newID 'L#20' : ' ' newStr := newType 'L#10' : ' ' newStr := newField3 'L#10' : ' ' newStr := newField4 'L#10' : ' ' newStr := newField5 'L#10' : ' ' newStr := newsm 'L#10' crt newStr next thisCount crt crt ' [] ' : input Ans, 1 return *-- writeNewDict: * call *SUB.LOCK.AND.WRITE.R1(R.JPL, 'JPL', Today) return *-- theEnd: call *HEADER.CLEAR.R1 END ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users