AWR Reports sometimes throw ORA-01406 (4332774)

WORKAROUND 1

The datatype that Oracle provides for AWR html reports is CHAR(8000).   But if max_string_size is set to STANDARD, the most Oracle can return via SQL is 4000.  So for some users, this report can cause ORA-01406.

A workaround could be to change the Oracle parameter max_string_size to EXTENDED if that is possible

WORKARIUND 2

Select the TOAD AWR Report in Text Format as this one works fine

STATUS

Issue fixed in version 15. The latest version of Toad for Oracle can be downloaded here