AMP Engine Error

I have a workflow (screenshot attached), whereby I'm getting an error on processing when run with AMP on, but no error when AMP is off. The error is Dynamic Input (29) Internal Error in RecordReader::ReadFields: Too many fields in the Dynamic Input tool. I'm feeding in a list of excel files/tabs/arrays to read in (attached screenshot). I read the data out for both instances, seeing that one row of data was dropped from two of the tabs of data when I see the AMP error (ends up being two rows each, since the last actual row is blanks across). These are not the tabs with the most data, so not sure why these are dropping and others aren't. The data on all of the tabs is consistent (e.g. same number of columns, same format --- all dates and numbers), so it's unclear to me why two tabs are dropping and others are not. Also, these are not the tabs with the most data/rows.

My current resolution seems to be turn off AMP, though requires every member of my team to do this, in which case I may ask everyone to always turn it off. Is there any other solution? Is there an explanation for this error occurring?

alteryx_error_2.png

alteryx_error.png

Error Message

Batch Macro

Dynamic Processing

AMP Engine

AMP-Engine

Accepted answers

All comments

nbondarchuk

What version of Alteryx Designer are you using?

BS_THE_ANALYST

@jvigneault is it inconvenient to build the process without the Dynamic Input? I always find it troublesome.

All the best,

nbondarchuk

For further investigation, it would be very helpful for us if you could share the workflow and examples of input data.

jvigneault

It's possible I'm just not familiar with alternative solutions that are available. Do you know similar workflows that are able to accomplish what I'm after?

I saw a request below asking for the workflow, so spent a few setting up an example, attached below. It seems if I delete all of the columns to the right of the columns I'm pulling through the tool, it fixes the issue, but I have data in those columns so can't actually just delete it from my file.

Thanks!

AggregateCF.yxzp

smaruda

You can use this simple batch macro to achieve what you need.

Even on E1 Dynamic Input does not give proper result - it outputs 2 extra records with Field Names of each file.

Screenshot 2023-10-31 145941.png

TEST data14.zip

smaruda

Sorry, E1 produce proper results. You have to deselect "First Raw Contains Data" in Dynamic Input config to remove fields names in output records.

Suskil

This issue has been identified as Defect GENG-3313 and has since been resolved in the following versions:

2021.4.2.47895 (Patch 12)
2022.1.1.10.42707 (Patch 10)
2023.1.1.336 (Patch 5)
2023.2.1.51 (Patch 1)

changwen

hello, the workflow was forced to stop when running the designer on my desktop even though the amp engine is selected on the "runtime". same for version 2021.4 and 2022.1. please advise.

apathetichell

@changwen - turn off AMP. Leave it off. Always.

changwen

when turning it off, it would pop up a window when running the workflow that you to check the amp engine again.

apathetichell

click on do not show the message again. re-run. sleep better at night.

harsh_alang

@changwen are you using the version 22.1 with Patch 10?

Are you able to try the workflow with version 23.2? Bug and crash reporting have been improved in 23.2 and it would provide much better insights.

changwen

still not working. same error - a bug

apathetichell

Are you writing to either a network drive or a database? sometimes the pipe ends when you begin with a connectoin (like a VPN) and then at some point your connection times out. For some DBs this can also happen if your cluster goes to sleep.

harsh_alang

@changwen you did not mention the version you are using. Are you able to share workflow?

If you are using 23.2, please enable Crash report in user setting and run the workflow. You will get a report ID please share that.

Crash.jpg

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335