Why Scheduled jobs stops working suddenly
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-24-2023 10:39 AM
Hi All,
We are not understanding that why Scheduled job stops working all of suddenly from last 5-days.
we have custom application, we have scheduled job against Custom application of custom tables. we found that data not updating from last 5-days, for Code testing we used scheduled job code in Background script and ran .
code executed forcefully and got Error Message like this
Error Message : on Task table 'sn_esign_esignature_configuration' field was deactivated Last Year only.
QueryEventLogger: Invalid query detected, please check logs for details [Unknown field sn_esign_esignature_configuration.document_type in table incident]
Invalid query detected, please check logs for details [Unknown field sn_esign_esignature_configuration in table incident]
any solution for this please
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-24-2023 10:59 AM
Have you looked at the incident table for the field "sn_esign_esignature_configuration? It seems your query looks for the document_type field on this reference record. But it looks like it's not finding the field on the incident table.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-24-2023 11:09 AM
Hi Kristen,
sn_esign_esignature_configuration is on TASK table , this field deactivated 1-year back.
Custom Table extended from " Task " table and we not using 'sn_esign_esignature_configuration' any where in custom table scripts.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-24-2023 11:37 AM
I would suggest doing a code search via Studio (you can search against all apps), to see what your code might be triggering that is causing that error. Is there a reason that the field was deactivated? Checking a PDI that is OOB, that field shows active.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-24-2023 11:42 AM
Yes I will check via Studio.
But still wondering part is this field Deactivated Last year May-2022,
But we designed Scheduled job on January-2023, it was running smoothly till last -5days back, since 5-days we are seeing that Job Not running .
if it is making issue then it has to stop working at first place when we deployed code . but since 4month we haven't seen any issue, issue occurred from last 5-days that is mysteries .