ServiceNow Conector: Invalid table x_rsnbv_redwood_nw_incident

Symptoms

After Creating ServiceNow Connector, when running one of the provided definition for ServiceNow (ie: Redwood_SNOW_CreateIncident) the following error appear:

ERROR 2023-11-17 16:57:47,754 GMT [Redwood Job Thread Pool: GLOBAL.SNOW_ProcessServer.ServiceForRedwood_ServiceNow worker 0-Executor 1094022] job.Redwood_SNOW_CreateIncident.16111145 - Exception thrown while creating the incident.
com.redwood.servicenow.shared.model.ServiceNowHttpException: Request failed with code 400: Bad Request. Cause: Invalid table x_rsnbv_redwood_nw_incident: null. (Status: failure)

Resolution

The 'Redwood Automation Connector' ServiceNow application from the ServiceNow App Store must be installed into your ServiceNow instance.

This application will create the necessary table for the request to properly work.

Error

stdout.log:

ERROR 2023-11-17 16:57:47,754 GMT [Redwood Job Thread Pool: GLOBAL.SNOW_ProcessServer.ServiceForRedwood_ServiceNow worker 0-Executor 1094022] job.Redwood_SNOW_CreateIncident.16111145 - Exception thrown while creating the incident.
com.redwood.servicenow.shared.model.ServiceNowHttpException: Request failed with code 400: Bad Request. Cause: Invalid table x_rsnbv_redwood_nw_incident: null. (Status: failure)
at Library REDWOOD.Redwood_ServiceNow//com.redwood.servicenow.shared.model.ServiceNowHttpException.createFromResponse(ServiceNowHttpException.java:63)
at Library REDWOOD.Redwood_ServiceNow//com.redwood.servicenow.shared.client.ServiceNowNoAuthClient.sendWithBody(ServiceNowNoAuthClient.java:174)
at Library REDWOOD.Redwood_ServiceNow//com.redwood.servicenow.shared.client.ServiceNowClient.createIncident(ServiceNowClient.java:153)
at Library REDWOOD.Redwood_ServiceNow//com.redwood.scheduler.app.servicenow.ServiceNowCreateIncidentTask.onExecute(ServiceNowCreateIncidentTask.java:152)
at Library REDWOOD.Redwood_ServiceNow//com.redwood.scheduler.custom.app.extensions_shared.model.CustomJobDefinitionBase.execute(CustomJobDefinitionBase.java:53)
at Library REDWOOD.Redwood_ServiceNow//com.redwood.scheduler.app.servicenow.ServiceNowJobExecutor.execute(ServiceNowJobExecutor.java:28)
at com.redwood.scheduler.customjob.service.CustomJobInstance.lambda$execute$0(CustomJobInstance.java:88)
at com.redwood.scheduler.script.java.impl.classloader.ThreadContextRunnable.call(ThreadContextRunnable.java:48)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
at java.base/java.lang.Thread.run(Thread.java:833)

Stderr.log:

-- JOB RUN STACK TRACE --
java.util.concurrent.ExecutionException: com.redwood.servicenow.shared.model.ServiceNowHttpException: Request failed with code 400: Bad Request. Cause: Invalid table x_rsnbv_redwood_nw_incident: null. (Status: failure)
at java.base/java.util.concurrent.FutureTask.report(FutureTask.java:122)
at java.base/java.util.concurrent.FutureTask.get(FutureTask.java:191)
at com.redwood.scheduler.script.java.impl.Java.evaluateCallableInt(Java.java:157)
at com.redwood.scheduler.customjob.service.CustomJobInstance.execute(CustomJobInstance.java:88)
at com.redwood.scheduler.systemjobservice.api.JobWorker.runProcessExecute(JobWorker.java:267)
at com.redwood.scheduler.systemjobservice.api.JobWorker.processExecute(JobWorker.java:204)
at com.redwood.scheduler.systemjobservice.api.JobWorker.doWork(JobWorker.java:125)
at com.redwood.scheduler.systemjobservice.api.JobWorker.doWork(JobWorker.java:64)
at com.redwood.scheduler.infrastructure.workqueue.WorkQueueWorker.run(WorkQueueWorker.java:72)
at java.base/java.lang.Thread.run(Thread.java:833)
Caused by: com.redwood.servicenow.shared.model.ServiceNowHttpException: Request failed with code 400: Bad Request. Cause: Invalid table x_rsnbv_redwood_nw_incident: null. (Status: failure)
at Library REDWOOD.Redwood_ServiceNow//com.redwood.servicenow.shared.model.ServiceNowHttpException.createFromResponse(ServiceNowHttpException.java:63)
at Library REDWOOD.Redwood_ServiceNow//com.redwood.servicenow.shared.client.ServiceNowNoAuthClient.sendWithBody(ServiceNowNoAuthClient.java:174)
at Library REDWOOD.Redwood_ServiceNow//com.redwood.servicenow.shared.client.ServiceNowClient.createIncident(ServiceNowClient.java:153)
at Library REDWOOD.Redwood_ServiceNow//com.redwood.scheduler.app.servicenow.ServiceNowCreateIncidentTask.onExecute(ServiceNowCreateIncidentTask.java:152)
at Library REDWOOD.Redwood_ServiceNow//com.redwood.scheduler.custom.app.extensions_shared.model.CustomJobDefinitionBase.execute(CustomJobDefinitionBase.java:53)
at Library REDWOOD.Redwood_ServiceNow//com.redwood.scheduler.app.servicenow.ServiceNowJobExecutor.execute(ServiceNowJobExecutor.java:28)
at com.redwood.scheduler.customjob.service.CustomJobInstance.lambda$execute$0(CustomJobInstance.java:88)
at com.redwood.scheduler.script.java.impl.classloader.ThreadContextRunnable.call(ThreadContextRunnable.java:48)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
... 1 more