CPAS/Tomcat can't communicate with your PostgreSQL service. Is the PostgreSQL service running? Can you communicate with it using pgAdmin III? Did you change the default port that PostgreSQL uses to communicate? If so, you'll need to specify this port in the jdbc url in cpas.xml.

Leave PostgreSQL running and restart Tomcat. It could be a timing problem where CPAS started up and attempted to connect before PostgreSQL was done starting. If that's the problem, you should be able to make the CPAS Tomcat service depend on PostgreSQL. The exact steps vary by operating system.

Adam

i faced a new problem again.
i've attached the error.log

so is CPAS/Tomcat communicating with PostgreSQL right now?

any guidance is greatly appreciated. thanks

Yes, they are communicating now. What is your configuration? You must be doing a manual install… but what operating system? What version of PostgreSQL?

The error message is fairly straightforward. The CPAS SQL scripts use a standard stored procedure language called PL/pgSQL. CPAS apparently created the new database, but PL/pgSQL is not installed by default on your PostgreSQL installation. So, you need to enable PL/pgSQL for the "cpas" database using CREATE LANGUAGE. The exact steps for doing this vary by PostgreSQL version… you can look it up in the PostgreSQL docs or use pgAdmin III to create the language.

Note: if you install on Windows using the graphical installer then all of this should be configured automatically.

yes finally it works thanks