DSXchange

When i write to excel sheet using Unstructured Data Stage , i am getting below error.


Unstructured_Data_3,0: com.ascential.e2.common.CC_Exception: java.lang.RuntimeException: java.io.IOException: Permission denied

Can you please help

The error message suggests that the user that actually executes the DataStage job lacks write permission to the Excel workbook. Check your Engine credentials.

I could see a zero kB file getting created. and i am able to create the same file as csv using sequential file stage.

Then the umask setting for the credentialled user may be incorrect; your job may have been able to create the file but not to write to the newly-created file. Check the permissions on the newly-created file.