SQL Server Problems

[andrewr]

This is using Alfresco 2.9B

I've followed the instructions here: http://forums.alfresco.com/viewtopic.php?t=7300
To set up SQL server 2005 access for Alfresco, as well as creating a DB, user and password.

Running Alfresco now gives me the following (abreviated!) errors:

11:14:21,828 WARN  [org.springframework.remoting.rmi.RmiRegistryFactoryBean] Could not detect RMI registry - creating new one
11:14:32,890 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema managed by database dialect org.alfresco.repo.domain.hibernate.dialect.AlfrescoSQLServerDialect.
11:15:32,906 ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema auto-update failed
org.alfresco.error.AlfrescoRuntimeException: A previous schema upgrade failed.  Revert to the original database before attempting the upgrade again.
..
11:15:33,078 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: Schema auto-update failed
..
Caused by: org.alfresco.error.AlfrescoRuntimeException: A previous schema upgrade failed.  Revert to the original database before attempting the upgrade again.
..
11:15:33,265 ERROR [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/alfresco]] Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener
org.alfresco.error.AlfrescoRuntimeException: Schema auto-update failed
..
Caused by: org.alfresco.error.AlfrescoRuntimeException: A previous schema upgrade failed.  Revert to the original database before attempting the upgrade again.
..
11:15:33,453 ERROR [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/alfresco]] Exception sending context initialized event to listener instance of class org.alfresco.web.app.ContextListener
org.alfresco.error.AlfrescoRuntimeException: Schema auto-update failed
..
Caused by: org.alfresco.error.AlfrescoRuntimeException: A previous schema upgrade failed.  Revert to the original database before attempting the upgrade again.
..

Any clues as to what it's doing/failing on? It's a clean blank database, why's it trying to upgrade?

[mikeh]

HI

See if there's an alf_bootstrap_lock table that may have been left behind - this can happen on a failed start or shutdown. You can drop that table if it exists and try again.

Thanks,
Mike

[corridor]

I had the same issue when I checked the server today. I stopped the server, dropped the table, then restarted and the issue had cleared. Thanks for the answer.

[andrewr]

Unfortunately for me it doesn't write anything to the database, it's completely blank still!

[andy]

Hi

Can you let us know what is written to the console at start up?

Andy