Export / Import fails with validation error

See original GitHub issue

Export a dashboard with VERSIONED_EXPORT=true. Try importing on same instance or another instance and it fails with a command validation error.

  1. Based on responses to #19268 from @villebro I reset my dev superset instance. Then created a dashboard from scratch and saved and exported it. I then tried to reimport it and it fails with a command validation error.
  2. I then reset the instance again and then tried to reimport the dashboard on a brand new setup. Fails with same error. The log is set to DEBUG but not very helpful
2022-03-22 10:25:21,789:INFO:werkzeug: * Running on http://127.0.0.1:8088/ (Press CTRL+C to quit)
2022-03-22 10:25:29,502:INFO:werkzeug:127.0.0.1 - - [22/Mar/2022 10:25:29] "GET /dashboard/list/?pageIndex=0&sortColumn=changed_on_delta_humanized&sortOrder=desc&viewMode=table HTTP/1.1" 200 -
2022-03-22 10:25:31,722:INFO:werkzeug:127.0.0.1 - - [22/Mar/2022 10:25:31] "GET /api/v1/dashboard/_info?q=(keys:!(permissions)) HTTP/1.1" 200 -
2022-03-22 10:25:31,727:INFO:werkzeug:127.0.0.1 - - [22/Mar/2022 10:25:31] "GET /api/v1/dashboard/?q=(order_column:changed_on_delta_humanized,order_direction:desc,page:0,page_size:25) HTTP/1.1" 200 -
Command failed validation
2022-03-22 10:25:42,497:INFO:superset.dashboards.commands.importers.dispatcher:Command failed validation
Error importing dashboard
2022-03-22 10:25:42,498:WARNING:superset.views.base:Error importing dashboard
2022-03-22 10:25:42,501:INFO:werkzeug:127.0.0.1 - - [22/Mar/2022 10:25:42] "POST /api/v1/dashboard/import/ HTTP/1.1" 422 -
Command failed validation
2022-03-22 10:25:48,012:INFO:superset.dashboards.commands.importers.dispatcher:Command failed validation
Error importing dashboard
2022-03-22 10:25:48,013:WARNING:superset.views.base:Error importing dashboard
2022-03-22 10:25:48,016:INFO:werkzeug:127.0.0.1 - - [22/Mar/2022 10:25:48] "POST /api/v1/dashboard/import/ HTTP/1.1" 422 -

Details of dashboard:

  1. Linked to 4 datasets (3 tables and a view) on MySQL
  2. Has 2 tabs
  3. Has markdown, big number with timeline, area and barcharts v2 with a filterbox

How to reproduce the bug

  1. Create a dashboard, save and export it (VERSIONED_EXPORT = true)
  2. Try to import and fails with a validation error
  3. The issue is that a simple dashboard with just one or two charts seems to work. A more involved dashboard such as the one I am building fails

Expected results

Import should be successful

Actual results

Fails import

Screenshots

Environment

(please complete the following information):

  • browser type and version: Chrome
  • superset version: superset version 1.4.1
  • python version: python --version 3.8.12
  • node.js version: node -v
  • any feature flags active: VERSIONED_EXPORT

Checklist

Make sure to follow these steps before submitting your issue - thank you!

  • I have checked the superset logs for python stacktraces and included it here as text if there are any.
  • I have reproduced the issue with at least the latest released version of superset.
  • I have checked the issue tracker for the same issue and I haven’t found one similar.

Additional context

If required @villebro please let me know and I can email you an export of the database (data and superset) and a copy of the dashboard zip file

Issue Analytics

  • State:closed
  • Created a year ago
  • Comments:10 (10 by maintainers)

github_iconTop GitHub Comments

1reaction
betodealmeidacommented, Mar 25, 2022

Taking a look, sorry for the delay.

1reaction
srinisubramaniancommented, Mar 23, 2022

cc @betodealmeida @eschutho to take a look at this. The export/import is such an important feature and needs some tlc

Read more comments on GitHub >

github_iconTop Results From Across the Web

Project import fails with Validation errors were found in Jira
Cause. Many factors can lead to a validation error when importing a Project Configuration exported file. Adaptavist lists and suggest fixes to ...
Read more >
encountered an error during import - configuration file
Hi,. I've exported a DC VM from a Hyper V 2012 server which I'm trying to restore on a new server running 2019...
Read more >
Export and Import Validations - Oracle Help Center
Failure of any of these validations will be logged in the ERROR_LOG table. Hard-validations. In case of a validation error under this category,...
Read more >
How to solve validation error while creating import/export ...
While creating or modifying the template of xml file type you may come across some validation errors, this blog will guide you to...
Read more >
Single item import fails with validation errors from other config
Hello, I have a Drupal 8 development site with an error that gets me stuck with migrating content. So I am trying to...
Read more >

github_iconTop Related Medium Post

No results found

github_iconTop Related StackOverflow Question

No results found

github_iconTroubleshoot Live Code

Lightrun enables developers to add logs, metrics and snapshots to live code - no restarts or redeploys required.
Start Free

github_iconTop Related Reddit Thread

No results found

github_iconTop Related Hackernoon Post

No results found

github_iconTop Related Tweet

No results found

github_iconTop Related Dev.to Post

No results found

github_iconTop Related Hashnode Post

No results found