Did you follow the recommendation in the error message?
We had a bug at some point that was fixed around prepared transactions.. I would need to know the version... and quite possibly get a copy of your data if you are using an older version.
Justin and Clebert ,
Thanks for your inputs. I followed the error message and the services are up now. If it is going to be periodic , I might ask your help with the required data files.