PRODUCT IOTS » product-uem 6.4.0 GA

Environment details
6.3.0 staging server

Prerequisites
None

Steps
Go to App Publisher
Add new Public App
Select Windows device type
Search for a Microsoft Store app and open it in another tab eg: Minecraft Education
Click Add release after entering remaining details
Select URL for the icon and screenshots. eg: copy the same icon and screenshots from the Microsoft store [1]:

• Icon - https://store-images.s-microsoft.com/image/apps.61383.13510798887411471.a0eac7f3-ab13-4987-8bac-ceab380e131f.cc7c863a-63fc-43c5-9ea7-b69cd41c0651?h=210
• Screenshot 1 - https://store-images.s-microsoft.com/image/apps.16094.13510798887411471.4bf11ed9-fed0-462c-ae72-2d2ced15fc99.d8e5486b-a34e-4369-b029-cdb445f66365?h=253
• Screenshot 2 - https://store-images.s-microsoft.com/image/apps.47366.13510798887411471.4bf11ed9-fed0-462c-ae72-2d2ced15fc99.9b9763b3-ef8b-4ceb-b833-dba6be1a0254?h=253
• Screenshot 3 - https://store-images.s-microsoft.com/image/apps.37159.13510798887411471.4bf11ed9-fed0-462c-ae72-2d2ced15fc99.b79dc5e7-4359-440f-b54c-e6512422953c?h=253

After pasting the URLs click continue to add the app release

Description
Cannot add screenshot URLs taken from Microsoft Store [2]
Error log is attached [3]

Result
[1] -
[2] -
[3] -

TID: [2] [api/application-mgt-publisher/v1.0] [2025-02-07 10:25:14,316] ERROR {io.entgra.proprietary.commons.extension.application.mgt.publisher.api.impl.ApplicationManagementPublisherAPIImpl} - Error occurred while creating the public app. io.entgra.device.mgt.core.application.mgt.common.exception.ApplicationManagementException: Error occurred while adding application with the name Minecraft Education to database
        at io.entgra.device.mgt.core.application.mgt.core.impl.ApplicationManagerImpl.triggerApplicationCreation(ApplicationManagerImpl.java:222)
        at io.entgra.device.mgt.core.application.mgt.core.impl.ApplicationManagerImpl.createApplicationBasedOnRemoteStatus(ApplicationManagerImpl.java:190)
        at io.entgra.device.mgt.core.application.mgt.core.impl.ApplicationManagerImpl.createApplication(ApplicationManagerImpl.java:152)
        at io.entgra.proprietary.commons.extension.application.mgt.publisher.api.impl.ApplicationManagementPublisherAPIImpl.createApplication(ApplicationManagementPublisherAPIImpl.java:903)
        at io.entgra.proprietary.commons.extension.application.mgt.publisher.api.impl.ApplicationManagementPublisherAPIImpl.createPubApp(ApplicationManagementPublisherAPIImpl.java:226)
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.base/java.lang.reflect.Method.invoke(Method.java:566)
        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.doPost(AbstractHTTPServlet.java:217)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:555)
        at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:279)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
        at io.entgra.proprietary.commons.extension.application.mgt.addons.ApiOriginFilter.doFilter(ApiOriginFilter.java:38)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
        at org.wso2.carbon.ui.filters.cache.ContentTypeBasedCachePreventionFilter.doFilter(ContentTypeBasedCachePreventionFilter.java:53)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
        at org.apache.catalina.filters.HttpHeaderSecurityFilter.doFilter(HttpHeaderSecurityFilter.java:129)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:596)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
        at org.wso2.carbon.identity.context.rewrite.valve.TenantContextRewriteValve.invoke(TenantContextRewriteValve.java:119)
        at org.wso2.carbon.identity.context.rewrite.valve.OrganizationContextRewriteValve.invoke(OrganizationContextRewriteValve.java:116)
        at org.wso2.carbon.tomcat.ext.valves.SameSiteCookieValve.invoke(SameSiteCookieValve.java:38)
        at org.wso2.carbon.identity.authz.valve.AuthorizationValve.invoke(AuthorizationValve.java:165)
        at org.wso2.carbon.identity.auth.valve.AuthenticationValve.invoke(AuthenticationValve.java:118)
        at org.wso2.carbon.tomcat.ext.valves.CompositeValve.continueInvocation(CompositeValve.java:106)
        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:311)
        at io.entgra.device.mgt.core.webapp.authenticator.framework.WebappAuthenticationValve.invoke(WebappAuthenticationValve.java:188)
        at org.wso2.carbon.tomcat.ext.valves.TomcatValveContainer.invokeValves(TomcatValveContainer.java:47)
        at org.wso2.carbon.tomcat.ext.valves.CompositeValve.invoke(CompositeValve.java:67)
        at org.wso2.carbon.tomcat.ext.valves.CarbonStuckThreadDetectionValve.invoke(CarbonStuckThreadDetectionValve.java:152)
        at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:670)
        at org.wso2.carbon.tomcat.ext.valves.CarbonContextCreatorValve.invoke(CarbonContextCreatorValve.java:63)
        at org.wso2.carbon.tomcat.ext.valves.RequestCorrelationIdValve.invoke(RequestCorrelationIdValve.java:137)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
        at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:390)
        at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
        at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:928)
        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1794)
        at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
        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.base/java.lang.Thread.run(Thread.java:834)
Caused by: io.entgra.device.mgt.core.application.mgt.common.exception.ApplicationManagementException: Error occurred while adding application or application release. application name: Minecraft Education.
        at io.entgra.device.mgt.core.application.mgt.core.impl.ApplicationManagerImpl.addAppDataIntoDB(ApplicationManagerImpl.java:1502)
        at io.entgra.device.mgt.core.application.mgt.core.impl.ApplicationManagerImpl.triggerApplicationCreation(ApplicationManagerImpl.java:204)
        ... 70 more
Caused by: io.entgra.device.mgt.core.application.mgt.core.exception.ApplicationManagementDAOException: SQL Exception while trying to release an application by executing the query INSERT INTO AP_APP_RELEASE (DESCRIPTION,VERSION,TENANT_ID,UUID,RELEASE_TYPE,PACKAGE_NAME,APP_PRICE, INSTALLER_LOCATION,ICON_LOCATION,BANNER_LOCATION,SC_1_LOCATION,SC_2_LOCATION,SC_3_LOCATION,APP_HASH_VALUE,SHARED_WITH_ALL_TENANTS,APP_META_INFO,SUPPORTED_OS_VERSIONS,CURRENT_STATE,AP_APP_ID) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
        at io.entgra.device.mgt.core.application.mgt.core.dao.impl.application.release.GenericApplicationReleaseDAOImpl.createRelease(GenericApplicationReleaseDAOImpl.java:107)
        at io.entgra.device.mgt.core.application.mgt.core.impl.ApplicationManagerImpl.addAppDataIntoDB(ApplicationManagerImpl.java:1473)
        ... 71 more
Caused by: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Data too long for column 'SC_1_LOCATION' at row 1
        at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:104)
        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 jdk.internal.reflect.GeneratedMethodAccessor262.invoke(Unknown Source)
        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.base/java.lang.reflect.Method.invoke(Method.java:566)
        at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:118)
        at com.sun.proxy.$Proxy53.executeUpdate(Unknown Source)
        at io.entgra.device.mgt.core.application.mgt.core.dao.impl.application.release.GenericApplicationReleaseDAOImpl.createRelease(GenericApplicationReleaseDAOImpl.java:91)
        ... 72 more