Server returned HTTP response code: 413 for <scrubbed secret> from msmdpump.dll
Getting error while retrieving data from Analysis Services. I tied to adjust below config. properties but it doesn't help.
maxRequestEntityAllowed
uploadReadAheadSize
maxAllowedContentLength
maxRequestLength
Is there any other configuration that could resolve the issue?
2021-08-30 07:16:28,460 ERROR [OlapDataAccessWorkRequestQueue-worker-pool-10-thread-1] (com.prosrm.system.logging.impl.Slf4jAdapter) - 5d71ee54-158a-4565-8ce8-04336f77883e | unknown | not set | OlapDataAccess: OlapDataAccess: org.olap4j.OlapException\r\n at org.olap4j.driver.xmla.XmlaOlap4jConnection$Helper.createException(XmlaOlap4jConnection.java:711)\r\n at org.olap4j.driver.xmla.XmlaOlap4jConnection.xxx(XmlaOlap4jConnection.java:536)\r\n at org.olap4j.driver.xmla.XmlaOlap4jConnection.populateList(XmlaOlap4jConnection.java:522)\r\n at org.olap4j.driver.xmla.XmlaOlap4jCube$RawMetadataReader.lookupMembersByUniqueName(XmlaOlap4jCube.java:436)\r\n at org.olap4j.driver.xmla.XmlaOlap4jCube$DelegatingMetadataReader.lookupMembersByUniqueName(XmlaOlap4jCube.java:287)\r\n at org.olap4j.driver.xmla.XmlaOlap4jCube$CachingMetadataReader.lookupMembersByUniqueName(XmlaOlap4jCube.java:374)\r\n at org.olap4j.driver.xmla.XmlaOlap4jCellSet.populate(XmlaOlap4jCellSet.java:218)\r\n at org.olap4j.driver.xmla.XmlaOlap4jStatement.executeOlapQuery(XmlaOlap4jStatement.java:314)\r\n at com.prosrm.data.olap.engine.analysisservices.multidimensional.AnalysisServicesEngine.executeQuery(AnalysisServicesEngine.java:134)\r\n at com.prosrm.data.olap.impl.AbstractOlapDataHandler.execute(AbstractOlapDataHandler.java:95)\r\n at com.prosrm.data.olap.impl.AbstractOlapDataHandler.executeQuery(AbstractOlapDataHandler.java:53)\r\n at com.prosrm.data.olap.impl.OlapTableDataHandler.executeQuery(OlapTableDataHandler.java:29)\r\n at com.prosrm.data.olap.impl.processor.RowCountQueryStrategy.processQuery(RowCountQueryStrategy.java:62)\r\n at com.prosrm.data.olap.impl.processor.OlapDataProcessor.getOlapData(OlapDataProcessor.java:49)\r\n at com.prosrm.data.olap.impl.OlapDataAccess.getOlapData(OlapDataAccess.java:150)\r\n at com.prosrm.data.olap.impl.JmsOlapDataAccessConsumer.performWork(JmsOlapDataAccessConsumer.java:71)\r\n at com.prosrm.jms.RegulatedWorkConsumer$Worker.doWork(RegulatedWorkConsumer.java:381)\r\n at com.prosrm.jms.RegulatedWorkConsumer$Worker.run(RegulatedWorkConsumer.java:351)\r\n at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)\r\n at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)\r\n at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)\r\n at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)\r\n at java.base/java.lang.Thread.run(Thread.java:834)\r\nCaused by: java.io.IOException: Server returned HTTP response code: 413 for <scrubbed secret> from msmdpump.dll\r\n at java.base/sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1919)\r\n at java.base/sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1515)\r\n at org.olap4j.driver.xmla.XmlaOlap4jDriver$HttpProxy.get(XmlaOlap4jDriver.java:283)\r\n at org.olap4j.driver.xmla.XmlaOlap4jConnection.xxx(XmlaOlap4jConnection.java:534)\r\n ... 21 more\r\n
2021-08-30 07:16:28,478 ERROR [OlapDataAccessWorkRequestQueue-worker-pool-10-thread-1] (com.prosrm.system.logging.impl.Slf4jAdapter) - 5d71ee54-158a-4565-8ce8-04336f77883e | unknown | not set | OlapDataAccess: OlapDataAccess: com.prosrm.common.OperationFailedException: Failed to get OLAP data. Please check log file for details.\r\n at com.prosrm.data.olap.engine.analysisservices.multidimensional.AnalysisServicesEngine.executeQuery(AnalysisServicesEngine.java:145)\r\n at com.prosrm.data.olap.impl.AbstractOlapDataHandler.execute(AbstractOlapDataHandler.java:95)\r\n at com.prosrm.data.olap.impl.AbstractOlapDataHandler.executeQuery(AbstractOlapDataHandler.java:53)\r\n at com.prosrm.data.olap.impl.OlapTableDataHandler.executeQuery(OlapTableDataHandler.java:29)\r\n at com.prosrm.data.olap.impl.processor.RowCountQueryStrategy.processQuery(RowCountQueryStrategy.java:62)\r\n at com.prosrm.data.olap.impl.processor.OlapDataProcessor.getOlapData(OlapDataProcessor.java:49)\r\n at com.prosrm.data.olap.impl.OlapDataAccess.getOlapData(OlapDataAccess.java:150)\r\n at com.prosrm.data.olap.impl.JmsOlapDataAccessConsumer.performWork(JmsOlapDataAccessConsumer.java:71)\r\n at com.prosrm.jms.RegulatedWorkConsumer$Worker.doWork(RegulatedWorkConsumer.java:381)\r\n at com.prosrm.jms.RegulatedWorkConsumer$Worker.run(RegulatedWorkConsumer.java:351)\r\n at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)\r\n at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)\r\n at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)\r\n at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)\r\n at java.base/java.lang.Thread.run(Thread.java:834)\r\nCaused by: org.olap4j.OlapException\r\n at org.olap4j.driver.xmla.XmlaOlap4jConnection$Helper.createException(XmlaOlap4jConnection.java:711)\r\n at org.olap4j.driver.xmla.XmlaOlap4jConnection.xxx(XmlaOlap4jConnection.java:536)\r\n at org.olap4j.driver.xmla.XmlaOlap4jConnection.populateList(XmlaOlap4jConnection.java:522)\r\n at org.olap4j.driver.xmla.XmlaOlap4jCube$RawMetadataReader.lookupMembersByUniqueName(XmlaOlap4jCube.java:436)\r\n at org.olap4j.driver.xmla.XmlaOlap4jCube$DelegatingMetadataReader.lookupMembersByUniqueName(XmlaOlap4jCube.java:287)\r\n at org.olap4j.driver.xmla.XmlaOlap4jCube$CachingMetadataReader.lookupMembersByUniqueName(XmlaOlap4jCube.java:374)\r\n at org.olap4j.driver.xmla.XmlaOlap4jCellSet.populate(XmlaOlap4jCellSet.java:218)\r\n at org.olap4j.driver.xmla.XmlaOlap4jStatement.executeOlapQuery(XmlaOlap4jStatement.java:314)\r\n at com.prosrm.data.olap.engine.analysisservices.multidimensional.AnalysisServicesEngine.executeQuery(AnalysisServicesEngine.java:134)\r\n ... 14 more\r\nCaused by: java.io.IOException: Server returned HTTP response code: 413 for <scrubbed secret> from msmdpump.dll\r\n at java.base/sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1919)\r\n at java.base/sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1515)\r\n at org.olap4j.driver.xmla.XmlaOlap4jDriver$HttpProxy.get(XmlaOlap4jDriver.java:283)\r\n at org.olap4j.driver.xmla.XmlaOlap4jConnection.xxx(XmlaOlap4jConnection.java:534)