Hi, any suggestions or comments on that? I need your support. Regards, Tomoko
2016-06-02 10:52 GMT+09:00 Tomoko Uchida <[email protected]>: > Hello, > I encountered an SQLException when I deleted a job with many output > connections. > > ERROR 2016-06-02 09:41:49,492 (Document delete thread '9') - Document > delete thread aborting and restarting due to database connection > reset: Database exception: SQLException doing query (22001): ERROR: > value too long for type character varying(64) > > > I've found that the error occurred because of ManifoldCF trying to > insert long string (more than 64 characters) to 'activitytype' column > of 'repohistory' table while deleting documents associated with the > job. > > For a trial, I altered 'activitytype' column type to 'text' by this > sentence, and restarted ManifoldCF. > alter table repohistory alter column activitytype TYPE text; > Then the deletion histories was successfully added and the job seemed > to be safely deleted. > > Inserted 'activitytype' values are like this: > document deletion (outputA) (outputB) (outputC) (outputD) (outputE) ... > > For application requirements, I cannot limit the number of output > connectors (to shorten history records.) > > Is that OK? Or there are good solutions for that. > > Thank you, > Tomoko
