Scheduled Job Fails

Post any question you may have in regards to GoAnywhere Director and let our talented support staff and other users assist you.

Scheduled Job Fails

Postby mpan20 » 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
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


Here's the specific job log:

Code: Select all
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


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?
mpan20
 
Posts: 3
Joined: Mon Sep 23, 2013 12:35 pm

Return to Community Forum

Who is online

Users browsing this forum: Google [Bot] and 1 guest