API Errors Due to Hostname Length

Overview

The following error can be seen in Smart Suite 7.0 environments

err_message: -20115 
ORA-20115: Unable to send message: 
ORA-06502: PL/SQL: numeric or value error: character string buffer too small 
ORA-06512: at "ATMS.I_MESSAGE", line 21 

This error is due to the hostname of the server being too long for the database table.

Example = HostNameExample.HostDomainExample.com

Resolution

Edit the following lines in the amcomapi.ini configuration file:
 
# The following parameter should be set when the hostname is greater than 32 chars to a unique
# name across linux servers that is less than 32 characters
MACHINE HOST NAME = HostNameExample

Reset the AmcomAPI process