fix: replaced transactional rollback with internal check on thrown errors

The recently introduced transactional model flow, on the dataset registration endpoint, showed issues on making query with no ancestor and during concurrency jobs execution. To avoid the extra overhead introduced, the transactional model flow has been replaced with a coherency check in the dataset registration step.