*Unknown checkbox on Select tool

Question

Good morning all,

I've come across a strange 'error' this morning and wondered if anyone has had a similar experience. I can't share any workflows, so will try to explain the best I can.

We have a number of workflows that take data from our SAP system and upload it to our SQL databases. We have set all the workflows with a select right before the output and have UNchecked the *Unknown fields checkbox. Our thinking behind this is that if a new field comes through, we don't want it to be uploaded as it will error. (We have the output set to truncate, so a new field will error the query as the column wouldn't be in the sql table)

Now, one of our workflows failed this morning. Looking at the truncate query on the output, there appears to be 2 new fields, causing the error.

The 2 new fields are in the select tool, even though the *Unknown field is unchecked.

I've looked at the SQL view that we have which is based on the SQL table and those 2 fields are not in the View. This means that they are definitely new fields.

The SQL table hasn't been amended, so no one has deleted the 2 fields from the actual table.

Why/how would a new field appear in the select tool, even with *Unknown unchecked?

(We're on version 2021.1 btw)

caltang · Answer

Have you tried turning AMP off and running it? If it still persists, can you remove the Select tool and replace it with a new Select tool with the same selections?

Else, you can try the Dynamic Select tool, and change the config to Formula, and have it become like:

[Name] IN ('Your fields here','Your fields here',etc...)

Hope this helps!

Rags1982 · Answer

Hi @Rahulv288 , there are no duplicate fields and unfortunately it wont let me upload a screenshot. (PC issue at the moment)

The error I got was on the output tool, basically saying that it couldn't delete/append data because there was an error with the sql query. This was caused by the 2 new fields being in the upload query and not being in the table.

The issue here though is how those 2 fields appeared in the select tool when the *Unknown fields box was unticked. Makes no sense as they should have appeared but not have been ticked.

Rahulv288 · Answer

Please review if any name duplication is happening since new fields getting created.
If possible please share the screenshot of error ?