fix: do not roll back transaction on partial identity insert error

fix: do not roll back transaction on partial identity insert error #8294