cancel
Showing results for 
Search instead for 
Did you mean: 

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

brianc0755
New Contributor

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.

brianc0755_0-1697736203499.png

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

brianc0755_1-1697736383468.png

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

 

 

1 ACCEPTED SOLUTION

alchemiz
Contributor III

Hi @brianc0755 ,

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

alchemiz_0-1697762566040.png

~EmEm

View solution in original post

1 REPLY 1

alchemiz
Contributor III

Hi @brianc0755 ,

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

alchemiz_0-1697762566040.png

~EmEm