Chances are the sporadic part arises because the request usually finishes in under 30 seconds (the default CommandTimeout) but if things are busy or otherwise delayed and the database call takes more than 30 seconds you see this error. Check the code and make sure you set your CommandTimeout with plenty of room to allow for the request to complete in all scenarios.