Sailpoint IIQ DB has many XML base colmuns, in rare cases we might want to to udpate specific XML.

For example: 

you cant login to the system becuase loginPassThrough is set to AD and AD is not Available, you can remove the loginPassThrough from the system configuration by changing  the attribute in the XML :


UPDATE identityiq.spt_configuration

SET attributes = REPLACE(

    attributes,

    '<entry key="loginPassThrough" value="AD"/>',

    '<entry key="loginPassThrough"/>'

)

WHERE name = 'SystemConfiguration'

  AND attributes LIKE '%<entry key="loginPassThrough" value="AD"/>%';


NOTE: it is not recommended to run direct udpate on the DB, we recommend use it as last alternative solution in case needed.