An error occurred during the execution of xp_cmdshell. A call to 'CreateProcess' failed with error code: '1450'.


Msg 15121, Level 16, State 21, Procedure xp_cmdshell, Line 1
An error occurred during the execution of xp_cmdshell. 
A call to 'CreateProcess' failed with error code: '1450'.



Today one of my sql job which collects All disk space details for  server fails with above error.

From error its very much clear that xp_cmdshell is failing with error code 1450. As this is a weekly job i was sure there is no case of any access issue.

On researching i found 
 Error 1450 = "Failed to write to virtual disk. System error= [Insufficient system resources exist to complete the requested service. (1450)]"

I also manually run script and got same error , which means its resource issue.

So i did RDP on server and found CPU and memory was normal but there is no space on C: drive. Its showing 0 MB free.

So we created some space on C: drive and again job starts working fine.


Note: If you get error "failed with error code: '5'" ; Its a access issue. Give access to user running xp_cmdshell on folder.

No comments:

Post a Comment