Videos on my server are being transcoded fine except sometimes I need to look into the mySQL table and reset last stuck field.

Question is: how to setup transcoding on separate server? Tried different approaches, but every time it throws an error in MySQL table "store local tmp file failed (storeFileLocally_Storage)"