Clarity

Expand all | Collapse all

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

  • 1.  Where are Parameters stored when running a Job through a Process?

     
    Posted 08-17-2017 08:18 AM

    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.



  • 2.  Re: Where are Parameters stored when running a Job through a Process?

    Posted 08-17-2017 08:39 AM

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



  • 3.  Re: Where are Parameters stored when running a Job through a Process?

    Posted 08-17-2017 10:09 AM

    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)



  • 4.  Re: Where are Parameters stored when running a Job through a Process?

     
    Posted 08-17-2017 10:27 AM

    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.



  • 5.  Re: Where are Parameters stored when running a Job through a Process?

    Posted 08-17-2017 11:50 AM

    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.



  • 6.  Re: Where are Parameters stored when running a Job through a Process?

     
    Posted 08-29-2017 07:02 AM

    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



  • 7.  Re: Where are Parameters stored when running a Job through a Process?

    Posted 08-29-2017 08:51 PM

    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



  • 8.  Re: Where are Parameters stored when running a Job through a Process?

     
    Posted 09-29-2017 08:10 AM

    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.



  • 9.  Re: Where are Parameters stored when running a Job through a Process?

    Posted 08-30-2017 04:15 AM