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: No events within the next 45 days.

Degrees Paralellism, bad result


 
Search this topic... | Search Data Integrator... | Search Box
Register or Login to Post    Forum Index -> Data Integrator  Previous TopicPrint TopicNext Topic
Author Message
Victor_BCN
Principal Member
Principal Member



Joined: 15 Sep 2009

Posts: 215


flag
PostPosted: Wed Oct 04, 2017 2:20 am 
Post subject: Degrees Paralellism, bad result

Dear BO Experts,

in my Data Services DS Config we have the GLOBAL_DOP = 0 and a Dataflow with DOP = 0 as well

This Dataflow was creating 15 threads and crashed very often

We decided to reduce the number of threads, Setting the DOP value in the DF to DOP = 8

The result is it has created 19 threads icon_biggrin.gif

Do you know how and where this value has to be set up?

Thanks a lot!
nopity.gif
Back to top
eganjp
Forum Addict
Forum Addict



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


flag
PostPosted: Tue Oct 10, 2017 11:40 am 
Post subject: Re: Degrees Paralellism, bad result

Somewhere in DS 4.x the Global_DOP was set to 2, which was an increase from 1 that was there in DS 3.x. For new projects I leave it at 2 but almost any client project that migrates from 3.x to 4.x I'll change it to 1. There are a lot of Dataflows that simply aren't written to work with DOP > 1. I don't think using a value of zero is a good idea. Set it to 1 to be safe.

I make the change to the DS_Config.txt file in the C:\ProgramData\SAP BusinessObjects\Data Services\conf on a Windows machine.

_________________
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
Victor_BCN
Principal Member
Principal Member



Joined: 15 Sep 2009

Posts: 215


flag
PostPosted: Thu Oct 12, 2017 3:01 am 
Post subject: Re: Degrees Paralellism, bad result

Hi!

At the end I removed unnecessary items of the DF like a Table Comparison and Update branch

Now it's working fine and doesnt crash

Thanks a lot!
seeya.gif
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator  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.0188 seconds using 18 queries. (SQL 0.0115 Parse 0.0002 Other 0.0071)
CCBot/2.0 (http://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