Add MP3 INSO type to Interwoven server

To check if your version of the Interwoven SQL database has the INSO type of MP3 type the following into the SQL query:

select * from mhgroup.typemap where DETECT_TYPE LIKE ‘%FI_MP3%’

If you have any results then you are fine if not execute the following two line of code one at a time:

insert into MHGROUP.TYPEMAP values (‘FI_MP3_ID31’, 1706,”,NULL)
insert into MHGROUP.TYPEMAP values (‘FI_MP3_ID32’, 1707,”,NULL)

To check if you have been successful run the first statement again so the results should show you two lines.

Change Interwoven Docstore and Index locations in SQL

First to check the location of the docstore and index type the following in SQL

select * from HK.mhgroup.docservers

To update the two items type the following:

update DATABASENAME.mhgroup.docservers set location = ‘\NEWSERVERNAMEwsdocs$’ where docserver = ‘defserver’
update DATABASENAME.mhgroup.docservers set location = ‘\NEWSERVERNAMEwsidx$’ where docserver = ‘idxserver’