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

Register | Login 

Sunset Ride 
Sunset Ride 

General Notice: BOB is going to retire...please see details here. All BOB forums have been converted to "read only" as of September 1st.
General Notice: No events within the next 45 days.

Job hangs when trying to run in parallel

Goto page 1, 2  Next
 
Search this topic... | Search DI: Performance and Tuning... | Search Box
Register or Login to Post    Forum Index -> Data Integrator -> DI: Performance and Tuning  Previous TopicPrint TopicNext Topic
Author Message
STEFFI DAVID
Forum Member
Forum Member



Joined: 16 May 2012

Posts: 14
Location: INDIA


flag
PostPosted: Wed Jun 13, 2012 2:04 am 
Post subject: Job hangs when trying to run in parallel

Hi,

We have a job having multiple workflows running in parallel, almost 20, which in turn have 2 WF's each within (sometimes connected sequentially) and these having DF's within. The job never executes in parallel, The sequential run is successful though.

We have tried everything from changing the no. of processors from 8 to 25, to changing the DOP of the DF's to 4 from the actual 0. But nothing turned out fruitful.

Appreciate any help!!

Additional info:
DB: Oracle
We have recently migrated the BODI 11.7 job to BODS 4.0

banghead.gif banghead.gif
Back to top
STEFFI DAVID
Forum Member
Forum Member



Joined: 16 May 2012

Posts: 14
Location: INDIA


flag
PostPosted: Tue Jun 19, 2012 3:24 am 
Post subject: Re: Job hangs when trying to run in parallel

Hi all,

Just in case you all have a similar problem, the job executes absolutely fine when the 2.5 patch is installed.

Steffi
Back to top
eganjp
Forum Addict
Forum Addict



Joined: 12 Sep 2007
ASUG Icon
Posts: 4287
Location: Denver Area


flag
PostPosted: Tue Jun 19, 2012 12:54 pm 
Post subject: Re: Job hangs when trying to run in parallel

STEFFI DAVID wrote:
Hi all,

Just in case you all have a similar problem, the job executes absolutely fine when the 2.5 patch is installed.

Steffi


Which patch is that? I haven't heard of SAP creating a 2.5 patch.

_________________
Jim Egan
ProKarma-an SAP Consulting Partner
Speaker at RMOUG Training Days 2013
Speaker at Sapphire Now 2013
Speaker at Business Objects User Conference 2013
-My ETL is faster than your database! - Advanced ETL performance tuning for Data Services
-Kill ETL bugs before they kill you!
My ETL blog

Latest Blog Posts
• 2014-04-17 Can Your ETL Make Your Reporting Faster?
• 2014-04-04 ProKarma Acquires Mantis Technology Group
• 2014-04-02 How to Create Charts in Webi (Part 2 of 2)
Back to top
STEFFI DAVID
Forum Member
Forum Member



Joined: 16 May 2012

Posts: 14
Location: INDIA


flag
PostPosted: Wed Jun 20, 2012 12:16 am 
Post subject: Re: Job hangs when trying to run in parallel

SAP BusinessObjects Data Services 4.0
Support Pack 2 Patch 5
(Version 14.0.2.462)

We call it 2.5 patch here..
Back to top
eganjp
Forum Addict
Forum Addict



Joined: 12 Sep 2007
ASUG Icon
Posts: 4287
Location: Denver Area


flag
PostPosted: Wed Jun 20, 2012 9:30 am 
Post subject: Re: Job hangs when trying to run in parallel

As if the whole R3 and version 12.x thing was bad enough now there is a new way to describe patches. banghead.gif Can SAP make it any more complicated? crazy.gif
_________________
Jim Egan
ProKarma-an SAP Consulting Partner
Speaker at RMOUG Training Days 2013
Speaker at Sapphire Now 2013
Speaker at Business Objects User Conference 2013
-My ETL is faster than your database! - Advanced ETL performance tuning for Data Services
-Kill ETL bugs before they kill you!
My ETL blog

Latest Blog Posts
• 2014-04-17 Can Your ETL Make Your Reporting Faster?
• 2014-04-04 ProKarma Acquires Mantis Technology Group
• 2014-04-02 How to Create Charts in Webi (Part 2 of 2)
Back to top
STEFFI DAVID
Forum Member
Forum Member



