Hi!
After the windowsupdatebatch the RESTAPI for SD+ stopped working.

If I try the following:  https://sdplus.site.com/sdpapi/request/286618

I get back:

This XML file does not appear to have any style information associated with it. The document tree is shown below.

In the serverout-logfile I can see the following: I was wondering if the line " 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.|" is the culpit?

[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|