Project

General

Profile

Actions
Copy link

Bug #10020

closed

Table "DM_ENROLMENT" not found error when enrolling 1000 devices

Added by Arshana Atapattu about 1 year ago. Updated 14 days ago.

Status:
Closed
Priority:
None
Assignee:
Pramila Niroshan
Start date:
03/22/2023
Due date:
% Done:

0%

Estimated time:
Device Type:
Component:
Type:

Description

Environment details
510 server
JMeter 5.5

Prerequisites
JMeter scripts1

Steps
start the server.
Once the server start run the JMeter script(If for super tenant, use super tenant reqs). Please note that in 510, to generate a token for a sub tenant you have to log into that sub tenant.

For load testing it is recommended to use CLI mode rather than GUI.
for generating reports you can use this command, execute it from where the jmeter bin folder.
jmeter -n -t "location of test file(.jmx)" -l "location of your result file" -e -o "location of reports folder"

Ex: sh jmeter -n -t /home/arshana/QA-scripts/Policy-test-case/01-Adding_devices.jmx -l "/home/arshana/Desktop/JMeter_reports/Reports/4_Adding_Devices/4_Adding_Devices.csv" -e -o /home/arshana/Desktop/JMeter_reports/Reports/4_Adding_Devices

The error2 is attached here.

Description
When enrolling 1000 devices it fails to enroll devices after some point. This happened with super tenant and sub-tenants.
This pattern3 was observed in both super and sub tenants.
the html report4 for this test is attached here.

[3]
[3]

Files

Download all files
01-Adding_devices.jmx (57.9 KB) 01-Adding_devices.jmx [1] Arshana Atapattu, 03/22/2023 12:42 PM
device enroll issue (10.3 KB) device enroll issue [2] Arshana Atapattu, 03/22/2023 12:42 PM
Screenshot from 2023-03-22 18-27-21.png (120 KB) Screenshot from 2023-03-22 18-27-21.png [3] Arshana Atapattu, 03/22/2023 12:57 PM
4_Adding_Devices.zip (1.07 MB) 4_Adding_Devices.zip [4] Arshana Atapattu, 03/22/2023 12:58 PM
device enroll issue_2 (9.2 KB) device enroll issue_2 [5] Arshana Atapattu, 03/22/2023 01:14 PM
Screenshot from 2023-08-14 19-23-58.png (238 KB) Screenshot from 2023-08-14 19-23-58.png [8] Arshana Atapattu, 08/15/2023 01:19 PM
Actions
Copy link
 #1

Updated by Arshana Atapattu about 1 year ago

After running this test again, was able to enroll 997 devices on super tenant. but it gave a little different error [5] this time.
Updating the ticket with the new error.

Actions
Copy link
 #2

Updated by Arshana Atapattu about 1 year ago

Tested on 5.2.4.2 SNAPSHOT
Without licensing, it enrolls 1000 devices. but sometimes it throws this error on some devices.

