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

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

BODS jobs getting stuck for long time while extracting


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



Joined: 16 Feb 2020

Posts: 1



PostPosted: Sun Feb 16, 2020 9:40 am 
Post subject: BODS jobs getting stuck for long time while extracting

[Moderator Note: Moved from ABOUT BOB to DATA INTEGRATOR - Chris Pohl]

Hi all,

BODS jobs are getting stuck while extracting data in production.
It has huge data ,30 million join with 8 million and staging database is DB2.
But i noticed that this occurs first job run or after job is modified.
any ideas, is it due to collect statistics? transaction logs?.
one data flow was stuck for 13 hrs in same location,no change in job count.
It completed after 13 hrs. Next run of same job took 4 hrs to complete.
The data is same.
please let me know if you any idea abt this issue.

Regards
Hariprasad
Back to top
BOBJFan
Principal Member
Principal Member



Joined: 24 Sep 2011

Posts: 143



PostPosted: Thu Feb 27, 2020 10:23 am 
Post subject: Re: BODS jobs getting stuck for long time while extracting

Try Bulk Load option in Target Table
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.0273 seconds using 17 queries. (SQL 0.0028 Parse 0.0008 Other 0.0236)
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