Re: [Dhis2-devs] startup error upgrade from 2.28 to 2.29

2018-10-27 Thread moses mwale
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  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  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 

Re: [Dhis2-devs] startup error upgrade from 2.28 to 2.29

2018-10-25 Thread Stian Sandvold
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  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
>