Error :
ERROR - DeviceTypePluginDAOImpl Error occurred while fetching device : '000-000-304' from AD_DEVICE
org.h2.jdbc.JdbcSQLTimeoutException: Timeout trying to lock table "AD_DEVICE"; SQL statement:
SELECT FCM_TOKEN, DEVICE_INFO, IMEI, IMSI, OS_VERSION, DEVICE_MODEL, VENDOR, LATITUDE, LONGITUDE, SERIAL, MAC_ADDRESS, DEVICE_NAME, OS_BUILD_DATE FROM AD_DEVICE WHERE DEVICE_ID = ? [50200-200]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:511) ~[h2_1.4.200.wso2v1.jar:?]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:429) ~[h2_1.4.200.wso2v1.jar:?]
at org.h2.message.DbException.get(DbException.java:205) ~[h2_1.4.200.wso2v1.jar:?]
at org.h2.message.DbException.get(DbException.java:181) ~[h2_1.4.200.wso2v1.jar:?]
at org.h2.pagestore.db.PageStoreTable.doLock1(PageStoreTable.java:375) ~[h2_1.4.200.wso2v1.jar:?]
at org.h2.pagestore.db.PageStoreTable.lock(PageStoreTable.java:338) ~[h2_1.4.200.wso2v1.jar:?]
at org.h2.table.TableFilter.lock(TableFilter.java:207) ~[h2_1.4.200.wso2v1.jar:?]
at org.h2.command.dml.Select.queryWithoutCache(Select.java:819) ~[h2_1.4.200.wso2v1.jar:?]
at org.h2.command.dml.Query.queryWithoutCacheLazyCheck(Query.java:201) ~[h2_1.4.200.wso2v1.jar:?]
at org.h2.command.dml.Query.query(Query.java:489) ~[h2_1.4.200.wso2v1.jar:?]
at org.h2.command.dml.Query.query(Query.java:451) ~[h2_1.4.200.wso2v1.jar:?]
at org.h2.command.CommandContainer.query(CommandContainer.java:285) ~[h2_1.4.200.wso2v1.jar:?]
at org.h2.command.Command.executeQuery(Command.java:195) ~[h2_1.4.200.wso2v1.jar:?]
at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:114) ~[h2_1.4.200.wso2v1.jar:?]
at sun.reflect.GeneratedMethodAccessor61.invoke(Unknown Source) ~[?:?]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_202]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_202]
at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114) ~[jdbc-pool_9.0.35.wso2v1.jar:?]
at com.sun.proxy.$Proxy50.executeQuery(Unknown Source) ~[?:?]
at org.wso2.carbon.device.mgt.extensions.device.type.template.dao.DeviceTypePluginDAOImpl.getDevice(DeviceTypePluginDAOImpl.java:84) [org.wso2.carbon.device.mgt.extensions_5.0.25.jar:?]
at org.wso2.carbon.device.mgt.extensions.device.type.template.DeviceTypeManager.isEnrolled(DeviceTypeManager.java:436) [org.wso2.carbon.device.mgt.extensions_5.0.25.jar:?]
at org.wso2.carbon.device.mgt.extensions.device.type.template.DeviceTypeManager.enrollDevice(DeviceTypeManager.java:328) [org.wso2.carbon.device.mgt.extensions_5.0.25.jar:?]
at org.wso2.carbon.device.mgt.core.service.DeviceManagementProviderServiceImpl.enrollDevice(DeviceManagementProviderServiceImpl.java:386) [org.wso2.carbon.device.mgt.core_5.0.25.jar:?]
at io.entgra.proprietary.platform.android.core.impl.AndroidServiceImpl.enrollDevice(AndroidServiceImpl.java:1480) [io.entgra.proprietary.platform.android.core_5.0.26.1.jar:?]
at io.entgra.proprietary.platform.android.api.service.impl.DeviceManagementAPIImpl.enrollDevice(DeviceManagementAPIImpl.java:245) [classes/:?]
at sun.reflect.GeneratedMethodAccessor669.invoke(Unknown Source) ~[?:?]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_202]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_202]
at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:179) [cxf-core-3.5.0.jar:3.5.0]
at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:96) [cxf-core-3.5.0.jar:3.5.0]
at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:201) [cxf-rt-frontend-jaxrs-3.5.0.jar:3.5.0]
at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:104) [cxf-rt-frontend-jaxrs-3.5.0.jar:3.5.0]
at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:59) [cxf-core-3.5.0.jar:3.5.0]
at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:96) [cxf-core-3.5.0.jar:3.5.0]
at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:307) [cxf-core-3.5.0.jar:3.5.0]
at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121) [cxf-core-3.5.0.jar:3.5.0]
at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:265) [cxf-rt-transports-http-3.5.0.jar:3.5.0]
at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:234) [cxf-rt-transports-http-3.5.0.jar:3.5.0]
at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:208) [cxf-rt-transports-http-3.5.0.jar:3.5.0]
at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:160) [cxf-rt-transports-http-3.5.0.jar:3.5.0]
at org.apache.cxf.transport.servlet.CXFNonSpringServlet.invoke(CXFNonSpringServlet.java:225) [cxf-rt-transports-http-3.5.0.jar:3.5.0]
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:304) [cxf-rt-transports-http-3.5.0.jar:3.5.0]
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPost(AbstractHTTPServlet.java:217) [cxf-rt-transports-http-3.5.0.jar:3.5.0]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:681) [tomcat-servlet-api_9.0.52.wso2v1.jar:?]
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:279) [cxf-rt-transports-http-3.5.0.jar:3.5.0]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) [tomcat_9.0.52.wso2v2.jar:?]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [tomcat_9.0.52.wso2v2.jar:?]
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) [tomcat_9.0.52.wso2v2.jar:?]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) [tomcat_9.0.52.wso2v2.jar:?]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [tomcat_9.0.52.wso2v2.jar:?]
at io.entgra.proprietary.platform.android.addons.ApiOriginFilter.doFilter(ApiOriginFilter.java:42) [io.entgra.proprietary.platform.android.addons-5.0.26.1.jar:?]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) [tomcat_9.0.52.wso2v2.jar:?]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [tomcat_9.0.52.wso2v2.jar:?]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) [tomcat_9.0.52.wso2v2.jar:?]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) [tomcat_9.0.52.wso2v2.jar:?]
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542) [tomcat_9.0.52.wso2v2.jar:?]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) [tomcat_9.0.52.wso2v2.jar:?]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat_9.0.52.wso2v2.jar:?]
at org.wso2.carbon.identity.context.rewrite.valve.TenantContextRewriteValve.invoke(TenantContextRewriteValve.java:107) [org.wso2.carbon.identity.context.rewrite.valve_1.4.25.jar:?]
at org.wso2.carbon.identity.authz.valve.AuthorizationValve.invoke(AuthorizationValve.java:110) [org.wso2.carbon.identity.authz.valve_1.4.25.jar:?]
at org.wso2.carbon.identity.auth.valve.AuthenticationValve.invoke(AuthenticationValve.java:105) [org.wso2.carbon.identity.auth.valve_1.4.25.14.jar:?]
at org.wso2.carbon.tomcat.ext.valves.CompositeValve.continueInvocation(CompositeValve.java:101) [org.wso2.carbon.tomcat.ext_4.6.2.168.jar:?]
at org.wso2.carbon.tomcat.ext.valves.CarbonTomcatValve$1.invoke(CarbonTomcatValve.java:47) [org.wso2.carbon.tomcat.ext_4.6.2.168.jar:?]
at org.wso2.carbon.webapp.authenticator.framework.WebappAuthenticationValve.processRequest(WebappAuthenticationValve.java:302) [org.wso2.carbon.webapp.authenticator.framework_5.0.25.jar:?]
at org.wso2.carbon.webapp.authenticator.framework.WebappAuthenticationValve.invoke(WebappAuthenticationValve.java:179) [org.wso2.carbon.webapp.authenticator.framework_5.0.25.jar:?]
at org.wso2.carbon.tomcat.ext.valves.TomcatValveContainer.invokeValves(TomcatValveContainer.java:47) [org.wso2.carbon.tomcat.ext_4.6.2.168.jar:?]
at org.wso2.carbon.tomcat.ext.valves.CompositeValve.invoke(CompositeValve.java:62) [org.wso2.carbon.tomcat.ext_4.6.2.168.jar:?]
at org.wso2.carbon.tomcat.ext.valves.CarbonStuckThreadDetectionValve.invoke(CarbonStuckThreadDetectionValve.java:145) [org.wso2.carbon.tomcat.ext_4.6.2.168.jar:?]
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:687) [tomcat_9.0.52.wso2v2.jar:?]
at org.wso2.carbon.tomcat.ext.valves.CarbonContextCreatorValve.invoke(CarbonContextCreatorValve.java:59) [org.wso2.carbon.tomcat.ext_4.6.2.168.jar:?]
at org.wso2.carbon.tomcat.ext.valves.RequestCorrelationIdValve.invoke(RequestCorrelationIdValve.java:126) [org.wso2.carbon.tomcat.ext_4.6.2.168.jar:?]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) [tomcat_9.0.52.wso2v2.jar:?]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) [tomcat_9.0.52.wso2v2.jar:?]
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:382) [tomcat_9.0.52.wso2v2.jar:?]
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat_9.0.52.wso2v2.jar:?]
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:893) [tomcat_9.0.52.wso2v2.jar:?]
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1726) [tomcat_9.0.52.wso2v2.jar:?]
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat_9.0.52.wso2v2.jar:?]
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) [tomcat_9.0.52.wso2v2.jar:?]
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) [tomcat_9.0.52.wso2v2.jar:?]
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat_9.0.52.wso2v2.jar:?]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_202]

