crystal reports, publications and dynamic recipients

[Former Member]

We are running BO edge 3.1 and I want to create a form letter that is perosnailzed and gets emailed out to about 15 people.  The recipients will change each time the report is run.  The form letter will ahve items such as dear mr/ms teacher<name>  you are teaching this class<class name> on this date<date>.  Is this able to be accomplished via regular report bursting or is this what i need a publication for?  If i need a publication can i just use two Crystal Reports for the source and dynamic recipient list or do they need to be web intelligence for the dymanic list?  I have tired it and it just won't work for me.  I have the emaill servers setup right  and have followed these links but nothing.

http://howtobi.wordpress.com/2011/02/23/how-to-setup-report-bursting-data-driven-publication-in-busi...

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/8077811e-7637-2e10-7c9f-dcb81d630...

[CdnConnection]

Kirk,

    What is exactly that is NOT working ?

Did you stage by stage unit testing?

- 1st - Test the Email delivery bu creating a simple schedule.

- 2nd - Create a simple Profile & Publication using eFashion database to make sure Publications works.

      - In order to use WebI as Publication, you will need to have Universe.

- 3rd - Final basic end-to-end test of all the individual server components to make sure you DO NOT any issue.

- 4th - Now build you custom Crystal &/or WebI based publication.

Regards,

Ajay

[Former Member]

i have broken down in stages.

if you schedule my source report it runs and will email.

I have scheduled my dynamic recipient report and it runs and emails.

I then tried a CR report for source and a different CR report for dynamic recipient list.

When i run this i get the following in the log file.

2013-04-05 08:45:31,481 INFO  [pool-4-thread-7] BusinessObjects_PublicationAdminLog_Instance_682801 - [Publication ID # 682801] - Running publication instance.

2013-04-05 08:45:31,559 INFO  [pool-4-thread-7] BusinessObjects_PublicationAdminLog_Instance_682801 - [Publication ID # 682801] - The global delivery rule for this publication was met; publication processing will now begin.

2013-04-05 08:54:12,903 ERROR [Transport:Shared-6/47] BusinessObjects_PublicationPostProcessingAdminLog_Instance_682801_0 - [Publication ID # 682801] - An exception was caught during post-processing. (FBE60401)

java.lang.OutOfMemoryError: Java heap space

2013-04-05 08:56:59,717 ERROR [PublishingPostProcessingService:pool-5/9] BusinessObjects_PublicationPostProcessingAdminLog_Instance_682801_0 - [Publication ID # 682801] - An exception was caught during post-processing. (FBE60401)

java.lang.OutOfMemoryError: Java heap space

2013-04-05 08:56:59,827 INFO  [pool-4-thread-7] BusinessObjects_PublicationAdminLog_Instance_682801 - [Publication ID # 682801] - Publication scheduling complete.

When i googled the some of the errors i got a link to this thread and i tried all of the suggestions and i still get the same error.

http://scn.sap.com/thread/1783918

[Former Member]

so i went out and removed a formula field from my Crystal report that was beign used for my dynamic report and the one for my source report.  The item runs but it never sends the PDF of the source document.  it does say it failed and this is why.

2013-04-05 09:36:45,852 INFO  [pool-4-thread-8] BusinessObjects_PublicationAdminLog_Instance_682917 - [Publication ID # 682917] - Running publication instance.

2013-04-05 09:36:45,915 INFO  [pool-4-thread-8] BusinessObjects_PublicationAdminLog_Instance_682917 - [Publication ID # 682917] - The global delivery rule for this publication was met; publication processing will now begin.

2013-04-05 09:36:53,476 WARN  [PublishingService:HandlerPool-40] BusinessObjects_PublicationAdminLog_Instance_682917 - [Publication ID # 682917] - Attempted to replace an %SI_EMAIL_ADDRESS% placeholder, but the email address for the recipient with user name "khill" is empty or missing. (FBE60039)

2013-04-05 09:36:53,476 WARN  [PublishingService:HandlerPool-40] BusinessObjects_PublicationAdminLog_Instance_682917 - [Publication ID # 682917] - Attempted to replace an %SI_EMAIL_ADDRESS% placeholder, but the email address for the recipient with user name "Administrator" is empty or missing. (FBE60039)

2013-04-05 09:36:56,615 ERROR [PublishingService:HandlerPool-40] BusinessObjects_PublicationAdminLog_Instance_682917 - [Publication ID # 682917] - Distribution to destination CrystalEnterprise.Smtp (To: %SI_EMAIL_ADDRESS%)  failed. Recipient: khill, Document Scope: Test Burst email : 682939 (Pdf) : [No personalization applied]. address error. [[CrystalEnterprise.Smtp] ([1]/[2])]: [Error sending address(es) to SMTP server. Return code: [SMTP 501 - Syntax error in parameters or arguments.]. Reason: [%SI_EMAIL_ADDRESS%].] (FBE60013)

2013-04-05 09:36:56,615 ERROR [PublishingService:HandlerPool-40] BusinessObjects_PublicationAdminLog_Instance_682917 - [Publication ID # 682917] - Distribution to destination CrystalEnterprise.Smtp (To: %SI_EMAIL_ADDRESS%)  failed. Recipient: Administrator, Document Scope: Test Burst email : 682939 (Pdf) : [No personalization applied].  (FBE60013)

2013-04-05 09:37:01,802 INFO  [pool-4-thread-8] BusinessObjects_PublicationAdminLog_Instance_682917 - [Publication ID # 682917] - Publication scheduling complete.

[Former Member]

ok so i solved it.  it seems it wanted the personaliztion features applied.  Now i do have one more question.  What if i don't want it to be an attachment what if i want it to be embedded in the email body is that possible?

[CdnConnection]

Kirk,

    You can NOT embed it into the email itself.  You want this type of customization you will need write some sort of custom Java SDK.  I am NOT sure if you could do both the embedding and publication within ONE SDK.

Regards,

Ajay

If the replies were helpful please let me know.