Thành Đặng Minh
06/03/2024, 1:47 AMkapa.ai
06/03/2024, 1:48 AMcost_per_conversion_lead
) in the AdsInsights
stream of the Facebook Marketing source. This issue typically arises when trying to access fields that are not supported by the Facebook Marketing API version you are using. Here are some steps you can take to resolve this issue: 1. Check the Fields in the API Documentation: Ensure that the field cost_per_conversion_lead
is a valid field in the Facebook Marketing API. You can refer to the official [Facebook Marketing API documentation](https://developers.facebook.com/docs/marketing-api/insights) to verify the available fields. 2. Update the Connector Version: Make sure you are using the latest version of the Facebook Marketing source connector. Sometimes, newer versions include updates and fixes for such issues. You can check the version you are using and update if necessary. 3. Custom Insights Report: If the field is not available in the default insights, you might need to create a custom insights report and select only the available/required fields. This approach can help bypass limitations with predefined fields. 4. Remove Unsupported Fields: If you have defined custom insights, ensure that unsupported fields are removed from the list. You can follow these steps to update custom insights reports: - Select Sources in the main navbar. - Select the Facebook Marketing Connector. - Select the Retest saved source. - Remove unsupported fields from the list in the Custom Insights section. - Select Test and Save. 5. Refresh Affected Schemas and Reset Data: After making the necessary changes, refresh the affected schemas and reset the data: - Select Connections in the main navbar. - Select the connection(s) affected by the update. - Select the Replication tab. - Select Refresh source schema. - Select OK. - Review any detected schema changes and select Save changes. - Ensure the Reset affected streams option is checked. - Select Save connection to reset the data in your destination and initiate a fresh sync. For more detailed instructions, you can refer to the [Facebook Marketing Migration Guide](https://docs.airbyte.com/integrations/sources/facebook-marketing-migrations#upgrading-to-200). If the issue persists, you might want to check if there are any ongoing issues or recent changes in the Facebook Marketing API that could be affecting the fields you are trying to access. For further assistance, you can also refer to the relevant GitHub issues and discussions: - [Issue #35334](https://github.com/airbytehq/airbyte/issues/35334) - [Issue #38154](https://github.com/airbytehq/airbyte/issues/38154) If you need more help, feel free to ask the community or open a new issue on the Airbyte GitHub repository.Thành Đặng Minh
06/03/2024, 2:01 AMkapa.ai
06/03/2024, 2:01 AMkapa.ai
06/03/2024, 2:02 AMsql
DELETE FROM connection_operation WHERE connection_id='your_connection_id';
DELETE FROM stream_reset WHERE connection_id='your_connection_id';
DELETE FROM notification_configuration WHERE connection_id='your_connection_id';
DELETE FROM schema_management WHERE connection_id='your_connection_id';
DELETE FROM stream_statuses WHERE connection_id='your_connection_id';
DELETE FROM retry_states WHERE connection_id='your_connection_id';
Replace your_connection_id
with the actual connection ID causing the issue.
5. Update Airbyte:
Ensure that you are using the latest version of Airbyte. Sometimes, bugs are fixed in newer releases, and updating might resolve the issue.
6. Consult the Community:
If none of the above steps resolve the issue, consider reaching out to the Airbyte community for help. You can post your issue on the [Airbyte GitHub Discussions](https://github.com/airbytehq/airbyte/discussions) or check if similar issues have been reported and resolved.
For more detailed troubleshooting, you can refer to the following relevant issues and discussions:
- [Issue #27992](https://github.com/airbytehq/airbyte/issues/27992)
- [Issue #25920](https://github.com/airbytehq/airbyte/issues/25920)
- [Discussion #28859](https://github.com/airbytehq/airbyte/discussions/28859)kapa.ai
06/03/2024, 2:02 AMsql DELETE FROM connection_operation WHERE connection_id='your_connection_id'; DELETE FROM stream_reset WHERE connection_id='your_connection_id'; DELETE FROM notification_configuration WHERE connection_id='your_connection_id'; DELETE FROM schema_management WHERE connection_id='your_connection_id'; DELETE FROM stream_statuses WHERE connection_id='your_connection_id'; DELETE FROM retry_states WHERE connection_id='your_connection_id';
Replace your_connection_id
with the actual connection ID causing the issue. 5. Update Airbyte: Ensure that you are using the latest version of Airbyte. Sometimes, bugs are fixed in newer releases, and updating might resolve the issue. 6. Consult the Community: If none of the above steps resolve the issue, consider reaching out to the Airbyte community for help. You can post your issue on the [Airbyte GitHub Discussions](https://github.com/airbytehq/airbyte/discussions) or check if similar issues have been reported and resolved. For more detailed troubleshooting, you can refer to the following relevant issues and discussions: - [Issue #27992](https://github.com/airbytehq/airbyte/issues/27992) - [Issue #25920](https://github.com/airbytehq/airbyte/issues/25920) - [Discussion #28859](https://github.com/airbytehq/airbyte/discussions/28859) By following these steps, you should be able to identify and resolve the issue causing the sync to fail. If you need further assistance, feel free to ask the community or open a new issue on the Airbyte GitHub repository.Daniel Khoa Le
06/03/2024, 8:55 AMDaniel Khoa Le
06/03/2024, 8:55 AMStephane Clery
06/06/2024, 12:19 PMDaniel Khoa Le
06/06/2024, 12:21 PMStephane Clery
06/06/2024, 12:22 PMDaniel Khoa Le
06/06/2024, 12:25 PMStephane Clery
06/06/2024, 1:01 PM