VERIFIED SOLUTION i
Resolve path related errors in Spectrum 'Write to Spreadsheet' stage
Within the Enterprise designer, while creating Excel spreadsheet output using 'Write to Spreadsheet' stage, one of the following error related to file path occurs:
- Error - "The Path was not found"
- Error - "FileNotFoundException: TempWriteToSpreadSheet-Write to Spreadsheet threw StageException: com.pb.spectrum.iosdk.datasource.DataSourceException: java.io.FileNotFoundException:"
- Error - "The device is not ready"
'Write to Spreadsheet' does not write to a client machine. It either has to be on the Spectrum host or on a remote FTP machine.
UPDATED: March 21, 2018
Try any of the following steps:
- Share one folder on the host and write all the files there. Then the users could map to that drive.
- Install an FTP server on another machine and have the users write the files there.
- Use 'Write to File' to generate a comma-delimited file (CSV) and use Excel to open generated CSV file.
- No Downloads