Can someone help me. I am trying to create an enhanced query job but getting an error.

[Deepu]

Hello,

I am trying to create an enhanced query job but getting an error.

The purpose of the query is to remove the end date for the business role and associated entitlements.

SELECT NULL AS role_user_account__ENDDATE , NULL AS account_entitlements1__ENDDATE ,rua.id AS role_user_account__PRIMARYKEY,
ae1.ACCENTKEY AS account_entitlements1__PRIMARYKEY
FROM role_user_account rua
JOIN roles r ON r.ROLEKEY = rua.ROLEKEY
JOIN accounts a ON a.ACCOUNTKEY = rua.ACCOUNTKEY
JOIN account_entitlements1 ae1 ON a.ACCOUNTKEY = ae1.ACCOUNTKEY
JOIN entitlement_values ev ON ev.ENTITLEMENT_VALUEKEY = ae1.ENTITLEMENT_VALUEKEY
JOIN users u ON u.USERKEY = rua.USERKEY
WHERE rua.ENDDATE IS NOT NULL
AND r.STATUS = 1
AND a.STATUS IN ('1', 'Active', 'Manually Provisioned')
AND u.USERKEY  = '18331'
AND r.ROLEKEY = '1209';

Thanks,

Deepu

[dgandhi]

Try to update one table column only in 1 query.

Refer below FAQ 

https://docs.saviyntcloud.com/bundle/EIC-FAQ/page/Content/FAQs.htm

Search with "Enhanced Query Execution"