Errors on Unable to validate database schema when starting newly created Allinone project on Alfresco 5 Enterprise in Eclispe

[qingl97]

I tried to run the newly created Allinone project in Eclipse using Alfresco SDK 2.0 with Alfresco One 5.0.0.3 in Windows 7 following the official guide. During the starting process, I found these error message in the alfresco.log:

2015-03-13 12:42:16,532  ERROR [domain.schema.SchemaBootstrap] [localhost-startStop-1] Unable to validate database schema.
 java.lang.IllegalArgumentException: dbObject cannot be null.
   at org.alfresco.util.schemacomp.DbProperty.<init>(DbProperty.java:51)
   at org.alfresco.util.schemacomp.DbProperty.<init>(DbProperty.java:113)
   at org.alfresco.util.schemacomp.model.AbstractDbObject.diff(AbstractDbObject.java:175)
   at org.alfresco.util.schemacomp.model.Table.doDiff(Table.java:220)
   at org.alfresco.util.schemacomp.model.AbstractDbObject.diff(AbstractDbObject.java:178)
   at org.alfresco.util.schemacomp.DefaultComparisonUtils.compareCollections(DefaultComparisonUtils.java:208)
   at org.alfresco.util.schemacomp.model.Schema.doDiff(Schema.java:181)
   at org.alfresco.util.schemacomp.model.AbstractDbObject.diff(AbstractDbObject.java:178)
   at org.alfresco.util.schemacomp.SchemaComparator.compare(SchemaComparator.java:66)
   at org.alfresco.util.schemacomp.SchemaComparator.validateAndCompare(SchemaComparator.java:57)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.attemptValidateSchema(SchemaBootstrap.java:1920)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.validateSchema(SchemaBootstrap.java:1862)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.validateSchema(SchemaBootstrap.java:1849)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1749)
   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:334)
   at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:948)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:482)
   at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:410)
   at org.alfresco.web.app.ContextLoaderListener.configureAndRefreshWebApplicationContext(ContextLoaderListener.java)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306)
   at org.alfresco.web.app.ContextLoaderListener.initWebApplicationContext(ContextLoaderListener.java)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:112)
   at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)
   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4939)
   at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5434)
   at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
   at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1559)
   at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1549)
   at java.util.concurrent.FutureTask.run(Unknown Source)
   at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
   at java.lang.Thread.run(Unknown Source)
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Finally I got

INFOS: Starting ProtocolHandler ["http-bio-8080"]‍

and I can visit http://localhost:8080/[alfresco|share] normally. Everything seems to be fine despite of the error about database schema I posted above.

For this newly created project, the only change I made is the pom file.
Following is the configuration for properties of the root pom.xml for my Allinone project.

<properties>
    <alfresco.groupId>org.alfresco</alfresco.groupId>
    <alfresco.version>5.0.0.3</alfresco.version>
    <alfresco.repo.artifactId>alfresco-enterprise</alfresco.repo.artifactId>
    <alfresco.share.artifactId>share-enterprise</alfresco.share.artifactId>
    <app.log.root.level>WARN</app.log.root.level>
    <alfresco.data.location>alf_data_dev</alfresco.data.location>
    <!– This controls which properties will be picked in multi-enviromment build –>
    <env>local</env>
</properties>
‍‍‍‍‍‍‍‍‍‍‍‍

So this should can prove that the running Alfresco is exactly of Enterprise Edition.
Also I configured the credentials for accessing the private Alfresco artifacts repository, so that the project can work against the Alfresco enterprise edition.

And I noticed this message in alfresco.log

INFO  [service.descriptor.DescriptorService] [localhost-startStop-1] Alfresco started (Enterprise). Current version: 5.0.0 (.3 r92668-b10) schema 8 009. Originally installed version: 5.0.0 (.3 r92668-b10) schema 8 009.
‍‍‍

I want to know the cause for this error in database schema validating. Any ideas?

In fact, despite of running Alfresco in Eclispe, I also got this error servral times when I start the Alfresco that I installed locallly on my PC. So I don't think it might be the cause of version.

I attached the console output so that you can have a dig into it if you need.

[gravitonian]

Hi,

This is a known bug: https://github.com/Alfresco/alfresco-sdk/issues/250

We are working on it.

It usually just happens first time you start when the DB is bootstrapped, after that it should work OK.