admin and hibernate problem

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

shay

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/LazyInitializer;

i've found this link on the net:
http://forums.alfresco.com/viewtopic.php?t=3148
which suggest to replace the hibenate jar, so i replaced the hibenate jar in my application (not in the alfresco web client) from hibernate-3.2.1.jar to hibernate3.jar and the problem solved, BUT…

When i tried to delete my new root space (which i created, not the company home)  via the alfresco web application, i got an exception and i had to restart the alfresco again.
after the 3 attempt i could not log in as admin and i got the following message:

The Home Space node referenced by Id: c114aa26-0db9-11dc-aa80-2fede2568e21 cannot be found. It may have been deleted from the database. Please contact your system administrator.

we use alfresco 2.0.0 and sdk-2.0.0 on linux


can you advice about:
how can i fix the admin problem? (can i recreate it? i tried to rebuild the indexs with index.recovery.mode=FULL but no luck)
which hibernate jar should i use with my application and which hibernate jar should i use with the alfresco web client?

this subject is very crucial and urgent to us since all of our content is in the alfresco and we cant reach it.

Thanks in advance,
Shay.

frederick

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!