Endpoint Protection

Hi,

We have LUA 2.3.4 installed on a separate server from SEPM.

We have set the LUA to use the connection through our proxy server and tested them successfully, however the download always fails.

No failure found under "activity monitor" logs.

I have retrieved the following from the logs:

 [pool-2-thread-2] INFO  handler.RequestHandler  - Starting download commit process
 [pool-2-thread-2] INFO  handler.RequestHandler  - Payload with status NOT_FOUND has been encountered, payloadId : 11
 [pool-2-thread-2] INFO  handler.RequestHandler  - no of payloads skipped because of files missing: 1
 [pool-2-thread-2] ERROR spi.SqlExceptionHelper  - ERROR: value too long for type character varying(200)
 [pool-2-thread-2] ERROR granulartelemetry.DAOGranularTelemetry  - Unknown exception while saving the specified telemetry.  
com.symantec.lua.mdl.granulartelemetry.Granulartelemetry@411ef4

LuaException [UserMessage[
ERROR:EXCEPTION_SAVING_CONFIGURATION:
]
Nested Exception is:
 [ org.hibernate.exception.DataException ] could not execute statement

org.hibernate.exception.DataException: could not execute statement

Any help would be highly appreciated.

Thanks.

Could you please post the complete log?  A proxy could pass the connection but a content filter might still block the updates. was this working before? when did it stop? Please post the logs

It never worked before. Find attached the logs.

Attachment(s)

lua-application_1.rar   50 KB 1 version

You said you are using proxy, but the log says there is no proxy, I think thats why it failing, Is it possible to bypass the proxy and check, just to narrow down where the problem is. This is what I snipped from your log.

 contentDir = clu-test    login = lua    readOnlyLogin =     proxyName = null    proxyPort = null    proxyProtocol = null    proxyUser = null    usingWriteOnlyLogin = false     )

This is what I retrieved from the logs (where I removed the proxy IP and username before posting the logs here).

name = Symantec LiveUpdate    username = xxxxxx    connectionStatus = null    deleted = false    updatedTimeStamp = null    connectionInfo = ConnectionInfo ( com.symantec.lua.mdl.server.ConnectionInfo@10ceebe    id = 1    hostName = liveupdate.symantecliveupdate.com    hostPort = 80    protocol = HTTP    contentDir =     login =     readOnlyLogin = null    proxyName = x.x.x.x    proxyPort = 8080    proxyProtocol = HTTP    proxyUser =     usingWriteOnlyLogin = false     )    serverType = LUA_SOURCE_SERVER     )  

I added a proxy under "source servers" config after which I could connect to the symantec live update site.

Before adding proxy, I would get "failure to connect" error.

So I can confirm we are using a proxy.

Also the download failed at 84%.

I can confirm we are using a proxy (see logs below where I had removed proxy IP and username before posting the logs here)

name = Symantec LiveUpdate    username = xxxxxx    connectionStatus = null    deleted = false    updatedTimeStamp = null    connectionInfo = ConnectionInfo ( com.symantec.lua.mdl.server.ConnectionInfo@10ceebe    id = 1    hostName = liveupdate.symantecliveupdate.com    hostPort = 80    protocol = HTTP    contentDir =     login =     readOnlyLogin = null    proxyName = x.x.x.x    proxyPort = 8080    proxyProtocol = HTTP    proxyUser =     usingWriteOnlyLogin = false     )    serverType = LUA_SOURCE_SERVER     )  

Anyway I could not connect to source servers before adding the proxy IP.

Test was successful after having added proxy

I see it now, that was from different servertype, there are totally 4.

if it has progressed till 86,it can connect to symantec.

from the log

 download.DownloadManager  - ****************************************************************update size 12670129897 Catalog size 326179

its around 12GB.

Can you break down the download to a smaller chuck.Select only Symantec enpdoint antivirus updates only. 

After updating the catalog

I would also suggent increasing the timeout setting.

http://www.symantec.com/connect/articles/liveupdate-administrator-2x-server-connection-recommendations

I had already modified "lua_static.properties" file, "server.xml" file, increased timeout under "preferences" tab and modified "actionitem" field in "productupdatedetails" table as recommended since I had setup the server but the download always failed.

I haven't tried breaking down the download.

I will launch the download with a smaller chunk and see.

But the issue still lies somewhere.

the error below may be somewhat related to the database?

LuaException [UserMessage[
ERROR:EXCEPTION_SAVING_CONFIGURATION:
]
Nested Exception is:
 [ org.hibernate.exception.DataException ] could not execute statement

Hello
We have exactly the same trouble
LUA 2.3.4 installed on a separate server from SEPM.
Download 98%, always fails.

LuaException [UserMessage[
ERROR:EXCEPTION_SAVING_CONFIGURATION:
]
Nested Exception is:
 [ org.hibernate.exception.DataException ] could not execute statement

AND

org.postgresql.util.PSQLException: ERROR: value too long for type character varying(200)

Hi Jeanyves,

I opened a case with support and the following workaround resolved my issue:

1/ Go to LUA\pgsql\bin
2/ Connect to database: “psql -p 7072 -U lua lua”
3/ Run query: “ALTER TABLE granular_telemetry_event ALTER COLUMN file_name TYPE character varying(256);”

Hope this helps.

Thank's a lot, Nansha, for sharing the solution!
This trick works fine for me!
Download 100% complete now.