Hello,
We are trying to set-up a load balancer with multiple instances of the Rest Services running in AWS, and I'm not sure how to configure Tessitura.
Thank you,
Lou Ann
So we set-up a load balancer in front of two identically set-up instances of the api server. Both api servers were domain-joined. We also had a load balancer for nginx. This seemed to be working OK, then we tried to resize the instance of our api server to something more robust than T2. Tessitura worked OK but our SOAP website started throwing the following error (which forced us to back-track and disable all load balancing to get things working again):
<Envelope> <Body> <Fault> <faultcode>soap:Server</faultcode> <faultstring>System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.SqlClient.SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_T_WEB_SESSION_VARIABLE_t_web_session". The conflict occurred in database "impresario", table "dbo.t_web_session_Session", column 'SessionKey'.The statement has been terminated. at Tessitura.WebAPI.webServiceSession.SetVariable(String sName, String sValue, String sMode) at Tessitura.WebAPI.Tessitura.SetVariable(String sSessionKey, String sName, String sValue, String sMode) --- End of inner exception stack trace ---</faultstring> <detail/> </Fault> </Body></Envelope>
We've since learned that we can load balance the api servers. We needed to make sure sticky sessions are enabled as well as ASP.NET Session State. However, we cannot load balance the nginx server nor can we load balance the seat server (apparently we would have a very bad day if we tried to do that).
The system is still not the way we want it but at least it's working ok.
Thank you.