[MultiLanguage Translator] Error uploading translations file (exported from 11.0.201)

Back to Forums

Adrian

Question

Forge

Hi,

Tried to upload excel file from P11 and got the following error:

Attempted to access an unloaded appdomain. (Exception from HRESULT: 0x80131014) - Check if uploaded file is protected.

Is Multilanguage Translator compatible with version 11?

Also when trying to use the Text Transalator feature I get 400:

)
Environment Information	eSpaceVer: 0 (Id=9994, PubId=0, CompiledWith=11.0.108.0) RequestUrl: https://xxx-dev.outsystemsenterprise.com/Translationtestapp/ExcelTranslator.aspx (Method: POST) AppDomain: /LM/W3SVC/1/ROOT/Translationtestapp-182-131894214064712664 FilePath: d:\Outsystems\Platform Server\running\Translationtestapp.01679750520\ExcelTranslator.aspx ClientIp: 84.193.209.35 Locale: en-US DateFormat: dd-MM-yyyy PID: 7112 ('w3wp', Started='12/13/2018 1:23:53 PM', Priv=1641Mb, Virt=2109418Mb) TID: 127 Thread Name: .NET: 4.0.30319.42000
Stack:	Attempted to access an unloaded appdomain. (Exception from HRESULT: 0x80131014) at System.StubHelpers.StubHelpers.InternalGetCOMHRExceptionObject(Int32 hr, IntPtr pCPCMD, Object pThis, Boolean fForWinRT) at System.StubHelpers.StubHelpers.GetCOMHRExceptionObject(Int32 hr, IntPtr pCPCMD, Object pThis) at OfficeOpenXml.Utils.CompoundDocument.ILockBytes.WriteAt(Int64 ulOffset, IntPtr pv, Int32 cb, UIntPtr& pcbWritten) at OfficeOpenXml.Utils.CompoundDocument.GetLockbyte(MemoryStream stream) at OfficeOpenXml.ExcelPackage.Load(Stream input, Stream output, String Password) at OutSystems.NssExcel_Package.CssExcel_Package.MssWorkbook_Open_BinaryData(Byte[] ssBinaryData, Object& ssWorkbook) at ssTranslationtestapp.RssExtensionExcel_Package.MssWorkbook_Open_BinaryData(HeContext heContext, Byte[] inParamBinaryData, Object& outParamWorkbook)

Thanks in advance for your help!

Kind regards,

Adrian

16 Dec 2018

Marcelo Ferreira

Hi Adrian,

Did you read the notes of the component?

Notes:

Please make sure your excel isn’t protected.
You will need a Yandex Translate API Key to assign to the Site Property YandexAPIKey. Go to the Yadex Site to get a free API key.

You get that bad request error if you dont have and API key

Regards,

Marcelo

17 Dec 2018

Diogo Cardoso

Hi Adrian,

Marcelo's post explains what is happening in your user case.

After rechecking the application and even updating to OS 11 it works as expected.

Please be sure to follow the notes in Marcelo's post.

Best regards,

Diogo Cardoso

17 Dec 2018

Adrian

Guys,

Thanks for the support, I managed to get a bit further thanks to adding the API key.

The excel generated by Service Studio is apparently protected so I had to copy the contents to a fresh excel file that one got accepted by the system , the translation ran smoothly, I can do a preview but when trying to download the file I get a big fat error (see below).

Any ideas what might be wrong?

Kind regards,

Adrian

Error executing query. Error in advanced query GetOriginalExcel in DownloadTranslatedVersion in ExcelTranslator in MainFlow in Translationtestapp (SELECT {ExcelTranslated}.[Key], {ExcelTranslated}.[Location], {ExcelTranslated}.[MaxLength], {ExcelTranslated}.[TextToBeTranslated] FROM {ExcelTranslated} JOIN {TimerForTranslation} ON {ExcelTranslated}.[TimerForTranslationId]={TimerForTranslation}.[Id] WHERE {TimerForTranslation}.[ExcelId]=@ExcelId GROUP BY {ExcelTranslated}.[Key], {ExcelTranslated}.[Location], {ExcelTranslated}.[MaxLength], {ExcelTranslated}.[TextToBeTranslated] ORDER BY 2 ASC ): The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value.
Environment Information	eSpaceVer: 0 (Id=9994, PubId=0, CompiledWith=11.0.108.0) RequestUrl: https://gbl-dev.outsystemsenterprise.com/Translationtestapp/ExcelTranslator.aspx (Method: POST) AppDomain: /LM/W3SVC/1/ROOT/Translationtestapp-182-131894214064712664 FilePath: d:\Outsystems\Platform Server\running\Translationtestapp.01679750520\ExcelTranslator.aspx ClientIp: 217.111.252.10 Locale: en-US DateFormat: dd-MM-yyyy PID: 7112 ('w3wp', Started='12/13/2018 1:23:53 PM', Priv=1756Mb, Virt=2110488Mb) TID: 127 Thread Name: .NET: 4.0.30319.42000
Stack:	[1] Error executing query. at ssTranslationtestapp.Flows.FlowMainFlow.ScrnExcelTranslator.FuncCommandDownloadTranslatedVersion.QueryGetOriginalExcel(HeContext heContext, Int32 maxRecords, IterationMultiplicity multiplicity, Int64& outParamCount, String qpstExcelId) at ssTranslationtestapp.Flows.FlowMainFlow.ScrnExcelTranslator.CommandDownloadTranslatedVersion(HeContext heContext, DateTime inParamExcelId_invar) [2] Error in advanced query GetOriginalExcel in DownloadTranslatedVersion in ExcelTranslator in MainFlow in Translationtestapp (SELECT {ExcelTranslated}.[Key], {ExcelTranslated}.[Location], {ExcelTranslated}.[MaxLength], {ExcelTranslated}.[TextToBeTranslated] FROM {ExcelTranslated} JOIN {TimerForTranslation} ON {ExcelTranslated}.[TimerForTranslationId]={TimerForTranslation}.[Id] WHERE {TimerForTranslation}.[ExcelId]=@ExcelId GROUP BY {ExcelTranslated}.[Key], {ExcelTranslated}.[Location], {ExcelTranslated}.[MaxLength], {ExcelTranslated}.[TextToBeTranslated] ORDER BY 2 ASC ): The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value.

18 Dec 2018

Marcelo Ferreira

Hi Adrian,

The component has a bug. Look for GetOriginalExcel and change the ExcelId input to datetime.

Regads,

Marcelo

18 Dec 2018

Diogo Cardoso

Hi Adrian,

Hi Marcelo,

Thanks for the reply from both of you.

We will update the component to fix this issue, thanks for the help Marcelo.

In the meantime, Adrian, please let us know if Marcelo's solution solves your issue.

Best regards,

Diogo Cardoso

18 Dec 2018

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.

See the full guidelines