added update method to access
added logging for query error
added logging for pipeline failure