subject:"\[Dhis2\-devs\] \[Dhis2\-users\] Resource Table error"

Re: [Dhis2-devs] [Dhis2-users] Resource Table error

2016-04-07 Thread channara rin

dear alex,
how can i do for remove duplicate period?
Yes, right knut.
by the way, if i upgrade to v2.20, that version doesn't have individual
record function, so my problem is i don't want to run aggregate data
automatic.

On Thu, Apr 7, 2016 at 11:29 PM, Knut Staring  wrote:

> Agree with Alex that you should really try to do an upgrade - just please
> make sure to back up everything first!
>
> However, I notice you had the same problem in October? Was it solve then
> and now it has come back - or have you had the problem now for 6 months?
>
> https://lists.launchpad.net/dhis2-users/msg08287.html
>
> On Thu, Apr 7, 2016 at 6:11 PM, Alex Tumwesigye 
> wrote:
>
>> Channara,
>>
>> The issue is related to timezone and was fixed. Upgrade to at least 2.20
>> or 2.21 but you have to first remove the duplicate period.
>>
>> Alex
>>
>> On Thu, Apr 7, 2016 at 7:08 PM, Knut Staring  wrote:
>>
>>> Hi Channara,
>>>
>>> It seems to me that the problem is that the _dateperiodstructure table
>>> has not been dropped (not sure why).
>>>
>>> Then when you try to regenerate it, it tries to insert the same values,
>>> starting from 1975-01-01 (which is the first row in the table)
>>>
>>> On Thu, Apr 7, 2016 at 6:01 PM, channara rin 
>>> wrote:
>>>
 dear Alex,
 what you mean was fixed? i currently using:
 Version:2.19Build revision:19251Build date:2015-07-01 02:04

 On Thu, Apr 7, 2016 at 10:46 PM, Alex Tumwesigye  wrote:

> Dear Channara,
>
> I think this bug was fixed.
> The date "1975-01-01" is duplicated.
> check your period table for any anomaly for that date.
>
> Alex
>
> On Thu, Apr 7, 2016 at 6:02 PM, channara rin 
> wrote:
>
>> Dear friend,
>> when i run analytic, i always got error like below. how to fix this
>> problem?
>>
>> ==
>> Resource table process failed
>> Resource table process failed, please check the logs. Time:
>> 2016-04-07T21:45:16.145+07:00. Message: PreparedStatementCallback; SQL
>> [insert into _dateperiodstructure values (?,?,?,?,?,?,?,?,?,?,?,?)]; 
>> ERROR:
>> duplicate key value violates unique constraint 
>> "_dateperiodstructure_pkey"
>> Detail: Key (dateperiod)=(1975-01-01) already exists.; nested
>> exception is org.postgresql.util.PSQLException: ERROR: duplicate key 
>> value
>> violates unique constraint "_dateperiodstructure_pkey"
>> Detail: Key (dateperiod)=(1975-01-01) already exists. Cause:
>> org.postgresql.util.PSQLException: ERROR: duplicate key value violates
>> unique constraint "_dateperiodstructure_pkey"
>> Detail: Key (dateperiod)=(1975-01-01) already exists.
>>
>> at
>> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)
>>
>> at
>> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)
>>
>> at
>> org.postgresql.core.v3.QueryExecutorImpl.sendQuery(QueryExecutorImpl.java:1130)
>>
>> at
>> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:396)
>>
>> at
>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2892)
>>
>> at
>> com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
>>
>> at
>> org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:1005)
>>
>> at
>> org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:989)
>>
>> at
>> org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:644)
>>
>> at
>> org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:673)
>>
>> at
>> org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:989)
>>
>> at
>> org.springframework.jdbc.core.BatchUpdateUtils.executeBatchUpdate(BatchUpdateUtils.java:32)
>>
>> at
>> org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1039)
>>
>> at
>> org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1034)
>>
>> at
>> org.hisp.dhis.resourcetable.jdbc.JdbcResourceTableStore.batchUpdate(JdbcResourceTableStore.java:101)
>>
>> at
>> org.hisp.dhis.resourcetable.DefaultResourceTableService.generateDatePeriodTable(DefaultResourceTableService.java:456)
>>
>> at sun.reflect.GeneratedMethodAccessor906.invoke(Unknown Source)
>>
>> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
>>
>> at java.lang.reflect.Method.invoke(Unknown Source)
>>
>> at
>> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
>>
>>

