Liferay not creating tables in SQL Database

[9年前 に Clay Banks によって更新されました。]

Hello Lr,

I've just created a brand new SQL Server Liferay Database. The database is empty and I'm trying to have Liferay populate it with the proper tables on Tomcat's startup.

I've added the property in my portal-ext.properties to automatically create these tables:

schema.run.enabled=true

However, no tables are getting created and I'm getting the following exceptions:

dex IX_C1A01806 on Users_Roles (userId);_ [Sanitized]
13:04:23,941 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "U
sers_Teams" because it does not exist or you do not have permissions.: create in
dex IX_4D06AD51 on Users_Teams (teamId);_ [Sanitized]
13:04:23,948 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "U
sers_Teams" because it does not exist or you do not have permissions.: create in
dex IX_A098EFBF on Users_Teams (userId);_ [Sanitized]
13:04:23,955 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "U
sers_UserGroups" because it does not exist or you do not have permissions.: crea
te index IX_66FF2503 on Users_UserGroups (userGroupId);_ [Sanitized]
13:04:23,962 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "U
sers_UserGroups" because it does not exist or you do not have permissions.: crea
te index IX_BE8102D6 on Users_UserGroups (userId);_ [Sanitized]
13:04:23,970 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "V
irtualHost" because it does not exist or you do not have permissions.: create un
ique index IX_A083D394 on VirtualHost (companyId, layoutSetId);_ [Sanitized]
13:04:23,978 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "V
irtualHost" because it does not exist or you do not have permissions.: create un
ique index IX_431A3960 on VirtualHost (hostname);_ [Sanitized]
13:04:23,985 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "W
ebDAVProps" because it does not exist or you do not have permissions.: create un
ique index IX_97DFA146 on WebDAVProps (classNameId, classPK);_ [Sanitized]
13:04:23,995 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "W
ebsite" because it does not exist or you do not have permissions.: create index
IX_96F07007 on Website (companyId);_ [Sanitized]
13:04:24,003 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "W
ebsite" because it does not exist or you do not have permissions.: create index
IX_4F0F0CA7 on Website (companyId, classNameId);_ [Sanitized]
13:04:24,010 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "W
ebsite" because it does not exist or you do not have permissions.: create index
IX_F960131C on Website (companyId, classNameId, classPK);_ [Sanitized]
13:04:24,017 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "W
ebsite" because it does not exist or you do not have permissions.: create index
IX_1AA07A6D on Website (companyId, classNameId, classPK, primary_);_ [Sanitized]

13:04:24,024 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "W
ebsite" because it does not exist or you do not have permissions.: create index
IX_F75690BB on Website (userId);_ [Sanitized]
13:04:24,034 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "W
ebsite" because it does not exist or you do not have permissions.: create index
IX_76F15D13 on Website (uuid_);_ [Sanitized]
13:04:24,041 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "W
ebsite" because it does not exist or you do not have permissions.: create index
IX_712BCD35 on Website (uuid_, companyId);_ [Sanitized]
13:04:24,051 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "W
ikiNode" because it does not exist or you do not have permissions.: create index
 IX_5D6FE3F0 on WikiNode (companyId);_ [Sanitized]
13:04:24,073 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "W
ikiNode" because it does not exist or you do not have permissions.: create index
 IX_B54332D6 on WikiNode (companyId, status);_ [Sanitized]
13:04:24,082 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "W
ikiNode" because it does not exist or you do not have permissions.: create index
 IX_B480A672 on WikiNode (groupId);_ [Sanitized]
13:04:24,090 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "W
ikiNode" because it does not exist or you do not have permissions.: create uniqu
e index IX_920CD8B1 on WikiNode (groupId, name);_ [Sanitized]
13:04:24,105 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "W
ikiNode" because it does not exist or you do not have permissions.: create index
 IX_23325358 on WikiNode (groupId, status);_ [Sanitized]
