I tried several times to export the TermBase from MultiTrans into an Excel file. But the export is blocking constantly at 21 % (or another specific percentage). We already tried on multiple PC's, and the same mistake happens again and again. In the "MultiTrans.Services.Host.log" file on the server, you may see the following error (see also: Where are the MultiTrans and Flow server logs located?):
[Critical] [General, General] [ 14] Aspose.Cells.CellsException: You want to put a string longer than 32K to Cell T14910. MS Excel only allows to put a string shorter than 32K to a Cell.
at .(String )
at Aspose.Cells.Cell.PutValue(String stringValue)
at Aspose.Cells.Cell.PutValue(Object objectValue)
at Aspose.Cells.Cell.set_Value(Object value)
at MultiCorpora.Services.TermBase.DataAccess.Jobs.Exports.ExcelExport.UpdateColumn(Row row, Int32 columnIdx, String columnTitle, Object columnValue)
at MultiCorpora.Services.TermBase.DataAccess.Jobs.Exports.ExcelExport.ExportUdfValue(List`1 udfValues, WebIUdfDefinition def, Row row, String iso3Code, Int32& columnIdx)
at MultiCorpora.Services.TermBase.DataAccess.Jobs.Exports.ExcelExport.ExportTerm(WebITerm term, String iso3Code, String header)
at MultiCorpora.Services.TermBase.DataAccess.Jobs.Exports.ExcelExport.ExportTermSingleLanguageColumns(WebITermGroupLanguage language, String iso3Code)
at MultiCorpora.Services.TermBase.DataAccess.Jobs.Exports.ExcelExport.ExportTermGroup(WebITermGroup termGroup)
at MultiCorpora.Services.TermBase.DataAccess.Jobs.Exports.ExcelExport.ProcessTermBases()
at MultiCorpora.Services.TermBase.DataAccess.Jobs.Exports.ExcelExport.Start()
at MultiCorpora.Services.TermBase.MultiThreading.ThreadManager.JobThreadStart()
|
Option 1: Try exporting to a different file format such as TBX or XML. Option 2: Look through the TermBase for terms and metadata values that seem to be extremely long (32,000 characters or more) and delete them. Once you can no longer find any of these extremely long terms/values, try to export the TermBase to Excel again. Option 3: Open a case with RWS support. If your system is not hosted by RWS, ask your IT department for assistance and be prepared to provide a backup of your MultiTrans database. |
A single cell in Microsoft Excel cannot contain more than 32,000 characters. Some terms or metadata values in the affected TermBase may have values which are longer than 32,000 characters, which causes the export process to throw an error. |