Forum Discussion
Anonymous
5 years agoNot applicable
ORA-01861 and ORA-01847 problems
Hi,
Now that I've been able to change my gateway on a server that runs 24/7, I have two datasets who caused me problems.
ORA-01861: literal does not match format string
and
ORA-01847: day of month must be between 1 and last day of month
I don't know where these problems come from. Sometimes, I know that Oracle don't like data type for my dates. When i'm with Power BI Desktop on my computer, these problems don't pop up when I refresh the dataset. Only happens on my workspace. Someone have an idea?
Thanks.
2 Replies
- GilbertQ
Super User
Hi Anonymous
Could you confirm that you have got the latest version of the On-Premise Gateway installed?- AnonymousNot applicable