Re: [Dhis2-devs] [Dhis2-users] Error while running analytics in 2.29

2018-06-04 Thread gerald thomas 
Dear Kumar,
What version of Postgres are running? Normally, these errors occurs when
the postgres.conf is not configured properly based on the data size it has
to analyzed.
Please can you send your Postgres.conf file.

On Tue, 5 Jun 2018 at 05:40, Kumar Shahdeo 
wrote:

> Yes, I rebooted the server, but still I am getting the same issue while
> running analytics
>
> On Tue, Jun 5, 2018 at 10:52 AM, gerald thomas 
> wrote:
>
>> Dear Kumar,
>> Have you tried to reboot the server after upgrades and then run analytics
>> again?
>>
>> On Tue, 5 Jun 2018 at 04:49, Kumar Shahdeo 
>> wrote:
>>
>>> Hi DHIS users,
>>>
>>>
>>> I have migrated from DHIS 2.27 to DHIS 2.29. I used the upgrade script
>>> provided by DHIS to upgrade the db. I have tried both incremental upgrade
>>> (2.27->2.28->2.29) and skipping 2.28(2.27->2.29). In both the cases I am
>>> getting the same issue.
>>>
>>> I am not able to run analytics. Analytics fails with below
>>> error(captured in screenshot)
>>>
>>>
>>>
>>>
>>>
>>> When I checked server logs. I got this exception :
>>>
>>> org.springframework.dao.DataIntegrityViolationException with error
>>> message ‘new row for relation "analytics_temp_2012" violates check
>>> constraint "analytics_temp_2012,_yearly_check”’
>>>
>>>
>>> Any suggestions on this will be highly appreciated.
>>>
>>> Regards
>>> --
>>> Kumar Gaurav Nath Shahdeo
>>> Developer
>>> Email gaura...@thoughtworks.com
>>> Telephone +91 9160688935 <+91+9160688935>
>>> [image: ThoughtWorks]
>>> 
>>> ___
>>> 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
>>>
>> --
>> Regards,
>>
>> Gerald
>>
>
>
>
> --
> Kumar Gaurav Nath Shahdeo
> Developer
> Email gaura...@thoughtworks.com
> Telephone +91 9160688935 <+91+9160688935>
> [image: ThoughtWorks]
> 
>
-- 
Regards,

Gerald
___
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

[Dhis2-devs] Event report is showing data after deleting all events also

2018-06-04 Thread Rajeswari Gottipati 
Hi DHIS Team,

We have deleted all events for specific orgunit, ran analytics and cleared
browser cache. Observed that there is no data in Event Capture app.



But still we are seeing numbers in Event Reports app as below




We have observed the same for other Orgunits also. Could you please let us
know why event report still showing numbers.

-- 
Rajeswari Gottipati
Sr Consultant
Email rajes...@thoughtworks.com
Telephone +91 9949292931 <+91%209949292931>
[image: ThoughtWorks]

___
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] Error while running analytics in 2.29

2018-06-04 Thread Kumar Shahdeo 
Yes, I rebooted the server, but still I am getting the same issue while
running analytics

On Tue, Jun 5, 2018 at 10:52 AM, gerald thomas 
wrote:

> Dear Kumar,
> Have you tried to reboot the server after upgrades and then run analytics
> again?
>
> On Tue, 5 Jun 2018 at 04:49, Kumar Shahdeo 
> wrote:
>
>> Hi DHIS users,
>>
>>
>> I have migrated from DHIS 2.27 to DHIS 2.29. I used the upgrade script
>> provided by DHIS to upgrade the db. I have tried both incremental upgrade
>> (2.27->2.28->2.29) and skipping 2.28(2.27->2.29). In both the cases I am
>> getting the same issue.
>>
>> I am not able to run analytics. Analytics fails with below error(captured
>> in screenshot)
>>
>>
>>
>>
>>
>> When I checked server logs. I got this exception :
>>
>> org.springframework.dao.DataIntegrityViolationException with error
>> message ‘new row for relation "analytics_temp_2012" violates check
>> constraint "analytics_temp_2012,_yearly_check”’
>>
>>
>> Any suggestions on this will be highly appreciated.
>>
>> Regards
>> --
>> Kumar Gaurav Nath Shahdeo
>> Developer
>> Email gaura...@thoughtworks.com
>> Telephone +91 9160688935 <+91+9160688935>
>> [image: ThoughtWorks]
>> 
>> ___
>> 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
>>
> --
> Regards,
>
> Gerald
>



-- 
Kumar Gaurav Nath Shahdeo
Developer
Email gaura...@thoughtworks.com
Telephone +91 9160688935 <+91+9160688935>
[image: ThoughtWorks]

___
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] Error while running analytics in 2.29

2018-06-04 Thread gerald thomas 
Dear Kumar,
Have you tried to reboot the server after upgrades and then run analytics
again?

On Tue, 5 Jun 2018 at 04:49, Kumar Shahdeo 
wrote:

> Hi DHIS users,
>
>
> I have migrated from DHIS 2.27 to DHIS 2.29. I used the upgrade script
> provided by DHIS to upgrade the db. I have tried both incremental upgrade
> (2.27->2.28->2.29) and skipping 2.28(2.27->2.29). In both the cases I am
> getting the same issue.
>
> I am not able to run analytics. Analytics fails with below error(captured
> in screenshot)
>
>
>
>
>
> When I checked server logs. I got this exception :
>
> org.springframework.dao.DataIntegrityViolationException with error message
> ‘new row for relation "analytics_temp_2012" violates check constraint
> "analytics_temp_2012,_yearly_check”’
>
>
> Any suggestions on this will be highly appreciated.
>
> Regards
> --
> Kumar Gaurav Nath Shahdeo
> Developer
> Email gaura...@thoughtworks.com
> Telephone +91 9160688935 <+91+9160688935>
> [image: ThoughtWorks]
> 
> ___
> 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
>
-- 
Regards,

