Data missing in downloaded xlsx or csv or json file

Some people using metabase are facing issues with downloading the questions.

They do not get any data in the downloaded files

I am currently using version 0.42.1

Hi @mustaq.ansari
Post "Diagnostic Info" from Admin > Troubleshooting
And post the content of the file (not a screenshot).

This is the content of the file:

{"database_id":4 started_at:"2022-02-23T09:33:57.273049Z" error_type:"missing-required-permissions" json_query:{"type":"native" middleware:{"ignore-cached-results?":true process-viz-settings?:true skip-results-metadata?:true format-rows?:false} native:{"template-tags":{"name":{"id":"2998ca3c-2c79-3cd2-ac4d-d7bc0407d012" name:"name" display-name:"Name" type:"dimension" dimension:["field" 6596 null] widget-type:"category" default:null}} query:"[\n{$match: {{name}}}\n\n{$lookup: {from: 'ipqs' localField: '_id' foreignField: 'shop' as: 'ipqsdata'}}\n{$unwind: '$ipqsdata'}\n\n{$project: {\n _id: 0 \n shopName: '$name' \n sia: '$ipqsdata.sia' \n quantityAvailable: '$ipqsdata.quantityAvailable' \n MRP: {$cond: {if: {$eq: [{$arrayElemAt: ['$ipqsdata.prices.orderType' 0]} MARKETPLACE']} \n then: {$divide: [{$arrayElemAt: ['$ipqsdata.prices.mrp' 0]} 100]} \n else: {$divide: [{$arrayElemAt: ['$ipqsdata.prices.mrp' 1]} 100]}}} \n sellingPrice: {$cond: {if: {$eq: [{$arrayElemAt: ['$ipqsdata.prices.orderType' 0]} MARKETPLACE']} \n then: {$divide: [{$arrayElemAt: ['$ipqsdata.prices.sellingPrice' 0]} 100]} \n else: {$divide: [{$arrayElemAt: ['$ipqsdata.prices.sellingPrice' 1]} 100]}}} \n variationUuid: '$ipqsdata.variationUuid'\n}}\n\n{$lookup: {from: 'sias' localField: 'sia' foreignField: '_id' as: 'siasdata'}}\n{$unwind: '$siasdata'}\n\n{$project: {\n id: 0 \n shopName: 1 \n quantityAvailable: 1 \n MRP: 1 \n sellingPrice: 1 \n itemName: '$siasdata.itemDetail.name' \n itemUsId: '$siasdata.itemDetail.usId' \n l0CategoryNames: '$siasdata.itemDetail.l0CategoryNames' \n l1CategoryNames: '$siasdata.itemDetail.l1CategoryNames' \n l2CategoryNames: '$siasdata.itemDetail.l2CategoryNames' \n description: '$siasdata.itemDetail.description' \n imageCount: {$size: '$siasdata.itemDetail.images'} \n images: '$siasdata.itemDetail.images.url' \n sizeChart: {$ifNull: [{$arrayElemAt: ['$siasdata.itemDetail.sizeChart.url' 0]} -']} \n material: {$ifNull: ['$siasdata.itemDetail.tags.Material' -']} \n sizing: {$ifNull: ['$siasdata.itemDetail.tags.Sizing/Fit' -']} \n color: {$ifNull: ['$siasdata.itemDetail.tags.Color' -']} \n style: {$ifNull: ['$siasdata.itemDetail.tags.Style' -']} \n Pattern: {$ifNull: ['$siasdata.itemDetail.tags.Pattern' -']} \n PackageIncludes: {$ifNull: ['$siasdata.itemDetail.tags.Package Includes' -']} \n careInstructions: {$ifNull: ['$siasdata.itemDetail.tags.Care Instructions' -']} \n origin: {$ifNull: ['$siasdata.itemDetail.tags.Origin' -']} \n benefits: {$ifNull: ['$siasdata.itemDetail.tags.Benefits' -']} \n ingredients: {$ifNull: ['$siasdata.itemDetail.tags.Ingredients/Material' -']} \n recommendedFor: {$ifNull: ['$siasdata.itemDetail.tags.Recommended For' -']} \n fragranceNotes: {$ifNull: ['$siasdata.itemDetail.tags.Fragrance Notes' -']} \n howToUse: {$ifNull: ['$siasdata.itemDetail.tags.How to use' -']} \n shelfLife: {$ifNull: ['$siasdata.itemDetail.tags.Shelf Life' -']} \n veg_NonVeg: {$ifNull: ['$siasdata.itemDetail.tags.Veg/Non-veg' -']} \n ingredeients_Food: {$ifNull: ['$siasdata.itemDetail.tags.Ingredients' -']} \n weight: {$ifNull: ['$siasdata.itemDetail.tags.Weight' -']} \n storageInstructions: {$ifNull: ['$siasdata.itemDetail.tags.Storage Instructions' -']} \n nutritionalValue: {$ifNull: ['$siasdata.itemDetail.tags.Nutritional Value' -']} \n flavour: {$ifNull: ['$siasdata.itemDetail.tags.Flavour' -']} \n styleType: {$ifNull: ['$siasdata.itemDetail.tags.Style Type' -']} \n baseMaterial: {$ifNull: ['$siasdata.itemDetail.tags.Base Material' -']} \n platingMaterial: {$ifNull: ['$siasdata.itemDetail.tags.Plating Material' -']} \n stoneType: {$ifNull: ['$siasdata.itemDetail.tags.Stone Type' -']} \n dimensions: {$ifNull: ['$siasdata.itemDetail.tags.Dimensions' -']} \n claspType: {$ifNull: ['$siasdata.itemDetail.tags.Clasp Type' -']} \n occassion: {$ifNull: ['$siasdata.itemDetail.tags.Occassion' -']} \n features: {$ifNull: ['$siasdata.itemDetail.tags.Features' -']} \n toeShape: {$ifNull: ['$siasdata.itemDetail.tags.Toe Shape' -']} \n fasteningType: {$ifNull: ['$siasdata.itemDetail.tags.Fastening Type' -']} \n soleMaterial: {$ifNull: ['$siasdata.itemDetail.tags.Sole Material' -']} \n otherMaterials: {$ifNull: ['$siasdata.itemDetail.tags.Other Materials' -']} \n ankleHeight: {$ifNull: ['$siasdata.itemDetail.tags.Ankle Height' -']} \n closure: {$ifNull: ['$siasdata.itemDetail.tags.Closure' -']} \n compartments: {$ifNull: ['$siasdata.itemDetail.tags.Compartments' -']} \n variationsTitle: {$switch: {branches: [\n {case: {$eq: [{$arrayElemAt: ['$siasdata.itemDetail.variations.uuid' 0]} $variationUuid']} then: {$arrayElemAt: ['$siasdata.itemDetail.variations.title' 0]}} \n {case: {$eq: [{$arrayElemAt: ['$siasdata.itemDetail.variations.uuid' 1]} $variationUuid']} then: {$arrayElemAt: ['$siasdata.itemDetail.variations.title' 1]}} \n {case: {$eq: [{$arrayElemAt: ['$siasdata.itemDetail.variations.uuid' 2]} $variationUuid']} then: {$arrayElemAt: ['$siasdata.itemDetail.variations.title' 2]}} \n {case: {$eq: [{$arrayElemAt: ['$siasdata.itemDetail.variations.uuid' 3]} $variationUuid']} then: {$arrayElemAt: ['$siasdata.itemDetail.variations.title' 3]}} \n {case: {$eq: [{$arrayElemAt: ['$siasdata.itemDetail.variations.uuid' 4]} $variationUuid']} then: {$arrayElemAt: ['$siasdata.itemDetail.variations.title' 4]}} \n {case: {$eq: [{$arrayElemAt: ['$siasdata.itemDetail.variations.uuid' 5]} $variationUuid']} then: {$arrayElemAt: ['$siasdata.itemDetail.variations.title' 5]}} \n {case: {$eq: [{$arrayElemAt: ['$siasdata.itemDetail.variations.uuid' 6]} $variationUuid']} then: {$arrayElemAt: ['$siasdata.itemDetail.variations.title' 6]}} \n {case: {$eq: [{$arrayElemAt: ['$siasdata.itemDetail.variations.uuid' 7]} $variationUuid']} then: {$arrayElemAt: ['$siasdata.itemDetail.variations.title' 7]}} \n {case: {$eq: [{$arrayElemAt: ['$siasdata.itemDetail.variations.uuid' 8]} $variationUuid']} then: {$arrayElemAt: ['$siasdata.itemDetail.variations.title' 8]}} \n {case: {$eq: [{$arrayElemAt: ['$siasdata.itemDetail.variations.uuid' 9]} $variationUuid']} then: {$arrayElemAt: ['$siasdata.itemDetail.variations.title' 9]}} \n {case: {$eq: [{$arrayElemAt: ['$siasdata.itemDetail.variations.uuid' 10]} $variationUuid']} then: {$arrayElemAt: ['$siasdata.itemDetail.variations.title' 10]}} \n {case: {$eq: [{$arrayElemAt: ['$siasdata.itemDetail.variations.uuid' 11]} $variationUuid']} then: {$arrayElemAt: ['$siasdata.itemDetail.variations.title' 11]}} \n {case: {$eq: [{$arrayElemAt: ['$siasdata.itemDetail.variations.uuid' 12]} $variationUuid']} then: {$arrayElemAt: ['$siasdata.itemDetail.variations.title' 12]}} \n {case: {$eq: [{$arrayElemAt: ['$siasdata.itemDetail.variations.uuid' 13]} $variationUuid']} then: {$arrayElemAt: ['$siasdata.itemDetail.variations.title' 13]}} \n {case: {$eq: [{$arrayElemAt: ['$siasdata.itemDetail.variations.uuid' 14]} $variationUuid']} then: {$arrayElemAt: ['$siasdata.itemDetail.variations.title' 14]}} \n ] \n default: '-'\n }}\n}}\n\n]" collection:"shops"} viz-settings:{"table.pivot":false table.pivot_column:"shopName" table.cell_column:"compartments" table.column_formatting:[] metabase.shared.models.visualization-settings/column-settings:{} metabase.shared.models.visualization-settings/table-columns:[{"metabase.shared.models.visualization-settings/table-column-name":"shopName" metabase.shared.models.visualization-settings/table-column-field-ref:["field" shopName {"base-type":"type/Text"}] metabase.shared.models.visualization-settings/table-column-enabled:true} {"metabase.shared.models.visualization-settings/table-column-name":"quantityAvailable" metabase.shared.models.visualization-settings/table-column-field-ref:["field" quantityAvailable {"base-type":"type/Integer"}] metabase.shared.models.visualization-settings/table-column-enabled:true} {"metabase.shared.models.visualization-settings/table-column-name":"MRP" metabase.shared.models.visualization-settings/table-column-field-ref:["field" MRP {"base-type":"type/Float"}] metabase.shared.models.visualization-settings/table-column-enabled:true} {"metabase.shared.models.visualization-settings/table-column-name":"sellingPrice" metabase.shared.models.visualization-settings/table-column-field-ref:["field" sellingPrice {"base-type":"type/Float"}] metabase.shared.models.visualization-settings/table-column-enabled:true} {"metabase.shared.models.visualization-settings/table-column-name":"itemName" metabase.shared.models.visualization-settings/table-column-field-ref:["field" itemName {"base-type":"type/Text"}] metabase.shared.models.visualization-settings/table-column-enabled:true} {"metabase.shared.models.visualization-settings/table-column-name":"itemUsId" metabase.shared.models.visualization-settings/table-column-field-ref:["field" itemUsId {"base-type":"type/Text"}] metabase.shared.models.visualization-settings/table-column-enabled:true} {"metabase.shared.models.visualization-settings/table-column-name":"l0CategoryNames" metabase.shared.models.visualization-settings/table-column-field-ref:["field" l0CategoryNames {"base-type":"type/Text"}] metabase.shared.models.visualization-settings/table-column-enabled:true} {"metabase.shared.models.visualization-settings/table-column-name":"l1CategoryNames" metabase.shared.models.visualization-settings/table-column-field-ref:["field" l1CategoryNames {"base-type":"type/Text"}] metabase.shared.models.visualization-settings/table-column-enabled:true} {"metabase.shared.models.visualization-settings/table-column-name":"l2CategoryNames" metabase.shared.models.visualization-settings/table-column-field-ref:["field" l2CategoryNames {"base-type":"type/Text"}] metabase.shared.models.visualization-settings/table-column-enabled:true} {"metabase.shared.models.visualization-settings/table-column-name":"description" metabase.shared.models.visualization-settings/table-column-field-ref:["field" description {"base-type":"type/Text"}] metabase.shared.models.visualization-settings/table-column-enabled:true} {"metabase.shared.models.visualization-settings/table-column-name":"imageCount" metabase.shared.models.visualization-settings/table-column-field-ref:["field" imageCount {"base-type":"type/Integer"}] metabase.shared.models.visualization-settings/table-column-enabled:true} {"metabase.shared.models.visualization-settings/table-column-name":"images" metabase.shared.models.visualization-settings/table-column-field-ref:["field" images {"base-type":"type/Array"}] metabase.shared.models.visualization-settings/table-column-enabled:true} {"metabase.shared.models.visualization-settings/table-column-name":"sizeChart" metabase.shared.models.visualization-settings/table-column-field-ref:["field" sizeChart {"base-type":"type/Text"}] metabase.shared.models.visualization-settings/table-column-enabled:true} {"metabase.shared.models.visualization-settings/table-column-name":"material" metabase.shared.models.visualization-settings/table-column-field-ref:["field" material {"base-type":"type/Text"}] metabase.shared.models.visualization-settings/table-column-enabled:true} {"metabase.shared.models.visualization-settings/table-column-name":"sizing" metabase.shared.models.visualization-settings/table-column-field-ref:["field" sizing {"base-type":"type/Text"}] metabase.shared.models.visualization-settings/table-column-enabled:true} {"metabase.shared.models.visualization-settings/table-column-name":"color" metabase.shared.models.visualization-settings/table-column-field-ref:["field" color {"base-type":"type/Text"}] metabase.shared.models.visualization-settings/table-column-enabled:true} {"metabase.shared.models.visualization-settings/table-column-name":"style" metabase.shared.models.visualization-settings/table-column-field-ref:["field" style {"base-type":"type/Text"}] metabase.shared.models.visualization-settings/table-column-enabled:true} {"metabase.shared.models.visualization-settings/table-column-name":"Pattern" metabase.shared.models.visualization-settings/table-column-field-ref:["field" Pattern {"base-type":"type/Text"}] metabase.shared.models.visualization-settings/table-column-enabled:true} {"metabase.shared.models.visualization-settings/table-column-name":"PackageIncludes" metabase.shared.models.visualization-settings/table-column-field-ref:["field" PackageIncludes {"base-type":"type/Text"}] metabase.shared.models.visualization-settings/table-column-enabled:true} {"metabase.shared.models.visualization-settings/table-column-name":"careInstructions" metabase.shared.models.visualization-settings/table-column-field-ref:["field" careInstructions {"base-type":"type/Text"}] metabase.shared.models.visualization-settings/table-column-enabled:true} {"metabase.shared.models.visualization-settings/table-column-name":"origin" metabase.shared.models.visualization-settings/table-column-field-ref:["field" origin {"base-type":"type/Text"}] metabase.shared.models.visualization-settings/table-column-enabled:true} {"metabase.shared.models.visualization-settings/table-column-name":"benefits" metabase.shared.models.visualization-settings/table-column-field-ref:["field" benefits {"base-type":"type/Text"}] metabase.shared.models.visualization-settings/table-column-enabled:true} {"metabase.shared.models.visualization-settings/table-column-name":"ingredients" metabase.shared.models.visualization-settings/table-column-field-ref:["field" ingredients {"base-type":"type/Text"}] metabase.shared.models.visualization-settings/table-column-enabled:true} {"metabase.shared.models.visualization-settings/table-column-name":"recommendedFor" metabase.shared.models.visualization-settings/table-column-field-ref:["field" recommendedFor {"base-type":"type/Text"}] metabase.shared.models.visualization-settings/table-column-enabled:true} {"metabase.shared.models.visualization-settings/table-column-name":"fragranceNotes" metabase.shared.models.visualization-settings/table-column-field-ref:["field" fragranceNotes {"base-type":"type/Text"}] metabase.shared.models.visualization-settings/table-column-enabled:true} {"metabase.shared.models.visualization-settings/table-column-name":"howToUse" metabase.shared.models.visualization-settings/table-column-field-ref:["field" howToUse {"base-type":"type/Text"}] metabase.shared.models.visualization-settings/table-column-enabled:true} {"metabase.shared.models.visualization-settings/table-column-name":"shelfLife" metabase.shared.models.visualization-settings/table-column-field-ref:["field" shelfLife {"base-type":"type/Text"}] metabase.shared.models.visualization-settings/table-column-enabled:true} {"metabase.shared.models.visualization-settings/table-column-name":"veg_NonVeg" metabase.shared.models.visualization-settings/table-column-field-ref:["field" veg_NonVeg {"base-type":"type/Text"}] metabase.shared.models.visualization-settings/table-column-enabled:true} {"metabase.shared.models.visualization-settings/table-column-name":"ingredeients_Food" metabase.shared.models.visualization-settings/table-column-field-ref:["field" ingredeients_Food {"base-type":"type/Text"}] metabase.shared.models.visualization-settings/table-column-enabled:true} {"metabase.shared.models.visualization-settings/table-column-name":"weight" metabase.shared.models.visualization-settings/table-column-field-ref:["field" weight {"base-type":"type/Text"}] metabase.shared.models.visualization-settings/table-column-enabled:true} {"metabase.shared.models.visualization-settings/table-column-name":"storageInstructions" metabase.shared.models.visualization-settings/table-column-field-ref:["field" storageInstructions {"base-type":"type/Text"}] metabase.shared.models.visualization-settings/table-column-enabled:true} {"metabase.shared.models.visualization-settings/table-column-name":"nutritionalValue" metabase.shared.models.visualization-settings/table-column-field-ref:["field" nutritionalValue {"base-type":"type/Text"}] metabase.shared.models.visualization-settings/table-column-enabled:true} {"metabase.shared.models.visualization-settings/table-column-name":"flavour" metabase.shared.models.visualization-settings/table-column-field-ref:["field" flavour {"base-type":"type/Text"}] metabase.shared.models.visualization-settings/table-column-enabled:true} {"metabase.shared.models.visualization-settings/table-column-name":"styleType" metabase.shared.models.visualization-settings/table-column-field-ref:["field" styleType {"base-type":"type/Text"}] metabase.shared.models.visualization-settings/table-column-enabled:true} {"metabase.shared.models.visualization-settings/table-column-name":"baseMaterial" metabase.shared.models.visualization-settings/table-column-field-ref:["field" baseMaterial {"base-type":"type/Text"}] metabase.shared.models.visualization-settings/table-column-enabled:true} {"metabase.shared.models.visualization-settings/table-column-name":"platingMaterial" metabase.shared.models.visualization-settings/table-column-field-ref:["field" platingMaterial {"base-type":"type/Text"}] metabase.shared.models.visualization-settings/table-column-enabled:true} {"metabase.shared.models.visualization-settings/table-column-name":"stoneType" metabase.shared.models.visualization-settings/table-column-field-ref:["field" stoneType {"base-type":"type/Text"}] metabase.shared.models.visualization-settings/table-column-enabled:true} {"metabase.shared.models.visualization-settings/table-column-name":"dimensions" metabase.shared.models.visualization-settings/table-column-field-ref:["field" dimensions {"base-type":"type/Text"}] metabase.shared.models.visualization-settings/table-column-enabled:true} {"metabase.shared.models.visualization-settings/table-column-name":"claspType" metabase.shared.models.visualization-settings/table-column-field-ref:["field" claspType {"base-type":"type/Text"}] metabase.shared.models.visualization-settings/table-column-enabled:true} {"metabase.shared.models.visualization-settings/table-column-name":"occassion" metabase.shared.models.visualization-settings/table-column-field-ref:["field" occassion {"base-type":"type/Text"}] metabase.shared.models.visualization-settings/table-column-enabled:true} {"metabase.shared.models.visualization-settings/table-column-name":"features" metabase.shared.models.visualization-settings/table-column-field-ref:["field" features {"base-type":"type/Text"}] metabase.shared.models.visualization-settings/table-column-enabled:true} {"metabase.shared.models.visualization-settings/table-column-name":"toeShape" metabase.shared.models.visualization-settings/table-column-field-ref:["field" toeShape {"base-type":"type/Text"}] metabase.shared.models.visualization-settings/table-column-enabled:true} {"metabase.shared.models.visualization-settings/table-column-name":"fasteningType" metabase.shared.models.visualization-settings/table-column-field-ref:["field" fasteningType {"base-type":"type/Text"}] metabase.shared.models.visualization-settings/table-column-enabled:true} {"metabase.shared.models.visualization-settings/table-column-name":"soleMaterial" metabase.shared.models.visualization-settings/table-column-field-ref:["field" soleMaterial {"base-type":"type/Text"}] metabase.shared.models.visualization-settings/table-column-enabled:true} {"metabase.shared.models.visualization-settings/table-column-name":"otherMaterials" metabase.shared.models.visualization-settings/table-column-field-ref:["field" otherMaterials {"base-type":"type/Text"}] metabase.shared.models.visualization-settings/table-column-enabled:true} {"metabase.shared.models.visualization-settings/table-column-name":"ankleHeight" metabase.shared.models.visualization-settings/table-column-field-ref:["field" ankleHeight {"base-type":"type/Text"}] metabase.shared.models.visualization-settings/table-column-enabled:true} {"metabase.shared.models.visualization-settings/table-column-name":"closure" metabase.shared.models.visualization-settings/table-column-field-ref:["field" closure {"base-type":"type/Text"}] metabase.shared.models.visualization-settings/table-column-enabled:true} {"metabase.shared.models.visualization-settings/table-column-name":"compartments" metabase.shared.models.visualization-settings/table-column-field-ref:["field" compartments {"base-type":"type/Text"}] metabase.shared.models.visualization-settings/table-column-enabled:true}]} database:4 parameters:[{"type":"category" value:["Astrid Bags"] target:["dimension" ["template-tag" name]] id:"2998ca3c-2c79-3cd2-ac4d-d7bc0407d012"}] async?:true cache-ttl:713} status:"failed" class:"class clojure.lang.ExceptionInfo" stacktrace:["--> query_processor.middleware.permissions$perms_exception.invokeStatic(permissions.clj:29)" query_processor.middleware.permissions$perms_exception.doInvoke(permissions.clj:24) query_processor.middleware.permissions$perms_exception.invokeStatic(permissions.clj:26) query_processor.middleware.permissions$perms_exception.invoke(permissions.clj:24) query_processor.middleware.permissions$fn__46235$check_ad_hoc_query_perms__46240$fn__46241.invoke(permissions.clj:83) query_processor.middleware.permissions$fn__46235$check_ad_hoc_query_perms__46240.invoke(permissions.clj:79) query_processor.middleware.permissions$fn__46267$check_query_permissions_STAR___46272$fn__46273.invoke(permissions.clj:98) query_processor.middleware.permissions$fn__46267$check_query_permissions_STAR___46272.invoke(permissions.clj:88) query_processor.middleware.permissions$check_query_permissions$fn__46286.invoke(permissions.clj:107) query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__51011.invoke(pre_alias_aggregations.clj:40) query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__46682.invoke(cumulative_aggregations.clj:60) query_processor.middleware.visualization_settings$update_viz_settings$fn__46620.invoke(visualization_settings.clj:62) query_processor.middleware.escape_join_aliases$escape_join_aliases_middleware$fn__48037.invoke(escape_join_aliases.clj:67) query_processor.middleware.fix_bad_references$fix_bad_references_middleware$fn__50976.invoke(fix_bad_references.clj:91) query_processor.middleware.resolve_joined_fields$resolve_joined_fields$fn__47567.invoke(resolve_joined_fields.clj:111) query_processor.middleware.resolve_joins$resolve_joins$fn__51592.invoke(resolve_joins.clj:178) query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__51134.invoke(add_implicit_joins.clj:193) query_processor.middleware.large_int_id$convert_id_to_string$fn__47586.invoke(large_int_id.clj:59) query_processor.middleware.format_rows$format_rows$fn__51186.invoke(format_rows.clj:74) query_processor.middleware.add_default_temporal_unit$add_default_temporal_unit$fn__46954.invoke(add_default_temporal_unit.clj:23) query_processor.middleware.desugar$desugar$fn__46593.invoke(desugar.clj:21) query_processor.middleware.binning$update_binning_strategy$fn__39507.invoke(binning.clj:229) query_processor.middleware.resolve_fields$resolve_fields$fn__45928.invoke(resolve_fields.clj:34) query_processor.middleware.add_dimension_projections$add_remapping$fn__50343.invoke(add_dimension_projections.clj:487) query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__50637.invoke(add_implicit_clauses.clj:164) query_processor.middleware.upgrade_field_literals$upgrade_field_literals$fn__47974.invoke(upgrade_field_literals.clj:117) query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__47331.invoke(add_source_metadata.clj:125) query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__50888.invoke(reconcile_breakout_and_order_by_bucketing.clj:100) query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__48975.invoke(auto_bucket_datetimes.clj:147) query_processor.middleware.resolve_source_table$resolve_source_tables$fn__45909.invoke(resolve_source_table.clj:45) query_processor.middleware.parameters$substitute_parameters$fn__48629.invoke(parameters.clj:109) query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__45982.invoke(resolve_referenced.clj:79) query_processor.middleware.expand_macros$expand_macros$fn__52250.invoke(expand_macros.clj:184) query_processor.middleware.add_timezone_info$add_timezone_info$fn__48409.invoke(add_timezone_info.clj:15) query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__51201.invoke(splice_params_in_response.clj:32) query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__50648$fn__50653.invoke(resolve_database_and_driver.clj:35) driver$do_with_driver.invokeStatic(driver.clj:60) driver$do_with_driver.invoke(driver.clj:56) query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__50648.invoke(resolve_database_and_driver.clj:34) query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__46528.invoke(fetch_source_query.clj:286) query_processor.middleware.store$initialize_store$fn__46719$fn__46720.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__46719.invoke(store.clj:10) query_processor.middleware.validate$validate_query$fn__50983.invoke(validate.clj:10) query_processor.middleware.normalize_query$normalize$fn__50990.invoke(normalize_query.clj:22) query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__48355.invoke(add_rows_truncated.clj:35) query_processor.middleware.results_metadata$record_and_return_metadata_BANG$fn__49646.invoke(results_metadata.clj:78) query_processor.middleware.constraints$add_default_userland_constraints$fn__48373.invoke(constraints.clj:42) query_processor.middleware.process_userland_query$process_userland_query$fn__50924.invoke(process_userland_query.clj:146) query_processor.middleware.catch_exceptions$catch_exceptions$fn__51281.invoke(catch_exceptions.clj:169) query_processor.reducible$async_qp$qp_STAR___43280$thunk__43281.invoke(reducible.clj:103) query_processor.reducible$async_qp$qp_STAR___43280$fn__43283.invoke(reducible.clj:108)] card_id:null context:"xlsx-download" error:"You do not have permissions to run this query." row_count:0 running_time:0 ex-data:{"type":"missing-required-permissions" required-permissions:["/db/4/native/"] actual-permissions:["/collection/13/" /db/4/schema/ /collection/67/ /collection/root/ /db/2/schema/ /db/3/schema/ /collection/89/ /collection/14/ /collection/57/ /collection/11/ /db/5/ /collection/76/ /collection/70/] permissions-error?:true} data:{"rows":[] cols:[]}}

{
"browser-info": {
"language": "en-IN",
"platform": "MacIntel",
"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/97.0.4692.71 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.14.1+1",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.14.1",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.14.1+1",
"os.name": "Linux",
"os.version": "4.14.248-189.473.amzn2.x86_64",
"user.language": "en",
"user.timezone": "UTC"
},
"metabase-info": {
"databases": [
"googleanalytics",
"mongo"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "10.17"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.2.23"
}
},
"run-mode": "prod",
"version": {
"date": "2022-02-17",
"tag": "v0.42.1",
"branch": "release-x.42.x",
"hash": "629f4de"
},
"settings": {
"report-timezone": "Asia/Calcutta"
}
}
}

@mustaq.ansari The stacktrace is completely mangled in the format, but it looks like you're seeing this issue:
https://github.com/metabase/metabase/issues/20643

Looks like everything is fine.

Also, being an Administrator, I get the downloads as it shows in the query. Problem arises with some of the default users.

@mustaq.ansari Then the error needs to triggered and then you need to include the full stacktrace from Admin > Troubleshooting > Logs.

I'm not sure why the question is unsaved. Something makes me think that you're seeing this issue:
https://github.com/metabase/metabase/issues/18433#issuecomment-945868661

Hi. I'am not able to get the recent logs. Can you please help?

@mustaq.ansari Without logs it's difficult.

Include the metadata from the question by going to the URL /api/card/123, where 123 is the question ID.

And create a new user with similar permissions to those having problems and login with that user to trigger the problem.

Did that. Found out it's happening because whenever a value is feeded in the filter, it starts a new question and then the user has to save the question and reload it again. This solves the issue but it is not a recommended solution. I don't want my default users to have the access to save questions.

Is there a permanent fix to this problem of new question being created when we use filters?

@mustaq.ansari Without you providing metadata or logs or steps-to-reproduce, then I cannot help.
It very much sounds like you're seeing https://github.com/metabase/metabase/issues/18433#issuecomment-945868661

{:database_id 4,
:started_at #t "2022-02-25T07:38:57.626697Z[UTC]",
:json_query
{:constraints nil,
:type :native,
:middleware
{:js-int-to-string? false,
:ignore-cached-results? true,
:process-viz-settings? true,
:skip-results-metadata? true,
:format-rows? false},
:native
{:template-tags
{"startDate"
{:id "32332ab9-aa20-a00b-c09b-2883105355d9",
:name "startDate",
:display-name "Startdate",
:type :date,
:default "2021-07-01",
:required true},
"endDate"
{:id "dcaad17c-e9ec-6165-4dff-cfeae449a262",
:name "endDate",
:display-name "Enddate",
:type :date,
:required true,
:default "2021-12-31"},
"category"
{:id "de8ceb1c-9734-8401-9b8d-be88eab611e7",
:name "category",
:display-name "Category",
:type :text,
:required true,
:default "All"}},
:query
"[\n{$match: {level: 0}}\n\n{$facet: {\n 'new': [\n {$project: {\n _id: 1,\n name: 'All'\n }}],\n 'old': [\n {$project: {\n _id: 1,\n name: 1\n }}]\n}}\n\n{$project: {\n items: {$concatArrays: ['$new', '$old']}\n}}\n\n{$unwind: '$items'}\n\n{$project: {\n _id: '$items._id',\n name: '$items.name'\n}}\n\n{$match: {name: {{category}}}}\n\n{$lookup: {from: 'sias', localField: '_id', foreignField: 'itemDetail.categories', as: 'siasdata'}}\n{$unwind: '$siasdata'}\n\n{$match: {'siasdata.deleted_at': null}}\n{$match: {$or: [{'siasdata.isResellerShop': false}, {'siasdata.isResellerShop': {$exists: false}}]}}\n\n{$project: {\n categoryName: '$name',\n categories: '$siasdata.itemDetail.categories',\n active: '$siasdata.active',\n itemName: '$siasdata.itemDetail.name',\n parentType: '$siasdata.itemDetail.parentType',\n parent: '$siasdata.itemDetail.parent',\n itemCreated_at: {$add: ['$siasdata.created_at', 19800000]}\n}}\n\n{$match: {$expr: {$and: [{$gte: ['$itemCreated_at', {{startDate}}]},\n {$lt: ['$itemCreated_at', {$add : [{{endDate}} , 86400000]}]}]}}}\n\n{$unwind: '$categories'}\n{$lookup: {from: 'categories', localField: 'categories', foreignField: '_id', as: 'categoriesdata'}}\n{$unwind: {path: '$catgoriesdata', preserveNullAndEmptyArrays: true}}\n\n{$match: {'categoriesdata.level': 2}}\n\n{$project: {\n l1CategoryName: '$categoryName',\n l2CategoryId: '$categoriesdata._id',\n l2CategoryName: '$categoriesdata.name',\n active: 1,\n itemName: 1,\n parentType: 1,\n parent: 1,\n itemCreated_at: 1,\n l2Category: {$zip: {'inputs': ['$categoriesdata._id', '$categoriesdata.name']}}\n}}\n\n{$unwind: '$l2CategoryId'}\n{$unwind: '$l2CategoryName'}\n\n{$group: {\n _id: '$l1CategoryName',\n l2Category: {$push: '$l2Category'},\n totalItemCount: {$sum: 1}\n}}\n\n{$unwind: '$l2Category'}\n{$unwind: '$l2Category'}\n\n{$project: {\n _id: 0\n L0Category: '$_id',\n L2CategoryId: {$arrayElemAt: ['$l2Category', 0]},\n L2Category: {$arrayElemAt: ['$l2Category', 1]},\n totalItemCount: 1\n}}\n\n{$group: {\n _id: '$L2CategoryId',\n L2Category: {$first: '$L2Category'},\n totalItemCount: {$first: '$totalItemCount'},\n itemCount: {$sum: 1}\n}}\n\n{$project: {\n _id: 0,\n l2Category: '$L2Category',\n itemCount: 1,\n itemCountPercentage: {$round: [{$multiply: [{$divide: ['$itemCount', '$totalItemCount']}, 100]}, 2]},\n l2CategoryId: '$_id'\n}}\n\n{$lookup: {from: 'sias', localField: 'l2CategoryId', foreignField: 'itemDetail.categories', as: 'siasdata'}}\n{$unwind: {path: '$siasdata', preserveNullAndEmptyArrays: true}}\n\n{$project: {\n itemCount: 1,\n itemCountPercentage: 1,\n l2CategoryId: 1,\n l2Category: 1,\n itemsId: 1,\n price: {$divide: [{$arrayElemAt: ['$siasdata.meta.bestPrice.sellingPrice', 0]},100]},\n marketplaceActiveItem: {$cond: {if: {$and: [{$eq: ['$siasdata.marketplaceActive', true]}, {$eq: ['$siasdata.shopActive', true]}]},\n then: 1,\n else: 0}},\n shopId: '$siasdata.shop',\n shopActive: {$cond: {if: {$and: [{$eq: ['$siasdata.shopActive', true]}, {$eq: ['$siasdata.deleted_at', null]}]},\n then: '$siasdata.shop',\n else: null}}\n}}\n\n{$group: {\n _id: '$l2CategoryId',\n l2Category: {$first: '$l2Category'},\n itemCount: {$first: '$itemCount'},\n itemCountPercentage: {$first: '$itemCountPercentage'},\n avgPrice: {$avg: '$price'},\n marketplaceActiveItem: {$sum: '$marketplaceActiveItem'},\n shopId: {$addToSet: '$shopId'},\n shopActive: {$addToSet: '$shopActive'}\n}}\n\n{$project: {\n id: 0,\n categoryName: '$l2Category',\n itemCount: 1,\n itemCountPercentage: 1,\n avgPrice: 1,\n marketplaceActiveItem: 1,\n sellerCount: {$size: '$shopId'},\n marketplaceActiveSeller: {$size: {$filter: {input: '$shopActive', as: 'd', cond: {$ne: ['$$d', null]}}}}\n}}\n]",
:collection "categories"},
:database 4,
:parameters nil,
:async? true,
:cache-ttl 141022},
:status :failed,
:class com.mongodb.MongoExecutionTimeoutException,
:stacktrace
["com.mongodb.internal.connection.ProtocolHelper.createSpecialException(ProtocolHelper.java:243)"
"com.mongodb.internal.connection.ProtocolHelper.getCommandFailureException(ProtocolHelper.java:175)"
"com.mongodb.internal.connection.InternalStreamConnection.receiveCommandMessageResponse(InternalStreamConnection.java:299)"
"com.mongodb.internal.connection.InternalStreamConnection.sendAndReceive(InternalStreamConnection.java:255)"
"com.mongodb.internal.connection.UsageTrackingInternalConnection.sendAndReceive(UsageTrackingInternalConnection.java:99)"
"com.mongodb.internal.connection.DefaultConnectionPool$PooledConnection.sendAndReceive(DefaultConnectionPool.java:444)"
"com.mongodb.internal.connection.CommandProtocolImpl.execute(CommandProtocolImpl.java:72)"
"com.mongodb.internal.connection.DefaultServer$DefaultServerProtocolExecutor.execute(DefaultServer.java:200)"
"com.mongodb.internal.connection.DefaultServerConnection.executeProtocol(DefaultServerConnection.java:269)"
"com.mongodb.internal.connection.DefaultServerConnection.command(DefaultServerConnection.java:131)"
"com.mongodb.internal.connection.DefaultServerConnection.command(DefaultServerConnection.java:123)"
"com.mongodb.operation.CommandOperationHelper.executeWrappedCommandProtocol(CommandOperationHelper.java:242)"
"com.mongodb.operation.CommandOperationHelper.executeWrappedCommandProtocol(CommandOperationHelper.java:233)"
"com.mongodb.operation.CommandOperationHelper.executeWrappedCommandProtocol(CommandOperationHelper.java:136)"
"com.mongodb.operation.AggregateOperationImpl$1.call(AggregateOperationImpl.java:193)"
"com.mongodb.operation.AggregateOperationImpl$1.call(AggregateOperationImpl.java:189)"
"com.mongodb.operation.OperationHelper.withConnectionSource(OperationHelper.java:462)"
"com.mongodb.operation.OperationHelper.withConnection(OperationHelper.java:406)"
"com.mongodb.operation.AggregateOperationImpl.execute(AggregateOperationImpl.java:189)"
"com.mongodb.operation.AggregateOperation.execute(AggregateOperation.java:295)"
"com.mongodb.operation.AggregateOperation.execute(AggregateOperation.java:41)"
"com.mongodb.client.internal.MongoClientDelegate$DelegateOperationExecutor.execute(MongoClientDelegate.java:179)"
"com.mongodb.client.internal.MongoClientDelegate$DelegateOperationExecutor.execute(MongoClientDelegate.java:161)"
"com.mongodb.DBCollection.aggregate(DBCollection.java:1502)"
"com.mongodb.DBCollection.aggregate(DBCollection.java:1462)"
"com.mongodb.DBCollection.aggregate(DBCollection.java:1447)"
"--> driver.mongo.execute$aggregate.invokeStatic(execute.clj:114)"
"driver.mongo.execute$aggregate.invoke(execute.clj:108)"
"driver.mongo.execute$execute_reducible_query.invokeStatic(execute.clj:163)"
"driver.mongo.execute$execute_reducible_query.invoke(execute.clj:157)"
"driver.mongo$fn__94824$f__93105__auto____94825.invoke(mongo.clj:234)"
"driver.mongo.util$do_with_mongo_connection$fn__93096.invoke(util.clj:218)"
"util.ssh$do_with_ssh_tunnel.invokeStatic(ssh.clj:134)"
"util.ssh$do_with_ssh_tunnel.invoke(ssh.clj:123)"
"driver.mongo.util$do_with_mongo_connection.invokeStatic(util.clj:212)"
"driver.mongo.util$do_with_mongo_connection.invoke(util.clj:207)"
"driver.mongo$fn__94824.invokeStatic(mongo.clj:233)"
"driver.mongo$fn__94824.invoke(mongo.clj:231)"
"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:68)"
"query_processor.context.default$default_runf.invoke(default.clj:66)"
"query_processor.context$runf.invokeStatic(context.clj:45)"
"query_processor.context$runf.invoke(context.clj:39)"
"query_processor.reducible$pivot.invokeStatic(reducible.clj:34)"
"query_processor.reducible$pivot.invoke(reducible.clj:31)"
"query_processor.middleware.mbql_to_native$mbql__GT_native$fn__49660.invoke(mbql_to_native.clj:25)"
"query_processor.middleware.check_features$check_features$fn__50406.invoke(check_features.clj:42)"
"query_processor.middleware.limit$limit$fn__47989.invoke(limit.clj:37)"
"query_processor.middleware.cache$run_query_with_cache.invokeStatic(cache.clj:177)"
"query_processor.middleware.cache$run_query_with_cache.invoke(cache.clj:168)"
"query_processor.middleware.cache$maybe_return_cached_results$fn__50789.invoke(cache.clj:203)"
"query_processor.middleware.optimize_temporal_filters$optimize_temporal_filters$fn__51822.invoke(optimize_temporal_filters.clj:204)"
"query_processor.middleware.validate_temporal_bucketing$validate_temporal_bucketing$fn__51866.invoke(validate_temporal_bucketing.clj:50)"
"query_processor.middleware.auto_parse_filter_values$auto_parse_filter_values$fn__49717.invoke(auto_parse_filter_values.clj:43)"
"query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__39778.invoke(wrap_value_literals.clj:161)"
"query_processor.middleware.annotate$add_column_info$fn__44544.invoke(annotate.clj:659)"
"query_processor.middleware.permissions$check_query_permissions$fn__46286.invoke(permissions.clj:108)"
"query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__51011.invoke(pre_alias_aggregations.clj:40)"
"query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__46682.invoke(cumulative_aggregations.clj:60)"
"query_processor.middleware.visualization_settings$update_viz_settings$fn__46620.invoke(visualization_settings.clj:62)"
"query_processor.middleware.escape_join_aliases$escape_join_aliases_middleware$fn__48037.invoke(escape_join_aliases.clj:67)"
"query_processor.middleware.fix_bad_references$fix_bad_references_middleware$fn__50976.invoke(fix_bad_references.clj:91)"
"query_processor.middleware.resolve_joined_fields$resolve_joined_fields$fn__47567.invoke(resolve_joined_fields.clj:111)"
"query_processor.middleware.resolve_joins$resolve_joins$fn__51592.invoke(resolve_joins.clj:178)"
"query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__51134.invoke(add_implicit_joins.clj:193)"
"query_processor.middleware.large_int_id$convert_id_to_string$fn__47586.invoke(large_int_id.clj:59)"
"query_processor.middleware.format_rows$format_rows$fn__51186.invoke(format_rows.clj:74)"
"query_processor.middleware.add_default_temporal_unit$add_default_temporal_unit$fn__46954.invoke(add_default_temporal_unit.clj:23)"
"query_processor.middleware.desugar$desugar$fn__46593.invoke(desugar.clj:21)"
"query_processor.middleware.binning$update_binning_strategy$fn__39507.invoke(binning.clj:229)"
"query_processor.middleware.resolve_fields$resolve_fields$fn__45928.invoke(resolve_fields.clj:34)"
"query_processor.middleware.add_dimension_projections$add_remapping$fn__50343.invoke(add_dimension_projections.clj:487)"
"query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__50637.invoke(add_implicit_clauses.clj:164)"
"query_processor.middleware.upgrade_field_literals$upgrade_field_literals$fn__47974.invoke(upgrade_field_literals.clj:117)"
"query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__47331.invoke(add_source_metadata.clj:125)"
"query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__50888.invoke(reconcile_breakout_and_order_by_bucketing.clj:100)"
"query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__48975.invoke(auto_bucket_datetimes.clj:147)"
"query_processor.middleware.resolve_source_table$resolve_source_tables$fn__45909.invoke(resolve_source_table.clj:45)"
"query_processor.middleware.parameters$substitute_parameters$fn__48629.invoke(parameters.clj:109)"
"query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__45982.invoke(resolve_referenced.clj:79)"
"query_processor.middleware.expand_macros$expand_macros$fn__52250.invoke(expand_macros.clj:184)"
"query_processor.middleware.add_timezone_info$add_timezone_info$fn__48409.invoke(add_timezone_info.clj:15)"
"query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__51201.invoke(splice_params_in_response.clj:32)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__50648$fn__50653.invoke(resolve_database_and_driver.clj:35)"
"driver$do_with_driver.invokeStatic(driver.clj:60)"
"driver$do_with_driver.invoke(driver.clj:56)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__50648.invoke(resolve_database_and_driver.clj:34)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__46528.invoke(fetch_source_query.clj:286)"
"query_processor.middleware.store$initialize_store$fn__46719$fn__46720.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__46719.invoke(store.clj:10)"
"query_processor.middleware.validate$validate_query$fn__50983.invoke(validate.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__50990.invoke(normalize_query.clj:22)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__48355.invoke(add_rows_truncated.clj:35)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG
$fn__49646.invoke(results_metadata.clj:78)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__48373.invoke(constraints.clj:42)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__50924.invoke(process_userland_query.clj:146)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__51281.invoke(catch_exceptions.clj:169)"
"query_processor.reducible$async_qp$qp_STAR___43280$thunk__43281.invoke(reducible.clj:103)"
"query_processor.reducible$async_qp$qp_STAR___43280$fn__43283.invoke(reducible.clj:108)"],
:card_id 2139,
:context :csv-download,
:error "Error in $cursor stage :: caused by :: operation exceeded time limit",
:row_count 0,
:running_time 0,
:data {:rows [], :cols []}}

@mustaq.ansari That error is operation exceeded time limit, which is coming from Mongo.