Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Not a legal OleAut date..

Getting the following error while refreshing from an Oracle DB using the Gateway refresh...   The following exception occurred while the managed IDataReader interface was being used: Not a legal Ol...
waltheed's avatar
waltheed
Icon for Impactful Individual rankImpactful Individual
9 years ago

Thanks Anonymous for your post! You helped me out.

 

I had the same error message. And indeed some of my dates ware having strange values, like 01-01-0015 and 01-01-0215. These should have been 01-01-2015. After I changed the data the refresh worked.

In my case these dates were not used in a relationship.

 

 

sweidlich's avatar
sweidlich
Icon for Advocate II rankAdvocate II
8 years ago

(I wanted to add to this, in case other people google this and find this...)

 

The messed up years were proving to be the issue for me, too. Fortunately, there were only a few (0997 should have been 1997, etc.). And I was able to add some steps to the query to replace the values with the correct date. This kept me from changing column number types back and forth.