Alfresco 3.4 Community support for Microsoft SQL Server 2008

[smcardle]

Hi Everybody

I was recently asked by a client to get Alfresco Community 3.4.d  to run against a Microsoft SQL Server 2008 R2 database.

However, the Alfresco Community editions only support MySQL and PostgreSQL databases so I took a look at what needed to be done to achieve this. Anyway, after a couple of days I had everything running smoothly and without issue.

I would like to create an AMP to update the alfresco.war file to include this support but haven't had time to look at that yet, maybe it's not possible with an AMP!!!!

Anyway, to install the changes you currently need to explode or uncompress the alfresco.war file and then unzip the contents of the SQLServer2008R2.zip file in to the WEB-INF/classes directory.

Then configure your alfresco-global.properties file to use your SQL Server database (it's only been tested with the Open Source jtds-1.2.5.jar, so copy this to either your tomcat/lib or your <jboss>/<server>/lib directory)

Create an SQL Server DB
Create an Alfresco user with password and grant DBO to the user
Execute the query ALTER DATABASE alfresco SET ALLOW_SNAPSHOT_ISOLATION ON;
Configure alfresco-global.properties

An example of the DB setup for SQL Server in the alfresco-global.properties file:

## SQLServer connection# Requires jTDS driver version 1.2.5 and SNAPSHOT isolation mode# Enable TCP protocol on fixed port 1433# Prepare the database with:# ALTER DATABASE alfresco SET ALLOW_SNAPSHOT_ISOLATION ON; #db.driver=net.sourceforge.jtds.jdbc.Driverdb.url=jdbc:jtds:sqlserver://<server>:1433/alfrescodb.username=alfrescodb.password=alfrescodb.txn.isolation=4096hibernate.dialect=org.hibernate.dialect.SQLServerDialect‍‍‍‍‍‍‍‍‍‍‍‍‍‍

You can get the zip file from here
http://www.4shared.com/file/wCSXyag9/SQLServer2008R2.html


Just one more thing…..
In the org.hibernate.dialect.SQLServerDialect directory there is an extra file named EOSS-removeAllTables.sq;
This contains a set of queries that will enable you to remove all of the tables create in the database by Alfresco, including all of the constraints. You probably wont need it but It was incredibly handy as I was trying to get this to run so that I could start over each time, forcing Alfresco to recreate the required tables….


Regards

Steve

[jonvargas]

Thanks Steve!

Just one question, where do you get originally the maps and scripts? And where are they always available to latests versions? Were they created by yourself?

I wonder because we plan to make some tests against the latest Community build and we want to make sure there is integrity between code and database.

Thanks in advance.

[softbless]

Hi,

Thanks a lot for sharing, I've tried it, and it's working. I think it would be good if you put this on Alfresco Forge. There's similar project for Oracle on Alfresco Forge.

[softbless]

Hi,

I think you need to remove this file : "ibatis\node-update-acl-SqlMap.xml"

If it's not removed, it will give error when : deleting content, and load Record Management Test Data.

[saidone]

I would like to create an AMP to update the alfresco.war file to include this support but haven't had time to look at that yet, maybe it's not possible with an AMP!!!!

Here's the AMP for Alfresco 3.4.e, with some fixes on your original scripts (CMIS was completely broken due to truncation problems) and a special fix for Activiti http://ubuntuone.com/516SzZgw7qm262U0axkiSe
Thank you very much Steve,
I'll start working on an Alfresco 4 version ASAP.

saidone

[saidone]

Work on 4.0 Community is nearly completed. You can download a beta version here:
http://saidone.org/kugelmass/pages/alfresco-community-support-for-microsoft-sql-server-2008

[mankind1]

Re: Alfresco 3.4 Community support for Microsoft SQL Server
Hello  saidone how are you?
Thanks for all of your hard work and effort into this project.

I have been trying to get MS SQL Server to work with Alfresco Community edition 4.0 d for about week now on a Windows 7 box
but cant seem to get it right.
I followed all of your steps (including Install the correct AMP; AlfrescoSQLServer-0.2-b35.amp against my alfresco.war  and copying the jtds-1.2.5.jar to my c:\AlfrescoCom40d\tomcat\lib\ folder )
I even used the benchmarking tool you created for alfresco…http://www.saidone.org/kugelmass/posts/alfresco-cmis-benchmarking-tool but still ….no love from Alfresco for me.
Could you please take a look at my files and just give me some pointers?
I am not sure where else I should be tweaking to try and get this working.
Thanks in advance

My config for Alfresco-global-properties (c:\AlfrescoCom40d\toncat\shared\classes\alfresco-global.properties) is as follows:

################################# Common Alfresco Properties ###################################dir.root=C:/ALFRES~1/alf_datadir.root=C:/AlfrescoCom40d/alf_data_nwalfresco.context=alfrescoalfresco.host=127.0.0.1alfresco.port=8080alfresco.protocol=httpshare.context=shareshare.host=127.0.0.1share.port=8080share.protocol=http### database connection properties ######db.driver=org.postgresql.Driver###db.username=alfresco###db.password=!@#$%%$#@!###db.name=alfresco###db.url=jdbc:postgresql://localhost:5432/${db.name}db.name=Alfrescodb.username=Alfrescodb.password=alfrescodb.host=localdb.port=1433db.driver=net.sourceforge.jtds.jdbc.Driverdb.url=jdbc:jtds:sqlserver://local:1433/Alfrescodb.txn.isolation=4096hibernate.dialect=org.hibernate.dialect.SQLServerDialect### FTP Server Configuration ###ftp.enabled=trueftp.port=21ftp.ipv6.enabled=false### RMI service ports ###alfresco.rmi.services.port=50500avm.rmi.service.port=0avmsync.rmi.service.port=0attribute.rmi.service.port=0authentication.rmi.service.port=0repo.rmi.service.port=0action.rmi.service.port=0deployment.rmi.service.port=0### External executable locations ###ooo.exe=C:/AlfrescoCom40d/openoffice/App/openoffice/program/soffice.exeooo.enabled=trueooo.port=8100ooo.port=8100img.root=C:/AlfrescoCom40d/imagemagickimg.dyn=${img.root}/libimg.exe=${img.root}/convertswf.exe=C:/ALFRES~1/swftools/pdf2swf.exejodconverter.enabled=false jodconverter.officeHome=C:/AlfrescoCom40d/openoffice/App/openoffice jodconverter.portNumbers=8100 ### Initial admin password ###alfresco_user_store.adminpassword=49c502bf4232f699f50136406327b71e### E-mail site invitation setting ###notification.email.siteinvite=false### File Protocol Root ###protocols.rootPath=/${spaces.company_home.childname}/${spaces.sites.childname}### License location ###dir.license.external=C:/ALFRES~1### Solr indexing ###index.subsystem.name=solrdir.keystore=${dir.root}/keystoresolr.port.ssl=8443### BPM Engine ###system.workflow.engine.jbpm.enabled=false‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

I have included the text from my Alfresco.log file (c:\windows\system32)
for you to perhaps help me figure out where I am going wrong

My repository-properties (c:AlfrescoCom40d\tomcat\webapps\alfresco\WEB-INF\classes\alfresco\repository-properties)is as follows:

# Repository configurationrepository.name=Main Repository# Directory configurationdir.root=./alf_datadir.contentstore=${dir.root}/contentstoredir.contentstore.deleted=${dir.root}/contentstore.deleted# The location of cached contentdir.cachedcontent=${dir.root}/cachedcontentdir.auditcontentstore=${dir.root}/audit.contentstore# The location for lucene index filesdir.indexes=${dir.root}/lucene-indexes# The location for index backupsdir.indexes.backup=${dir.root}/backup-lucene-indexes# The location for lucene index locksdir.indexes.lock=${dir.indexes}/locks#Directory to find external licensedir.license.external=.# Spring resource location of external license fileslocation.license.external=file://${dir.license.external}/*.lic# Spring resource location of embedded license files    location.license.embedded=/WEB-INF/alfresco/license/*.lic# Spring resource location of license files on shared classpathlocation.license.shared=classpath*:/alfresco/extension/license/*.lic# WebDAV initialization propertiessystem.webdav.servlet.enabled=truesystem.webdav.storeName=${protocols.storeName}system.webdav.rootPath=${protocols.rootPath}# Is the JBPM Deploy Process Servlet enabled?# Default is false. Should not be enabled in production environments as the# servlet allows unauthenticated deployment of new workflows.system.workflow.deployservlet.enabled=false# Sets the location for the JBPM Configuration Filesystem.workflow.jbpm.config.location=classpath:org/alfresco/repo/workflow/jbpm/jbpm.cfg.xml # Determines if JBPM workflow definitions are shown.# Default is false. This controls the visibility of JBPM # workflow definitions from the getDefinitions and # getAllDefinitions WorkflowService API but still allows # any in-flight JBPM workflows to be completed.system.workflow.engine.jbpm.definitions.visible=false#Determines if Activiti definitions are visiblesystem.workflow.engine.activiti.definitions.visible=true# Determines if the JBPM engine is enabledsystem.workflow.engine.jbpm.enabled=true# Determines if the Activiti engine is enabledsystem.workflow.engine.activiti.enabled=trueindex.subsystem.name=lucene# ######################################### ## Index Recovery and Tracking Configuration ## ######################################### ### Recovery types are:#    NONE:     Ignore#    VALIDATE: Checks that the first and last transaction for each store is represented in the indexes#    AUTO:     Validates and auto-recovers if validation fails#    FULL:     Full index rebuild, processing all transactions in order.  The server is temporarily suspended.index.recovery.mode=VALIDATE# FULL recovery continues when encountering errorsindex.recovery.stopOnError=falseindex.recovery.maximumPoolSize=5# Set the frequency with which the index tracking is triggered.# For more information on index tracking in a cluster:#    http://wiki.alfresco.com/wiki/High_Availability_Configuration_V1.4_to_V2.1#Version_1.4.5.2C_2.1.1_an...# By default, this is effectively never, but can be modified as required.#    Examples:#       Never:                   * * * * * ? 2099#       Once every five seconds: 0/5 * * * * ?#       Once every two seconds : 0/2 * * * * ?#       See http://www.quartz-scheduler.org/docs/tutorials/crontrigger.htmlindex.tracking.cronExpression=0/5 * * * * ?index.tracking.adm.cronExpression=${index.tracking.cronExpression}index.tracking.avm.cronExpression=${index.tracking.cronExpression}# Other properties.index.tracking.maxTxnDurationMinutes=10index.tracking.reindexLagMs=1000index.tracking.maxRecordSetSize=1000index.tracking.maxTransactionsPerLuceneCommit=100index.tracking.disableInTransactionIndexing=false# Index tracking information of a certain age is cleaned out by a scheduled job.# Any clustered system that has been offline for longer than this period will need to be seeded# with a more recent backup of the Lucene indexes or the indexes will have to be fully rebuilt.# Use -1 to disable purging.  This can be switched on at any stage.index.tracking.minRecordPurgeAgeDays=30# Reindexing of missing content is by default 'never' carried out.# The cron expression below can be changed to control the timing of this reindexing.# Users of Enterprise Alfresco can configure this cron expression via JMX without a server restart.# Note that if alfresco.cluster.name is not set, then reindexing will not occur.index.reindexMissingContent.cronExpression=* * * * * ? 2099# Change the failure behaviour of the configuration checkersystem.bootstrap.config_check.strict=true# The name of the cluster#   Leave this empty to disable cluster entryalfresco.cluster.name=# The EHCache RMI peer URL addresses to set in the ehcache-custom.xml file#   Use this property to set the hostname of the current server.#   This is only necessary if the cache peer URLs are generated with an invalid IP address for the local server.alfresco.ehcache.rmi.hostname=#   Use this property to set the cache peer URL port.alfresco.ehcache.rmi.remoteObjectPort=0alfresco.ehcache.rmi.port=0alfresco.ehcache.rmi.socketTimeoutMillis=5000# The protocol stack to use from the JGroups configuration file#   Use this property to select which communication method should be used.#   The JGroups configuration file is build up using the protocol stringalfresco.jgroups.defaultProtocol=UDP# The bind address and interface for JGroups to use; equivalent to -Djgroups.bind_addr and -Djgroups.bind_interfacealfresco.jgroups.bind_address=alfresco.jgroups.bind_interface=# JGroups configuration (http://www.jgroups.org)# The location of the JGroups configuration filealfresco.jgroups.configLocation=classpath:alfresco/jgroups/alfresco-jgroups-${alfresco.jgroups.defaultProtocol}.xml## How long should shutdown wait to complete normally before # taking stronger action and calling System.exit()# in ms, 10,000 is 10 seconds#shutdown.backstop.timeout=10000shutdown.backstop.enabled=false# Server Single User Mode# note:#   only allow named user (note: if blank or not set then will allow all users)#   assuming maxusers is not set to 0#server.singleuseronly.name=admin# Server Max Users - limit number of users with non-expired tickets# note: #   -1 allows any number of users, assuming not in single-user mode#   0 prevents further logins, including the ability to enter single-user modeserver.maxusers=-1# The Cron expression controlling the frequency with which the OpenOffice connection is testedopenOffice.test.cronExpression=0 * * * * ?## Disable all shared caches (mutable and immutable)#    These properties are used for diagnostic purposessystem.cache.disableMutableSharedCaches=falsesystem.cache.disableImmutableSharedCaches=false## Properties to limit resources spent on individual searches## The maximum time spent pruning resultssystem.acl.maxPermissionCheckTimeMillis=10000# The maximum number of search results to perform permission checks againstsystem.acl.maxPermissionChecks=1000# The maximum number of filefolder list resultssystem.filefolderservice.defaultListMaxResults=5000# Properties to control read permission evaluation for acegisystem.readpermissions.optimise=truesystem.readpermissions.bulkfetchsize=1000## Manually control how the system handles maximum string lengths.# Any zero or negative value is ignored.# Only change this after consulting support or reading the appropriate Javadocs for# org.alfresco.repo.domain.schema.SchemaBootstrap for V2.1.2system.maximumStringLength=-1## Limit hibernate session size by trying to amalgamate events for the L2 session invalidation# - hibernate works as is up to this size # - after the limit is hit events that can be grouped invalidate the L2 cache by type and not instance# events may not group if there are post action listener registered (this is not the case with the default distribution)system.hibernateMaxExecutions=20000## Determine if modification timestamp propagation from child to parent nodes is respected or not.# Even if 'true', the functionality is only supported for child associations that declare the# 'propagateTimestamps' element in the dictionary definition.system.enableTimestampPropagation=true## Decide if content should be removed from the system immediately after being orphaned.# Do not change this unless you have examined the impact it has on your backup procedures.system.content.eagerOrphanCleanup=false# The number of days to keep orphaned content in the content stores.#    This has no effect on the 'deleted' content stores, which are not automatically emptied.system.content.orphanProtectDays=14# The action to take when a store or stores fails to delete orphaned content#    IGNORE: Just log a warning.  The binary remains and the record is expunged#    KEEP_URL: Log a warning and create a URL entry with orphan time 0.  It won't be processed or removed.system.content.deletionFailureAction=IGNORE# The CRON expression to trigger the deletion of resources associated with orphaned content.system.content.orphanCleanup.cronExpression=0 0 4 * * ?# The CRON expression to trigger content URL conversion.  This process is not intesive and can#    be triggered on a live system.  Similarly, it can be triggered using JMX on a dedicated machine.system.content.contentUrlConverter.cronExpression=* * * * * ? 2099system.content.contentUrlConverter.threadCount=2system.content.contentUrlConverter.batchSize=500system.content.contentUrlConverter.runAsScheduledJob=false# #################### ## Lucene configuration ## #################### ### Millisecond threshold for text transformations# Slower transformers will force the text extraction to be asynchronous#lucene.maxAtomicTransformationTime=20## The maximum number of clauses that are allowed in a lucene query #lucene.query.maxClauses=10000## The size of the queue of nodes waiting for index# Events are generated as nodes are changed, this is the maximum size of the queue used to coalesce event# When this size is reached the lists of nodes will be indexed## http://issues.alfresco.com/browse/AR-1280:  Setting this high is the workaround as of 1.4.3. #lucene.indexer.batchSize=1000000fts.indexer.batchSize=1000## Index cache sizes#lucene.indexer.cacheEnabled=truelucene.indexer.maxDocIdCacheSize=100000lucene.indexer.maxDocumentCacheSize=100lucene.indexer.maxIsCategoryCacheSize=-1lucene.indexer.maxLinkAspectCacheSize=10000lucene.indexer.maxParentCacheSize=100000lucene.indexer.maxPathCacheSize=100000lucene.indexer.maxTypeCacheSize=10000## Properties for merge (not this does not affect the final index segment which will be optimised) # Max merge docs only applies to the merge process not the resulting index which will be optimised.#lucene.indexer.mergerMaxMergeDocs=1000000lucene.indexer.mergerMergeFactor=5lucene.indexer.mergerMaxBufferedDocs=-1lucene.indexer.mergerRamBufferSizeMb=16## Properties for delta indexes (not this does not affect the final index segment which will be optimised) # Max merge docs only applies to the index building process not the resulting index which will be optimised.#lucene.indexer.writerMaxMergeDocs=1000000lucene.indexer.writerMergeFactor=5lucene.indexer.writerMaxBufferedDocs=-1lucene.indexer.writerRamBufferSizeMb=16## Target number of indexes and deltas in the overall index and what index size to merge in memory#lucene.indexer.mergerTargetIndexCount=8lucene.indexer.mergerTargetOverlayCount=5lucene.indexer.mergerTargetOverlaysBlockingFactor=2lucene.indexer.maxDocsForInMemoryMerge=60000lucene.indexer.maxRamInMbForInMemoryMerge=16lucene.indexer.maxDocsForInMemoryIndex=60000lucene.indexer.maxRamInMbForInMemoryIndex=16## Other lucene properties#lucene.indexer.termIndexInterval=128lucene.indexer.useNioMemoryMapping=true# over-ride to false for pre 3.0 behaviourlucene.indexer.postSortDateTime=truelucene.indexer.defaultMLIndexAnalysisMode=EXACT_LANGUAGE_AND_ALLlucene.indexer.defaultMLSearchAnalysisMode=EXACT_LANGUAGE_AND_ALL## The number of terms from a document that will be indexed#lucene.indexer.maxFieldLength=10000# Should we use a 'fair' locking policy, giving queue-like access behaviour to# the indexes and avoiding starvation of waiting writers? Set to false on old# JVMs where this appears to cause deadlocklucene.indexer.fairLocking=true## Index locks (mostly deprecated and will be tidied up with the next lucene upgrade)#lucene.write.lock.timeout=10000lucene.commit.lock.timeout=100000lucene.lock.poll.interval=100lucene.indexer.useInMemorySort=truelucene.indexer.maxRawResultSetSizeForInMemorySort=1000lucene.indexer.contentIndexingEnabled=trueindex.backup.cronExpression=0 0 3 * * ?lucene.defaultAnalyserResourceBundleName=alfresco/model/dataTypeAnalyzers# When transforming archive files (.zip etc) into text representations (such as#  for full text indexing), should the files within the archive be processed too?# If enabled, transformation takes longer, but searches of the files find more.transformer.Archive.includeContents=false# Database configurationdb.schema.stopAfterSchemaBootstrap=falsedb.schema.update=truedb.schema.update.lockRetryCount=24db.schema.update.lockRetryWaitSeconds=5db.driver=org.gjt.mm.mysql.Driverdb.name=Afrescodb.url=jdbc:jtds:sqlserver://local:1433/Alfrescodb.username=Alfrescodb.password=alfrescodb.pool.initial=10db.pool.max=40db.txn.isolation=-1db.pool.statements.enable=truedb.pool.statements.max=40db.pool.min=0db.pool.idle=-1db.pool.wait.max=-1db.pool.validate.query=select 1db.pool.evict.interval=-1db.pool.evict.idle.min=1800000db.pool.validate.borrow=truedb.pool.validate.return=falsedb.pool.evict.validate=false#db.pool.abandoned.detect=falsedb.pool.abandoned.time=300## db.pool.abandoned.log=true (logAbandoned) adds overhead (http://commons.apache.org/dbcp/configuration.html)# and also requires db.pool.abandoned.detect=true (removeAbandoned)#db.pool.abandoned.log=false# Audit configurationaudit.enabled=trueaudit.tagging.enabled=trueaudit.alfresco-access.enabled=falseaudit.alfresco-access.sub-events.enabled=falseaudit.cmischangelog.enabled=falseaudit.dod5015.enabled=false# Setting this flag to true will force startup failure when invalid audit configurations are detectedaudit.config.strict=false# Audit map filter for AccessAuditor - restricts recorded events to user driven events audit.filter.alfresco-access.default.enabled=trueaudit.filter.alfresco-access.transaction.user=~System;~null;.*audit.filter.alfresco-access.transaction.type=cm:folder;cm:content;st:siteaudit.filter.alfresco-access.transaction.path=~/sys:archivedItem;~/ver:;.*# System Configurationsystem.store=system://systemsystem.descriptor.childname=sys:descriptorsystem.descriptor.current.childname=sys:descriptor-current# User configalfresco_user_store.store=user://alfrescoUserStorealfresco_user_store.system_container.childname=sys:systemalfresco_user_store.user_container.childname=sys:people# note: default admin username - should not be changed after installationalfresco_user_store.adminusername=admin# Initial password - editing this will not have any effect once the repository is installedalfresco_user_store.adminpassword=209c6174da490caeb422f3fa5a7ae634# note: default guest username - should not be changed after installationalfresco_user_store.guestusername=guest# Used to move home folders to a new locationhome_folder_provider_synchronizer.enabled=falsehome_folder_provider_synchronizer.override_provider=home_folder_provider_synchronizer.keep_empty_parents=false# Spaces Archive Configurationspaces.archive.store=archive://SpacesStore# Spaces Configurationspaces.store=workspace://SpacesStorespaces.company_home.childname=app:company_homespaces.guest_home.childname=app:guest_homespaces.dictionary.childname=app:dictionaryspaces.templates.childname=app:space_templatesspaces.imapConfig.childname=app:imap_configsspaces.imap_templates.childname=app:imap_templatesspaces.scheduled_actions.childname=cm:Scheduled Actionsspaces.emailActions.childname=app:email_actionsspaces.searchAction.childname=cm:searchspaces.templates.content.childname=app:content_templatesspaces.templates.email.childname=app:email_templatesspaces.templates.email.invite1.childname=app:invite_email_templatesspaces.templates.email.notify.childname=app:notify_email_templatesspaces.templates.email.following.childname=app:followingspaces.templates.rss.childname=app:rss_templatesspaces.savedsearches.childname=app:saved_searchesspaces.scripts.childname=app:scriptsspaces.wcm.childname=app:wcmspaces.wcm_content_forms.childname=app:wcm_formsspaces.content_forms.childname=app:formsspaces.user_homes.childname=app:user_homesspaces.user_homes.regex.key=userNamespaces.user_homes.regex.pattern=spaces.user_homes.regex.group_order=spaces.sites.childname=st:sitesspaces.templates.email.invite.childname=cm:invitespaces.templates.email.activities.childname=cm:activitiesspaces.rendition.rendering_actions.childname=app:rendering_actionsspaces.replication.replication_actions.childname=app:replication_actionsspaces.wcm_deployed.childname=cm:wcm_deployedspaces.transfers.childname=app:transfersspaces.transfer_groups.childname=app:transfer_groupsspaces.transfer_temp.childname=app:tempspaces.inbound_transfer_records.childname=app:inbound_transfer_recordsspaces.webscripts.childname=cm:webscriptsspaces.extension_webscripts.childname=cm:extensionwebscriptsspaces.models.childname=app:modelsspaces.workflow.definitions.childname=app:workflow_defsspaces.publishing.root.childname=app:publishing_rootspaces.templates.email.workflowemailnotification.childname=cm:workflownotificationspaces.nodetemplates.childname=app:node_templates# ADM VersionStore Configurationversion.store.enableAutoVersioning=trueversion.store.deprecated.lightWeightVersionStore=workspace://lightWeightVersionStoreversion.store.version2Store=workspace://version2Storeversion.store.migrateVersionStore.threadCount=3version.store.migrateVersionStore.batchSize=1version.store.migrateCleanupJob.threadCount=3version.store.migrateCleanupJob.batchSize=1# WARNING: For non-production testing only !!! Do not change (to avoid version store issues, including possible mismatch). Should be false since lightWeightVersionStore is deprecated.version.store.onlyUseDeprecatedV1=false# The CRON expression to trigger migration of the version store from V1 (2.x) to V2 (3.x)# By default, this is effectively 'never' but can be modified as required.#    Examples:#       Never:                     * * * * * ? 2099#       Once every thirty minutes: 0 0/30 * * * ?#       See http://www.quartz-scheduler.org/docs/tutorials/crontrigger.htmlversion.store.migrateVersionStore.cronExpression=* * * * * ? 2099# Limit number of version histories to migrate per job cycle, where -1 = unlimited. Note: if limit > 0 then need to schedule job to run regularly in order to complete the migration.version.store.migrateVersionStore.limitPerJobCycle=-1version.store.migrateVersionStore.runAsScheduledJob=false# Folders for storing peoplesystem.system_container.childname=sys:systemsystem.people_container.childname=sys:peoplesystem.authorities_container.childname=sys:authoritiessystem.zones_container.childname=sys:zones# Folders for storing workflow related infosystem.workflow_container.childname=sys:workflow# Are user names case sensitive?user.name.caseSensitive=falsedomain.name.caseSensitive=falsedomain.separator=# AVM Specific properties.avm.remote.idlestream.timeout=30000#Format caption extracted from the XML Schema.xforms.formatCaption=true# ECM content usages/quotassystem.usages.enabled=falsesystem.usages.clearBatchSize=50system.usages.updateBatchSize=50# Repository endpoint - used by Activity Servicerepo.remote.url=http://localhost:8080/alfrescorepo.remote.endpoint=/service# Create home folders as people are created (true) or create them lazily (false)home.folder.creation.eager=true# Should we consider zero byte content to be the same as no content when firing# content update policies? Prevents 'premature' firing of inbound content rules# for some clients such as Mac OS X Finderpolicy.content.update.ignoreEmpty=false# The well known RMI registry port and external host name published in the stubs# is defined in the alfresco-shared.properties file## alfresco.rmi.services.port=50500# Default value of alfresco.rmi.services.host is 0.0.0.0 which means 'listen on all adapters'.# This allows connections to JMX both remotely and locally.#alfresco.rmi.services.host=0.0.0.0# If the RMI address is in-use, how many retries should be done before aborting# Default value of alfresco.rmi.services.retries is 0 which means 'Don't retry if the address is in-use'alfresco.rmi.services.retries=4# RMI service ports for the individual services.# These eight services are available remotely.## Assign individual ports for each service for best performance # or run several services on the same port, you can even run everything on 50500 if # running through a firewall.## Specify 0 to use a random unused port.# avm.rmi.service.port=50501avmsync.rmi.service.port=50502authentication.rmi.service.port=50504repo.rmi.service.port=50505action.rmi.service.port=50506deployment.rmi.service.port=50507monitor.rmi.service.port=50508# Should the Mbean server bind to an existing  server.   Set to true for most application servers.# false for WebSphere clusters.mbean.server.locateExistingServerIfPossible=true# External executable locationsooo.exe=sofficeooo.user=${dir.root}/oouserimg.root=./ImageMagickimg.dyn=${img.root}/libimg.exe=${img.root}/bin/convertswf.exe=./bin/pdf2swf# Thumbnail Servicesystem.thumbnail.generate=true# Generate doclib icons# When creating a doclib icon, only use the first pageLimit pages (currently only understood by pdfbox# TextToPdfContentTransformer)system.thumbnail.definition.doclib.timeoutMs=-1system.thumbnail.definition.doclib.readLimitTimeMs=-1system.thumbnail.definition.doclib.maxSourceSizeKBytes=-1system.thumbnail.definition.doclib.readLimitKBytes=-1system.thumbnail.definition.doclib.pageLimit=1system.thumbnail.definition.doclib.maxPages=-1# Max mimetype sizes to create thumbnail iconssystem.thumbnail.mimetype.maxSourceSizeKBytes.pdf=-1system.thumbnail.mimetype.maxSourceSizeKBytes.txt=-1system.thumbnail.mimetype.maxSourceSizeKBytes.docx=-1system.thumbnail.mimetype.maxSourceSizeKBytes.xlsx=-1system.thumbnail.mimetype.maxSourceSizeKBytes.pptx=-1system.thumbnail.mimetype.maxSourceSizeKBytes.odt=-1system.thumbnail.mimetype.maxSourceSizeKBytes.ods=-1system.thumbnail.mimetype.maxSourceSizeKBytes.odp=-1# Configuration for handling of failing thumbnails.# See NodeEligibleForRethumbnailingEvaluator's javadoc for details.## Retry periods limit the frequency with which the repository will attempt to create Share thumbnails# for content nodes which have previously failed in their thumbnail attempts.# These periods are in seconds.## 604800s = 60s * 60m * 24h * 7d = 1 weeksystem.thumbnail.retryPeriod=60system.thumbnail.retryCount=2system.thumbnail.quietPeriod=604800system.thumbnail.quietPeriodRetriesEnabled=true# Content Transformers# Base setting for all transformers (2 min timeout)content.transformer.default.timeoutMs=120000content.transformer.default.readLimitTimeMs=-1content.transformer.default.maxSourceSizeKBytes=-1content.transformer.default.readLimitKBytes=-1content.transformer.default.pageLimit=-1content.transformer.default.maxPages=-1# text -> pdf using PdfBox (txt=text/*) 10M takes about 12 secondscontent.transformer.PdfBox.TextToPdf.maxSourceSizeKBytes=10240# pdf -> swf using Pdf2swf 1M takes about 30 seconds.# Using a value of 1.25M (a bit larger that the txt or xlsx) used to create# the pdf on the way to swf to avoid the second part of a transform failingcontent.transformer.Pdf2swf.maxSourceSizeKBytes=1152# txt -> pdf -> swf 1M (pdf is about the same size as the txt)# Need this limit as transformer.PdfBox txt -> pdf is allowed up to 10M# unlike transformer.OpenOffice and transformer.JodConverter which# also only allow 1M textcontent.transformer.complex.Text.Pdf2swf.maxSourceSizeKBytes=1024# Limits for specific mimetype transformations (txt=text/plain only) 1M# Has implication for Share preview which generally goes via pdf to get to swfcontent.transformer.OpenOffice.mimeTypeLimits.txt.pdf.maxSourceSizeKBytes=1024content.transformer.OpenOffice.mimeTypeLimits.xlsx.pdf.maxSourceSizeKBytes=1024content.transformer.JodConverter.mimeTypeLimits.txt.pdf.maxSourceSizeKBytes=1024content.transformer.JodConverter.mimeTypeLimits.xlsx.pdf.maxSourceSizeKBytes=1024# Property to enable upgrade from 2.1-AV2.1-A.fixes.to.schema=0#V2.1-A.fixes.to.schema=82# The default authentication chainauthentication.chain=alfrescoNtlm1:alfrescoNtlm# Do authentication tickets expire or live for ever?authentication.ticket.ticketsExpire=false# If ticketsEpire is true then how they should expire?# Valid values are: AFTER_INACTIVITY, AFTER_FIXED_TIME, DO_NOT_EXPIRE# The default is AFTER_FIXED_TIMEauthentication.ticket.expiryMode=AFTER_FIXED_TIME# If authentication.ticket.ticketsExpire is true and# authentication.ticket.expiryMode is AFTER_FIXED_TIME or AFTER_INACTIVITY,# this controls the minimum period for which tickets are valid. # The default is PT1H for one hour.authentication.ticket.validDuration=PT1H# Default NFS user mappings (empty). Note these users will be able to# authenticate through NFS without password so ensure NFS port is secure before# enabling and adding mappingsnfs.enabled=falsenfs.user.mappings=nfs.user.mappings.default.uid=0nfs.user.mappings.default.gid=0#Example NFS user mappings#nfs.user.mappings=admin,user1 #nfs.user.mappings.value.admin.uid=0 #nfs.user.mappings.value.admin.gid=0 #nfs.user.mappings.value.user1.uid=500 #nfs.user.mappings.value.user1.gid=500 # Default root path for protocolsprotocols.storeName=${spaces.store}protocols.rootPath=/${spaces.company_home.childname}# OpenCMISopencmis.connector.default.store=${spaces.store}opencmis.connector.default.rootPath=/${spaces.company_home.childname}opencmis.connector.default.typesDefaultMaxItems=500opencmis.connector.default.typesDefaultDepth=-1opencmis.connector.default.objectsDefaultMaxItems=10000opencmis.connector.default.objectsDefaultDepth=100opencmis.connector.default.openHttpSession=false# IMAPimap.server.enabled=falseimap.server.port=143imap.server.attachments.extraction.enabled=true# Default IMAP mount pointsimap.config.home.store=${spaces.store}imap.config.home.rootPath=/${spaces.company_home.childname}imap.config.home.folderPath=Imap Homeimap.config.server.mountPoints=AlfrescoIMAPimap.config.server.mountPoints.default.mountPointName=IMAPimap.config.server.mountPoints.default.modeName=ARCHIVEimap.config.server.mountPoints.default.store=${spaces.store}imap.config.server.mountPoints.default.rootPath=${protocols.rootPath}imap.config.server.mountPoints.value.AlfrescoIMAP.mountPointName=Alfresco IMAPimap.config.server.mountPoints.value.AlfrescoIMAP.modeName=MIXED# Activities Feed - refer to subsystem# Feed max size (number of entries)activities.feed.max.size=100# Feed max age (eg. 44640 mins => 31 days)activities.feed.max.ageMins=44640# Subsystem unit test values. Will not have any effect on production serverssubsystems.test.beanProp.default.longProperty=123456789123456789subsystems.test.beanProp.default.anotherStringProperty=Global Defaultsubsystems.test.beanProp=inst1,inst2,inst3subsystems.test.beanProp.value.inst2.boolProperty=truesubsystems.test.beanProp.value.inst3.anotherStringProperty=Global Instance Defaultsubsystems.test.simpleProp2=truesubsystems.test.simpleProp3=Global Default3# Default Async Action Thread Pooldefault.async.action.threadPriority=1default.async.action.corePoolSize=8default.async.action.maximumPoolSize=20# Deployment Servicedeployment.service.numberOfSendingThreads=5deployment.service.corePoolSize=2deployment.service.maximumPoolSize=3deployment.service.threadPriority=5# How long to wait in mS before refreshing a target lock - detects shutdown serversdeployment.service.targetLockRefreshTime=60000# How long to wait in mS from the last communication before deciding that deployment has failed, possibly # the destination is no longer available?deployment.service.targetLockTimeout=3600000#Invitation Service# Should send emails as part of invitation process.notification.email.siteinvite=true# Transfer Servicetransferservice.receiver.enabled=truetransferservice.receiver.stagingDir=${java.io.tmpdir}/alfresco-transfer-staging## How long to wait in mS before refreshing a transfer lock - detects shutdown servers# Default 1 minute.transferservice.receiver.lockRefreshTime=60000## How many times to attempt retry the transfer locktransferservice.receiver.lockRetryCount=3# How long to wait, in mS, before retrying the transfer lock        transferservice.receiver.lockRetryWait=100## How long to wait, in mS, since the last contact with from the client before # timing out a transfer.   Needs to be long enough to cope with network delays and "thinking # time" for both source and destination.    Default 5 minutes.transferservice.receiver.lockTimeOut=300000; DM Receiever Properties;; The name of the DM Receiver target - you deploy to this target namedeployment.dmr.name=alfresco; consolidate staging, author and workflow sandboxes to onedeployment.dmr.consolidate=true; The name of the Alfresco receiver targer deployment.avm.name=avm;Where should the root of the web project be stored, by default /www/avm_webappsdeployment.avm.rootPath=/www/avm_webapps; Pattern for live stores deployment by the alfresco receiverdeployment.avm.storeNamePattern=%storeName%-live; Built in deployment receiver properties for the default ; filesystem receiver; filesystem receiver configurationdeployment.filesystem.rootdir=./wcmdeployment.filesystem.datadir=${deployment.filesystem.rootdir}/depdatadeployment.filesystem.logdir=${deployment.filesystem.rootdir}/deplogdeployment.filesystem.metadatadir=${deployment.filesystem.rootdir}/depmetadatadeployment.filesystem.autofix=truedeployment.filesystem.errorOnOverwrite=false; default filesystem target configurationdeployment.filesystem.default.rootdir=./wwwdeployment.filesystem.default.name=filesystemdeployment.filesystem.default.metadatadir=${deployment.filesystem.metadatadir}/default## Encryption properties## default keystores locationdir.keystore=classpath:alfresco/keystore# general encryption parametersencryption.keySpec.class=org.alfresco.encryption.DESEDEKeyGeneratorencryption.keyAlgorithm=DESedeencryption.cipherAlgorithm=DESede/CBC/PKCS5Padding# secret key keystore configurationencryption.keystore.location=${dir.keystore}/keystoreencryption.keystore.keyMetaData.location=${dir.keystore}/keystore-passwords.propertiesencryption.keystore.provider=encryption.keystore.type=JCEKS# backup secret key keystore configurationencryption.keystore.backup.location=${dir.keystore}/backup-keystoreencryption.keystore.backup.keyMetaData.location=${dir.keystore}/backup-keystore-passwords.propertiesencryption.keystore.backup.provider=encryption.keystore.backup.type=JCEKS# Should encryptable properties be re-encrypted with new encryption keys on botstrap?encryption.bootstrap.reencrypt=false# mac/md5 encryptionencryption.mac.messageTimeout=30000encryption.mac.algorithm=HmacSHA1# ssl encryptionencryption.ssl.keystore.location=${dir.keystore}/ssl.keystoreencryption.ssl.keystore.provider=encryption.ssl.keystore.type=JCEKSencryption.ssl.keystore.keyMetaData.location=${dir.keystore}/ssl-keystore-passwords.propertiesencryption.ssl.truststore.location=${dir.keystore}/ssl.truststoreencryption.ssl.truststore.provider=encryption.ssl.truststore.type=JCEKSencryption.ssl.truststore.keyMetaData.location=${dir.keystore}/ssl-truststore-passwords.properties# Re-encryptor propertiesencryption.reencryptor.chunkSize=100encryption.reencryptor.numThreads=2# SOLR connection details (e.g. for JMX)solr.host=localhostsolr.port=8080solr.port.ssl=8443solr.solrUser=solrsolr.solrPassword=solr# none, httpssolr.secureComms=https# Solr connection timeouts# solr connect timeout in mssolr.solrConnectTimeout=5000# cron expression defining how often the Solr Admin client (used by JMX) pings Solr if it goes awaysolr.solrPingCronExpression=0 0/5 * * * ? *## Web Publishing Properties#publishing.root.path=/app:company_home/app:dictionarypublishing.root=${publishing.root.path}/${spaces.publishing.root.childname}## URL Shortening Properties#urlshortening.bitly.username=brianalfrescourlshortening.bitly.api.key=R_ca15c6c89e9b25ccd170bafd209a0d4furlshortening.bitly.url.length=20## Bulk Filesystem Importer## The number of threads to employ in a batch importbulkImport.batch.numThreads=4# The size of a batch in a batch import i.e. the number of files to import in a# transaction/threadbulkImport.batch.batchSize=20## Caching Content Store#system.content.caching.cacheOnInbound=truesystem.content.caching.maxDeleteWatchCount=1# Clean up every day at 3 amsystem.content.caching.contentCleanup.cronExpression=0 0 3 * * ?system.content.caching.timeToLiveSeconds=0system.content.caching.timeToIdleSeconds=86400system.content.caching.maxElementsInMemory=5000system.content.caching.maxElementsOnDisk=10000system.content.caching.minFileAgeMillis=60000system.content.caching.maxUsageMB=4096# maxFileSizeMB - 0 means no max file size.system.content.caching.maxFileSizeMB=0mybatis.useLocalCaches=falsefileFolderService.checkHidden.enabled=true‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

04:17:22,997 ERROR [org.springframework.web.context.ContextLoader] Context initialization failedorg.springframework.beans.factory.parsing.BeanDefinitionParsingException: Configuration problem: Failed to import bean definitions from URL location [classpath:alfresco/application-context.xml]Offending resource: ServletContext resource [/WEB-INF/web-application-context.xml]; nested exception is org.springframework.beans.factory.BeanDefinitionStoreException: IOException parsing XML document from class path resource [alfresco/application-context.xml]; nested exception is java.io.FileNotFoundException: class path resource [alfresco/application-context.xml] cannot be opened because it does not exist   at org.springframework.beans.factory.parsing.FailFastProblemReporter.error(FailFastProblemReporter.java:68)   at org.springframework.beans.factory.parsing.ReaderContext.error(ReaderContext.java:85)   at org.springframework.beans.factory.parsing.ReaderContext.error(ReaderContext.java:76)   at org.springframework.beans.factory.xml.DefaultBeanDefinitionDocumentReader.importBeanDefinitionResource(DefaultBeanDefinitionDocumentReader.java:192)   at org.springframework.beans.factory.xml.DefaultBeanDefinitionDocumentReader.parseDefaultElement(DefaultBeanDefinitionDocumentReader.java:147)   at org.springframework.beans.factory.xml.DefaultBeanDefinitionDocumentReader.parseBeanDefinitions(DefaultBeanDefinitionDocumentReader.java:132)   at org.springframework.beans.factory.xml.DefaultBeanDefinitionDocumentReader.registerBeanDefinitions(DefaultBeanDefinitionDocumentReader.java:93)   at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.registerBeanDefinitions(XmlBeanDefinitionReader.java:493)   at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.doLoadBeanDefinitions(XmlBeanDefinitionReader.java:390)   at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:334)   at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:302)   at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:143)   at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:178)   at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:149)   at org.springframework.web.context.support.XmlWebApplicationContext.loadBeanDefinitions(XmlWebApplicationContext.java:124)   at org.springframework.web.context.support.XmlWebApplicationContext.loadBeanDefinitions(XmlWebApplicationContext.java:93)   at org.springframework.context.support.AbstractRefreshableApplicationContext.refreshBeanFactory(AbstractRefreshableApplicationContext.java:130)   at org.springframework.context.support.AbstractApplicationContext.obtainFreshBeanFactory(AbstractApplicationContext.java:467)   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:397)   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:276)   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197)   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)   at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4135)   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4630)   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)   at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)   at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)   at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)   at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)   at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)   at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)   at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)   at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)   at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:445)   at org.apache.catalina.core.StandardService.start(StandardService.java:519)   at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)   at org.apache.catalina.startup.Catalina.start(Catalina.java:581)   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)   at java.lang.reflect.Method.invoke(Method.java:597)   at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)Caused by: org.springframework.beans.factory.BeanDefinitionStoreException: IOException parsing XML document from class path resource [alfresco/application-context.xml]; nested exception is java.io.FileNotFoundException: class path resource [alfresco/application-context.xml] cannot be opened because it does not exist   at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:341)   at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:302)   at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:143)   at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:178)   at org.springframework.beans.factory.xml.DefaultBeanDefinitionDocumentReader.importBeanDefinitionResource(DefaultBeanDefinitionDocumentReader.java:186)   … 43 moreCaused by: java.io.FileNotFoundException: class path resource [alfresco/application-context.xml] cannot be opened because it does not exist   at org.springframework.core.io.ClassPathResource.getInputStream(ClassPathResource.java:158)   at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:328)   … 47 more04:17:50,346 INFO  [org.springframework.extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl04:17:50,480 INFO  [org.springframework.extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js04:17:50,481 INFO  [org.springframework.extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl04:17:50,485 INFO  [org.springframework.extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js04:17:55,596 INFO  [org.springframework.extensions.webscripts.DeclarativeRegistry] Registered 314 Web Scripts (+0 failed), 324 URLs04:17:55,597 INFO  [org.springframework.extensions.webscripts.DeclarativeRegistry] Registered 8 Package Description Documents (+0 failed) 04:17:55,597 INFO  [org.springframework.extensions.webscripts.DeclarativeRegistry] Registered 0 Schema Description Documents (+0 failed) 04:17:56,000 INFO  [org.springframework.extensions.webscripts.AbstractRuntimeContainer] Initialised Spring Surf Container Web Script Container (in 5505.837ms)04:17:56,009 INFO  [org.springframework.extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl04:17:56,016 INFO  [org.springframework.extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js04:18:04,647 INFO  [org.alfresco.web.site.EditionInterceptor] Unable to retrieve License information from Alfresco: 404‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

[saidone]

Hello mankind1, I'm fine thanks.

I've just installed Alfresco Community 4.0.d on Windows 7 x64 hoping to replicate your issue.
Unfortunately I did not succeeded, since Alfresco started successfully.

Watching your log, that error seems indeed unrelated to the database, as it state that the file alfresco/application-context.xml does not exist: you can check if it is true: the original file should be in tomcat/webapps/alfresco/WEB-INF/classes/alfresco

I also suggest you to try cleaning the tomcat work and temp directories and delete the alfresco folder inside webapps (i.e. the exploded war), leaving only the (patched) war and see what happens.

Thank you for trying and testing these scripts, and I also wish you a better luck with next restarts!

Cheers,
saidone

P.S.
If you want I can provide the alfresco.war I've tested, that works fine for me (altough nothing more than the original war + the SQL Server amp).

[mankind1]

Hello Saidone,

Thanks for your reply. I am still struggling with this issue. The truth is I kind of gave up on it in frustration, but am now returning hoping that I might find the answer in someone else's solution to my problem, but sadly, no such luck.

Here is the error I am getting from my installation of Community 4.0 d on a windows 2008 R2 server: (taken from c:\alfresco\tomcat\log\stdout_xxx.log)
2012-06-27 11:40:20,404  INFO  [management.subsystems.ChildApplicationContextFactory] [Thread-1] Starting 'sysAdmin' subsystem, ID: [sysAdmin, default]
2012-06-27 11:40:20,529  INFO  [management.subsystems.ChildApplicationContextFactory] [Thread-1] Startup of 'sysAdmin' subsystem, ID: [sysAdmin, default] complete
2012-06-27 11:40:32,829  WARN  [alfresco.util.AbstractTriggerBean] [Thread-1] Job ehCacheTracerJob is not active/enabled
2012-06-27 11:40:37,439  INFO  [extensions.webscripts.TemplateProcessorRegistry] [Thread-1] Registered template processor Repository Template Processor for extension ftl
2012-06-27 11:40:37,443  INFO  [extensions.webscripts.ScriptProcessorRegistry] [Thread-1] Registered script processor Repository Script Processor for extension js
2012-06-27 11:40:46,898  INFO  [domain.schema.SchemaBootstrap] [Thread-1] Schema managed by database dialect org.alfresco.repo.domain.hibernate.dialect.AlfrescoSQLServerDialect.
2012-06-27 11:40:47,192  ERROR [domain.schema.SchemaBootstrap] [Thread-1] Failed to dump normalized, pre-upgrade schema to file.  Error: The SELECT permission was denied on the object 'schemas', database 'mssqlsystemresource', schema 'sys'.
2012-06-27 11:40:52,406  ERROR [domain.schema.SchemaBootstrap] [Thread-1] Failed to dump normalized, pre-upgrade schema to file.  Error: The SELECT permission was denied on the object 'schemas', database 'mssqlsystemresource', schema 'sys'.
2012-06-27 11:40:57,624  ERROR [domain.schema.SchemaBootstrap] [Thread-1] Failed to dump normalized, pre-upgrade schema to file.  Error: The SELECT permission was denied on the object 'schemas', database 'mssqlsystemresource', schema 'sys'.
2012-06-27 11:41:02,831  ERROR [domain.schema.SchemaBootstrap] [Thread-1] Failed to dump normalized, pre-upgrade schema to file.  Error: The SELECT permission was denied on the object 'schemas', database 'mssqlsystemresource', schema 'sys'.
2012-06-27 11:41:08,037  ERROR [domain.schema.SchemaBootstrap] [Thread-1] Failed to dump normalized, pre-upgrade schema to file.  Error: The SELECT permission was denied on the object 'schemas', database 'mssqlsystemresource', schema 'sys'.
2012-06-27 11:41:13,246  ERROR [domain.schema.SchemaBootstrap] [Thread-1] Failed to dump normalized, pre-upgrade schema to file.  Error: The SELECT permission was denied on the object 'schemas', database 'mssqlsystemresource', schema 'sys'.
2012-06-27 11:41:18,454  ERROR [domain.schema.SchemaBootstrap] [Thread-1] Failed to dump normalized, pre-upgrade schema to file.  Error: The SELECT permission was denied on the object 'schemas', database 'mssqlsystemresource', schema 'sys'.
2012-06-27 11:41:23,661  ERROR [domain.schema.SchemaBootstrap] [Thread-1] Failed to dump normalized, pre-upgrade schema to file.  Error: The SELECT permission was denied on the object 'schemas', database 'mssqlsystemresource', schema 'sys'.
2012-06-27 11:41:28,935  ERROR [domain.schema.SchemaBootstrap] [Thread-1] Failed to dump normalized, pre-upgrade schema to file.  Error: The SELECT permission was denied on the object 'schemas', database 'mssqlsystemresource', schema 'sys'.
2012-06-27 11:41:34,194  ERROR [domain.schema.SchemaBootstrap] [Thread-1] Failed to dump normalized, pre-upgrade schema to file.  Error: The SELECT permission was denied on the object 'schemas', database 'mssqlsystemresource', schema 'sys'.
2012-06-27 11:41:39,400  ERROR [domain.schema.SchemaBootstrap] [Thread-1] Failed to dump normalized, pre-upgrade schema to file.  Error: The SELECT permission was denied on the object 'schemas', database 'mssqlsystemresource', schema 'sys'.
2012-06-27 11:41:44,610  ERROR [domain.schema.SchemaBootstrap] [Thread-1] Failed to dump normalized, pre-upgrade schema to file.  Error: The SELECT permission was denied on the object 'schemas', database 'mssqlsystemresource', schema 'sys'.
2012-06-27 11:41:49,816  ERROR [domain.schema.SchemaBootstrap] [Thread-1] Failed to dump normalized, pre-upgrade schema to file.  Error: The SELECT permission was denied on the object 'schemas', database 'mssqlsystemresource', schema 'sys'.
2012-06-27 11:41:55,021  ERROR [domain.schema.SchemaBootstrap] [Thread-1] Failed to dump normalized, pre-upgrade schema to file.  Error: The SELECT permission was denied on the object 'schemas', database 'mssqlsystemresource', schema 'sys'.
2012-06-27 11:42:00,233  ERROR [domain.schema.SchemaBootstrap] [Thread-1] Failed to dump normalized, pre-upgrade schema to file.  Error: The SELECT permission was denied on the object 'schemas', database 'mssqlsystemresource', schema 'sys'.
2012-06-27 11:42:05,437  ERROR [domain.schema.SchemaBootstrap] [Thread-1] Failed to dump normalized, pre-upgrade schema to file.  Error: The SELECT permission was denied on the object 'schemas', database 'mssqlsystemresource', schema 'sys'.
2012-06-27 11:42:10,640  ERROR [domain.schema.SchemaBootstrap] [Thread-1] Failed to dump normalized, pre-upgrade schema to file.  Error: The SELECT permission was denied on the object 'schemas', database 'mssqlsystemresource', schema 'sys'.
2012-06-27 11:42:15,845  ERROR [domain.schema.SchemaBootstrap] [Thread-1] Failed to dump normalized, pre-upgrade schema to file.  Error: The SELECT permission was denied on the object 'schemas', database 'mssqlsystemresource', schema 'sys'.
2012-06-27 11:42:21,054  ERROR [domain.schema.SchemaBootstrap] [Thread-1] Failed to dump normalized, pre-upgrade schema to file.  Error: The SELECT permission was denied on the object 'schemas', database 'mssqlsystemresource', schema 'sys'.
2012-06-27 11:42:26,261  ERROR [domain.schema.SchemaBootstrap] [Thread-1] Failed to dump normalized, pre-upgrade schema to file.  Error: The SELECT permission was denied on the object 'schemas', database 'mssqlsystemresource', schema 'sys'.
2012-06-27 11:42:31,469  ERROR [domain.schema.SchemaBootstrap] [Thread-1] Failed to dump normalized, pre-upgrade schema to file.  Error: The SELECT permission was denied on the object 'schemas', database 'mssqlsystemresource', schema 'sys'.
2012-06-27 11:42:36,674  ERROR [domain.schema.SchemaBootstrap] [Thread-1] Failed to dump normalized, pre-upgrade schema to file.  Error: The SELECT permission was denied on the object 'schemas', database 'mssqlsystemresource', schema 'sys'.
2012-06-27 11:42:41,881  ERROR [domain.schema.SchemaBootstrap] [Thread-1] Failed to dump normalized, pre-upgrade schema to file.  Error: The SELECT permission was denied on the object 'schemas', database 'mssqlsystemresource', schema 'sys'.
2012-06-27 11:42:47,093  ERROR [domain.schema.SchemaBootstrap] [Thread-1] Failed to dump normalized, pre-upgrade schema to file.  Error: The SELECT permission was denied on the object 'schemas', database 'mssqlsystemresource', schema 'sys'.
2012-06-27 11:42:52,121  ERROR [domain.schema.SchemaBootstrap] [Thread-1] Schema auto-update failed
org.alfresco.error.AlfrescoRuntimeException: 05270000 A previous schema upgrade failed or was not completed.  Revert to the original database before attempting the upgrade again.
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1492)
   at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)
   at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEventInternal(SafeApplicationEventMulticaster.java:209)
   at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:180)
   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:303)
   at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:911)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:428)
   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:276)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
   at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)
   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4135)
   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4630)
   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
   at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
   at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)
   at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)
   at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)
   at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
   at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
   at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
   at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
   at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:445)
   at org.apache.catalina.core.StandardService.start(StandardService.java:519)
   at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
   at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
