Dashboard subscription email sent failed

Bug reports
1

Hi Metabase,
I have a Dashboard and a email subscription.
If I choose to attach results in csv, email is sent, if I choose to attach in XLS, email failed, in the Log:

2022-05-24 15:34:43,793 WARN util.XMLHelper :: SAX Feature unsupported [log suppressed for 5 minutes]http://javax.xml.XMLConstants/property/accessExternalStylesheet
java.lang.IllegalArgumentException: Not supported: http://javax.xml.XMLConstants/property/accessExternalStylesheet
at org.apache.xalan.processor.TransformerFactoryImpl.setAttribute(TransformerFactoryImpl.java:571)
at org.apache.poi.util.XMLHelper.trySet(XMLHelper.java:284)
at org.apache.poi.util.XMLHelper.getTransformerFactory(XMLHelper.java:225)
at org.apache.poi.util.XMLHelper.newTransformer(XMLHelper.java:231)
at org.apache.poi.openxml4j.opc.StreamHelper.saveXmlInStream(StreamHelper.java:56)
at org.apache.poi.openxml4j.opc.internal.ZipContentTypeManager.saveImpl(ZipContentTypeManager.java:68)
at org.apache.poi.openxml4j.opc.internal.ContentTypeManager.save(ContentTypeManager.java:450)
at org.apache.poi.openxml4j.opc.ZipPackage.saveImpl(ZipPackage.java:563)
at org.apache.poi.openxml4j.opc.OPCPackage.save(OPCPackage.java:1490)
at org.apache.poi.ooxml.POIXMLDocument.write(POIXMLDocument.java:227)
at org.apache.poi.xssf.streaming.SXSSFWorkbook.write(SXSSFWorkbook.java:968)
at dk.ative.docjure.spreadsheet$save_workbook_into_stream_BANG_.invokeStatic(spreadsheet.clj:106)
at dk.ative.docjure.spreadsheet$save_workbook_into_stream_BANG_.invoke(spreadsheet.clj:101)
at metabase.query_processor.streaming.xlsx$fn$reify__39174.finish_BANG_(xlsx.clj:514)
at metabase.email.messages$stream_api_results_to_export_format$fn__57922$fn__57923.invoke(messages.clj:371)
at metabase.query_processor.store$do_with_store.invokeStatic(store.clj:44)
at metabase.query_processor.store$do_with_store.invoke(store.clj:38)
at metabase.email.messages$stream_api_results_to_export_format$fn__57922.invoke(messages.clj:355)
at metabase.driver$do_with_driver.invokeStatic(driver.clj:75)
at metabase.driver$do_with_driver.invoke(driver.clj:71)
at metabase.email.messages$stream_api_results_to_export_format.invokeStatic(messages.clj:354)
at metabase.email.messages$stream_api_results_to_export_format.invoke(messages.clj:342)
at metabase.email.messages$result_attachment$fn__57939.invoke(messages.clj:384)
at metabase.email.messages$result_attachment.invokeStatic(messages.clj:383)
at metabase.email.messages$result_attachment.invoke(messages.clj:373)
at clojure.core$map$fn__5884.invoke(core.clj:2759)
at clojure.lang.LazySeq.sval(LazySeq.java:42)
at clojure.lang.LazySeq.seq(LazySeq.java:51)
at clojure.lang.Cons.next(Cons.java:39)
at clojure.lang.RT.boundedLength(RT.java:1793)
at clojure.lang.RestFn.applyTo(RestFn.java:130)
at clojure.core$apply.invokeStatic(core.clj:667)
at clojure.core$mapcat.invokeStatic(core.clj:2787)
at clojure.core$mapcat.doInvoke(core.clj:2787)
at clojure.lang.RestFn.invoke(RestFn.java:423)
at metabase.email.messages$result_attachments.invokeStatic(messages.clj:388)
at metabase.email.messages$result_attachments.invoke(messages.clj:387)
at metabase.email.messages$render_message_body.invokeStatic(messages.clj:455)
at metabase.email.messages$render_message_body.invoke(messages.clj:438)
at metabase.email.messages$render_pulse_email.invokeStatic(messages.clj:467)
at metabase.email.messages$render_pulse_email.invoke(messages.clj:464)
at metabase.pulse$fn__76417.invokeStatic(pulse.clj:293)
at metabase.pulse$fn__76417.invoke(pulse.clj:282)
at clojure.lang.MultiFn.invoke(MultiFn.java:239)
at metabase.pulse$results__GT_notifications$iter__76447__76451$fn__76452.invoke(pulse.clj:345)
at clojure.lang.LazySeq.sval(LazySeq.java:42)
at clojure.lang.LazySeq.seq(LazySeq.java:51)
at clojure.lang.RT.seq(RT.java:535)
at clojure.core$seq__5419.invokeStatic(core.clj:139)
at clojure.core$seq__5419.invoke(core.clj:139)
at metabase.pulse$send_notifications_BANG_.invokeStatic(pulse.clj:387)
at metabase.pulse$send_notifications_BANG_.invoke(pulse.clj:386)
at metabase.pulse$send_pulse_BANG_.invokeStatic(pulse.clj:415)
at metabase.pulse$send_pulse_BANG_.doInvoke(pulse.clj:395)
at clojure.lang.RestFn.invoke(RestFn.java:410)
at metabase.api.pulse$fn__77604.invokeStatic(pulse.clj:239)
at metabase.api.pulse$fn__77604.invoke(pulse.clj:225)
at compojure.core$wrap_response$fn__28036.invoke(core.clj:160)
at compojure.core$wrap_route_middleware$fn__28020.invoke(core.clj:132)
at compojure.core$wrap_route_info$fn__28025.invoke(core.clj:139)
at compojure.core$wrap_route_matches$fn__28029.invoke(core.clj:151)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__28029.invoke(core.clj:153)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__28029.invoke(core.clj:153)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__28029.invoke(core.clj:153)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__28029.invoke(core.clj:152)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048.invoke(core.clj:200)
at metabase.server.middleware.auth$enforce_authentication$fn__66749.invoke(auth.clj:14)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048.invoke(core.clj:200)
at compojure.core$make_context$handler__28076.invoke(core.clj:289)
at compojure.core$make_context$fn__28080.invoke(core.clj:299)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at compojure.core$make_context$fn__28080.invoke(core.clj:300)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at compojure.core$make_context$fn__28080.invoke(core.clj:300)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at compojure.core$make_context$fn__28080.invoke(core.clj:300)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at compojure.core$make_context$fn__28080.invoke(core.clj:300)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at compojure.core$make_context$fn__28080.invoke(core.clj:300)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at compojure.core$make_context$fn__28080.invoke(core.clj:300)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at compojure.core$make_context$fn__28080.invoke(core.clj:300)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at compojure.core$make_context$fn__28080.invoke(core.clj:300)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at compojure.core$make_context$fn__28080.invoke(core.clj:300)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at compojure.core$make_context$fn__28080.invoke(core.clj:300)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at compojure.core$make_context$fn__28080.invoke(core.clj:300)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at compojure.core$make_context$fn__28080.invoke(core.clj:300)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at compojure.core$make_context$fn__28080.invoke(core.clj:300)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at compojure.core$make_context$fn__28080.invoke(core.clj:300)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at compojure.core$make_context$fn__28080.invoke(core.clj:300)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at compojure.core$make_context$fn__28080.invoke(core.clj:300)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at compojure.core$make_context$fn__28080.invoke(core.clj:300)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at compojure.core$make_context$fn__28080.invoke(core.clj:300)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at compojure.core$make_context$fn__28080.invoke(core.clj:300)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at compojure.core$make_context$fn__28080.invoke(core.clj:300)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at compojure.core$make_context$fn__28080.invoke(core.clj:300)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at compojure.core$make_context$fn__28080.invoke(core.clj:300)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at metabase.api.routes$fn__78112$fn__78115.invoke(routes.clj:59)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048.invoke(core.clj:200)
at clojure.lang.AFn.applyToHelper(AFn.java:160)
at clojure.lang.AFn.applyTo(AFn.java:144)
at clojure.core$apply.invokeStatic(core.clj:667)
at clojure.core$apply.invoke(core.clj:662)
at metabase.server.routes$fn__78262$fn__78263.doInvoke(routes.clj:67)
at clojure.lang.RestFn.invoke(RestFn.java:436)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048.invoke(core.clj:200)
at compojure.core$make_context$handler__28076.invoke(core.clj:289)
at compojure.core$make_context$fn__28080.invoke(core.clj:299)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__28029.invoke(core.clj:153)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__28029.invoke(core.clj:153)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__28029.invoke(core.clj:153)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at metabase.server.routes$fn__78248$fn__78250.invoke(routes.clj:45)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048.invoke(core.clj:200)
at metabase.server.middleware.exceptions$catch_uncaught_exceptions$fn__75074.invoke(exceptions.clj:98)
at metabase.server.middleware.exceptions$catch_api_exceptions$fn__75071.invoke(exceptions.clj:86)
at metabase.server.middleware.log$log_api_call$fn__78732$fn__78733$fn__78734.invoke(log.clj:211)
at metabase.driver.sql_jdbc.execute.diagnostic$do_with_diagnostic_info.invokeStatic(diagnostic.clj:15)
at metabase.driver.sql_jdbc.execute.diagnostic$do_with_diagnostic_info.invoke(diagnostic.clj:9)
at metabase.server.middleware.log$log_api_call$fn__78732$fn__78733.invoke(log.clj:203)
at toucan.db$_do_with_call_counting.invokeStatic(db.clj:216)
at toucan.db$_do_with_call_counting.invoke(db.clj:209)
at metabase.server.middleware.log$log_api_call$fn__78732.invoke(log.clj:202)
at metabase.server.middleware.browser_cookie$ensure_browser_id_cookie$fn__81968.invoke(browser_cookie.clj:38)
at metabase.server.middleware.security$add_security_headers$fn__60352.invoke(security.clj:148)
at metabase.server.middleware.json$wrap_json_body$fn__81107.invoke(json.clj:63)
at metabase.server.middleware.json$wrap_streamed_json_response$fn__81125.invoke(json.clj:99)
at metabase.server.middleware.offset_paging$handle_paging$fn__60376.invoke(offset_paging.clj:42)
at ring.middleware.keyword_params$wrap_keyword_params$fn__82235.invoke(keyword_params.clj:55)
at ring.middleware.params$wrap_params$fn__82254.invoke(params.clj:77)
at metabase.server.middleware.misc$maybe_set_site_url$fn__35182.invoke(misc.clj:59)
at metabase.server.middleware.session$bind_current_user$fn__46653$fn__46654.invoke(session.clj:291)
at metabase.server.middleware.session$do_with_current_user.invokeStatic(session.clj:270)
at metabase.server.middleware.session$do_with_current_user.invoke(session.clj:259)
at metabase.server.middleware.session$bind_current_user$fn__46653.invoke(session.clj:290)
at metabase.server.middleware.session$wrap_current_user_info$fn__46635.invoke(session.clj:240)
at metabase.server.middleware.session$wrap_session_id$fn__46619.invoke(session.clj:173)
at metabase.server.middleware.auth$wrap_api_key$fn__66757.invoke(auth.clj:27)
at ring.middleware.cookies$wrap_cookies$fn__82155.invoke(cookies.clj:216)
at metabase.server.middleware.misc$add_content_type$fn__35165.invoke(misc.clj:27)
at metabase.server.middleware.misc$disable_streaming_buffering$fn__35190.invoke(misc.clj:76)
at ring.middleware.gzip$wrap_gzip$fn__82197.invoke(gzip.clj:86)
at metabase.server.middleware.misc$bind_request$fn__35193.invoke(misc.clj:93)
at metabase.server.middleware.ssl$redirect_to_https_middleware$fn__81984.invoke(ssl.clj:38)
at metabase.server$async_proxy_handler$fn__78504.invoke(server.clj:73)
at metabase.server.proxy$org.eclipse.jetty.server.handler.AbstractHandler$ff19274a.handle(Unknown Source)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)
at org.eclipse.jetty.server.Server.handle(Server.java:516)
at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:400)
at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:645)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:392)
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:277)
at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311)
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105)
at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:338)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:315)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:173)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131)
at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:409)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:883)
at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1034)
at java.lang.Thread.run(Unknown Source)

