Cannot add or update Activity record because Account Owner does not exist.

Question

Cannot add or update Activity record because Account Owner does not exist.

Jpotucek

SSCoach

Points: 18583
More actions
December 23, 2009 at 5:38 am

#143700

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.
Any ideas?

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

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

muthukkumaran Kaliyamoorthy SSCoach Points: 19026 More actions · Answer 1

Jpotucek (12/23/2009)
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.
Any ideas?

Which login r u using to connect the server (Sql or Windows)

Also post the sql server version

Select @@version

Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/

Jpotucek SSCoach Points: 18583 More actions · Answer 2

Select @@Version

Using Windows Authenticated login to connect to the Database

muthukkumaran Kaliyamoorthy SSCoach Points: 19026 More actions · Answer 3

Jpotucek (12/23/2009)
Select @@Version
Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86) Nov 24 2008 13:01:59 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
Using Windows Authenticated login to connect to the Database

Hi,

Did u check that Windows Login name in sql server security list.

Also check the OS error logs.

The SQL authenticated logins that receive the "Logon Error: 18456" error message are configured to use Windows domain password policy enforcement.

KB-925744

Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/

Johan Bijnens SSC Guru Points: 135382 More actions · Answer 4

did you restore that database ?

if yes, then check the database owner and put it back to the one it was before the restore (if you didn't alter it, it will be the sqluser or windows login that restored the db).

If you cannot find which was the previous db owner, then alter it to sa with mapping ON !

use yourrestoreddb

exec sp_changedbowner 'sa', true

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

Lowell SSC Guru Points: 323518 More actions · Answer 5

looks like a business rule error in your application, not anything from SQL itself; I'd guess you have an app that is writing to the error log, instead of sya, a messagebox for an end user? do you have an app that could be doing this?

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Jpotucek SSCoach Points: 18583 More actions · Answer 6

I checked the Windows authenticated login that is being used to connect to the database.. It is NOT set up to enforce Domain password Policy.

This DB has not been restored and the owner is 'sa' it always has been.

Not sure if the App is giving the User and error diaglog box. most of the errors occurred overnight and there are not users on the system..

Lowell SSC Guru Points: 323518 More actions · Answer 7

i'm thinking some overnight import/update process is failing; there's no "Activity record" or "Account Owner" as far as SQL is concerned; it really jumps out to me that some unattended application is posting to the logs. maybe look at any Jobs in the Agent that might be calling a process?

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Jpotucek SSCoach Points: 18583 More actions · Answer 8

The errors are being posted to the SQL Log as well as the Application Event log. I have no agent jobs running but I did check with the Developer and they have been running bulk imports into one of the databases in the Instance. They errors are occurring against the Developers own Network ID. Since this is a Dev box, they have adequate permissions to the Databases to do these types of bulk imports.. Just concerns me when I have errors in the logs that I can't explain..

Jpotucek SSCoach Points: 18583 More actions · Answer 9

The errors are being posted to the SQL Log as well as the Application Event log. I have no agent jobs running but I did check with the Developer and they have been running bulk imports into one of the databases in the Instance. They errors are occurring against the Developers own Network ID. Since this is a Dev box, they have adequate permissions to the Databases to do these types of bulk imports.. Just concerns me when I have errors in the logs that I can't explain..

Johan Bijnens SSC Guru Points: 135382 More actions · Answer 10

btw Error: 250071 is an error number > 49999 which indicates it is a user defined error code !

Order your devs to figure out in which occasions they raise this error !

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me