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

[Daniel Draes]

You have a scheduled import reading from a file? Is this a file accessed via MID Server?

Which release of NOW are you on? If I am not mistaken there is no baseline functionality to schedule a file based import via MID as of today.

[narendrand]

Hi Fogg,

Thanks for your response.
We have scheduled job pointing to Data source > Data source type is File - File retrieval method is SFTP   - we gave server details with username and password in Data source.

We are in Geneva Release.

Cheers,

Narendran

[Daniel Draes]

Hi Narendran,

thanks, this makes more sense now.

The file you are about to read, how often is that refreshed? Can you be certain the file is available at the time the schedule runs? It sounds like the file was not there or the FTP server could not give it to the reading process.

Fogg

[narendrand]

Hi Fogg,

I have checked with server team, It looks the file was available during schedule run.

If the file is not available in server end, we used to receive the error message 'File not found ' but the message received here is ' Problem opening a handle to remote file:' so we are confusing with the reason for this particular message.

You have any suggesstions?

Cheers,

Narendran