How to register a WSDL with long endpoint address?

How to register a WSDL with long endpoint address?

book

Article ID: KB0080438

calendar_today

Updated On:

Products Versions
TIBCO ActiveMatrix Policy Director 1.1.0

Description

When trying to register a WSDL as an External Service, the below error is seen in the SystemNode.log:
--------------
24 May 2018 12:31:28,934 [amxAdminDefaultHttpConnector_85] [WARN ] [com.tibco.ampd.psm] org.hibernate.util.JDBCExceptionReporter - SQL Error: 8152, SQLState: 22001
24 May 2018 12:31:28,934 [amxAdminDefaultHttpConnector_85] [ERROR] [com.tibco.ampd.psm] org.hibernate.util.JDBCExceptionReporter - String or binary data would be truncated.
24 May 2018 12:31:28,940 [amxAdminDefaultHttpConnector_85] [ERROR] [com.tibco.ampd.psm] com.tibco.governance.gws.amxcomponent.wsdlmanager.GWSWsdlManagerServlet - Failed to register WSDL.[Error while registering <wsdl_name>, null.]
--------------

This is because the long endpoint address could not be inserted into PSMPORT table.

Environment

All Supported Platforms

Resolution

Increase the size of the column ENDPOINTADDRESS in the table PSMPORT in AMX Administrator database and then register the WSDL.

For example,
ALTER TABLE psmport MODIFY endpointaddress varchar(510);

Issue/Introduction

This article provides a workaround to register WSDLs with long binding address and avoid SQL errors.