In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Output Error

gaj98307
5 - Atom
Subject: Phantom ToolId 224 Error - Transform Tool Failing with Row Mismatch
Hi everyone,
I'm getting a persistent error in Designer Cloud that's blocking my workflow from running. The error shows "ToolId 224: The number of rows in the Source do not match the number..." but there's no Tool #224 in my workflow.
Error Details:
  • Transform tool fails with "AmibJobFailed"
  • Naconverter fails with "UpstreamJobFailed"
  • Job ID: 2413270
  • Asset: "Consulting Case Cleaned"
  • Output: Excel file "Cleaned Data.xlsx"
What I've tried:
  • Cleared browser cache and cookies
  • Saved and reopened the workflow
  • Checked for hidden tools off the canvas
  • Verified all tool connections
The workflow was working previously, but now consistently fails with this phantom tool ID reference. Has anyone encountered similar phantom tool ID errors in Designer Cloud?
Any suggestions for troubleshooting workflow corruption issues would be appreciated!
2 REPLIES 2
jrlindem
12 - Quasar

@gaj98307 I would recommend you re-posting this in the Designer Cloud Discussion Board:

Alteryx Designer Cloud Discussions - Alteryx Community

Chaoued
8 - Asteroid

@gaj98307 

- Switch output to CSV temporarily -> run.

--> If it succeeds: focus on Excel output configuration.


- Remove/disable Pivot/Unpivot/Join/Union steps -> run

--> If the error disappears: the mismatch is in that operator; re-validate keys/columns.


- Turn off strict schema on any steps/output -> run.

--> If it succeeds: re-align schema or add a schema enforcement step right before the writer.

Labels
Top Solution Authors