Values from RITM is not populating properly into the Catalog Task

[suvi1]

I  am having custom table and all the values are strings there.

i am populating 4 values from the custom table like this

 if i select the Source system , the values are populating  based on the source system.

 (i want to say here , that same record is displaying from the back end cutom table)

 where entity, data owner and data owner 2 are dependent on the Source system.

  and  i am getting like this.

Entity field and DataOwner fields are not populating.

Can any one suggest me , where can i have done the wrong.

and in the workflow i have set the fields.

[GlideFather · Accepted solution]

It might be caused by selecting records that have been deleted/deactivated.

Install browser extension called SN Utils and then when you have the form with the situation like you do, then double click the variable name (e.g. Entity or Data Owner), and you will see whether it is empty, or there is any sys_id.
When there is a sys_id, copy it, then go to backend and use a slashcommand "/" following the sys_id you just copied and press enter, it is the fastest way to recognise the sys id. Example of the full slash command "/basaeed5c3d60210647b0f35fd0133bf" + enter.

You will see what the record is, or whether it is not existing, the same way it can be searched in PROD or any other environment,

It can happen for example when there is a record in PROD, and you are using the sys_id in DEV where it does not exist.

[suvi1]

hi Brad,

  All are populating from the same table.

 Source  field is unique record in the table, so Entity is depended on the source.

See the below screen shot.

similary for dataowner ,

below is the screen shot

[Brad Bowman]

Since you are using the variable Auto-populate feature, you should not be setting these 2 values in a workflow Run Script activity.  If you set the value of Source system manually on the form, does the correct Entity auto populate?

[suvi1]

I did not get it.

by using the Auto-populate feature i am getting the correct values on the form.

 so you are telling me not to set the values of entity in the workflow catalog TASK right ?

[Brad Bowman]

I'm confusing myself so I setup a simple example in my PDI.  I have two reference variables requested_for and requested_for_manager, both reference the sys_user table.  RF Manager is setup to auto populate based on the dependent question requested_for dot walking to the Manager.  

Scenario 1:

I can populate requested_for manually on the request form, RITM, or a Catalog Task and RF Manager will auto populate.  Whichever form I use to manually populate this, both variables still show populated on the other forms.

Scenario 2 & 3:

I do not populate either variable on the request form, but populate requested_for on the RITM via a Run Script, or within the Catalog Task activity.  RF Manager remains blank as the auto populate feature only works in the UI not backend/scripts.

Scenario 4 & 5:

I do not populate either variable on the request form, but populate requested_for and requested_for_manager on the RITM via a Run Script, or within the Catalog Task activity.  When viewing both the RITM and Catalog Task, both variables are populated.  In this example I happen to use a different manager sys_id so it's not the manager on requested_for record, but when viewing the record the auto populate did not change/override this value.

So it sounds like Scenario 1 is working for you.  When you are not seeing Entity and Data Owner populated, is Source System previous populated, or are you setting this value in the same script as the other two/three variables?  Is this script in a Run Script or Catalog Task activity?  Are you attempting to set Entity and Data Owner using the same sys_ids that work when populating Source System manually?

[suvi1]

HI Brad,

Scenario 1. is similiar to me.

Through  1st variable: Source system, i am populating all the variables(Entity,Data Owner1 and Dataowner2) are populating on the form.

That means i am selecting on only Source System on the Catalog form, rest of the variables((Entity,Data Owner1 and Data Owner2)) are autimatically populating on the catalog form.

 and when i submit the form , RITM will be created, 

 when i open the RITM , i can see only the 1st variable Value SourceSystem  like below screen shot

.

 Similarly on the Task form also, the similar one is populating on the TASK form.