000029455 - Unable to run the jobDeployScript.sql on the RSA Archer instance Database

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support on Apr 23, 2019
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000029455
Applies ToRSA Product Set: Archer
RSA Version/Condition: 6.x
Platform: Windows
IssueUnable to run the jobDeployScript.sql.

When the above script is run in the SQL management studio, it gives an error:
 

Msg 515, Level 16, State 2, Procedure sp_add_job, Line 137
Cannot insert the value NULL into column 'owner_sid', table 'msdb.dbo.sysjobs'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 14262, Level 16, State 1, Procedure sp_verify_job_identifiers, Line 41
The specified @job_id ('C3BE6690-FE17-433F-8F15-9CC149D04038') does not exist.
Msg 14262, Level 16, State 1, Procedure sp_verify_job_identifiers, Line 41
The specified @job_id ('C3BE6690-FE17-433F-8F15-9CC149D04038') does not exist.
Msg 14262, Level 16, State 1, Procedure sp_verify_job_identifiers, Line 41
The specified @job_id ('C3BE6690-FE17-433F-8F15-9CC149D04038') does not exist.
Msg 14262, Level 16, State 1, Procedure sp_verify_job_identifiers, Line 41
The specified @job_id ('C3BE6690-FE17-433F-8F15-9CC149D04038') does not exist.
Msg 515, Level 16, State 2, Procedure sp_add_job, Line 137
Cannot insert the value NULL into column 'owner_sid', table 'msdb.dbo.sysjobs'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 14262, Level 16, State 1, Procedure sp_verify_job_identifiers, Line 41
The specified @job_id ('7D8426CB-276A-404A-AEA3-8046049D484A') does not exist.
Msg 14262, Level 16, State 1, Procedure sp_verify_job_identifiers, Line 41
The specified @job_id ('7D8426CB-276A-404A-AEA3-8046049D484A') does not exist.
Msg 14262, Level 16, State 1, Procedure sp_verify_job_identifiers, Line 41
The specified @job_id ('7D8426CB-276A-404A-AEA3-8046049D484A') does not exist.
Msg 14262, Level 16, State 1, Procedure sp_verify_job_identifiers, Line 41
The specified @job_id ('7D8426CB-276A-404A-AEA3-8046049D484A') does not exist.


 
ResolutionThis issue occurs when the default SA account in the SQL Server is disabled.

- When the maintenance jobs are created -> an owner needs to be defined and by default the script assigns the owner as 'sa'
 
Search for the string '@owner_login_name' in the script, and replace SA with any other account that has sysadmin privileges.
 
Note: You will have to define the owner at two places in the script. (Since the script will be creating two jobs).

Attachments

    Outcomes