Itgenclr150 + itgendcr031 when refreshing data

image

image

What is going wrong here when loading the data?

It seems that I no longer have access to one table, namely V2flat_projectitems.

Extra addition from PowerBI: It is a table that I can still address, but when removing data (duplicates) I suddenly get this message:

Unexpected error: Unable to translate bytes [8B] at index 1 from specified code page to Unicode.
Details:
    Microsoft.Mashup.Evaluator.Interface.ErrorException: Unable to translate bytes [8B] at index 1 from specified code page to Unicode. ---> System.Text.DecoderFallbackException: Unable to translate bytes [8B] at index 1 from specified code page to Unicode. ---> System.Text.DecoderFallbackException: Unable to translate bytes [8B] at index 1 from specified code page to Unicode.
   at System.Text.DecoderExceptionFallbackBuffer.Throw(Byte[] bytesUnknown, Int32 index)
   at System.Text.DecoderExceptionFallbackBuffer.Fallback(Byte[] bytesUnknown, Int32 index)
   at System.Text.DecoderFallbackBuffer.InternalFallback(Byte[] bytes, Byte* pBytes, Char*& chars)
   at System.Text.UTF8Encoding.GetChars(Byte* bytes, Int32 byteCount, Char* chars, Int32 charCount, DecoderNLS baseDecoder)
   at System.Text.DecoderNLS.GetChars(Byte[] bytes, Int32 byteIndex, Int32 byteCount, Char[] chars, Int32 charIndex, Boolean flush)
   at System.Text.DecoderNLS.GetChars(Byte[] bytes, Int32 byteIndex, Int32 byteCount, Char[] chars, Int32 charIndex)
   at System.IO.StreamReader.ReadBuffer(Char[] userBuffer, Int32 userOffset, Int32 desiredChars, Boolean& readToUserBuffer)
   at System.IO.StreamReader.Read(Char[] buffer, Int32 index, Int32 count)
   at Microsoft.OData.Json.JsonReader.ReadInput()
   at Microsoft.OData.Json.JsonReader.SkipWhitespaces()
   at Microsoft.OData.Json.JsonReader.Read()
   at Microsoft.OData.Json.BufferingJsonReader.ReadInternal()
   at Microsoft.OData.Json.BufferingJsonReader.ReadNextAndCheckForInStreamError()
   at Microsoft.OData.Json.BufferingJsonReader.ReadInternal()
   at Microsoft.OData.JsonLight.ODataJsonLightDeserializer.ReadPayloadStartImplementation(ODataPayloadKind payloadKind, PropertyAndAnnotationCollector propertyAndAnnotationCollector, Boolean isReadingNestedPayload, Boolean allowEmptyPayload)
   at Microsoft.OData.JsonLight.ODataJsonLightDeserializer.ReadPayloadStart(ODataPayloadKind payloadKind, PropertyAndAnnotationCollector propertyAndAnnotationCollector, Boolean isReadingNestedPayload, Boolean allowEmptyPayload)
   at Microsoft.OData.JsonLight.ODataJsonLightReader.ReadAtStartImplementation()
   at Microsoft.OData.ODataReaderCore.ReadImplementation()
   at Microsoft.OData.ODataReaderCore.InterceptException[T](Func`1 action)
   at Microsoft.Mashup.Engine1.Library.OData.V4_7.Reader.ODataReaderEnumerator.Read()
   at Microsoft.Mashup.Engine1.Library.OData.V4_7.Reader.ODataReaderEnumerator.Start()
   at Microsoft.Mashup.Engine1.Library.OData.V4_7.Reader.ODataReaderEnumerator.MoveNext()
   at Microsoft.Mashup.Engine1.Language.Query.DistinctQuery.DistinctEnumerable.DistinctEnumerator.MoveNext()
   at Microsoft.Mashup.Engine1.Runtime.SkipTakeEnumerator`1.MoveNext()
   at Microsoft.Mashup.Engine1.Runtime.RetryQuery.RetryEnumerator.MoveNext()
   at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.ValuePreviewValueSource.TableValuePreviewValueSource.SerializeRows(Int32 count)
   at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.ValuePreviewValueSource.TableValuePreviewValueSource.get_SmallValue()
   at Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_SmallValue()
   at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.<>c__DisplayClass0_0.<RunStub>b__0()
   at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(String entryName, IEngineHost engineHost, IMessageChannel channel, Action action)
   --- End of inner exception stack trace ---
   at Microsoft.Mashup.Evaluator.EvaluationHost.<>c__DisplayClass17_0.<TryReportException>b__1()
   at Microsoft.Mashup.Common.SafeExceptions.IgnoreSafeExceptions(IEngineHost host, IHostTrace trace, Action action)
   at Microsoft.Mashup.Evaluator.EvaluationHost.TryReportException(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Exception exception)
   at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(String entryName, IEngineHost engineHost, IMessageChannel channel, Action action)
   at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.<>c__DisplayClass12_0`1.<OnBeginGetResult>b__0()
   at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)
   at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetResult[T](IMessageChannel channel, BeginGetResultMessage message, Action`1 action)
   at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetPreviewValueSource(IMessageChannel channel, BeginGetPreviewValueSourceMessage message)
   at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
   at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
   at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
   at Microsoft.Mashup.Evaluator.ChannelMessenger.OnMessageWithUnknownChannel(IMessageChannel baseChannel, MessageWithUnknownChannel messageWithUnknownChannel)
   at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
   at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
   at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
   at Microsoft.Mashup.Evaluator.EvaluationHost.Run()
   at Microsoft.Mashup.Container.EvaluationContainerMain.Run(Object args)
   at Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass9_0.<CreateAction>b__0(Object o)
   at Microsoft.Mashup.Container.EvaluationContainerMain.SafeRun(String[] args)
   at Microsoft.Mashup.Container.EvaluationContainerMain.Main(String[] args)
   --- End of inner exception stack trace ---
   at Microsoft.Mashup.Evaluator.EvaluationHost.OnException(IEngineHost engineHost, IMessageChannel channel, ExceptionMessage message)
   at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
   at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
   at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
   at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
   at Microsoft.Mashup.Evaluator.Interface.IMessageChannelExtensions.WaitFor[T](IMessageChannel channel)
   at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.WaitFor(Func`1 condition, Boolean disposing)
   at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.get_SmallValue()
   at Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_SmallValue()
   at Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult2`1 result, Func`1 getStaleSince, Func`1 getSampled)

