OBIEE Report not delivering to FTP server — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE Report not delivering to FTP server

Received Response
11
Views
2
Comments
Ibag
Ibag Rank 3 - Community Apprentice
edited Aug 13, 2024 5:58PM in Oracle Analytics Cloud and Server

Hi Everyone,

We had setup of FTP server and scheduling a BIP report to a FTP destinatination. This is working fine in single node OBIEE 12c instance.

Manage BI Publisher--> FTP--> Add Server--> Provided details--> Test successfully and reports are delivering to destination path in remote server.

We have other instance with load balancer OBIEE, and did the same setup.

When we schedule report, it says report job scheduled successfully, but no output in the remote server, when we checked job history, it returns no data.

Anything we need to perform specific when it comes to load balancer instance.

Any thoughts would be helpful

Thanks in advance

Answers

  • Sherry George
    Sherry George Rank 7 - Analytics Coach

    Refer this document and verify your BI publisher configuration is correct.

    Oracle Support Document 1952502.1 (What Has To Be Shared In Oracle Bi Publisher 11G 12c Cluster Environment?)

    Also under Manage BI publisher Test JMS and  Database connection under Scheduler Configuration. Check that Result is 'Passed' under Scheduler Diagnostics.

    pastedImage_0.png

  • Ibag
    Ibag Rank 3 - Community Apprentice

    Thanks Sherry for quick insight, I will validate and post the results