Re: [Dhis2-devs] [Dhis2-users] Resource Table error

2016-04-07 Thread Knut Staring

Agree with Alex that you should really try to do an upgrade - just please
make sure to back up everything first!

However, I notice you had the same problem in October? Was it solve then
and now it has come back - or have you had the problem now for 6 months?

https://lists.launchpad.net/dhis2-users/msg08287.html

On Thu, Apr 7, 2016 at 6:11 PM, Alex Tumwesigye 
wrote:

> Channara,
>
> The issue is related to timezone and was fixed. Upgrade to at least 2.20
> or 2.21 but you have to first remove the duplicate period.
>
> Alex
>
> On Thu, Apr 7, 2016 at 7:08 PM, Knut Staring  wrote:
>
>> Hi Channara,
>>
>> It seems to me that the problem is that the _dateperiodstructure table
>> has not been dropped (not sure why).
>>
>> Then when you try to regenerate it, it tries to insert the same values,
>> starting from 1975-01-01 (which is the first row in the table)
>>
>> On Thu, Apr 7, 2016 at 6:01 PM, channara rin 
>> wrote:
>>
>>> dear Alex,
>>> what you mean was fixed? i currently using:
>>> Version:2.19Build revision:19251Build date:2015-07-01 02:04
>>>
>>> On Thu, Apr 7, 2016 at 10:46 PM, Alex Tumwesigye 
>>> wrote:
>>>
 Dear Channara,

 I think this bug was fixed.
 The date "1975-01-01" is duplicated.
 check your period table for any anomaly for that date.

 Alex

 On Thu, Apr 7, 2016 at 6:02 PM, channara rin 
 wrote:

> Dear friend,
> when i run analytic, i always got error like below. how to fix this
> problem?
>
> ==
> Resource table process failed
> Resource table process failed, please check the logs. Time:
> 2016-04-07T21:45:16.145+07:00. Message: PreparedStatementCallback; SQL
> [insert into _dateperiodstructure values (?,?,?,?,?,?,?,?,?,?,?,?)]; 
> ERROR:
> duplicate key value violates unique constraint "_dateperiodstructure_pkey"
> Detail: Key (dateperiod)=(1975-01-01) already exists.; nested
> exception is org.postgresql.util.PSQLException: ERROR: duplicate key value
> violates unique constraint "_dateperiodstructure_pkey"
> Detail: Key (dateperiod)=(1975-01-01) already exists. Cause:
> org.postgresql.util.PSQLException: ERROR: duplicate key value violates
> unique constraint "_dateperiodstructure_pkey"
> Detail: Key (dateperiod)=(1975-01-01) already exists.
>
> at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)
>
> at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)
>
> at
> org.postgresql.core.v3.QueryExecutorImpl.sendQuery(QueryExecutorImpl.java:1130)
>
> at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:396)
>
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2892)
>
> at
> com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
>
> at
> org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:1005)
>
> at
> org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:989)
>
> at
> org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:644)
>
> at
> org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:673)
>
> at
> org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:989)
>
> at
> org.springframework.jdbc.core.BatchUpdateUtils.executeBatchUpdate(BatchUpdateUtils.java:32)
>
> at
> org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1039)
>
> at
> org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1034)
>
> at
> org.hisp.dhis.resourcetable.jdbc.JdbcResourceTableStore.batchUpdate(JdbcResourceTableStore.java:101)
>
> at
> org.hisp.dhis.resourcetable.DefaultResourceTableService.generateDatePeriodTable(DefaultResourceTableService.java:456)
>
> at sun.reflect.GeneratedMethodAccessor906.invoke(Unknown Source)
>
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
>
> at java.lang.reflect.Method.invoke(Unknown Source)
>
> at
> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
>
> at
> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:201)
>
> at com.sun.proxy.$Proxy262.generateDatePeriodTable(Unknown Source)
>
> at
> org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.generateAll(ResourceTableTask.java:121)
>
> at
> org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.run(ResourceTableTask.java:85)
>
> at

Re: [Dhis2-devs] [Dhis2-users] Resource Table error

2016-04-07 Thread channara rin

dear Alex,
what you mean was fixed? i currently using:
Version:2.19Build revision:19251Build date:2015-07-01 02:04

On Thu, Apr 7, 2016 at 10:46 PM, Alex Tumwesigye 
wrote:

> Dear Channara,
>
> I think this bug was fixed.
> The date "1975-01-01" is duplicated.
> check your period table for any anomaly for that date.
>
> Alex
>
> On Thu, Apr 7, 2016 at 6:02 PM, channara rin 
> wrote:
>
>> Dear friend,
>> when i run analytic, i always got error like below. how to fix this
>> problem?
>>
>> ==
>> Resource table process failed
>> Resource table process failed, please check the logs. Time:
>> 2016-04-07T21:45:16.145+07:00. Message: PreparedStatementCallback; SQL
>> [insert into _dateperiodstructure values (?,?,?,?,?,?,?,?,?,?,?,?)]; ERROR:
>> duplicate key value violates unique constraint "_dateperiodstructure_pkey"
>> Detail: Key (dateperiod)=(1975-01-01) already exists.; nested exception
>> is org.postgresql.util.PSQLException: ERROR: duplicate key value violates
>> unique constraint "_dateperiodstructure_pkey"
>> Detail: Key (dateperiod)=(1975-01-01) already exists. Cause:
>> org.postgresql.util.PSQLException: ERROR: duplicate key value violates
>> unique constraint "_dateperiodstructure_pkey"
>> Detail: Key (dateperiod)=(1975-01-01) already exists.
>>
>> at
>> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)
>>
>> at
>> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)
>>
>> at
>> org.postgresql.core.v3.QueryExecutorImpl.sendQuery(QueryExecutorImpl.java:1130)
>>
>> at
>> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:396)
>>
>> at
>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2892)
>>
>> at
>> com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
>>
>> at
>> org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:1005)
>>
>> at
>> org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:989)
>>
>> at
>> org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:644)
>>
>> at
>> org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:673)
>>
>> at
>> org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:989)
>>
>> at
>> org.springframework.jdbc.core.BatchUpdateUtils.executeBatchUpdate(BatchUpdateUtils.java:32)
>>
>> at
>> org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1039)
>>
>> at
>> org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1034)
>>
>> at
>> org.hisp.dhis.resourcetable.jdbc.JdbcResourceTableStore.batchUpdate(JdbcResourceTableStore.java:101)
>>
>> at
>> org.hisp.dhis.resourcetable.DefaultResourceTableService.generateDatePeriodTable(DefaultResourceTableService.java:456)
>>
>> at sun.reflect.GeneratedMethodAccessor906.invoke(Unknown Source)
>>
>> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
>>
>> at java.lang.reflect.Method.invoke(Unknown Source)
>>
>> at
>> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
>>
>> at
>> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:201)
>>
>> at com.sun.proxy.$Proxy262.generateDatePeriodTable(Unknown Source)
>>
>> at
>> org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.generateAll(ResourceTableTask.java:121)
>>
>> at
>> org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.run(ResourceTableTask.java:85)
>>
>> at org.hisp.dhis.scheduling.ScheduledTasks.run(ScheduledTasks.java:60)
>>
>> at
>> org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
>>
>> at
>> org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:81)
>>
>> at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
>>
>> at java.util.concurrent.FutureTask.run(Unknown Source)
>>
>> at
>> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown
>> Source)
>>
>> at
>> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown
>> Source)
>>
>> at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
>>
>> at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
>>
>> at java.lang.Thread.run(Unknown Source)
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-us...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Alex Tumwesigye
>
> Technical Advisor - DHIS2 (Consultant),
> Ministry of Health/AFENET
> Kampala
> Uganda
> +256 774149 775, + 256 759 800161
> Skype ID: talexie
>
> IT Consultant (Servers, Networks and Security, Health

Re: [Dhis2-devs] [Dhis2-users] Resource Table error

2016-04-07 Thread Alex Tumwesigye

Channara,

The issue is related to timezone and was fixed. Upgrade to at least 2.20 or
2.21 but you have to first remove the duplicate period.

Alex

On Thu, Apr 7, 2016 at 7:08 PM, Knut Staring  wrote:

> Hi Channara,
>
> It seems to me that the problem is that the _dateperiodstructure table
> has not been dropped (not sure why).
>
> Then when you try to regenerate it, it tries to insert the same values,
> starting from 1975-01-01 (which is the first row in the table)
>
> On Thu, Apr 7, 2016 at 6:01 PM, channara rin 
> wrote:
>
>> dear Alex,
>> what you mean was fixed? i currently using:
>> Version:2.19Build revision:19251Build date:2015-07-01 02:04
>>
>> On Thu, Apr 7, 2016 at 10:46 PM, Alex Tumwesigye 
>> wrote:
>>
>>> Dear Channara,
>>>
>>> I think this bug was fixed.
>>> The date "1975-01-01" is duplicated.
>>> check your period table for any anomaly for that date.
>>>
>>> Alex
>>>
>>> On Thu, Apr 7, 2016 at 6:02 PM, channara rin 
>>> wrote:
>>>
 Dear friend,
 when i run analytic, i always got error like below. how to fix this
 problem?

 ==
 Resource table process failed
 Resource table process failed, please check the logs. Time:
 2016-04-07T21:45:16.145+07:00. Message: PreparedStatementCallback; SQL
 [insert into _dateperiodstructure values (?,?,?,?,?,?,?,?,?,?,?,?)]; ERROR:
 duplicate key value violates unique constraint "_dateperiodstructure_pkey"
 Detail: Key (dateperiod)=(1975-01-01) already exists.; nested exception
 is org.postgresql.util.PSQLException: ERROR: duplicate key value violates
 unique constraint "_dateperiodstructure_pkey"
 Detail: Key (dateperiod)=(1975-01-01) already exists. Cause:
 org.postgresql.util.PSQLException: ERROR: duplicate key value violates
 unique constraint "_dateperiodstructure_pkey"
 Detail: Key (dateperiod)=(1975-01-01) already exists.

 at
 org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)

 at
 org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)

 at
 org.postgresql.core.v3.QueryExecutorImpl.sendQuery(QueryExecutorImpl.java:1130)

 at
 org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:396)

 at
 org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2892)

 at
 com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)

 at
 org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:1005)

 at
 org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:989)

 at
 org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:644)

 at
 org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:673)

 at
 org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:989)

 at
 org.springframework.jdbc.core.BatchUpdateUtils.executeBatchUpdate(BatchUpdateUtils.java:32)

 at
 org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1039)

 at
 org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1034)

 at
 org.hisp.dhis.resourcetable.jdbc.JdbcResourceTableStore.batchUpdate(JdbcResourceTableStore.java:101)

 at
 org.hisp.dhis.resourcetable.DefaultResourceTableService.generateDatePeriodTable(DefaultResourceTableService.java:456)

 at sun.reflect.GeneratedMethodAccessor906.invoke(Unknown Source)

 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

 at java.lang.reflect.Method.invoke(Unknown Source)

 at
 org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)

 at
 org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:201)

 at com.sun.proxy.$Proxy262.generateDatePeriodTable(Unknown Source)

 at
 org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.generateAll(ResourceTableTask.java:121)

 at
 org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.run(ResourceTableTask.java:85)

 at org.hisp.dhis.scheduling.ScheduledTasks.run(ScheduledTasks.java:60)

 at
 org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)

 at
 org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:81)

 at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

 at java.util.concurrent.FutureTask.run(Unknown Source)

 at

