Compile Error: "Fields that are used for input are not allowed on the output side of a map" (SCI78180) *|* -9BDBE263FA901

Question & Answer

Question

Compile Error: "Fields that are used for input are not allowed on the output side of a map" (SCI78180)

Answer

Technote (troubleshooting)

Problem(Abstract)

Compile Error: "Fields that are used for input are not allowed on the output side of a map" (SCI78180)

Symptom

Compile Error: "Fields that are used for input are not allowed on the output side of a map"

Cause

The DSN specified in the map was not updated.

Resolving the problem

When objects in the database (Table View Column names etc) change an update must be performed on the DSN in the map.

1. Open the map
2. Right click on the SQL File Format Object and select 'Properties'
3. Select the 'Data Source' tab
4. Highlight the DSN in the 'Currently Defined Data Source' list box
5. Click the 'Update' button.

Historical Number

PRI6890

Product Alias/Synonym

Change

Column names in the database were changed.

Fact

Gentran Integration Suite Release 4.0
SQL Map
SCI78180

[{"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Product":{"code":"SS73G6","label":"Sterling Total Payments for Financial Services"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"","label":""}}]

Tips

Compile Error: "Fields that are used for input are not allowed on the output side of a map" (SCI78180) | -9BDBE263FA901