A value cannot be extracted twice

Hello,

I’m having an issue with a previously working process. As far as I know, I didn’t change anything that could have broken it…but I’m sure I must have?

I’m getting the following error:

My process only appears to be extracting feeCode2 a single time, however it is in a loop.
My preview comes up correctly. My process doesn’t show any errors unless I run it through workflow.

Thoughts?

What happens if you do Validate Records (green check) on the entire data file in Design? It’s likely caused by some condition controlling your loop that’s causing it to try to extract it twice. Perhaps because the data is different on the particular record where it’s happening.

Validate Records is going to tell you exactly which record is in error. By default, the Design tool only shows you the first 200 records though. So you need to expand the preview first, then run the validation.

Believe it or not, I get an “All records are valid” response.

Because of what I’m trying to do with my data, I have one record with 200+ detail tables and sub details from there.

Can you confirm that the file that you use in Workflow (and that errors out) is the exact same one as the one you run in your Datamapper while designing?

Confirmed that it is the same one I’m datamapping with vs. designing vs. workflow

To help you properly we would need to see the Template and reproduce the issue. I suggest you open a technical support call at 1-866-348-5863 or through our website.

Since the default number of records validated by the Validate records option in the DataMapper is 200, you can either increase that number to match the number of records in your data file, or you can use the Execute Data Mapping task in Workflow and tick the Validate only option, which will go through the entire file, regardless of the number of records in it.

Check out PReS Workflow Workflow 2018.2 User Guide for details on how to interpret the results of that operation.

Thanks guys. I called in and am waiting for a call back. I only have one record, and that record is showing as valid. So we’ll see what they say.

I’m still waiting to hear back from support. However, I’ve narrowed down my issue to a single page:

My conditional is:

  1. Balance column contain a period?
    If Yes: Map Fee Code, amount chgd, date, amount paid, date, balance
    If No: Map Fee Code, larger area near balance
  2. Step to next line

For some reason, when it gets to the Martin Luther Kin part, it throws this error saying the value can’t be mapped twice (feeCode2, which is equivalnent to the “No” fee code mapping.

I would say it’s caused by the same title appearing in two different rows when in fact they are a single book. I don’t know what kind of logic you applied for moving from one detail line to the next, but that’s where I would start investigating.