Livelink Service Hangs

[Vand20]

I have LL 9.5.0.1 running on Windows 2003 SP2 server. This is an entire new systems, new firewall ...etc that we are going to move our current Livelink enterprise to.
I made copy of our data files: EFS, SQL.. and currently running the system as test prior to production cut over. We have the SQL & Index server on the same subnet (inside network), the Web server is on another subnet (Out side DMZ)
The problem I have with my livelink instance on the Web server is livelink would run for a couple hours then cease to respond. When Livelink stops responding, I was prompt for the login page where I enter my login and password again - the error I get was a fail loging in: Unable to retreive the information from the KUAF table.
This is seems as from my web server, I lost a connection with the SQL database. I don't have any trouble logging in from my Index server. This is just on the Web server. Firewall logs didn't show any block traffic.
By stop and start livelink service, I'll have everything working for a couple hours and it would happens again.
I'm wondering if any body experience the same thing. I suspect a socket connection time out between my Web server and the Livelink SQL database, but can not determine what is it.

 

[ggriffit]

This is most likely a DB timeout on the connection from the webserver to the DB, have you looked at the THREAD and CONNECT logs on the webserver?

Greg Griffiths
Livelink Certified Developer & ECM Global Star Champion 2005 & 2006

http://www.greggriffiths.org/livelink/

 

[Vand20]

Thank you Ggriffit for reply ,
I moved the Web server to the same subnet as my SQL server and don't have this problem. So the problem is definitely a DB time out from the firewall. I have a cisco ASA5520 with IPS that I have to investigate. As far as I know, we don't apply any time out for connection protocol but I'm new at this firewall so I'm not sure if I'm still missing something in the setup. May be some default setting that I'm not aware of.
Much appreciate if you or other usershave experience this problem.
Thanks