SAP IDM 7.2- ToPass to update account attribute not working

[former_member297605]

Hi Experts

Please could you check the below pass and let me know what is wrong as it is not working. Im trying to update the user's ACCOUNT attribute.

Thanks

Ranjit

[peterwass · Accepted solution]

Can you post the error?

On first look, the MSKEY is a number, not a string in your SQL...

[former_member297605 · Accepted solution]

Hi Peter

Error below.About the SQL statement, when I execute the statement in SQL it gives me the correct user.

[jaisuryan · Accepted solution]

Hi Ranjit,

Above error is from the task "SetModifyContext" and not the error of "Set Account attribute"

Please post the error you are getting while running "Set Account attribute"? Also try running the job without "Changetype = add "

Kind regards,

Jai

[peterwass · Accepted solution]

SetModifyContext looks like a task rather than a job.  It also makes sense in that I can't see where the script is being called in the screen shots.

Are you intending to add a new user?  changetype add will create a new user.  changetype modify will ensure that it only updates an existing user.  It may be that its not running the task because you're telling it to add a new user and, as it already exists, its not doing any of the work.

Peter

[former_member297605 · Accepted solution]

Hi Jai

When I run the job I don't see anything in the job log, nothing happens.

Should I have change type = modify?

Also I have set the attribute in the destination tab with value of the userid. Is this right?

[former_member297605 · Accepted solution]

Hi Peter

No not intending to add a user, just want to add his ACCOUNT attribute with the value of the user's userid.

When I run the job I don't see anything in the job log, nothing happens.

Should I have change type = modify?

Also I have set the attribute in the destination tab with value of the userid. Is this right?

[peterwass · Accepted solution]

Your destination tab should look like

MSKEYVALUE                   <mskeyvalue>

ACCOUNT<system>          <accountname>

Adding:

changetype                         modify

is optional and not required.

[jaisuryan · Accepted solution]

Also check what's the existing value in database using below SQL,

select attrname, searchvalue from idmv_value_basic where MSKEY = 6930 and AttrName = 'ACCOUNT<repname>'

Kind regards,

Jai

[former_member297605 · Accepted solution]

Thanks Peter / Jai... That sorted it .

cheers

Ranjit