2022-10-14 23:05:41.946  INFO 1 --- [           main] c.a.a.h.AffinitiHnbf360EsSvApplication   : Starting AffinitiHnbf360EsSvApplication vV1.00.05 using Java 11.0.16.1 on 93934bf285b1 with PID 1 (/AFFINITI_DMS_LGL_ES_SV.jar started by root in /)
2022-10-14 23:05:41.952  INFO 1 --- [           main] c.a.a.h.AffinitiHnbf360EsSvApplication   : The following profiles are active: dev
2022-10-14 23:05:43.770  INFO 1 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat initialized with port(s): 8090 (http)
2022-10-14 23:05:43.791  INFO 1 --- [           main] o.apache.catalina.core.StandardService   : Starting service [Tomcat]
2022-10-14 23:05:43.791  INFO 1 --- [           main] org.apache.catalina.core.StandardEngine  : Starting Servlet engine: [Apache Tomcat/9.0.53]
2022-10-14 23:05:43.914  INFO 1 --- [           main] o.a.c.c.C.[Tomcat].[localhost].[/]       : Initializing Spring embedded WebApplicationContext
2022-10-14 23:05:43.914  INFO 1 --- [           main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 1872 ms
2022-10-14 23:05:45.097  INFO 1 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat started on port(s): 8090 (http) with context path ''
2022-10-14 23:05:45.117  INFO 1 --- [           main] c.a.a.h.AffinitiHnbf360EsSvApplication   : Started AffinitiHnbf360EsSvApplication in 3.958 seconds (JVM running for 4.623)
2022-10-14 23:07:00.001  INFO 1 --- [   scheduling-1] c.a.a.h.c.ApplicationConfiguration       : Court Case escalation process started
2022-10-14 23:07:00.478  INFO 1 --- [   scheduling-1] c.a.a.h.s.t.TicketEscalationServiceImpl  : SV Batch ID : 1665769662000
2022-10-14 23:07:00.508  INFO 1 --- [   scheduling-1] c.a.a.h.s.t.TicketEscalationServiceImpl  : SLA Configuration count [ 4 ]
2022-10-14 23:07:00.517  INFO 1 --- [   scheduling-1] c.a.a.h.s.t.TicketEscalationServiceImpl  : SLA Configured status count [ 1 ] for SLA Config Id [ 1 ]
2022-10-14 23:07:00.533  INFO 1 --- [   scheduling-1] c.a.a.h.s.t.TicketEscalationServiceImpl  : SLA eligible case count [ 33 ] for SLA Config Id [ 1 ]
2022-10-14 23:07:00.553 ERROR 1 --- [   scheduling-1] c.a.a.h.s.t.TicketEscalationServiceImpl  : Failed to convert property value of type 'null' to required type 'int' for property 'notificationlevel'; nested exception is org.springframework.core.convert.ConversionFailedException: Failed to convert from type [null] to type [int] for value 'null'; nested exception is java.lang.IllegalArgumentException: A null value cannot be assigned to a primitive type

org.springframework.beans.TypeMismatchException: Failed to convert property value of type 'null' to required type 'int' for property 'notificationlevel'; nested exception is org.springframework.core.convert.ConversionFailedException: Failed to convert from type [null] to type [int] for value 'null'; nested exception is java.lang.IllegalArgumentException: A null value cannot be assigned to a primitive type
        at org.springframework.beans.AbstractNestablePropertyAccessor.convertIfNecessary(AbstractNestablePropertyAccessor.java:600) ~[spring-beans-5.3.10.jar!/:5.3.10]
        at org.springframework.beans.AbstractNestablePropertyAccessor.convertForProperty(AbstractNestablePropertyAccessor.java:609) ~[spring-beans-5.3.10.jar!/:5.3.10]
        at org.springframework.beans.AbstractNestablePropertyAccessor.processLocalProperty(AbstractNestablePropertyAccessor.java:458) ~[spring-beans-5.3.10.jar!/:5.3.10]
        at org.springframework.beans.AbstractNestablePropertyAccessor.setPropertyValue(AbstractNestablePropertyAccessor.java:278) ~[spring-beans-5.3.10.jar!/:5.3.10]
        at org.springframework.beans.AbstractNestablePropertyAccessor.setPropertyValue(AbstractNestablePropertyAccessor.java:246) ~[spring-beans-5.3.10.jar!/:5.3.10]
        at org.springframework.jdbc.core.BeanPropertyRowMapper.mapRow(BeanPropertyRowMapper.java:318) ~[spring-jdbc-5.3.10.jar!/:5.3.10]
        at org.springframework.jdbc.core.RowMapperResultSetExtractor.extractData(RowMapperResultSetExtractor.java:94) ~[spring-jdbc-5.3.10.jar!/:5.3.10]
        at org.springframework.jdbc.core.RowMapperResultSetExtractor.extractData(RowMapperResultSetExtractor.java:61) ~[spring-jdbc-5.3.10.jar!/:5.3.10]
        at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:723) ~[spring-jdbc-5.3.10.jar!/:5.3.10]
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:651) ~[spring-jdbc-5.3.10.jar!/:5.3.10]
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:713) ~[spring-jdbc-5.3.10.jar!/:5.3.10]
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:744) ~[spring-jdbc-5.3.10.jar!/:5.3.10]
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:757) ~[spring-jdbc-5.3.10.jar!/:5.3.10]
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:810) ~[spring-jdbc-5.3.10.jar!/:5.3.10]
        at com.avn.affiniti.hnbf360essv.dao.ticket.TicketDAOImpl.getTicketTicketBySLA(TicketDAOImpl.java:192) ~[classes!/:V1.00.05]
        at com.avn.affiniti.hnbf360essv.dao.ticket.TicketDAOImpl$$FastClassBySpringCGLIB$$5fbb478e.invoke(<generated>) ~[classes!/:V1.00.05]
        at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.3.10.jar!/:5.3.10]
        at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:779) ~[spring-aop-5.3.10.jar!/:5.3.10]
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.3.10.jar!/:5.3.10]
        at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750) ~[spring-aop-5.3.10.jar!/:5.3.10]
        at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137) ~[spring-tx-5.3.10.jar!/:5.3.10]
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.3.10.jar!/:5.3.10]
        at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750) ~[spring-aop-5.3.10.jar!/:5.3.10]
        at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:692) ~[spring-aop-5.3.10.jar!/:5.3.10]
        at com.avn.affiniti.hnbf360essv.dao.ticket.TicketDAOImpl$$EnhancerBySpringCGLIB$$bbf9f111.getTicketTicketBySLA(<generated>) ~[classes!/:V1.00.05]
        at com.avn.affiniti.hnbf360essv.service.ticketescalation.TicketEscalationServiceImpl.startGenericEscalation(TicketEscalationServiceImpl.java:104) ~[classes!/:V1.00.05]
        at com.avn.affiniti.hnbf360essv.configuration.ApplicationConfiguration.cronJob(ApplicationConfiguration.java:105) ~[classes!/:V1.00.05]
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na]
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:na]
        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:na]
        at java.base/java.lang.reflect.Method.invoke(Method.java:566) ~[na:na]
        at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84) ~[spring-context-5.3.10.jar!/:5.3.10]
        at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) ~[spring-context-5.3.10.jar!/:5.3.10]
        at org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:95) ~[spring-context-5.3.10.jar!/:5.3.10]
        at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) ~[na:na]
        at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) ~[na:na]
        at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:304) ~[na:na]
        at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) ~[na:na]
        at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) ~[na:na]
        at java.base/java.lang.Thread.run(Thread.java:829) ~[na:na]
Caused by: org.springframework.core.convert.ConversionFailedException: Failed to convert from type [null] to type [int] for value 'null'; nested exception is java.lang.IllegalArgumentException: A null value cannot be assigned to a primitive type
        at org.springframework.core.convert.support.GenericConversionService.assertNotPrimitiveTargetType(GenericConversionService.java:335) ~[spring-core-5.3.10.jar!/:5.3.10]
        at org.springframework.core.convert.support.GenericConversionService.handleResult(GenericConversionService.java:328) ~[spring-core-5.3.10.jar!/:5.3.10]
        at org.springframework.core.convert.support.GenericConversionService.convert(GenericConversionService.java:184) ~[spring-core-5.3.10.jar!/:5.3.10]
        at org.springframework.beans.TypeConverterDelegate.convertIfNecessary(TypeConverterDelegate.java:243) ~[spring-beans-5.3.10.jar!/:5.3.10]
        at org.springframework.beans.AbstractNestablePropertyAccessor.convertIfNecessary(AbstractNestablePropertyAccessor.java:590) ~[spring-beans-5.3.10.jar!/:5.3.10]
        ... 39 common frames omitted
Caused by: java.lang.IllegalArgumentException: A null value cannot be assigned to a primitive type
        ... 44 common frames omitted

s