I recently came across an error like this when looking through application logs at work:
Error: org.postgresql.util.PSQLException: ERROR: value too long for type character varying(3500)
It's an application that I'm not 100% familiar with yet and it wasn't clear which table and column the error message was referring to. All I knew was that it was some varchar(3500) column. Fortunately, PostgreSQL makes it easy to query the database schema.
SELECT * FROM information_schema.columns WHERE table_schema = 'public' AND data_type = 'character varying' AND character_maximum_length = 3500;
In my case it narrowed things down to a few possibilities of which one was the obvious answer. Hopefully you have the same luck.