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

[PrasadShelar]

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

[Mannapuram]

@PrasadShelar  This one has 'File Retrieval method' as 'Attachment. Load data would look for an attachment attached to the Data source. 

Other SG- Data sources might have other ways of File Retrieval methods, so those are triggered. But when it's attachment, you make a dummy attachment of the data you want to test and then click on 'Load data'

The error are facing is the one pop-up, when there is not attachment. You can try loading data on a OOB data source like 'Service Definition' and it did return the same error as yours. 

But if you attach a file, it will not (I am attaching a dummy excel for verification).

[PrasadShelar]

Hey @Mannapuram ,

Thanks for you response!

Just to clarify the current status:

I agree, In the setup for the Service Graph Connector for Tenable, the data source SG-Tenable TVM - 1 uses the "Attachment" method to retrieve files.

Since we hadn’t executed the scheduled jobs earlier, no REST API calls were made to Tenable, and therefore no JSON files were retrieved or attached to the data source. This explains the error during the test load:

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

It seems the data source expects a file to be attached for the import set to execute properly.

I’ve now run the scheduled job, which should have invoked the Script Include, made the REST API call to Tenable, fetched the data, and attached the file to the data source. However, I’m still seeing the same error in the import set. Please check attached screenshot.

Let me know if there’s anything else I should check or configure.

Best regards,
Prasad

[Mannapuram]

@PrasadShelar  As per your explanation and error screen shot, it shows that the REST API/Flow action/ Data stream is not working properly. This should be responsible for getting an attachment and attaching it to Data source. 

You can go to Workflow Studio and check Flow Action or Data stream (each SG has a different way, like SG-Azure works with Flow Action, whereas, SG-SolarWinds works with DataStream). There is an option to test them and check if the attachment is fetched. As the authontication was successful, the connection errors should be there. 

To my knowledge, there is nothing much in configuration to be done. But there is debug needs to be done why the attachment is not fetched. 

I am not able to install this particular SG in my personal instance, thus, not able to guide you completely.