SQL Server: Unable to locate and update an entity

[qutesanju]

I m getting one error for the job

Production_Delay_Insert..TransDelay: Unable to locate and update an entity, when an action of Update Only has been specified. Family: 'Invalid Delay' Search Criteria: INVALID_DELAY_MES_DATAB_CHR = '0' AND INVALID_DELAY_MES_SYSTE_CHR = 'P' AND INVALID_DELAY_MES_DELAY_KEY_NBR = '87402029OGDGNM10Mar 28 2008 7:00:00:000AM'.

what does this error say?

[* Note - Title changed to be more descriptive - Andy *]

[ray.wurlod]

It says there's no key of that combination of values in your target table, therefore there's no such row that can be updated.

[qutesanju]

but action set at my target table is insert new or update existing so if in case it's corrosponding entity not found while update so it must insert new record?

[nikhilanshuman]

but action set at my target table is insert new or update existing so if in case it's corrosponding entity not found while update so it must insert new record?

but the error message says ... "an action of Update Only has been specified".. !

[chulett]

Right, check your setting. What database / stage by the way?

[qutesanju]

database is sql server 2005

[ArndW]

Can you cut-and-paste your DataStage update SQL and try to run it in SQL server?