Forum Discussion

InsureBI's avatar
InsureBI
Advocate II
10 years ago

Data refresh error: OLE DB or ODBC error: Exception from HRESULT: 0x80040E1D.

I am trying to refresh a table (with less than 50 records and 200 columns).  The source is a text file on my desktop and I am pretty sure nothing has changed except a few additional records in the ne...
Need Help
GrimasS's avatar
GrimasS
Regular Visitor
10 years ago

Hi Insure BI,

 

Not sure if you got this resolved or not but take a look at the Relationship Manager and see if there are any conflicting relationships. I get this error when adding new Columns or Tables to my report. I have several relationships between tables in my report and the Relationship Manager will sometimes autodetect new relationships when adding in new Columns or Tables. Some of these newly created relationships will conflict with the old ones. When this happens and  I attempt to refresh the report I get your error. So any time I add new Columns or Tables to my report, I have to double check the Relationship Manager to see if there are any new relationships.

ggrozak's avatar
ggrozak
Frequent Visitor
10 years ago

I am having this same problem. Data source is a local SQL table.

 

Any thoughts?

  • mcray11's avatar
    mcray11
    Helper I
    10 years ago

    I'm also having this same problem, from excel data sources.

    I've reviewed the relationships in my database, and eliminated several of the newest ones, but have not been able to resolve the issue. Any other suggestions?

    • mcray11's avatar
      mcray11
      Helper I
      10 years ago

      I gave up on trying to fix the issue and deleted the table giving the error. Then I was able to refresh the remaining data and able to re-add the table.