Oracle Transactional Business Intelligence

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

Categories

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

Agent Limitations

Received Response
133
Views
3
Comments
Neil Peacock
Neil Peacock Rank 2 - Community Beginner
in Oracle Transactional Business Intelligence

Summary

Encountering limitations on the exports from agents

Content

I am currently encountering an issue where exporting data through an agent is cutting off at 25,000 rows even though the agent is set to use data and CSV on the export option.

I understand there is a limit of 25,000 rows when you export through excel, however using data - csv usually bypasses this and uses the higher limit. However I am having trouble automating this through an agent.

Has anyone else encountered this issue or know a way around it?

Thanks in advance for any help.

Neil

Tagged:

Answers

  • Chris Dabel
    Chris Dabel Rank 2 - Community Beginner

    Hi Neil,

    This is due to the parameters set in the BI config files on the BI server. Generally, these parameters cannot be changed for cloud BI instances. There is one setting for normal export to CSV, and another for Agents.

    You can get more rows of data by using the BI Cloud Connector, where you can schedule data extracts.

    Learn more about it here.

    Using BI Publisher scheduled reports is another option. The limits for BI Publisher are different in that they are dependent on "Memory Guard" settings.
    Learn more about these settings here: 
        -  Oracle Fusion BI Publisher: How to request changes for the BI Publisher Memory Guard settings (Doc ID 2199494.1)

     

    Thank you,

    Chris Dabel
    Oracle Fusion Support

  • Neil Peacock
    Neil Peacock Rank 2 - Community Beginner

    Hi Chris,

    Thanks for this reply, I had been told by Oracle support that the settings can't be changed but the export of CSV through an agent should use the CSV limit and not be cut off at a lower limit. However I believe your answer is correct.

    Do you know if there is any plans to match agent limits to the data type they are exporting or is this not in the pipeline?

    Neil

  • Chris Dabel
    Chris Dabel Rank 2 - Community Beginner 
    Hi Neil,

 

I do not believe there are plans to increase the Agent CSV export limit.

I recommend logging a Service Request to allow us to hear the business
requirement and advise you on how we can help meet the requirement.

 

Thanks,

Chris