Skip to main content
To homepage To homepage
Solved

Error synchronizing TimeXtender Dynamics 365 Business Central - Online data source

  • August 26, 2024
  • 9 replies
  • 211 views
oscarcleve
Contributor
Forum|alt.badge.img+1

I get the following error message when synchronizing a TimeXtender Dynamics 365 Business Central - Online data source:

 

“System.AggregateException: Ett eller flera fel har uppstått. ---> System.ApplicationException: Invalid response from Business Central retrieving table Field for company “

 

Authorize OAuth as well as Test Connection is successful in TimeXtender desktop.

 

It seems like the Tenant and the Environment parameters are correct as connection fails when I alter these parameters.

 

I am able to authorize and connect regardless what I input in the fields in the Account section.

 

I use the Service to Service authentication with Client ID and Client Secret from the Azure app registration.

 

I use TimeXtender v. 6718.1 and ODX Service v. 6718.1.

 

Any suggestions on what to try next?

 

Best answer by oscarcleve

I still wait for my customer’s approval to try a reinstallation. In the meantime I am retrieving data from BC through the TimeXtender REST connector. 

View original
Did this topic help you find an answer to your question?

9 replies

oscarcleve
Contributor
Forum|alt.badge.img+1
  • oscarcleve
  • Author
  • Contributor
  • 13 replies
  • August 26, 2024

Full error message:

System.AggregateException: Ett eller flera fel har uppstått. ---> System.ApplicationException: Invalid response from Business Central retrieving table Field for company 

   vid Jet.NavMetadataPlugin.BCCloudMetadata.GetTableViaCodeUnitAPIHandlingTimeouts(String tableName, String companyName, String fields, String filters, Int32 maxTotalRecs, Action`1 processPartialTable)
   vid Jet.NavMetadataPlugin.BCCloudMetadata.GetTableViaCodeUnitAPI(String tableName, String companyName, String fields, Int32 maxTotalRecs)
   vid Jet.NavMetadataPlugin.BCCloudMetadata.CollectMetaData()
   vid Jet.NavMetadataPlugin.BCCloudMetadata.GetTranslationTable()
   vid Jet.NavMetadataPlugin.BCCloudMetadataPlugin.GetAdapterTranslation(DataTable dataTable)
   vid TimeXtender.ODX.Account.BC365CustomDataSource.BCObjectInformation.<Initialize>b__26_0(BCCloudMetadataPlugin plugin)
   vid TimeXtender.ODX.Account.BC365CustomDataSource.BCObjectInformation.RunPlugin(Action`1 action)
   vid TimeXtender.ODX.Account.BC365CustomDataSource.BCObjectInformation.RunPlugin(Action`1 action, Boolean runInThread)
   vid TimeXtender.ODX.Account.BC365CustomDataSource.BCObjectInformation.Initialize()
   vid TimeXtender.ODX.Account.BC365CustomDataSource.AccountBC365CustomDataSource.GetTables(Func`3 tableHasFilterMatch, Func`4 columnHasFilterMatch)
   vid DataSourceEngine.Custom.CustomSourceEngine.SynchronizeSource(List`1 existingTableModels, IDataStorageEngine dataStorageEngine)
   vid ExecutionEngine.Action.SynchronizeAction.Execute()
   vid ExecutionEngine.Action.ExecutionAction.<.ctor>b__11_0()
   vid System.Threading.Tasks.Task.Execute()
   --- Slut på stackspårning för interna undantag ---
