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.

Jobs running slow after changing the Datastore credentials.


 
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
Vamsi99
Senior Member
Senior Member



Joined: 25 Nov 2010

Posts: 65


flag
PostPosted: Sun Nov 08, 2015 10:17 am 
Post subject: Jobs running slow after changing the Datastore credentials.

Hi,

I have changed the User credentials in one of the Datastores, and observe the Jobs have become very slow and unresponsive.

I am able to run a test job, and Connectivity is working fine.

Not able to understand why Jobs are not running as earlier,Can someone suggest if i need to check any parameters.

Thanks,
Vamsi,
Back to top
prasanna NA
Forum Member
Forum Member



Joined: 09 Jan 2012

Posts: 23



PostPosted: Wed Dec 09, 2015 1:59 am 
Post subject: Re: Jobs running slow after changing the Datastore credentia

Dear Vamsi,

Good Day!

First of all could you please check whether the new connection's server is working fine or not i mean the connection that we define in the datastore(oracle,sql or etc:-) sometimes the server might be down(oracle,sql etc). due to this you are unable to fetch the data i guess.

Also, could you please check how many records that you are pulling or loading into the new connection.

Also you said that the new connection is working fine with some test job. can you tell me hoe many records ou are pulling or loading in the new connection in your test job.

Regards,
Prasna
Back to top
Vamsi99
Senior Member
Senior Member



Joined: 25 Nov 2010

Posts: 65


flag
PostPosted: Wed Dec 09, 2015 5:44 am 
Post subject: Re: Jobs running slow after changing the Datastore credentia

Hi Prasanna

Reimporting all the Target tables solved the issue icon_biggrin.gif icon_biggrin.gif

Thanks,
Vamsi.
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 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.0265 seconds using 17 queries. (SQL 0.0027 Parse 0.0008 Other 0.0230)
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