Error to Download Definition via LUA Server

[Wilbur Loy]

Dear,

Via LUA Server I cant complete to download some virus definitions for Symantec Endpoint Protection 14.2 RU2, It keeps failing at 99%.

My Symantec Liveupdate Administrator is of Version: 2.3.9.30. From the log of the lua-application.log its not possible to find a file to download form the Symantec URL (https://liveupdate.symantecliveupdate.com:443/)

***

2023-09-12 10:01:02,480 [pool-3-thread-24] INFO  rcl.HttpsHelper [] - Released connection for HTTP Get Method
2023-09-12 10:01:02,480 [pool-3-thread-24] INFO  download.CatalogDownloader [] - miniTriFile not found on server : C:\TempDownload\Downloads\1694484053259\1\sepc$20smr$20definitions$2014.2$20ru2_microdefsb.old_symalllanguages_livetri.zip
2023-09-12 10:01:02,480 [pool-3-thread-24] INFO  rcl.HttpsHelper [] - about to download file (url): https://liveupdate.symantecliveupdate.com:443/sepc$20smr$20definitions$2014.2$20ru2_microdefsb.error_symalllanguages_livetri.zip
2023-09-12 10:01:03,203 [pool-3-thread-24] INFO  rcl.HttpsHelper [] - After execute method code: 404 - method.contentLength: 433
2023-09-12 10:01:03,203 [pool-3-thread-24] ERROR rcl.HttpsHelper [] - Http Error Msg : HTTP/1.1 404 Not Found
2023-09-12 10:01:03,203 [pool-3-thread-24] ERROR rcl.HttpsHelper [] - could not find file to download - 
java.io.FileNotFoundException: 404: could not find file to download - /sepc$20smr$20definitions$2014.2$20ru2_microdefsb.error_symalllanguages_livetri.zip on: ConnectionInfo ( com.symantec.lua.mdl.server.ConnectionInfo@4f4146fb    id = 1    hostName = liveupdate.symantecliveupdate.com    hostPort = 443    protocol = HTTPS    contentDir =     login =     readOnlyLogin = null    proxyName = null    proxyPort = null    proxyProtocol = null    proxyUser = null    usingWriteOnlyLogin = false    proxyEnabled = false     )
    at com.symantec.lua.util.rcl.HttpsHelper.downloadFile(Unknown Source) [classes/:?]
    at com.symantec.lua.util.rcl.HttpsHelper.downloadFile(Unknown Source) [classes/:?]
    at com.symantec.lua.handler.download.DownloadHelper.downloadFile(Unknown Source) [classes/:?]
    at com.symantec.lua.handler.download.CatalogDownloader.call(Unknown Source) [classes/:?]
    at com.symantec.lua.handler.download.CatalogDownloader.call(Unknown Source) [classes/:?]
    at java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?]
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1130) [?:?]
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:630) [?:?]
    at java.lang.Thread.run(Thread.java:832) [?:?]
2023-09-12 10:01:03,203 [pool-3-thread-24] INFO  rcl.HttpsHelper [] - Released connection for HTTP Get Method
2023-09-12 10:01:03,203 [pool-3-thread-24] INFO  download.CatalogDownloader [] - miniTriFile not found on server : C:\TempDownload\Downloads\1694484053259\1\sepc$20smr$20definitions$2014.2$20ru2_microdefsb.error_symalllanguages_livetri.zip
2023-09-12 10:01:03,203 [pool-3-thread-24] INFO  threadpool.LUAThreadPool [] - Execute: LUA THREAD POOL SIZE: 1 total task count: 154 Active task count: 2
2023-09-12 10:01:03,203 [pool-3-thread-37] INFO  threadpool.LUAThreadPool [] - Execute: LUA THREAD POOL SIZE: 0 total task count: 154 Active task count: 1
2023-09-12 10:01:03,204 [http-nio-7070-exec-10] INFO  download.ContentCatalogHandler [] - Value of allConnectionFailed after validating - > false

***

https://liveupdate.symantecliveupdate.com/sepc$20smr$20definitions$2014.2$20ru2_microdefsb.error_symalllanguages_livetri.zip 

gives 404 error.

***

Also is the $20 URL escape code correct? I checked its for SPACE

Character	URL Escape Codes	String Literal Escape Code
SPACE	%20	$20

Appreciate if can help me to understand how i can resolve this.

[Tamás Kiss]

Hi, Try to split downloads (manager, clients) and distributions. Create 2 downloads and 2 distributions.

[Wilbur Loy]

Hi, I wasn't able to split between manager and clients, the options were clients and contents instead. So I was able to complete 100% contents download. But the clients download failed at 99%.

[Wilbur Loy]

