Error Message

An error occured updating a schedule. System.Data.SqlClient.SqlException: 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.

When Compliance Accelerator (CA) or Discovery Accelerator (DA) creates a Schedule for searches, the Job Owner is sa by design.  When the SQL System Account is changed from SQL System Account default 'sa', the job cannot be linked to the SQL Server Agent Jobs.

Workaround 

Rename the SQL System Account back to the default of sa.

1.  Open the Microsoft SQL Server Management Studio (SSMS) console.

2.  Expand Security and then Login.

3.  Locate and right click the System Account and select Rename.

4.  Replace the name with sa and save.

Veritas Corporation has acknowledged that the above-mentioned issue is present in the version(s) of the product(s) referenced in this article.

There are currently no plans to address this issue by way of a cumulative hotfix or service pack in the current or previous versions of the software at the present time. This issue may be resolved in a future major revision of the software at a later time, but is not scheduled for any release. If you feel this issue has a direct business impact for you and your continued use of the product, please contact your Veritas Sales representative or the Veritas Sales group to discuss these concerns.  For information on how to contact Veritas Sales, please see https://www.veritas.com.