Untitled
unknown
plain_text
3 months ago
28 kB
2
Indexable
urllib.error.HTTPError: HTTP Error 400:
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "C:\Users\x528785\PycharmProjects\mars\cib-mars-cuboatotizspread\deploy\app\__main__.py", line 8, in <module>
f.execute()
File "C:\Users\x528785\PycharmProjects\mars\cib-mars-cuboatotizspread\deploy\app\RNIVCatalog.py", line 203, in execute
self.data_load_controller.dlc_load_plsec(query_params_plvector)
File "C:\Users\x528785\PycharmProjects\mars\cib-mars-cuboatotizspread\deploy\app\data_loader\DataLoadController.py", line 161, in dlc_load_plsec
plsec_loader_shat.extract(scope, split_by_desk=True, risk_classes=['IR', 'Inflation'])
File "C:\Users\x528785\PycharmProjects\mars\cib-mars-cuboatotizspread\deploy\app\data_loader\specific\PLVectorLoader.py", line 34, in extract
desk_list = self.get_desk_list(mdx_parameters)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\x528785\PycharmProjects\mars\cib-mars-cuboatotizspread\deploy\app\data_loader\specific\PLVectorLoader.py", line 149, in get_desk_list
desk_query.extract(mdx_parameters)
File "C:\Users\x528785\PycharmProjects\mars\cib-mars-cuboatotizspread\deploy\app\data_loader\MDXDataLoader.py", line 57, in extract
self.query_result = self.catalog.query_mdx(self.source_cube, self.mdx_query_to_run, self.source_cube)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\x528785\PycharmProjects\mars\cib-mars-cuboatotizspread\deploy\arq\MarsAtotiCatalog.py", line 100, in query_mdx
return ses.query_mdx(mdx, timeout=timedelta(milliseconds=MDX_TIMEOUT))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\ProgramData\anaconda3\envs\Atoti\Lib\site-packages\pydantic\validate_call_decorator.py", line 59, in wrapper_function
return validate_call_wrapper(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\ProgramData\anaconda3\envs\Atoti\Lib\site-packages\pydantic\_internal\_validate_call.py", line 81, in __call__
res = self.__pydantic_validator__.validate_python(pydantic_core.ArgsKwargs(args, kwargs))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\ProgramData\anaconda3\envs\Atoti\Lib\site-packages\atoti_query\query_session.py", line 371, in query_mdx
cellset = self._query_mdx_to_cellset(mdx, context=context)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\ProgramData\anaconda3\envs\Atoti\Lib\site-packages\atoti_query\query_session.py", line 333, in _query_mdx_to_cellset
response = self._client.fetch_json(
^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\ProgramData\anaconda3\envs\Atoti\Lib\site-packages\atoti_core\activeviam_client.py", line 220, in fetch_json
return fetch_json(
^^^^^^^^^^^
File "C:\ProgramData\anaconda3\envs\Atoti\Lib\site-packages\atoti_core\fetch_json.py", line 55, in fetch_json
opener_director.open(request, timeout=timeout_in_seconds)
File "C:\ProgramData\anaconda3\envs\Atoti\Lib\urllib\request.py", line 521, in open
response = meth(req, response)
^^^^^^^^^^^^^^^^^^^
File "C:\ProgramData\anaconda3\envs\Atoti\Lib\urllib\request.py", line 630, in http_response
response = self.parent.error(
^^^^^^^^^^^^^^^^^^
File "C:\ProgramData\anaconda3\envs\Atoti\Lib\urllib\request.py", line 559, in error
return self._call_chain(*args)
^^^^^^^^^^^^^^^^^^^^^^^
File "C:\ProgramData\anaconda3\envs\Atoti\Lib\urllib\request.py", line 492, in _call_chain
result = func(*args)
^^^^^^^^^^^
File "C:\ProgramData\anaconda3\envs\Atoti\Lib\site-packages\atoti_core\activeviam_client.py", line 119, in http_error_default
raise ActiveViamHttpError(
atoti_core.activeviam_client.ActiveViamHttpError: HTTP Error 400: com.qfs.fwk.services.BadArgumentException: [400] com.quartetfs.pivot.mdx.MdxException: Error with the following query: SELECT NON EMPTY Crossjoin( [Measures].[contributors.COUNT], [Aire].[Risk_Factor_Aire].[Risk_Factor_Aire].Members ) ON COLUMNS, NON EMPTY [Portfolio].[TradingDesk].[TradingDesk].Members ON ROWS FROM ( SELECT { [Product].[Group].[ALL].[AllMember].[BOND], [Product].[Group].[ALL].[AllMember].[RTRN], [Product].[Group].[ALL].[AllMember].[ETF] } ON COLUMNS FROM [VaR-ES Cube] WHERE ( [Aire].[VaRMethod].[ALL].[AllMember].[SHAT], ) ) WHERE ( [Aire].[VaRMethod].[ALL].[AllMember].[SHAT], [Dates].[Date].[AsOfDate].[2024-11-29], [Risk].[Risk Classes].[ALL].[AllMember].[TOTAL SIN CREDITO], [Risk].[Scenario Sets].[Scenario Set].[VAR_HISTORICAL_SLB_HISTORICAL_1D] ) CELL PROPERTIES VALUE, FORMATTED_VALUE, BACK_COLOR, FORE_COLOR, FONT_FLAGS
at com.qfs.pivot.rest.query.impl.JsonQueryService.executeQuery(JsonQueryService.java:170)
at com.qfs.pivot.rest.query.impl.JsonQueryService.executeMdxQuery(JsonQueryService.java:103)
at com.qfs.pivot.rest.query.impl.QueriesRestService.mdxQuery(QueriesRestService.java:62)
at sun.reflect.GeneratedMethodAccessor414.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:193)
at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:103)
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:308)
at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121)
at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:267)
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:216)
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:301)
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPost(AbstractHTTPServlet.java:220)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:276)
at org.springframework.web.servlet.mvc.ServletWrappingController.handleRequestInternal(ServletWrappingController.java:165)
at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:177)
at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:52)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1038)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1005)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:908)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:882)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.qfs.jwt.impl.JwtFilter.doFilter(JwtFilter.java:124)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:101)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.boot.actuate.web.trace.servlet.HttpTraceFilter.doFilterInternal(HttpTraceFilter.java:90)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320)
at com.qfs.pivot.servlet.impl.ContextValueFilter.doFilter(ContextValueFilter.java:69)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:119)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:215)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at com.qfs.jwt.impl.JwtFilter.doFilter(JwtFilter.java:124)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:96)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:74)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215)
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:357)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:270)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.filterAndRecordMetrics(WebMvcMetricsFilter.java:117)
at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:106)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:834)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1417)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:750)
Caused by: com.quartetfs.pivot.mdx.MdxException: Error with the following query: SELECT NON EMPTY Crossjoin( [Measures].[contributors.COUNT], [Aire].[Risk_Factor_Aire].[Risk_Factor_Aire].Members ) ON COLUMNS, NON EMPTY [Portfolio].[TradingDesk].[TradingDesk].Members ON ROWS FROM ( SELECT { [Product].[Group].[ALL].[AllMember].[BOND], [Product].[Group].[ALL].[AllMember].[RTRN], [Product].[Group].[ALL].[AllMember].[ETF] } ON COLUMNS FROM [VaR-ES Cube] WHERE ( [Aire].[VaRMethod].[ALL].[AllMember].[SHAT], ) ) WHERE ( [Aire].[VaRMethod].[ALL].[AllMember].[SHAT], [Dates].[Date].[AsOfDate].[2024-11-29], [Risk].[Risk Classes].[ALL].[AllMember].[TOTAL SIN CREDITO], [Risk].[Scenario Sets].[Scenario Set].[VAR_HISTORICAL_SLB_HISTORICAL_1D] ) CELL PROPERTIES VALUE, FORMATTED_VALUE, BACK_COLOR, FORE_COLOR, FONT_FLAGS
at com.quartetfs.pivot.mdx.impl.ASelectStatementExecutor.executeAfterParse(ASelectStatementExecutor.java:375)
at com.quartetfs.pivot.mdx.impl.ASelectStatementExecutor.executeAfterParse(ASelectStatementExecutor.java:357)
at com.quartetfs.pivot.mdx.impl.ASelectStatementExecutor.execute(ASelectStatementExecutor.java:346)
at com.qfs.pivot.rest.query.impl.JsonQueryService$JsonSelectExecutor.execute(JsonQueryService.java:201)
at com.qfs.pivot.rest.query.impl.JsonQueryService$JsonSelectExecutor.execute(JsonQueryService.java:181)
at com.qfs.pivot.rest.query.impl.JsonQueryService.executeQuery(JsonQueryService.java:165)
... 112 more
Caused by: com.quartetfs.fwk.query.QueryException: Could not execute query at epoch 2768. : ActivePivotSyncActionQuery: action=MdxAction (mdx=SELECT NON EMPTY Crossjoin( [Measures].[contributors.COUNT], [Aire].[Risk_Factor_Aire].[Risk_Factor_Aire].Members ) ON COLUMNS, NON EMPTY [Portfolio].[TradingDesk].[TradingDesk].Members ON ROWS FROM ( SELECT { [Product].[Group].[ALL].[AllMember].[BOND], [Product].[Group].[ALL].[AllMember].[RTRN], [Product].[Group].[ALL].[AllMember].[ETF] } ON COLUMNS FROM [VaR-ES Cube] WHERE ( [Aire].[VaRMethod].[ALL].[AllMember].[SHAT], ) ) WHERE ( [Aire].[VaRMethod].[ALL].[AllMember].[SHAT], [Dates].[Date].[AsOfDate].[2024-11-29], [Risk].[Risk Classes].[ALL].[AllMember].[TOTAL SIN CREDITO], [Risk].[Scenario Sets].[Scenario Set].[VAR_HISTORICAL_SLB_HISTORICAL_1D] ) CELL PROPERTIES VALUE, FORMATTED_VALUE, BACK_COLOR, FORE_COLOR, FONT_FLAGS), argument=com.quartetfs.pivot.mdx.impl.BasicSelectExecutor@22eb9bcb
at com.quartetfs.biz.pivot.impl.ActivePivotVersion$QueryExecutionTask.getWithQueriesTimeLimit(ActivePivotVersion.java:1500)
at com.quartetfs.biz.pivot.impl.ActivePivotVersion.execute(ActivePivotVersion.java:916)
at com.quartetfs.biz.pivot.query.impl.ActivePivotSyncUtils.activePivotSyncExec(ActivePivotSyncUtils.java:94)
at com.quartetfs.pivot.mdx.impl.ASelectStatementExecutor.executeAfterParse(ASelectStatementExecutor.java:373)
... 117 more
Caused by: java.lang.RuntimeException: java.lang.RuntimeException: com.quartetfs.fwk.query.QueryException: ActivePivotSyncActionQuery: action=MdxAction (mdx=SELECT NON EMPTY Crossjoin( [Measures].[contributors.COUNT], [Aire].[Risk_Factor_Aire].[Risk_Factor_Aire].Members ) ON COLUMNS, NON EMPTY [Portfolio].[TradingDesk].[TradingDesk].Members ON ROWS FROM ( SELECT { [Product].[Group].[ALL].[AllMember].[BOND], [Product].[Group].[ALL].[AllMember].[RTRN], [Product].[Group].[ALL].[AllMember].[ETF] } ON COLUMNS FROM [VaR-ES Cube] WHERE ( [Aire].[VaRMethod].[ALL].[AllMember].[SHAT], ) ) WHERE ( [Aire].[VaRMethod].[ALL].[AllMember].[SHAT], [Dates].[Date].[AsOfDate].[2024-11-29], [Risk].[Risk Classes].[ALL].[AllMember].[TOTAL SIN CREDITO], [Risk].[Scenario Sets].[Scenario Set].[VAR_HISTORICAL_SLB_HISTORICAL_1D] ) CELL PROPERTIES VALUE, FORMATTED_VALUE, BACK_COLOR, FORE_COLOR, FONT_FLAGS), argument=com.quartetfs.pivot.mdx.impl.BasicSelectExecutor@22eb9bcb
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at java.util.concurrent.ForkJoinTask.getThrowableException(ForkJoinTask.java:593)
at java.util.concurrent.ForkJoinTask.get(ForkJoinTask.java:1066)
at com.quartetfs.biz.pivot.impl.ActivePivotVersion$QueryExecutionTask.getWithQueriesTimeLimit(ActivePivotVersion.java:1471)
... 120 more
Caused by: java.lang.RuntimeException: com.quartetfs.fwk.query.QueryException: ActivePivotSyncActionQuery: action=MdxAction (mdx=SELECT NON EMPTY Crossjoin( [Measures].[contributors.COUNT], [Aire].[Risk_Factor_Aire].[Risk_Factor_Aire].Members ) ON COLUMNS, NON EMPTY [Portfolio].[TradingDesk].[TradingDesk].Members ON ROWS FROM ( SELECT { [Product].[Group].[ALL].[AllMember].[BOND], [Product].[Group].[ALL].[AllMember].[RTRN], [Product].[Group].[ALL].[AllMember].[ETF] } ON COLUMNS FROM [VaR-ES Cube] WHERE ( [Aire].[VaRMethod].[ALL].[AllMember].[SHAT], ) ) WHERE ( [Aire].[VaRMethod].[ALL].[AllMember].[SHAT], [Dates].[Date].[AsOfDate].[2024-11-29], [Risk].[Risk Classes].[ALL].[AllMember].[TOTAL SIN CREDITO], [Risk].[Scenario Sets].[Scenario Set].[VAR_HISTORICAL_SLB_HISTORICAL_1D] ) CELL PROPERTIES VALUE, FORMATTED_VALUE, BACK_COLOR, FORE_COLOR, FONT_FLAGS), argument=com.quartetfs.pivot.mdx.impl.BasicSelectExecutor@22eb9bcb
at java.util.concurrent.ForkJoinTask.completeExceptionally(ForkJoinTask.java:948)
at com.qfs.concurrent.cancellable.impl.CancellableCountedCompleter.performExceptionalCompletion(CancellableCountedCompleter.java:277)
at com.qfs.concurrent.cancellable.impl.CancellableCountedCompleter.onCompletion(CancellableCountedCompleter.java:264)
at java.util.concurrent.CountedCompleter.tryComplete(CountedCompleter.java:577)
at com.quartetfs.biz.pivot.impl.ActivePivotVersion$QueryExecutionTask.afterCompute(ActivePivotVersion.java:1362)
at com.qfs.concurrent.cancellable.impl.CancellableCountedCompleter.afterExec(CancellableCountedCompleter.java:149)
at com.quartetfs.biz.pivot.context.impl.ContextualCancellableCountedCompleter.afterExec(ContextualCancellableCountedCompleter.java:124)
at com.qfs.concurrent.cancellable.impl.CancellableCountedCompleter.compute(CancellableCountedCompleter.java:170)
at java.util.concurrent.CountedCompleter.exec(CountedCompleter.java:731)
at java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:289)
at java.util.concurrent.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1056)
at java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1692)
at java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:175)
Caused by: com.quartetfs.fwk.query.QueryException: ActivePivotSyncActionQuery: action=MdxAction (mdx=SELECT NON EMPTY Crossjoin( [Measures].[contributors.COUNT], [Aire].[Risk_Factor_Aire].[Risk_Factor_Aire].Members ) ON COLUMNS, NON EMPTY [Portfolio].[TradingDesk].[TradingDesk].Members ON ROWS FROM ( SELECT { [Product].[Group].[ALL].[AllMember].[BOND], [Product].[Group].[ALL].[AllMember].[RTRN], [Product].[Group].[ALL].[AllMember].[ETF] } ON COLUMNS FROM [VaR-ES Cube] WHERE ( [Aire].[VaRMethod].[ALL].[AllMember].[SHAT], ) ) WHERE ( [Aire].[VaRMethod].[ALL].[AllMember].[SHAT], [Dates].[Date].[AsOfDate].[2024-11-29], [Risk].[Risk Classes].[ALL].[AllMember].[TOTAL SIN CREDITO], [Risk].[Scenario Sets].[Scenario Set].[VAR_HISTORICAL_SLB_HISTORICAL_1D] ) CELL PROPERTIES VALUE, FORMATTED_VALUE, BACK_COLOR, FORE_COLOR, FONT_FLAGS), argument=com.quartetfs.pivot.mdx.impl.BasicSelectExecutor@22eb9bcb
at com.quartetfs.biz.pivot.query.impl.ActivePivotSyncActionAttachedQuery.executeAsync(ActivePivotSyncActionAttachedQuery.java:59)
at com.quartetfs.biz.pivot.impl.AActivePivotQueryExecutor.executeAsync(AActivePivotQueryExecutor.java:33)
at com.quartetfs.biz.pivot.impl.ActivePivotVersion.executeAttachedAsync(ActivePivotVersion.java:1100)
at com.quartetfs.biz.pivot.impl.ActivePivotVersion$QueryExecutionTask.computeSafely(ActivePivotVersion.java:1350)
at com.qfs.concurrent.cancellable.impl.CancellableCountedCompleter.execSafely(CancellableCountedCompleter.java:133)
at com.quartetfs.biz.pivot.context.impl.ContextualCancellableCountedCompleter.execSafely(ContextualCancellableCountedCompleter.java:118)
at com.qfs.concurrent.cancellable.impl.CancellableCountedCompleter.compute(CancellableCountedCompleter.java:163)
... 5 more
Caused by: com.quartetfs.pivot.mdx.MdxException: SELECT NON EMPTY Crossjoin( [Measures].[contributors.COUNT], [Aire].[Risk_Factor_Aire].[Risk_Factor_Aire].Members ) ON COLUMNS, NON EMPTY [Portfolio].[TradingDesk].[TradingDesk].Members ON ROWS FROM ( SELECT { [Product].[Group].[ALL].[AllMember].[BOND], [Product].[Group].[ALL].[AllMember].[RTRN], [Product].[Group].[ALL].[AllMember].[ETF] } ON COLUMNS FROM [VaR-ES Cube] WHERE ( [Aire].[VaRMethod].[ALL].[AllMember].[SHAT], ) ) WHERE ( [Aire].[VaRMethod].[ALL].[AllMember].[SHAT], [Dates].[Date].[AsOfDate].[2024-11-29], [Risk].[Risk Classes].[ALL].[AllMember].[TOTAL SIN CREDITO], [Risk].[Scenario Sets].[Scenario Set].[VAR_HISTORICAL_SLB_HISTORICAL_1D] ) CELL PROPERTIES VALUE, FORMATTED_VALUE, BACK_COLOR, FORE_COLOR, FONT_FLAGS
at com.quartetfs.pivot.mdx.impl.ASelectStatementExecutor.resolve(ASelectStatementExecutor.java:232)
at com.quartetfs.pivot.mdx.impl.ASelectStatementExecutor.noSyncExecuteAfterParse(ASelectStatementExecutor.java:412)
at com.quartetfs.pivot.mdx.impl.ASelectStatementExecutor$MdxAction.execute(ASelectStatementExecutor.java:481)
at com.quartetfs.pivot.mdx.impl.ASelectStatementExecutor$MdxAction.execute(ASelectStatementExecutor.java:461)
at com.quartetfs.biz.pivot.query.impl.ActivePivotSyncUtils$AAction.execute(ActivePivotSyncUtils.java:205)
at com.quartetfs.biz.pivot.query.impl.ActivePivotSyncActionAttachedQuery.executeAsync(ActivePivotSyncActionAttachedQuery.java:57)
... 11 more
Caused by: com.quartetfs.pivot.mdx.MdxException: Failed resolution of expression: ([Aire].[VaRMethod].[ALL].[AllMember].[SHAT], )
at com.quartetfs.pivot.mdx.impl.SelectStatementResolver.resolve(SelectStatementResolver.java:164)
at com.quartetfs.pivot.mdx.impl.SelectStatementResolver.resolveSlicer(SelectStatementResolver.java:788)
at com.quartetfs.pivot.mdx.impl.SelectStatementResolver.resolveSelectBase(SelectStatementResolver.java:460)
at com.quartetfs.pivot.mdx.impl.SelectStatementResolver.resolveSelectBase(SelectStatementResolver.java:443)
at com.quartetfs.pivot.mdx.impl.SelectStatementResolver.resolveSelect(SelectStatementResolver.java:257)
at com.quartetfs.pivot.mdx.impl.SelectStatementResolver.resolve(SelectStatementResolver.java:205)
at com.quartetfs.pivot.mdx.impl.ASelectStatementExecutor.doResolve(ASelectStatementExecutor.java:274)
at com.quartetfs.pivot.mdx.impl.ASelectStatementExecutor.resolve(ASelectStatementExecutor.java:226)
... 16 more
Caused by: com.quartetfs.pivot.mdx.MdxException: No matching signature for ([Aire].[VaRMethod].[ALL].[AllMember].[SHAT], ). Available signatures are: ()([<Member> ...]), ()(<Value>), ()(<Tuple>), ()(<Set> ...)
at com.quartetfs.pivot.mdx.impl.SelectStatementResolver$ResolveVisitor.visit(SelectStatementResolver.java:1082)
at com.quartetfs.pivot.mdx.impl.SelectStatementResolver$ResolveVisitor.visit(SelectStatementResolver.java:859)
at com.quartetfs.pivot.mdx.impl.CachingVisitor.visit(CachingVisitor.java:85)
at com.quartetfs.pivot.mdx.statement.impl.UnresolvedFunctionCall.accept(UnresolvedFunctionCall.java:58)
at com.quartetfs.pivot.mdx.impl.SelectStatementResolver.resolve(SelectStatementResolver.java:162)
... 23 more
[2024-12-19 12:59:34,115][py4j.clientserver] INFO: Closing down clientserver connectionEditor is loading...
Leave a Comment