---> (Internt undantag #0) System.ApplicationException: Invalid response from Business Central retrieving table Field for company 

   vid Jet.NavMetadataPlugin.BCCloudMetadata.GetTableViaCodeUnitAPIHandlingTimeouts(String tableName, String companyName, String fields, String filters, Int32 maxTotalRecs, Action`1 processPartialTable)
   vid Jet.NavMetadataPlugin.BCCloudMetadata.GetTableViaCodeUnitAPI(String tableName, String companyName, String fields, Int32 maxTotalRecs)
   vid Jet.NavMetadataPlugin.BCCloudMetadata.CollectMetaData()
   vid Jet.NavMetadataPlugin.BCCloudMetadata.GetTranslationTable()
   vid Jet.NavMetadataPlugin.BCCloudMetadataPlugin.GetAdapterTranslation(DataTable dataTable)
   vid TimeXtender.ODX.Account.BC365CustomDataSource.BCObjectInformation.<Initialize>b__26_0(BCCloudMetadataPlugin plugin)
   vid TimeXtender.ODX.Account.BC365CustomDataSource.BCObjectInformation.RunPlugin(Action`1 action)
   vid TimeXtender.ODX.Account.BC365CustomDataSource.BCObjectInformation.RunPlugin(Action`1 action, Boolean runInThread)
   vid TimeXtender.ODX.Account.BC365CustomDataSource.BCObjectInformation.Initialize()
   vid TimeXtender.ODX.Account.BC365CustomDataSource.AccountBC365CustomDataSource.GetTables(Func`3 tableHasFilterMatch, Func`4 columnHasFilterMatch)
   vid DataSourceEngine.Custom.CustomSourceEngine.SynchronizeSource(List`1 existingTableModels, IDataStorageEngine dataStorageEngine)
   vid ExecutionEngine.Action.SynchronizeAction.Execute()
   vid ExecutionEngine.Action.ExecutionAction.<.ctor>b__11_0()
   vid System.Threading.Tasks.Task.Execute()<---
 

G
Community Manager
Forum|alt.badge.img
  • Greg Lennox
  • Community Manager
  • 21 replies
  • August 26, 2024

Hi Oscar,

Following my reply on your support ticket, I believe I was able to reproduce this error and am checking our our product team and will provide an update when it is available.

Thank you for your patience.

Greg Lennox

oscarcleve
1 person likes this
  • oscarcleve
    oscarcleve
oscarcleve
Contributor
Forum|alt.badge.img+1
  • oscarcleve
  • Author
  • Contributor
  • 13 replies
  • August 27, 2024

Hi,

Thank you! The provider version I am using is 20.2.0.0.

Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Thomas Lind
  • Community Manager
  • 1017 replies
  • August 28, 2024

Hi @oscarcleve 

As I mentioned in the ticket. This issue used to happen when we had installed the wrong Jet Analytics Extension, or had the old version. Once we updated the one we had it started working.

In the prerequisites for BC we explain how to install it, but it can also be used to reinstall it I assume.

 

Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

Hi @oscarcleve did you try reinstalling the Jet Analytics Extension as suggested by Thomas above?

oscarcleve
Contributor
Forum|alt.badge.img+1
  • oscarcleve
  • Author
  • Contributor
  • 13 replies
  • Answer
  • September 4, 2024

I still wait for my customer’s approval to try a reinstallation. In the meantime I am retrieving data from BC through the TimeXtender REST connector. 

R
Participant
Forum|alt.badge.img

Hi @Christian Hauggaard @Thomas Lind 

We run into the same error here. We have reinstalled the Jet Analytics Extension but still run into the same error. Any other options available that we can try and test?

Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Thomas Lind
  • Community Manager
  • 1017 replies
  • September 13, 2024

Hi @Remy Kamphuis | Victa 

There are more than one version and it needs to be the newest one. Due to a loss of rights, I can’t show you which ones exist and which one to choose, only to keep trying until all options have been attempted.

If it is not the edition of the extension, it is probably the rights you use.

If you use OAuth, it will be the user you authenticate with and the App if you use service to service.

I personally prefer the service to service option. The one I use is set up like so.

It gives me rights to see everything.

R
Participant
Forum|alt.badge.img

Hi @Thomas Lind, 

In the Extension Marketplace we only find two versions of the Jet Analytics for Business Central extensions. The first from Jet Global Data Technologies is not available anymore and they point to the second; the one from insightsoftware. This is the one we have installed; version 1.23.12.3601, which seems to be the latest. 

 

These are my rights:

 

Reply


Most helpful members this week

Terms and ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings