+ Post New Thread
Results 1 to 3 of 3
MIS Systems Thread, SIMSScheduledTaskUser in Technical; 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 ...
  1. #1
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 493 Times in 376 Posts
    Rep Power
    0

    SIMSScheduledTaskUser

    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.
    Last edited by Rawns; 25th February 2013 at 03:36 PM.

  2. #2

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,956
    Thank Post
    775
    Thanked 1,487 Times in 1,234 Posts
    Rep Power
    367
    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.

  3. #3

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,956
    Thank Post
    775
    Thanked 1,487 Times in 1,234 Posts
    Rep Power
    367
    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.

  4. Thanks to vikpaw from:

    Rawns (1st March 2013)



SHARE:
+ Post New Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •