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

Forge Component
(3)
Published on 2018-12-18 by Indigo Leap
3 votes
Published on 2018-12-18 by Indigo Leap


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 InformationeSpaceVer: 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


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

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

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 InformationeSpaceVer: 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.

Hi Adrian,

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

Regads,

Marcelo


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