Skip to Content

job was taking 1 hour to execute but now taking 15 hours

What I have to do when some job was taking 1 hour to execute but now taking 15 hours. How can I solve this problem?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • Posted on Dec 25, 2014 at 09:08 PM

    There might be thousands of reasons. Try to narrrow down your problem using the monitor log output. Then proceed from there.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 26, 2014 at 09:58 AM

    Hi Sabat,

    As Dirk mentioned, check your BODS Logs and try to find which data flow is taking longer to complete. There might be a possibility of index fragmentation of your fact tables(if there are any). There might be other reasons also so I am not asking to check the indexes directly.

    Regards

    Arun Sasi

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 26, 2014 at 06:23 PM

    Hi,

    I had a similar issue where job executes for longer time.Could you please suggest in the monitor long how can we know that a particular query in the data flow is taking longer time to process.What makes the difference of the execution time and elapsed time.

    Many thanks in advance.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 27, 2014 at 05:24 AM

    Hi,

    Is there any calculation using the absolute time and elapsed time to check the time taken to read 1000 rows in a particular query.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 08, 2015 at 09:22 PM

    As mentioned in this chain, the reasons can be numerous.

    Some usual causes are

    1. If there is a join in the dataflow check the join condition as there might be cartisian issue in cases which might cause the issue

    2. Check the BODS Job server infrastructure setup. If the volume of data processed a lot higher than the original volume when it was taking 1 hour to execute, then you might need to upgrade the infrastructure. RAM/CPU or the combination of both can be upgraded

    3. Check the indexing set up on the source and target tables. Specifically if the target table has a clustered index introduced, then it will take a lot of time to load as it will cluster after each commit.

    The causes and remedies are endless.......

    Raghu

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.