Re: [Dhis2-devs] [Dhis2-users] Resource Table error

2016-04-07 Thread Knut Staring

Hi Channara,

It seems to me that the problem is that the _dateperiodstructure table has
not been dropped (not sure why).

Then when you try to regenerate it, it tries to insert the same values,
starting from 1975-01-01 (which is the first row in the table)

On Thu, Apr 7, 2016 at 6:01 PM, channara rin  wrote:

> dear Alex,
> what you mean was fixed? i currently using:
> Version:2.19Build revision:19251Build date:2015-07-01 02:04
>
> On Thu, Apr 7, 2016 at 10:46 PM, Alex Tumwesigye 
> wrote:
>
>> Dear Channara,
>>
>> I think this bug was fixed.
>> The date "1975-01-01" is duplicated.
>> check your period table for any anomaly for that date.
>>
>> Alex
>>
>> On Thu, Apr 7, 2016 at 6:02 PM, channara rin 
>> wrote:
>>
>>> Dear friend,
>>> when i run analytic, i always got error like below. how to fix this
>>> problem?
>>>
>>> ==
>>> Resource table process failed
>>> Resource table process failed, please check the logs. Time:
>>> 2016-04-07T21:45:16.145+07:00. Message: PreparedStatementCallback; SQL
>>> [insert into _dateperiodstructure values (?,?,?,?,?,?,?,?,?,?,?,?)]; ERROR:
>>> duplicate key value violates unique constraint "_dateperiodstructure_pkey"
>>> Detail: Key (dateperiod)=(1975-01-01) already exists.; nested exception
>>> is org.postgresql.util.PSQLException: ERROR: duplicate key value violates
>>> unique constraint "_dateperiodstructure_pkey"
>>> Detail: Key (dateperiod)=(1975-01-01) already exists. Cause:
>>> org.postgresql.util.PSQLException: ERROR: duplicate key value violates
>>> unique constraint "_dateperiodstructure_pkey"
>>> Detail: Key (dateperiod)=(1975-01-01) already exists.
>>>
>>> at
>>> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)
>>>
>>> at
>>> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)
>>>
>>> at
>>> org.postgresql.core.v3.QueryExecutorImpl.sendQuery(QueryExecutorImpl.java:1130)
>>>
>>> at
>>> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:396)
>>>
>>> at
>>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2892)
>>>
>>> at
>>> com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
>>>
>>> at
>>> org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:1005)
>>>
>>> at
>>> org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:989)
>>>
>>> at
>>> org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:644)
>>>
>>> at
>>> org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:673)
>>>
>>> at
>>> org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:989)
>>>
>>> at
>>> org.springframework.jdbc.core.BatchUpdateUtils.executeBatchUpdate(BatchUpdateUtils.java:32)
>>>
>>> at
>>> org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1039)
>>>
>>> at
>>> org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1034)
>>>
>>> at
>>> org.hisp.dhis.resourcetable.jdbc.JdbcResourceTableStore.batchUpdate(JdbcResourceTableStore.java:101)
>>>
>>> at
>>> org.hisp.dhis.resourcetable.DefaultResourceTableService.generateDatePeriodTable(DefaultResourceTableService.java:456)
>>>
>>> at sun.reflect.GeneratedMethodAccessor906.invoke(Unknown Source)
>>>
>>> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
>>>
>>> at java.lang.reflect.Method.invoke(Unknown Source)
>>>
>>> at
>>> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
>>>
>>> at
>>> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:201)
>>>
>>> at com.sun.proxy.$Proxy262.generateDatePeriodTable(Unknown Source)
>>>
>>> at
>>> org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.generateAll(ResourceTableTask.java:121)
>>>
>>> at
>>> org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.run(ResourceTableTask.java:85)
>>>
>>> at org.hisp.dhis.scheduling.ScheduledTasks.run(ScheduledTasks.java:60)
>>>
>>> at
>>> org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
>>>
>>> at
>>> org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:81)
>>>
>>> at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
>>>
>>> at java.util.concurrent.FutureTask.run(Unknown Source)
>>>
>>> at
>>> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown
>>> Source)
>>>
>>> at
>>> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown
>>> Source)
>>>
>>> at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
>>>
>>> at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
>>>
>>> at java.lang.Thread.run(Unknown Source)
>>>
>>>

