Something's gone wrong on question by reverting

Metabase Version : v0.44.0

We got error on question like "Something's gone wrong. We've run into an error. You can try refreshing the page, or just go back." when reverting from histories. Any related errors cannot be found in logs.

The result is available in dashboard, but question itself is error page.
I'm not sure it's related or not, but the message is like "Sorry, you don’t have permission to see that." in the question page when we click the link for this question in dashboard.

Hi @erika
Post "Diagnostic Info" from Admin > Troubleshooting.
And include all related logs from Admin > Troubleshooting > Logs.

Thank you for your reply @flamber .
Here are all the related logs.

[99f30ff4-42d6-45f2-aac8-39ea108859e3] 2022-08-23T17:27:01+09:00 DEBUG metabase.server.middleware.log GET /api/timeline 200 17.1 ms (5 DB calls) App DB connections: 1/15 Jetty threads: 5/50 (11 idle, 0 queued) (165 total active threads) Queries in flight: 0 (0 queued)
[99f30ff4-42d6-45f2-aac8-39ea108859e3] 2022-08-23T17:27:01+09:00 DEBUG metabase.server.middleware.log GET /api/collection/tree 200 72.0 ms (22 DB calls) App DB connections: 1/15 Jetty threads: 4/50 (12 idle, 0 queued) (165 total active threads) Queries in flight: 0 (0 queued)
[99f30ff4-42d6-45f2-aac8-39ea108859e3] 2022-08-23T17:27:01+09:00 DEBUG metabase.server.middleware.log GET /api/card/41 200 47.3 ms (10 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (13 idle, 0 queued) (165 total active threads) Queries in flight: 0 (0 queued)
[99f30ff4-42d6-45f2-aac8-39ea108859e3] 2022-08-23T17:27:01+09:00 DEBUG metabase.server.middleware.log GET /api/alert/question/41 200 4.1 ms (1 DB calls) App DB connections: 2/15 Jetty threads: 5/50 (11 idle, 0 queued) (165 total active threads) Queries in flight: 0 (0 queued)
[99f30ff4-42d6-45f2-aac8-39ea108859e3] 2022-08-23T17:27:01+09:00 DEBUG metabase.server.middleware.log GET /api/database/2/schemas 200 30.0 ms (4 DB calls) App DB connections: 1/15 Jetty threads: 4/50 (12 idle, 0 queued) (165 total active threads) Queries in flight: 0 (0 queued)
[99f30ff4-42d6-45f2-aac8-39ea108859e3] 2022-08-23T17:27:01+09:00 DEBUG metabase.server.middleware.log GET /api/table/49/query_metadata 200 44.7 ms (9 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (13 idle, 0 queued) (165 total active threads) Queries in flight: 0 (0 queued)

@erika

  1. Post "Diagnostic Info" from Admin > Troubleshooting. Latest release is 0.44.1
  2. Which version did you upgrade from?
  3. The logs do not indicate a revert. There should be a POST request.
  1. Post "Diagnostic Info" from Admin > Troubleshooting. Latest release is 0.44.1
    Oh sorry I missed "Diagnostic Info".... Here is the diagnostic info.
{
  "browser-info": {
    "language": "ja",
    "platform": "MacIntel",
    "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/104.0.0.0 Safari/537.36",
    "vendor": "Google Inc."
  },
  "system-info": {
    "file.encoding": "UTF-8",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "11.0.16+8",
    "java.vendor": "Eclipse Adoptium",
    "java.vendor.url": "https://adoptium.net/",
    "java.version": "11.0.16",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11.0.16+8",
    "os.name": "Linux",
    "os.version": "4.14.281-212.502.amzn2.x86_64",
    "user.language": "en",
    "user.timezone": "GMT"
  },
  "metabase-info": {
    "databases": [
      "bigquery-cloud-sdk"
    ],
    "hosting-env": "unknown",
    "application-database": "mysql",
    "application-database-details": {
      "database": {
        "name": "MariaDB",
        "version": "10.4.21-MariaDB-log"
      },
      "jdbc-driver": {
        "name": "MariaDB Connector/J",
        "version": "2.7.5"
      }
    },
    "run-mode": "prod",
    "version": {
      "date": "2022-08-04",
      "tag": "v0.44.0",
      "branch": "release-x.44.x",
      "hash": "d3700f5"
    },
    "settings": {
      "report-timezone": "Asia/Tokyo"
    }
  }
}
  1. Which version did you upgrade from?
  2. The logs do not indicate a revert. There should be a POST request.

We reverted the version of specific question from its histories.
It's been in error ever since once it is reverted.

I tried to find the logs that indicates reverting, but couldn't because of limitations on log retention periods.

@erika It sounds like you have reverted a question to a previous revision from long ago, which caused a corruption on the question.

You would have to look in the Metabase application database and compare the changes in revision with report_card where the active question lives.

I cannot tell what the problem is without seeing the revision.object or report_card.dataset_query

@flamber

Sorry for the late reply.
Please check the below data about revision and report_card.
( ***masked*** means masked data)

revision

[
	{
		"id" : 202,
		"model" : "Card",
		"model_id" : 41,
		"user_id" : 8,
		"timestamp" : "2022-02-27 05:12:26.000000",
		"object" : "{\"description\":null,\"archived\":false,\"collection_position\":null,\"table_id\":49,\"database_id\":2,\"enable_embedding\":false,\"collection_id\":18,\"query_type\":\"query\",\"name\":\"***masked***\",\"creator_id\":1,\"made_public_by_id\":null,\"embedding_params\":null,\"cache_ttl\":null,\"dataset_query\":{\"database\":2,\"query\":{\"source-table\":49,\"aggregation\":[[\"distinct\",[\"field\",414,null]]]},\"type\":\"query\"},\"id\":41,\"display\":\"scalar\",\"visualization_settings\":{},\"public_uuid\":null}",
		"is_reversion" : "0",
		"is_creation" : "0",
		"message" : null
	},
	{
		"id" : 255,
		"model" : "Card",
		"model_id" : 41,
		"user_id" : 1,
		"timestamp" : "2022-03-02 06:55:13.000000",
		"object" : "{\"description\":null,\"archived\":false,\"collection_position\":null,\"table_id\":49,\"database_id\":2,\"enable_embedding\":false,\"collection_id\":18,\"query_type\":\"query\",\"name\":\"***masked***\",\"creator_id\":1,\"made_public_by_id\":null,\"embedding_params\":null,\"cache_ttl\":null,\"dataset_query\":{\"type\":\"query\",\"query\":{\"source-table\":49,\"aggregation\":[[\"distinct\",[\"field\",414,null]]],\"filter\":[\"=\",[\"field\",416,null],1]},\"database\":2},\"id\":41,\"display\":\"scalar\",\"visualization_settings\":{},\"public_uuid\":null}",
		"is_reversion" : "0",
		"is_creation" : "0",
		"message" : null
	},
	{
		"id" : 256,
		"model" : "Card",
		"model_id" : 41,
		"user_id" : 1,
		"timestamp" : "2022-03-02 06:57:03.000000",
		"object" : "{\"description\":null,\"archived\":false,\"collection_position\":null,\"table_id\":49,\"database_id\":2,\"enable_embedding\":false,\"collection_id\":18,\"query_type\":\"query\",\"name\":\"***masked***\",\"creator_id\":1,\"made_public_by_id\":null,\"embedding_params\":null,\"cache_ttl\":null,\"dataset_query\":{\"type\":\"query\",\"query\":{\"source-table\":49,\"aggregation\":[[\"distinct\",[\"field\",414,null]]],\"filter\":[\"=\",[\"field\",416,null],1]},\"database\":2},\"id\":41,\"display\":\"scalar\",\"visualization_settings\":{},\"public_uuid\":null}",
		"is_reversion" : "0",
		"is_creation" : "0",
		"message" : null
	},
	{
		"id" : 1000,
		"model" : "Card",
		"model_id" : 41,
		"user_id" : 1,
		"timestamp" : "2022-03-10 07:48:25.000000",
		"object" : "{\"description\":null,\"archived\":false,\"collection_position\":null,\"table_id\":49,\"database_id\":2,\"enable_embedding\":false,\"collection_id\":18,\"query_type\":\"query\",\"name\":\"***masked***\",\"creator_id\":1,\"made_public_by_id\":null,\"embedding_params\":null,\"cache_ttl\":null,\"dataset_query\":{\"type\":\"query\",\"query\":{\"source-table\":49,\"aggregation\":[[\"distinct\",[\"field\",414,null]]],\"filter\":[\"=\",[\"field\",416,null],1]},\"database\":2},\"id\":41,\"display\":\"scalar\",\"visualization_settings\":{},\"public_uuid\":null}",
		"is_reversion" : "0",
		"is_creation" : "0",
		"message" : null
	},
	{
		"id" : 1396,
		"model" : "Card",
		"model_id" : 41,
		"user_id" : 1,
		"timestamp" : "2022-03-15 01:59:25.000000",
		"object" : "{\"description\":null,\"archived\":false,\"collection_position\":null,\"table_id\":49,\"database_id\":2,\"enable_embedding\":false,\"collection_id\":18,\"query_type\":\"query\",\"name\":\"***masked***\",\"creator_id\":1,\"made_public_by_id\":null,\"embedding_params\":null,\"cache_ttl\":null,\"dataset_query\":{\"type\":\"query\",\"query\":{\"source-table\":49,\"aggregation\":[[\"distinct\",[\"field\",414,null]]],\"filter\":[\"=\",[\"field\",416,null],1]},\"database\":2},\"id\":41,\"display\":\"scalar\",\"visualization_settings\":{},\"dataset\":false,\"public_uuid\":null}",
		"is_reversion" : "0",
		"is_creation" : "0",
		"message" : null
	},
	{
		"id" : 2922,
		"model" : "Card",
		"model_id" : 41,
		"user_id" : 1,
		"timestamp" : "2022-04-01 05:38:54.000000",
		"object" : "{\"description\":null,\"archived\":false,\"collection_position\":null,\"table_id\":49,\"database_id\":2,\"enable_embedding\":false,\"collection_id\":18,\"query_type\":\"query\",\"name\":\"***masked***\",\"creator_id\":1,\"made_public_by_id\":null,\"embedding_params\":null,\"cache_ttl\":null,\"dataset_query\":{\"database\":2,\"query\":{\"source-table\":49,\"aggregation\":[[\"distinct\",[\"field\",414,null]]],\"filter\":[\"and\",[\"=\",[\"field\",416,null],1],[\">\",[\"field\",413,null],\"2022-02-21\"]]},\"type\":\"query\"},\"id\":41,\"display\":\"scalar\",\"visualization_settings\":{},\"dataset\":false,\"public_uuid\":null}",
		"is_reversion" : "0",
		"is_creation" : "0",
		"message" : null
	},
	{
		"id" : 11873,
		"model" : "Card",
		"model_id" : 41,
		"user_id" : 7,
		"timestamp" : "2022-08-15 02:02:07.000000",
		"object" : "{\"description\":null,\"archived\":false,\"collection_position\":null,\"table_id\":null,\"database_id\":7,\"enable_embedding\":false,\"collection_id\":18,\"query_type\":\"native\",\"name\":\"***masked***\",\"creator_id\":1,\"made_public_by_id\":null,\"embedding_params\":null,\"cache_ttl\":null,\"dataset_query\":{\"type\":\"native\",\"native\":{\"template-tags\":{\"date\":{\"id\":\"a64c05b9-d3d0-d973-bb23-220e2e24d921\",\"name\":\"date\",\"display-name\":\"Date\",\"type\":\"dimension\",\"dimension\":[\"field\",9437,null],\"widget-type\":\"date/all-options\",\"default\":null}},\"query\":\"***masked***"},\"database\":7},\"id\":41,\"parameter_mappings\":null,\"display\":\"scalar\",\"entity_id\":null,\"collection_preview\":true,\"visualization_settings\":{},\"parameters\":[{\"id\":\"a64c05b9-d3d0-d973-bb23-220e2e24d921\",\"type\":\"date/all-options\",\"target\":[\"dimension\",[\"template-tag\",\"date\"]],\"name\":\"Date\",\"slug\":\"date\"}],\"dataset\":false,\"public_uuid\":null}",
		"is_reversion" : "0",
		"is_creation" : "0",
		"message" : null
	},
	{
		"id" : 11881,
		"model" : "Card",
		"model_id" : 41,
		"user_id" : 7,
		"timestamp" : "2022-08-15 02:12:00.000000",
		"object" : "{\"description\":null,\"archived\":false,\"collection_position\":null,\"table_id\":null,\"database_id\":7,\"enable_embedding\":false,\"collection_id\":18,\"query_type\":\"native\",\"name\":\"***masked***\",\"creator_id\":1,\"made_public_by_id\":null,\"embedding_params\":null,\"cache_ttl\":null,\"dataset_query\":{\"type\":\"native\",\"native\":{\"template-tags\":{\"date\":{\"id\":\"a64c05b9-d3d0-d973-bb23-220e2e24d921\",\"name\":\"date\",\"display-name\":\"Date\",\"type\":\"dimension\",\"dimension\":[\"field\",9437,null],\"widget-type\":\"date/all-options\",\"default\":null}},\"query\":\"***masked***\"},\"database\":7},\"id\":41,\"parameter_mappings\":null,\"display\":\"scalar\",\"entity_id\":null,\"collection_preview\":true,\"visualization_settings\":{},\"parameters\":[{\"id\":\"a64c05b9-d3d0-d973-bb23-220e2e24d921\",\"type\":\"date/all-options\",\"target\":[\"dimension\",[\"template-tag\",\"date\"]],\"name\":\"Date\",\"slug\":\"date\"}],\"dataset\":false,\"public_uuid\":null}",
		"is_reversion" : "0",
		"is_creation" : "0",
		"message" : null
	},
	{
		"id" : 11882,
		"model" : "Card",
		"model_id" : 41,
		"user_id" : 7,
		"timestamp" : "2022-08-15 02:15:32.000000",
		"object" : "{\"description\":null,\"archived\":false,\"collection_position\":null,\"table_id\":null,\"database_id\":7,\"enable_embedding\":false,\"collection_id\":18,\"query_type\":\"native\",\"name\":\"***masked***\",\"creator_id\":1,\"made_public_by_id\":null,\"embedding_params\":null,\"cache_ttl\":null,\"dataset_query\":{\"database\":7,\"native\":{\"query\":\"***masked***\",\"template-tags\":{\"date\":{\"id\":\"de5701d9-76ea-6f03-03f3-08930f4906f7\",\"name\":\"date\",\"display-name\":\"Date\",\"type\":\"dimension\",\"dimension\":[\"field\",9437,null],\"widget-type\":\"date/all-options\",\"default\":null}}},\"type\":\"native\"},\"id\":41,\"parameter_mappings\":null,\"display\":\"scalar\",\"entity_id\":null,\"collection_preview\":true,\"visualization_settings\":{},\"parameters\":[{\"id\":\"de5701d9-76ea-6f03-03f3-08930f4906f7\",\"type\":\"date/all-options\",\"target\":[\"dimension\",[\"template-tag\",\"date\"]],\"name\":\"Date\",\"slug\":\"date\"}],\"dataset\":false,\"public_uuid\":null}",
		"is_reversion" : "0",
		"is_creation" : "0",
		"message" : null
	},
	{
		"id" : 11886,
		"model" : "Card",
		"model_id" : 41,
		"user_id" : 7,
		"timestamp" : "2022-08-15 02:22:52.000000",
		"object" : "{\"description\":null,\"archived\":false,\"collection_position\":null,\"table_id\":null,\"database_id\":7,\"enable_embedding\":false,\"collection_id\":18,\"query_type\":\"native\",\"name\":\"***masked***\",\"creator_id\":1,\"made_public_by_id\":null,\"embedding_params\":null,\"cache_ttl\":null,\"dataset_query\":{\"database\":7,\"native\":{\"query\":\***masked***\",\"template-tags\":{\"date\":{\"id\":\"de5701d9-76ea-6f03-03f3-08930f4906f7\",\"name\":\"date\",\"display-name\":\"Date\",\"type\":\"dimension\",\"dimension\":[\"field\",9437,null],\"widget-type\":\"date/all-options\",\"default\":null}}},\"type\":\"native\"},\"id\":41,\"parameter_mappings\":null,\"display\":\"scalar\",\"entity_id\":null,\"collection_preview\":true,\"visualization_settings\":{},\"parameters\":[{\"id\":\"de5701d9-76ea-6f03-03f3-08930f4906f7\",\"type\":\"date/all-options\",\"target\":[\"dimension\",[\"template-tag\",\"date\"]],\"name\":\"Date\",\"slug\":\"date\"}],\"dataset\":false,\"public_uuid\":null}",
		"is_reversion" : "0",
		"is_creation" : "0",
		"message" : null
	},
	{
		"id" : 11901,
		"model" : "Card",
		"model_id" : 41,
		"user_id" : 7,
		"timestamp" : "2022-08-15 02:36:18.000000",
		"object" : "{\"description\":null,\"archived\":false,\"collection_position\":null,\"table_id\":null,\"database_id\":7,\"enable_embedding\":false,\"collection_id\":18,\"query_type\":\"native\",\"name\":\"***masked***\",\"creator_id\":1,\"made_public_by_id\":null,\"embedding_params\":null,\"cache_ttl\":null,\"dataset_query\":{\"database\":7,\"native\":{\"query\":\"***masked***\",\"template-tags\":{\"date\":{\"id\":\"de5701d9-76ea-6f03-03f3-08930f4906f7\",\"name\":\"date\",\"display-name\":\"Date\",\"type\":\"dimension\",\"dimension\":[\"field\",9437,null],\"widget-type\":\"date/all-options\",\"default\":null}}},\"type\":\"native\"},\"id\":41,\"parameter_mappings\":null,\"display\":\"scalar\",\"entity_id\":null,\"collection_preview\":true,\"visualization_settings\":{},\"parameters\":[{\"id\":\"de5701d9-76ea-6f03-03f3-08930f4906f7\",\"type\":\"date/all-options\",\"target\":[\"dimension\",[\"template-tag\",\"date\"]],\"name\":\"Date\",\"slug\":\"date\"}],\"dataset\":false,\"public_uuid\":null}",
		"is_reversion" : "0",
		"is_creation" : "0",
		"message" : null
	},
	{
		"id" : 11925,
		"model" : "Card",
		"model_id" : 41,
		"user_id" : 7,
		"timestamp" : "2022-08-15 03:29:15.000000",
		"object" : "{\"description\":null,\"archived\":false,\"collection_position\":null,\"table_id\":null,\"database_id\":7,\"enable_embedding\":false,\"collection_id\":18,\"query_type\":\"native\",\"name\":\"***masked***",\"creator_id\":1,\"made_public_by_id\":null,\"embedding_params\":null,\"cache_ttl\":null,\"dataset_query\":{\"database\":7,\"native\":{\"query\":\"***masked***\",\"template-tags\":{\"date\":{\"id\":\"de5701d9-76ea-6f03-03f3-08930f4906f7\",\"name\":\"date\",\"display-name\":\"Date\",\"type\":\"dimension\",\"dimension\":[\"field\",9437,null],\"widget-type\":\"date/all-options\",\"default\":null}}},\"type\":\"native\"},\"id\":41,\"parameter_mappings\":null,\"display\":\"scalar\",\"entity_id\":null,\"collection_preview\":true,\"visualization_settings\":{},\"parameters\":[{\"id\":\"de5701d9-76ea-6f03-03f3-08930f4906f7\",\"type\":\"date/all-options\",\"target\":[\"dimension\",[\"template-tag\",\"date\"]],\"name\":\"Date\",\"slug\":\"date\"}],\"dataset\":false,\"public_uuid\":null}",
		"is_reversion" : "0",
		"is_creation" : "0",
		"message" : null
	},
	{
		"id" : 11926,
		"model" : "Card",
		"model_id" : 41,
		"user_id" : 7,
		"timestamp" : "2022-08-15 03:29:30.000000",
		"object" : "{\"description\":null,\"archived\":false,\"collection_position\":null,\"table_id\":null,\"database_id\":7,\"enable_embedding\":false,\"collection_id\":18,\"query_type\":\"native\",\"name\":\"***masked***\",\"creator_id\":1,\"made_public_by_id\":null,\"embedding_params\":null,\"cache_ttl\":null,\"dataset_query\":{\"database\":7,\"native\":{\"query\":\"***masked***\",\"template-tags\":{\"date\":{\"id\":\"de5701d9-76ea-6f03-03f3-08930f4906f7\",\"name\":\"date\",\"display-name\":\"Date\",\"type\":\"dimension\",\"dimension\":[\"field\",9437,null],\"widget-type\":\"date/all-options\",\"default\":null}}},\"type\":\"native\"},\"id\":41,\"parameter_mappings\":null,\"display\":\"scalar\",\"entity_id\":null,\"collection_preview\":true,\"visualization_settings\":{},\"parameters\":[{\"id\":\"de5701d9-76ea-6f03-03f3-08930f4906f7\",\"type\":\"date/all-options\",\"target\":[\"dimension\",[\"template-tag\",\"date\"]],\"name\":\"Date\",\"slug\":\"date\"}],\"dataset\":false,\"public_uuid\":null}",
		"is_reversion" : "0",
		"is_creation" : "0",
		"message" : null
	},
	{
		"id" : 11927,
		"model" : "Card",
		"model_id" : 41,
		"user_id" : 7,
		"timestamp" : "2022-08-15 03:33:30.000000",
		"object" : "{\"description\":null,\"archived\":false,\"collection_position\":null,\"table_id\":null,\"database_id\":7,\"enable_embedding\":false,\"collection_id\":18,\"query_type\":\"native\",\"name\":\"***masked***\",\"creator_id\":1,\"made_public_by_id\":null,\"embedding_params\":null,\"cache_ttl\":null,\"dataset_query\":{\"database\":7,\"native\":{\"query\":\"***masked***\",\"template-tags\":{\"date\":{\"id\":\"de5701d9-76ea-6f03-03f3-08930f4906f7\",\"name\":\"date\",\"display-name\":\"Date\",\"type\":\"dimension\",\"dimension\":[\"field\",9437,null],\"widget-type\":\"date/all-options\",\"default\":null}}},\"type\":\"native\"},\"id\":41,\"parameter_mappings\":null,\"display\":\"scalar\",\"entity_id\":null,\"collection_preview\":true,\"visualization_settings\":{},\"parameters\":[{\"id\":\"de5701d9-76ea-6f03-03f3-08930f4906f7\",\"type\":\"date/all-options\",\"target\":[\"dimension\",[\"template-tag\",\"date\"]],\"name\":\"Date\",\"slug\":\"date\"}],\"dataset\":false,\"public_uuid\":null}",
		"is_reversion" : "0",
		"is_creation" : "0",
		"message" : null
	},
	{
		"id" : 11928,
		"model" : "Card",
		"model_id" : 41,
		"user_id" : 7,
		"timestamp" : "2022-08-15 03:35:18.000000",
		"object" : "{\"description\":null,\"archived\":false,\"collection_position\":null,\"table_id\":null,\"database_id\":7,\"enable_embedding\":false,\"collection_id\":18,\"query_type\":\"native\",\"name\":\"***masked***\",\"creator_id\":1,\"made_public_by_id\":null,\"embedding_params\":null,\"cache_ttl\":null,\"dataset_query\":{\"database\":7,\"native\":{\"query\":\"***masked***",\"template-tags\":{\"date\":{\"id\":\"de5701d9-76ea-6f03-03f3-08930f4906f7\",\"name\":\"date\",\"display-name\":\"Date\",\"type\":\"dimension\",\"dimension\":[\"field\",9437,null],\"widget-type\":\"date/all-options\",\"default\":null}}},\"type\":\"native\"},\"id\":41,\"parameter_mappings\":null,\"display\":\"scalar\",\"entity_id\":null,\"collection_preview\":true,\"visualization_settings\":{},\"parameters\":[{\"id\":\"de5701d9-76ea-6f03-03f3-08930f4906f7\",\"type\":\"date/all-options\",\"target\":[\"dimension\",[\"template-tag\",\"date\"]],\"name\":\"Date\",\"slug\":\"date\"}],\"dataset\":false,\"public_uuid\":null}",
		"is_reversion" : "0",
		"is_creation" : "0",
		"message" : null
	},
	{
		"id" : 11933,
		"model" : "Card",
		"model_id" : 41,
		"user_id" : 7,
		"timestamp" : "2022-08-15 03:41:53.000000",
		"object" : "{\"description\":null,\"archived\":false,\"collection_position\":null,\"table_id\":49,\"database_id\":2,\"enable_embedding\":false,\"collection_id\":18,\"query_type\":\"query\",\"name\":\"***masked***\",\"creator_id\":1,\"made_public_by_id\":null,\"embedding_params\":null,\"cache_ttl\":null,\"dataset_query\":{\"database\":2,\"query\":{\"source-table\":49,\"aggregation\":[[\"distinct\",[\"field\",414,null]]],\"filter\":[\"and\",[\"=\",[\"field\",416,null],1],[\">\",[\"field\",413,null],\"2022-02-21\"]]},\"type\":\"query\"},\"id\":41,\"display\":\"scalar\",\"visualization_settings\":{},\"dataset\":false,\"public_uuid\":null}",
		"is_reversion" : "1",
		"is_creation" : "0",
		"message" : null
	},
	{
		"id" : 11934,
		"model" : "Card",
		"model_id" : 41,
		"user_id" : 7,
		"timestamp" : "2022-08-15 03:43:25.000000",
		"object" : "{\"description\":null,\"archived\":false,\"collection_position\":null,\"table_id\":null,\"database_id\":7,\"enable_embedding\":false,\"collection_id\":18,\"query_type\":\"native\",\"name\":\"***masked***\",\"creator_id\":1,\"made_public_by_id\":null,\"embedding_params\":null,\"cache_ttl\":null,\"dataset_query\":{\"database\":7,\"native\":{\"query\":\"***masked***\",\"template-tags\":{\"date\":{\"id\":\"de5701d9-76ea-6f03-03f3-08930f4906f7\",\"name\":\"date\",\"display-name\":\"Date\",\"type\":\"dimension\",\"dimension\":[\"field\",9437,null],\"widget-type\":\"date/all-options\",\"default\":null}}},\"type\":\"native\"},\"id\":41,\"parameter_mappings\":null,\"display\":\"scalar\",\"entity_id\":null,\"collection_preview\":true,\"visualization_settings\":{},\"parameters\":[{\"id\":\"de5701d9-76ea-6f03-03f3-08930f4906f7\",\"type\":\"date/all-options\",\"target\":[\"dimension\",[\"template-tag\",\"date\"]],\"name\":\"Date\",\"slug\":\"date\"}],\"dataset\":false,\"public_uuid\":null}",
		"is_reversion" : "1",
		"is_creation" : "0",
		"message" : null
	},
	{
		"id" : 12481,
		"model" : "Card",
		"model_id" : 41,
		"user_id" : 2,
		"timestamp" : "2022-08-22 07:33:07.000000",
		"object" : "{\"description\":null,\"archived\":false,\"collection_position\":null,\"table_id\":49,\"database_id\":2,\"enable_embedding\":false,\"collection_id\":18,\"query_type\":\"query\",\"name\":\"***masked***\",\"creator_id\":1,\"made_public_by_id\":null,\"embedding_params\":null,\"cache_ttl\":null,\"dataset_query\":{\"database\":2,\"query\":{\"source-table\":49,\"aggregation\":[[\"distinct\",[\"field\",414,null]]],\"filter\":[\"and\",[\"=\",[\"field\",416,null],1],[\">\",[\"field\",413,null],\"2022-02-21\"]]},\"type\":\"query\"},\"id\":41,\"display\":\"scalar\",\"visualization_settings\":{},\"dataset\":false,\"public_uuid\":null}",
		"is_reversion" : "1",
		"is_creation" : "0",
		"message" : null
	}
]

report_card

[
	{
		"id" : 41,
		"created_at" : "2022-02-22 08:23:36",
		"updated_at" : "2022-08-30 05:25:17",
		"name" : "***masked***",
		"description" : null,
		"display" : "scalar",
		"dataset_query" : "{\"database\":2,\"query\":{\"source-table\":49,\"aggregation\":[[\"distinct\",[\"field\",414,null]]],\"filter\":[\"and\",[\"=\",[\"field\",416,null],1],[\">\",[\"field\",413,null],\"2022-02-21\"]]},\"type\":\"query\"}",
		"visualization_settings" : "{}",
		"creator_id" : 1,
		"database_id" : 2,
		"table_id" : 49,
		"query_type" : "query",
		"archived" : "0",
		"collection_id" : 18,
		"public_uuid" : null,
		"made_public_by_id" : null,
		"enable_embedding" : "0",
		"embedding_params" : null,
		"cache_ttl" : null,
		"result_metadata" : "***masked***",
		"collection_position" : null,
		"dataset" : "0",
		"entity_id" : null,
		"parameters" : "[{\"id\":\"de5701d9-76ea-6f03-03f3-08930f4906f7\",\"type\":\"date/all-options\",\"target\":[\"dimension\",[\"template-tag\",\"date\"]],\"name\":\"Date\",\"slug\":\"date\"}]",
		"parameter_mappings" : null,
		"collection_preview" : "1"
	}
]

@erika You are trying to revert to a question that was created on a version from a long time ago.
https://github.com/metabase/metabase/issues/16583 - upvote by clicking :+1: on the first post

1 Like

@flamber
Okay I'll follow that issue.
Is there any solution for the question that has already resulted in an error?
Do I have to give it up and create new question?

@erika If you don't have a way of reverting to before you made the previous revert, then yes, it's probably easier to create a new question.

1 Like