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);