Re: [Dhis2-devs] [Dhis2-users] Resource Table error

2016-04-07 Thread Alex Tumwesigye

Dear Channara,

I think this bug was fixed.
The date "1975-01-01" is duplicated.
check your period table for any anomaly for that date.

Alex

On Thu, Apr 7, 2016 at 6:02 PM, channara rin  wrote:

> Dear friend,
> when i run analytic, i always got error like below. how to fix this
> problem?
>
> ==
> Resource table process failed
> Resource table process failed, please check the logs. Time:
> 2016-04-07T21:45:16.145+07:00. Message: PreparedStatementCallback; SQL
> [insert into _dateperiodstructure values (?,?,?,?,?,?,?,?,?,?,?,?)]; ERROR:
> duplicate key value violates unique constraint "_dateperiodstructure_pkey"
> Detail: Key (dateperiod)=(1975-01-01) already exists.; nested exception is
> org.postgresql.util.PSQLException: ERROR: duplicate key value violates
> unique constraint "_dateperiodstructure_pkey"
> Detail: Key (dateperiod)=(1975-01-01) already exists. Cause:
> org.postgresql.util.PSQLException: ERROR: duplicate key value violates
> unique constraint "_dateperiodstructure_pkey"
> Detail: Key (dateperiod)=(1975-01-01) already exists.
>
> at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)
>
> at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)
>
> at
> org.postgresql.core.v3.QueryExecutorImpl.sendQuery(QueryExecutorImpl.java:1130)
>
> at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:396)
>
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2892)
>
> at
> com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
>
> at
> org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:1005)
>
> at
> org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:989)
>
> at
> org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:644)
>
> at
> org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:673)
>
> at
> org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:989)
>
> at
> org.springframework.jdbc.core.BatchUpdateUtils.executeBatchUpdate(BatchUpdateUtils.java:32)
>
> at
> org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1039)
>
> at
> org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1034)
>
> at
> org.hisp.dhis.resourcetable.jdbc.JdbcResourceTableStore.batchUpdate(JdbcResourceTableStore.java:101)
>
> at
> org.hisp.dhis.resourcetable.DefaultResourceTableService.generateDatePeriodTable(DefaultResourceTableService.java:456)
>
> at sun.reflect.GeneratedMethodAccessor906.invoke(Unknown Source)
>
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
>
> at java.lang.reflect.Method.invoke(Unknown Source)
>
> at
> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
>
> at
> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:201)
>
> at com.sun.proxy.$Proxy262.generateDatePeriodTable(Unknown Source)
>
> at
> org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.generateAll(ResourceTableTask.java:121)
>
> at
> org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.run(ResourceTableTask.java:85)
>
> at org.hisp.dhis.scheduling.ScheduledTasks.run(ScheduledTasks.java:60)
>
> at
> org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
>
> at
> org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:81)
>
> at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
>
> at java.util.concurrent.FutureTask.run(Unknown Source)
>
> at
> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown
> Source)
>
> at
> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown
> Source)
>
> at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
>
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
>
> at java.lang.Thread.run(Unknown Source)
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Alex Tumwesigye

Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET
Kampala
Uganda
+256 774149 775, + 256 759 800161
Skype ID: talexie

