Server returned HTTP response code: 413 for <scrubbed secret> from msmdpump.dll

Shaharyar Mahmood 21 Reputation points
2022-09-22T20:37:46.707+00:00

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)

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,249 questions
0 comments No comments
{count} votes