search cancel

LiveUpdate Administrator fails to download SEP 14.x content files

book

Article ID: 215609

calendar_today

Updated On:

Products

Endpoint Protection

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

Attachments