Import set Error

[narendrand]

Hi Everyone,

We have Scheduled import used to run every day, during last import we received below error message "java.io.IOException: Problem opening a handle to remote file: /SCCM/outgoing/SCCMMonthly_15-07-2016.csv ( scheduled import job: CMS SCCM Month User Device)"

I am not much clear on source of this issue.

Kindly give your comments.

Thanks in advance,

Regards,

Narendran

[narendrand]

Hi Everyone,

Please share your comments on this issue.

Cheers,

Narendran

[Daniel Draes]

I am a bit confused about the part 'opening a remote file'. This sounds a bit like if the file system you are trying read from is a network drive. This could mean the drive itself was mounted but the target host not accessible or something like this.

Don't know if that makes sense in your environment.

[wryanr]

Narendran,

I was just investigating this same issue in my environment. We had a long-standing import where the data source was a CSV file on an sFTP server. The error message was the same. We confirmed with an FTP client that the file was available and not corrupt and then ran a test load of 20 records from ServiceNow and received the same error.

It turned out, in our case, that the File Path in the Data Source is case-sensitive. The user that put the file on the sFTP site had a lower-case 's' where an upper-case 'S' was expected. Once I renamed the file on the sFTP site the import ran successfully.

Hope this helps.

Ryan

[surya123]

Hi Narendran

Did you get a solution to what the issue was and what you did to get it fixed?

[narendrand]

Hi Surya,

This message is the default errror message in Geneva release if source file not found.

In our case, we have set the property in data source to delete the source file once data import processed.

The scheduled import in our non prod instance processed the import and deleted the source file so while the prod instance tries to run the same import we have received this error.

Cheers,

Narendran