Hey Sandvold please below
select pushanalysisid, uid, code, name, title, schedulingdayoffrequency from pushanalysis; pushanalysisid | uid | code | name | title | schedulingdayoffrequency ----------------+-------------+-------+-------------------------------------------+-------------------------------------------+-------------------------- 4030992 | JmuWTH9oUcn | | Child Health monthly newsletter | Child Health Monthly Newsletter | 22 4029471 | MWotV5Va75Q | | HIV Testing and Counselling Newsletter | HIV Testing and Counselling Newsletter | 22 4028842 | GeryOIbsWhg | | Maternal Health_News Letter (Test) | Maternal Health_News Letter (Test) | 22 2946234 | a19w4BhUNo8 | | Quarterly News Letter (Testing) | | 16 4029684 | PNhbOVQfNzv | | Immunization Monthly Newsletter | Immunization Monthly Newsletter | 22 5460302 | BbXhhJ02EbV | xx890 | RBF-report | RBF _Report 2017 health | 4453262 | rIAnKBuPpPG | | Self Assessment | Self Assessment | 20 5460325 | mLFU0RdEboH | gt567 | Consolidated District RBF Invoice for HCs | Consolidated District RBF Invoice for HCs | 4030951 | uOqRtK7ditU | | Health Services Utilazation | Health Services Utilazation | 22 4627355 | PSnTgqRWv8V | | HIV Test and Treat monthly newsletter | HIV Test and Treat monthly newsletter | 22 4028510 | OrJLwiOSVbO | | Mothly Report Completeness (Submitted) | Mothly Report Completeness (Submitted) | 21 4029128 | Vs4qna0Li1u | | Circumcision_News Letter (Test) | Circumcision News Letter (Test) | 22 (12 rows) On Thu, Oct 25, 2018 at 4:15 PM Stian Sandvold <st...@dhis2.org> wrote: > Hi Moses, > > I am not sure exactly why it fails, but could you let me know how many > rows you have in your "pushanalysis" table, and if there are more than 5, > could you attach the data of those not mentioned in the log: > > * INFO 2018-10-25 15:11:30,520 'system-process' create > org.hisp.dhis.scheduling.JobConfiguration, name: PushAnalysis: > JmuWTH9oUcn, uid: bqBqbARSW8s (AuditLogUtil.java [localhost-startStop-1]) > * INFO 2018-10-25 15:11:30,530 'system-process' create > org.hisp.dhis.scheduling.JobConfiguration, name: PushAnalysis: > MWotV5Va75Q, uid: Y9mDJj6AuqP (AuditLogUtil.java [localhost-startStop-1]) > * INFO 2018-10-25 15:11:30,539 'system-process' create > org.hisp.dhis.scheduling.JobConfiguration, name: PushAnalysis: > GeryOIbsWhg, uid: jPJ6dV7ojuC (AuditLogUtil.java [localhost-startStop-1]) > * INFO 2018-10-25 15:11:30,543 'system-process' create > org.hisp.dhis.scheduling.JobConfiguration, name: PushAnalysis: > a19w4BhUNo8, uid: I49TPE2wGcu (AuditLogUtil.java [localhost-startStop-1]) > * INFO 2018-10-25 15:11:30,546 'system-process' create > org.hisp.dhis.scheduling.JobConfiguration, name: PushAnalysis: > PNhbOVQfNzv, uid: qAS36jVFphT (AuditLogUtil.java [localhost-startStop-1]) > > > On Thu, Oct 25, 2018 at 3:39 PM moses mwale <isoftcom...@gmail.com> wrote: > >> whenever i upgrade from 2.28 to 2.29 i see error below >> >> * INFO 2018-10-25 15:11:29,932 'system-process' create >> org.hisp.dhis.scheduling.JobConfiguration, name: Analytics, uid: >> rIxDo7LeidU (AuditLogUtil.java [localhost-startStop-1]) >> * ERROR 2018-10-25 15:11:29,940 Could not map job type >> '[resourceTableTask]' with cron '0 0 23 * * ?' (SchedulerUpgrade.java >> [localhost-startStop-1]) >> * ERROR 2018-10-25 15:11:29,940 Could not map job type >> '[resourceTableTask]' with cron '0 0 23 * * ?' (SchedulerUpgrade.java >> [localhost-startStop-1]) >> * ERROR 2018-10-25 15:11:29,941 Could not map job type >> '[resourceTableTask]' with cron '0 0 23 * * ?' (SchedulerUpgrade.java >> [localhost-startStop-1]) >> * ERROR 2018-10-25 15:11:29,941 Could not map job type >> '[resourceTableTask]' with cron '0 0 23 * * ?' (SchedulerUpgrade.java >> [localhost-startStop-1]) >> * ERROR 2018-10-25 15:11:29,941 Could not map job type >> '[resourceTableTask]' with cron '0 0 23 * * ?' (SchedulerUpgrade.java >> [localhost-startStop-1]) >> * INFO 2018-10-25 15:11:29,941 'system-process' create >> org.hisp.dhis.scheduling.JobConfiguration, name: Resource table, uid: >> VE0d6NQqXGy (AuditLogUtil.java [localhost-startStop-1]) >> * INFO 2018-10-25 15:11:29,945 Moving existing Push Analysis jobs. >> (SchedulerUpgrade.java [localhost-startStop-1]) >> * INFO 2018-10-25 15:11:30,520 'system-process' create >> org.hisp.dhis.scheduling.JobConfiguration, name: PushAnalysis: JmuWTH9oUcn, >> uid: bqBqbARSW8s (AuditLogUtil.java [localhost-startStop-1]) >> * INFO 2018-10-25 15:11:30,530 'system-process' create >> org.hisp.dhis.scheduling.JobConfiguration, name: PushAnalysis: MWotV5Va75Q, >> uid: Y9mDJj6AuqP (AuditLogUtil.java [localhost-startStop-1]) >> * INFO 2018-10-25 15:11:30,539 'system-process' create >> org.hisp.dhis.scheduling.JobConfiguration, name: PushAnalysis: GeryOIbsWhg, >> uid: jPJ6dV7ojuC (AuditLogUtil.java [localhost-startStop-1]) >> * INFO 2018-10-25 15:11:30,543 'system-process' create >> org.hisp.dhis.scheduling.JobConfiguration, name: PushAnalysis: a19w4BhUNo8, >> uid: I49TPE2wGcu (AuditLogUtil.java [localhost-startStop-1]) >> * INFO 2018-10-25 15:11:30,546 'system-process' create >> org.hisp.dhis.scheduling.JobConfiguration, name: PushAnalysis: PNhbOVQfNzv, >> uid: qAS36jVFphT (AuditLogUtil.java [localhost-startStop-1]) >> * ERROR 2018-10-25 15:11:30,554 java.lang.NullPointerException >> at >> org.hisp.dhis.startup.SchedulerUpgrade.lambda$execute$2(SchedulerUpgrade.java:164) >> at java.util.ArrayList.forEach(ArrayList.java:1257) >> at >> org.hisp.dhis.startup.SchedulerUpgrade.execute(SchedulerUpgrade.java:161) >> 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:498) >> at >> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333) >> at >> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) >> at >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) >> at >> org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99) >> at >> org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282) >> at >> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) >> at >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) >> at >> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213) >> at com.sun.proxy.$Proxy194.execute(Unknown Source) >> 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:5068) >> at >> org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5584) >> at >> org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:147) >> at >> org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:899) >> at >> org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:875) >> at >> org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652) >> at >> org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1091) >> at >> org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1980) >> 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:1149) >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) >> at java.lang.Thread.run(Thread.java:748) >> (StartupListener.java [localhost-startStop-1]) >> Oct 25, 2018 3:11:30 PM org.apache.catalina.core.StandardContext >> startInternal >> SEVERE: One or more listeners failed to start. Full details will be found >> in the appropriate container log file >> Oct 25, 2018 3:11:30 PM org.apache.catalina.core.StandardContext >> startInternal >> SEVERE: Context [] startup failed due to previous errors >> >> please help me understand where its failing >> >> -- >> developer_lusaka_systems >> _______________________________________________ >> Mailing list: https://launchpad.net/~dhis2-devs >> Post to : dhis2-devs@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-devs >> More help : https://help.launchpad.net/ListHelp >> > > > -- > Stian Sandvold > Software developer, DHIS2 > University of Oslo > http://www.dhis2.org > -- developer_lusaka_systems
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp