Thanks for the response : Versions : uv 10.2.11 on hpux B.11.31
I tried : LISTF SELECT VOC WITH TYPE = "F" "Q" SORT VOC WITH TYPE = "F" "Q" SORT VOC WITH TYPE = "F" "Q" BY F2 Even ignoring system files ( those automatically added to HS_FILE_ACCESS ) nothing matches the order that HS.UPDATE.FILEINFO is using. I will have to check out the wiki article as I couldn't find any info on HS.UPDATE.FILEINFO. Gerry > -----Original Message----- > From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- > us...@listserver.u2ug.org] On Behalf Of Anthony W. Youngman > Sent: February 27, 2009 12:07 PM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] ODBC setup error > > In message <47c1b98393896f41a7bfe435442394e510f...@gmsdc.gerzio.ca>, > u2ug <simpson-u...@gerzio.ca> writes > >We have an account setup to allow odbc access to specific files. > >We added access to a new file and ran HS.UPDATE.FILEINFO which > processed > >a few files but then aborted the session with that old standard : > > > > Abnormal termination of UniVerse > > Fault type is 11. Layer type is Unknown. > > > >The files that were processed are accessible via odbc but no others. > > > >I tried removing all data files references from the VOC , so there > >shouldn't be any files to update and it still gave me this error. > >I also tried disabling and re-enabling file access via HS.ADMIN but > the > >same result - we get the same error when the enable tries to run the > >HS.UPDATE.FILEINFO command. > > Quite likely. What version of UV are you on? > > >I am assuming that it is hitting a bad file and blowing up, but I > don't > >know what that file might be as the order that files are processed > seems > >to be pretty random. > > Try SELECT VOC WITH TYPE EQ "F" and see if that's the order it's > processing them in (I think it probably is). > > > >This is a major issue. > >Can anybody shed some light on this ? > > > Look on the UniVerse page on PickWiki. There's a page about setting up > ODBC - it's pretty out-of-date because it's based on 9.6, but it may > well give you some clues - especially about how to get > HS.UPDATE.FILEINFO into verbose mode, which stands a good chance of > telling you which file is blowing up. > > Cheers, > Wol > -- > Anthony W. Youngman <pi...@thewolery.demon.co.uk> > 'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking > the > thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The > man > lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998 > Visit the MaVerick web-site - <http://www.maverick-dbms.org> Open > Source Pick > ------- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/