Service Graph Connector for Tenable - Error: "Zero or More than One File Attached" during test load

PrasadShelar
Tera Expert

Hi Community!👋

 

We’ve installed the Service Graph Connector for Tenable(x_tsirm_tio_now) to bring assets into the CMDB from Tenable. The connector setup was successful, and we received a 200 OK(success) response when testing the connection.


The connector includes multiple data sources mapped to scheduled import jobs. One of the data sources, 'SG-Tenable TVM - 1', uses the "Attachment" method to retrieve files.


However, when we attempt a test load of 20 records from the related list of this data source, we receive the following error:

com.glide.db.impex.datasource.DataSourceException: Zero or More than one file Attached

I’ve attached screenshots of:

  • Import Status
  • Application Logs
  • Data Source

Has anyone encountered this issue before? What could be causing it, and how can we resolve it?

Any guidance would be appreciated!

https: // store. servicenow. com  /store/ app/ d102bfea1ba46a50a85b16db234bcbf7

https:// docs.tenable .com /integrations/ServiceNow /Content/Welcome.htm

 

Thanks in advance for your help!🙏

 

Tags - Service Graph Connector, Tenable, CMDB, Import Jobs, DataSourceException, ServiceNow Integration, Test Load Error, Import Status, Application Logs, SG-Tenable TVM - 1, File Attachment Issue, Scheduled Import Jobs, Import Set API, ServiceNow CMDB, Troubleshooting, com.glide.db.impex.datasource.DataSourceException: Zero or More than one file Attached

1 ACCEPTED SOLUTION

PrasadShelar
Tera Expert

Hey @donhall ,

 

 

After some time, one of my friends took this implementation further. He informed that 2 modifications helped him resolve this error. Please try and confirm if this works for you as well.

 

1. Disable MID Server: The error occurs because ServiceNow cannot locate exactly one file during the attachment-based import.

2. Switch Endpoint URL: (Try this only if 1st option didn't work.) Disable the "Use MID Server" option in your web connection settings to allow direct cloud communication, and change your API endpoint from https:// cloud.tenable.com to https:// tenable.io to route through the correct regional cloud infrastructure. [Please remove space " " in the URLs].


Please hit Like if this helps you in any way. And let me know if this resolves your issue so that we can mark this as a Solution.

Thanks in advance!

View solution in original post

12 REPLIES 12

Edxavier Robert
Mega Sage

Hi @PrasadShelar , 

 

If you go to table: sn_cmdb_int_util_service_graph_connection  and open your Connection are you able to see records on under the Service Graph Connection Properties? On which connector are you working on: Operational Technology, Security Center or Vulnerability Managmenet?

Hi @Edxavier Robert ,

 

Thank you so much for your response!

 

Yes, I do have an active connection on the sn_cmdb_int_util_service_graph_connection table with a 200/success status.

We are currently working on integrating Tenable Vulnerability Management(SGC-Tenable) to bring assets into the CMDB.

 

I’ve attached a screenshot of the connection. Please let me know if you need any additional details.

 

Best regards,
Prasad

Hi @PrasadShelar , 

Thanks for the screenshot. If you open that connection, do you see the connection properties?  

Hello @Edxavier Robert,

Thanks for your quick reply!

 

I can see the Service Graph Connection Properties tab on the connection form, but we haven’t configured any properties yet. I’m following the guided setup, and there doesn’t seem to be any step that mentions configuring these properties. It has fields like property, value, etc.

 

I’ve also attached the Tenable documentation PDF for your reference, but I couldn’t find any instructions related to this configuration there either. 

 

Let me know if I might be missing something or if there’s a separate guide for this.

 

Regards,
Prasad