Vantage 8.04 on Win 64 and SQL Server Issues

[tnewellar]

We have been having issues with our Vantage installation and Epicor seems to be at a loss. Is anyone operating successfully with a similar configuration?

Dell 2950 server, 16 GB RAM
Windows server 2003 64 bit OS
SQL Server 2005
Vantage 8.03.403C

What happens is that from one day to the next the Progress application servers stop accepting connections. We get the following error from the clients.
Could not connect to the AppServer: General Error: No connection could be made because the target machine actively refused it: (7203)
At Epicors technical support direction we'vechanged the application server pool parameters and now can get several days of connectivity. Then refused connections again. No decernable reason as to why.

This is a brand new installation. Epicor did the installation. Epicor has been on the server a dozen times and has not fixed it yet.

At this point, we can not consider going live on the new system because of the stability issues.

Is there anyone running with the same configuration?
Is there anyone experiencing the same or similar issues?

 

[gmcfarlane]

If you have a SQL installation, look at the table licUser.
this has a habit of getting filled w/ orphaned records if a user powers down w/ a vantage session open.

this is the table used to monitor license usage. You can just delete all the records and you will be ok.

Its been a while since I had this problem. You may need to restart your app servers after you do this.

use mfgsys803
go
delete from licuser

 

[tnewellar]

Thanks gmcfarlane, that does not seem to be the issue at this point but I'll keep it in mind as we start to have more users accessing the system.

I applied a new open edge patch today and am hopeful that the root cause is addressed by the hotfix.

cheers

 

[TechoBabbly]

What do your appserver logs say? Have you looked at them prior to restarting the appservers after you get this error? I would suggest setting them up for verbose logging to try to track down what the problem might be.