I have a situation where I am getting the FS404 error message when trying to add tables to a database.

(e.g. volume x has the same header info as volume y, cannot attach)

What I am trying to accomplish is to "detach" the xxxx table from the current layout and then attach another table with the same name xxxx from another volume/directory.

I read a bunch of posts regarding this type of error but could not find a concrete answer or solution.

I tried to attach the datavol,revmedia and looked at the record but couldn't make much sense of it. I also tried renaming the directory in which my revxxxx table exists but that didn't work. Any info is appreciated. </QUOTE> ---- === At 29 NOV 2005 01:34AM support@sprezzatura.com wrote: === <QUOTE>The REVMEDIA%% record contains

- Next File Name

- Volume Label

It's that you would need to change on the volume you are attaching.

However, it's not as simple as just making the change. This value is used to uniquely identify the volume name so that when tables are aliased in, indexes are put into the correct place. This gives a table a fully qualified name of tableName*account*volumeLabel. Basically, if you change the volume label, you can corrupt indexing on that file. You'll need to do a bit of index record manipulation, which involves deleting the ! record and modifying the !TABLE record.

support@sprezzatura.com

The Sprezzatura Group Web Site

World Leaders in all things RevSoft

Bruce,

There's also a routine supplied in OI called RENAME_VOLUME based on the old RevMedia Arev version…

The Sprezzatura Group

World leaders in all things RevSoft

Bruce,

Ran into similar problems with attaching volumes with the same media name. Turns out the volume I was detaching contained a System table called importexport (old arev table). Unfortunately, OI will not detach certain "System" tables and thus would not allow me to attach another volume with the same media name.

HTH,

John

Ok, I will try that, thanks.

John,

There is a difference in OI between detaching a table and detaching a volume. If you have attached table A in volume X on directory path P, and you wish to attach table A in volume X on path Q, then you must Detach_Volume( X ) or Detach_Volume( P ). Afterwards, you can Attach_Table( A, Q ). However, if you wish to attach a different table A while retaining the attach of other tables from directory P, the problem of Renaming the media arises. As pointed out, Renaming the media of a directory changes not just the volume pointer, but all the index information as well.

Gerald

Gerald,

I know about detach_volume… I was trying to point out that under certain circumstances it will not completely detach all the files if those files are "system" files. I ran into this where I had a volume of AREV files that I needed to detach and attach another volume with the same media name. Turns out it contained "IMPORTEXPORT" and would not detach that table thus preventing the attachment of the second volume.

John

View this thread on the Works forum...