Export / Import fails with validation error
See original GitHub issueExport a dashboard with VERSIONED_EXPORT=true. Try importing on same instance or another instance and it fails with a command validation error.
- 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.
- 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:
- Linked to 4 datasets (3 tables and a view) on MySQL
- Has 2 tabs
- Has markdown, big number with timeline, area and barcharts v2 with a filterbox
How to reproduce the bug
- Create a dashboard, save and export it (VERSIONED_EXPORT = true)
- Try to import and fails with a validation error
- 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 version1.4.1 - python version:
python --version3.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:
- Created a year ago
- Comments:10 (10 by maintainers)
Top 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 >
Top Related Medium Post
No results found
Top Related StackOverflow Question
No results found
Troubleshoot Live Code
Lightrun enables developers to add logs, metrics and snapshots to live code - no restarts or redeploys required.
Start Free
Top Related Reddit Thread
No results found
Top Related Hackernoon Post
No results found
Top Related Tweet
No results found
Top Related Dev.to Post
No results found
Top Related Hashnode Post
No results found
Taking a look, sorry for the delay.
cc @betodealmeida @eschutho to take a look at this. The export/import is such an important feature and needs some tlc