Object Reference not set to an instance of an object on SmartConnect map validate

Published: Jul 12, 2017
Post Author Written by eOne Solutions

I have an existing SmartConnect map that is pointing to an Excel file. If I add a new column to that file, I receive the error message ‘Object reference not set to an instance of an object’ when I click validate or preview. The map was working until I added the new column.

The issue is there is an existing column with the same name already mapped via a local constant. I added a column to my Excel file called MYBATCH but the local constant called MYBATCH was already mapped in the destination. If I changed the local constant or change the column in the Excel file, the map will open and run correctly.

The same issue will occur for any type of data source, if you add a new column to that data source that matches an existing column, whether it’s a local constant, global constant or any additional column name.


Feeling stuck? Get the support and guidance you need to help you power through any data challenge

We're on your integration team. Connect with our people and let us know how we can help you.