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

Certified Lead Developer

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?

  Discussion posts and replies are publicly visible