Frequently Asked Questions
Frequently Asked Questions
Error in TRANSLATION_TID3_OTn_IW table when migrating to SQL
Posted by Elizabeth Sumpter (M-Files) on 06 April 2018 09:47 PM

When migrating an M-Files vault from Firebird to SQL, the below error may be encountered:

Status: Failed. Error: Migrating document vault "[vault name]" failed.

Copying of database table "TRANSLATION_TID3_OT0_IW" failed.

Unspecified error. (Unspecified error)

 

RPCScheduledJobsHelper.cpp, 4479, Migrating document vault "[vault name]" failed. (0x8004045C)

RPCScheduledJobsHelper.cpp, 3953, Migrating document vault "[vault name]" failed. (0x8004045C)

VaultManager.cpp, 2370, Migrating document vault "[vault name]" failed. (0x8004045C)

VaultManager.cpp, 2370, Copying of database table "TRANSLATION_TID3_OT0_IW" failed. (0x8004045B)

MigrateVault.cpp, 200, Copying of database table "TRANSLATION_TID3_OT0_IW" failed. (0x8004045B)

MigrateVault.cpp, 434, Copying of database table "TRANSLATION_TID3_OT0_IW" failed. (0x8004045B)

MigrateVault.cpp, 705, Copying of database table "TRANSLATION_TID3_OT0_IW" failed. (0x8004045B)

MigrateVault.cpp, 705, Unspecified error. (Unspecified error) (0x80004005)

MigrateVault.cpp, 1051, Unspecified error. (Unspecified error) (0x80004005)

 

This is a known issue and the solution is to empty the contents of one of the generated database tables according to the below instructions:

Please use the FBDatabaseTool from https://share.m-files.com/FBDatabaseTool_2018.zip

Note: The tool is intended to be used for this specific case only and then removed afterward. Further use, storage, or delivery is not permitted.

 Instructions:

  • First, extract the tool and launch the FBDatabaseTool.exe (ignore the tool's note about easy usage and execute from the MFServer.exe installation directory)
  • Then in the tool window:
    • Write the correct M-Files version to the version field: 12_0_6550_8 (please verify that this is the version you are using, if not please replace this string with the correct version, making sure to use underscores instead of dots)
    • After you have the backup, take the vault offline
    • Select the metadata.fdb from your vault and click connect
    • Click Begin Transaction
    • Write the query "delete from TRANSLATION_TID3_OT0_IW;" excluding the double quotes
    • Click Execute Query
    • Click Commit
    • Close the tool (the execute/commit steps may take a while)
    • Bring the vault online and check that it is working
    • Do the migration
  • Then, after the migration:
    • Set this registry key
      • [HKEY_LOCAL_MACHINE\SOFTWARE\Motive\M-Files\<version>\Server\MFServer\Vaults\<vault guid>\ThoroughOptimization\IncludedOnlyTasks]
      • "RecalculateIndexedWords"=dword:00000001
    • Run thorough optimization
    • Remove the registry key

 

If you encounter the same error with a different table listed after fixing the first one, repeat the above process for the new table name.

Note: This is an "R&D tool" so it may not provide you any input after, for example, clicking Begin Transaction. Please contact us immediately and do not attempt to fix any possible problems, if such arise.

(6 vote(s))
This article was helpful
This article was not helpful

Help Desk Software by Kayako case