Skip to main content
S
sagarmemane921-Visitor
1-Visitor
February 20, 2020
Solved

Anyone used the scheduler in 8.5 version.

  • February 20, 2020
  • 9 replies
  • 2889 views

I am trying to used the scheduler but unfortunately my subscription not called for scheduler .Didn't get the exact solution while digging it.

Need help !!

 

 

Thanks in advance 

Best answer by Constantine

Well, it depends on what you put in the timestamp field when you save data in that datatable.

 

One way to troubleshoot it is by opening this datatable in Composer and go to its Mashup -- this will give you a preview of what's inside. 

 

Also try to wrap filters into an array, like this:

"filters": [{

 

Finally, in 90% of cases you should use Streams or ValueStreams instead of DataTables -- they are indexed by timestamp and thus optimized for such kind of queries. Your data table will start slowing your system down after it receives few thousands of records, which usually happens very soon.

 

/ Constantine

9 replies

S
slangleyCommunity Manager
Support
February 20, 2020

Hi @sagarmemane92.

 

I'm not clear on the issue.  Can you please provide more details.  Are you getting an error?  Screenshots may be helpful.

 

Regards.

 

--Sharon

S
sagarmemane921-VisitorAuthor
1-Visitor
February 24, 2020

Hey Slangley,

 

I want to send the data automatically.I am using the data table .In service i am fetching the data and in subscription i am sending trying to send the data in html format through mail.But unfortunately my subscription not calling .I don't exactly error.(Script log- Error in: EMS_Scheduler_Sagar.Weekly_PF_Report javascript service)

Here I am attaching the service and subscription file 

 

 

Thanks in advance 

 

Sagar

 

C
Constantine18-Opal
18-Opal
February 24, 2020

Hello Sagar,

 

Here, in the very first line you should use "logger" instead of "Logger":

Logger.warn("Gandtay");

 

/ Constantine 

C
Constantine18-Opal
18-Opal
February 21, 2020

Hello @sagarmemane92 ,

 

  1. Make sure that the Scheduler is enabled;
  2. Make sure that the Subscription is enabled;
  3. Make sure the Scheduler executes under a user with sufficient access rights. For testing try Administrator;
  4. Check your cron string (ThingWorx syntax is not 100% compatible with that of the classic cron);

/ Constantine

S
sagarmemane921-VisitorAuthor
1-Visitor
February 24, 2020

Hi Constantine,

 

 Thanks For feedback ,

 

But i already did this changes.But still my subscription is not calling.Even in subscription Logger.warn("error); is also not working

 

I am attaching mu service and subscription here.

 

Regards

Sagar

Terms & ConditionsAccessibility statement