Skip to Content

Issue with Report Publication in BOXI 3.1 SP 5

Hi Folks,

Currently we are bursting a webi report to 1,000+ users through InfoBurst. We are hoping to leverage the Publication feature in R3.1 to burst our compensation report to the 1,000+ dynamic user base via email. The issues we have hit are - publication is limited to the number of dynamic users in one publication and BOXI only spawns one instance at a time for publications, meaning it will be refreshing this one report 1,000+ times sequentially. We have considered breaking the report up through a filter and creating multiple publications, but then we would be supporting multiple copies of the same report(this report is updated on a quarterly basis).

Our BOXI 3.1 SP 5 installation is in Windows environment and Database is Oracle.

If we use publication in BOXI as we are using through InfoBurst we get following error message:

2012-10-01 13:32:05,948 INFO [pool-4-thread-4] BusinessObjects_PublicationAdminLog_Instance_75965 - [Publication ID # 75965] - Running publication instance.

2012-10-01 13:32:06,026 INFO [pool-4-thread-4] BusinessObjects_PublicationAdminLog_Instance_75965 - [Publication ID # 75965] - The global delivery rule for this publication was met; publication processing will now begin.

2012-10-01 13:32:26,479 ERROR [PublishingService:HandlerPool-46] BusinessObjects_PublicationAdminLog_Instance_75965 - [Publication ID # 75965] - Scheduling document job "XXXX_Rep_Statement" (ID: 75,980) failed: A database error occured. The database error text is: ORA-01795: maximum number of expressions in a list is 1000

. (WIS 10901) (FBE60502)

2012-10-01 13:32:27,026 INFO [pool-4-thread-4] BusinessObjects_PublicationAdminLog_Instance_75965 - [Publication ID # 75965] - Publication scheduling complete.

Regards,

Bashir Awan



Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Nov 19, 2012 at 08:37 PM

    Bashir,

    If you want to leverage the full capabilities of the Publications built-in within XI 3.x, you need do do some initial groundwork first

    - Create UNV against data source

    - You prevent limits on Dynamic users, you will need to create BOBJ Enterprise Users & Groups

    - Create Profile against UNV for 1000+ splits

    - Create Publication using WebI reports as source and leverage the Profile create.

    - If you want to the WebI reports to have CUSTOM name then a Java Plugin code will need to written

    I have several customer's that I have migrated from these 3rd party tools to fully leverage the built-in Profile & Publication within XI 3.x, as well as BI4.

    Good Luck,

    Ajay Gupta

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.