topic Re: admin and hibernate problem in Alfresco Archive

admin and hibernate problem

shay — Tue, 29 May 2007 13:12:06 GMT

Hi,I tried to build a new tree in the alfresco using the java APIs, starting with a new root space and adding some new sub trees recursively. after about 50 cycles i got the following exception:java.lang.NoSuchMethodError: java.lang.Object.getHibernateLazyInitializer()Lorg/hibernate/proxy/LazyInitia

Re: admin and hibernate problem

frederick — Tue, 29 May 2007 13:56:06 GMT

I'm afraid I can't help you on the hibernate issue, but to restore your admin account you could try the following:

Assumptions:
- There is no other admin account available
- You have full access to the Alfresco db schema

1. Obtain the nodereference of a valid space (eg. company home)
You can do this by logging in with another user account that can access company home.

2. Look up your account's username row in the 'alf_node_properties' table. It should look something like this:

714, 'STRING', b'0', 'STRING', b'0', 0, 0, 0, 'myAccountName', '', '{http://www.alfresco.org/model/content/1.0}userName'

3. Use this id (714 in this example) to look up the row in the 'alf_node_properties' table that contains the homeFolder for your admin account. It looks something like this:

714, 'NODEREF', b'0', 'STRING', b'0', 0, 0, 0, 'workspace://SpacesStore/a9c268ee-0dc9-11dc-90f6-dd72221b1cb4', '', '{http://www.alfresco.org/model/content/1.0}homeFolder'

4. Execute an update statement on this row:

update 'alf_node_properties' set string_value = 'newHomeRef' where node_id = 714 and qname = '{http://www.alfresco.org/model/content/1.0}homeFolder'

Replacing newHomeRef with the reference of the valid space, and 714 with the id that corresponds to your node in the db.

5. Restart alfresco
Now your homefolder should have changed to the valid space (eg. company home).

Good luck!

Re: admin and hibernate problem

shay — Tue, 29 May 2007 15:16:48 GMT

thank you Frederick, that was very helpful and solved the admin problem

i'm still looking for an answer about the hibernate issue :?

about the delete issue…when i tries to delete a space (via the web client) i get the following error in the log file:

17:41:06,173 ERROR [org.alfresco.web.ui.common.Utils] Unable to delete Space due to system error:
java.lang.OutOfMemoryError: Java heap space

how can i change the heap size?… this space size is about 100MB and in the future we'll have even bigger spaces (above 1G) is there any other solution to this problem? (the user tries to delete a root space which is above 1G via the web client)

Re: admin and hibernate problem

frederick — Tue, 29 May 2007 20:20:23 GMT

If you installed Alfresco out of the box, the heap config is in alfresco.bat (or alfresco.sh I assume):

set JAVA_OPTS=-Xms256m -Xmx512m -Xss2048k -server‍

Xms is initial heap size, Xmx is maximum heap size, Xss is stack size per thread.

If you do not use the alfresco batch or shell script, you must add these parameters to the place where java.exe is called (for tomcat in windows this is bin/catalina.bat).

Regards,

Re: admin and hibernate problem

kevinr — Wed, 30 May 2007 09:59:00 GMT

The -server switch is a workaround for the hibernate issue - if you are setting the bigger heap size, set this switch also.

Thanks,

Kevin