Post reply

urgent-getting error while executing query in DTS

  • July 12, 2005 at 10:48 am

    #164316

    hi,

    i am getting this error while executing an query in DTS:

     

    Error:  -2147217900 (80040E14); Provider Error:  8650 (21CA)

       Error string:  [Microsoft][ODBC SQL Server Driver][SQL

    Server]Intra-query parallelism caused your server command (process ID #53) to deadlock. Rerun the query without intra-query parallelism by using the query hint option (maxdop1).

       Error source:  Microsoft OLE DB Provider for ODBC Drivers

       Help file:

       Help context:  0

    DTSRun OnFinish:  ExportTask

    Please help me as it is urgent.I am using SQL SERVER 2000

    thanks and regards,

    vishal

  • July 12, 2005 at 10:49 am

    #573556

    Try the query like this :

    Select * from dbo.SysObjects maxdop1

  • July 12, 2005 at 1:16 pm

    #573650

    DTS does the things only in serial manner, I mean one after the other. Check, whether you are executing two jobs at the same time. Ideally, put those on success/on completion/on failure etc.,

  • July 12, 2005 at 4:23 pm

    #573698

    I think you need to turn off your parellism because it's causing a deadlock.

  • July 12, 2005 at 5:33 pm

    #573711

    Did you try my version of the query???

  • July 12, 2005 at 5:46 pm

    #573718

    Remi, not sure which query you'r ereferring to?

     

    If you're talking about the query below it only reads everything from sysobjects.

    Select * from dbo.SysObjects maxdop1

  • July 12, 2005 at 6:15 pm

    #573721

    Select * from dbo.SysObjects maxdop1 this should stop that error from occuring.

  • July 12, 2005 at 8:23 pm

    #573753

    Remi, do you mean something like this?

    Select *

    from dbo.SysObjects

    option (maxdop 1)

  • July 12, 2005 at 8:37 pm

    #573754

    ya that makes more sens . No you know I never had multi processor server .

Viewing 9 posts - 1 through 8 (of 8 total)

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