My setup:

{
"browser-info": {
"language": "en-US",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "Cp1252",
"java.runtime.name": "Java(TM) SE Runtime Environment",
"java.runtime.version": "1.8.0_221-b11",
"java.vendor": "Oracle Corporation",
"java.vendor.url": "http://java.oracle.com/",
"java.version": "1.8.0_221",
"java.vm.name": "Java HotSpot(TM) 64-Bit Server VM",
"java.vm.version": "25.221-b11",
"os.name": "Windows Server 2016",
"os.version": "10.0",
"user.language": "en",
"user.timezone": "Europe/Paris"
},
"metabase-info": {
"databases": [
"sqlserver",
"mysql",
"sqlite",
"postgres",
"googleanalytics",
"h2"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "12.2"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.3.2"
}
},
"run-mode": "prod",
"version": {
"tag": "v0.43.1",
"date": "2022-05-16",
"branch": "release-x.43.x",
"hash": "7f1a1c4"
},
"settings": {
"report-timezone": "Europe/Paris"
}
}
}

Best regards
Nicolas

2

Hi @nico8
Upgrade to Java 11: https://www.metabase.com/docs/latest/operations-guide/java-versions.html
You should have the same problem if you try to export the question as XLSX.

3

I have installed the latest version of Adoptium Java version.
But still the same error :

