OLE/DB provider returned message: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done

• Baiteay

  Old Hand

  Points: 357

  More actions

  June 30, 2005 at 10:11 pm

  #109988

  I create store procedure to run on [MICROSOF-BBC6D6].SMSUat2

  --------------------------------------------------------------

  CREATE PROCEDURE SPD_SmsDtsShipmentConfFromIDs_SetFlagAndGetDate

  AS

  DECLARE @SetDt           datetime 

  BEGIN

    SET @SetDt = GETDATE()

    UPDATE [MICROSOF-BBC6D6].SMSUat2.dbo.WMSSHPCONF

    SET      TransmitFlag = '9'

       ,ADDDATE   =   @SetDt

    WHERE TransmitFlag = '0' AND ProcessSource = 'Y'

    UPDATE   [INTELTION].IDS.dbo.WMSSHPCONF

    SET              TransmitFlag = '9'

         ,ADDDATE = @SetDt

    WHERE TransmitFlag = '0' AND ProcessSource = 'Y'

  END

  ----------------------------------------------------------------

  But it show:

  Server: Msg 7306, Level 16, State 2, Line 11

  Could not open table '"IDS"."dbo"."WMSSHPCONF"' from OLE DB provider 'SQLOLEDB'.  The provider could not support a row lookup position. The provider indicates that conflicts occurred with other properties or requirements.

  [OLE/DB provider returned message: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.]

   

  What should I do ?

  Help me please...............................

• July 4, 2005 at 8:00 am

  This was removed by the editor as SPAM

• Dan Donahue

  SSC Rookie

  Points: 32

  More actions

  July 7, 2005 at 8:40 am

  #571832

  Check out this kb article. http://support.microsoft.com/default.aspx?scid=kb;en-us;814581

  Basically it says to put a unique index or primary key on the table.

  Hope that helps,

  Dan