Where are Parameters stored when running a Job through a Process?

[Legacy User]

I have created a process that has an action on a step to launch the Synchronize portfolio Investments job. I hardcoded a specific Portfolio in there (BP&IT Portfolio)

 

Where in the DB is this parameter stored? I tried looking into BPM_DEF_STEP_ACTION_PARAMS table but that doesn't seem to hold the value.

 

 

Any help would be appreciated.

[Matthew Muskaloon]

Moving this to the PPM community as this was opened up in the APM community.

[David Morton]

CMN_SCH_JOB_RUN_PARAMS I think.

 

(BPM_DEF_STEP_ACTION_PARAMS is to do with the definition of a process rather than the execution of a job)

[Legacy User]

David: Even if running the job happens from a step action WITHIN a process?

I defined in a process to run a job with a specific parameter. I didn't schedule the job nor ran it.

 

Because i see that you need a: job_run_id to link CMN_SCH_JOB_RUN_PARAMS, which i don't have since it's defined in a process definition.

[David Morton]

Hmmm interesting not what I expected.

 

But I did a quick test and they seem to be in CMN_ATTRIBUTE_VALUES - you'll have to read back through the IDs to see how that relates to the process.

[Legacy User]

Hi David,

 

Sorry for the delayed reply. But yes, you are right. It is stored in CMN_ATTRIBUTE_VALUES. Nice find

 

But i cannot seem to read back through the ID's to find the process. This is what i found:

 

1) Going down using the attribute ID

select *
from CMN_ATTRIBUTE_VALUES cav
join cmn_attributes ca on ca.id = cav.attribute_id
join CMN_BUSINESS_OBJECTS cbo on cbo.id = ca.pk_id
join CMN_SCH_JOB_DEFINITIONS csjd on csjd.id = cbo.pk_id
where cav.id = 5179085

 

>> will lead to the job definition

 

2) Going down using the Attribute Set ID

select cavs.*
from CMN_ATTRIBUTE_VALUES cav
join CMN_ATTRIBUTE_VALUE_SETS cavs on cavs.id = cav.attribute_set_id
where cav.id = 5179085

 

>> will give the job_id

 

(replace cav.id by the CMN_ATTRIBUTE_VALUES id found)  >> so this will lead to the job definition, but not to the process

 

Do you see anything i can use in there to relay back to the step_action?

 

Any help would be appreciated.

 

Anthony

[Jeanne Gaskill]

Hi Anthony,

Here are the tables you need:
BPM_DEF_STEP_ACTIONS contains the job id, the job definition id, and the step id,
BPM_DEF_STEPS contains the stage_id

BPM_DEF_STAGES contains the process_version_id

BPM_DEF_PROCESS_VERSIONS contains the process_id

BPM_DEF_PROCESSES contains the process_code.

 

If you need the actual name of the process, you can map to the name in the CMN_CAPTIONS_NLS.

 

And you already have a way to get from the job definition id to the parameters.

 

Hopefully this will give you the information you need.

 

Please let me know whether or not this resolves your problem.

 

Jeanne

[Legacy User]

Thanks Jeanne_Gaskill_CA_Clarity_Support and urmas for the information. But I was not really looking for this particular information, but more on how to go from CMN_ATTRIBUTE_VALUES (where the parameter for running a job in a process is stored) to the Process definition itself.

 

As you can see above I cannot seem to find the missing "link". Any help would be appreciated.

[Deactivated User]

See also
https://communities.ca.com/message/57092834?commentID=57092834#comment-57092834