Error when loading 2.19 sample data

I am running my own instance of 2.19 and everything goes fine until I try to load in the sample data for that version. When I do I get this error:

Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception: (BasicResourcePool.java [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0])

web_1 | org.postgresql.util.PSQLException: The connection attempt failed.

web_1 | at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:233)

Everything went fine loading the data.

Has anyone seen this before? Do I need to adjust some hibernate setting?

Thanks,

Adam

You need to make sure the database name, database user name, and database password are correct in the hibernate.properties file.

Knut

···

On Wed, Sep 9, 2015 at 2:25 AM, Adam Preston adam704a@hotmail.com wrote:

I am running my own instance of 2.19 and everything goes fine until I try to load in the sample data for that version. When I do I get this error:

Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception: (BasicResourcePool.java [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0])

web_1 | org.postgresql.util.PSQLException: The connection attempt failed.

web_1 | at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:233)

Everything went fine loading the data.

Has anyone seen this before? Do I need to adjust some hibernate setting?

Thanks,

Adam


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org

Thanks I definitely had a problem with resolving my host in my hibernate.configuration file.

Last question, when I am using the sample data, do I need to specify a certain encryption password in the hibernate.configuration file. Reason I ask is that I am getting encryption errors like this one when I load in that sample data.

ERROR 2015-09-09 14:44:06,508 org.jasypt.exceptions.EncryptionOperationNotPossibleException

web_1 | at org.jasypt.encryption.pbe.StandardPBEByteEncryptor.decrypt(StandardPBEByteEncryptor.java:1055)

web_1 | at org.jasypt.encryption.pbe.StandardPBEStringEncryptor.decrypt(StandardPBEStringEncryptor.java:725)

web_1 | at org.jasypt.encryption.pbe.PooledPBEStringEncryptor.decrypt(PooledPBEStringEncryptor.java:498)

web_1 | at org.jasypt.hibernate4.type.AbstractEncryptedAsStringType.nullSafeGet(AbstractEncryptedAsStringType.java:143)

web_1 | at org.hibernate.type.CustomType.nullSafeGet(CustomType.java:127)

web_1 | at org.hibernate.type.AbstractType.hydrate(AbstractType.java:106)

web_1 | at org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:2903)

Thanks for your help.

Adam

···

From: knutst@gmail.com
Date: Wed, 9 Sep 2015 06:18:33 +0300
Subject: Re: [Dhis2-users] Error when loading 2.19 sample data
To: adam704a@hotmail.com
CC: dhis2-users@lists.launchpad.net

You need to make sure the database name, database user name, and database password are correct in the hibernate.properties file.

Knut

On Wed, Sep 9, 2015 at 2:25 AM, Adam Preston adam704a@hotmail.com wrote:

I am running my own instance of 2.19 and everything goes fine until I try to load in the sample data for that version. When I do I get this error:

Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception: (BasicResourcePool.java [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0])

web_1 | org.postgresql.util.PSQLException: The connection attempt failed.

web_1 | at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:233)

Everything went fine loading the data.

Has anyone seen this before? Do I need to adjust some hibernate setting?

Thanks,

Adam


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp


Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org

FYI - I got this to work by removing the encryption.password line from the hibernate.configuration file.