topic Re: Fresh install on W2K3/MSSQL 2K - 'Schema auto-update failed' in Alfresco Archive

Fresh install on W2K3/MSSQL 2K - 'Schema auto-update failed'

ejholmgren — Fri, 22 Aug 2008 16:47:09 GMT

I am getting the following error with a fresh Alfresco Community 2.9.0B install on W2K3 and MSSQL 2K …11:21:29,687 ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema auto-update failedorg.alfresco.error.AlfrescoRuntimeException: A previous schema upgrade failed. Revert to the original d

Re: Fresh install on W2K3/MSSQL 2K - 'Schema auto-update failed'

pranjesh — Sat, 23 Aug 2008 22:56:01 GMT

I am in a similar situation…except that the database is Oracle…

Re: Fresh install on W2K3/MSSQL 2K - 'Schema auto-update failed'

shoshin — Thu, 16 Oct 2008 09:16:59 GMT

This seems to alfresco user doesn't have adequate rights.
If you change it to database root password it is working properly.

Cheers!
Shoshin

Re: Fresh install on W2K3/MSSQL 2K - 'Schema auto-update failed'

shoshin — Thu, 16 Oct 2008 09:40:14 GMT

Please do also refer this following post.If your error falls under this category.
http://forums.alfresco.com/en/viewtopic.php?t=5369

Cheers!
Shoshin

Re: Fresh install on W2K3/MSSQL 2K - 'Schema auto-update failed'

norgan — Thu, 16 Oct 2008 12:26:59 GMT

Hi there,
I solved the problem by deleting the data folder and database and letting Alfresco redo the basic setup.

Regards, Norgan

Re: Fresh install on W2K3/MSSQL 2K - 'Schema auto-update failed'

shoshin — Mon, 20 Oct 2008 04:36:19 GMT

If the problem associates with Mysql can't read/write error you can try deleting the content from temp folder and do a restart.Usually it would be windows/temp directory. you can chk the mysql variables and figure out temp folder of yours.

Cheers!
Shoshin