Oracle Business Intelligence Applications

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Business Intelligence Applications

Categories

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

OBIEE CSV Export file cannot be found

Received Response
129
Views
10
Comments
KashSidd
KashSidd Rank 5 - Community Champion
in Oracle Business Intelligence Applications

I run a report in OBIEE (12.2.1.3) and when I export the file as CSV, I get the message that the file has been exported but neither I get the message on the bottom of the browser (Chrome) nor do I see it in my "Downloads" folder... Anybody has any ideas?

Answers

  • Charles M
    Charles M Rank 6 - Analytics Lead

    Hi Kash,

    Could you provide some more details about this? Also, was this working before at any point? All dashboards/analyses affected the same way?

    Do you have another browser you could try from?

    Regards,

    Charles

  • KashSidd
    KashSidd Rank 5 - Community Champion

    Hi,

    Also, was this working before at any point?

    Yes, it was working before about couple of months ago and just added two new columns to the report but even if we run the old report, its the same issue. Basically, the moment you click on Export to CSV, we wont even get a bottom bar stating that its downloading which is really weird. We have tried at different computers to make sure its not just one computer and same tests were performed with different User logins. Now we are about to re-start the BI services to see if that makes any difference

    All dashboards/analyses affected the same way?

    Yes

    Do you have another browser you could try from?

    Tried with Chrome and IE but the same issue

  • KashSidd
    KashSidd Rank 5 - Community Champion

    All dashboards/analyses affected the same way?

    No only that one report

  • Charles M
    Charles M Rank 6 - Analytics Lead

    Ok, noted. So, basically, you've made some changes to a "report" (as @Christian Berg says ... reports are BI Publisher objects; is this a bi publisher report, or dashboard/analysis?).

    If you have access, can you check the sawlog? /{Path_to_Middleware_Home}/instances/{Instance_name}/diagnostics/logs/OracleBIPresentationServicesComponent/coreapplication_obips1

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner 
    Charles M wrote:as Christian Berg says ... reports are BI Publisher objects; is this a bi publisher report, or dashboard/analysis?).

    Image result for getting popcorn

  • KashSidd
    KashSidd Rank 5 - Community Champion

    Its a BI Analysis and BTW, restart of the services didnt help

  • KashSidd
    KashSidd Rank 5 - Community Champion

    Just to further clarify its a BI Analysis on its own and not part of any dashboard... And its not a publisher report

  • Charles M
    Charles M Rank 6 - Analytics Lead

    Thanks Kash. Are you able to see that log?

  • Charles M
    Charles M Rank 6 - Analytics Lead

    Sorry ... I gave you the path for 11g. Try this for 12c: /{DOMAIN_HOME}/servers/obips1/logs/sawlog[n].log

    OBIEE 12c: Quick Reference For Architecture, Lifecycle Management and File Locations (Doc ID 2067527.1)

  • KashSidd
    KashSidd Rank 5 - Community Champion

    Sorry I dont have access to it but we will further proceed with the hardware team on this issue... The weird thing is that it works fine if you re-create the report but the next day the same report would not export the CSV file and its basically a ghost file