Unable to startup the latest version of dotcms, missing database tables

205 views

Skip to first unread message

vince...@gmail.com

unread,

Mar 18, 2016, 7:37:34 AM3/18/16

to dotCMS User Group

Hi All,

I am new to dotcms. I download the latest version of dotcms dotcms_3.3.1.zip and try to install it but I got some issues.

I followed the steps mentioned here https://dotcms.com/docs/latest/quick-start-guide , but still got no lucky.

1. I am using mysql, and followed http://dotcms.com/docs/latest/database-configuration to create the database. After execute the command "create database dotcms default character set = utf8 default collate = utf8_general_ci;" the table is created and there is no table available. I stopped and restarted mysql

2. I unzip the dotcms_3.3.1.zip, updated the mysql configuration at C:\Users\344773\Downloads\dotcms\dotserver\tomcat-8.0.18\webapps\ROOT\META-INF\context.xml , below is my config

<Resource name="jdbc/dotCMSPool" auth="Container"

type="javax.sql.DataSource" driverClassName="com.mysql.jdbc.Driver"

url="jdbc:mysql://localhost/dotcms?characterEncoding=UTF-8"

username="xxx" password="xxx" maxTotal="60" maxIdle="10" maxWaitMillis="60000"

removeAbandonedOnBorrow="true" removeAbandonedOnMaintenance="true" removeAbandonedTimeout="60" logAbandoned="true"

timeBetweenEvictionRunsMillis="30000" validationQuery="SELECT 1" testOnBorrow="true" testWhileIdle="true" />

3. I executed the command "C:\Users\344773\Downloads\dotcms\bin\startup.bat"

4. Server is up, but with errors in the log file. Basically it told me some table does not exists. Below is full log file.

[18/03/16 12:03:02:937 CST] INFO util.AsciiArt:

[18/03/16 12:03:02:942 CST] INFO util.AsciiArt:

[18/03/16 12:03:02:942 CST] INFO util.AsciiArt: OOOO 7777777 7777 7777 77777777

[18/03/16 12:03:02:942 CST] INFO util.AsciiArt: OOOO OO 777777777 77777 77777 77777777

[18/03/16 12:03:02:942 CST] INFO util.AsciiArt: OOOO OOO 77777 777777 77777 7777

[18/03/16 12:03:02:942 CST] INFO util.AsciiArt: OOOOOOOOOO OOOOOOOO OOOOOOOOO 7777 7777777 777777 7777

[18/03/16 12:03:02:942 CST] INFO util.AsciiArt: OOOO OOOOO OOOO OOOO OOOO 7777 7777777 7777777 777777

[18/03/16 12:03:02:943 CST] INFO util.AsciiArt: OOOO OOOO OOO OOOO OOOO 7777 77777777 777 7777 777777

[18/03/16 12:03:02:943 CST] INFO util.AsciiArt: OOOO OOOO OOOO OOOO OOOO 7777 777 777 777 7777 7777

[18/03/16 12:03:02:943 CST] INFO util.AsciiArt: OOOO OOOO OOO OOOO OOOO 77777 777 777777 7777 7777

[18/03/16 12:03:02:943 CST] INFO util.AsciiArt: OOOO OOOO OOOO OOO OOOO 77777 777 7777 7777 7777

[18/03/16 12:03:02:943 CST] INFO util.AsciiArt: OOOOOOOOOO OOOOOOOO OOOOO 777777777 777 7777 7777 777777777

[18/03/16 12:03:02:943 CST] INFO util.AsciiArt:

[18/03/16 12:03:02:943 CST] INFO util.AsciiArt: Content Management System

[18/03/16 12:03:02:943 CST] INFO util.AsciiArt:

[18/03/16 12:03:03:960 CST] INFO util.OSGIUtil: Felix dir: C:\Users\344773\Downloads\dotcms\dotserver\tomcat-8.0.18\webapps\ROOT\WEB-INF\felix

[18/03/16 12:03:03:970 CST] INFO util.OSGIUtil: Loading property felix.auto.deploy.action=install,start

[18/03/16 12:03:03:971 CST] INFO util.OSGIUtil: Loading property felix.fileinstall.start.level=1

[18/03/16 12:03:03:971 CST] INFO util.OSGIUtil: Loading property felix.fileinstall.log.level=3

[18/03/16 12:03:03:971 CST] INFO util.OSGIUtil: Loading property org.osgi.framework.startlevel.beginning=2

[18/03/16 12:03:03:972 CST] INFO util.OSGIUtil: Loading property org.osgi.framework.storage.clean=onFirstInit

[18/03/16 12:03:03:972 CST] INFO util.OSGIUtil: Loading property felix.log.level=4

[18/03/16 12:03:05:324 CST] INFO util.OSGIUtil: Loading Factory com.dotcms.repackage.org.apache.felix.framework.FrameworkFactory

[18/03/16 12:03:07:667 CST] INFO util.OSGIUtil: osgi felix framework started

[18/03/16 12:03:07:797 CST] INFO server.CMISServiceFactoryImpl: Initializing in-memory repository...

[18/03/16 12:03:07:846 CST] INFO server.CMISServiceFactoryImpl: ...initialized in-memory repository.

[18/03/16 12:03:07:846 CST] INFO impl.CmisRepositoryContextListener: Initialized Services Factory: com.dotcms.enterprise.cmis.server.CMISServiceFactoryImpl

