Well the schema doesn't appear to be the problem anymore. I dug up an old post on the boards that suggested I drop the table alf_bootstrap_lock and that solved that problem. I am still getting an error though. I don't know if I have stated it before but I am using Alfresco 2.9B on a Windows 2003 server. I always use to start up alfresco by using a "start alfresco" command from the start menu. When I would click that a CLI window would open and Tomcat would start. This is where I fould the schema error before. Now the error that is appearing in the CLI window is:
"13:05:57,015 User
ystem ERROR [web.context.ContextLoader] Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'usageQuotaProtector' defined in class path resource [alfresco/usage-services-context.xml]: Invocation of init method failed; nexted exception is org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.Generic JDBCExpection: Cannot open connection
Caused by: org.springframwork.transaction.CannotCreateTransactionException:Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection
Caused by
rg.hibernate.exception.GenericJDBCException: Cannot open connection
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException <SQLStateConverter.java:103>"
and Then it just keep going with at least one hundred lines (when I hit pause it said 57 more lines) of lines similar to the "at" line at the end there.
To answer gavinc's questions, No, I don't think I have used nightly builds, but that is because I am not sure what they are. If they are new builds of alfresco made each night, then no. If they are something else, maybe. As for the other question, I think the problem was the alf_bootstrap_lock because after dropping it, the schema problem went away. Wether or not it went away because this error though is a different question. I just hope I didn't cause this new error by "fixing" the other one. Thanks for any help in advance.
"13:05:57,015 User
ystem ERROR [web.context.ContextLoader] Context initialization failedorg.springframework.beans.factory.BeanCreationException: Error creating bean with name 'usageQuotaProtector' defined in class path resource [alfresco/usage-services-context.xml]: Invocation of init method failed; nexted exception is org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.Generic JDBCExpection: Cannot open connection
Caused by: org.springframwork.transaction.CannotCreateTransactionException:Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection
Caused by
rg.hibernate.exception.GenericJDBCException: Cannot open connectionat org.hibernate.exception.SQLStateConverter.handledNonSpecificException <SQLStateConverter.java:103>"
and Then it just keep going with at least one hundred lines (when I hit pause it said 57 more lines) of lines similar to the "at" line at the end there.
To answer gavinc's questions, No, I don't think I have used nightly builds, but that is because I am not sure what they are. If they are new builds of alfresco made each night, then no. If they are something else, maybe. As for the other question, I think the problem was the alf_bootstrap_lock because after dropping it, the schema problem went away. Wether or not it went away because this error though is a different question. I just hope I didn't cause this new error by "fixing" the other one. Thanks for any help in advance.
