LiveUpdate Administrator Download tasks fail at 99% with "ERROR: value too long for type character varying(4000)"

Products

• Endpoint Protection

Issue/Introduction

LiveUpdate Administrator (LUA) started to fail the download task at 99% after around September 5, 2023(GMT).

[Reason for failure] in LUA notification mail is "The download request failed to commit to database."

In the lua-application log files, there are errors similar to:

--------------------------------------
2023-09-11 12:46:11,003 [pool-3-thread-3] ERROR contentcatalog.DAOProductUpdate [] - Unknown exception while commit index info
org.hibernate.exception.DataException: could not execute statement
    at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:135) ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
    at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49) ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
...
Caused by: org.postgresql.util.PSQLException: ERROR: value too long for type character varying(4000)
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440) ~[postgresql-42.2.5.jar:42.2.5]
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183) ~[postgresql-42.2.5.jar:42.2.5]
...
2023-09-11 12:46:12,350 [pool-3-thread-3] ERROR handler.RequestHandler [] - Failed to commit and move updates
com.symantec.lua.util.exception.systemexceptions.LuaDataException: org.hibernate.exception.DataException: could not execute statement
    at com.symantec.lua.dao.contentcatalog.DAOProductUpdate.commitIndexInfo(Unknown Source) ~[classes/:?]
...
Caused by: org.postgresql.util.PSQLException: ERROR: value too long for type character varying(4000)
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440) ~[postgresql-42.2.5.jar:42.2.5]
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183) ~[postgresql-42.2.5.jar:42.2.5]
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308) ~[postgresql-42.2.5.jar:42.2.5]
...
2023-09-11 12:46:15,112 [pool-3-thread-3] INFO  handler.RequestHandler [] - -- To send download Request FAILURE event
2023-09-11 12:46:15,138 [pool-3-thread-3] INFO  handler.RequestHandler [] - Download Request Status is set to FAILURE
2023-09-11 12:46:15,138 [pool-3-thread-3] INFO  email.EmailNotificationHandler [] - Sending failure mail as request failed to commit to Database for the Download request with ReqID: 3
--------------------------------

If the following contents are removed from the target to be downloaded, the download task will succeed.

• Symantec Endpoint Protection 14.3 RU6 and earlier:
  • Symantec Advanced Endpoint Protection Upgrade Win64
    
    
• Symantec Endpoint Protection 14.3 RU7 and later:
  • Symantec  Endpoint Protection Upgrade ARM64
  • Symantec  Endpoint Protection Upgrade Win64

These contents are in [Symantec Endpoint Protection 14.x <language>] - [Client Updates] section.

 

Environment

LiveUpdate Administrator (LUA) 2.3.9 and earlier

Resolution

By upgrading to LUA 2.3.10 or later, you will be able to download the above contents as well.
To download the latest version of LUA visit Download LiveUpdate Administrator.