SAP Knowledge Base Article - Preview

3143023 - sap_perf_job_add "Cannot insert the value NULL into column 'name', table 'msdb.dbo.sysjobs'"

Symptom

An error occurred while processing option System Rename > Central System > SAP System Rename(Last error reported by the step: Errors when executing sql command:

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert the value NULL into column 'name', table 'msdb.dbo.sysjobs'; column does not allow nulls. INSERT fails.
[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert the value NULL into column 'name', table 'msdb.dbo.sysjobs'; column does not allow nulls. INSERT fails.
[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert the value NULL into column 'name', table 'msdb.dbo.sysjobs'; column does not allow nulls. INSERT fails.
[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.

SOLUTION: If this message is displayed as a warning, you can ignore it. If this is an error, contact SAP support.

Last info written in  instdir_MssLog.log

use SID
execute as login = suser_sname(suser_sid('sid'))
------------------------------------------------
-- Create all CCMS monitoring SQL Agent Jobs
execute sap_perf_job_add ' ','DBCOLL'
execute sap_perf_job_add ' ','TABSTATS'
execute sap_perf_job_add ' ','LOCKSTATS'
------------------------------------------------
[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert the value NULL into column 'name', table 'msdb.dbo.sysjobs'; column does not allow nulls. INSERT fails.
[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert the value NULL into column 'name', table 'msdb.dbo.sysjobs'; column does not allow nulls. INSERT fails.
[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert the value NULL into column 'name', table 'msdb.dbo.sysjobs'; column does not allow nulls. INSERT fails.
[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.
------------------------------------------------


Read more...

Keywords

'msdb.dbo.sysjobs' rename sap_perf_job_add , KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.