Bug #10499: Cannot update Android Enterprise Managed configuration - Backlog - Entgra.io

Bug #10499

Updated by Arshana Atapattu 11 months ago

*Environment details* 
 6.0.0 server 


 *Prerequisites* 
 Android Enterprise App 


 *Steps* 
 create a profile in managed configurations. 
 then try to update the managed configurations in same app 


 *Description* 
 Issue 1: 
 Cannot update Android Enterprise Managed configuration. 
 when tried to update it throws error. 
 Error log [1]. 

 Issue 2: 
 Whenever a Managed configurations profile [2] was deleted and again try add a another managed configuration it shows error [3]. 
 There was no front end or back end error. 

 *Result* 

 [1] 
 TID: [-1234] [api/device-mgt/android/v1.0] [2024-01-08 10:30:53,820] ERROR {io.entgra.proprietary.uem.platform.android.core.dao.impl.EnterpriseDAOImpl} - Error occurred while modifying the details for    mcm id '07395944881811849666' data. java.sql.SQLIntegrityConstraintViolationException: Column 'LAST_UPDATED_TIMESTAMP' cannot be null 
	 at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:117) 
	 at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) 
	 at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) 
	 at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953) 
	 at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1092) 
	 at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1040) 
	 at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1347) 
	 at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1025) 
	 at sun.reflect.GeneratedMethodAccessor68.invoke(Unknown Source) 
	 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 
	 at java.lang.reflect.Method.invoke(Method.java:498) 
	 at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114) 
	 at com.sun.proxy.$Proxy49.executeUpdate(Unknown Source) 
	 at io.entgra.proprietary.uem.platform.android.core.dao.impl.EnterpriseDAOImpl.updateConfig(EnterpriseDAOImpl.java:244) 
	 at io.entgra.proprietary.uem.platform.android.core.impl.AndroidGoogleEnterpriseServiceImpl.updateMobileDevice(AndroidGoogleEnterpriseServiceImpl.java:170) 
	 at io.entgra.proprietary.uem.platform.android.api.AndroidEnterpriseAPIImpl.updateManagedConfigs(AndroidEnterpriseAPIImpl.java:863) 
	 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
	 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 
	 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 
	 at java.lang.reflect.Method.invoke(Method.java:498) 
	 at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:179) 
	 at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:96) 
	 at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:201) 
	 at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:104) 
	 at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:59) 
	 at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:96) 
	 at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:307) 
	 at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121) 
	 at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:265) 
	 at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:234) 
	 at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:208) 
	 at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:160) 
	 at org.apache.cxf.transport.servlet.CXFNonSpringServlet.invoke(CXFNonSpringServlet.java:225) 
	 at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:304) 
	 at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPut(AbstractHTTPServlet.java:234) 
	 at javax.servlet.http.HttpServlet.service(HttpServlet.java:684) 
	 at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:279) 
	 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) 
	 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) 
	 at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) 
	 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) 
	 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) 
	 at io.entgra.proprietary.uem.platform.android.addons.ApiOriginFilter.doFilter(ApiOriginFilter.java:38) 
	 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) 
	 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) 
	 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) 
	 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) 
	 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542) 
	 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) 
	 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) 
	 at org.wso2.carbon.identity.context.rewrite.valve.TenantContextRewriteValve.invoke(TenantContextRewriteValve.java:107) 
	 at org.wso2.carbon.identity.authz.valve.AuthorizationValve.invoke(AuthorizationValve.java:110) 
	 at org.wso2.carbon.identity.auth.valve.AuthenticationValve.invoke(AuthenticationValve.java:105) 
	 at org.wso2.carbon.tomcat.ext.valves.CompositeValve.continueInvocation(CompositeValve.java:101) 
	 at org.wso2.carbon.tomcat.ext.valves.CarbonTomcatValve$1.invoke(CarbonTomcatValve.java:47) 
	 at io.entgra.device.mgt.core.webapp.authenticator.framework.WebappAuthenticationValve.processRequest(WebappAuthenticationValve.java:301) 
	 at io.entgra.device.mgt.core.webapp.authenticator.framework.WebappAuthenticationValve.invoke(WebappAuthenticationValve.java:178) 
	 at org.wso2.carbon.tomcat.ext.valves.TomcatValveContainer.invokeValves(TomcatValveContainer.java:47) 
	 at org.wso2.carbon.tomcat.ext.valves.CompositeValve.invoke(CompositeValve.java:62) 
	 at org.wso2.carbon.tomcat.ext.valves.CarbonStuckThreadDetectionValve.invoke(CarbonStuckThreadDetectionValve.java:145) 
	 at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:687) 
	 at org.wso2.carbon.tomcat.ext.valves.CarbonContextCreatorValve.invoke(CarbonContextCreatorValve.java:59) 
	 at org.wso2.carbon.tomcat.ext.valves.RequestCorrelationIdValve.invoke(RequestCorrelationIdValve.java:126) 
	 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) 
	 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) 
	 at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:382) 
	 at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) 
	 at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:893) 
	 at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1726) 
	 at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) 
	 at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) 
	 at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) 
	 at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) 
	 at java.lang.Thread.run(Thread.java:748) 

 TID: [-1234] [api/device-mgt/android/v1.0] [2024-01-08 10:30:53,833] ERROR {io.entgra.proprietary.uem.platform.android.core.impl.AndroidGoogleEnterpriseServiceImpl} - Error occurred while updating managed configs for mcm id 07395944881811849666 io.entgra.proprietary.uem.platform.android.common.exception.EnterpriseManagementDAOException: Error occurred while modifying the details for    mcm id '07395944881811849666' data. 
	 at io.entgra.proprietary.uem.platform.android.core.dao.impl.EnterpriseDAOImpl.updateConfig(EnterpriseDAOImpl.java:256) 
	 at io.entgra.proprietary.uem.platform.android.core.impl.AndroidGoogleEnterpriseServiceImpl.updateMobileDevice(AndroidGoogleEnterpriseServiceImpl.java:170) 
	 at io.entgra.proprietary.uem.platform.android.api.AndroidEnterpriseAPIImpl.updateManagedConfigs(AndroidEnterpriseAPIImpl.java:863) 
	 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
	 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 
	 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 
	 at java.lang.reflect.Method.invoke(Method.java:498) 
	 at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:179) 
	 at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:96) 
	 at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:201) 
	 at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:104) 
	 at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:59) 
	 at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:96) 
	 at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:307) 
	 at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121) 
	 at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:265) 
	 at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:234) 
	 at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:208) 
	 at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:160) 
	 at org.apache.cxf.transport.servlet.CXFNonSpringServlet.invoke(CXFNonSpringServlet.java:225) 
	 at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:304) 
	 at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPut(AbstractHTTPServlet.java:234) 
	 at javax.servlet.http.HttpServlet.service(HttpServlet.java:684) 
	 at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:279) 
	 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) 
	 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) 
	 at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) 
	 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) 
	 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) 
	 at io.entgra.proprietary.uem.platform.android.addons.ApiOriginFilter.doFilter(ApiOriginFilter.java:38) 
	 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) 
	 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) 
	 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) 
	 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) 
	 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542) 
	 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) 
	 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) 
	 at org.wso2.carbon.identity.context.rewrite.valve.TenantContextRewriteValve.invoke(TenantContextRewriteValve.java:107) 
	 at org.wso2.carbon.identity.authz.valve.AuthorizationValve.invoke(AuthorizationValve.java:110) 
	 at org.wso2.carbon.identity.auth.valve.AuthenticationValve.invoke(AuthenticationValve.java:105) 
	 at org.wso2.carbon.tomcat.ext.valves.CompositeValve.continueInvocation(CompositeValve.java:101) 
	 at org.wso2.carbon.tomcat.ext.valves.CarbonTomcatValve$1.invoke(CarbonTomcatValve.java:47) 
	 at io.entgra.device.mgt.core.webapp.authenticator.framework.WebappAuthenticationValve.processRequest(WebappAuthenticationValve.java:301) 
	 at io.entgra.device.mgt.core.webapp.authenticator.framework.WebappAuthenticationValve.invoke(WebappAuthenticationValve.java:178) 
	 at org.wso2.carbon.tomcat.ext.valves.TomcatValveContainer.invokeValves(TomcatValveContainer.java:47) 
	 at org.wso2.carbon.tomcat.ext.valves.CompositeValve.invoke(CompositeValve.java:62) 
	 at org.wso2.carbon.tomcat.ext.valves.CarbonStuckThreadDetectionValve.invoke(CarbonStuckThreadDetectionValve.java:145) 
	 at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:687) 
	 at org.wso2.carbon.tomcat.ext.valves.CarbonContextCreatorValve.invoke(CarbonContextCreatorValve.java:59) 
	 at org.wso2.carbon.tomcat.ext.valves.RequestCorrelationIdValve.invoke(RequestCorrelationIdValve.java:126) 
	 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) 
	 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) 
	 at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:382) 
	 at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) 
	 at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:893) 
	 at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1726) 
	 at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) 
	 at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) 
	 at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) 
	 at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) 
	 at java.lang.Thread.run(Thread.java:748) 
 Caused by: java.sql.SQLIntegrityConstraintViolationException: Column 'LAST_UPDATED_TIMESTAMP' cannot be null 
	 at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:117) 
	 at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) 
	 at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) 
	 at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953) 
	 at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1092) 
	 at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1040) 
	 at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1347) 
	 at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1025) 
	 at sun.reflect.GeneratedMethodAccessor68.invoke(Unknown Source) 
	 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 
	 at java.lang.reflect.Method.invoke(Method.java:498) 
	 at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114) 
	 at com.sun.proxy.$Proxy49.executeUpdate(Unknown Source) 
	 at io.entgra.proprietary.uem.platform.android.core.dao.impl.EnterpriseDAOImpl.updateConfig(EnterpriseDAOImpl.java:244) 
	 ... 60 more 

 TID: [-1234] [publisher-ui-request-handler] [2024-01-08 10:30:53,843] ERROR {io.entgra.device.mgt.core.ui.request.interceptor.util.HandlerUtil} - Received 500 response for http request : PUT https://uem.gw.entgra.net:443/api/device-mgt/android/v1.0/enterprise/managed-configs. Error message: {"message":"Error when saving configs","errorItems":[]} 
 TID: [-1234] [publisher-ui-request-handler] [2024-01-08 10:30:53,843] ERROR {io.entgra.device.mgt.core.ui.request.interceptor.InvokerHandler} - Error occurred while invoking the PUT API endpoint. 


 [2] 
 !Screenshot%20from%202024-01-08%2018-21-40.png! 

 [3] 
 !Screenshot%20from%202024-01-08%2018-19-23.png!

Back

Project

General

Profile

PRODUCT IOTS » Backlog

Bug #10499