LiveUpdate Administrator fails to download SEP 14.x content files
Article ID: 215609
Updated On:
Products
Issue/Introduction
LiveUpdate Administrator (LUA) start to fail download task after around 6 AM GMT, May 21.
[Reason for failure] in LUA notification mail is "The download request failed to commit to database."
From OS Application log:
Log Name: Application
Source: PostgreSQL
Level: Error
Description:
The description for Event ID 0 from source PostgreSQL cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.
If the event originated on another computer, the display information had to be saved with the event.
The following information was included with the event:
2021-05-21 15:29:37.576 IST [5908] ERROR: value too long for type character varying(4000)
2021-05-21 15:29:37.576 IST [5908] STATEMENT: insert into PreCondition (name, value, ID) values ($1, $2, $3)
From the lua-application logs:
2021-05-22 12:21:41,818 [pool-2-thread-1] ERROR spi.SqlExceptionHelper - ERROR: value too long for type character varying(4000)
2021-05-22 12:21:41,828 [pool-2-thread-1] 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)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
.
Caused by: org.postgresql.util.PSQLException: ERROR: value too long for type character varying(4000)
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2455)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2155)
2021-05-22 12:21:41,832 [pool-2-thread-1] ERROR handler.RequestHandler - Failed to commit and move updates
LuaException [UserMessage[
ERROR:EXCEPTION_DBACCESS:
]
Nested Exception is:
[ org.hibernate.exception.DataException ] could not execute statement
org.hibernate.exception.DataException: could not execute statement
at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:135)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
.
Caused by: org.postgresql.util.PSQLException: ERROR: value too long for type character varying(4000)
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2455)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2155)
.
Caused by: org.hibernate.exception.DataException: could not execute statement
at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:135)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
Environment
LiveUpdate Administrator 2.x
Resolution
A new LUA catalog has been published to address this issue.
You would need to manually update the LU catalog within your LUA
To download and update the new LU catalog:
1. Log in LUA console.
2. [Configure] - select "My Symantec Products"
3. Click on "update Symantec Product Catalog"
4. After the catalog has updated, run the download task
Additional Information
Note : If you have unchecked the following 4 contents as a temporary workaround which was described in this document previously, please check them again.
- [Manager - Virus Definitions (Win32)]
- [Manager - Virus Definitions (Win64)]
- [Manager - Virus R Definitions (Win32)]
- [Manager - Virus R Definitions (Win64)]
These contents are in [Symantec Endpoint Protection 14.x <language>] - [Content Updates] section.
ESCRT-7021
Endpoint Protection 12.1.x content (definitions) no longer available for download
Feedback
