November 5, 2009 at 8:31 am
MS SQL Server 2005...
These two errors are filling up my sql server and Server level application even log??
Cannot add or update Activity record because Account Owner does not exist.
Error: 250071, Severity: 16, State: 1.
The error is associated with a user running a series of inserts like this.....
INSERT INTO [Activity]([Cust],[Type],[CashTran],[BaseAmt],[BookDate],[RecvPay],[Curr],[FxAmt],[Branch],[Dept],[TranDate],
[Ref],[Account],[ValueDate],[PaymtMethod],[InstrumentQty],[InstrumentPrice]) values(@1,@2,@3,@4,@5,@6,@7,@8,@9,@10,getdate(),@11,@12,@13,@14,@15,@16)
Can anyone tell me how to fix this?
November 5, 2009 at 8:42 am
That's almost certainly a custom error. Is there a trigger on the table they're inserting into?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 5, 2009 at 11:53 am
There are 3 triggers but I cannot view them because the application vendor has them encrypted!
November 5, 2009 at 11:56 am
Then you'll need to contact the application vendor about the error message.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply