Forum Discussion

LesKimbler's avatar
LesKimbler
Qrew Cadet
21 hours ago

Error listing for Pipelines?

Is there any kind of troubleshooting/listing somewhere of Common issues with Pipelines.

I have Literally copied a working Pipeline line by line, instruction by instruction, and the one I am working on keeps getting an error. What I have noticed is for some reason the "Commit Upsert" runs twice, which i don't believe it ever used to if I look at older runs similar to this one. It is very frustrating with Pipelines to build an exact copy a functioning pipeline, only difference is a different app, and the copy will not function.

I've added a screenshot of the error i'm getting. If anyone can either help me or guide me to a answer, I would appreciate it.

4 Replies

  •  

    Thanks for sharing the screenshot!

    The error message 'Some record IDs specified were not found' in the table means the Pipeline is trying to update a record that doesn’t exist in the target table. That usually happens when the Upsert step is set to “Update only,” but the matching value (like a Record ID or key field) isn’t found.

    Here are a few steps to help resolve this:

    ✅ What to Check:

    1. Matching Field in the Upsert Step
      • Open the Upsert step and confirm which field it’s using to find matching records (e.g., Record ID#, a custom key field, etc.).
      • Make sure that value exists in the destination table.
    2. Upsert Mode
      • Is the Upsert set to “Update only”? If so, and there’s no matching record, it will error out.
      • If it makes sense for your use case, try switching to “Update or Add”.
    3. Review Input Values
      • In the run history, click into the “Input” section of the Upsert step.
      • Look at the value it’s trying to match — does that Record ID (or key) exist in the table?

    Let me know what you find or if you already checked these items.

    • LesKimbler's avatar
      LesKimbler
      Qrew Cadet

      The upsert is set to look for a Key Field that is unique to each record, and when the initial record is created, it uses a pipeline to create that record in another App.
      The problem is, when the Other app version of the record is updated, even when searching for the identical Key Field, it is not finding it, even though I have just created it using the other app.

      I tried to screenshot these but the post wouldn't let me add them.

      Updating table

      10207 - Kroger - 6800-100 - 11-16B - 872

      Original Source Table

      10207 - Kroger - 6800-100 - 11-16B - 872

      As you see, the fields match, so why would it not find it?

       

    • LesKimbler's avatar
      LesKimbler
      Qrew Cadet

      I've now attempted to add a additional parameter for it to search for that is again in both records, and it finds Neither, so kicks back and tells me there is no record. At least previously it found the record, but he upsert failed.

    • LesKimbler's avatar
      LesKimbler
      Qrew Cadet

      Figured it out. In my search records step, I was using the "Record Update" for the field, not the Search Records"

      Thanks for your help.