Spotfire Ideas Portal
We make use of the public web service UpdateAnalysisService to trigger scheduled updates externally after a data refresh.
Sometimes the scheduled updates fail. The only way to check this, is to manually log on at the Spotfire Server, go to the Scheduling & Routing tab and check the activities. We would really like to check the status of the scheduled updates which have been triggered externally via the public web service. In this way we can provide automated feedback on successes or failures.
Also this is unsupported but have a look at this page in your server:
/spotfire/rest/jobs/listAllInstancesDetail
Enable Action Logging and use a query like the one below:
SELECT ACTION_LOG_ID,
TO_CHAR(CAST(aclo.ORIGINAL_TIME AS DATE), 'DD-Mon-YYYY HH24:MI') AS REFRESH_DATE_TIME,
CAST((SYSDATE - CAST(aclo.ORIGINAL_TIME AS DATE)) * 86400 AS INTEGER) AS SECS_SINCE_EVENT,
INITCAP(aclo.LOG_ACTION) AS EVENT_TYPE,
aclo.SUCCESS,
aclo.ID2 AS ANALYSIS_PATH,
SUBSTR(aclo.ID2, 2, INSTR(aclo.ID2, '/', 2) - 2) AS APP_NAME,
SUBSTR(aclo.ID2, INSTR(aclo.ID2, '/', -1) +1) AS ANALYSIS_NAME,
aclo.ARG2 AS ERROR_MESSAGE,
'https://[your server]/spotfire/wp/ViewAnalysis.aspx?file=' || REPLACE(aclo.ID2, ' ', '%20') AS REPORT_URL
FROM ACTIONLOG aclo,
NODE_SERVICES nose
WHERE aclo.LOG_CATEGORY = 'library_wp' AND aclo.LOG_ACTION IN('update', 'load')
AND aclo.USER_NAME = 'scheduledupdates@SPOTFIRESYSTEM'
AND aclo.ARG3 = 'SchedulerUserSession'
AND aclo.ORIGINAL_TIME >= SYSTIMESTAMP - 10/1440
AND aclo.ARG5 = nose.ID (+)
AND aclo.ACTION_LOG_ID IS NOT NULL
ORDER BY aclo.ORIGINAL_TIME DESC