SAM - Generate Data For Software Lifecycle Report scheduled job

psyherin · ‎08-30-2023

Hi All,

I am using SAM workspace and trying to open the Software Product Lifecyle report, but it is coming up as empty. The table sam_sw_product_lifecycle_result is empty as well. The scheduled job SAM - Generate Data For Software Lifecycle Report is running but it seems it is not collecting any data.

The content library is updated as well as the software products are normalised. Have not made any changes to scheduled job or script includes related to SAM and they are all OOTB.

I am trying to troubleshoot and pinpoint the issue but not able to find it.

Any help is appreciated.

Thanks

Community Alums · ‎09-08-2023

I can see that below job and Script Include populates Lifecycle Report. I can clearly see that it has condition active = true , so data will not be populated if all your lifecycle records are active false.

I could check that we also have around 5000 lifecycle records as active false but they are just .5% of all lifecycle records. If all your lifecycle records are active false, You may raise a case with ServiceNow to find out. I would also be interested to know why they have disabled all lifecycle records

Scheduled Job - /sysauto_script.do?sys_id=db696cbf0f521010a2bb13b2ff767e98

Script Include - /sys_script_include.do?sys_id=468b4d1eb7221010a2bb8a04ae11a964

View solution in original post

Community Alums · ‎09-03-2023

Please validate if Software Product Lifecycle table has data populated. Lifecycle report table gets data from Product Lifecycle and calculate/populate fields in Lifecycle Report table.

psyherin · ‎09-03-2023

Hi Rajneesh,

The Software Product Lifecycle table has data populated. What I have noticed is on this table all the data records are inactive. Does it need to be active? Why would they all be inactive?

Community Alums · ‎09-05-2023

Yes, it needs to be active to be included in Lifecycle report

psyherin · ‎09-07-2023

Hi @Community Alums ,

All the records on the software product lifecycle table are inactive. Also the content_active is true. how does these records are made active? I cannot see any BR or scripts for this table which make these records active.

Also for testing purposes in PDI I tried couple of records and made it inactive and then ran the scheduled job it still collected the data and populated it on the lifecycle report.

I am now confused even more.