Incosistent "Input document should be a flattened map data" Error.

[brianc0755]

I have a simple pipeline that reads from a list of table names.  For each item in the list it looks up data in one SQL database and transfers it to another database.

This is the child pipeline.  It is passed the name of the table on which to operate as a pipeline parameter.  It works as expected when executed standalone.

This is the parent pipeline.  The pipeline execute snap calls the child pipeline and passes the table name.

The pipeline execute snap always fails with this message:

Pipeline did not complete successfully

Resolution:

Fix the child pipeline errors and try again

Reason:

Snap errors: [{ruuid=054aed42-5b64-43ab-8df4-2a54c6416e84, reason=Input document should be a flattened map data, but found: LinkedHashMap, label=CSV Formatter, resolution=Please make sure the input document a flattened map data., failure=Cannot format CSV data, snap_fqid=com-snaplogic-snaps-transform-csvformatter_3-main22460}]

The child pipeline reports the same error:

Cannot format CSV data

Resolution:

Please make sure the input document a flattened map data.

Reason:

Input document should be a flattened map data, but found: LinkedHashMap

[alchemiz · Accepted solution]

Hi @brianc0755 ,

Good day, check the SQL Server - Select snap and unchecked the "Pass through" property 

~EmEm