13:04:24,123 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "W
ikiNode" because it does not exist or you do not have permissions.: create index
 IX_6C112D7C on WikiNode (uuid_);_ [Sanitized]
13:04:24,135 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "W
ikiNode" because it does not exist or you do not have permissions.: create index
 IX_E0E6D12C on WikiNode (uuid_, companyId);_ [Sanitized]
13:04:24,143 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "W
ikiNode" because it does not exist or you do not have permissions.: create uniqu
e index IX_7609B2AE on WikiNode (uuid_, groupId);_ [Sanitized]
13:04:24,150 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "W
ikiPage" because it does not exist or you do not have permissions.: create index
 IX_A2001730 on WikiPage (format);_ [Sanitized]
13:04:24,157 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "W
ikiPage" because it does not exist or you do not have permissions.: create index
 IX_16E99B0A on WikiPage (groupId, nodeId, head);_ [Sanitized]
13:04:24,164 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "W
ikiPage" because it does not exist or you do not have permissions.: create index
 IX_BA72B89A on WikiPage (groupId, nodeId, head, parentTitle, status);_ [Sanitiz
ed]
13:04:24,170 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "W
ikiPage" because it does not exist or you do not have permissions.: create index
 IX_E0092FF0 on WikiPage (groupId, nodeId, head, status);_ [Sanitized]
13:04:24,176 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "W
ikiPage" because it does not exist or you do not have permissions.: create index
 IX_941E429C on WikiPage (groupId, nodeId, status);_ [Sanitized]
13:04:24,183 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "W
ikiPage" because it does not exist or you do not have permissions.: create index
 IX_5FF21CE6 on WikiPage (groupId, nodeId, title, head);_ [Sanitized]
13:04:24,189 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "W
ikiPage" because it does not exist or you do not have permissions.: create index
 IX_CAA451D6 on WikiPage (groupId, userId, nodeId, status);_ [Sanitized]
13:04:24,195 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "W
ikiPage" because it does not exist or you do not have permissions.: create index
 IX_C8A9C476 on WikiPage (nodeId);_ [Sanitized]
13:04:24,200 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "W
ikiPage" because it does not exist or you do not have permissions.: create index
 IX_E7F635CA on WikiPage (nodeId, head);_ [Sanitized]
13:04:24,206 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "W
ikiPage" because it does not exist or you do not have permissions.: create index
 IX_65E84AF4 on WikiPage (nodeId, head, parentTitle);_ [Sanitized]
13:04:24,214 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "W
ikiPage" because it does not exist or you do not have permissions.: create index
 IX_9F7655DA on WikiPage (nodeId, head, parentTitle, status);_ [Sanitized]
13:04:24,220 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "W
ikiPage" because it does not exist or you do not have permissions.: create index
 IX_40F94F68 on WikiPage (nodeId, head, redirectTitle, status);_ [Sanitized]
13:04:24,226 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "W
ikiPage" because it does not exist or you do not have permissions.: create index
 IX_432F0AB0 on WikiPage (nodeId, head, status);_ [Sanitized]
13:04:24,232 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "W
ikiPage" because it does not exist or you do not have permissions.: create index
 IX_46EEF3C8 on WikiPage (nodeId, parentTitle);_ [Sanitized]
13:04:24,238 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "W
ikiPage" because it does not exist or you do not have permissions.: create index
 IX_1ECC7656 on WikiPage (nodeId, redirectTitle);_ [Sanitized]
13:04:24,244 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "W
ikiPage" because it does not exist or you do not have permissions.: create index
 IX_546F2D5C on WikiPage (nodeId, status);_ [Sanitized]
13:04:24,257 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "W
ikiPage" because it does not exist or you do not have permissions.: create index
 IX_997EEDD2 on WikiPage (nodeId, title);_ [Sanitized]
13:04:24,272 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "W
ikiPage" because it does not exist or you do not have permissions.: create index
 IX_E745EA26 on WikiPage (nodeId, title, head);_ [Sanitized]