Actions
Copy link
 #3

Updated by Viranga Gunarathna 12 months ago

  • Project changed from product-uem 5.3.0 GA to 32
  • Category deleted (Backend)
Actions
Copy link
 #4

Updated by Viranga Gunarathna 12 months ago

  • Project changed from 32 to 33
Actions
Copy link
 #5

Updated by Arshana Atapattu 9 months ago

Server was setup against mysql db and used only DM_DB.

when tried to enroll 1000 devices, process was failed due to "[2023-08-14 17:45:15,788] ERROR - AndroidServiceImpl Maximum device count is enrolled for your license. Therefore you are not allowed to enroll more devices until you upgrade the license."

This was tried on another device. Got the same outcome.

Error on carbon console [6]
some other errors came with log [6] and [7]
codes pattern during test [8]

Full error log can get ffrom here -> https://drive.google.com/file/d/1e-zSvsZo5W8NOdqGnhjS9solMnSzBRQZ/view?usp=drive_link

[6]
[2023-08-14 18:51:38,174] INFO - 256 Unpublished violations detected
[2023-08-14 18:51:38,174] INFO - 256 Unpublished violations detected
[2023-08-14 18:51:38,175] INFO - 256 Violation Payload : {"messages":[{"data":"eyJ1dWlkIjoiZTcxNWRkZDQtZTVhYy01ZTExLThhZjYtZDNhYjM1ZjM1M2IwIiwidmlvbGF0aW9ucyI6W3sidmlvbGF0aW9uVHlwZSI6IlJFQUNIRURfREVWSUNFX0NPVU5UIiwibWVzc2FnZSI6IkxpY2Vuc2luZyBleHBpcmVkIGR1ZSB0byBSRUFDSEVEX0RFVklDRV9DT1VOVCIsImRldGVjdGVkVGltZXN0YW1wIjoxNjkyMDE5Mjk4MTc0fSx7InZpb2xhdGlvblR5cGUiOiJDSEFOR0VfSEFSRFdBUkVfSUQiLCJtZXNzYWdlIjoiRGV0ZWN0ZWQgZnJhdWQuIFZpb2xhdGVkIGxpY2Vuc2luZyBjcml0ZXJpYSBDSEFOR0VfSEFSRFdBUkVfSUQiLCJkZXRlY3RlZFRpbWVzdGFtcCI6MTY5MjAxOTI5ODE3NH1dfQ\u003d\u003d"}]}
[2023-08-14 18:51:38,725] INFO - 256 Violation messages published {
  "messageIds": [
    "8086888382914485"
  ]
}

