hi <@U04SE163WC8> I am using Facebook Marketing so...
# ask-ai
t
hi @kapa.ai I am using Facebook Marketing source and got this error (#100) Tried accessing nonexisting field (cost_per_conversion_lead) on node type (AdsInsights). Please help me fix this
k
It looks like you're encountering an error related to accessing a non-existing field (
cost_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.
t
I try to sync but it appears this "Failed to start sync: errors.http.default" @kapa.ai
k
A message from kapa.ai
It looks like you're encountering an error message "Failed to start sync: errors.http.default" when trying to initiate a sync. This type of error can be indicative of several underlying issues. Here are some steps you can take to troubleshoot and resolve this problem: 1. Check for Running Syncs: Ensure that there are no other syncs currently running for the same connection. Sometimes, a sync might be stuck or not properly terminated, causing new sync attempts to fail. You can verify this by checking the status of your jobs in the Airbyte UI. 2. Reset the Connection: If a sync is stuck, you might need to reset the connection. However, be aware that resetting will clear the data in your destination and start a fresh sync. Here’s how you can reset the connection: - Go to the Connections tab in the Airbyte UI. - Select the connection that is causing the issue. - Click on the Replication tab. - Click on Reset data and confirm the action. 3. Check Logs for Detailed Errors: Detailed logs can provide more context about why the sync is failing. You can access the logs from the Airbyte UI: - Go to the Jobs tab. - Find the job that failed and click on it to view the logs. - Look for any specific error messages that might indicate the root cause. 4. Database Cleanup: If the issue persists, you might need to clean up the database entries related to the connection. This can be done by manually deleting entries from the relevant tables in your Airbyte database. Here are some SQL commands that might help:
Copy code
sql
   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)
It looks like you're encountering an error message "Failed to start sync: errors.http.default" when trying to initiate a sync. This type of error can be indicative of several underlying issues. Here are some steps you can take to troubleshoot and resolve this problem: 1. Check for Running Syncs: Ensure that there are no other syncs currently running for the same connection. Sometimes, a sync might be stuck or not properly terminated, causing new sync attempts to fail. You can verify this by checking the status of your jobs in the Airbyte UI. 2. Reset the Connection: If a sync is stuck, you might need to reset the connection. However, be aware that resetting will clear the data in your destination and start a fresh sync. Here’s how you can reset the connection: - Go to the Connections tab in the Airbyte UI. - Select the connection that is causing the issue. - Click on the Replication tab. - Click on Reset data and confirm the action. 3. Check Logs for Detailed Errors: Detailed logs can provide more context about why the sync is failing. You can access the logs from the Airbyte UI: - Go to the Jobs tab. - Find the job that failed and click on it to view the logs. - Look for any specific error messages that might indicate the root cause. 4. Database Cleanup: If the issue persists, you might need to clean up the database entries related to the connection. This can be done by manually deleting entries from the relevant tables in your Airbyte database. Here are some SQL commands that might help:
Copy code
sql    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.
d
Hi @Thành Đặng Minh, The issue was created but no official resolution yet. https://github.com/airbytehq/airbyte/issues/38835
This happened to us too.
s
This happened to us as well.
d
Hi @Stephane Clery, You can check out the solution here.
🙏 1
s
so just upgrading the connector should work?
d
@Stephane Clery Yes, do not need to reset.
👍 1
s
data synched thanks 👍
🙌 1