search cancel

Failed to import XML CA Catalog.

book

Article ID: 228486

calendar_today

Updated On:

Products

CA Service Catalog

Issue/Introduction

Trying to export an XML, but we see that the result is zero, when reviewing the logs we see this message: 

Caused by: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.microsoft.sqlserver.jdbc.SQLServerException: Length of LOB data (66194) to be replicated exceeds configured maximum 65536. Use the stored procedure sp_configure to increase the configured maximum value for max text repl size option, which defaults to 65536. A configured value of -1 indicates no limit, other that the limit imposed by the data type.


Error Code: 7139
Call: UPDATE usm_form_component_attrib_ext SET attr_long_value = ? WHERE (form_comp_attr_id = ?)

We do not know how to validate the size mentioned in the message.

Environment

Release : 17.2

Component : Catalog - Attachments/Notes

Resolution

The modification of the XML was made because the database cache has a lower value than the amount referenced.

Additional Information

See also:

https://www.sqlservercentral.com/blogs/replication-max-text-length