itgenclr150 and itgendcr031

These two screenshots relate to the path /app/diagnostics/logging/api. This has no relation to a Teamleader table or an OData4 download.

Additional information required

Would it be possible to add a (anonymised) screenshot of the request details in Invantive Bridge Online Monitoring, as described at Meer inzicht met nieuwe Online Monitoring?

You can find the details by clicking on the download request which represents the subject of this topic.

The download request usually has an SQL statement in which the table name is visible.

Please keep at least the following data visible in both columns:

  • the title bar with the request ID,
  • the status code, network size, path and timestamps in the left-hand column,
  • the error code and error message right at the bottom of the left-hand column,
  • the entire right-hand column, including the SQL statement, table name and parameter values.

For example:

Check the correct server and user

Carefully check that you are logging in on the Bridge Online website that is also used from Power BI, and with the same username. You will only see the requests from the Invantive Cloud user with which you log in on the website.

Four servers are in use:

  • bridge-online.cloud
  • app-online.cloud
  • bridge-online.invantive.com
  • app-online.invantive.com

You can see which server is being used in your script or the source code of the report.

Check the correct request and details

Make sure you select the request first in order to display the details. Only one request should be visible in the screenshot.

Also carefully check whether the request has a path containing odata4 or apps. Requests with other paths are generally not relevant for this purpose.

Error message and tips by e-mail

In addition, if there is an error message in Power BI, Power Query, Azure Data Factory, Qlik or Tableau, the Invantive Cloud user who received the error message will usually receive an e-mail at their e-mail address containing an error message and tips.

We advise checking the spam folder of the user concerned for such e-mails sent from support@invantive.com.

This question has been automatically closed after 1 week of inactivity. The last given answer has been marked as the solution.

Please post a new question in a separate topic if the issue occurs again. In the new question, please include a link to this topic by pasting its URL into the text.