Gerald
___
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

[Dhis2-devs] Error while running analytics in 2.29

2018-06-04 Thread Kumar Shahdeo 
Hi DHIS users,


I have migrated from DHIS 2.27 to DHIS 2.29. I used the upgrade script
provided by DHIS to upgrade the db. I have tried both incremental upgrade
(2.27->2.28->2.29) and skipping 2.28(2.27->2.29). In both the cases I am
getting the same issue.

I am not able to run analytics. Analytics fails with below error(captured
in screenshot)





When I checked server logs. I got this exception :

org.springframework.dao.DataIntegrityViolationException with error message
‘new row for relation "analytics_temp_2012" violates check constraint
"analytics_temp_2012_yearly_check”’


Any suggestions on this will be highly appreciated.

Regards
-- 
Kumar Gaurav Nath Shahdeo
Developer
Email gaura...@thoughtworks.com
Telephone +91 9160688935 <+91+9160688935>
[image: ThoughtWorks]

___
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

[Dhis2-devs] how to manage a datset with dynamic rows of detail data?

2018-06-04 Thread 林晓东 


 hi,all


   I  encounter a problem like this: 
collecting info of a doctor, with one or more times of training experience, 
how to design this case?  

  Thanks.


--

此致

   林晓东

莫愁前路无知己，天下谁人不识君。

在 2018-05-25 16:58:07，"Kumar Shahdeo"  写道：

In 2.29 , The "Tracked entity" object is renamed to "Tracked Entity Type" in 
the web API.
So, try using "trackedEntityType"


On Fri, May 25, 2018 at 2:13 PM, 林晓东  wrote:

Hi,all,
   I have done a test on Tracker Web API. as documents: 
  body:
{
  "trackedEntity": "nEenWmSyUEp",
  "orgUnit": "DiszpKrYNg8",
  "attributes": [
{
  "attribute": "w75KJ2mc4zz",
  "value": "Joe"
},
{
  "attribute": "zDhUuAYrxNC",
  "value": "Smith"
}
  ]
}
url: 
https://play.dhis2.org/dev/api/29/trackedEntityInstances.json?ou=DiszpKrYNg8
method : post


got:


{
  "httpStatus" : "Internal Server Error",
  "httpStatusCode" : 500,
  "status" : "ERROR",
  "message" : "Unrecognized field \"trackedEntity\" (class 
org.hisp.dhis.dxf2.events.trackedentity.TrackedEntityInstance), not marked as 
ignorable (14 known properties: \"trackedEntityInstance\", 
\"lastUpdatedAtClient\", \"lastUpdated\", \"createdAtClient\", 
\"trackedEntityType\", \"orgUnit\", \"inactive\", \"enrollments\", 
\"featureType\", \"attributes\", \"deleted\", \"relationships\", \"created\", 
\"coordinates\"])\n at [Source: (String)\"{\n  \"trackedEntity\": 
\"nEenWmSyUEp\",\n  \"orgUnit\": \"DiszpKrYNg8\",\n  \"attributes\": [\n{\n 
 \"attribute\": \"w75KJ2mc4zz\",\n  \"value\": \"Joe\"\n},\n{\n 
 \"attribute\": \"zDhUuAYrxNC\",\n  \"value\": \"Smith\"\n}\n  
]\n}\"; line: 2, column: 21] (through reference chain: 
org.hisp.dhis.dxf2.events.trackedentity.TrackedEntityInstance[\"trackedEntity\"])"
}{
  "httpStatus" : "Internal Server Error",
  "httpStatusCode" : 500,
  "status" : "ERROR",
  "message" : "Unrecognized field \"trackedEntity\" (class 
org.hisp.dhis.dxf2.events.trackedentity.TrackedEntityInstance), not marked as 
ignorable (14 known properties: \"trackedEntityInstance\", 
\"lastUpdatedAtClient\", \"lastUpdated\", \"createdAtClient\", 
\"trackedEntityType\", \"orgUnit\", \"inactive\", \"enrollments\", 
\"featureType\", \"attributes\", \"deleted\", \"relationships\", \"created\", 
\"coordinates\"])\n at [Source: (String)\"{\n  \"trackedEntity\": 
\"nEenWmSyUEp\",\n  \"orgUnit\": \"DiszpKrYNg8\",\n  \"attributes\": [\n{\n 
 \"attribute\": \"w75KJ2mc4zz\",\n  \"value\": \"Joe\"\n},\n{\n 
 \"attribute\": \"zDhUuAYrxNC\",\n  \"value\": \"Smith\"\n}\n  
]\n}\"; line: 2, column: 21] (through reference chain: 
org.hisp.dhis.dxf2.events.trackedentity.TrackedEntityInstance[\"trackedEntity\"])"
}


what's wrong with this?


Thanks.
--

此致

   林晓东

莫愁前路无知己，天下谁人不识君。




 


___
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







--

| Kumar Gaurav Nath Shahdeo |
| Developer |
| Email | gaura...@thoughtworks.com |
| Telephone | +91 9160688935 |
| |___
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