CMDBuild Forum

Initial start of CMDBuild fails with error "PSQLException: ERROR: function _cm_class_list() does not exist"

Old Versions
#1

Hello CMDBuild Team,

I have installed Postgresql 9.6, JDK 1.8, CMDBuild 2.4.2 on a Redhat 6 system and performed the steps in you technical manual

to unpack the files and libraries.

However on initial start, CMDBuild fails with error "PSQLException: ERROR: function _cm_class_list() does not exist"

I went into psql and ran

postgres=# CREATE LANGUAGE plpgsql;
ERROR:  language "plpgsql" already exists

Is 9.6 to recent of a release for cmdbuild 2.4.2?

I got the same error on 8.4, and so upgraded to the latest postgres release 9.6, but the error persists.

Any ideas on what I need to do to work around this error?

We are trying to demo CMDBuild to management asap to see if it will work as our CMDB.

Kind Regards,

Daniel Gutierrez

Sr. Developer

Walmartlabs

#2
Dear Daniel,
 
if you look at the database that you select from user interface using a tool such as pgAdmin can you find such function? If not the database is not a CMDBuild database or it was wrongly restored.
 
Best regards.
 
-- CMDBuild Team
 
Previously Daniel wrote:

Hello CMDBuild Team,

I have installed Postgresql 9.6, JDK 1.8, CMDBuild 2.4.2 on a Redhat 6 system and performed the steps in you technical manual

to unpack the files and libraries.

However on initial start, CMDBuild fails with error "PSQLException: ERROR: function _cm_class_list() does not exist"

I went into psql and ran

postgres=# CREATE LANGUAGE plpgsql;
ERROR:  language "plpgsql" already exists

Is 9.6 to recent of a release for cmdbuild 2.4.2?

I got the same error on 8.4, and so upgraded to the latest postgres release 9.6, but the error persists.

Any ideas on what I need to do to work around this error?

We are trying to demo CMDBuild to management asap to see if it will work as our CMDB.

Kind Regards,

Daniel Gutierrez

Sr. Developer

Walmartlabs

 

#3

Hi CMDBuild Team,

 

The problem was caused by me when I uncommented the DB access data in <tomcat>/webapps/cmdbuild/WEB-INF/config/database.conf

before finishing the initial configuration in the GUI. When the pplication failed to start the first time I saw a database access error in the cmdbuild.log file, so that is why I uncommented the entries. But after reading your Technical manual I realized that I was not supposed to do that.

I now have the Demo data installed and working fine.

Thanks for your response.

 

Daniel

 

Previously Tecnoteca wrote:
Dear Daniel,
 
if you look at the database that you select from user interface using a tool such as pgAdmin can you find such function? If not the database is not a CMDBuild database or it was wrongly restored.
 
Best regards.
 
-- CMDBuild Team
 
Previously Daniel wrote:

Hello CMDBuild Team,

I have installed Postgresql 9.6, JDK 1.8, CMDBuild 2.4.2 on a Redhat 6 system and performed the steps in you technical manual

to unpack the files and libraries.

However on initial start, CMDBuild fails with error "PSQLException: ERROR: function _cm_class_list() does not exist"

I went into psql and ran

postgres=# CREATE LANGUAGE plpgsql;
ERROR:  language "plpgsql" already exists

Is 9.6 to recent of a release for cmdbuild 2.4.2?

I got the same error on 8.4, and so upgraded to the latest postgres release 9.6, but the error persists.

Any ideas on what I need to do to work around this error?

We are trying to demo CMDBuild to management asap to see if it will work as our CMDB.

Kind Regards,

Daniel Gutierrez

Sr. Developer

Walmartlabs