Find solutions to common technical problems encountered while using ChartDB.
Invalid JSON Error During Import
This usually means ChartDB can’t understand the format of the JSON data you’re providing.
Possible Causes:
Troubleshooting Steps:
Verify JSON Syntax
Use an online JSON validator to check your exported JSON for syntax errors. Correct any errors found before importing into ChartDB.
Adjust Database Client Output Settings (SSMS/Azure Data Studio)
Increase the character limit for query results in your database client:
mssql.query.maxCharsToStore
.Re-export and Re-import
After adjusting settings or correcting JSON syntax, re-run the ChartDB export query. Copy the entire JSON output again and paste it into ChartDB.
Try a Different Browser
Test importing the JSON in a different web browser to rule out browser-specific issues.
Missing Tables After Database Import
If your database has multiple schemas, ChartDB might not display all your tables immediately after import.
Possible Cause:
public
schema. Tables in other schemas are hidden initially.Solution:
To display tables from other schemas, you need to select them in the schema management panel.
Steps:
Select Schemas to Display
Go to the tables and fields pages and navigate to the “Managing Schemas” section to learn how to select schemas and display tables from those schemas. Learn more about managing schemas
Missing Relationships After Database Import (PostgreSQL, SQL Server)
Users importing PostgreSQL and SQL Server databases sometimes report that relationships between tables are not automatically detected and visualized.
Possible Causes:
Troubleshooting Steps:
Verify Foreign Key Constraints in your Database
Ensure foreign key constraints are correctly defined in your database. Use a database client to inspect table definitions.
Use Updated Import Query
Try using the updated import query provided by the ChartDB team for your specific database.
Manually Add Relationships in ChartDB
Create relationships manually within ChartDB using drag and drop, right-click, or the side panel.
Check for Naming Conventions
Unconventional naming of foreign key columns might hinder automatic detection.
Diagram Export to PNG/JPG/SVG Fails or Hangs
Sometimes, exporting your diagram to image formats (PNG, JPG, SVG) might fail without a clear error message, or the process might hang.
Possible Causes:
Troubleshooting Steps:
Check Browser Console for Errors
Open your browser’s developer console. Attempt export again. Check the console for JavaScript errors.
Try a Different Browser
Try exporting the diagram using a different web browser.
ChartDB Slow or Crashing with Large Databases
Working with very large database schemas can sometimes lead to performance issues or browser crashes.
Possible Causes:
Recommendations for Handling Large Databases:
Import Only Necessary Schemas/Subsets
If possible, import only the schemas or subsets you need to visualize.
Simplify Diagrams
Break down very large diagrams into smaller, domain-specific diagrams.
Monitor Browser Performance
Observe browser resource usage (CPU, Memory) to identify limitations.
Diagrams Disappear or are Lost After Browser Session
Users sometimes report that their diagrams disappear after closing their browser.
ChartDB cloud version automatically backs up your diagrams in the cloud, while the self-hosted version stores diagrams only in your browser’s local storage and requires manual exports for backup. See our Cloud vs Self-Hosted documentation for more details.
Possible Causes:
Preventing Diagram Loss:
Understand Local Browser Storage
Diagrams are stored locally in your web browser.
Avoid Clearing Browser Data Unintentionally
Be cautious when clearing browser data. Do not clear “Cookies and other site data” to preserve diagrams.
Do Not Use Incognito/Private Browsing for Important Diagrams
Avoid using incognito mode for important diagrams.
Regularly Export Your Diagrams as Backups
Regularly export your diagrams as JSON files. Treat these files as backups.
Find solutions to common technical problems encountered while using ChartDB.
Invalid JSON Error During Import
This usually means ChartDB can’t understand the format of the JSON data you’re providing.
Possible Causes:
Troubleshooting Steps:
Verify JSON Syntax
Use an online JSON validator to check your exported JSON for syntax errors. Correct any errors found before importing into ChartDB.
Adjust Database Client Output Settings (SSMS/Azure Data Studio)
Increase the character limit for query results in your database client:
mssql.query.maxCharsToStore
.Re-export and Re-import
After adjusting settings or correcting JSON syntax, re-run the ChartDB export query. Copy the entire JSON output again and paste it into ChartDB.
Try a Different Browser
Test importing the JSON in a different web browser to rule out browser-specific issues.
Missing Tables After Database Import
If your database has multiple schemas, ChartDB might not display all your tables immediately after import.
Possible Cause:
public
schema. Tables in other schemas are hidden initially.Solution:
To display tables from other schemas, you need to select them in the schema management panel.
Steps:
Select Schemas to Display
Go to the tables and fields pages and navigate to the “Managing Schemas” section to learn how to select schemas and display tables from those schemas. Learn more about managing schemas
Missing Relationships After Database Import (PostgreSQL, SQL Server)
Users importing PostgreSQL and SQL Server databases sometimes report that relationships between tables are not automatically detected and visualized.
Possible Causes:
Troubleshooting Steps:
Verify Foreign Key Constraints in your Database
Ensure foreign key constraints are correctly defined in your database. Use a database client to inspect table definitions.
Use Updated Import Query
Try using the updated import query provided by the ChartDB team for your specific database.
Manually Add Relationships in ChartDB
Create relationships manually within ChartDB using drag and drop, right-click, or the side panel.
Check for Naming Conventions
Unconventional naming of foreign key columns might hinder automatic detection.
Diagram Export to PNG/JPG/SVG Fails or Hangs
Sometimes, exporting your diagram to image formats (PNG, JPG, SVG) might fail without a clear error message, or the process might hang.
Possible Causes:
Troubleshooting Steps:
Check Browser Console for Errors
Open your browser’s developer console. Attempt export again. Check the console for JavaScript errors.
Try a Different Browser
Try exporting the diagram using a different web browser.
ChartDB Slow or Crashing with Large Databases
Working with very large database schemas can sometimes lead to performance issues or browser crashes.
Possible Causes:
Recommendations for Handling Large Databases:
Import Only Necessary Schemas/Subsets
If possible, import only the schemas or subsets you need to visualize.
Simplify Diagrams
Break down very large diagrams into smaller, domain-specific diagrams.
Monitor Browser Performance
Observe browser resource usage (CPU, Memory) to identify limitations.
Diagrams Disappear or are Lost After Browser Session
Users sometimes report that their diagrams disappear after closing their browser.
ChartDB cloud version automatically backs up your diagrams in the cloud, while the self-hosted version stores diagrams only in your browser’s local storage and requires manual exports for backup. See our Cloud vs Self-Hosted documentation for more details.
Possible Causes:
Preventing Diagram Loss:
Understand Local Browser Storage
Diagrams are stored locally in your web browser.
Avoid Clearing Browser Data Unintentionally
Be cautious when clearing browser data. Do not clear “Cookies and other site data” to preserve diagrams.
Do Not Use Incognito/Private Browsing for Important Diagrams
Avoid using incognito mode for important diagrams.
Regularly Export Your Diagrams as Backups
Regularly export your diagrams as JSON files. Treat these files as backups.