My Oracle Support Banner

Getting Error 'java.io.FileNotFoundException: zTableId_xxxxxx_xxx.xls (Permission denied)' Exporting Static Table Driver (Doc ID 2603665.1)

Last updated on NOVEMBER 08, 2019

Applies to:

Oracle Financial Services Profitability Management - Version 8.0.6.1.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Profitability Management (PFT)

Symptoms

When attempting to export a Static Table Driver definition from the definition screen, you are able to save the spreadsheet:

 

But when you open the spreadsheet, there is no data - only the word 'Error'.

 

The following error appears in the web server's pftapp.log:

[25-02-19 19:33:21,169 GMT PM] [INFO ] [WEB] exportDataToExcel->query::select F0_ID,F0_DESC,T1_ID,T1_DESC,COEFF from zTableId_xxxxxx_xxx where 1=1 AND coeff is not null order by F0_DESC,T1_DESC
[25-02-19 19:33:21,189 GMT PM] [INFO ] [WEB] exportDataToExcel->Rows created in workbook::3
[25-02-19 19:33:21,189 GMT PM] [INFO ] [WEB] exportDataToExcel-Exporting to Excel is Success::3
[25-02-19 19:33:21,189 GMT PM] [INFO ] [WEB] exportDataToExcel->Excel written successfully
[25-02-19 19:33:21,220 GMT PM] [INFO ] [WEB] [** Error in exportDataToExcel**]
java.io.FileNotFoundException: zTableId_xxxxxx_xxx.xls (Permission denied)
       at java.io.FileOutputStream.open0(Native Method) ~[?:1.8.0_202]
       at java.io.FileOutputStream.open(FileOutputStream.java:270) ~[?:1.8.0_202]
       at java.io.FileOutputStream.(FileOutputStream.java:213) ~[?:1.8.0_202]
       at java.io.FileOutputStream.(FileOutputStream.java:162) ~[?:1.8.0_202]
       at com.ofs.fsapps.pft.action.ClsActTableId.exportDataToExcel(ClsActTableId.java:2787) [PftApp.jar:?]
       at sun.reflect.GeneratedMethodAccessor403.invoke(Unknown Source) ~[?:?]
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_202]
       at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_202]
       etc.

As a result, you cannot use the Excel export / import to update the Static Table Driver definition.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.