OLE DB or ODBC error: exception from HRESULT: 0x80040E4E

[Khyati01]

Hello friends 

I am trying to run a file in which I have 26 queries with huge files

All 26 queries does not have any errors 

No yellow mark or question mark

I have 24 gb ram in my laptop 

However I am tired of getting this error

In all queries 

I have tried to change data types as well nothing is working out for me

Please assist

 

[Anonymous]

Hi,@Khyati01 .I am glaf to help you.

Based on your description and the screenshots provided.

You mentioned that you tried to change the data type before but it did not work.

In this case, there may be an issue with the data source itself that prevents the data type change from taking effect. You need to check the integrity and consistency of the data source.

You mentioned that it contains 26 queries. Is it because the data source involves multiple steps or a large amount of data, which may lead to errors. Can you please try to simplify the query or execute it in steps.

Sometimes clearing the data source cache can resolve data loading issues.

Try clearing the data cache and revalidating the data source credentials.

After trying to clear the cache, reduce the number of queries on the data appropriately, and check and optimize the data structure in the data source version appropriately. Ensure that the field types and model relationships in the data source and Desktop are consistent.
Hope the following articles can help you.
URL:
Ole Db Or Odbc Error Exception From Hresult 0x80040e4e (Resolved)
Error 0x80040e4e: OLE DB or ODBC [Exception from HRESULT]
 

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.