Hi,

I can split into the following options (content, client)

I was able to complete for content download but not the client download

Attached is the full logs for the 2023-09-14

I m not sure if I am looking at the right direction to try to understand what went wrong.

But my focus is on the following files not able to download 

***
Line 555
***

2023-09-14 13:11:39,708 [pool-2-thread-13] ERROR rcl.HttpsHelper [] - could not find file to download - 
java.io.FileNotFoundException: 404: could not find file to download - /sepc$20error$20submission$20control$20data_1.0_symalllanguages_livetri.zip on: ConnectionInfo ( com.symantec.lua.mdl.server.ConnectionInfo@3fcc22f0    id = 1    hostName = liveupdate.symantecliveupdate.com    hostPort = 443    protocol = HTTPS    contentDir =     login =     readOnlyLogin = null    proxyName = null    proxyPort = null    proxyProtocol = null    proxyUser = null    usingWriteOnlyLogin = false    proxyEnabled = false     )

***
Line 11973
***

2023-09-14 13:16:55,268 [pool-2-thread-39] ERROR rcl.HttpsHelper [] - could not find file to download - 
java.io.FileNotFoundException: 404: could not find file to download - /sepm$20behavior$20and$20security$20heuristics$2014.2$20ru2_microdefsb.apr_symalllanguages_livetri.zip on: ConnectionInfo ( com.symantec.lua.mdl.server.ConnectionInfo@50a38487    id = 1    hostName = liveupdate.symantecliveupdate.com    hostPort = 443    protocol = HTTPS    contentDir =     login =     readOnlyLogin = null    proxyName = null    proxyPort = null    proxyProtocol = null    proxyUser = null    usingWriteOnlyLogin = false    proxyEnabled = false     )

***

I am hoping if anyone with the same product Symantec Endpoint Protection 14.2 RU2 can let me know if they encountered such similar issue this week. The downloads were all able to complete successfully before this week. And I tried to use another LUA setup in my office network to perform this product download and also encountered this 99% mark failed situation.

Thanks for taking the time to read this.

Attachment(s)

lua-application-2023-09-14.log   4.01 MB 1 version

[Marius Bjoernstad]

I don't know about those messages in particular, but I've had a lot of failures like that in LUA.

First make sure you have enough disk space. The error sure doesn't look like that, because it's a 404 error, but it's a quick thing to check so why not.

You can use the [+] buttons on the "Select Products to be Added" screen to narrow down the files to download, and at least for me, I can usually successfully download everything except a few files. For the failed files, they will probably work after there's a new version released, or you can possibly use the Content Manager tab to delete the files, then try again.

[Off topic: I can only do this a few times per year, and I think LUA doesn't handle that well and gives me many errors like this. I've personally given up on LUA, but haven't found an alternative method to do what it does.]

[Wilbur Loy]

Hi, I was able to identify that the content downloads actually completed. Just the saving of commits failed
--
2023-09-18 10:18:44,718 [pool-3-thread-3] INFO  download.DownloadUpdateRequest [] - DownloadRequestThread started for request id : 233
2023-09-18 10:18:44,719 [pool-3-thread-3] INFO  download.DownloadUpdateRequest [] - Download Request Status will be set to RETRIEVING

...

2023-09-18 10:20:47,496 [pool-3-thread-3] INFO  handler.RequestHandler [] - Updating status of downloadJob : 233 to ---> JOB_COMPLETE
2023-09-18 10:20:47,506 [pool-3-thread-3] INFO  handler.RequestHandler [] - ************LUA_DOWNLOAD_CONTENT TRANSFER_END************
2023-09-18 10:20:47,506 [pool-3-thread-3] INFO  download.DownloadUpdateRequest [] - Download Request Invocation Result : COMPLETE
2023-09-18 10:20:47,506 [pool-3-thread-3] INFO  handler.RequestHandler [] - Starting download commit process
2023-09-18 10:20:47,507 [pool-3-thread-3] INFO  handler.RequestHandler [] - There are updates to be commited, starting move process and database changes
2023-09-18 10:20:47,507 [pool-3-thread-3] INFO  handler.RequestHandler [] - About to sleep before sending an download request state change event
2023-09-18 10:20:47,508 [pool-3-thread-3] INFO  handler.RequestHandler [] - wake up after sleep in download request state change, so that event can be sent
2023-09-18 10:20:47,508 [pool-3-thread-3] INFO  handler.RequestHandler [] - Download Request Status is set to DOWNLOAD_COMMITING
2023-09-18 10:20:47,508 [pool-3-thread-3] INFO  util.LuaUtil [] -  JVM Runtime - Memory in MB - Total memory: 709 Free Memory: 362 maximum memory: 1536
2023-09-18 10:20:47,508 [pool-3-thread-3] INFO  common.ContentRepository [] - Write Lock on content repository accquired
2023-09-18 10:20:47,508 [pool-3-thread-3] INFO  common.ContentRepository [] - ************LUA_DOWNLOAD_COPY_UPDATES_TO_CONTENT_REPOSITORY_START************
2023-09-18 10:20:48,447 [http-nio-7070-exec-2] ERROR monitor.MonitorManager [] - Percent complete greater that 100. requestId: 233
2023-09-18 10:20:49,385 [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]
    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126) ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112) ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
    at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:211) ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
    at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:62) ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3124) ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3581) ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
    at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:104) ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
    at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:465) ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
    at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:351) ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
    at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:350) ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
    at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:56) ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
    at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1258) ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
    at com.symantec.lua.dao.contentcatalog.DAOProductUpdate.commitIndexInfo(Unknown Source) [classes/:?]
    at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
    at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:?]
    at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
    at java.lang.reflect.Method.invoke(Method.java:564) ~[?:?]
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333) [spring-aop-4.3.5.RELEASE.jar:4.3.5.RELEASE]
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) [spring-aop-4.3.5.RELEASE.jar:4.3.5.RELEASE]
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) [spring-aop-4.3.5.RELEASE.jar:4.3.5.RELEASE]
    at org.springframework.aop.framework.adapter.ThrowsAdviceInterceptor.invoke(ThrowsAdviceInterceptor.java:125) [spring-aop-4.3.5.RELEASE.jar:4.3.5.RELEASE]
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.3.5.RELEASE.jar:4.3.5.RELEASE]
    at org.springframework.aop.framework.adapter.AfterReturningAdviceInterceptor.invoke(AfterReturningAdviceInterceptor.java:52) [spring-aop-4.3.5.RELEASE.jar:4.3.5.RELEASE]
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.3.5.RELEASE.jar:4.3.5.RELEASE]
    at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52) [spring-aop-4.3.5.RELEASE.jar:4.3.5.RELEASE]
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.3.5.RELEASE.jar:4.3.5.RELEASE]
    at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99) [spring-tx-4.3.5.RELEASE.jar:4.3.5.RELEASE]
    at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282) [spring-tx-4.3.5.RELEASE.jar:4.3.5.RELEASE]
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) [spring-tx-4.3.5.RELEASE.jar:4.3.5.RELEASE]
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.3.5.RELEASE.jar:4.3.5.RELEASE]
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213) [spring-aop-4.3.5.RELEASE.jar:4.3.5.RELEASE]
    at com.sun.proxy.$Proxy56.commitIndexInfo(Unknown Source) [?:?]
    at com.symantec.lua.common.ContentRepository.commitUpdates(Unknown Source) [classes/:?]
    at com.symantec.lua.handler.RequestHandler.commitDownloadRequest(Unknown Source) [classes/:?]
    at com.symantec.lua.handler.download.DownloadUpdateRequest.download(Unknown Source) [classes/:?]
    at com.symantec.lua.handler.download.DownloadUpdateRequest.call(Unknown Source) [classes/:?]
    at java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?]
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) [?:?]
    at java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?]
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1130) [?:?]
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:630) [?:?]
    at java.lang.Thread.run(Thread.java:832) [?:?]
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]
    at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441) ~[postgresql-42.2.5.jar:42.2.5]
    at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365) ~[postgresql-42.2.5.jar:42.2.5]
    at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:143) ~[postgresql-42.2.5.jar:42.2.5]
    at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:120) ~[postgresql-42.2.5.jar:42.2.5]
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) ~[commons-dbcp-1.4.jar:1.4]
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) ~[commons-dbcp-1.4.jar:1.4]
    at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:208) ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
    ... 39 more
