Skip to main content
New Participant
May 10, 2023 1:24 AM UTC
Question

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

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
    Genius
    May 10, 2023 10:36 AM UTC

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