BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: Upcoming Events: PGHBOUG: Aug 23.

Publications Running over 24 hours


 
Search this topic... | Search XI Scheduler... | Search Box
Register or Login to Post    Forum Index -> Enterprise Scheduling and Distribution -> XI Scheduler  Previous TopicPrint TopicNext Topic
Author Message
a123
Principal Member
Principal Member



Joined: 28 Dec 2011

Posts: 176



PostPosted: Thu Apr 26, 2018 8:05 am 
Post subject: Publications Running over 24 hours

Hello Folks

Environment: 4.1 SP9 (Physical) Windows 2008 server 1TB RAM SQL server database

Issue: Systemic issue where all publications run for longer then 24 hours before completing.

I have ran the same publications on two other separate environments one 4.1 SP9 and 4.2 SP4, the results is they run in normal time few seconds to few minutes.

I have SAP involved but I have not made traction with them. They collected logs, landscape report. Created single ADP with XMX set at 10G

Any advice how I can research root cause of the issue?

I am thinking of splitting the adaptive processing server according to a video I saw on the SAPAnalyticsTraining https://www.youtube.com/watch?v=2Uyi0V7RdwA


Thank You,
Amr
Back to top
Nick Daniels
Forum Aficionado
Forum Aficionado



Joined: 15 Aug 2002

Posts: 14069
Location: England


flag
PostPosted: Thu Apr 26, 2018 9:30 am 
Post subject: Re: Publications Running over 24 hours

Are they waiting for WIPS resource. Click on Running and see what it says.
Back to top
a123
Principal Member
Principal Member



Joined: 28 Dec 2011

Posts: 176



PostPosted: Thu Apr 26, 2018 9:52 am 
Post subject: Re: Publications Running over 24 hours

Nick Daniels wrote:
Are they waiting for WIPS resource. Click on Running and see what it says.


Thank You Nick for your prompt reply. I attached a screen shot of the message. In the two other environments the publications finished within 60 seconds. Yesterday when I ran this publication it took 16 hours.
Back to top
a123
Principal Member
Principal Member



Joined: 28 Dec 2011

Posts: 176



PostPosted: Thu Apr 26, 2018 10:44 am 
Post subject: Re: Publications Running over 24 hours

I took the information in the status message "waiting for scheduling job to complete" and googled it and came across this link https://archive.sap.com/discussions/thread/1783918

It said due to recurring schedule the publication can be waiting? I created a copy of the report with no schedules and behold the publication ran fine.

So what is the issue with the report having recurring schedules and a publication over it?
Back to top
Nick Daniels
Forum Aficionado
Forum Aficionado



Joined: 15 Aug 2002

Posts: 14069
Location: England


flag
PostPosted: Thu Apr 26, 2018 12:33 pm 
Post subject: Re: Publications Running over 24 hours

See the word Pending in your screenshot? It means there isn't a free crystal service to procesd the report...are other reports running all day while these publications hang about?
Back to top
a123
Principal Member
Principal Member



Joined: 28 Dec 2011

Posts: 176



PostPosted: Thu Apr 26, 2018 12:52 pm 
Post subject: Re: Publications Running over 24 hours

Hello Nick for the log file I don't know why it says it is pending. I assume because the log file is being written into. I ran a few tests and for log file it does show status of pending until the publication completes. The Status does show running.

I don't understand how a recurring schedule in the report impacts the publication?
Back to top
Nick Daniels
Forum Aficionado
Forum Aficionado



Joined: 15 Aug 2002

Posts: 14069
Location: England


flag
PostPosted: Thu Apr 26, 2018 2:10 pm 
Post subject: Re: Publications Running over 24 hours

The publication is just a wrapper but the work is done by a crystal report service....or web intelligence processing service. They have limits on concurrent usage. Say that limit is 5 and 5 crystal reports are currently scheduled and running...your publicstion can get started but that is jyst the wrapper it needs a free slot to actually run the report
Back to top
a123
Principal Member
Principal Member



Joined: 28 Dec 2011

Posts: 176



PostPosted: Thu Apr 26, 2018 4:01 pm 
Post subject: Re: Publications Running over 24 hours

I don't have any other reports pending. So I have been running more tests. I have been pulling in more data instead of daily, monthly now. I have noticed the same message "waiting for scheduling job to complete" then it finishes.

My next steps in testing is to pull more data about 6 month worth so I have a baseline. Then I will schedule a normal recurring report and run the publication and see if performance stays the same.
Back to top
Nick Daniels
Forum Aficionado
Forum Aficionado



Joined: 15 Aug 2002

Posts: 14069
Location: England


flag
PostPosted: Sat Apr 28, 2018 7:07 am 
Post subject: Re: Publications Running over 24 hours

Ok, did you try just scheduling a refresh of the report as opposed to a full blown publication?
Back to top
a123
Principal Member
Principal Member



Joined: 28 Dec 2011

Posts: 176



PostPosted: Mon May 14, 2018 10:00 am 
Post subject: Re: Publications Running over 24 hours

Hello Nick,

The issue has been resolved. I had to go to the default setting in the actual report and remove the event trigger. It still does not make sense why saving an event in the default setting would cause this behavior. I will reach out to the SAP reps and see if they can replicate the issue and offer advice.

I appreciate all your help,
Amr
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Enterprise Scheduling and Distribution -> XI Scheduler  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0319 seconds using 17 queries. (SQL 0.0030 Parse 0.0009 Other 0.0279)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo