BS-9367 : CLONE - [6.1.2] And Join Gateways going into failed state

- Update SQL & Groovy scripts & Integration tests to update the gateway state with 'executing' if the HitBys doesn't start by "FINISH"; else, with "completed"