Hi, I have the same problem; I'm trying to do a full export-import from Alfresco 2.9b to Alfresco Labs 3.
(A clean installation of Alfresco Labs 3 works fine on Win2003 and Scientific Linux 5.2 both)
Scenario:
OS:Windows Server 2003 Enterprise
DB
ostgreSQL 8.2.5
First of all, I've tried to perform a full import-export via .acp files (it worked quite well from 2.1 to 2.9: I've used it repeatedly to test our production environment on local machines) . Now I've got just the same error reported in the post above (The error happens on Win2003 and Scientific Linux 5.2 both).
Last, I've tried to perform a canonical backup/restore via db backup/restore and alf_data backup/restore (they are synchronized, due to a scheduled backup every night). This method worked quite well with previous versions, too.
I've set db.upgrade=false in /alfresco/extension/custom.repository.properties, otherwise I get the following error
I don't worry about this, since setting db.upgrade=false solves.
But now this is the big error:
I look at the forum and it seems to be related to PostgreSQL . Could you help me?
Thanks
(A clean installation of Alfresco Labs 3 works fine on Win2003 and Scientific Linux 5.2 both)
Scenario:
OS:Windows Server 2003 Enterprise
DB
ostgreSQL 8.2.5First of all, I've tried to perform a full import-export via .acp files (it worked quite well from 2.1 to 2.9: I've used it repeatedly to test our production environment on local machines) . Now I've got just the same error reported in the post above (The error happens on Win2003 and Scientific Linux 5.2 both).
Last, I've tried to perform a canonical backup/restore via db backup/restore and alf_data backup/restore (they are synchronized, due to a scheduled backup every night). This method worked quite well with previous versions, too.
I've set db.upgrade=false in /alfresco/extension/custom.repository.properties, otherwise I get the following error
ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema auto-update failed
org.alfresco.error.AlfrescoRuntimeException: The schema script could not be found at location classpath:alfresco/dbscripts/upgrade/2.2/${db.script.dialect}/AlfrescoSchemaUpdate-2.2-ACL.sql I don't worry about this, since setting db.upgrade=false solves.
But now this is the big error:
12:09:16,203 INFO [org.alfresco.web.site.FrameworkHelper] Successfully Initialized Web Framework
12:11:59,750 INFO [org.alfresco.config.xml.XMLConfigService$PropertyConfigurer] Loading properties file from class path resource [alfresco/file-servers.properties]
12:12:07,531 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.PostgreSQLDialect.
12:12:07,546 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] Bypassing schema update checks.
12:12:19,593 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.hibernate.exception.SQLGrammarException: could not load an entity: [org.alfresco.repo.avm.IssuerIDImpl#node]
…..lots of at org. ….
Caused by: org.postgresql.util.PSQLException: ERROR: relation "avm_issuer_ids" does not exist
3-nov-2008 12.12.19 org.apache.catalina.core.StandardContext start
GRAVE: Error listenerStart
3-nov-2008 12.12.19 org.apache.catalina.core.StandardContext start
GRAVE: Context [/alfresco] startup failed due to previous errors
log4j:ERROR LogMananger.repositorySelector was null likely due to error in class reloading, using NOPLoggerRepository.
3-nov-2008 12.12.21 org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive share.war
12:12:23,250 INFO [web.site.FrameworkHelper] Successfully Initialized Web Framework
3-nov-2008 12.12.29 org.apache.coyote.http11.Http11BaseProtocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
3-nov-2008 12.12.29 org.apache.catalina.storeconfig.StoreLoader load
INFO: Find registry server-registry.xml at classpath resource
3-nov-2008 12.12.29 org.apache.catalina.startup.Catalina start
INFO: Server startup in 45062 ms
I look at the forum and it seems to be related to PostgreSQL . Could you help me?
Thanks
