[sims] SIMSScheduledTaskUser

[Rawns]

This error is showing up in event viewer every 15 seconds:

 

The activated proc '[sims].[db_pia_sb_RunScheduledJob]' running on queue 'sims.sims.ScheduledJobQueue' output the following: 'Cannot execute as the database principal because the principal "SIMSScheduledTaskUser" does not exist, this type of principal cannot be impersonated, or you do not have permission.'

 

I assume it's because the SIMSScheduledTaskUser is missing from System Manager. Not too familiar with this user, so does anyone know what permissions this user should have, and is the password for the account usually a default one? Odd though as no SIMS scheduled tasks are trying to run at the moment.

Edited February 25, 2013 by Rawns

[vikpaw]

I don't think it's a default user. If it's for the kind of scheduled reports I'm thinking of.

You can create it and supply the credentials to command reporter / the scheduled script.

I'd say someone has deleted it. You should be able to find the scheduled task that is running it. Odd frequency mind.

[vikpaw]

Or this:

The 'SIMSScheduledTaskUser' is a user account required for 3rd Party Data Change Tracking (enabled via the menu route Tools | Setups | Data Change Management).

 

 

 

If the Data Change Management option is turned ON and you do not use a third party product for extracting data from SIMS .net, then it should be set to OFF.

 

If you do need this option to be turned on, then please could you log a case with your local support unit quoting this KB number.

[howartp]

Necro thread.

 

I came across this thread last week with the same issue, and opened a ticket with Capita.

 

Working with the engineer this morning, we ran the following SQL. (A joint effort because I found the SQL article but he had the knowledge to understand it)

 

This looks in the master and SIMS databases for a principal called SIMSScheduledTaskUser - which in our case was completely missing from master, despite showing up in both SQL Studio > SIMS > Security > Users and SQL Studio > Master > Security > Users.

 

USE master

SELECT * FROM sys.database_principals

WHERE [name] = 'SIMSScheduledTaskUser'

go

USE SIMS

SELECT * FROM sys.database_principals

WHERE [name] = 'SIMSScheduledTaskUser'

go

 

To fix it (ie recreate the principal) we ran:

 

set nocount on

 

alter user SIMSScheduledTaskUser

with login = SIMSScheduledTaskUser

 

Go

 

Hope this helps someone else in another 8 years time?!