Skip to main content

iPaaS.com MCP: Guide - Investigating a Failed Sync

Step by step: find a failed sync, diagnose it, agree a fix, apply it, resync, and confirm the record arrived, using the iPaaS.com MCP server (beta).

Before you start to use our MCP, please review the following items:

  • Ensure you have completed the iPaaS.com platform training before using this to best understand what is going on. If you need to gain access to it reach out to partnerships@ipaas.com.

  • With great power comes great responsibility - the MCP can do things like trigger a sync for your entire catalog and modify (or remove) data from your account. Ensure you understand what you want it to do before you work with it. iPaaS.com is not responsible for restoring any data or configuration changes made using the MCP.

  • Measure twice, cut once: When working with this, planning ahead of time (or asking the MCP to plan for you) will greatly benefit your work.

  • Remember that this is in beta so some features may be added, removed or altered as we continue our development. The latest change log notes can be found here.

  • If you have any issues or need to report a bug please reach out to us at mcp@ipaas.com.

When a record fails to sync, an error lands in your error queue. This guide shows how to work through it with the MCP, from "something failed" to "the record arrived", without guessing. You stay in control the whole way: the assistant suggests, you approve, and nothing changes until you confirm.

Before you begin

  • Connect with the right tools. Use the /mcp/operations,mappings domains (see Choosing Your Tools). Operations covers errors, logs and resyncs. Mappings covers fixing how data is translated.

  • Check your key's permissions (see Getting Started). For this guide you will want Error, Integration Monitoring Error Logs, Integration Monitoring Activity Logs, Subscription and Manual Sync, plus the permission for the type of record you are fixing. To change mappings, add the mapping permissions with Edit.

  • Check the company. Ask the assistant which company you're connected to before you start.

  • Know what your key can't do: the MCP can't log in to your other systems. If the cause is on the other side, such as an expired credential or corrupt /missing data, you will fix that there.

The loop at a glance

  1. Find the error.

  2. Diagnose it: what kind of error is it, and who can fix it?

  3. Read the source that explains it, not just the message.

  4. Agree the fix with the assistant before anything changes.

  5. Apply the fix, previewing first.

  6. Resync one record to prove the fix.

  7. Confirm it arrived.

  8. Re-check the queue and clean up.

NOTE: The assistant is designed to suggest a fix and wait for your approval. If it ever tries to fix something or resync without asking, say no and ask it to explain first.

Step 1: Find the error

Ask in plain language. For example:

  • "Show me my errors."

  • "Show me the errors for my e-commerce connection."

  • "I have the job ID from a resync: show me the error."

  • "I am missing orders in my ERP. Show me possible errors."

Each error in the queue records what failed, the connected system, the scope (such as product/updated), the direction, the external ID, the status, the number of attempts and a reference ID. The reference ID is the ID of the job that produced the error (the hook ID a resync returns), and it is the usual way in. A sync's tracking ID is a different ID and doesn't match an error.

Every error has a status:

Status

Meaning

Active

Failed and still waiting

Retry Pending

The platform will try again

Manual Fix Required

Someone has to change something before it can succeed

Ready For Delete

