Thank you @alfranke for your patience going through the error logs. I didn’t have an idea that Service Name was database name (I did give the proper database name for CDM Database Name). But thanks to you there are no connection errors anymore.
But it gave rise to some new flyway error about cohort_definition table already
existing . I looked through this post Olympus configuration questions/problems and it was suggested that the table be deleted and let flyway create it. I went ahead and did that but, it gave rise to a new flyway error - http://pastebin.com/DXYjSNNU. I am not sure about how to resolve this.
Thanks for all the help @alfranke