reports from sc_task table, not showing Catalog Variables data in report.

[Deepchand_Yadav]

reports from sc_task table, Started not showing Catalog Variables data in report. Earlier it used to show data and customers were using it to report.

When i have a deeper look into that , i found one workaround as flipped the Catalog Variables field "Global = True" and then refreshed the report underlying data in variables were started showing.

So wanted to check if this is known issue, or is there any other reason for sudden disappearing of variable data in report.

[Robbie · Accepted solution]

Hi @Deepchand_Yadav,

Typically variables are restricted to the Requested Item view by default.

By setting the Global attribute to true enables the variables to be available and visible on both the requested item as well as the catalog task.

The fact you're reporting from the catalog task table would require this attribute to be set to true.

With regards to why it worked previously, was this for a particular item or items? Has the report been updated? The Global attribute is per item so this could explain the behaviour.

To help others (or for me to help you more directly), please mark this response correct by clicking on Accept as Solution and/or Helpful.

Thanks, Robbie

[Robbie · Accepted solution]

Hi @Deepchand_Yadav,

Did you see my earlier response?

Typically variables are restricted to the Requested Item view by default.

By setting the Global attribute to true enables the variables to be available and visible on both the requested item as well as the catalog task.

The fact you're reporting from the catalog task table would require this attribute to be set to true.

With regards to why it worked previously, was this for a particular item or items? Has the report been updated? The Global attribute is per item so this could explain the behaviour.

To help others (or for me to help you more directly), please mark this response correct by clicking on Accept as Solution and/or Helpful.

Thanks, Robbie

[Deepchand_Yadav]

Service Now updated it was known internal Problem PRB1329985 and its fixed in Rome & higher version. But for already existing customers it has to be enabled manually.

the system property mentioned is: 

glide.script.partial_record_materializer.enabled  needs to be made true.