A later attempt succeeded (errors move through this stage quickly so it's unlikely you will see it)

Dismissed

Cleared from the queue by a person

The assistant filters by one thing at a time, such as a job ID, a connected system or a status. If you give it two, it will ask you to pick one.

Step 2: Diagnose it

Pick an error and ask the assistant to diagnose it. You can give it the error's own ID or the job ID. It reads the error, finds any error code in the message, and sorts it into one of these:

Kind

What it means

Who usually fixes it

Integration

An error from the connector for that system, usually shown with the vendor's name in its code

You, in iPaaS.com: often a mapping, a translation or a missing field

External system

The third-party system reported the failure, such as it refused the data, couldn't be reached or rejected the credential

You, in the other system

Platform

A general iPaaS.com error code

Often the platform. If it's related to the data the MCP should be able to address; if not, gather the error ID and tracking ID and contact support.

Unknown

The message didn't match anything the assistant knows

Needs reading, covered in Step 3

Older integrations sometimes report plain-English messages with no code. For those, the assistant uses its best judgement about what the message points to, such as a connection, a credential or a record that wasn't found, and it tells you when it is guessing.

The diagnosis also hands the assistant everything it needs to resync the record later, because the error already holds the connected system, the scope, the direction and the external ID.

Step 3: Read the source, don't trust the message

An error message alone is rarely enough to choose a fix. Ask the assistant to find the help articles for the error. It searches the integration's Error Messages article for the exact text, which documents most failures with a code, a cause and a fix. For platform codes it points to the codes reference, and for external-system failures it points to that vendor's own documentation.

A good prompt is: "Read the help article for this error, then tell me what you think the fix is and why." If the assistant proposes a fix without a source, ask where it came from.

Step 4: When there are many errors

Twenty errors are usually three causes. Ask the assistant to plan a fix for a job ID, a connected system or a status. It groups the errors by root cause, so records that fail for the same reason are counted together, and orders the groups:

  1. Causes you can fix in iPaaS.com, which you can act on now.

  2. Causes that need a change in the other system.

  3. Causes it can't classify.

The plan itself changes nothing. For each group it lays out the same sequence: propose the fix, get your approval, apply it with a preview, retry the record that failed first, retry the other records in the group to prove the fix didn't break them, then re-check the queue.

Fix one cause at a time and verify it before moving to the next. If you apply two fixes before checking either, you can't tell which one worked.

Step 5: Apply the fix

What you change depends on the cause. Here are the usual ones:

What the error points to

What you'd do

A value that doesn't translate, or a wrong field in a mapping

Ask the assistant to review the mapping collection, then change the mapping or translation. It previews the change first.

Bad data on the record itself

Correct the record in the source system, or ask the assistant to update it in iPaaS.com. Preview first.

A field the integration doesn't have

If it's a custom field, the assistant can create it. Otherwise, the field has to be added to the integration. Contact support@ipaas.com.

The connected system can't be reached, or rejects the credential

Fix the connection in the other system or in the connection settings. This is not a data fix, and the MCP can't do it for you. Resync afterwards.

A data type or direction the integration doesn't support

Ask the assistant to check what the integration supports. If it isn't supported, resyncing will never work.

A record with no external ID in the destination yet

Ask the assistant to find the records that are missing one for that system.

Every change goes through the preview-and-confirm steps described in Safety, Permissions and Limits. Read the preview before you confirm.

Step 6: Resync one record

Once the fix is in, resync the record that originally failed, and only that one. Ask the assistant to resync it. It shows a preview that names:

  • the exact record

  • the connected system

  • the direction (to iPaaS.com or from iPaaS.com)

The preview also checks that the integration supports that data type and direction, and it stops if not. The assistant can take these values from the error itself, but check them before you confirm.

When that one record works, resync the rest of the group, up to 25 at a time.

Step 7: Confirm it arrived

A resync starts a background job. Starting it doesn't mean the record arrived, so the resync checks each record and reports whether it was delivered, not delivered (with the reason) or still running. For a job that is still running, ask the assistant to check on it, and watch its status:

  • Stages such as Translating or Sending to Destination mean it is still running. They aren't failures, so don't go looking for errors yet. Ask again in a moment.

  • Complete means the run finished.

  • Frozen, Errored, Abandoned, Failed or Clapback mean the sync didn't succeed. Look at the error queue for that job's ID to see why.

  • Pending can mean the job hasn't been recorded yet, or is old. The platform only keeps recent jobs, for about 48 hours.

The platform retries failed jobs, so a job that reported a failure can later report Complete once the underlying problem is fixed.

Complete is not proof of delivery. A job can finish cleanly having sent nothing at all. That is what happens when a mapping collection's filter excludes the record. A filter isn't an error, so nothing appears in the error queue. Always check that the record actually arrived.

When a record didn't arrive, the assistant also says which of two things happened: the destination was reached and declined the record, which usually means a filter, or the destination was never reached, which on a sync into iPaaS.com often means the source had nothing to send.

How you check depends on the direction:

  • Records coming into iPaaS.com: ask the assistant to check whether the records landed. It reports which external IDs now resolve to an iPaaS.com record.

  • Records going out of iPaaS.com: ask the assistant to look up the record's external ID for that system. If one is now linked, it arrived. You can also check the record in the other system.

If the job completed but the record didn't arrive or change, the usual causes are:

  • A filter on the mapping collection excluded it. Ask the assistant to review the mapping collection and explain its filter.

  • The record type only moves with its parent. A transaction line travels with its transaction, and a variant with its product. Resync the parent instead.

Step 8: Re-check the queue and clean up

  • Ask for the errors for the same job ID again. Fixed records show as Ready For Delete.

  • If an error is still there and you've dealt with its cause, ask the assistant to dismiss it. Dismissing clears it from the queue, and it doesn't fix or retry anything. It works on up to 25 errors at a time and shows a preview first.

  • Don't dismiss an error just to make the queue tidy. If the cause is still there, the next sync will fail the same way.

If there's nothing in the queue

A record can fail to arrive without raising an error. The most common reason is a mapping collection filter that skips it silently. Ask the assistant to review the mapping collection for that data type and direction, and to explain what its filter does. Also check that the integration supports that data type and direction at all, and that webhooks and polls are set up to send it. Note that a manual resync ignores whether a webhook is enabled, so a manual resync working doesn't prove the automatic sync will.

Going deeper

  • Run logs. Ask the assistant to look at the transfer run log for a record or tracking ID. Each run shows its steps with the platform's own messages.

  • Live re-run. As a last resort, the assistant can re-run a transfer against a real record and report each checkpoint. It is slower and uses a real record in your account, so it asks you to confirm first.

Prompts to start with

  • "Show me the active sync errors for my e-commerce connection."

  • "Group these errors by cause and plan the fixes, but don't change anything yet."

  • "Diagnose this error and read the help article for it before you suggest a fix."

  • "Preview the change to that mapping."

  • "Resync that one record to the e-commerce system, preview first."

  • "Did that record actually arrive?"

If something doesn't work

  • You get a 401 on errors or logs. Your key lacks a permission. Ask the assistant to check your permissions, then create a new key with the missing ones.

  • The assistant can't find the error by the ID you gave. Two IDs find an error: the error's own ID, and its reference ID, which is the ID of the job that produced it. A sync's tracking ID matches neither, so if that is what you have, ask the assistant for the job ID from the resync.

  • A resync is refused as unsupported. The integration doesn't support that data type or direction, so no resync will work. Contact support@ipaas.com.

Anything else: mcp@ipaas.com.

Did this answer your question?