Just had a thought. Could it be access rights? If, as looks likely, this is used by UV to manage schemas, it might be locked down so only the SQL DBA can edit it. What's the betting that would cause your problem?
In that case, it's nasty, because it also means any attempt to run HS.UPDATE.FILEINFO is likely to fail. Hmm... you might need to change the F to X to export your tables then change it back again so the account actually works... I'm guessing we might not suffer this because I've never used SQL Schemas in UV, and other people may not have met it because they only use SQL Schemas. The fact you think you're running a very old version also means it may be (probably is) a fixed problem by now... Cheers, Wol -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: 26 June 2008 09:42 To: '[email protected]' Subject: RE: [U2] UVODBC Account Activation Yes I know it's a UV file. That was point of me mentioning PTERM.FILE - that's a UV file too and it was UV files that gave me the most grief. Does anybody know what UV_ASSOC does? Is it safe to delete the VOC pointer? It looks to me like it's part of the SQL table mechanism so if you're not actually creating SQL schemas etc it's probably totally unnecessary in this account. What you could try is changing the F to an X and seeing if anything in the account falls over. Cheers, Wol -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mac Bhyat Sent: 26 June 2008 08:56 To: [email protected] Subject: RE: [U2] UVODBC Account Activation This is a brand new uv account - the problem seems to be on a uv file D_UV_ASSOC and I'm not sure if I can delete that Mac -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: 25 Jun 2008 16:34 To: '[email protected]' Subject: RE: [U2] UVODBC Account Activation Okay. Firstly, do you need this file in your account? Oddly enough, most of my "hard to fix" problems with ODBC have been caused by the various preparation/export programs crashing on system files we've never touched. If you don't need it, delete the VOC entry. I had it crash on PTERM.FILE - a system-supplied multi-part file. Secondly, go to pickwiki, find the page on Universe, and then look at the page on ODBC. You might find it useful as it describes my tribulations with 9.6. Bear in mind that these export routines process EVERYTHING, so the entire account needs to be nice and clean, not just the files you're exporting :-( Cheers, Wol -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mac Bhyat Sent: 25 June 2008 14:44 To: [email protected] Subject: RE: [U2] UVODBC Account Activation Hi, I know it's a very old version of uv - maybye 9.5 or possibly even 9.4 Mac -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: 25 Jun 2008 12:41 To: '[email protected]' Subject: RE: [U2] UVODBC Account Activation Not that I know much about this error but ... What version of UV are you running? I've set up ODBC on both 9.6 and 10.2, and the later version seems to be a lot more robust ... Cheers, Wol -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mac Bhyat Sent: 25 June 2008 10:59 To: [email protected] Subject: [U2] UVODBC Account Activation Hi, I have a friend who is try to activate ODBC access in an account running on a unix based server and is getting the following: DICT UV_ASSOC /uv/sql/catalog/D_UV_ASSOC 2 1 CRITICAL ERROR! Notify the system administrator. Abnormal termination of UniVerse. Fault type is 11. Layer type is BASIC run machine. Fault occurred in BASIC program *LISTFILES at address 520. Any suggestions ? Thanks mac Mac Bhyat Software Engineer - Special Projects Unibase Solutions (Pty) Ltd. URL: http://www.unibase.co.za <http://www.unibase.co.za/> Email: [EMAIL PROTECTED] Tel: 011 621 7000 Cell: 079 181 3266 Fax: 011 621 7029 DISCLAIMER AND CONFIDENTIALITY This message and any attachment contain information intended solely for the addressee which is confidential or private in nature and subject to legal privilege. If you receive this message in error please notify the sender immediately by email and thereafter delete the message and do not disclose the content in any way. Unibase Solutions (Pty) Ltd cannot assure the integrity of this communication, nor that it is free of errors, virus, interception or interference, and disclaims all liability for any such. Views and opinions are those of the sender unless clearly stated as being that of the company. The authority of the sender to bind the company should be verified by the recipient and not assumed. For contact and address information regarding the company please go to <http://www.unibase.co.za/> www.unibase.co.za -- This message was scanned for spam and viruses by BitDefender. For more information please visit http://linux.bitdefender.com/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ -- This message was scanned for spam and viruses by BitDefender. For more information please visit http://linux.bitdefender.com/ __________ NOD32 3216 (20080625) Information __________ This message was checked by NOD32 antivirus system. http://www.eset.com -- This message was scanned for spam and viruses by BitDefender. For more information please visit http://linux.bitdefender.com/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ -- This message was scanned for spam and viruses by BitDefender. For more information please visit http://linux.bitdefender.com/ __________ NOD32 3219 (20080625) Information __________ This message was checked by NOD32 antivirus system. http://www.eset.com -- This message was scanned for spam and viruses by BitDefender. For more information please visit http://linux.bitdefender.com/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
