I'm able to create an index for a table on a different drive using indexspace. Is there a way to directly update the index file location in the SYSINDEX table? I tried to update the FNAME column in that table, but I get an insufficient permissions error.
One of my system tables was corrupt. Do I have to reinstall Texis to recreate the system tables, or is there another way to recreate the system database?
Which one? You don't need to reinstall Texis, as creating a new database will recreate the system tables in that database. The greater challenge will be getting the right information into that table.
e:\modules>texis -ci -log "" -force -module sitevalidations sitevalidations
Texis Web Script (Vortex) Copyright (c) 1996-2009 Thunderstone - EPI, Inc. Commercial Version 5.01.1258488718 20091117 (i686-intel-winnt-64-32) 002 sitevalidations: Cannot open KDBF file e:\texissystemdb\T06848a_D.btr for writing: error 2/2: The system cannot find the file specified/No such file or directory
015 sitevalidations: Probable corrupt KDBF file e:\texissystemdb\T06848a_D.btr: FDBF disabled, enable in texis.cnf only if known to be FDBF
000 sitevalidations: Vortex (3296) ABEND: exception 0xC0000005 (ACCESS_VIOLATION) at ip 0x47b069
I'm also seeing this error when trying to compile a script:
Texis Web Script (Vortex) Copyright (c) 1996-2009 Thunderstone - EPI, Inc.
Commercial Version 5.01.1258488718 20091117 (i686-intel-winnt-64-32)
100 e:\testscript: Index e:\texissystemdb\xsdd-0 appears to be being updated
000 e:\testscript: Cannot create index xsdd: Already exists as type `T' in the function createindex
000 e:\testscript: SQLPrepare() failed with -1 in the function prepntexis
If you look in SYSINDEX to find out which index and type that is. You may want to open a support ticket, as it may be a fairly easy fix after seeing SYSINDEX.