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.