Scheduled Job Fails
Posted: Tue Feb 04, 2014 4:32 pm
I'm running into a problem which I think may be some sort of permissions issue with a scheduled job. I can run the project manually with no errors. The project reads an Excel file from the server, writes it to a database table, queries the data, and writes it back to a .CSV file. It is setup as a scheduled job using my credentials. I have no permissions issues reading, writing, or deleting from the directory the files are located in. When the job runs, it will fail with the following error:
Code: Select all
Here's the specific job log:Job Number 1372732229680
Status x
Project Name EditBadgeFile
Project Folder /Simplex-Counterpoint
User mpangersis
Submitted By *scheduler
Queue Priority 5
Run Priority 5
Submit Time 2/3/14 3:00:18 PM
Start Time 2/3/14 3:00:18 PM
End Time 2/3/14 3:00:18 PM
Time Taken 0.64
Job Log View
Remarks [8099 - readExcel] An unexpected error occurred. Unable to construct record instance
Code: Select all
If I open the file location and double click the Excel file it will open with no problem. I close Excel, rerun the job, and it completes with no issues. Any thoughts on why I have to open the Excel file first and close it before the scheduled job will complete?2/3/14 3:00:18 PM INFO Start Date and Time: 2/3/14 3:00:18 PM
2/3/14 3:00:18 PM INFO Job Number: 1372732229680
2/3/14 3:00:18 PM INFO Project Name: /Simplex-Counterpoint/EditBadgeFile
2/3/14 3:00:18 PM INFO Submitted By: *scheduler
2/3/14 3:00:18 PM INFO GoAnywhere Director 4.5.1 running on Windows Server 2008 6.0 (x86)
2/3/14 3:00:18 PM INFO Executing project 'EditBadgeFile'
2/3/14 3:00:18 PM INFO Project location: C:\Program Files\Linoma Software\GoAnywhere\userdata\projects\Simplex-Counterpoint\EditBadgeFile.xml
2/3/14 3:00:18 PM INFO Executing module 'Main'
2/3/14 3:00:18 PM INFO Executing task 'sql 1.0 (TRUNCATE TABLE Badges)'
2/3/14 3:00:18 PM INFO Executing sub-task 'query'
2/3/14 3:00:18 PM INFO Query completed successfully and -1 row(s) were affected
2/3/14 3:00:18 PM INFO Finished sub-task 'query'
2/3/14 3:00:18 PM INFO Finished task 'sql 1.0 (TRUNCATE TABLE Badges)'
2/3/14 3:00:18 PM INFO Executing task 'readExcel 2.0'
2/3/14 3:00:18 PM INFO Finished task 'readExcel 2.0'
2/3/14 3:00:18 PM ERROR Unable to construct record instance
2/3/14 3:00:18 PM INFO Finished project 'EditBadgeFile'
2/3/14 3:00:18 PM ERROR [8099 - readExcel] An unexpected error occurred.
Unable to construct record instance
com.linoma.dpa.runtime.JobFailedException: [8099 - readExcel] An unexpected error occurred.
Unable to construct record instance
at com.linoma.dpa.runtime.Job.run(Unknown Source)
at com.linoma.dpa.util.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at com.linoma.dpa.util.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Thread.java:662)
Caused by: org.apache.poi.hssf.record.RecordFormatException: Unable to construct record instance
at org.apache.poi.hssf.record.RecordFactory$ReflectionRecordCreator.create(RecordFactory.java:64)
at org.apache.poi.hssf.record.RecordFactory.createSingleRecord(RecordFactory.java:263)
at org.apache.poi.hssf.record.RecordFactoryInputStream$StreamEncryptionInfo.<init>(RecordFactoryInputStream.java:62)
at org.apache.poi.hssf.record.RecordFactoryInputStream.<init>(RecordFactoryInputStream.java:167)
at org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.java:389)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:275)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:200)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:316)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:297)
at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:60)
at com.linoma.dpa.tasks.converters.excel.v2.ExcelDataReader.open(Unknown Source)
at com.linoma.dpa.tasks.converters.excel.v2.ExcelRowSetMetaDataFinder.getMetaData(Unknown Source)
at com.linoma.dpa.tasks.converters.excel.v2.ExcelRowSet.getAutoDetectedMetaData(Unknown Source)
at com.linoma.dpa.tasks.converters.ReaderRowSet.initialize(Unknown Source)
at com.linoma.dpa.tasks.converters.excel.v2.ExcelRowSet.<init>(Unknown Source)
at com.linoma.dpa.tasks.converters.excel.v2.ExcelReaderTask.createRowSet(Unknown Source)
at com.linoma.dpa.tasks.converters.DataReaderTask.execute(Unknown Source)
at com.linoma.dpa.ModuleV2.execute(Unknown Source)
at com.linoma.dpa.Project.execute(Unknown Source)
at com.linoma.dpa.runtime.Job.executeProject(Unknown Source)
... 4 more
Caused by: org.apache.poi.hssf.record.RecordFormatException: Not enough data (1) to read requested (2) bytes
at org.apache.poi.hssf.record.RecordInputStream.checkRecordPosition(RecordInputStream.java:215)
at org.apache.poi.hssf.record.RecordInputStream.readUShort(RecordInputStream.java:260)
at org.apache.poi.util.StringUtil.readUnicodeLE(StringUtil.java:274)
at org.apache.poi.hssf.record.WriteAccessRecord.<init>(WriteAccessRecord.java:80)
at sun.reflect.GeneratedConstructorAccessor2995.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at org.apache.poi.hssf.record.RecordFactory$ReflectionRecordCreator.create(RecordFactory.java:56)
... 23 more
2/3/14 3:00:18 PM INFO End Date and Time: 2/3/14 3:00:18 PM