Scheduled Publication is running for ever-FBE 60037

Created a Publication with:

  1. Source as WebI report,
  2. Enterprise recipients,
  3. Destination as Email (configured everything correctly).

When the job is scheduled it runs for ever, with following as status in log

“Waiting for distribution job to complete. Job ID:88,656, name: ScopeBatch88656, Kind: ScopeBatch in Pending state (FBE 60037) [0 recipients processed]”

I have this problem only in UAT and it is working fine in DEV environment. Also the BO servers such as Adaptive Job Server and Publication Job Server are up and running.

Enterprise recipients receive emails with URL for the report in DEV and it stays in Running status for ever in UAT.

Environment is XI 3.1


sramlaxman (BOB member since 2010-11-24)

I periodically encounter the same issue, although my publication’s source is a Crystal Report.

Although all servers are indicated as running/enabled, I have found that a restart of the Destination Job Server allows the publication to complete.


fsalamon (BOB member since 2005-10-05)

Yes the server restart did finally work for me. Thanks for you reply.

But we now have a new error. I am able to schedule using my ID but the Users are not able to do it using theirs. The following is the error message they are getting in the log.

2012-01-30 15:23:04,687 ERROR [PublishingService:HandlerPool-125] BusinessObjects_PublicationAdminErrorLog_Instance_91902 - [Publication ID # 91902] - Distribution to destination CrystalEnterprise.Managed failed. Recipient: xx89275, Document Scope: Document name with instance (Excel) : (AND ). (FBE60013) [3 recipients processed.]

Users are gettings emails but nothing is shown when they open the web page. But only the user who schedules the report gets the URL which shows the excel file but he then cannot open it (double cliking on it does not work)

I have checked the groups/securities they all are good (though not exactly similar as Users are denied access to certain folders).


sramlaxman (BOB member since 2010-11-24)

Hello,

I also have a similar implementation for the Publications:

  1. Source as WebI report,
  2. Dynamic recipients(based on another Webi report),
  3. Destination as Email (configured everything correctly).

I created also in CMC an Event with the type “Success or Failure”(I didn’t set anything else) and I want to use it when scheduling the Publication but I don’t know how to make it work because I want to run a Publication after another Publication has finished running.
I’m guessing I have to select the Event I created from the Events–> Available Schedule Events (in the Publication properties). But where do I define that I want this Publication to run before the previous one.

Can someone please help me?
Thank you!


oki :romania: (BOB member since 2012-02-01)

try this—

publication 1, trigger event , publication 2

schedule publicaiton 1, enter in the “event to trigger on completion” the trigger event,

schedule publication 2, enter in the “events to wait for” the trigger event.

the flow will work as - publication 1 completes > triggers the event > publication 2 receives the event > publication 2 runs.

hope this helps.


smruti.panda :india: (BOB member since 2011-11-11)

This is exactly the scenario I want to implement.
Thank you very much for your fast answer, panda.

Regards,
oki


oki :romania: (BOB member since 2012-02-01)