2022-05-30 14:23:00,856 WARN util.XMLHelper :: SAX Feature unsupported [log suppressed for 5 minutes]http://javax.xml.XMLConstants/property/accessExternalStylesheet
java.lang.IllegalArgumentException: Not supported: http://javax.xml.XMLConstants/property/accessExternalStylesheet
at org.apache.xalan.processor.TransformerFactoryImpl.setAttribute(TransformerFactoryImpl.java:571)
at org.apache.poi.util.XMLHelper.trySet(XMLHelper.java:284)
at org.apache.poi.util.XMLHelper.getTransformerFactory(XMLHelper.java:225)
at org.apache.poi.util.XMLHelper.newTransformer(XMLHelper.java:231)
at org.apache.poi.openxml4j.opc.StreamHelper.saveXmlInStream(StreamHelper.java:56)
at org.apache.poi.openxml4j.opc.internal.ZipContentTypeManager.saveImpl(ZipContentTypeManager.java:68)
at org.apache.poi.openxml4j.opc.internal.ContentTypeManager.save(ContentTypeManager.java:450)
at org.apache.poi.openxml4j.opc.ZipPackage.saveImpl(ZipPackage.java:563)
at org.apache.poi.openxml4j.opc.OPCPackage.save(OPCPackage.java:1490)
at org.apache.poi.ooxml.POIXMLDocument.write(POIXMLDocument.java:227)
at org.apache.poi.xssf.streaming.SXSSFWorkbook.write(SXSSFWorkbook.java:968)
at dk.ative.docjure.spreadsheet$save_workbook_into_stream_BANG_.invokeStatic(spreadsheet.clj:106)
at dk.ative.docjure.spreadsheet$save_workbook_into_stream_BANG_.invoke(spreadsheet.clj:101)
at metabase.query_processor.streaming.xlsx$fn$reify__39174.finish_BANG_(xlsx.clj:514)
at metabase.email.messages$stream_api_results_to_export_format$fn__57922$fn__57923.invoke(messages.clj:371)
at metabase.query_processor.store$do_with_store.invokeStatic(store.clj:44)
at metabase.query_processor.store$do_with_store.invoke(store.clj:38)
at metabase.email.messages$stream_api_results_to_export_format$fn__57922.invoke(messages.clj:355)
at metabase.driver$do_with_driver.invokeStatic(driver.clj:75)
at metabase.driver$do_with_driver.invoke(driver.clj:71)
at metabase.email.messages$stream_api_results_to_export_format.invokeStatic(messages.clj:354)
at metabase.email.messages$stream_api_results_to_export_format.invoke(messages.clj:342)
at metabase.email.messages$result_attachment$fn__57939.invoke(messages.clj:384)
at metabase.email.messages$result_attachment.invokeStatic(messages.clj:383)
at metabase.email.messages$result_attachment.invoke(messages.clj:373)
at clojure.core$map$fn__5884.invoke(core.clj:2759)
at clojure.lang.LazySeq.sval(LazySeq.java:42)
at clojure.lang.LazySeq.seq(LazySeq.java:51)
at clojure.lang.Cons.next(Cons.java:39)
at clojure.lang.RT.boundedLength(RT.java:1793)
at clojure.lang.RestFn.applyTo(RestFn.java:130)
at clojure.core$apply.invokeStatic(core.clj:667)
at clojure.core$mapcat.invokeStatic(core.clj:2787)
at clojure.core$mapcat.doInvoke(core.clj:2787)
at clojure.lang.RestFn.invoke(RestFn.java:423)
at metabase.email.messages$result_attachments.invokeStatic(messages.clj:388)
at metabase.email.messages$result_attachments.invoke(messages.clj:387)
at metabase.email.messages$render_message_body.invokeStatic(messages.clj:455)
at metabase.email.messages$render_message_body.invoke(messages.clj:438)
at metabase.email.messages$render_pulse_email.invokeStatic(messages.clj:467)
at metabase.email.messages$render_pulse_email.invoke(messages.clj:464)
at metabase.pulse$fn__76417.invokeStatic(pulse.clj:293)
at metabase.pulse$fn__76417.invoke(pulse.clj:282)
at clojure.lang.MultiFn.invoke(MultiFn.java:239)
at metabase.pulse$results__GT_notifications$iter__76447__76451$fn__76452.invoke(pulse.clj:345)
at clojure.lang.LazySeq.sval(LazySeq.java:42)
at clojure.lang.LazySeq.seq(LazySeq.java:51)
at clojure.lang.RT.seq(RT.java:535)
at clojure.core$seq__5419.invokeStatic(core.clj:139)
at clojure.core$seq__5419.invoke(core.clj:139)
at metabase.pulse$send_notifications_BANG_.invokeStatic(pulse.clj:387)
at metabase.pulse$send_notifications_BANG_.invoke(pulse.clj:386)
at metabase.pulse$send_pulse_BANG_.invokeStatic(pulse.clj:415)
at metabase.pulse$send_pulse_BANG_.doInvoke(pulse.clj:395)
at clojure.lang.RestFn.invoke(RestFn.java:410)
at metabase.api.pulse$fn__77604.invokeStatic(pulse.clj:239)
at metabase.api.pulse$fn__77604.invoke(pulse.clj:225)
at compojure.core$wrap_response$fn__28036.invoke(core.clj:160)
at compojure.core$wrap_route_middleware$fn__28020.invoke(core.clj:132)
at compojure.core$wrap_route_info$fn__28025.invoke(core.clj:139)
at compojure.core$wrap_route_matches$fn__28029.invoke(core.clj:151)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__28029.invoke(core.clj:153)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__28029.invoke(core.clj:153)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__28029.invoke(core.clj:153)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__28029.invoke(core.clj:152)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048.invoke(core.clj:200)
at metabase.server.middleware.auth$enforce_authentication$fn__66749.invoke(auth.clj:14)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048.invoke(core.clj:200)
at compojure.core$make_context$handler__28076.invoke(core.clj:289)
at compojure.core$make_context$fn__28080.invoke(core.clj:299)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at compojure.core$make_context$fn__28080.invoke(core.clj:300)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at compojure.core$make_context$fn__28080.invoke(core.clj:300)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at compojure.core$make_context$fn__28080.invoke(core.clj:300)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at compojure.core$make_context$fn__28080.invoke(core.clj:300)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at compojure.core$make_context$fn__28080.invoke(core.clj:300)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at compojure.core$make_context$fn__28080.invoke(core.clj:300)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at compojure.core$make_context$fn__28080.invoke(core.clj:300)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at compojure.core$make_context$fn__28080.invoke(core.clj:300)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at compojure.core$make_context$fn__28080.invoke(core.clj:300)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at compojure.core$make_context$fn__28080.invoke(core.clj:300)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at compojure.core$make_context$fn__28080.invoke(core.clj:300)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at compojure.core$make_context$fn__28080.invoke(core.clj:300)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at compojure.core$make_context$fn__28080.invoke(core.clj:300)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at compojure.core$make_context$fn__28080.invoke(core.clj:300)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at compojure.core$make_context$fn__28080.invoke(core.clj:300)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at compojure.core$make_context$fn__28080.invoke(core.clj:300)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at compojure.core$make_context$fn__28080.invoke(core.clj:300)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at compojure.core$make_context$fn__28080.invoke(core.clj:300)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at compojure.core$make_context$fn__28080.invoke(core.clj:300)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at compojure.core$make_context$fn__28080.invoke(core.clj:300)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at compojure.core$make_context$fn__28080.invoke(core.clj:300)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at compojure.core$make_context$fn__28080.invoke(core.clj:300)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at metabase.api.routes$fn__78112$fn__78115.invoke(routes.clj:59)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048.invoke(core.clj:200)
at clojure.lang.AFn.applyToHelper(AFn.java:160)
at clojure.lang.AFn.applyTo(AFn.java:144)
at clojure.core$apply.invokeStatic(core.clj:667)
at clojure.core$apply.invoke(core.clj:662)
at metabase.server.routes$fn__78262$fn__78263.doInvoke(routes.clj:67)
at clojure.lang.RestFn.invoke(RestFn.java:436)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048.invoke(core.clj:200)
at compojure.core$make_context$handler__28076.invoke(core.clj:289)
at compojure.core$make_context$fn__28080.invoke(core.clj:299)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__28029.invoke(core.clj:153)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__28029.invoke(core.clj:153)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__28029.invoke(core.clj:153)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048$f__28049$respond_SINGLEQUOTE___28050.invoke(core.clj:197)
at metabase.server.routes$fn__78248$fn__78250.invoke(routes.clj:45)
at compojure.core$routes$fn__28048$f__28049.invoke(core.clj:198)
at compojure.core$routes$fn__28048.invoke(core.clj:200)
at metabase.server.middleware.exceptions$catch_uncaught_exceptions$fn__75074.invoke(exceptions.clj:98)
at metabase.server.middleware.exceptions$catch_api_exceptions$fn__75071.invoke(exceptions.clj:86)
at metabase.server.middleware.log$log_api_call$fn__78732$fn__78733$fn__78734.invoke(log.clj:211)
at metabase.driver.sql_jdbc.execute.diagnostic$do_with_diagnostic_info.invokeStatic(diagnostic.clj:15)
at metabase.driver.sql_jdbc.execute.diagnostic$do_with_diagnostic_info.invoke(diagnostic.clj:9)
at metabase.server.middleware.log$log_api_call$fn__78732$fn__78733.invoke(log.clj:203)
at toucan.db$_do_with_call_counting.invokeStatic(db.clj:216)
at toucan.db$_do_with_call_counting.invoke(db.clj:209)
at metabase.server.middleware.log$log_api_call$fn__78732.invoke(log.clj:202)
at metabase.server.middleware.browser_cookie$ensure_browser_id_cookie$fn__81968.invoke(browser_cookie.clj:38)
at metabase.server.middleware.security$add_security_headers$fn__60352.invoke(security.clj:148)
at metabase.server.middleware.json$wrap_json_body$fn__81107.invoke(json.clj:63)
at metabase.server.middleware.json$wrap_streamed_json_response$fn__81125.invoke(json.clj:99)
at metabase.server.middleware.offset_paging$handle_paging$fn__60376.invoke(offset_paging.clj:42)
at ring.middleware.keyword_params$wrap_keyword_params$fn__82235.invoke(keyword_params.clj:55)
at ring.middleware.params$wrap_params$fn__82254.invoke(params.clj:77)
at metabase.server.middleware.misc$maybe_set_site_url$fn__35182.invoke(misc.clj:59)
at metabase.server.middleware.session$bind_current_user$fn__46653$fn__46654.invoke(session.clj:291)
at metabase.server.middleware.session$do_with_current_user.invokeStatic(session.clj:270)
at metabase.server.middleware.session$do_with_current_user.invoke(session.clj:259)
at metabase.server.middleware.session$bind_current_user$fn__46653.invoke(session.clj:290)
at metabase.server.middleware.session$wrap_current_user_info$fn__46635.invoke(session.clj:240)
at metabase.server.middleware.session$wrap_session_id$fn__46619.invoke(session.clj:173)
at metabase.server.middleware.auth$wrap_api_key$fn__66757.invoke(auth.clj:27)
at ring.middleware.cookies$wrap_cookies$fn__82155.invoke(cookies.clj:216)
at metabase.server.middleware.misc$add_content_type$fn__35165.invoke(misc.clj:27)
at metabase.server.middleware.misc$disable_streaming_buffering$fn__35190.invoke(misc.clj:76)
at ring.middleware.gzip$wrap_gzip$fn__82197.invoke(gzip.clj:86)
at metabase.server.middleware.misc$bind_request$fn__35193.invoke(misc.clj:93)
at metabase.server.middleware.ssl$redirect_to_https_middleware$fn__81984.invoke(ssl.clj:38)
at metabase.server$async_proxy_handler$fn__78504.invoke(server.clj:73)
at metabase.server.proxy$org.eclipse.jetty.server.handler.AbstractHandler$ff19274a.handle(Unknown Source)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)
at org.eclipse.jetty.server.Server.handle(Server.java:516)
at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:400)
at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:645)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:392)
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:277)
at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311)
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105)
at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:338)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:315)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:173)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131)
at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:409)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:883)
at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1034)
at java.base/java.lang.Thread.run(Thread.java:833)

