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