Skip to main content

Need Help Using Spok Knowledge?

Certain site features may not be supported by older versions of Internet Explorer.
Chrome, Edge, Firefox, or Safari will provide the most optimal experience.
Spok

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

Related Defects:

N/A

 


KB48667