REST API not working?
Since the last windowsupdate batch we are having problems with the RESTAPI.
When I enter the following URL:
https://sdplus.local/sdpapi/request/286618/
I get an error like this:
This XML file does not appear to have any style information associated with it. The document tree is shown below.
<API version="1.0">
<response>
<operation name="">
<result>
<status>
Failed
</status>
<message>
Error when performing - null - null
</message>
</result>
</operation>
</response>
</API>
In server out-logfile I can see the following:
[16:20:52:105]|[11-21-2017]|[com.manageengine.servicedesk.jobexecutors.MailNotificationJobExecutor]|[INFO]|[120]|: Constructor called with this.jobInfoObject: {"jobId":[7681446],"moduleName":["MAIL_NOTIFICATION_JOB"],"executorClass":["com.manageengine.servicedesk.jobexecutors.MailNotificationJobExecutor"],"jobInput":["{\"ENTITY_NAME\":\"WORKORDER\",\"ENTITY_ID\":286618,\"NOTIFY_TYPE\":\"UnpickedQueueReqTechNotify_E-Mail\",\"NOTIFY_FROM\":\"QUEUEUTIL\"}"],"jobInputObjectStore":[null],"errorInfo":[null]}|
[16:20:52:105]|[11-21-2017]|[com.manageengine.servicedesk.jobexecutors.SDPJobExecutorImpl]|[INFO]|[120]|: entityId:::286618|
[16:20:52:293]|[11-21-2017]|[com.adventnet.db.adapter.mssql.MssqlSQLGenerator]|[WARNING]|[120]|: Old API is being used to form range query Kindly use proper column alias if the same column names are added to form range query with MSSQL.|
[16:20:52:355]|[11-21-2017]|[com.manageengine.jobscheduler.JobQueue]|[INFO]|[120]|: queueOverFlow: false; isPendingJobAvailableInDB: false; canAddOneTimeJobToQueue: true|
[16:20:52:355]|[11-21-2017]|[com.manageengine.jobscheduler.JobQueue]|[INFO]|[120]|: OTJ added to: DB and QUEUE; jobId: 7681446; current jobQueueSize:1|
[16:20:52:355]|[11-21-2017]|[com.manageengine.jobscheduler.JobExecutor]|[INFO]|[132]|: JobExecutor instance created for JobId: 7681446; jobInfoObject: {"jobId":[7681446],"moduleName":["MAIL_NOTIFICATION_JOB"],"executorClass":["com.manageengine.servicedesk.jobexecutors.MailNotificationJobExecutor"],"jobInput":["{\"ENTITY_NAME\":\"WORKORDER\",\"ENTITY_ID\":286618,\"NOTIFY_TYPE\":\"UnpickedQueueReqTechNotify_E-Mail\",\"NOTIFY_FROM\":\"QUEUEUTIL\"}"],"jobInputObjectStore":["com.manageengine.jobscheduler.JobInputObjectStore@2531dc1d"],"errorInfo":[null]}|
[16:20:52:355]|[11-21-2017]|[com.manageengine.jobscheduler.JobScheduler]|[INFO]|[132]|: Starting to get job from queue to execute.|
[16:20:52:355]|[11-21-2017]|[com.manageengine.servicedesk.jobexecutors.SDPJobExecutorImpl]|[INFO]|[1994]|: Constructor called for job Id: 7681446|
[16:20:52:355]|[11-21-2017]|[com.manageengine.servicedesk.jobexecutors.MailNotificationJobExecutor]|[INFO]|[1994]|: Constructor called with this.jobInfoObject: {"jobId":[7681446],"moduleName":["MAIL_NOTIFICATION_JOB"],"executorClass":["com.manageengine.servicedesk.jobexecutors.MailNotificationJobExecutor"],"jobInput":["{\"ENTITY_NAME\":\"WORKORDER\",\"ENTITY_ID\":286618,\"NOTIFY_TYPE\":\"UnpickedQueueReqTechNotify_E-Mail\",\"NOTIFY_FROM\":\"QUEUEUTIL\"}"],"jobInputObjectStore":["com.manageengine.jobscheduler.JobInputObjectStore@2531dc1d"],"errorInfo":[null]}|
[16:20:52:355]|[11-21-2017]|[com.manageengine.servicedesk.jobexecutors.SDPJobExecutorImpl]|[INFO]|[2039]|: entityId:::286618|
[16:20:52:355]|[11-21-2017]|[com.manageengine.jobscheduler.JobExecutorImpl]|[INFO]|[2039]|: after loadJobInputObjectStore - this.jobInfoObject: {"jobId":[7681446],"moduleName":["MAIL_NOTIFICATION_JOB"],"executorClass":["com.manageengine.servicedesk.jobexecutors.MailNotificationJobExecutor"],"jobInput":["{\"ENTITY_NAME\":\"WORKORDER\",\"ENTITY_ID\":286618,\"NOTIFY_TYPE\":\"UnpickedQueueReqTechNotify_E-Mail\",\"NOTIFY_FROM\":\"QUEUEUTIL\"}"],"jobInputObjectStore":["com.manageengine.jobscheduler.JobInputObjectStore@2531dc1d"],"errorInfo":[null]}|
[16:20:52:355]|[11-21-2017]|[com.adventnet.servicedesk.utils.WorkOrderUtil]|[INFO]|[120]|: unpickedDueTime********************************************************1511334017897|
[16:20:52:355]|[11-21-2017]|[com.adventnet.servicedesk.utils.WorkOrderUtil]|[INFO]|[120]|: unpickedDueTime********************************************************1511188764350|
[16:20:52:355]|[11-21-2017]|[com.adventnet.servicedesk.utils.WorkOrderUtil]|[INFO]|[120]|: unpickedDueTime********************************************************1511364600000|
[16:20:52:355]|[11-21-2017]|[com.adventnet.servicedesk.utils.WorkOrderUtil]|[INFO]|[120]|: unpickedDueTime********************************************************1511364600000|
[16:20:52:355]|[11-21-2017]|[com.adventnet.servicedesk.utils.WorkOrderUtil]|[INFO]|[120]|: unpickedDueTime********************************************************1511364600000|
[16:20:52:355]|[11-21-2017]|[com.manageengine.jobscheduler.JobExecutorImpl]|[INFO]|[2039]|: preExecute end for job Id: 7681446|
[16:20:52:355]|[11-21-2017]|[com.manageengine.servicedesk.jobexecutors.MailNotificationJobExecutor]|[INFO]|[2039]|: Started processing job: 7681446; jobInfoObject: {"jobId":[7681446],"moduleName":["MAIL_NOTIFICATION_JOB"],"executorClass":["com.manageengine.servicedesk.jobexecutors.MailNotificationJobExecutor"],"jobInput":["{\"ENTITY_NAME\":\"WORKORDER\",\"ENTITY_ID\":286618,\"NOTIFY_TYPE\":\"UnpickedQueueReqTechNotify_E-Mail\",\"NOTIFY_FROM\":\"QUEUEUTIL\"}"],"jobInputObjectStore":["com.manageengine.jobscheduler.JobInputObjectStore@2531dc1d"],"errorInfo":[null]}|
[16:20:52:355]|[11-21-2017]|[com.manageengine.servicedesk.jobexecutors.MailNotificationJobExecutor]|[INFO]|[2039]|: execute:::jobInput: {"ENTITY_NAME":"WORKORDER","ENTITY_ID":286618,"NOTIFY_TYPE":"UnpickedQueueReqTechNotify_E-Mail","NOTIFY_FROM":"QUEUEUTIL"}; jobInputObjectStore: com.manageengine.jobscheduler.JobInputObjectStore@2531dc1d|
[16:20:52:355]|[11-21-2017]|[com.adventnet.servicedesk.utils.WorkOrderUtil]|[INFO]|[120]|: unpickedDueTime********************************************************1511364600000|
[16:20:52:355]|[11-21-2017]|[com.adventnet.servicedesk.utils.WorkOrderUtil]|[INFO]|[120]|: unpickedDueTime********************************************************1511191800000|
[16:20:52:355]|[11-21-2017]|[com.adventnet.servicedesk.util.QueueUtil]|[INFO]|[2039]|: Notify Filter condition matched. Hence not sending the queue notification for request ID 286618|
[16:20:52:355]|[11-21-2017]|[com.manageengine.servicedesk.jobexecutors.MailNotificationJobExecutor]|[INFO]|[2039]|: Successfully executed the job Id:: 7681446; notifyFrom: QUEUEUTIL|
[16:20:52:355]|[11-21-2017]|[com.manageengine.jobscheduler.JobExecutorImpl]|[INFO]|[2039]|: deleteJobOnComplete job Id: 7681446|
[16:20:52:355]|[11-21-2017]|[com.manageengine.jobscheduler.JobExecutorImpl]|[INFO]|[2039]|: postExecute end for job Id: 7681446|
[16:20:52:355]|[11-21-2017]|[com.adventnet.servicedesk.utils.WorkOrderUtil]|[INFO]|[120]|: unpickedDueTime********************************************************1511278200000|
[16:20:52:465]|[11-21-2017]|[com.manageengine.jobscheduler.JobExecutor]|[INFO]|[1994]|: Going to shutdown the executor for the job Id:7681446|
[16:20:52:527]|[11-21-2017]|[com.manageengine.jobscheduler.JobExecutor]|[INFO]|[1994]|: Initiated executor shutdown for the job Id: 7681446|
[16:20:52:527]|[11-21-2017]|[com.manageengine.jobscheduler.JobExecutor]|[INFO]|[1994]|: Job execution completed for job id: 7681446|
[16:20:52:527]|[11-21-2017]|[com.adventnet.servicedesk.utils.WorkOrderUtil]|[INFO]|[120]|: unpickedDueTime********************************************************1511364600000|
[16:20:52:527]|[11-21-2017]|[com.adventnet.servicedesk.utils.WorkOrderUtil]|[INFO]|[120]|: unpickedDueTime********************************************************1511364600000|
[16:20:52:636]|[11-21-2017]|[com.adventnet.servicedesk.utils.WorkOrderUtil]|[INFO]|[120]|: unpickedDueTime********************************************************1511334007647|
[16:20:52:902]|[11-21-2017]|[com.adventnet.servicedesk.utils.WorkOrderUtil]|[INFO]|[120]|: unpickedDueTime********************************************************1511253638090|
[16:20:52:902]|[11-21-2017]|[com.adventnet.servicedesk.utils.WorkOrderUtil]|[INFO]|[120]|: unpickedDueTime********************************************************1511421577985|
[16:20:53:043]|[11-21-2017]|[com.manageengine.jobscheduler.JobQueueFiller]|[INFO]|[133]|: Starting job queue filler in the interval:20000|
[16:20:53:043]|[11-21-2017]|[com.manageengine.jobscheduler.JobQueue]|[INFO]|[133]|: checkAndFillQueueFromDB: jobQueueSize: 0; jobInfoQueueSize: 300|
[16:20:53:043]|[11-21-2017]|[com.manageengine.jobscheduler.JobQueue]|[INFO]|[133]|: JobQueue.size is less than JobInfoQueueSize. So going to fill from db if available in DB|
[16:20:53:043]|[11-21-2017]|[com.manageengine.jobscheduler.JobSchedulerUtil]|[INFO]|[133]|: thresholdCount: 360; getJobInfoQueueThreasholdPercentageToRefill: 120; getJobInfoQueueSize(): 300; numberOfJobsInJobQueue: 0|
[16:20:53:043]|[11-21-2017]|[com.adventnet.db.adapter.mssql.MssqlSQLGenerator]|[WARNING]|[133]|: Old API is being used to form range query Kindly use proper column alias if the same column names are added to form range query with MSSQL.|
[16:20:52:105]|[11-21-2017]|[com.manageengine.servicedesk.jobexecutors.SDPJobExecutorImpl]|[INFO]|[120]|: entityId:::286618|
[16:20:52:293]|[11-21-2017]|[com.adventnet.db.adapter.mssql.MssqlSQLGenerator]|[WARNING]|[120]|: Old API is being used to form range query Kindly use proper column alias if the same column names are added to form range query with MSSQL.|
[16:20:52:355]|[11-21-2017]|[com.manageengine.jobscheduler.JobQueue]|[INFO]|[120]|: queueOverFlow: false; isPendingJobAvailableInDB: false; canAddOneTimeJobToQueue: true|
[16:20:52:355]|[11-21-2017]|[com.manageengine.jobscheduler.JobQueue]|[INFO]|[120]|: OTJ added to: DB and QUEUE; jobId: 7681446; current jobQueueSize:1|
[16:20:52:355]|[11-21-2017]|[com.manageengine.jobscheduler.JobExecutor]|[INFO]|[132]|: JobExecutor instance created for JobId: 7681446; jobInfoObject: {"jobId":[7681446],"moduleName":["MAIL_NOTIFICATION_JOB"],"executorClass":["com.manageengine.servicedesk.jobexecutors.MailNotificationJobExecutor"],"jobInput":["{\"ENTITY_NAME\":\"WORKORDER\",\"ENTITY_ID\":286618,\"NOTIFY_TYPE\":\"UnpickedQueueReqTechNotify_E-Mail\",\"NOTIFY_FROM\":\"QUEUEUTIL\"}"],"jobInputObjectStore":["com.manageengine.jobscheduler.JobInputObjectStore@2531dc1d"],"errorInfo":[null]}|
[16:20:52:355]|[11-21-2017]|[com.manageengine.jobscheduler.JobScheduler]|[INFO]|[132]|: Starting to get job from queue to execute.|
[16:20:52:355]|[11-21-2017]|[com.manageengine.servicedesk.jobexecutors.SDPJobExecutorImpl]|[INFO]|[1994]|: Constructor called for job Id: 7681446|
[16:20:52:355]|[11-21-2017]|[com.manageengine.servicedesk.jobexecutors.MailNotificationJobExecutor]|[INFO]|[1994]|: Constructor called with this.jobInfoObject: {"jobId":[7681446],"moduleName":["MAIL_NOTIFICATION_JOB"],"executorClass":["com.manageengine.servicedesk.jobexecutors.MailNotificationJobExecutor"],"jobInput":["{\"ENTITY_NAME\":\"WORKORDER\",\"ENTITY_ID\":286618,\"NOTIFY_TYPE\":\"UnpickedQueueReqTechNotify_E-Mail\",\"NOTIFY_FROM\":\"QUEUEUTIL\"}"],"jobInputObjectStore":["com.manageengine.jobscheduler.JobInputObjectStore@2531dc1d"],"errorInfo":[null]}|
[16:20:52:355]|[11-21-2017]|[com.manageengine.servicedesk.jobexecutors.SDPJobExecutorImpl]|[INFO]|[2039]|: entityId:::286618|
[16:20:52:355]|[11-21-2017]|[com.manageengine.jobscheduler.JobExecutorImpl]|[INFO]|[2039]|: after loadJobInputObjectStore - this.jobInfoObject: {"jobId":[7681446],"moduleName":["MAIL_NOTIFICATION_JOB"],"executorClass":["com.manageengine.servicedesk.jobexecutors.MailNotificationJobExecutor"],"jobInput":["{\"ENTITY_NAME\":\"WORKORDER\",\"ENTITY_ID\":286618,\"NOTIFY_TYPE\":\"UnpickedQueueReqTechNotify_E-Mail\",\"NOTIFY_FROM\":\"QUEUEUTIL\"}"],"jobInputObjectStore":["com.manageengine.jobscheduler.JobInputObjectStore@2531dc1d"],"errorInfo":[null]}|
[16:20:52:355]|[11-21-2017]|[com.adventnet.servicedesk.utils.WorkOrderUtil]|[INFO]|[120]|: unpickedDueTime********************************************************1511334017897|
[16:20:52:355]|[11-21-2017]|[com.adventnet.servicedesk.utils.WorkOrderUtil]|[INFO]|[120]|: unpickedDueTime********************************************************1511188764350|
[16:20:52:355]|[11-21-2017]|[com.adventnet.servicedesk.utils.WorkOrderUtil]|[INFO]|[120]|: unpickedDueTime********************************************************1511364600000|
[16:20:52:355]|[11-21-2017]|[com.adventnet.servicedesk.utils.WorkOrderUtil]|[INFO]|[120]|: unpickedDueTime********************************************************1511364600000|
[16:20:52:355]|[11-21-2017]|[com.adventnet.servicedesk.utils.WorkOrderUtil]|[INFO]|[120]|: unpickedDueTime********************************************************1511364600000|
[16:20:52:355]|[11-21-2017]|[com.manageengine.jobscheduler.JobExecutorImpl]|[INFO]|[2039]|: preExecute end for job Id: 7681446|
[16:20:52:355]|[11-21-2017]|[com.manageengine.servicedesk.jobexecutors.MailNotificationJobExecutor]|[INFO]|[2039]|: Started processing job: 7681446; jobInfoObject: {"jobId":[7681446],"moduleName":["MAIL_NOTIFICATION_JOB"],"executorClass":["com.manageengine.servicedesk.jobexecutors.MailNotificationJobExecutor"],"jobInput":["{\"ENTITY_NAME\":\"WORKORDER\",\"ENTITY_ID\":286618,\"NOTIFY_TYPE\":\"UnpickedQueueReqTechNotify_E-Mail\",\"NOTIFY_FROM\":\"QUEUEUTIL\"}"],"jobInputObjectStore":["com.manageengine.jobscheduler.JobInputObjectStore@2531dc1d"],"errorInfo":[null]}|
[16:20:52:355]|[11-21-2017]|[com.manageengine.servicedesk.jobexecutors.MailNotificationJobExecutor]|[INFO]|[2039]|: execute:::jobInput: {"ENTITY_NAME":"WORKORDER","ENTITY_ID":286618,"NOTIFY_TYPE":"UnpickedQueueReqTechNotify_E-Mail","NOTIFY_FROM":"QUEUEUTIL"}; jobInputObjectStore: com.manageengine.jobscheduler.JobInputObjectStore@2531dc1d|
[16:20:52:355]|[11-21-2017]|[com.adventnet.servicedesk.utils.WorkOrderUtil]|[INFO]|[120]|: unpickedDueTime********************************************************1511364600000|
[16:20:52:355]|[11-21-2017]|[com.adventnet.servicedesk.utils.WorkOrderUtil]|[INFO]|[120]|: unpickedDueTime********************************************************1511191800000|
[16:20:52:355]|[11-21-2017]|[com.adventnet.servicedesk.util.QueueUtil]|[INFO]|[2039]|: Notify Filter condition matched. Hence not sending the queue notification for request ID 286618|
[16:20:52:355]|[11-21-2017]|[com.manageengine.servicedesk.jobexecutors.MailNotificationJobExecutor]|[INFO]|[2039]|: Successfully executed the job Id:: 7681446; notifyFrom: QUEUEUTIL|
[16:20:52:355]|[11-21-2017]|[com.manageengine.jobscheduler.JobExecutorImpl]|[INFO]|[2039]|: deleteJobOnComplete job Id: 7681446|
[16:20:52:355]|[11-21-2017]|[com.manageengine.jobscheduler.JobExecutorImpl]|[INFO]|[2039]|: postExecute end for job Id: 7681446|
[16:20:52:355]|[11-21-2017]|[com.adventnet.servicedesk.utils.WorkOrderUtil]|[INFO]|[120]|: unpickedDueTime********************************************************1511278200000|
[16:20:52:465]|[11-21-2017]|[com.manageengine.jobscheduler.JobExecutor]|[INFO]|[1994]|: Going to shutdown the executor for the job Id:7681446|
[16:20:52:527]|[11-21-2017]|[com.manageengine.jobscheduler.JobExecutor]|[INFO]|[1994]|: Initiated executor shutdown for the job Id: 7681446|
[16:20:52:527]|[11-21-2017]|[com.manageengine.jobscheduler.JobExecutor]|[INFO]|[1994]|: Job execution completed for job id: 7681446|
[16:20:52:527]|[11-21-2017]|[com.adventnet.servicedesk.utils.WorkOrderUtil]|[INFO]|[120]|: unpickedDueTime********************************************************1511364600000|
[16:20:52:527]|[11-21-2017]|[com.adventnet.servicedesk.utils.WorkOrderUtil]|[INFO]|[120]|: unpickedDueTime********************************************************1511364600000|
[16:20:52:636]|[11-21-2017]|[com.adventnet.servicedesk.utils.WorkOrderUtil]|[INFO]|[120]|: unpickedDueTime********************************************************1511334007647|
[16:20:52:902]|[11-21-2017]|[com.adventnet.servicedesk.utils.WorkOrderUtil]|[INFO]|[120]|: unpickedDueTime********************************************************1511253638090|
[16:20:52:902]|[11-21-2017]|[com.adventnet.servicedesk.utils.WorkOrderUtil]|[INFO]|[120]|: unpickedDueTime********************************************************1511421577985|
[16:20:53:043]|[11-21-2017]|[com.manageengine.jobscheduler.JobQueueFiller]|[INFO]|[133]|: Starting job queue filler in the interval:20000|
[16:20:53:043]|[11-21-2017]|[com.manageengine.jobscheduler.JobQueue]|[INFO]|[133]|: checkAndFillQueueFromDB: jobQueueSize: 0; jobInfoQueueSize: 300|
[16:20:53:043]|[11-21-2017]|[com.manageengine.jobscheduler.JobQueue]|[INFO]|[133]|: JobQueue.size is less than JobInfoQueueSize. So going to fill from db if available in DB|
[16:20:53:043]|[11-21-2017]|[com.manageengine.jobscheduler.JobSchedulerUtil]|[INFO]|[133]|: thresholdCount: 360; getJobInfoQueueThreasholdPercentageToRefill: 120; getJobInfoQueueSize(): 300; numberOfJobsInJobQueue: 0|
[16:20:53:043]|[11-21-2017]|[com.adventnet.db.adapter.mssql.MssqlSQLGenerator]|[WARNING]|[133]|: Old API is being used to form range query Kindly use proper column alias if the same column names are added to form range query with MSSQL.|