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.
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).
I also have a similar implementation for the Publications:
Source as WebI report,
Dynamic recipients(based on another Webi report),
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.