[18/03/16 12:03:07:901 CST] INFO util.SystemProperties: Loading file:/C:/Users/344773/Downloads/dotcms/dotserver/tomcat-8.0.18/webapps/ROOT/WEB-INF/classes/system.properties

[18/03/16 12:03:07:903 CST] INFO util.SystemProperties: Loading file:/C:/Users/344773/Downloads/dotcms/dotserver/tomcat-8.0.18/webapps/ROOT/WEB-INF/classes/system-ext.properties

[18/03/16 12:03:07:937 CST] INFO util.PropsLoader: Loading file:/C:/Users/344773/Downloads/dotcms/dotserver/tomcat-8.0.18/webapps/ROOT/WEB-INF/classes/portal.properties

[18/03/16 12:03:07:938 CST] INFO util.PropsLoader: Loading file:/C:/Users/344773/Downloads/dotcms/dotserver/tomcat-8.0.18/webapps/ROOT/WEB-INF/classes/portal-ext.properties

[18/03/16 12:03:08:491 CST] INFO business.CacheLocator: loading cache administrator: com.dotmarketing.business.ChainableCacheAdministratorImpl

[18/03/16 12:03:09:157 CST] INFO guava.GuavaCache: *** Cache Config Memory : default: 1000

[18/03/16 12:03:09:158 CST] INFO guava.GuavaCache: *** Cache Config Memory : livecache: 1000

[18/03/16 12:03:09:158 CST] INFO guava.GuavaCache: *** Cache Config Memory : workingcache: 1000

[18/03/16 12:03:09:158 CST] INFO guava.GuavaCache: *** Cache Config Memory : adminconfigpool: 100

[18/03/16 12:03:09:158 CST] INFO guava.GuavaCache: *** Cache Config Memory : blockdirectivecache: 1000

[18/03/16 12:03:09:158 CST] INFO guava.GuavaCache: *** Cache Config Memory : categorybykeycache: 1000

[18/03/16 12:03:09:158 CST] INFO guava.GuavaCache: *** Cache Config Memory : categorycache: 1000

[18/03/16 12:03:09:158 CST] INFO guava.GuavaCache: *** Cache Config Memory : categorychildrencache: 1000

[18/03/16 12:03:09:158 CST] INFO guava.GuavaCache: *** Cache Config Memory : categoryparentscache: 1000

[18/03/16 12:03:09:158 CST] INFO guava.GuavaCache: *** Cache Config Memory : companypool: 10

[18/03/16 12:03:09:158 CST] INFO guava.GuavaCache: *** Cache Config Memory : contentletcache: 5000

[18/03/16 12:03:09:159 CST] INFO guava.GuavaCache: *** Cache Config Memory : fileassetmetadatacache: 200

[18/03/16 12:03:09:159 CST] INFO guava.GuavaCache: *** Cache Config Memory : dotcmslayoutcache: 1000

[18/03/16 12:03:09:159 CST] INFO guava.GuavaCache: *** Cache Config Memory : dotcmsrolecache: 1000

[18/03/16 12:03:09:159 CST] INFO guava.GuavaCache: *** Cache Config Memory : dotcmsrolekeycache: 1000

[18/03/16 12:03:09:159 CST] INFO guava.GuavaCache: *** Cache Config Memory : dotcmsuserrolecache: 1000

[18/03/16 12:03:09:159 CST] INFO guava.GuavaCache: *** Cache Config Memory : fieldscache: 1000

[18/03/16 12:03:09:159 CST] INFO guava.GuavaCache: *** Cache Config Memory : filecache: 1000

[18/03/16 12:03:09:159 CST] INFO guava.GuavaCache: *** Cache Config Memory : foldercache: 1000

[18/03/16 12:03:09:159 CST] INFO guava.GuavaCache: *** Cache Config Memory : hostaliascache: 1000

[18/03/16 12:03:09:159 CST] INFO guava.GuavaCache: *** Cache Config Memory : hostcache: 1000

[18/03/16 12:03:09:160 CST] INFO guava.GuavaCache: *** Cache Config Memory : hostvariablescache: 1000

[18/03/16 12:03:09:160 CST] INFO guava.GuavaCache: *** Cache Config Memory : htmlpagecache: 1000

[18/03/16 12:03:09:160 CST] INFO guava.GuavaCache: *** Cache Config Memory : identifiercache: 50000

[18/03/16 12:03:09:160 CST] INFO guava.GuavaCache: *** Cache Config Memory : languagecacheimpl: 1000

[18/03/16 12:03:09:160 CST] INFO guava.GuavaCache: *** Cache Config Memory : navcache: 1000

[18/03/16 12:03:09:160 CST] INFO guava.GuavaCache: *** Cache Config Memory : parentpermissionablecache: 10000

[18/03/16 12:03:09:160 CST] INFO guava.GuavaCache: *** Cache Config Memory : permissioncache: 50000

[18/03/16 12:03:09:160 CST] INFO guava.GuavaCache: *** Cache Config Memory : plugincache: 1000

[18/03/16 12:03:09:160 CST] INFO guava.GuavaCache: *** Cache Config Memory : portletpool: 100

[18/03/16 12:03:09:160 CST] INFO guava.GuavaCache: *** Cache Config Memory : structurecache: 500

[18/03/16 12:03:09:161 CST] INFO guava.GuavaCache: *** Cache Config Memory : templatecache: 500

[18/03/16 12:03:09:161 CST] INFO guava.GuavaCache: *** Cache Config Memory : userdotcmscache: 1000

[18/03/16 12:03:09:161 CST] INFO guava.GuavaCache: *** Cache Config Memory : useremaildotcmscache: 1000

[18/03/16 12:03:09:161 CST] INFO guava.GuavaCache: *** Cache Config Memory : userproxycache: 1000

[18/03/16 12:03:09:161 CST] INFO guava.GuavaCache: *** Cache Config Memory : velocitycache: 1000

[18/03/16 12:03:09:161 CST] INFO guava.GuavaCache: *** Cache Config Memory : velocitymenucache: 1000

[18/03/16 12:03:09:162 CST] INFO guava.GuavaCache: *** Cache Config Memory : velocitymisscache: 1000

[18/03/16 12:03:09:162 CST] INFO guava.GuavaCache: *** Cache Config Memory : versioncache: 50000

[18/03/16 12:03:09:162 CST] INFO guava.GuavaCache: *** Cache Config Memory : versioninfocache: 50000

[18/03/16 12:03:09:162 CST] INFO guava.GuavaCache: *** Cache Config Memory : virtuallinkscache: 1000

[18/03/16 12:03:09:162 CST] INFO guava.GuavaCache: *** Cache Config Memory : workflowcache: 1000

[18/03/16 12:03:09:162 CST] INFO guava.GuavaCache: *** Cache Config Memory : workflowstepcache: 1000

[18/03/16 12:03:09:162 CST] INFO guava.GuavaCache: *** Cache Config Memory : workflowtaskcache: 10000

[18/03/16 12:03:09:162 CST] INFO guava.GuavaCache: *** Cache Config Memory : indiciescache: 8

[18/03/16 12:03:09:162 CST] INFO guava.GuavaCache: *** Cache Config Memory : publishingendpointcache: 100

[18/03/16 12:03:09:162 CST] INFO guava.GuavaCache: *** Cache Config Memory : workflowactioncache: 10000

[18/03/16 12:03:09:162 CST] INFO guava.GuavaCache: *** Cache Config Memory : logmappercache: 10

[18/03/16 12:03:09:163 CST] INFO guava.GuavaCache: *** Cache Config Memory : translatedquerycache: 5000

[18/03/16 12:03:09:163 CST] INFO guava.GuavaCache: *** Cache Config Memory : csscache: 2500

[18/03/16 12:03:09:163 CST] INFO guava.GuavaCache: *** Cache Config Memory : dotcmsrootrolescache: 1000

[18/03/16 12:03:09:163 CST] INFO guava.GuavaCache: *** Cache Config Memory : identifier404cache: 1000

[18/03/16 12:03:09:163 CST] INFO guava.GuavaCache: *** Cache Config Memory : fieldsvarcache: 1000

[18/03/16 12:03:09:163 CST] INFO guava.GuavaCache: *** Cache Config Memory : relationshipcachebyname: 1000

[18/03/16 12:03:09:163 CST] INFO guava.GuavaCache: *** Cache Config Memory : relationshipcachebyinode: 1000

[18/03/16 12:03:09:163 CST] INFO guava.GuavaCache: *** Cache Config Memory : propertycache: 1000

[18/03/16 12:03:09:163 CST] INFO guava.GuavaCache: *** Cache Config Memory : containercache: 1000

[18/03/16 12:03:09:163 CST] INFO guava.GuavaCache: *** Cache Config Memory : newnotificationcache: 1000

[18/03/16 12:03:09:164 CST] INFO guava.GuavaCache: *** Cache Config Memory : containerstructurecache: 1000

[18/03/16 12:03:09:492 CST] INFO guava.GuavaCache: *** Building Cache : structurecache, size:500,Concurrency:32

[18/03/16 12:03:17:470 CST] INFO tiles.TilesPlugin: Tiles definition factory loaded for module ''.

[18/03/16 12:03:17:486 CST] INFO validator.ValidatorPlugIn: Loading validation rules file from '/WEB-INF/validator-rules.xml'

[18/03/16 12:03:17:488 CST] INFO validator.ValidatorPlugIn: Loading validation rules file from '/WEB-INF/validation.xml'

[18/03/16 12:03:18:686 CST] INFO startup.StartupTasksExecutor: Starting startup tasks.

[18/03/16 12:03:18:727 CST] INFO cfg.Environment: Hibernate 2.1.8

[18/03/16 12:03:18:728 CST] INFO cfg.Environment: hibernate.properties not found

[18/03/16 12:03:18:736 CST] INFO cfg.Environment: using JDK 1.4 java.sql.Timestamp handling

[18/03/16 12:03:18:748 CST] INFO cfg.Configuration: configuring from resource: /hibernate.cfg.xml

[18/03/16 12:03:18:749 CST] INFO cfg.Configuration: Configuration resource: /hibernate.cfg.xml

[18/03/16 12:03:19:226 CST] INFO cfg.Configuration: Configured SessionFactory: null

[18/03/16 12:03:19:231 CST] INFO cfg.Configuration: Mapping resource: com/dotmarketing/beans/DotCMSId.hbm.xml

[18/03/16 12:03:19:605 CST] INFO cfg.Binder: Mapping class: com.dotmarketing.beans.Inode -> inode

[18/03/16 12:03:19:840 CST] INFO cfg.Binder: Mapping joined-subclass: com.dotmarketing.portlets.categories.model.Category -> category

