Skip to main content

I am deploying a project to Snowflake.

On a table I get the following error:
Object reference not set to an instance of an object.

As read in another ticket I did a ‘Save and reload' but unfortunately that did not solve the issue.

It;s on deploying the data cleansing script however it does not show me the script in the deployment log, I only see the error message. Is there an easy  way i can see what lookup column is causing the issue ?

 

Hi @Roy V 

Is there any way you can be more specific about what you do to get this error?

For example you say it happens on deploying a table. There is some steps that will be deployed, what part fails.

Is it only this table that fails and if not what are the differences with those that work and those that do not.


Hi Thomas, here some more details:
It is when deploying a table, where the error occurs on deploying the data cleansing rules.

As you can see you can click on the error but not on a/the script being used so I do not know where to look to find the cause of the error.
Other tables do not have this issue but there are not many strange things happening, just 8 lookups and normal copy columns from the mapping.
 

The error details:
 

Any suggestions/ideas?


Hi @Roy V 

Can you please try deploying all objects associated with the table? To do this, right-click and select Deploy and then select Review task and then make sure all deployment steps are checked, and click Start. Do you still get the error?

 

If the error persists, please send screenshots of the table with its mappings and all the fields (including any transformations on fields) and screenshots of the table settings


Reply