Why Scheduled jobs stops working suddenly

k232
Giga Contributor

‎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

 

 

0 Helpfuls
  • 738 Views
5 REPLIES 5

Kristen Ankeny
Kilo Sage

‎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. 

0 Helpfuls

k232
Giga Contributor
In response to Kristen Ankeny

‎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.

 

 

k232_0-1682359685656.png

 

 

0 Helpfuls

Kristen Ankeny
Kilo Sage
In response to k232

‎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. 

0 Helpfuls

k232
Giga Contributor
In response to Kristen Ankeny

‎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 .

0 Helpfuls