Missing choices 'Automatically run a script to create a report summary' of Scheduled Jobs

[amy56]

I have created a scheduled job as ‘Automatically run a script to create a report summary table’ at our DEV, but when I try to deploy it to UAT by update set I found it failed with error message as ‘Could not find a table sysauto_summary_generator this update requires’. Then I checked UAT Scheduled Jobs module and found the new create choice list without ‘Automatically run a script to create a report summary table’ option. Please refer to my below screenshots for the detail. Please help to advise what’s the matter and how to add it to UAT, many thanks!

[Rahul Talreja · Accepted solution]

Hi @amy56 ,

It seems like the issue is related to the fact that the 'sysauto_summary_generator' table does not exist in the UAT environment. The scheduled job 'Automatically run a script to create a report summary table' might be relying on this table which exists in your DEV environment but not in the UAT.

As for the new create choice list without ‘Automatically run a script to create a report summary table’, it could be due to the absence of the table or the script itself in the UAT environment.

Here are some steps you can take to resolve the issue:

1. Check if the 'sysauto_summary_generator' table exists in the UAT environment.
2. If not, you should recreate it or import it from the DEV environment.
3. If the table is there, check if the scheduled job 'Automatically run a script to create a report summary table' is properly referencing this table.
4. For the choice list, make sure that the script and its dependencies are properly deployed to UAT.

[Mayur2109]

Hi @amy56 ,

From the error  ‘Could not find a table sysauto_summary_generator this update requires’ is seems sysauto_summary_generator is not present on UAT instance can you check if any table with such name is present on dev and missing on uat instance.

Please check and Mark Helpful and Correct if it really helps you.

Regards,
Mayur Shardul

[amy56]

Hi Mayur,

Yes, I can find the table 'sysauto_summary_generator' at Dev but can't find it at UAT. It seems somebody has applied something on DEV but not UAT. I just wonder what is it. 

[Mayur2109 · Accepted solution]

HI @amy56 ,

Then you need to have the same table on UAT also that will solve your issue.You can move the same table from dev to uat using update sets, once you are done with moving table again move you changes that should work. For the safer side check the scripts related to table are in place on UAT instance.

Please check and Mark Helpful and Correct if it really helps you.

Regards,
Mayur Shardul

[Rahul Talreja · Accepted solution]

Hi @amy56 ,

It seems like the issue is related to the fact that the 'sysauto_summary_generator' table does not exist in the UAT environment. The scheduled job 'Automatically run a script to create a report summary table' might be relying on this table which exists in your DEV environment but not in the UAT.

As for the new create choice list without ‘Automatically run a script to create a report summary table’, it could be due to the absence of the table or the script itself in the UAT environment.

Here are some steps you can take to resolve the issue:

1. Check if the 'sysauto_summary_generator' table exists in the UAT environment.
2. If not, you should recreate it or import it from the DEV environment.
3. If the table is there, check if the scheduled job 'Automatically run a script to create a report summary table' is properly referencing this table.
4. For the choice list, make sure that the script and its dependencies are properly deployed to UAT.