[18/03/16 12:03:19:846 CST] INFO cfg.Binder: Mapping joined-subclass: com.dotmarketing.portlets.files.model.File -> file_asset

[18/03/16 12:03:19:855 CST] INFO cfg.Binder: Mapping joined-subclass: com.dotmarketing.portlets.contentlet.business.Contentlet -> contentlet

[18/03/16 12:03:19:868 CST] INFO cfg.Binder: Mapping joined-subclass: com.dotmarketing.portlets.containers.model.Container -> containers

[18/03/16 12:03:19:870 CST] INFO cfg.Binder: Mapping joined-subclass: com.dotmarketing.portlets.folders.model.Folder -> folder

[18/03/16 12:03:19:872 CST] INFO cfg.Binder: Mapping joined-subclass: com.dotmarketing.portlets.templates.model.Template -> template

[18/03/16 12:03:19:879 CST] INFO cfg.Binder: Mapping joined-subclass: com.dotmarketing.portlets.htmlpages.model.HTMLPage -> htmlpage

[18/03/16 12:03:19:882 CST] INFO cfg.Binder: Mapping joined-subclass: com.dotmarketing.portlets.links.model.Link -> links

[18/03/16 12:03:19:890 CST] INFO cfg.Binder: Mapping joined-subclass: com.dotmarketing.portlets.mailinglists.model.MailingList -> mailing_list

[18/03/16 12:03:19:896 CST] INFO cfg.Binder: Mapping joined-subclass: com.dotmarketing.portlets.campaigns.model.Campaign -> campaign

[18/03/16 12:03:19:901 CST] INFO cfg.Binder: Mapping joined-subclass: com.dotmarketing.portlets.campaigns.model.Recipient -> recipient

[18/03/16 12:03:19:905 CST] INFO cfg.Binder: Mapping joined-subclass: com.dotmarketing.portlets.campaigns.model.Click -> click

[18/03/16 12:03:19:910 CST] INFO cfg.Binder: Mapping joined-subclass: com.dotmarketing.portlets.communications.model.Communication -> communication

[18/03/16 12:03:19:915 CST] INFO cfg.Binder: Mapping joined-subclass: com.dotmarketing.beans.UserProxy -> user_proxy

[18/03/16 12:03:19:924 CST] INFO cfg.Binder: Mapping joined-subclass: com.dotmarketing.portlets.virtuallinks.model.VirtualLink -> virtual_link

[18/03/16 12:03:19:924 CST] INFO cfg.Binder: Mapping joined-subclass: com.dotmarketing.portlets.structure.model.Structure -> structure

[18/03/16 12:03:19:929 CST] INFO cfg.Binder: Mapping joined-subclass: com.dotmarketing.portlets.structure.model.Relationship -> relationship

[18/03/16 12:03:19:934 CST] INFO cfg.Binder: Mapping joined-subclass: com.dotmarketing.portlets.structure.model.Field -> field

[18/03/16 12:03:19:939 CST] INFO cfg.Binder: Mapping joined-subclass: com.dotmarketing.portlets.user.model.UserComment -> user_comments

[18/03/16 12:03:19:944 CST] INFO cfg.Binder: Mapping joined-subclass: com.dotmarketing.portlets.userfilter.model.UserFilter -> user_filter

[18/03/16 12:03:19:950 CST] INFO cfg.Binder: Mapping joined-subclass: com.dotmarketing.portlets.report.model.Report -> report_asset

[18/03/16 12:03:19:954 CST] INFO cfg.Binder: Mapping joined-subclass: com.dotmarketing.portlets.report.model.ReportParameter -> report_parameter

[18/03/16 12:03:19:959 CST] INFO cfg.Binder: Mapping class: com.dotmarketing.portlets.workflows.model.WorkflowTask -> workflow_task

[18/03/16 12:03:19:964 CST] INFO cfg.Binder: Mapping class: com.dotmarketing.portlets.workflows.model.WorkflowComment -> workflow_comment

[18/03/16 12:03:19:968 CST] INFO cfg.Binder: Mapping class: com.dotmarketing.portlets.workflows.model.WorkflowHistory -> workflow_history

[18/03/16 12:03:19:973 CST] INFO cfg.Binder: Mapping class: com.dotmarketing.portlets.workflows.model.WorkFlowTaskFiles -> workflowtask_files

[18/03/16 12:03:19:977 CST] INFO cfg.Binder: Mapping class: com.dotmarketing.beans.Permission -> permission

[18/03/16 12:03:19:978 CST] INFO cfg.Binder: Mapping class: com.dotmarketing.beans.PermissionReference -> permission_reference

[18/03/16 12:03:19:982 CST] INFO cfg.Binder: Mapping class: com.dotmarketing.beans.Tree -> tree

[18/03/16 12:03:20:316 CST] INFO cfg.Binder: Mapping class: com.dotmarketing.beans.MultiTree -> multi_tree

[18/03/16 12:03:20:328 CST] INFO cfg.Binder: Mapping class: com.dotmarketing.portlets.user.model.UserPreference -> user_preferences

[18/03/16 12:03:20:333 CST] INFO cfg.Binder: Mapping class: com.dotmarketing.portlets.languagesmanager.model.Language -> language

[18/03/16 12:03:20:333 CST] INFO cfg.Binder: Mapping class: com.dotmarketing.beans.Clickstream -> clickstream

[18/03/16 12:03:20:368 CST] INFO cfg.Binder: Mapping class: com.dotmarketing.beans.ClickstreamRequest -> clickstream_request

