Skip to Content
0
Former Member
Feb 14, 2011 at 10:39 AM

Crystal Reports Publication fails when using dynamic recipients

206 Views

Hi experts,

We are facing a problem related with the BOE 3.1 Dynamic recipients Publication.

We have created a Publication with just one Crystal Report based on a MDX Query. We send the report in PDF format to email destinations

Dynamic recipients are defined in a WebI report pulling data from a BW query universe. We can display the email, user ID, Use Name and other fields we would like to use as dynamic parameters.

Server side trust seems to be configured (is there any way to test it is properly configured?).

The Publication is working fine with enterprise recipients (which have SAP BW account), and each recipient receive its PDF by email.

When we execute same report with dynamic recipients without selecting dynamic personalization parameters it is working fine. But when we select one dynamic parameter (which is coming from the WebI report we use for dynamic recipients) eg: Profit Centre, the Publication fails and we get a Database Connector error:

2011-02-14 08:53:25,275 ERROR [PublishingService:HandlerPool-13] BusinessObjects_PublicationAdminErrorLog_Instance_31036 - [Publication ID # 31036] - Scheduling document job "P&L" (ID: 31,051) failed: Error in File ~tmp191067bfa343ff0.rpt: Database Connector Error (FBE60502) [1 recipients processed.]

How can a dynamic parameter affect on the Database Connection?

Does anyone have an idea about what could be wrong?

Thanks!