Hi, any suggestions? Is this a known limitation, or should I create a ticket about that?
Thanks, Tomoko 2016-06-09 10:44 GMT+09:00 Tomoko Uchida <[email protected]>: > Hello developers, > > I have sent same message to the user mailing list but there are no > reply. Could anyone help me? > Some jobs in our customer production environment no longer cannot be > deleted for this problem. > > We are looking for solutions to delete the jobs safely. > If my question was not clear, I am ready to provide more detailed explanation. > > ---- > > 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. > > ALTER TABLE repohistory ALTER COLUMN activitytype TYPE text; > > After altering the table I restarted ManifoldCF 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 in advance, > Tomoko
