REP-56133 – an attempt to write to the folder failed due to lack of permission Oracle forms and report 12c - Unable to generate report to file – Solved

Symptom

Report is working fine when DESTYPE=cache , but throws this error when trying to generate file to a folder.

Reason

Report server is trying to write the output file to a folder but the server do not have access to the folder.

Solution

How it is done

In my case, rep_server1 is my report server. My rwserver.conf file is located in below path

C:\Oracle\Middleware\Oracle_Home2\user_projects\domains\base_domain\config\fmwconfig\components\ReportsServerComponent\rep_server1

I am trying to create pdf report in c:\tmprep folder. So I need to give write permission to this folder. I am adding the below code at the end of the file just above the closing server tag.

<folderAccess>
              <write>C:\TMPREP</write>
</folderAccess>

let me share screenshot of the operations.

Note : If multiple folders needs to be given permission to, separate them with semi colon.

Note : If your report rdf files folders needs to be given read permission too. ( remember to add semi colon for multiple folders)

Example

<folderAccess>
              <read>C:\Proj1\Finance\Reports;C:\Proj1\HR\Reports;</read>
              <write>C:\TMPREP;C:\Output</write>
</folderAccess>

Now save the file and restart report server

Restarting report server from command prompt

In command prompt, CD to domain home bin path

cd C:\Oracle\Middleware\Oracle_Home2\user_projects\domains\base_domain\bin

Stop report server

stopComponent.cmd rep_server1

Start Report Server

startComponent.cmd rep_server1

Process Complete, try again to generate report to the specified folder.