Error: The following exception occurred while the managed IDbCommand interface was being used - when using an Odata feed

When attempting to create an Odata feed from one of Altru's queries you may received this error message: The following exception occurred while the managed IDbCommand interface was being used: The content of the data feed is not valid for an Atom feed.. An error occurred while processing table 'Revenue'. The current operation was cancelled because another operation in the transaction failed
This issue has now been resolved. If you experience this error, please Click Chat with Support and provide exact steps to duplicate.

Steps to Duplicate

  1. Click Analysis > information library 
  2. Search for and select your query
  3. Click Get Odata link > copy the Odata link
  4. Open up Excel and create an Odata connection
Refreshing the existing file:
  1. Open the Excel file  > click the Data tab
  2. Click Refresh All
  3. Enter credentials

Environment

 Altru Arts & Cultural

Was this article helpful?