OOB JOB "POPULATE TPM DISCOVERED TECHNOLOGIES AND LIFECYCLES" NOT WORKING AS EXPECTED

Randy TCTS
Tera Expert

ello Community,

 

We installed the Enterprise Architecture application and we are working on populating the TRM product list in the Technology Portfolio section of the application. We ran the OOB job called "Populate TPM Discovered Technologies and Lifecycles" and it appears to be not doing what it is expected to do. The job is not populating data into the sn_apm_trm_standards_product table as expected. The job is also not putting any record in the sn_apm_tpm_discovered_technology_run_log table to indicate any information the job is supposed to do.

 

We are in need of help to figure out what are we missing short of writing our custom script to move data from the source tables into the sn_apm_trm_standards_product table. Thank you for your help.

 

@tangcov 

11 REPLIES 11

sonali panda1
Kilo Sage

Hi,

 

The job  "POPULATE TPM DISCOVERED TECHNOLOGIES AND LIFECYCLES" is for populating the TPM discovered technology table and then you can see the data in the Technology portfolio - TPM lifecycle. It is not meant to populate or auto create the TRM standard product.

TRM products are organization specific and have to be handled manually as to which products are approved for use by organization. You can automate this based on your requirement from the SW discovery model table for eg. If a particular product type you are considering to be architecturally significant and want to see it in the TPM lifecycle dashboard, and also want the TRM products to be created simultaneously so they dont show in the Tech debt, you can create the custom script, . But OOB  there is no logic to automatically create in TRM products table.

 

Thanks

Sonali

Randy TCTS
Tera Expert

Thank you your feedback, @sonali panda1 .  What would be the table we should look at for the HW models?

Hi,

What we did as part of MVP is, looked at the TPM discovered technology for the Type = Hardware and looked at the Product and created that as TRM product. Also, the hardware model table we picked all of then which were normalized and had a normalized product name and created that aswell. 

 

Thanks

Sonali

Randy TCTS
Tera Expert

Hi @sonali panda1 .  We have been running the job mentioned earlier to populate the sn_apm_tpm_discovered_technology table but the job (

POPULATE TPM DISCOVERED TECHNOLOGIES AND LIFECYCLES

) is not doing the expected outcome.