ERROR: value too long for type character varying(255)


Issue:  Moab is not able to send charges to MAM because it is getting error messages indicating that the database is rejecting the request. 

Symptom:  You can get errors in the logs similar to the following:

4:33:35 19:26:21 N/A 0 1 Failure registering job Start (<jobid>) with accounting manager -- Unable to invoke AM request - server rejected request with status code 720 - DBD::Pg::db do failed: ERROR: value too long for type character varying(255)
4:33:35 19:26:21 N/A 0 1 Unable to invoke AM request - server rejected request with status code 720 - DBD::Pg::db do failed: ERROR: value too long for type character varying(255)

 

Solution:  It's possible to have a couple columns in the database that don't allow for the correct number of characters.  You can update these columns by accessing the database directly and running these commands:

ALTER TABLE g_transaction ALTER COLUMN g_details TYPE character varying(1024);
ALTER TABLE g_transaction ALTER COLUMN g_description TYPE character varying(1024);

Tags: MAM, MySQL, PG, Postgres, PostgreSQL
Last update:
2015-12-30 18:07
Author:
Ben Roberts
Revision:
1.0
Average rating:0 (0 Votes)

You can comment this FAQ

Chuck Norris has counted to infinity. Twice.

Records in this category

Tags