2023-09-18 10:20:49,385 [pool-3-thread-3] INFO  common.ContentRepository [] - Write Lock on content repository released
2023-09-18 10:20:49,385 [pool-3-thread-3] INFO  util.LuaUtil [] -  JVM Runtime - Memory in MB - Total memory: 709 Free Memory: 357 maximum memory: 1536
2023-09-18 10:20:49,385 [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/:?]
    at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
    at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:?]
    at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
    at java.lang.reflect.Method.invoke(Method.java:564) ~[?:?]
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333) ~[spring-aop-4.3.5.RELEASE.jar:4.3.5.RELEASE]
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) ~[spring-aop-4.3.5.RELEASE.jar:4.3.5.RELEASE]
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) ~[spring-aop-4.3.5.RELEASE.jar:4.3.5.RELEASE]
    at org.springframework.aop.framework.adapter.ThrowsAdviceInterceptor.invoke(ThrowsAdviceInterceptor.java:125) ~[spring-aop-4.3.5.RELEASE.jar:4.3.5.RELEASE]
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) ~[spring-aop-4.3.5.RELEASE.jar:4.3.5.RELEASE]
    at org.springframework.aop.framework.adapter.AfterReturningAdviceInterceptor.invoke(AfterReturningAdviceInterceptor.java:52) ~[spring-aop-4.3.5.RELEASE.jar:4.3.5.RELEASE]
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) ~[spring-aop-4.3.5.RELEASE.jar:4.3.5.RELEASE]
    at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52) ~[spring-aop-4.3.5.RELEASE.jar:4.3.5.RELEASE]
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) ~[spring-aop-4.3.5.RELEASE.jar:4.3.5.RELEASE]
    at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99) ~[spring-tx-4.3.5.RELEASE.jar:4.3.5.RELEASE]
    at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282) ~[spring-tx-4.3.5.RELEASE.jar:4.3.5.RELEASE]
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) ~[spring-tx-4.3.5.RELEASE.jar:4.3.5.RELEASE]
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) ~[spring-aop-4.3.5.RELEASE.jar:4.3.5.RELEASE]
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213) ~[spring-aop-4.3.5.RELEASE.jar:4.3.5.RELEASE]
    at com.sun.proxy.$Proxy56.commitIndexInfo(Unknown Source) ~[?:?]
    at com.symantec.lua.common.ContentRepository.commitUpdates(Unknown Source) ~[classes/:?]
    at com.symantec.lua.handler.RequestHandler.commitDownloadRequest(Unknown Source) [classes/:?]
    at com.symantec.lua.handler.download.DownloadUpdateRequest.download(Unknown Source) [classes/:?]
    at com.symantec.lua.handler.download.DownloadUpdateRequest.call(Unknown Source) [classes/:?]
    at java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?]
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) [?:?]
    at java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?]
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1130) [?:?]
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:630) [?:?]
    at java.lang.Thread.run(Thread.java:832) [?:?]
Caused by: 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]
    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126) ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112) ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
    at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:211) ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
    at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:62) ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3124) ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3581) ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
    at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:104) ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
    at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:465) ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
    at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:351) ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
    at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:350) ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
    at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:56) ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
    at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1258) ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
    ... 30 more
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]
    at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441) ~[postgresql-42.2.5.jar:42.2.5]
    at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365) ~[postgresql-42.2.5.jar:42.2.5]
    at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:143) ~[postgresql-42.2.5.jar:42.2.5]
    at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:120) ~[postgresql-42.2.5.jar:42.2.5]
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) ~[commons-dbcp-1.4.jar:1.4]
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) ~[commons-dbcp-1.4.jar:1.4]
    at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:208) ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
    at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:62) ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3124) ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3581) ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
    at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:104) ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
    at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:465) ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
    at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:351) ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
    at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:350) ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
    at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:56) ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
    at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1258) ~[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
    ... 30 more
2023-09-18 10:20:49,776 [pool-3-thread-3] INFO  handler.RequestHandler [] - Timestamp folder - 1695003523211 of this request is deleted
2023-09-18 10:20:49,781 [pool-3-thread-3] INFO  handler.RequestHandler [] - About to sleep before sending an download request state change event
2023-09-18 10:20:49,781 [pool-3-thread-3] INFO  handler.RequestHandler [] - wake up after sleep in download request state change, so that event can be sent
2023-09-18 10:20:51,782 [pool-3-thread-3] INFO  handler.RequestHandler [] - -- To send download Request FAILURE event
2023-09-18 10:20:51,799 [pool-3-thread-3] INFO  handler.RequestHandler [] - Download Request Status is set to FAILURE
2023-09-18 10:20:51,799 [pool-3-thread-3] INFO  email.EmailNotificationHandler [] - Sending failure mail as request failed to commit to Database for the Download request with ReqID: 233
2023-09-18 10:20:51,846 [pool-3-thread-3] INFO  handler.RequestHandler [] -  successfully removed ft from map for req id 233
2023-09-18 10:20:51,846 [pool-3-thread-3] INFO  handler.RequestHandler [] - Current requests cached in RequestHandler class  : =====requestTasks - reqIds: 
    =====requestSinkMap - reqIds: 
    =====requestFutureTaskTable - reqIds: 
2023-09-18 10:20:51,846 [pool-3-thread-3] INFO  download.DownloadUpdateRequest [] - ************LUA_DOWNLOAD_END************ for Request Id: 233
2023-09-18 10:20:51,846 [pool-3-thread-3] INFO  download.DownloadUpdateRequest [] - ********************Event End************************