CDN template in Application Setup doesn’t save

CDN template in Application Setup can’t be saved. Any changes disappear when logging out and logging in again.

Description description

Environment

Dynamic Media Classic

Issue/Symptoms

The CDN template in Application Setup, which is used to invalidate images, disappears after logging in and out. It means that the invalidate CDN option is not working as the field is empty. That is why copying and pasting the template is required each time it disappears. The issue is causing a delay in invalidating the images on the website.

Resolution resolution

The Database field where the CDN template is saved has an upper limit of 2500 characters. When a CDN template larger than that is saved, it results in an error in the logs, even though the UI does not indicate anything wrong. Bringing the template below 2500 characters resolves the error.

Here is what the logs indicate as a response to a Company Settings update request with too large of a CDN template:

2024-02-27 11:59:07,333 [ RESP_FAULT-f2957e392d404394b8accf8815f6c503]
[ user@company.com] [ -] [ updatePropertySet] [ 185 ms]
< tns:ipsApiFault
xmlns:tns=“http://www.scene7.com/IpsApi/xsd”> < tns:code> 30000< /tns:code> < tns:reason> java.sql.SQLException:
ORA-12899: value too large for column
“IPS”.“PROPERTYSETVALUE”.“VC_PROPERTYVALUE” (actual: 3620, maximum:
2500)
ORA-06512: at “IPS.SP3_ADDEDIT_PROPERTYSETVALUE”, line 100
ORA-06512: at line 1
< /tns:reason> < /tns:ipsApiFault>