* INFO  2018-07-09 14:32:43,579 Following listners are registered: [org.hisp.dhis.sms.listener.DataValueSMSListener@39302c7a, org.hisp.dhis.sms.liste
ner.J2MEDataValueSMSListener@3d3387e, org.hisp.dhis.sms.listener.UnregisteredSMSListener@27c46f30, org.hisp.dhis.sms.listener.DhisMessageAlertListene
r@6e19c5c8, org.hisp.dhis.sms.listener.TrackedEntityRegistrationSMSListener@72ada530, org.hisp.dhis.sms.listener.ProgramStageDataEntrySMSListener@6cc
d4aa1, org.hisp.dhis.sms.listener.SingleEventListener@3b47a26b] (SmsConsumerThread.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:43,773 SQL Warning Code: 0, SQLState: 00000 (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:43,774 parse S_2: COMMIT (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:43,774 SQL Warning Code: 0, SQLState: 00000 (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:43,774 StartTransactionCommand (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:43,774 SQL Warning Code: 0, SQLState: 00000 (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:43,775 bind <unnamed> to S_2 (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:43,775 SQL Warning Code: 0, SQLState: 00000 (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:43,775 ProcessUtility (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:43,775 SQL Warning Code: 0, SQLState: 00000 (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:43,775 CommitTransactionCommand (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:43,776 SQL Warning Code: 0, SQLState: 00000 (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:43,776 CommitTransaction (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:43,776 SQL Warning Code: 0, SQLState: 00000 (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:43,776 name: unnamed; blockState:           END; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:  (SqlExceptionH
elper.java [localhost-startStop-1])
* INFO  2018-07-09 14:32:43,787 SMS consumer started (DefaultSmsConsumerService.java [localhost-startStop-1])
* INFO  2018-07-09 14:32:45,502 Session timeout set to 3600 seconds (DefaultAuthenticationSuccessHandler.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:45,838 RP discovery / realm validation disabled;  (RealmVerifier.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:46,746 SQL Warning Code: 0, SQLState: 00000 (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:46,747 bind <unnamed> to S_2 (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:46,747 SQL Warning Code: 0, SQLState: 00000 (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:46,747 StartTransactionCommand (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:46,747 SQL Warning Code: 0, SQLState: 00000 (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:46,747 ProcessUtility (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:46,748 SQL Warning Code: 0, SQLState: 00000 (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:46,748 CommitTransactionCommand (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:46,748 SQL Warning Code: 0, SQLState: 00000 (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:46,748 CommitTransaction (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:46,748 SQL Warning Code: 0, SQLState: 00000 (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:46,748 name: unnamed; blockState:           END; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:  (SqlExceptionH
elper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:46,802 SQL Warning Code: 0, SQLState: 00000 (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:46,803 bind <unnamed> to S_2 (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:46,803 SQL Warning Code: 0, SQLState: 00000 (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:46,803 StartTransactionCommand (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:46,802 SQL Warning Code: 0, SQLState: 00000 (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:46,803 bind <unnamed> to S_2 (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:46,803 SQL Warning Code: 0, SQLState: 00000 (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:46,803 StartTransactionCommand (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:46,803 SQL Warning Code: 0, SQLState: 00000 (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:46,804 ProcessUtility (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:46,804 SQL Warning Code: 0, SQLState: 00000 (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:46,804 CommitTransactionCommand (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:46,804 SQL Warning Code: 0, SQLState: 00000 (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:46,804 CommitTransaction (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:46,805 SQL Warning Code: 0, SQLState: 00000 (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:46,805 name: unnamed; blockState:           END; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:  (SqlExceptionHelper.java [localhost-startStop-1])
* INFO  2018-07-09 14:32:48,596 Version: 2.28, revision: a5da35f, build date: Mon Jul 09 06:22:45 IST 2018, database name: dhis2, database type: PostgreSQL, Java version: 1.8.0_131 (DefaultSystemService.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:48,598 SQL Warning Code: 0, SQLState: 00000 (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:48,599 bind <unnamed> to S_2 (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:48,599 SQL Warning Code: 0, SQLState: 00000 (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:48,599 StartTransactionCommand (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:48,599 SQL Warning Code: 0, SQLState: 00000 (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:48,599 ProcessUtility (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:48,599 SQL Warning Code: 0, SQLState: 00000 (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:48,600 CommitTransactionCommand (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:48,600 SQL Warning Code: 0, SQLState: 00000 (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:48,600 CommitTransaction (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:48,600 SQL Warning Code: 0, SQLState: 00000 (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:48,600 name: unnamed; blockState:           END; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:  (SqlExceptionHelper.java [localhost-startStop-1])
* INFO  2018-07-09 14:32:48,601 SMS configuration not found (DefaultSmsConfigurationManager.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:48,603 SQL Warning Code: 0, SQLState: 00000 (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:48,603 bind <unnamed> to S_2 (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:48,603 SQL Warning Code: 0, SQLState: 00000 (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:48,604 StartTransactionCommand (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:48,604 SQL Warning Code: 0, SQLState: 00000 (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:48,604 ProcessUtility (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:48,604 SQL Warning Code: 0, SQLState: 00000 (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:48,604 CommitTransactionCommand (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:48,604 SQL Warning Code: 0, SQLState: 00000 (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:48,605 CommitTransaction (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:48,605 CommitTransaction (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:48,605 SQL Warning Code: 0, SQLState: 00000 (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:48,605 name: unnamed; blockState:           END; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:  (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:48,610 SQL Warning Code: 0, SQLState: 00000 (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:48,610 bind <unnamed> to S_2 (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:48,610 SQL Warning Code: 0, SQLState: 00000 (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:48,611 StartTransactionCommand (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:48,611 SQL Warning Code: 0, SQLState: 00000 (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:48,611 ProcessUtility (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:48,611 SQL Warning Code: 0, SQLState: 00000 (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:48,611 CommitTransactionCommand (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:48,611 SQL Warning Code: 0, SQLState: 00000 (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:48,612 CommitTransaction (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:48,612 SQL Warning Code: 0, SQLState: 00000 (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:48,612 name: unnamed; blockState:           END; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:  (SqlExceptionHelper.java [localhost-startStop-1])
* INFO  2018-07-09 14:32:48,616 Scheduled task with key: 0 0 0 * * ? and cron: 0 0 0 * * ? (SpringScheduler.java [localhost-startStop-1])
* INFO  2018-07-09 14:32:48,616 Scheduled task with key: fileResourceCleanupTask and cron: 0 0 2 * * ? (SpringScheduler.java [localhost-startStop-1])
* INFO  2018-07-09 14:32:48,617 Scheduled task with key: dataStatisticsTask and cron: 0 0 2 * * ? (SpringScheduler.java [localhost-startStop-1])
* INFO  2018-07-09 14:32:48,617 Scheduled task with key: validationResultNotificationTask and cron: 0 0 7 * * ? (SpringScheduler.java [localhost-startStop-1])
* INFO  2018-07-09 14:32:48,618 Scheduled task with key: credentialsExpiryAlertTask and cron: 0 0 2 * * ? (SpringScheduler.java [localhost-startStop-1])
* INFO  2018-07-09 14:32:48,618 Scheduled task with key: scheduledDataSetNotificationTask and cron: 0 0 2 * * ? (SpringScheduler.java [localhost-startStop-1])
* INFO  2018-07-09 14:32:48,635 Executing startup routine [1 of 15, runlevel 1]: InitTableAlteror (DefaultStartupRoutineExecutor.java [localhost-startStop-1])
* INFO  2018-07-09 14:32:49,364 Executing startup routine [2 of 15, runlevel 2]: PeriodTypePopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:49,369 SQL Warning Code: 0, SQLState: 00000 (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:49,369 parse S_3: ROLLBACK (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:49,369 SQL Warning Code: 0, SQLState: 00000 (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:49,370 StartTransactionCommand (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:49,370 SQL Warning Code: 0, SQLState: 00000 (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:49,370 bind <unnamed> to S_3 (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:49,370 SQL Warning Code: 0, SQLState: 00000 (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:49,370 ProcessUtility (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:49,370 SQL Warning Code: 0, SQLState: 00000 (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:49,370 CommitTransactionCommand (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:49,370 StartTransactionCommand (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:49,370 SQL Warning Code: 0, SQLState: 00000 (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:49,370 bind <unnamed> to S_3 (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:49,370 SQL Warning Code: 0, SQLState: 00000 (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:49,370 ProcessUtility (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:49,370 SQL Warning Code: 0, SQLState: 00000 (SqlExceptionHelper.java [localhost-startStop-1])
* WARN  2018-07-09 14:32:49,370 CommitTransactionCommand (SqlExceptionHelper.java [localhost-startStop-1])
* ERROR 2018-07-09 14:32:49,372 org.hibernate.WrongClassException: Object [id=678182] was not of the specified subclass [org.hisp.dhis.period.PeriodType] : Discriminator: BiWeekly
        at org.hibernate.loader.Loader.getInstanceClass(Loader.java:1816)
        at org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1627)
        at org.hibernate.loader.Loader.getRow(Loader.java:1556)
        at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:740)
        at org.hibernate.loader.Loader.processResultSet(Loader.java:985)
        at org.hibernate.loader.Loader.doQuery(Loader.java:943)
        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:349)
        at org.hibernate.loader.Loader.doList(Loader.java:2615)
        at org.hibernate.loader.Loader.listUsingQueryCache(Loader.java:2460)
        at org.hibernate.loader.Loader.list(Loader.java:2422)
        at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:109)
        at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1896)
        at org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:366)
        at org.hisp.dhis.period.hibernate.HibernatePeriodStore.getAllPeriodTypes(HibernatePeriodStore.java:228)
        at org.hisp.dhis.period.PeriodTypePopulator.executeInTransaction(PeriodTypePopulator.java:66)
        at org.hisp.dhis.system.startup.TransactionContextStartupRoutine$1.doInTransaction(TransactionContextStartupRoutine.java:57)
        at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:133)
        at org.hisp.dhis.system.startup.TransactionContextStartupRoutine.execute(TransactionContextStartupRoutine.java:52)
        at org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:113)
        at org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:70)
        at org.hisp.dhis.system.startup.StartupListener.contextInitialized(StartupListener.java:71)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4792)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5256)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:754)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:730)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:985)
        at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
        at java.util.concurrent.FutureTask.run(FutureTask.java:266)
 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
        at java.lang.Thread.run(Thread.java:748)
 (StartupListener.java [localhost-startStop-1])
* INFO  2018-07-09 14:32:49,422 De-registering jdbc driver: org.postgresql.Driver@25a564f1 (StartupListener.java [localhost-startStop-1])