13:04:24,290 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "W
ikiPage" because it does not exist or you do not have permissions.: create index
 IX_BEA33AB8 on WikiPage (nodeId, title, status);_ [Sanitized]
13:04:24,315 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "W
ikiPage" because it does not exist or you do not have permissions.: create uniqu
e index IX_3D4AF476 on WikiPage (nodeId, title, version);_ [Sanitized]
13:04:24,343 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "W
ikiPage" because it does not exist or you do not have permissions.: create index
 IX_85E7CC76 on WikiPage (resourcePrimKey);_ [Sanitized]
13:04:24,586 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "W
ikiPage" because it does not exist or you do not have permissions.: create index
 IX_B771D67 on WikiPage (resourcePrimKey, nodeId);_ [Sanitized]
13:04:24,957 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "W
ikiPage" because it does not exist or you do not have permissions.: create index
 IX_E1F55FB on WikiPage (resourcePrimKey, nodeId, head);_ [Sanitized]
13:04:25,069 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "W
ikiPage" because it does not exist or you do not have permissions.: create index
 IX_94D1054D on WikiPage (resourcePrimKey, nodeId, status);_ [Sanitized]
13:04:25,084 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "W
ikiPage" because it does not exist or you do not have permissions.: create uniqu
e index IX_2CD67C81 on WikiPage (resourcePrimKey, nodeId, version);_ [Sanitized]

13:04:25,091 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "W
ikiPage" because it does not exist or you do not have permissions.: create index
 IX_1725355C on WikiPage (resourcePrimKey, status);_ [Sanitized]
13:04:25,113 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "W
ikiPage" because it does not exist or you do not have permissions.: create index
 IX_FBBE7C96 on WikiPage (userId, nodeId, status);_ [Sanitized]
13:04:25,119 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "W
ikiPage" because it does not exist or you do not have permissions.: create index
 IX_9C0E478F on WikiPage (uuid_);_ [Sanitized]
13:04:25,126 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "W
ikiPage" because it does not exist or you do not have permissions.: create index
 IX_5DC4BD39 on WikiPage (uuid_, companyId);_ [Sanitized]
13:04:25,139 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "W
ikiPage" because it does not exist or you do not have permissions.: create uniqu
e index IX_899D3DFB on WikiPage (uuid_, groupId);_ [Sanitized]
13:04:25,147 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "W
ikiPageResource" because it does not exist or you do not have permissions.: crea
te unique index IX_21277664 on WikiPageResource (nodeId, title);_ [Sanitized]
13:04:25,166 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "W
ikiPageResource" because it does not exist or you do not have permissions.: crea
te index IX_BE898221 on WikiPageResource (uuid_);_ [Sanitized]
13:04:25,174 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "W
orkflowDefinitionLink" because it does not exist or you do not have permissions.
: create index IX_A8B0D276 on WorkflowDefinitionLink (companyId);_ [Sanitized]
13:04:25,180 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "W
orkflowDefinitionLink" because it does not exist or you do not have permissions.
: create index IX_A4DB1F0F on WorkflowDefinitionLink (companyId, workflowDefinit
ionName, workflowDefinitionVersion);_ [Sanitized]
13:04:25,196 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "W
orkflowDefinitionLink" because it does not exist or you do not have permissions.
: create index IX_B6EE8C9E on WorkflowDefinitionLink (groupId, companyId, classN
ameId);_ [Sanitized]
13:04:25,205 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "W
orkflowDefinitionLink" because it does not exist or you do not have permissions.
: create index IX_1E5B9905 on WorkflowDefinitionLink (groupId, companyId, classN
ameId, classPK);_ [Sanitized]
13:04:25,215 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "W
orkflowDefinitionLink" because it does not exist or you do not have permissions.
: create index IX_705B40EE on WorkflowDefinitionLink (groupId, companyId, classN
ameId, classPK, typePK);_ [Sanitized]
13:04:25,223 WARN  [localhost-startStop-1][BaseDB:457] Cannot find the object "W
orkflowInstanceLink" because it does not exist or you do not have permissions.:
create index IX_415A7007 on WorkflowInstanceLink (groupId, companyId, classNameI
d, classPK);_ [Sanitized]
13:04:25,291 WARN  [localhost-startStop-1][ReleaseLocalServiceImpl:288] Invalid
object name 'Release_'.
13:04:25,311 WARN  [localhost-startStop-1][ReleaseLocalServiceImpl:288] Invalid
object name 'Release_'.
13:04:25,314 ERROR [localhost-startStop-1][MainServlet:209] com.liferay.portal.k
ernel.events.ActionException: com.liferay.portal.kernel.exception.SystemExceptio
n: Release_ table was not initialized properly
com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.exce
ption.SystemException: Release_ table was not initialized properly
  at com.liferay.portal.events.StartupAction.run(StartupAction.java:74)
   at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.ja
