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.
SAP Knowledge Base Article - Preview