[18/03/16 12:03:20:372 CST] INFO cfg.Binder: Mapping class: com.dotmarketing.beans.Clickstream404 -> clickstream_404

[18/03/16 12:03:20:377 CST] INFO cfg.Binder: Mapping class: com.dotmarketing.portlets.webforms.model.WebForm -> web_form

[18/03/16 12:03:20:382 CST] INFO cfg.Binder: Mapping class: com.dotmarketing.beans.Rating -> content_rating

[18/03/16 12:03:20:404 CST] INFO cfg.Binder: Mapping class: com.dotmarketing.tag.model.Tag -> tag

[18/03/16 12:03:20:409 CST] INFO cfg.Binder: Mapping class: com.dotmarketing.tag.model.TagInode -> tag_inode

[18/03/16 12:03:20:417 CST] INFO cfg.Binder: Mapping class: com.dotmarketing.beans.ChallengeQuestion -> challenge_question

[18/03/16 12:03:20:421 CST] INFO cfg.Binder: Mapping class: com.dotmarketing.beans.Trackback -> trackback

[18/03/16 12:03:20:426 CST] INFO cfg.Binder: Mapping class: com.dotmarketing.beans.UsersToDelete -> users_to_delete

[18/03/16 12:03:20:430 CST] INFO cfg.Binder: Mapping class: com.dotmarketing.portlets.calendar.model.CalendarReminder -> calendar_reminder

[18/03/16 12:03:20:439 CST] INFO cfg.Binder: Mapping class: com.dotmarketing.portlets.chains.model.Chain -> chain

[18/03/16 12:03:20:444 CST] INFO cfg.Binder: Mapping class: com.dotmarketing.portlets.chains.model.ChainState -> chain_state

[18/03/16 12:03:20:448 CST] INFO cfg.Binder: Mapping class: com.dotmarketing.portlets.chains.model.ChainLinkCode -> chain_link_code

[18/03/16 12:03:20:452 CST] INFO cfg.Binder: Mapping class: com.dotmarketing.portlets.chains.model.ChainStateParameter -> chain_state_parameter

[18/03/16 12:03:20:457 CST] INFO cfg.Binder: Mapping class: com.dotmarketing.plugin.model.Plugin -> plugin

[18/03/16 12:03:20:462 CST] INFO cfg.Binder: Mapping class: com.dotmarketing.business.Role -> cms_role

[18/03/16 12:03:20:466 CST] INFO cfg.Binder: Mapping class: com.dotmarketing.business.UsersRoles -> users_cms_roles

[18/03/16 12:03:20:470 CST] INFO cfg.Binder: Mapping class: com.dotmarketing.business.LayoutsRoles -> layouts_cms_roles

[18/03/16 12:03:20:475 CST] INFO cfg.Binder: Mapping class: com.dotmarketing.business.Layout -> cms_layout

[18/03/16 12:03:20:479 CST] INFO cfg.Binder: Mapping class: com.dotmarketing.business.PortletsLayouts -> cms_layouts_portlets

[18/03/16 12:03:20:484 CST] INFO cfg.Binder: Mapping class: com.dotmarketing.portlets.hostvariable.model.HostVariable -> host_variable

[18/03/16 12:03:20:488 CST] INFO cfg.Binder: Mapping class: com.dotmarketing.beans.FixAudit -> fixes_audit

[18/03/16 12:03:20:493 CST] INFO cfg.Binder: Mapping class: com.dotmarketing.beans.Identifier -> identifier

[18/03/16 12:03:20:498 CST] INFO cfg.Binder: Mapping class: com.dotmarketing.beans.TemplateContainers -> template_containers

[18/03/16 12:03:20:502 CST] INFO cfg.Binder: Mapping class: com.dotmarketing.beans.ContainerStructure -> container_structures

[18/03/16 12:03:20:507 CST] INFO cfg.Binder: Mapping class: com.dotmarketing.portlets.dashboard.model.DashboardWorkStream -> analytic_summary_workstream

[18/03/16 12:03:20:511 CST] INFO cfg.Binder: Mapping class: com.dotmarketing.portlets.dashboard.model.DashboardSummaryPeriod -> analytic_summary_period

[18/03/16 12:03:20:515 CST] INFO cfg.Binder: Mapping class: com.dotmarketing.portlets.dashboard.model.DashboardSummaryVisits -> analytic_summary_visits

[18/03/16 12:03:20:522 CST] INFO cfg.Binder: Mapping class: com.dotmarketing.portlets.dashboard.model.DashboardSummary404 -> analytic_summary_404

[18/03/16 12:03:20:530 CST] INFO cfg.Binder: Mapping class: com.dotmarketing.portlets.dashboard.model.DashboardUserPreferences -> dashboard_user_preferences

[18/03/16 12:03:20:535 CST] INFO cfg.Binder: Mapping class: com.dotmarketing.portlets.dashboard.model.DashboardSummary -> analytic_summary

[18/03/16 12:03:20:539 CST] INFO cfg.Binder: Mapping class: com.dotmarketing.portlets.dashboard.model.DashboardSummaryReferer -> analytic_summary_referer

[18/03/16 12:03:20:543 CST] INFO cfg.Binder: Mapping class: com.dotmarketing.portlets.dashboard.model.DashboardSummaryPage -> analytic_summary_pages