2012-06-27 11:42:52,124  ERROR [web.context.ContextLoader] [Thread-1] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: 05270001 Schema auto-update failed
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1612)
   at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)
   at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEventInternal(SafeApplicationEventMulticaster.java:209)
   at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:180)
   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:303)
   at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:911)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:428)
   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:276)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
   at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)
   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4135)
   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4630)
   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
   at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
   at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)
   at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)
   at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)
   at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
   at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
   at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
   at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
   at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:445)
   at org.apache.catalina.core.StandardService.start(StandardService.java:519)
   at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
   at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: org.alfresco.error.AlfrescoRuntimeException: 05270000 A previous schema upgrade failed or was not completed.  Revert to the original database before attempting the upgrade again.
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1492)
   … 34 more
log4j:ERROR LogMananger.repositorySelector was null likely due to error in class reloading, using NOPLoggerRepository.
2012-06-27 11:43:44,387  INFO  [extensions.webscripts.TemplateProcessorRegistry] [Thread-1] Registered template processor freemarker for extension ftl
2012-06-27 11:43:44,488  INFO  [extensions.webscripts.ScriptProcessorRegistry] [Thread-1] Registered script processor javascript for extension js
2012-06-27 11:43:44,507  INFO  [extensions.webscripts.TemplateProcessorRegistry] [Thread-1] Registered template processor freemarker for extension ftl
2012-06-27 11:43:44,517  INFO  [extensions.webscripts.ScriptProcessorRegistry] [Thread-1] Registered script processor javascript for extension js
2012-06-27 11:43:53,629  INFO  [extensions.webscripts.DeclarativeRegistry] [Thread-1] Registered 312 Web Scripts (+0 failed), 322 URLs
2012-06-27 11:43:53,629  INFO  [extensions.webscripts.DeclarativeRegistry] [Thread-1] Registered 8 Package Description Documents (+0 failed)
2012-06-27 11:43:53,629  INFO  [extensions.webscripts.DeclarativeRegistry] [Thread-1] Registered 0 Schema Description Documents (+0 failed)
2012-06-27 11:43:53,913  INFO  [extensions.webscripts.AbstractRuntimeContainer] [Thread-1] Initialised Spring Surf Container Web Script Container (in 9241.473ms)
2012-06-27 11:43:54,022  INFO  [extensions.webscripts.TemplateProcessorRegistry] [Thread-1] Registered template processor freemarker for extension ftl
2012-06-27 11:43:54,030  INFO  [extensions.webscripts.ScriptProcessorRegistry] [Thread-1] Registered script processor javascript for extension js
log4j:WARN No appenders could be found for logger (org.quartz.core.QuartzSchedulerThread).
log4j:WARN Please initialize the log4j system properly.

