Oracle Analytics and AI

In Oracle Fusion- BIP Report Job succeeds but Files not found on FTP Server

We have scheduled a BI publisher report by using the schedule option on the BIP report to place file on the FTP server. When we run the job it is getting ran successfully without any error, but the file is not placed on the FTP server.

We have done this for few list of reports. Few of the reports output is placed on the FTP server but 2 of reports are getting executed successfully without any errors or warnings but the files are not placed in the FTP server

We are not having any clue to resolve this issue please help

Find more posts tagged with

Accepted answers

All comments

Hassan El Bouihi-Oracle

Hello Srividya,

Please raise a new SR and provide the following information for the Support to debug the issue:

1. Login as a user who has the BI Administrator role and schedule the job.

2. This time, you will see the Diagnostic Tab. Click on the last option to generate more information in the log file.

3. Once it completes, query up the report job history and click on the Report Job Name and then click on the Diagnostic Log.

4. Upload the log to the SR for review.

Review Doc ID 2126699.1 for more details on how to run this process

Thank you

Hassan

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/19115/in-oracle-fusion-bip-report-job-succeeds-but-files-not-found-on-ftp-server

Hi @Srividya Naguluri,

Have you got the resolution for this issue? Can you please share?

Adding @Parag Hiremath.

Thanks for your help.

Cheers,

Parag Hiremath

Hi @Srividya Naguluri

The issue was related to the file watcher in our case and has been fixed.

Was it the same in your case?

Thanks

Parag

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/comment/63248#Comment_63248

Thank you very much Parag!

Brian J Becker

Parag Hiremath

Parag, can you provide more detail on the resolution, as to what the 'file watcher' is?

We have same scenerio happening where the file is not getting to our FTP server.

thanks

Gaurav Bharadwaj-Oracle

@Brian J Becker
File Watcher is some tool that runs over the FTP folders.

In short the issue was on the FTP or Client side of things rather than on the Server side(BIP).

Please ask your FTP vendor to review the logs for when you submit the job thats supposed to send files to FTP and monitor for incoming connections and data.

BIP sets the job as successful if it is successful in sending the job out of the Oracle Network, beyond that there is no tracking that is done by BIP. Meaning there is a very high chance issue could be with your Network or FTP server itself.

Regards,
Gaurav