[7]
[2023-08-14 18:50:44,051] INFO - 46 Heartbeat payload: {"messages":[{"data":"eyJ1dWlkIjoiZTcxNWRkZDQtZTVhYy01ZTExLThhZjYtZDNhYjM1ZjM1M2IwIiwiZGV2aWNlQ291bnQiOjIxNiwiYXBwQ291bnQiOjAsImhhcmR3YXJlSWQiOiJhYTljNDdkMy1lZjA1YWM0YS04OGJkYmM2NS04LTE2NjIxODU0NzIwNzQzODUyZGIifQ\u003d\u003d"}]}

[8]
[8]

[9]
Failed while retrieving devices count from DBTable "DM_ENROLMENT" not found; SQL statement:
SELECT COUNT AS DEVICE_COUNT FROM DM_ENROLMENT e [42102-200]
org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "DM_ENROLMENT" not found; SQL statement:
SELECT COUNT AS DEVICE_COUNT FROM DM_ENROLMENT e [42102-200]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:453)
at org.h2.message.DbException.getJdbcSQLException(DbException.java:429)
at org.h2.message.DbException.get(DbException.java:205)
at org.h2.message.DbException.get(DbException.java:181)
at org.h2.command.Parser.readTableOrView(Parser.java:7628)
at org.h2.command.Parser.readTableFilter(Parser.java:1970)
at org.h2.command.Parser.parseSelectFromPart(Parser.java:2827)
at org.h2.command.Parser.parseSelect(Parser.java:2959)
at org.h2.command.Parser.parseQuerySub(Parser.java:2817)
at org.h2.command.Parser.parseSelectUnion(Parser.java:2649)
at org.h2.command.Parser.parseQuery(Parser.java:2620)
at org.h2.command.Parser.parsePrepared(Parser.java:868)
at org.h2.command.Parser.parse(Parser.java:843)
at org.h2.command.Parser.parse(Parser.java:815)
at org.h2.command.Parser.prepareCommand(Parser.java:738)
at org.h2.engine.Session.prepareLocal(Session.java:657)
at org.h2.engine.Session.prepareCommand(Session.java:595)
at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1235)
at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:76)
at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:352)
at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:281)
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:313)
at io.entgra.proprietary.licensing.toolkit.eval.CountObserver.getTotalDevicesInSystem(CountObserver.java:168)
at io.entgra.proprietary.licensing.toolkit.service.impl.LicensingServiceImpl.isAllocatedDeviceCountReached(LicensingServiceImpl.java:21)
at io.entgra.proprietary.uem.platform.android.core.impl.AndroidServiceImpl.enrollDevice(AndroidServiceImpl.java:1446)
at io.entgra.proprietary.uem.platform.android.api.service.impl.DeviceManagementAPIImpl.enrollDevice(DeviceManagementAPIImpl.java:241)
at sun.reflect.GeneratedMethodAccessor924.invoke(Unknown Source)
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.doPost(AbstractHTTPServlet.java:217)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:681)
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)

