Snowflake - Failed to update a user

Which IIQ version are you inquiring about?

8.4p2

Please share any other relevant files that may be required (for example, logs).

Share all details about your problem, including any error messages you may have received.

We are seeing this error sporadically when we try to revoke a role and disable the Snowflake account.

We can’t reproduce it on demand. Has anybody seen this error? Any hints?

Thanks.

Pasha

2026-01-06T12:33:47,540 ERROR https-openssl-nio-443-exec-4 openconnector.connector.snowflake.SnowflakeConnector:199 - Failed to update a user, Error:
java.lang.NullPointerException: null
at openconnector.connector.snowflake.SnowflakeService.fetchRolesForSingleUser(SnowflakeService.java:995) ~[connector-bundle-webservices.jar:8.4p2]
at openconnector.connector.snowflake.SnowflakeService.getAccount(SnowflakeService.java:958) ~[connector-bundle-webservices.jar:8.4p2]
at openconnector.connector.snowflake.SnowflakeProvisioner.updateUser(SnowflakeProvisioner.java:319) ~[connector-bundle-webservices.jar:8.4p2]
at openconnector.connector.snowflake.SnowflakeConnector.update(SnowflakeConnector.java:195) ~[connector-bundle-webservices.jar:8.4p2]

Hi @pasha, could see a null pointer exception coming up as per the stack trace. can you please enable more logging in before or after provisioning rule in see if you get more details on the error, possibly print whole provisioning plan and check out what could be the error.

Hi @pasha

I would suggest enabling trace logs. Currently, null pointer exception is visible and nothing apart from this.

Thanks to those who looked into this and made suggestions.

The error has stopped happening since I posted it here. Did not know just posting here could solve issues :slight_smile:

Thanks again.

Hi @pasha It could be because of some specific user not having all required data. I would recommend adding null checks in your code to mitigate the issue in future.

Hi @r_pragati It’s not my code showing the null. It’s the connector itself.

I see, you might need to enable trace logs for the connector in that case.

There is an eFix for this. The issue is resolved in 8.2p3 and other recent versions.

The issue is related to “workspace” in Snowflake where there is no role attached (null) to the user’s personal database. The issue is intermittent, since not all people use the concept of workspace on Snowflake.