Problem with Scheduled File Import from Mid-server

[pratap_rathore]

I am using scheduled file import plugin to import csv file from mid-server, plugin works correctly around one month and it is giving problem and not running manually or by scheduled time.

Can anyone suggest what may be the cause of problem as we are not able to use inbuilt option of FTP and HTTP import as our server is not public.

Thanks

[mamann]

If you're referring to the Remote File Import from ServiceNow Share

The code has changed slightly, which can be found at MID Server CSV Importer

If you use the original authors code, you MUST comment out line(s) 37 and 40 or it will not work

[pratap_rathore]

Thanks Mark, for your solution I have also implemented this but unable to get success, If I manually upload the file through transform map it works, Same code is working fine on Test and Development environment but on production it fails here is the error I got in logs--

Failure during scheduled run of job: : java.lang.NullPointerException: name can't be null: java.io.FilePermission.init(FilePermission.java:171)

java.io.FilePermission.<init>(FilePermission.java:249)

java.lang.SecurityManager.checkRead(SecurityManager.java:871)

java.io.FileInputStream.<init>(FileInputStream.java:113)

com.glide.sys.util.SecurelyAccess.getFileInputStream(SecurelyAccess.java:181)

com.glide.protocol.file.FileURLConnection.getInputStream(FileURLConnection.java:22)

com.glide.db.impex.datasource.DataSource.writeFile(DataSource.java:349)

com.glide.db.impex.datasource.DataSource.getFile(DataSource.java:316)

com.glide.db.impex.datasource.DataSource.getFile(DataSource.java:283)

com.glide.db.impex.CSVLoader.setDataSource(CSVLoader.java:116)

com.glide.db.impex.JDBCLoader.setImportDataSource(JDBCLoader.java:530)

com.glide.db.impex.datasource.CSVDataSource.getLoader(CSVDataSource.java:19)

com.glide.system_import_set.ImportSetLoader.loadImportSetTable(ImportSetLoader.java:31)

com.snc.automation.ScheduledImportSetJob.runImport(ScheduledImportSetJob.java:49)

com.snc.automation.ScheduledImportJob.execute(ScheduledImportJob.java:44)

com.glide.schedule.JobExecutor.execute(JobExecutor.java:72)

com.glide.schedule.GlideScheduleWorker.executeJob(GlideScheduleWorker.java:177)

com.glide.schedule.GlideScheduleWorker.process(GlideScheduleWorker.java:124)

com.glide.schedule.GlideScheduleWorker.run(GlideScheduleWorker.java:56)

[mamann]

Here is a newer version which is confirmed working.ServiceNow Share

[california123]

Can anyone help using Scheduled File Import from Mid-server

Scheduled import through SFTP

And am getting following error