[18/03/16 12:03:20:547 CST] INFO cfg.Binder: Mapping class: com.dotmarketing.portlets.dashboard.model.DashboardSummaryContent -> analytic_summary_content

[18/03/16 12:03:20:555 CST] INFO cfg.Binder: Mapping class: com.dotmarketing.portlets.files.model.FileAssetVersionInfo -> fileasset_version_info

[18/03/16 12:03:20:559 CST] INFO cfg.Binder: Mapping class: com.dotmarketing.portlets.contentlet.model.ContentletVersionInfo -> contentlet_version_info

[18/03/16 12:03:20:571 CST] INFO cfg.Binder: Mapping class: com.dotmarketing.portlets.templates.model.TemplateVersionInfo -> template_version_info

[18/03/16 12:03:20:575 CST] INFO cfg.Binder: Mapping class: com.dotmarketing.portlets.htmlpages.model.HTMLPageVersionInfo -> htmlpage_version_info

[18/03/16 12:03:20:580 CST] INFO cfg.Binder: Mapping class: com.dotmarketing.portlets.containers.model.ContainerVersionInfo -> container_version_info

[18/03/16 12:03:20:584 CST] INFO cfg.Binder: Mapping class: com.dotmarketing.portlets.links.model.LinkVersionInfo -> link_version_info

[18/03/16 12:03:20:588 CST] INFO cfg.Binder: Mapping class: com.dotmarketing.portlets.structure.model.FieldVariable -> field_variable

[18/03/16 12:03:20:588 CST] INFO cfg.Configuration: Mapping resource: com/dotmarketing/beans/DotCMSId_NOSQLGEN.hbm.xml

[18/03/16 12:03:20:617 CST] INFO cfg.Binder: Mapping class: com.dotmarketing.plugin.model.PluginProperty -> plugin_property

[18/03/16 12:03:20:632 CST] INFO cfg.Configuration: processing one-to-many association mappings

[18/03/16 12:03:20:633 CST] INFO cfg.Binder: Mapping collection: com.dotmarketing.beans.Clickstream.clickstreamRequests -> clickstream_request

[18/03/16 12:03:20:633 CST] INFO cfg.Binder: Mapping collection: com.dotmarketing.portlets.dashboard.model.DashboardSummary404.userPreferences -> dashboard_user_preferences

[18/03/16 12:03:20:633 CST] INFO cfg.Configuration: processing one-to-one association property references

[18/03/16 12:03:20:633 CST] INFO cfg.Configuration: processing foreign key constraints

[18/03/16 12:03:20:674 CST] INFO dialect.Dialect: Using dialect: com.dotcms.repackage.net.sf.hibernate.dialect.MySQLDialect

[18/03/16 12:03:20:692 CST] INFO cfg.SettingsFactory: Maximim outer join fetch depth: 2

[18/03/16 12:03:20:692 CST] INFO cfg.SettingsFactory: Use outer join fetching: true

[18/03/16 12:03:20:696 CST] INFO connection.ConnectionProviderFactory: Initializing connection provider: com.liferay.util.dao.hibernate.DSConnectionProvider

[18/03/16 12:03:20:715 CST] INFO transaction.TransactionManagerLookupFactory: No TransactionManagerLookup configured (in JTA environment, use of process level read-write cache is not recommended)

[18/03/16 12:03:20:729 CST] INFO cfg.SettingsFactory: Use scrollable result sets: true

[18/03/16 12:03:20:729 CST] INFO cfg.SettingsFactory: Use JDBC3 getGeneratedKeys(): true

[18/03/16 12:03:20:729 CST] INFO cfg.SettingsFactory: Optimize cache for minimal puts: false

[18/03/16 12:03:20:729 CST] INFO cfg.SettingsFactory: Query language substitutions: {}

[18/03/16 12:03:20:729 CST] INFO cfg.SettingsFactory: cache provider: com.dotcms.repackage.net.sf.hibernate.cache.EhCacheProvider

[18/03/16 12:03:20:734 CST] INFO cfg.Configuration: instantiating and configuring caches

[18/03/16 12:03:20:959 CST] INFO impl.SessionFactoryImpl: building session factory

[18/03/16 12:03:22:594 CST] INFO impl.SessionFactoryObjectFactory: Not binding factory to JNDI, no JNDI name configured

[18/03/16 12:03:22:616 CST] INFO runalways.Task00001LoadSchema: -------------------------------------------------------------------------------------

[18/03/16 12:03:22:616 CST] INFO runalways.Task00001LoadSchema:

[18/03/16 12:03:22:616 CST] INFO runalways.Task00001LoadSchema: Empty dotCMS database found. Loading initial dotCMS schema for MySQL

[18/03/16 12:03:22:616 CST] INFO runalways.Task00001LoadSchema:

[18/03/16 12:03:22:616 CST] INFO runalways.Task00001LoadSchema: -------------------------------------------------------------------------------------

[18/03/16 12:03:22:619 CST] INFO startup.StartupTasksExecutor: Running: Task00001LoadSchema

[18/03/16 12:03:22:619 CST] INFO runalways.Task00001LoadSchema: Loading schema

[18/03/16 12:03:22:678 CST] INFO guava.GuavaCache: *** Building Cache : companypool, size:10,Concurrency:32

[18/03/16 12:03:22:790 CST] INFO cfg.Binder: Mapping class: com.dotcms.repackage.com.liferay.counter.ejb.CounterHBM -> Counter