va:1238)
   at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:206)
    at javax.servlet.GenericServlet.init(GenericServlet.java:160)
   at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:
1266)
      at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.ja
va:1185)
      at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1080
)
     at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.j
ava:5027)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.ja
va:5314)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
 at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:9
01)
      at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)

      at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:633)
        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:977)

        at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:
1655)
   at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
      at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
   at java.util.concurrent.FutureTask.run(FutureTask.java:138)
     at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecuto
r.java:886)
  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:
908)
      at java.lang.Thread.run(Thread.java:662)
Caused by: com.liferay.portal.kernel.exception.SystemException: Release_ table w
as not initialized properly
     at com.liferay.portal.service.impl.ReleaseLocalServiceImpl.testSupportsStri
ngCaseSensitiveQuery(ReleaseLocalServiceImpl.java:250)
       at com.liferay.portal.service.impl.ReleaseLocalServiceImpl.getBuildNumber
OrCreate(ReleaseLocalServiceImpl.java:185)
     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:3
9)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
     at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(Servic
eBeanMethodInvocation.java:115)
      at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.execut
e(DefaultTransactionExecutor.java:62)
 at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(Transact
ionInterceptor.java:51)
  at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBe
anMethodInvocation.java:111)
      at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMet
hodAdvice.java:56)
    at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(Service
BeanMethodInvocation.java:111)
      at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMet
hodAdvice.java:56)
    at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(Service
BeanMethodInvocation.java:111)
      at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMet
hodAdvice.java:56)
    at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(Service
BeanMethodInvocation.java:111)
      at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMet
hodAdvice.java:56)
    at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(Service
BeanMethodInvocation.java:111)
      at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMet
hodAdvice.java:56)
    at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(Service
BeanMethodInvocation.java:111)
      at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMet
hodAdvice.java:56)
    at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(Service
BeanMethodInvocation.java:111)
      at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMet
hodAdvice.java:56)
    at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(Service
BeanMethodInvocation.java:111)
      at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMet
hodAdvice.java:56)
    at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(Service
BeanMethodInvocation.java:111)
      at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMet
hodAdvice.java:56)
    at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(Service
BeanMethodInvocation.java:111)
      at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAop
Proxy.java:175)
       at $Proxy77.getBuildNumberOrCreate(Unknown Source)
      at com.liferay.portal.service.ReleaseLocalServiceUtil.getBuildNumberOrCrea
te(ReleaseLocalServiceUtil.java:290)
  at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:102)
     at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:160)
        at com.liferay.portal.ee.license.StartupAction.doRun(Unknown Source)
    at com.liferay.portal.events.StartupAction.run(StartupAction.java:68)
   ... 20 more
Stopping the server due to unexpected startup errors

Any ideas?

[9年前 に Clay Banks によって更新されました。]

Turns out it was a DDL permission that I did not possess. Once I obtained this I was able to auto-create the tables.

More info on DDL: http://en.wikipedia.org/wiki/Data_definition_language