Actions
Copy link
 #6

Updated by Viranga Gunarathna 3 months ago

  • Project changed from 33 to Backlog
Actions
Copy link
 #7

Updated by Pramila Niroshan 3 months ago

  • Assignee set to Pramila Niroshan
Actions
Copy link
 #8

Updated by Pramila Niroshan 2 months ago

  • Status changed from New to QA

In here issue was my sql transaction isolation level is REPEATABLE READ

we need to change it to READ-COMMITTED

1. Locate your MySQL configuration file:
- On Linux systems - /etc/mysql/my.cnf.
2. Open the MySQL configuration file using a text editor.
3. Find or create the [mysqld] section:
- If you already have a [mysqld] section, locate it within the file.
- If you don't have one, you can create it at the end of the file.

4. Add the `transaction_isolation` parameter:
- Add the following line under the [mysqld] section:

     transaction_isolation=READ-COMMITTED

5. Save the changes to the MySQL configuration file.

6. Restart the MySQL server:

sudo service mysql restart

we can temporarily set this using bellow commands


SET GLOBAL TRANSACTION ISOLATION LEVEL READ COMMITTED;
SELECT @@global.transaction_ISOLATION;
Actions
Copy link
 #9

Updated by Pramila Niroshan 14 days ago

  • Status changed from QA to Closed
Actions
Copy link

Also available in: Atom PDF