Joined: 16 May 2012

Posts: 14
Location: INDIA


flag
PostPosted: Wed Jun 20, 2012 10:45 pm 
Post subject: Re: Job hangs when trying to run in parallel

Tell me about it!!

But anyway, in case you have any other option in solving the issue I've mentioned, do let me know. I don't want to stick on to the fact that this patch is what can solve this. icon_question.gif

"We have a job having multiple workflows running in parallel, almost 20, which in turn have 2 WF's each within (sometimes connected sequentially) and these having DF's within. The job never executes in parallel, The sequential run is successful though."
Back to top
eganjp
Forum Addict
Forum Addict



Joined: 12 Sep 2007
ASUG Icon
Posts: 4287
Location: Denver Area


flag
PostPosted: Thu Jun 21, 2012 10:09 am 
Post subject: Re: Job hangs when trying to run in parallel

Is it the case where you are trying to run two instances of the job in parallel? Or, are you trying to run the Workflows within the job in parallel?

Increasing the number of engines is one of the first things I would have recommended. But you already took care of that. Is it possible that you are overloadig the operating system in which the Job Server is running?

On the database side are you seeing the multiple requests from the Job Server? Is it possible that the database server is the holdup?

_________________
Jim Egan
ProKarma-an SAP Consulting Partner
Speaker at RMOUG Training Days 2013
Speaker at Sapphire Now 2013
Speaker at Business Objects User Conference 2013
-My ETL is faster than your database! - Advanced ETL performance tuning for Data Services
-Kill ETL bugs before they kill you!
My ETL blog

Latest Blog Posts
• 2014-04-17 Can Your ETL Make Your Reporting Faster?
• 2014-04-04 ProKarma Acquires Mantis Technology Group
• 2014-04-02 How to Create Charts in Webi (Part 2 of 2)
Back to top
STEFFI DAVID
Forum Member
Forum Member



Joined: 16 May 2012

Posts: 14
Location: INDIA


flag
PostPosted: Tue Jun 26, 2012 1:48 am 
Post subject: Re: Job hangs when trying to run in parallel

I'm trying to run the Workflows within the job in parallel.
The job is something like,
"there are 4 major WF's connected in series, each of these WF's have around 20 WF's within, and each of these 20 WF's have another 2 WF's in them and then each have 1 or 2 DF's and a whole load of scripts calling out functions, etc., etc. here and there."

We also made sure that the OS was not overloaded, by assigning a separate job server to this job.
As usual in the begining all fingers were pointed to the DB, and they also made sure that there was no delay or holdup from their side.

Th ultimate solution after each try was the patch. banghead.gif
Back to top
Johannes Vink
Forum Enthusiast
Forum Enthusiast



Joined: 20 Mar 2012

Posts: 1138


flag
PostPosted: Tue Jun 26, 2012 2:51 am 
Post subject: Re: Job hangs when trying to run in parallel

From which patch level did you come from? Patch 5 fix list does not contain anything around hanging proceses or something about Oracle.

Or patch 5 fixed more than is listed...
Back to top
eganjp
Forum Addict
Forum Addict



Joined: 12 Sep 2007
ASUG Icon
Posts: 4287
Location: Denver Area


flag
PostPosted: Tue Jun 26, 2012 9:15 am 
Post subject: Re: Job hangs when trying to run in parallel

Johannes Vink wrote:
Or patch 5 fixed more than is listed...


It's protected from disclosure by Executive Privilege. icon_biggrin.gif

_________________
Jim Egan
ProKarma-an SAP Consulting Partner
Speaker at RMOUG Training Days 2013
Speaker at Sapphire Now 2013
Speaker at Business Objects User Conference 2013
-My ETL is faster than your database! - Advanced ETL performance tuning for Data Services
-Kill ETL bugs before they kill you!
My ETL blog

Latest Blog Posts
• 2014-04-17 Can Your ETL Make Your Reporting Faster?
• 2014-04-04 ProKarma Acquires Mantis Technology Group
• 2014-04-02 How to Create Charts in Webi (Part 2 of 2)
Back to top
STEFFI DAVID
Forum Member
Forum Member



Joined: 16 May 2012

Posts: 14
Location: INDIA


flag
PostPosted: Tue Jun 26, 2012 10:56 pm 
Post subject: Re: Job hangs when trying to run in parallel

