Error importing accounts via SQLLoader connector

[rrivera1109 (Rebecca Rivera)]

We are implementing a new SQLLoader connector that is pulling a flat file from our sftp server into Sailpoint IDN. We have performed this many times with our various databases successfully however as I am trying this with our Tableau file, we are receiving the following error when importing our accounts for the first time.

sailpoint.connector.ConnectorException: Index value for [EMAIL] on new object was null.

Our account schema looks good and our query to pull the data appears good so unsure on why email is showing null.

Our account sql query is:
SELECT email AS EMAIL, full_name AS FULL_NAME, CONCAT( site, ‘|’, role) AS PROFILE FROM tableau_prod_users
UNION
SELECT email AS EMAIL, full_name AS FULL_NAME, CONCAT( site, ‘|’, role) AS PROFILE FROM tableau_sbox_users

Any help would be appreciated.

[philip-ellis]

The only thing I can think of is that the data for email is somehow null on one of the records. Your sql query looks good but without looking at the raw data there would be no way to know.

[rrivera1109 (Rebecca Rivera)]

Great call out. I can’t view the raw data but asked someone who could to please send me a copy. Upon examination, there is a “guest” account with no permissions and no email.