I have a query that I am modifying from "Month" to "Week". I was able to replace the Month references and change them to week.
I can run the query in Toad. When I run it in Clarity, I get Caused by: java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01843: not a valid month
What is the best way to find the cause?
I don't see the data element listed in the logs that is causing the error.