When trying to use the SQL Tuning Advisor from SQL Developer I get this error.
Tuning advisor was working some days before.
The solution is very simple. The string of the query is just too long.
I'm trying to optimize a stored procedure using dynamic sql with a parameter to decide if the sql is executed or output.
I just copied the output into a fresh sql developer pane and tried to use the tuning advisor.
The problem is that the generated output has a lot of trailing blanks, I just have to remove them.
Try to switch your browser's language settings.
If the database is running with American/America, switch your browser to en-us. Then re-connect and run the task again.
This fixed up our SQL Tuning Advisor task which failed with the same error.