topic Alfresco, Hibernate, and ORA-01795 on Production in Alfresco Archive

Alfresco, Hibernate, and ORA-01795 on Production

jack_jin — Wed, 10 Jun 2009 23:00:51 GMT

Hello,We are currently using alfresco 3.0c running on a dedicated linux server. As we load more content with alfresco's wcm system, we encountered an error didn't exist before. While using alfresco's native UI, we now encounter an error doing the following:1) Login to alfresco as admin (admin is a

Re: Alfresco, Hibernate, and ORA-01795 on Production

jack_jin — Thu, 11 Jun 2009 14:44:29 GMT

Also, would upgrading to Alfresco 3.1 would fix this?

Re: Alfresco, Hibernate, and ORA-01795 on Production

jack_jin — Mon, 15 Jun 2009 16:17:25 GMT

Our site went live with the issue unfixed. Any help would be greatly appreciated.

Re: Alfresco, Hibernate, and ORA-01795 on Production

jack_jin — Wed, 01 Jul 2009 19:11:55 GMT

Re: Alfresco, Hibernate, and ORA-01795 on Production

zaizi — Fri, 03 Jul 2009 04:47:38 GMT

By trying to expand modified items in a heavily used sandbox, we have to wait 20 minutes ish, then we get the transaction is rolling back error.

Can you qualify how heavily the sandbox is used?

Did you just trying running your site on Enterprise 3.1?

Re: Alfresco, Hibernate, and ORA-01795 on Production

tommorris — Fri, 03 Jul 2009 14:13:32 GMT

Hi there,

We're experiencing similar problems. The more files you have in the modified-items list, the slower it gets. It gets even slower when those items have been submitted to a workflow that is 'in-flight'. Or, more accurately, the greater the number of *separate* workflows instances.

The problem is exacerbated with certain hardware, I believe.

We have an open JIRA request for engineers to look into this.

Tom

Re: Alfresco, Hibernate, and ORA-01795 on Production

whybish — Wed, 08 Jul 2009 21:10:38 GMT

Even if there were less than 1000 anonymous parameters that sql would still perform poorly. The IN clause is slow because it cannot use indexes effectively. Rather than finding all process instances with given ids, this stuff would need to be refactored to be looking at some flag on process instance.

Re: Alfresco, Hibernate, and ORA-01795 on Production

jack_jin — Wed, 29 Jul 2009 20:55:41 GMT

By trying to expand modified items in a heavily used sandbox, we have to wait 20 minutes ish, then we get the transaction is rolling back error.

Can you qualify how heavily the sandbox is used?

Did you just trying running your site on Enterprise 3.1?

Sorry for the late reply to the thread.

The sandbox is around 1500 versions and has about 200-300 files. The problem still exist on production today.

After doing two more projects on alfresco 3.1, Alfresco 3.1 doesn't seem to have this issue. The queries in Alfresco 3.1 seems to be more efficient when it comes to fetching a list of modified items.

I wonder if there's a way to patch it for 3.0, since Alfresco doesn't release oracle scripts to update alfresco 3.0 to 3.1.

Re: Alfresco, Hibernate, and ORA-01795 on Production

fracat71 — Fri, 28 May 2010 18:32:16 GMT

Hi all,
here a possible solution:
http://forums.alfresco.com/en/viewtopic.php?f=14&t=26355&p=88594#p88594

Regards