"Query timeout expired"

  • Hi, ALL

    CAN SOME TELL ME WHATS GOING ON HERE OR ANY SUGGESTIONS

    OLE DB provider "SQLNCLI" for linked server "TFSQL04" returned message "Query timeout expired".

    Msg 7399, Level 16, State 1, Procedure reportTecsysReconciliation, Line 34

    The OLE DB provider "SQLNCLI" for linked server "TFSQL04" reported an error. Execution terminated by the provider because a resource limit was reached.

    Msg 7421, Level 16, State 2, Procedure reportTecsysReconciliation, Line 34

    Cannot fetch the rowset from OLE DB provider "SQLNCLI" for linked server "TFSQL04". .

    THANKS FOR LOOKING INTO IT

  • @ harita

    When do you get this error, while running a proc?

    Can you check if your sql services are running?

    Or see errors in sql logs?

    Regards,

    Sushant

    Regards
    Sushant Kumar
    MCTS,MCP

  • Hi,

    i am getting this error when i run a stored pro

  • @ harita

    You need to increase the remote query timeout option in SSMS

    SSMS-->prop-->connections-->remote qery timeout--> wats the value??

    Regards,

    Sushant

    Regards
    Sushant Kumar
    MCTS,MCP

  • i think the value is 0

  • i didnt understand the path

    SSMS-->prop-->connections-->remote qery timeout--> wats the value??

    can you be more specific

  • which sql server version are you running?

    Regards
    Sushant Kumar
    MCTS,MCP

  • ya i found it teh remote query timeout is 600

  • change it to 0 and then again run the stored proc

    Regards,

    Sushant

    Regards
    Sushant Kumar
    MCTS,MCP

  • yes i did change it to 0 , but can you explain me whats going on here, we run this report every moth and never had this problem but y now

  • Did it run now or not?

    You may be running this every month, but usually it got run under 600 secs (10 mins) but now, maybe due to more data or slower speed thru network that query might be taking more than 10 mins to run and so it fails accordin to that setting.

    Regards,

    Sushant

    Regards
    Sushant Kumar
    MCTS,MCP

  • harita (11/1/2010)


    yes i did change it to 0 , but can you explain me whats going on here, we run this report every moth and never had this problem but y now

    Perhaps indexes have become fragmented or other performance problems have arisn.

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply