Output Error

Question

Subject: Phantom ToolId 224 Error - Transform Tool Failing with Row MismatchHi 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!

Chaoued · Answer

@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.

jrlindem · Answer

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

Alteryx Designer Cloud Discussions - Alteryx Community