Why is my collection in domo brick not syncing with the dataset after enabling the sync?
I created a dataset and attached to the app, Enabled the sync from collection to dataset. Ensured that the data types in dataset matches to that of the schema. However, when I add the inputs, the data in the collections ( App DB) is not syncing with the datasets.
Best Answer
-
Sounds like you have already done a few of the main things needed to troubleshoot the issue. You enabled sync and verified the schema.
I recently posted (still viewable as unanswered) about my brick dataset not showing in the brick with the same schema as I see it outside the brick. It is converting decimals to integers. Double check the dataset from the brick interface to see if the schema the brick is using is truly the same.
Have you checked the data for NULLs or invalid values?- Check Sync Configuration:
- Verify that the sync settings between the app's collection and the Domo dataset are configured correctly. Ensure that the sync option is enabled.
- Review Data Types and Schema:
- Confirm that the data types in the collection match exactly with the dataset schema in Domo. Even small discrepancies can cause sync issues.
- Inspect Data Integrity:
- Ensure that the data being entered into the app’s collection does not contain any invalid or unexpected values that might be causing the sync to fail.
- Check Sync Logs:
- Look at any available logs or error messages from the sync process. These logs can provide specific information about what might be going wrong.
- Validate Collection Updates:
- Ensure that the data in the app's collection is being updated correctly. Sometimes the issue might be with the data input process rather than the sync process.
- Verify Dataset Permissions:
- Check that the permissions for the Domo dataset allow for updates from the app’s collection. There might be access restrictions preventing the sync.
- Update Sync Settings:
- Sometimes reconfiguring or re-enabling the sync settings can resolve issues. Try disabling and then re-enabling the sync.
- Manual Sync Attempt:
- If available, try to manually trigger the sync process to see if that resolves the issue.
- Data Volume and Sync Frequency:
- Check if there is a large volume of data that might be causing delays or timeouts. Adjust the sync frequency if necessary.
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0 - Check Sync Configuration:
Answers
-
Sounds like you have already done a few of the main things needed to troubleshoot the issue. You enabled sync and verified the schema.
I recently posted (still viewable as unanswered) about my brick dataset not showing in the brick with the same schema as I see it outside the brick. It is converting decimals to integers. Double check the dataset from the brick interface to see if the schema the brick is using is truly the same.
Have you checked the data for NULLs or invalid values?- Check Sync Configuration:
- Verify that the sync settings between the app's collection and the Domo dataset are configured correctly. Ensure that the sync option is enabled.
- Review Data Types and Schema:
- Confirm that the data types in the collection match exactly with the dataset schema in Domo. Even small discrepancies can cause sync issues.
- Inspect Data Integrity:
- Ensure that the data being entered into the app’s collection does not contain any invalid or unexpected values that might be causing the sync to fail.
- Check Sync Logs:
- Look at any available logs or error messages from the sync process. These logs can provide specific information about what might be going wrong.
- Validate Collection Updates:
- Ensure that the data in the app's collection is being updated correctly. Sometimes the issue might be with the data input process rather than the sync process.
- Verify Dataset Permissions:
- Check that the permissions for the Domo dataset allow for updates from the app’s collection. There might be access restrictions preventing the sync.
- Update Sync Settings:
- Sometimes reconfiguring or re-enabling the sync settings can resolve issues. Try disabling and then re-enabling the sync.
- Manual Sync Attempt:
- If available, try to manually trigger the sync process to see if that resolves the issue.
- Data Volume and Sync Frequency:
- Check if there is a large volume of data that might be causing delays or timeouts. Adjust the sync frequency if necessary.
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0 - Check Sync Configuration:
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 731 Beast Mode
- 55 App Studio
- 40 Variables
- 682 Automate
- 175 Apps
- 451 APIs & Domo Developer
- 46 Workflows
- 10 DomoAI
- 35 Predict
- 14 Jupyter Workspaces
- 21 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 122 Manage
- 119 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 107 Community Announcements
- 4.8K Archive