Export Sets Do Not Run, Node Log Error: *** ERROR *** EXPORT SET - ExportSetHandler : Fail to find the MID server by sys_id - Support and Troubleshooting

Export Sets Do Not Run, Node Log Error: *** ERROR *** EXPORT SET - ExportSetHandler : Fail to find the MID server by sys_id Issue Export Sets do not run, the node log will show an error similar to this when an Export Set is requested to be run:

2021-12-05 10:20:08 (476) Default-thread-5 4C5C7C701B10C150384A6467BC4BCB47 txid=d3dc78381bdc *** Start #129781 /xmlhttp.do, user: myuser 2021-12-05 10:20:08 (482) Default-thread-5 4C5C7C701B10C150384A6467BC4BCB47 txid=d3dc78381bdc WARNING *** WARNING *** Get for non-existent record: ecc_agent:f3242908db7abbfe848bd7764896191c, initializing 2021-12-05 10:20:08 (483) Default-thread-5 4C5C7C701B10C150384A6467BC4BCB47 txid=d3dc78381bdc SEVERE *** ERROR *** EXPORT SET - ExportSetHandler : Fail to find the MID server by sys_id: abc02908db7ab3c4848bd7764896191c 2021-12-05 10:20:08 (485) Default-thread-5 4C5C7C701B10C150384A6467BC4BCB47 txid=d3dc78381bdc WARNING *** WARNING *** java.lang.NullPointerException org.mozilla.javascript.JavaScriptException: java.lang.NullPointerException org.mozilla.javascript.JavaScriptException: java.lang.NullPointerException at org.mozilla.javascript.Context.makeJavaScriptException(Context.java:1937) at org.mozilla.javascript.Context.throwAsScriptRuntimeEx(Context.java:1923) at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:143) at org.mozilla.javascript.FunctionObject.doInvoke(FunctionObject.java:670) at org.mozilla.javascript.FunctionObject.call(FunctionObject.java:559) at org.mozilla.javascript.FunctionObject.call(FunctionObject.java:491) at org.mozilla.javascript.BaseFunction.construct(BaseFunction.java:410) at org.mozilla.javascript.ScriptRuntime.newObject(ScriptRuntime.java:2476) at org.mozilla.javascript.ScriptRuntime.newObjectEx(ScriptRuntime.java:2491) at org.mozilla.javascript.gen.sys_script_include_69a76ed3471331004695d7527c9a717f_script_822._c_anonymous_3(sys_script_include.69a76ed3471331004695d7527c9a717f.script:43) at org.mozilla.javascript.gen.sys_script_include_69a76ed3471331004695d7527c9a717f_script_822.call(sys_script_include.69a76ed3471331004695d7527c9a717f.script) at org.mozilla.javascript.ScriptRuntime.doCall2(ScriptRuntime.java:2678) at org.mozilla.javascript.ScriptRuntime.doCall(ScriptRuntime.java:2617) at org.mozilla.javascript.ScriptRuntime.applyOrCall(ScriptRuntime.java:2576) at org.mozilla.javascript.BaseFunction.execIdCall(BaseFunction.java:300) at org.mozilla.javascript.IdFunctionObject.call(IdFunctionObject.java:102) at org.mozilla.javascript.ScriptRuntime.doCall(ScriptRuntime.java:2615) at org.mozilla.javascript.optimizer.OptRuntime.call1(OptRuntime.java:32) at org.mozilla.javascript.gen.sys_script_include_d65f78c40a0a0b6900196656f35913d3_script_125._c_anonymous_2(sys_script_include.d65f78c40a0a0b6900196656f35913d3.script:34) at org.mozilla.javascript.gen.sys_script_include_d65f78c40a0a0b6900196656f35913d3_script_125.call(sys_script_include.d65f78c40a0a0b6900196656f35913d3.script) at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:563) at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3459) at org.mozilla.javascript.gen.sys_script_include_d65f78c40a0a0b6900196656f35913d3_script_125.call(sys_script_include.d65f78c40a0a0b6900196656f35913d3.script) at org.mozilla.javascript.ScriptRuntime.doCall2(ScriptRuntime.java:2678) at org.mozilla.javascript.ScriptRuntime.doCall(ScriptRuntime.java:2617) at org.mozilla.javascript.ScriptableObject.callMethod(ScriptableObject.java:2658) at org.mozilla.javascript.ScriptableObject.callMethod(ScriptableObject.java:2630) at com.glide.script.RhinoObject.callFunction(RhinoObject.java:169) at com.glide.script.GlideRhinoObject.callFunction(GlideRhinoObject.java:156) at com.glide.script.RhinoObject.callFunction(RhinoObject.java:165) at com.glide.processors.xmlhttp.AJAXEvaluator.evalScriptInclude(AJAXEvaluator.java:178) at com.glide.processors.xmlhttp.AJAXEvaluator.evaluateAjax(AJAXEvaluator.java:87) at com.glide.processors.xmlhttp.AJAXEvaluator.process(AJAXEvaluator.java:65) at com.glide.processors.xmlhttp.internal.XMLHttpRequestExecutor.process(XMLHttpRequestExecutor.java:110) at com.glide.processors.xmlhttp.internal.XMLHttpRequestExecutor.process(XMLHttpRequestExecutor.java:76) at com.glide.processors.xmlhttp.AJAXXMLHttpAggregator.process(AJAXXMLHttpAggregator.java:70) at com.glide.processors.XMLHttpProcessor.processJavaAJAX(XMLHttpProcessor.java:168) at com.glide.processors.XMLHttpProcessor.process(XMLHttpProcessor.java:121) at com.glide.processors.AProcessor.runProcessor(AProcessor.java:596) at com.glide.processors.AProcessor.processTransaction(AProcessor.java:266) at com.glide.processors.ProcessorRegistry.process0(ProcessorRegistry.java:181) at com.glide.processors.ProcessorRegistry.process(ProcessorRegistry.java:169) at com.glide.ui.GlideServletTransaction.process(GlideServletTransaction.java:44) at com.glide.sys.Transaction.run(Transaction.java:2406) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748)

Release Applies to any release.

Cause The Export set's Export target is not pointing to a valid mid server record.

Resolution (1) Open the Export Set record that is not running (sys_export_set table)

(2) From there open up the Export Set's Export target

(3) The "MID Server" value points to a non-existent sys_id for a mid server record (ecc_agent table)

(4) To resolve the issue set the "MID Server" value to the appropriate running mid server from the drop down for this export set, save the record and try the export set again.