and from c:afresco\tomcat\stderr_xxx.log):
Jun 27, 2012 11:40:03 AM org.apache.catalina.core.ApplicationContext log
INFO: Initializing Spring root WebApplicationContext
Jun 27, 2012 11:40:31 AM org.activiti.engine.impl.ProcessEngineImpl <init>
INFO: ProcessEngine default created
Jun 27, 2012 11:42:52 AM org.apache.catalina.core.StandardContext listenerStart
SEVERE: Exception sending context initialized event to listener instance of class org.alfresco.web.app.ContextLoaderListener
org.alfresco.error.AlfrescoRuntimeException: 05270001 Schema auto-update failed
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1612)
   at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)
   at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEventInternal(SafeApplicationEventMulticaster.java:209)
   at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:180)
   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:303)
   at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:911)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:428)
   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:276)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
   at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)
   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4135)
   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4630)
   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
   at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
   at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)
   at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)
   at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)
   at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
   at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
   at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
   at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
   at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:445)
   at org.apache.catalina.core.StandardService.start(StandardService.java:519)
   at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
   at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: org.alfresco.error.AlfrescoRuntimeException: 05270000 A previous schema upgrade failed or was not completed.  Revert to the original database before attempting the upgrade again.
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1492)
   … 34 more
Jun 27, 2012 11:42:52 AM org.apache.catalina.core.StandardContext listenerStart
SEVERE: Exception sending context initialized event to listener instance of class org.alfresco.web.app.ContextListener
org.alfresco.error.AlfrescoRuntimeException: 05270001 Schema auto-update failed
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1612)
   at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)
   at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEventInternal(SafeApplicationEventMulticaster.java:209)
   at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:180)
   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:303)
   at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:911)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:428)
   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:276)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
   at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)
   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4135)
   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4630)
   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
   at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
   at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)
   at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)
   at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)
   at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
   at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
   at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
   at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
   at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:445)
   at org.apache.catalina.core.StandardService.start(StandardService.java:519)
   at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
   at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: org.alfresco.error.AlfrescoRuntimeException: 05270000 A previous schema upgrade failed or was not completed.  Revert to the original database before attempting the upgrade again.
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1492)
   … 34 more
