Start-up Error for Confluence

[clem]

Hi,

Does anyone know why I am getting this error during the startup of Confluence?

2016-09-27 12:11:03,611 ERROR [localhost-startStop-1] [core.persistence.schema.StartupSchemaChecker] checkSchema Failed to verify schema consistency
java.lang.NullPointerException
at com.atlassian.confluence.core.persistence.schema.hibernate.HibernateSchemaComparator.compareIndexes(HibernateSchemaComparator.java:136)
at com.atlassian.confluence.core.persistence.schema.hibernate.HibernateSchemaComparator.compareTable(HibernateSchemaComparator.java:99)
at com.atlassian.confluence.core.persistence.schema.hibernate.HibernateSchemaComparator.access$000(HibernateSchemaComparator.java:50)
at com.atlassian.confluence.core.persistence.schema.hibernate.HibernateSchemaComparator$1.apply(HibernateSchemaComparator.java:83)
at com.atlassian.confluence.core.persistence.schema.hibernate.HibernateSchemaComparator$1.apply(HibernateSchemaComparator.java:77)
at com.google.common.collect.Iterators$8.next(Iterators.java:812)
at com.google.common.collect.Lists.newArrayList(Lists.java:139)
at com.google.common.collect.Lists.newArrayList(Lists.java:119)
at com.atlassian.confluence.core.persistence.schema.hibernate.HibernateSchemaComparator.compareTables(HibernateSchemaComparator.java:76)
at com.atlassian.confluence.core.persistence.schema.hibernate.HibernateSchemaComparator.compareSchema(HibernateSchemaComparator.java:66)
at com.atlassian.confluence.core.persistence.schema.hibernate.HibernateSchemaComparisonService.compareExpectedWithActualSchema(HibernateSchemaComparisonService.java:53)
at com.atlassian.confluence.core.persistence.schema.StartupSchemaChecker.checkSchema(StartupSchemaChecker.java:75)
at com.atlassian.confluence.core.persistence.schema.StartupSchemaChecker.checkSchemaIfBuildNumbersMatch(StartupSchemaChecker.java:60)
at com.atlassian.tenancy.api.helper.TenantAccessors$2.call(TenantAccessors.java:43)
at com.atlassian.tenancy.api.helper.TenantAccessors$2.call(TenantAccessors.java:40)
at com.atlassian.confluence.tenant.VolatileSingleTenantRegistry.asTenant(VolatileSingleTenantRegistry.java:53)
at com.atlassian.tenancy.api.helper.TenantAccessors$1.apply(TenantAccessors.java:27)
at com.atlassian.tenancy.api.helper.TenantAccessors$1.apply(TenantAccessors.java:23)
at com.google.common.collect.Iterators$8.next(Iterators.java:812)
at com.google.common.collect.Iterables$3.next(Iterables.java:508)
at com.google.common.collect.Iterables$3.next(Iterables.java:501)
at com.google.common.collect.Iterators$5.hasNext(Iterators.java:544)
at com.google.common.collect.Iterators$8.hasNext(Iterators.java:807)
at com.google.common.collect.Iterables$3.hasNext(Iterables.java:504)
at com.google.common.collect.Iterators$5.hasNext(Iterators.java:543)
at com.atlassian.tenancy.api.helper.PerTenantInitialiser.init(PerTenantInitialiser.java:41)
at com.atlassian.confluence.core.persistence.schema.StartupSchemaChecker.runTenantInitialiser(StartupSchemaChecker.java:46)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)

Thank-you,

Cynthia

[Guilherme V.]

Hi Cynthia,
That's the method that checks the database, I mean, there's an internal task that will check the content of the tables and the columns. 
Are you using MySQL?
Maybe this article can provide more information:https://confluence.atlassian.com/confkb/the-database-constraint-checker-722143829.html 

[clem]

Hi,

Thanks for the reply.  I'm using an Oracle database.

Do you know if the error would be serious in nature or some noise that can be ignored or recovered from?

Thank-you,

Cynthia

[Guilherme V.]

Did you setup a view for the user as stated in this article: https://confluence.atlassian.com/display/DOC/Database+Setup+for+Oracle#DatabaseSetupforOracle-Step3.SetupyourOracleuserwithschema-creationprivileges

The query would be:

create view <user>.all_objects as
select *
from sys.all_objects
where owner = upper('<user>');