Skip to main content
May 10, 2023
Question

Deprecated Export SQL to Excel Smart Service Not a Valid Month Error

  • May 10, 2023
  • 1 reply
  • 0 views

Hi,

I have been using the Deprecated Export SQL to Excel Smart Service for a document download functionality. When the process model is initiated back to back like twice, or randomly out of nowhere with even the first try, the smart service gives this error and the process model fails: "The following error was raised by the Export to Excel function: ORA-01843: not a valid month". 

I did an analysis on the SQL code, it works on the database and I believe it should be fine. In the SQL code, I have to_date function and I am comparing two dates with different formats such as MM/DD/yyyy and yyyyMMdd. I am wondering if anyone else is facing a similar issue and what would be the possible solution?

    1 reply

    mathieud0001
    May 10, 2023

    Would need to see the SQL to be able to help.