Jun 27, 2012 11:42:52 AM com.sun.xml.ws.transport.http.servlet.WSServletContextListener contextInitialized
INFO: WSSERVLET12: JAX-WS context listener initializing
Jun 27, 2012 11:42:57 AM com.sun.xml.ws.transport.http.servlet.WSServletDelegate <init>
INFO: WSSERVLET14: JAX-WS servlet initializing
Jun 27, 2012 11:42:57 AM org.apache.catalina.core.StandardContext start
SEVERE: Error listenerStart
Jun 27, 2012 11:42:57 AM org.apache.catalina.core.StandardContext start
SEVERE: Context [/alfresco] startup failed due to previous errors
Jun 27, 2012 11:42:57 AM com.sun.xml.ws.transport.http.servlet.WSServletDelegate destroy
INFO: WSSERVLET15: JAX-WS servlet destroyed
Jun 27, 2012 11:42:57 AM com.sun.xml.ws.transport.http.servlet.WSServletContextListener contextDestroyed
INFO: WSSERVLET13: JAX-WS context listener destroyed
Jun 27, 2012 11:42:57 AM org.apache.catalina.core.ApplicationContext log
INFO: Closing Spring root WebApplicationContext
Jun 27, 2012 11:42:57 AM org.apache.catalina.core.ApplicationContext log
INFO: Shutting down log4j
Jun 27, 2012 11:42:57 AM org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc
SEVERE: The web application [/alfresco] registered the JBDC driver [net.sourceforge.jtds.jdbc.Driver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
Jun 27, 2012 11:42:57 AM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: The web application [/alfresco] appears to have started a thread named [net.sf.ehcache.CacheManager@7f85e155] but has failed to stop it. This is very likely to create a memory leak.
Jun 27, 2012 11:42:57 AM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: The web application [/alfresco] appears to have started a thread named [SolrWatcherScheduler_Worker-1] but has failed to stop it. This is very likely to create a memory leak.
Jun 27, 2012 11:42:57 AM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: The web application [/alfresco] appears to have started a thread named [SolrWatcherScheduler_Worker-2] but has failed to stop it. This is very likely to create a memory leak.
Jun 27, 2012 11:42:57 AM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: The web application [/alfresco] appears to have started a thread named [SolrWatcherScheduler_Worker-3] but has failed to stop it. This is very likely to create a memory leak.
Jun 27, 2012 11:42:57 AM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: The web application [/alfresco] appears to have started a thread named [Timer-0] but has failed to stop it. This is very likely to create a memory leak.
Jun 27, 2012 11:42:57 AM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: The web application [/alfresco] appears to have started a thread named [DefaultScheduler_Worker-1] but has failed to stop it. This is very likely to create a memory leak.
Jun 27, 2012 11:42:57 AM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: The web application [/alfresco] appears to have started a thread named [DefaultScheduler_Worker-2] but has failed to stop it. This is very likely to create a memory leak.
Jun 27, 2012 11:42:57 AM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: The web application [/alfresco] appears to have started a thread named [DefaultScheduler_Worker-3] but has failed to stop it. This is very likely to create a memory leak.
Jun 27, 2012 11:42:57 AM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: The web application [/alfresco] appears to have started a thread named [DefaultScheduler_Worker-4] but has failed to stop it. This is very likely to create a memory leak.
Jun 27, 2012 11:42:57 AM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: The web application [/alfresco] appears to have started a thread named [DefaultScheduler_Worker-5] but has failed to stop it. This is very likely to create a memory leak.
Jun 27, 2012 11:42:57 AM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: The web application [/alfresco] appears to have started a thread named [DefaultScheduler_Worker-6] but has failed to stop it. This is very likely to create a memory leak.
Jun 27, 2012 11:42:57 AM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: The web application [/alfresco] appears to have started a thread named [DefaultScheduler_Worker-7] but has failed to stop it. This is very likely to create a memory leak.
Jun 27, 2012 11:42:57 AM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: The web application [/alfresco] appears to have started a thread named [DefaultScheduler_Worker-8] but has failed to stop it. This is very likely to create a memory leak.
Jun 27, 2012 11:42:57 AM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: The web application [/alfresco] appears to have started a thread named [DefaultScheduler_Worker-9] but has failed to stop it. This is very likely to create a memory leak.
Jun 27, 2012 11:42:57 AM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: The web application [/alfresco] appears to have started a thread named [DefaultScheduler_Worker-10] but has failed to stop it. This is very likely to create a memory leak.
Jun 27, 2012 11:42:57 AM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: The web application [/alfresco] appears to have started a thread named [Thread-4] but has failed to stop it. This is very likely to create a memory leak.
Jun 27, 2012 11:42:57 AM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: The web application [/alfresco] appears to have started a thread named [SolrWatcherScheduler_QuartzSchedulerThread] but has failed to stop it. This is very likely to create a memory leak.
Jun 27, 2012 11:42:57 AM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: The web application [/alfresco] appears to have started a thread named [DefaultScheduler_QuartzSchedulerThread] but has failed to stop it. This is very likely to create a memory leak.
Jun 27, 2012 11:42:57 AM org.apache.catalina.loader.WebappClassLoader clearThreadLocalMap
SEVERE: The web application [/alfresco] created a ThreadLocal with key of type [null] (value [com.sun.xml.bind.v2.ClassFactory$1@25b3c442]) and a value of type [java.util.WeakHashMap] (value [{class javax.xml.bind.annotation.W3CDomHandler=java.lang.ref.WeakReference@64a6138a, class org.alfresco.repo.audit.model._3.Audit=java.lang.ref.WeakReference@534cfca5, class org.alfresco.repo.audit.model._3.PathMap=java.lang.ref.WeakReference@635edf5c, class org.alfresco.repo.audit.model._3.DataExtractors=java.lang.ref.WeakReference@699a43fb, class org.alfresco.repo.audit.model._3.GenerateValue=java.lang.ref.WeakReference@ee549e7, class org.alfresco.repo.audit.model._3.DataGenerators=java.lang.ref.WeakReference@6f56e454, class org.alfresco.repo.audit.model._3.RecordValue=java.lang.ref.WeakReference@31a87fe7, class org.alfresco.repo.audit.model._3.Application=java.lang.ref.WeakReference@2d653029, class org.alfresco.repo.audit.model._3.AuditPath=java.lang.ref.WeakReference@4e3ceb07, class org.alfresco.repo.audit.model._3.DataExtractor=java.lang.ref.WeakReference@16a40b2, class org.alfresco.repo.audit.model._3.DataGenerator=java.lang.ref.WeakReference@66bd66d7, class java.util.ArrayList=java.lang.ref.WeakReference@1caae1f3, class org.alfresco.repo.audit.model._3.PathMappings=java.lang.ref.WeakReference@16d82739}]) but failed to remove it when the web application was stopped. This is very likely to create a memory leak.
Jun 27, 2012 11:42:57 AM org.apache.catalina.loader.WebappClassLoader clearThreadLocalMap
SEVERE: The web application [/alfresco] created a ThreadLocal with key of type [java.lang.ThreadLocal] (value [java.lang.ThreadLocal@48f71ae6]) and a value of type [org.apache.cxf.bus.CXFBusImpl] (value [org.apache.cxf.bus.CXFBusImpl@57071776]) but failed to remove it when the web application was stopped. This is very likely to create a memory leak.
Jun 27, 2012 11:42:57 AM org.apache.catalina.loader.WebappClassLoader clearThreadLocalMap
SEVERE: The web application [/alfresco] created a ThreadLocal with key of type [null] (value [com.sun.xml.bind.v2.runtime.Coordinator$1@1295709d]) and a value of type [java.lang.Object[]] (value [[Ljava.lang.Object;@11145cf3]) but failed to remove it when the web application was stopped. This is very likely to create a memory leak.
Jun 27, 2012 11:42:57 AM org.apache.catalina.loader.WebappClassLoader clearThreadLocalMap
SEVERE: The web application [/alfresco] created a ThreadLocal with key of type [java.lang.ThreadLocal] (value [java.lang.ThreadLocal@4fe25e47]) and a value of type [org.alfresco.util.CachingDateFormat] (value [yyyy-MM-dd]) but failed to remove it when the web application was stopped. This is very likely to create a memory leak.

Please advise

Thanks in advance

[saidone]

Hello Mankind1,

now your problem is clear: it seems that the SQLServer user that Alfresco is using to connect to the database does not have the correct privileges. It should have sufficient rights to create tables, etc.
I suggest you to give the ownership of the database "alfresco" to that user and retry.
At that point on the log you should see:

17:22:30,657 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Starting 'sysAdmin' subsystem, ID: [sysAdmin, default]
17:22:30,728 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Startup of 'sysAdmin' subsystem, ID: [sysAdmin, default] complete
17:22:37,743 WARN [org.alfresco.util.AbstractTriggerBean] Job ehCacheTracerJob is not active/enabled 17:22:40,549 INFO [org.springframework.extensions.webscripts.TemplateProcessorRegistry] Registered template processor Repository Template Processor for extension ftl
17:22:40,551 INFO [org.springframework.extensions.webscripts.ScriptProcessorRegistry] Registered script processor Repository Script Processor for extension js
17:22:45,873 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema managed by database dialect org.alfresco.repo.domain.hibernate.dialect.AlfrescoSQLServerDialect.
17:22:47,012 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /home/saidone/alfresco-4.0.d/tomcat/temp/Alfresco/AlfrescoSchema-AlfrescoSQLServ erDialect-Update-6791308787379541521.sql (Copied from classpath:alfresco/dbscripts/create/org.alfresco.repo.domain.hibernate.dialect.A lfrescoSQLServerDialect/AlfrescoCreate-RepoTables.sql).
17:22:47,356 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /home/saidone/alfresco-4.0.d/tomcat/temp/Alfresco/AlfrescoSchema-AlfrescoSQLServ erDialect-Update-1836921456835355488.sql (Copied from classpath:alfresco/dbscripts/create/org.alfresco.repo.domain.hibernate.dialect.A lfrescoSQLServerDialect/AlfrescoCreate-LockTables.sql).
17:22:47,390 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /home/saidone/alfresco-4.0.d/tomcat/temp/Alfresco/AlfrescoSchema-AlfrescoSQLServ erDialect-Update-7188642070110397531.sql (Copied from classpath:alfresco/dbscripts/create/org.alfresco.repo.domain.hibernate.dialect.A lfrescoSQLServerDialect/AlfrescoCreate-ContentTables.sql).

[…]

17:22:48,763 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /home/saidone/alfresco-4.0.d/tomcat/temp/Alfresco/AlfrescoSchema-AlfrescoSQLServ erDialect-Update-4281027549462978162.sql (Copied from classpath:alfresco/dbscripts/create/org.alfresco.repo.domain.hibernate.dialect.A lfrescoSQLServerDialect/AlfrescoPostCreate-JBPM-FK-indexes.sql).
17:22:49,545 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] All executed statements: /home/saidone/alfresco-4.0.d/tomcat/temp/Alfresco/AlfrescoSchema-AlfrescoSQLServ erDialect-All_Statements-8139403548822186140.sql.
17:22:52,433 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] Normalized schema dumped to file /home/saidone/alfresco-4.0.d/tomcat/temp/Alfresco/AlfrescoSchema-AlfrescoSQLServerDialect-1881954587623112679.xml.

Let me know if it works now!

Cheers,
saidone

http://saidone.org/kugelmass/posts/alfresco-cmis-benchmarking-tool#comments