Johannes Vink wrote:
Patch 5 fix list does not contain anything around hanging proceses or something about Oracle.

Or patch 5 fixed more than is listed...



ADAPT01622848 - Just thought it might be this one though it has teradata instead of oracle, found it in the release notes. Like I've mentioned before, not sure how the job runs fine with this patch, maybe it isn't listed like you said, might come out later, but it solves my purpose. icon_razz.gif

If you still got some more ideas, then do let me know.
Back to top
Johannes Vink
Forum Enthusiast
Forum Enthusiast



Joined: 20 Mar 2012

Posts: 1138


flag
PostPosted: Wed Jun 27, 2012 12:46 am 
Post subject: Re: Job hangs when trying to run in parallel

Nah does not seem to be any connection between bulk loading Teradata and this case...

I just thought... could there be a table lock or that BODS is waiting on free resource at the db level? I had once a case where that happened with no error. BODS just kept waiting... and waiting etc.
Back to top
eganjp
Forum Addict
Forum Addict



Joined: 12 Sep 2007
ASUG Icon
Posts: 4287
Location: Denver Area


flag
PostPosted: Wed Jun 27, 2012 9:42 am 
Post subject: Re: Job hangs when trying to run in parallel

Johannes Vink wrote:
I just thought... could there be a table lock or that BODS is waiting on free resource at the db level? I had once a case where that happened with no error. BODS just kept waiting... and waiting etc.


There is a feature with Oracle tablespaces where if they fill up then the connection/ETL job will get suspended and wait for the DBA to add more space. The time it is allowed to wait is configurable by the DBA.

What we have found is that just because the DBA gets around to adding more space doesn't mean that the job will continue as if nothing happened. Some times it will, some times it won't.

_________________
Jim Egan
ProKarma-an SAP Consulting Partner
Speaker at RMOUG Training Days 2013
Speaker at Sapphire Now 2013
Speaker at Business Objects User Conference 2013
-My ETL is faster than your database! - Advanced ETL performance tuning for Data Services
-Kill ETL bugs before they kill you!
My ETL blog

Latest Blog Posts
• 2014-04-17 Can Your ETL Make Your Reporting Faster?
• 2014-04-04 ProKarma Acquires Mantis Technology Group
• 2014-04-02 How to Create Charts in Webi (Part 2 of 2)
Back to top
pratipsen
Forum Member
Forum Member



Joined: 29 Jun 2012

Posts: 2



PostPosted: Fri Jun 29, 2012 2:38 pm 
Post subject: Re: Job hangs when trying to run in parallel

HI,
we are processing many iDocs from SAP system (00s, 000s) using BODS - and its taking huge huge time to process them - Niether can we have them in parallel as the system hangs - I mean all RFCs hang.

Also, having 000s of iDocs sometimes results in huge queues and also the system fails. The manual mentions to disable 'dispatch immediate' and using higher SAP packets'. But is there a good work arond - with respect to tuning?

What is the best suggested solution?

Sen
Back to top
eganjp
Forum Addict
Forum Addict



Joined: 12 Sep 2007
ASUG Icon
Posts: 4287
Location: Denver Area


flag
PostPosted: Fri Jun 29, 2012 2:41 pm 
Post subject: Re: Job hangs when trying to run in parallel

pratipsen, you should start your own thread as your topic does not relate closely enough to the topic of this thread.
_________________
Jim Egan
ProKarma-an SAP Consulting Partner
Speaker at RMOUG Training Days 2013
Speaker at Sapphire Now 2013
Speaker at Business Objects User Conference 2013
-My ETL is faster than your database! - Advanced ETL performance tuning for Data Services
-Kill ETL bugs before they kill you!
My ETL blog

Latest Blog Posts
• 2014-04-17 Can Your ETL Make Your Reporting Faster?
• 2014-04-04 ProKarma Acquires Mantis Technology Group
• 2014-04-02 How to Create Charts in Webi (Part 2 of 2)
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator -> DI: Performance and Tuning  Previous TopicPrint TopicNext Topic
Page 1 of 2 All times are GMT - 5 Hours
Goto page 1, 2  Next
 
Jump to:  

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

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0313 seconds using 18 queries. (SQL 0.0028 Parse 0.0010 Other 0.0275)
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