topic Continuous error in logs in Alfresco Archive

Continuous error in logs

yogeshpj — Sat, 27 Aug 2016 23:52:32 GMT

Hi All,I am getting following exception in my logs continuously.I have disabled the feed jobs but then also I am getting this error.Can anyone help on this ?2016-08-27 15:46:15,092 ERROR [post.lookup.PostLookup] [DefaultScheduler_Worker-10] Exception during update of posts: org.springframework.dao

Re: Continuous error in logs

romschn — Sun, 28 Aug 2016 07:00:01 GMT

One option you can try is to add a validation query for the database if it is already not there and see if that works or not.
The way it will help is, basically it will try to execute this validation query before the actual usage and ensures if the connection is available for use.
Hope this helps.

Re: Continuous error in logs

openpj — Thu, 22 Sep 2016 06:49:01 GMT

Try to check if your database server has enough number of connection instance to use for the connection pool dedicated to Alfresco.

Then check if your settings in the alfresco-global.properties fit well with your database, mainly db.pool.max.

Hope this helps.

Re: Continuous error in logs

kaynezhang — Thu, 22 Sep 2016 08:51:30 GMT

Maybe you also need to increase processes, sessions and transactions in oracle.
execute following commands in sqlplus

alter system set processes = 150 scope = spfile;
alter system set sessions = 300 scope = spfile;
alter system set transactions = 330 scope = spfile;