[18/03/16 12:03:22:843 CST] INFO cfg.Binder: Mapping class: com.liferay.portal.ejb.AddressHBM -> Address

[18/03/16 12:03:22:870 CST] INFO cfg.Binder: Mapping class: com.liferay.portal.ejb.CompanyHBM -> Company

[18/03/16 12:03:22:885 CST] INFO cfg.Binder: Mapping class: com.liferay.portal.ejb.ImageHBM -> Image

[18/03/16 12:03:22:892 CST] INFO cfg.Binder: Mapping class: com.liferay.portal.ejb.PasswordTrackerHBM -> PasswordTracker

[18/03/16 12:03:22:899 CST] INFO cfg.Binder: Mapping class: com.liferay.portal.ejb.PortletHBM -> Portlet

[18/03/16 12:03:22:918 CST] INFO cfg.Binder: Mapping class: com.liferay.portal.ejb.PortletPreferencesHBM -> PortletPreferences

[18/03/16 12:03:22:935 CST] INFO cfg.Binder: Mapping class: com.liferay.portal.ejb.ReleaseHBM -> Release_

[18/03/16 12:03:22:943 CST] INFO cfg.Binder: Mapping class: com.liferay.portal.ejb.UserHBM -> User_

[18/03/16 12:03:22:953 CST] INFO cfg.Binder: Mapping class: com.liferay.portal.ejb.UserTrackerHBM -> UserTracker

[18/03/16 12:03:22:960 CST] INFO cfg.Binder: Mapping class: com.liferay.portal.ejb.UserTrackerPathHBM -> UserTrackerPath

[18/03/16 12:03:22:967 CST] INFO cfg.Binder: Mapping class: com.liferay.portlet.admin.ejb.AdminConfigHBM -> AdminConfig

[18/03/16 12:03:22:974 CST] INFO cfg.Binder: Mapping class: com.liferay.portlet.polls.ejb.PollsChoiceHBM -> PollsChoice

[18/03/16 12:03:22:991 CST] INFO cfg.Binder: Mapping class: com.liferay.portlet.polls.ejb.PollsDisplayHBM -> PollsDisplay

[18/03/16 12:03:23:010 CST] INFO cfg.Binder: Mapping class: com.liferay.portlet.polls.ejb.PollsQuestionHBM -> PollsQuestion

[18/03/16 12:03:23:020 CST] INFO cfg.Binder: Mapping class: com.liferay.portlet.polls.ejb.PollsVoteHBM -> PollsVote

[18/03/16 12:03:23:036 CST] INFO cfg.Configuration: processing one-to-many association mappings

[18/03/16 12:03:23:036 CST] INFO cfg.Configuration: processing one-to-one association property references

[18/03/16 12:03:23:036 CST] INFO cfg.Configuration: processing foreign key constraints

[18/03/16 12:03:23:047 CST] INFO dialect.Dialect: Using dialect: null

[18/03/16 12:03:23:065 CST] INFO dialect.Dialect: Using dialect: com.dotcms.repackage.net.sf.hibernate.dialect.MySQLDialect

[18/03/16 12:03:23:065 CST] INFO cfg.SettingsFactory: Maximim outer join fetch depth: 2

[18/03/16 12:03:23:066 CST] INFO cfg.SettingsFactory: Use outer join fetching: true

[18/03/16 12:03:23:066 CST] INFO connection.ConnectionProviderFactory: Initializing connection provider: com.liferay.util.dao.hibernate.DSConnectionProvider

[18/03/16 12:03:23:066 CST] INFO transaction.TransactionManagerLookupFactory: No TransactionManagerLookup configured (in JTA environment, use of process level read-write cache is not recommended)

[18/03/16 12:03:23:068 CST] INFO cfg.SettingsFactory: Use scrollable result sets: true

[18/03/16 12:03:23:068 CST] INFO cfg.SettingsFactory: Use JDBC3 getGeneratedKeys(): true

[18/03/16 12:03:23:068 CST] INFO cfg.SettingsFactory: Optimize cache for minimal puts: false

[18/03/16 12:03:23:068 CST] INFO cfg.SettingsFactory: Query language substitutions: {}

[18/03/16 12:03:23:068 CST] INFO cfg.SettingsFactory: cache provider: com.dotcms.repackage.net.sf.hibernate.cache.EhCacheProvider

[18/03/16 12:03:23:068 CST] INFO cfg.Configuration: instantiating and configuring caches

[18/03/16 12:03:23:069 CST] INFO impl.SessionFactoryImpl: building session factory

[18/03/16 12:03:23:152 CST] INFO impl.SessionFactoryObjectFactory: Not binding factory to JNDI, no JNDI name configured

[18/03/16 12:03:23:192 CST] WARN util.JDBCExceptionReporter: SQL Error: 1146, SQLState: 42S02

[18/03/16 12:03:23:192 CST] ERROR util.JDBCExceptionReporter: Table 'dotcms.company' doesn't exist

[18/03/16 12:03:23:207 CST] WARN util.JDBCExceptionReporter: SQL Error: 1146, SQLState: 42S02

[18/03/16 12:03:23:207 CST] ERROR util.JDBCExceptionReporter: Table 'dotcms.company' doesn't exist

[18/03/16 12:03:23:280 CST] ERROR servlets.UpdateQuartzCronJobsServlet: Table 'dotcms.qrtz_triggers' doesn't exist

com.dotmarketing.exception.DotDataException: Table 'dotcms.qrtz_triggers' doesn't exist

at com.dotmarketing.common.db.DotConnect.loadResult(DotConnect.java:233) ~[dotcms_3.3.1_2521e19.jar:?]

at com.dotmarketing.common.db.DotConnect.loadResults(DotConnect.java:353) ~[dotcms_3.3.1_2521e19.jar:?]

at com.dotmarketing.servlets.UpdateQuartzCronJobsServlet.init(UpdateQuartzCronJobsServlet.java:48) [dotcms_3.3.1_2521e19.jar:?]

at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1231) [catalina.jar:8.0.18]

at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1144) [catalina.jar:8.0.18]

at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1031) [catalina.jar:8.0.18]

at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4901) [catalina.jar:8.0.18]

at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5188) [catalina.jar:8.0.18]

at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) [catalina.jar:8.0.18]

at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725) [catalina.jar:8.0.18]

at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701) [catalina.jar:8.0.18]

at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:714) [catalina.jar:8.0.18]

at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1069) [catalina.jar:8.0.18]

at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1719) [catalina.jar:8.0.18]

at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) [?:1.7.0_72]

at java.util.concurrent.FutureTask.run(FutureTask.java:262) [?:1.7.0_72]

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [?:1.7.0_72]

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [?:1.7.0_72]

at java.lang.Thread.run(Thread.java:745) [?:1.7.0_72]

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'dotcms.qrtz_triggers' doesn't exist

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.7.0_72]

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) ~[?:1.7.0_72]

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.7.0_72]

at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[?:1.7.0_72]

at com.mysql.jdbc.Util.handleNewInstance(Util.java:404) ~[mysql-connector-java-5.1.37-bin.jar:5.1.37]

at com.mysql.jdbc.Util.getInstance(Util.java:387) ~[mysql-connector-java-5.1.37-bin.jar:5.1.37]

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:941) ~[mysql-connector-java-5.1.37-bin.jar:5.1.37]

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3870) ~[mysql-connector-java-5.1.37-bin.jar:5.1.37]

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3806) ~[mysql-connector-java-5.1.37-bin.jar:5.1.37]

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2470) ~[mysql-connector-java-5.1.37-bin.jar:5.1.37]

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2617) ~[mysql-connector-java-5.1.37-bin.jar:5.1.37]

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2550) ~[mysql-connector-java-5.1.37-bin.jar:5.1.37]

at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861) ~[mysql-connector-java-5.1.37-bin.jar:5.1.37]

at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1962) ~[mysql-connector-java-5.1.37-bin.jar:5.1.37]

at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:82) ~[tomcat-dbcp.jar:8.0.18]

at com.dotmarketing.common.db.DotConnect.executeQuery(DotConnect.java:577) ~[dotcms_3.3.1_2521e19.jar:?]

at com.dotmarketing.common.db.DotConnect.executeQuery(DotConnect.java:489) ~[dotcms_3.3.1_2521e19.jar:?]

at com.dotmarketing.common.db.DotConnect.loadResult(DotConnect.java:231) ~[dotcms_3.3.1_2521e19.jar:?]

... 18 more

[18/03/16 12:03:23:459 CST] INFO guava.GuavaCache: *** Building Cache : languagecacheimpl, size:1000,Concurrency:32

[18/03/16 12:03:23:533 CST] WARN util.JDBCExceptionReporter: SQL Error: 1146, SQLState: 42S02

[18/03/16 12:03:23:533 CST] ERROR util.JDBCExceptionReporter: Table 'dotcms.language' doesn't exist

[18/03/16 12:03:23:534 CST] WARN util.JDBCExceptionReporter: SQL Error: 1146, SQLState: 42S02

[18/03/16 12:03:23:534 CST] ERROR util.JDBCExceptionReporter: Table 'dotcms.language' doesn't exist

[18/03/16 12:03:23:534 CST] ERROR business.LanguageFactoryImpl: getLanguage failed:com.dotmarketing.exception.DotRuntimeException: Could not execute query

com.dotmarketing.exception.DotRuntimeException: Could not execute query

at com.dotmarketing.db.HibernateUtil.load(HibernateUtil.java:436) ~[dotcms_3.3.1_2521e19.jar:?]

at com.dotmarketing.portlets.languagesmanager.business.LanguageFactoryImpl.getLanguage(LanguageFactoryImpl.java:73) [dotcms_3.3.1_2521e19.jar:?]

at com.dotmarketing.portlets.languagesmanager.business.LanguageFactoryImpl.getDefaultLanguage(LanguageFactoryImpl.java:222) [dotcms_3.3.1_2521e19.jar:?]

at com.dotmarketing.portlets.languagesmanager.business.LanguageAPIImpl.getDefaultLanguage(LanguageAPIImpl.java:92) [dotcms_3.3.1_2521e19.jar:?]

at com.dotmarketing.servlets.BinaryExporterServlet.<init>(BinaryExporterServlet.java:79) [dotcms_3.3.1_2521e19.jar:?]

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.7.0_72]

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) [?:1.7.0_72]

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [?:1.7.0_72]

at java.lang.reflect.Constructor.newInstance(Constructor.java:526) [?:1.7.0_72]

at java.lang.Class.newInstance(Class.java:379) [?:1.7.0_72]

at org.apache.catalina.core.DefaultInstanceManager.newInstance(DefaultInstanceManager.java:121) [catalina.jar:8.0.18]

at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1095) [catalina.jar:8.0.18]