500: Unexpected server error

CPAS Forum (Inactive)
500: Unexpected server error greener  2006-02-03 16:08
Status: Closed
 
Hey everyone, I installed CPAS about a month ago (XP pro, CPAS Installer, not manually) and it was working great until today when all I did was I reboot the machine and then when I tried to connect to cpas I recieved:
500: Unexpected server error java.lang.reflect.InvocationTargetException

[Show more details] java.lang.RuntimeException: java.lang.reflect.InvocationTargetException
       at org.fhcrc.cpas.util.BoundMap.get(BoundMap.java:89)
       at org.fhcrc.cpas.view.GroovyView.createModelBinding(GroovyView.java:475)
       at org.fhcrc.cpas.view.GroovyView.renderView(GroovyView.java:447)
       at org.fhcrc.cpas.view.WebPartView.render(WebPartView.java:123)
       at org.fhcrc.cpas.view.HttpView._render(HttpView.java:197)
       at org.fhcrc.cpas.view.HttpView.include(HttpView.java:403)
       at org.fhcrc.cpas.view.ViewController.includeView

And it continues...

I read through all the posts pertaining to this problem.

It appears that the user listed above vensel@pw.usda.gov

had the same exact problems and me. I tried to use PGTEST and also recieved:

The system cannot find the file specified

I went in and added the environmental variable:

Variable name %JAVA_HOME% (and I tried just JAVA_HOME) Variable Value: C:CPASInstalljdk1.5.0_04bin

to both the user and system, however I'm still getting the same 500 error I attached my log and cpas file for review. There is no firewall currently on and since the system has been working for a month so I can assume the Postgre works The post gre conf file looks like the 5432 port has not changed. Any advice folks can give me is muchly appreciated. sorry I first posted as a reply, but realized it should be a new post.

thanks

-Rich
 
 
mbellew responded:  2006-02-04 11:11
The relevant error in this trace is

03 Feb 2006 10:47:36,523 ERROR DbSchema : Exception loading schema from metadatacore org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.)

My guess is that tomcat came up before the postgres service. Try stopping the tomcat service, make sure posgres is running, then restarting the tomcat service.

I can see how this would be an issue when running both servers on the same machine. If you're up for it, you might look into making the tomcat service "depend" on the postgres service. This can be done on the Dependencies Tab of the Properties dialog in the Windows Services Manager.

 
adam responded:  2006-12-05 10:47