IT Consultant (Servers, Networks and Security, Health Information Systems -
DHIS2, Disease Outbreak & Surveillance Systems) & Solar Consultant


"I don't want to be anything other than what I have been - one tree hill "
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs

Re: [Dhis2-devs] [Dhis2-users] Resource table error

2014-06-23 Thread Olav Poppe

I’m experiencing the exact same thing with the latest build of 2.15 and MySQL.

Version:
2.15
Build revision:
15167
Build date:
2014-06-23 02:08




22. juni 2014 kl. 09:54 skrev Yemi Awe j2y...@gmail.com:

 Hi all,
 I am using dhis2.15 and when i generated the resource table, i got this error
 
 nested exception is 
 com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 
 'd.dataelementid' in 'on clause'
 
 I am using tomcat 7.0, jdk 1.7
 
 Any idea what could have gone wrong?
 
 ___
 Mailing list: https://launchpad.net/~dhis2-users
 Post to : dhis2-us...@lists.launchpad.net
 Unsubscribe : https://launchpad.net/~dhis2-users
 More help   : https://help.launchpad.net/ListHelp

___
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

Re: [Dhis2-devs] [Dhis2-users] Resource table error

2014-06-23 Thread Olav Poppe

Reported it as (urgent) bug: https://bugs.launchpad.net/dhis2/+bug/1333405

23. juni 2014 kl. 11:42 skrev Olav Poppe olav.po...@me.com:

 I’m experiencing the exact same thing with the latest build of 2.15 and MySQL.
 
 Version:
 2.15
 Build revision:
 15167
 Build date:
 2014-06-23 02:08
 
 
 
 
 22. juni 2014 kl. 09:54 skrev Yemi Awe j2y...@gmail.com:
 
 Hi all,
 I am using dhis2.15 and when i generated the resource table, i got this error
 
 nested exception is 
 com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 
 'd.dataelementid' in 'on clause'
 
 I am using tomcat 7.0, jdk 1.7
 
 Any idea what could have gone wrong?
 
 ___
 Mailing list: https://launchpad.net/~dhis2-users
 Post to : dhis2-us...@lists.launchpad.net
 Unsubscribe : https://launchpad.net/~dhis2-users
 More help   : https://help.launchpad.net/ListHelp
 
 ___
 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

___
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

Re: [Dhis2-devs] [Dhis2-users] Resource Table error

Re: [Dhis2-devs] [Dhis2-users] Resource Table error

Re: [Dhis2-devs] [Dhis2-users] Resource Table error

Re: [Dhis2-devs] [Dhis2-users] Resource Table error

Re: [Dhis2-devs] [Dhis2-users] Resource Table error

Re: [Dhis2-devs] [Dhis2-users] Resource Table error

Re: [Dhis2-devs] [Dhis2-users] Resource table error

Re: [Dhis2-devs] [Dhis2-users] Resource table error

8 matches

Site Navigation

Mail list logo

Footer information