fix: handle orphan files and return appropriate responses when syncing connectors

fix: handle orphan files and return appropriate responses when syncing connectors #2763