Diagnostic Info

{
"browser-info": {
"language": "en-US",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "Cp1252",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "17.0.3+7",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "17.0.3",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "17.0.3+7",
"os.name": "Windows Server 2016",
"os.version": "10.0",
"user.language": "en",
"user.timezone": "Europe/Paris"
},
"metabase-info": {
"databases": [
"sqlserver",
"mysql",
"sqlite",
"postgres",
"googleanalytics",
"h2"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "12.2"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.3.2"
}
},
"run-mode": "prod",
"version": {
"date": "2022-05-16",
"tag": "v0.43.1",
"branch": "release-x.43.x",
"hash": "7f1a1c4"
},
"settings": {
"report-timezone": "Europe/Paris"
}
}
}

4

@nico8 Now simplify the problem. Figure out which question is causing problems. See if you can export the question as XLSX directly. Figure out a way to reproduce.

5

Hi,

I isolated the question in error.
Here is the stacktrace:

{"database_id":35,"started_at":"2022-06-14T10:36:53.3469762+02:00","via":[{"status":"failed","class":"class clojure.lang.ExceptionInfo","error":"Error reducing result rows","stacktrace":["--> query_processor.context.default$default_reducef$fn__38223.invoke(default.clj:59)","query_processor.context.default$default_reducef.invokeStatic(default.clj:56)","query_processor.context.default$default_reducef.invoke(default.clj:48)","query_processor.context$reducef.invokeStatic(context.clj:69)","query_processor.context$reducef.invoke(context.clj:62)","query_processor.context.default$default_runf$respond_STAR___38227.invoke(default.clj:68)","driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:507)","driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:486)","driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:494)","driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:486)","driver.sql_jdbc$fn__83565.invokeStatic(sql_jdbc.clj:54)","driver.sql_jdbc$fn__83565.invoke(sql_jdbc.clj:52)","query_processor.context$executef.invokeStatic(context.clj:59)","query_processor.context$executef.invoke(context.clj:48)","query_processor.context.default$default_runf.invokeStatic(default.clj:67)","query_processor.context.default$default_runf.invoke(default.clj:65)","query_processor.context$runf.invokeStatic(context.clj:45)","query_processor.context$runf.invoke(context.clj:39)","query_processor.reducible$identity_qp.invokeStatic(reducible.clj:12)","query_processor.reducible$identity_qp.invoke(reducible.clj:9)","query_processor.middleware.cache$maybe_return_cached_results$maybe_return_cached_results_STAR___51444.invoke(cache.clj:220)","query_processor.middleware.permissions$check_query_permissions$fn__47227.invoke(permissions.clj:109)","query_processor.middleware.mbql_to_native$mbql__GT_native$fn__50385.invoke(mbql_to_native.clj:23)","query_processor$fn__52917$combined_post_process__52922$combined_post_process_STAR___52923.invoke(query_processor.clj:207)","query_processor$fn__52917$combined_pre_process__52918$combined_pre_process_STAR___52919.invoke(query_processor.clj:204)","query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__51365$fn__51370.invoke(resolve_database_and_driver.clj:35)","driver$do_with_driver.invokeStatic(driver.clj:75)","driver$do_with_driver.invoke(driver.clj:71)","query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__51365.invoke(resolve_database_and_driver.clj:34)","query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__47470.invoke(fetch_source_query.clj:281)","query_processor.middleware.store$initialize_store$fn__47658$fn__47659.invoke(store.clj:11)","query_processor.store$do_with_store.invokeStatic(store.clj:44)","query_processor.store$do_with_store.invoke(store.clj:38)","query_processor.middleware.store$initialize_store$fn__47658.invoke(store.clj:10)","query_processor.middleware.normalize_query$normalize$fn__51637.invoke(normalize_query.clj:22)","query_processor.middleware.constraints$add_default_userland_constraints$fn__48727.invoke(constraints.clj:53)","query_processor.middleware.process_userland_query$process_userland_query$fn__51576.invoke(process_userland_query.clj:145)","query_processor.middleware.catch_exceptions$catch_exceptions$fn__51948.invoke(catch_exceptions.clj:162)","query_processor.reducible$async_qp$qp_STAR___44197$thunk__44199.invoke(reducible.clj:100)","query_processor.reducible$async_qp$qp_STAR___44197$fn__44201.invoke(reducible.clj:105)"],"error_type":"qp","ex-data":{"type":"qp"}}],"error_type":"qp","json_query":

Other question based on the same query is working, the only difference is the summarize by month vs by week or no summarize.

Nicolas

6

@nico8 Okay, can you post the question metadata by going to the URL /api/card/123, where 123 is the question ID. You can redact the question name, creator and editor email/name if you want, but leave everything else as is.

7 
{"description":null,"archived":false,"collection_position":null,"table_id":2523,"result_metadata":[{"description":null,"semantic_type":"type/CreationDate","coercion_strategy":null,"unit":"month","name":"Date","settings":null,"field_ref":["field",34889,{"temporal-unit":"month"}],"effective_type":"type/Date","id":34889,"display_name":"Date","fingerprint":{"global":{"distinct-count":148,"nil%":0.0},"type":{"type/DateTime":{"earliest":"2020-01-02","latest":"2020-07-03"}}},"base_type":"type/Date"},{"description":null,"semantic_type":"type/Category","coercion_strategy":null,"name":"Code pays","settings":null,"field_ref":["field",34891,null],"effective_type":"type/Text","id":34891,"display_name":"Code pays","fingerprint":{"global":{"distinct-count":3,"nil%":0.0},"type":{"type/Text":{"percent-json":0.0,"percent-url":0.0,"percent-email":0.0,"percent-state":0.0,"average-length":3.0}}},"base_type":"type/Text"},{"description":null,"semantic_type":"type/Category","coercion_strategy":null,"name":"ID magasin","settings":null,"field_ref":["field",34887,null],"effective_type":"type/Text","id":34887,"display_name":"ID magasin","fingerprint":{"global":{"distinct-count":79,"nil%":0.0},"type":{"type/Text":{"percent-json":0.0,"percent-url":0.0,"percent-email":0.0,"percent-state":0.0,"average-length":3.0}}},"base_type":"type/Text"},{"description":null,"semantic_type":"type/Product","coercion_strategy":null,"name":"Nom magasin","settings":null,"field_ref":["field",34884,null],"effective_type":"type/Text","id":34884,"display_name":"Nom magasin","fingerprint":{"global":{"distinct-count":79,"nil%":0.0},"type":{"type/Text":{"percent-json":0.0,"percent-url":0.0,"percent-email":0.0,"percent-state":0.0,"average-length":11.8634}}},"base_type":"type/Text"},{"description":null,"semantic_type":"type/Category","coercion_strategy":null,"name":"DR","settings":null,"field_ref":["expression","DR"],"effective_type":"type/Text","id":35146,"display_name":"DR","fingerprint":{"global":{"distinct-count":9,"nil%":0.0},"type":{"type/Text":{"percent-json":0.0,"percent-url":0.0,"percent-email":0.0,"percent-state":0.0,"average-length":5.358695652173913}}},"base_type":"type/Text"},{"display_name":"Sum of Nb tickets","semantic_type":"type/Quantity","settings":null,"field_ref":["aggregation",0],"name":"sum","base_type":"type/Integer","effective_type":"type/Integer","fingerprint":{"global":{"distinct-count":1907,"nil%":0.0},"type":{"type/Number":{"min":2.0,"q1":5128.1668466486435,"q3":8086.3458757052995,"max":18787.0,"sd":3075.0093398670997,"avg":6928.103883949462}}}},{"display_name":"Sum of Nb email","semantic_type":"type/Quantity","settings":null,"field_ref":["aggregation",1],"name":"sum_2","base_type":"type/Integer","effective_type":"type/Integer","fingerprint":{"global":{"distinct-count":224,"nil%":0.0},"type":{"type/Number":{"min":0.0,"q1":0.5646274291364721,"q3":6.573075304196397,"max":1229.0,"sd":102.53489921955394,"avg":30.741226017781937}}}},{"display_name":"Ratio email / ticket","field_ref":["aggregation",2],"name":"Ratio email / ticket","base_type":"type/Float","effective_type":"type/Float","semantic_type":null,"fingerprint":{"global":{"distinct-count":985,"nil%":0.0},"type":{"type/Number":{"min":0.0,"q1":1.0773203427271458E-4,"q3":8.643924649085745E-4,"max":0.22288106034182073,"sd":0.017854543850026428,"avg":0.005264372286932183}}}}],"creator":{"email":"nNico8","first_name":"Nico8","last_login":"2022-06-01T16:18:58.28027Z","is_qbnewb":false,"is_superuser":true,"id":1,"last_name":"Nico8","date_joined":"2020-04-02T13:23:33.33Z","common_name":"Nico8 Nico8"},"can_write":true,"database_id":35,"enable_embedding":false,"collection_id":198,"query_type":"query","name":"Stat email par magasin par DR par mois","last_query_start":"2022-06-14T08:57:57.170333Z","dashboard_count":2,"average_query_time":285.6973684210526316,"creator_id":1,"moderation_reviews":[],"updated_at":"2022-06-14T08:57:57.821071Z","made_public_by_id":null,"embedding_params":null,"cache_ttl":null,"dataset_query":{"database":35,"query":{"aggregation":[["sum",["field",34888,null]],["sum",["field",34886,null]],["aggregation-options",["/",["sum",["field",34886,null]],["sum",["field",34888,null]]],{"display-name":"Ratio email / ticket","name":"Ratio email / ticket"}]],"breakout":[["field",34889,{"temporal-unit":"month"}],["field",34891,null],["field",34887,null],["field",34884,null],["expression","DR"]],"expressions":{"DR":["field",35146,{"join-alias":"V_M_MYQUERY_MAGASIN_DR"}]},"filter":["=",["field",34891,null],"FRA"],"joins":[{"alias":"V_M_MYQUERY_MAGASIN_DR","condition":["=",["field",34887,null],["field",35128,{"join-alias":"V_M_MYQUERY_MAGASIN_DR"}]],"fields":"all","source-table":2540}],"order-by":[["desc",["field",34889,{"temporal-unit":"month"}]],["asc",["field",34891,null]],["asc",["field",34887,null]]],"source-table":2523},"type":"query"},"id":1214,"display":"table","last-edit-info":{"id":1,"email":"nNico8","first_name":"Nico8","last_name":"Nico8","timestamp":"2022-03-14T10:30:07.787504Z"},"visualization_settings":{"pivot_table.column_split":{"columns":[["field",34891,null],["field",4141,{"join-alias":"V_M_MYQUERY_MAGASIN"}]],"rows":[["field",34887,null],["field",34884,null],["field",34889,{"temporal-unit":"week"}]],"values":[["aggregation",0],["aggregation",1],["aggregation",2]]},"table.cell_column":"Nb tickets","table.pivot_column":"Code pays","column_settings":{"[\"name\",\"Ratio email / ticket\"]":{"number_style":"percent"},"[\"name\",\"sum_2\"]":{"column_title":"Nb email"},"[\"name\",\"sum\"]":{"column_title":"Nb tickets"},"[\"ref\",[\"field\",34890,null]]":{"number_style":"percent"},"[\"ref\",[\"field\",35146,null]]":{"column_title":"DR"},"[\"ref\",[\"field\",4141,null]]":{"column_title":"DR"}}},"collection":{"authority_level":null,"description":null,"archived":false,"slug":"email_magasin","color":"#509EE3","name":"Email Magasin","personal_owner_id":null,"id":198,"location":"/48/","namespace":null},"dataset":false,"created_at":"2022-02-24T16:47:57.649476Z","public_uuid":null}
8

@nico8 So are you seeing this stacktrace, when you try to export as XLSX via the question?
And if you make any changes to the question, then it works?
And it only happens to this question?
Then just recreate the question. I've not been able to trigger any errors by creating a similar question.

9

Sorry, the Stacktrace is when I export the question as XLSX.
If I made any changes to the question, it does not works.
It happens only to his question.
I have created a new question based on the same tables, filter, summarize, ... but it is the same result when opening the XLSX: error.
It is linked to a Date type field and summarized by month. It works by day, week, quarter, year.

10

@nico8 Do an export. Then look in the logs for anything around the time of the export - Admin > Troubleshooting > Logs.

I'm guessing it requires some specific combination of your data to be able to trigger this problem, which makes it impossible to figure out what is going on without mock data.

11

Same error

I found a workaround solution: in the table option, change setting on the filed Date style from January, 2018 to 1, 2018