Skip to Content
avatar image
Former Member

IDT Derived Table Validation returns Timeout error

Hello,

In IDT we have derived tables that joins two tables. After validation, aproximately 10 minutes waiting and then "Timeout error " error message appears. When I write "top 1" in the select clause, validation was finished successfully.

How can I solve this problem?

Thank you all

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Oct 13, 2017 at 04:13 AM

    Hi Mehmet,

    Update the parameters of DFX to remove the 600 seconds limit.

    Thanks,
    Mahboob Mohammed

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 18, 2017 at 02:23 PM
    -1

    You may also check if you are using ansi92 sql paramter and fully qualified naming schema. This might help correct the root of the issue.

    Evaluate if there are any expensive operators in the joins of the tables. Are there primary keys/foreign keys set?Is the cardinality set?

    Scanning for cardinality may take time as it searches the entire table for dublicates and comparisons between the tables. If the tables are large then this may take time in validation.

    Kindest Regards,

    Jacqueline

    Add comment
    10|10000 characters needed characters exceeded