UNION ALL Error

Troubleshooting
, ,
#1

logs-539.txt (879.2 KB)
Error union all in contacts_scd.sql Intercom

Airbyte 0.36.4-alpha

#2

Hey @ayyoub can you try syncing it again by removing the contacts stream?

#4

how to remove the contacts stream @harshith

#5

syncing intercom is too long to wait even in contacts with start date at 29 April 2022 need more than 17 hours to sync :pensive:

#6

Got it I could see contacts itself has a lot of data. Do you mind sharing one contact record here after hashing/deleting the contact details. I want to understand the values for

 "created_at": {
      "type": ["null", "integer"]
    },
    "updated_at": {
      "type": ["null", "integer"]
    },
    "signed_up_at": {
      "type": ["null", "integer"]
    },
    "last_seen_at": {
      "type": ["null", "integer"]
    },
    "last_replied_at": {
      "type": ["null", "integer"]
    },
#7

already delete old temp tabel and solved thanks @harshith

#8

Hi there from the Community Assistance team.
We’re letting you know about an issue we discovered with the back-end process we use to handle topics and responses on the forum. If you experienced a situation where you posted the last message in a topic that did not receive any further replies, please open a new topic to continue the discussion. In addition, if you’re having a problem and find a closed topic on the subject, go ahead and open a new topic on it and we’ll follow up with you. We apologize for the inconvenience, and appreciate your willingness to work with us to provide a supportive community.

#9