Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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

  • Hi Anonymous 


    Could you confirm that you have got the latest version of the On-Premise Gateway installed?

    • Anonymous's avatar
      Anonymous
      Not applicable

      GilbertQ I guess so. Here what I have :