Qualys Knowledge Base import as well Qualys Host Detection Import scheduled jobs fails to retrieve the data - Support and Troubleshooting

Qualys Knowledge Base import as well Qualys Host Detection Import scheduled jobs fails to retrieve the data Issue When the scheduled jobs for Qualys Host detection and Qualys Knowledge Base import are executed, the inserts or updates are shown as 0 as no data from Qualys is transformed into ServiceNow tables.

Release Madrid and above

Cause The application logs throw below warning, when there is a failure :

2021-02-04 06:24:59 (241) worker.5 worker.5 txid=55b322ba1b0e OUTBOUND_HTTP: protocol=HTTP/1.1 response_status=200 response_time=1249 request_length=0 response_length=2713335 app_scope=sn_vul_qualys session_id=glide.scheduler.worker.5 transaction_name="ASYNC: Run process on insert - system" transaction_id=55b322ba1b0eecd0521beacee54bcbe3 user_name=VR.System mid_server= source_table=sys_script source_record=2e1cd7825333020034c69816a11c081e system_id=app128152.ams101.service-now.com:alstomdev007 method=POST log_level=Basic scheme=https hostname=qualysguard.qg2.apps.qualys.eu path=/api/2.0/fo/asset/host/vm/detection/ url= https://qualysguard.qg2.apps.qualys.eu/api/2.0/fo/asset/host/vm/detection/ 2021-02-04 06:24:59 (247) worker.5 worker.5 txid=55b322ba1b0e WARNING *** WARNING *** Security restricted: xml is not an authorized file extension 2021-02-04 06:24:59 (274) worker.5 worker.5 txid=55b322ba1b0e WARNING *** WARNING *** Get for non-existent record: sys_attachment:null, initializing 2021-02-04 06:24:59 (275) worker.5 worker.5 txid=55b322ba1b0e SEVERE *** ERROR *** com.ctc.wstx.exc.WstxEOFException: Unexpected EOF in prolog at [row,col {unknown-source}]: [1,0] org.apache.axiom.om.OMException: com.ctc.wstx.exc.WstxEOFException: Unexpected EOF in prolog at [row,col {unknown-source}]: [1,0] at org.apache.axiom.om.impl.builder.StAXOMBuilder.next(StAXOMBuilder.java:297) at org.apache.axiom.om.impl.dom.DocumentImpl.getOMDocumentElement(DocumentImpl.java:446) at org.apache.axiom.om.impl.dom.DocumentImpl.getDocumentElement(DocumentImpl.java:458) at com.glide.util.XMLStreamDocument.getDocumentElement(XMLStreamDocument.java:397) at com.glide.script.XMLDocument2.jsFunction_getDocumentElement(XMLDocument2.java:101) at com.glide.script.fencing.ScopedXMLDocument2.jsFunction_getDocumentElement(ScopedXMLDocument2.java:59) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:138) at org.mozilla.javascript.FunctionObject.doInvoke(FunctionObject.java:670) at org.mozilla.javascript.FunctionObject.call(FunctionObject.java:614) at org.mozilla.javascript.ScriptRuntime.doCall(ScriptRuntime.java:2609) at org.mozilla.javascript.optimizer.OptRuntime.callProp0(OptRuntime.java:85) at org.mozilla.javascript.gen.sys_script_include_bb2a7dcb9f21120034c6b6a0942e70f4_script_92036._c_anonymous_5(sys_script_include.bb2a7dcb9f21120034c6b6a0942e70f4.script:34) at org.mozilla.javascript.gen.sys_script_include_bb2a7dcb9f21120034c6b6a0942e70f4_script_92036.call(sys_script_include.bb2a7dcb9f21120034c6b6a0942e70f4.script) at org.mozilla.javascript.ScriptRuntime.doCall2(ScriptRuntime.java:2678) at org.mozilla.javascript.ScriptRuntime.doCall(ScriptRuntime.java:2617) at org.mozilla.javascript.optimizer.OptRuntime.call1(OptRuntime.java:32) at org.mozilla.javascript.gen.sys_script_include_d69e2184ff900300c68c9f783894face_script_92034._c_anonymous_3(sys_script_include.d69e2184ff900300c68c9f783894face.script:55)

Resolution The exception is observed if the 'XML is not added as a valid file type in the system property below :

glide.attachment.extensions

Please ensure that XML is also added to the list of file type extensions.