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

2015-11-11 Thread Hannan Khan 
Dear Sumudu

Did you check the period table for duplicate period? If you removed all
duplicates and still the problem persists, then can try this:

Take a backup of your database.
Manually delete _periodstructure table.
Generate resource table again.

Hopefully your problem will be resolved.

Regards

Hannan Khan
HISP Bangladesh

On Thu, Nov 5, 2015 at 10:12 AM, sumudu weerasinghe 
wrote:

> Hi Lars,
>
> I upgraded it to 2.20 but it gives same error,  unable to generate
> resource tables.
> e
> Do i need to delete period 2015.01 from table contents?
> ​
>
> On Thu, Nov 5, 2015 at 6:59 AM, sumudu weerasinghe 
> wrote:
>
>> Thanks Lars,
>>  I will try to upgrade it today .
>>
>>-   Do i need to do the changes on "period" table before upgrade or
>>just upgrade my database according to upgrade note ?
>>-   Actually i want to upgrade up to 2.21 , is there issue in upgrade
>>in to 2.21
>>
>> regards
>> Sumudu
>>
>> On Thu, Nov 5, 2015 at 1:38 AM, Lars Helge Øverland 
>> wrote:
>>
>>> Hi Sumudu,
>>>
>>> this weakness was fixed in version 2.20 and later. Are you able to
>>> upgrade your instance?
>>>
>>> regards,
>>>
>>> Lars
>>>
>>>
>>> On Thu, Oct 29, 2015 at 3:15 AM, sumudu weerasinghe >> > wrote:
>>>
 Yes Morten,

 I tried it before and after deletion of period but still not work and
 giving same error.
 as in second error massage.




 On Thu, Oct 29, 2015 at 9:37 AM, Morten Olav Hansen >>> > wrote:

> Hi
>
> Did you try and prune your periods? it should be under data admin ->
> maintainence
>
> --
> Morten
>
> On Thu, Oct 29, 2015 at 10:50 AM, sumudu weerasinghe <
> sumudu...@gmail.com> wrote:
>
>> Dear all,
>>
>>
>> We use dhis 2.19 , tracker for Nutrition registry.
>> I had problem with resource table generation. error came as follows,
>>
>> ​
>> then according to previous discussion i delete the duplicate 01.2015
>> value from period table and their fk constrain from eventchart_ periods
>> table.
>>
>> Following above changes i got second error massage as follows,
>>
>>
>> ​
>> Can any one help on this matter?
>>
>>
>> Best Regards,
>>
>> Sumudu Weerasinghe
>> Teaching hospital Ragama,
>> Sri Lanka
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-d...@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-d...@lists.launchpad.net
 Unsubscribe : https://launchpad.net/~dhis2-devs
 More help   : https://help.launchpad.net/ListHelp


>>>
>>>
>>> --
>>> Lars Helge Øverland
>>> Lead developer, DHIS 2
>>> University of Oslo
>>> Skype: larshelgeoverland
>>> http://www.dhis2.org 
>>>
>>>
>>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] After Database Restore, Analytics table empty

2015-11-11 Thread Hannan Khan 
Dear Moses

Please check the disk space available as Lars suggested and also check the
physical memory used and virtual memory used during analytic operation.

The possible reason of backup size difference is one with analytic and
data-mart tables and the other one without these tables or blank. The log
you share in your mail doesn't content any error log which does not lead to
a solution. Can you please share the tomcat log file for that specif time
period after when the backup is small.

Regards

Hannan Khan
HISP Bangladesh

On Tue, Nov 10, 2015 at 7:58 PM, Lars Helge Øverland 
wrote:

> Sounds like an out of disk space issue. Perhaps verify that you have
> enough space on the partition you are storing the files on.
>
> On Tue, Nov 10, 2015 at 1:33 PM, Moses Marimo  wrote:
>
>> Hi Lars,
>>
>> I have seen where the problem was. Apparently, there is a scheduled
>> script that backs up the database. At some point, the size of the backup
>> file dropped from 2.3GB to 270MB. So, I was restoring this smaller file
>> while was definitely an incomplete file. I had to go back one week to get a
>> "healthy" looking backup file and it worked. So, there problem was not with
>> the DHIS2 software.
>>
>> Now, my currently problem is, why would a Postgresql backup file suddenly
>> fail that way, from 2.3GB to 270MB. I have tried to manually backup the
>> database and still same small backup file. The space on the server is about
>> 80% free space. I am using a pg_dump to backup the database on Ubuntu 14.04
>> LTS.
>>
>>
>>
>> On Mon, Nov 9, 2015 at 11:07 AM, Moses Marimo  wrote:
>>
>>> * INFO  2015-11-09 10:38:24,708 Indicator group set table generated 
>>> (DefaultResourceTableService.java [taskScheduler-5])
>>> * INFO  2015-11-09 10:38:24,717 Create organisation unit group set table 
>>> SQL: CREATE TABLE _organisationunitgroupsetstructure ( organisationunitid 
>>> INTEGER NOT NULL, organisationunitname VARCHAR (250), "Location" VARCHAR 
>>> (250), "NDAElbuYMNM" CHARACTER(11), "Ownership" VARCHAR (250), 
>>> "Y2vBvfxaIcS" CHARACTER(11), "Type" VARCHAR (250), "fguPo20Ggjj" 
>>> CHARACTER(11), PRIMARY KEY ( organisationunitid ) ) 
>>> (JdbcResourceTableStore.java [taskScheduler-5])
>>> * INFO  2015-11-09 10:38:24,719 Populate organisation unit group set 
>>> structure SQL: insert into _organisationunitgroupsetstructure select 
>>> ou.organisationunitid as organisationunitid, ou.name as 
>>> organisationunitname, (select oug.name from orgunitgroup oug inner join 
>>> orgunitgroupmembers ougm on ougm.orgunitgroupid = oug.orgunitgroupid inner 
>>> join orgunitgroupsetmembers ougsm on ougsm.orgunitgroupid = 
>>> ougm.orgunitgroupid and ougsm.orgunitgroupsetid = 2034 where 
>>> ougm.organisationunitid = ou.organisationunitid limit 1) as "Location", 
>>> (select oug.uid from orgunitgroup oug inner join orgunitgroupmembers ougm 
>>> on ougm.orgunitgroupid = oug.orgunitgroupid inner join 
>>> orgunitgroupsetmembers ougsm on ougsm.orgunitgroupid = ougm.orgunitgroupid 
>>> and ougsm.orgunitgroupsetid = 2034 where ougm.organisationunitid = 
>>> ou.organisationunitid limit 1) as "NDAElbuYMNM", (select oug.name from 
>>> orgunitgroup oug inner join orgunitgroupmembers ougm on ougm.orgunitgroupid 
>>> = oug.orgunitgroupid inner join orgunitgroupsetmembers ougsm on 
>>> ougsm.orgunitgroupid = ougm.orgunitgroupid and ougsm.orgunitgroupsetid = 
>>> 2032 where ougm.organisationunitid = ou.organisationunitid limit 1) as 
>>> "Ownership", (select oug.uid from orgunitgroup oug inner join 
>>> orgunitgroupmembers ougm on ougm.orgunitgroupid = oug.orgunitgroupid inner 
>>> join orgunitgroupsetmembers ougsm on ougsm.orgunitgroupid = 
>>> ougm.orgunitgroupid and ougsm.orgunitgroupsetid = 2032 where 
>>> ougm.organisationunitid = ou.organisationunitid limit 1) as "Y2vBvfxaIcS", 
>>> (select oug.name from orgunitgroup oug inner join orgunitgroupmembers ougm 
>>> on ougm.orgunitgroupid = oug.orgunitgroupid inner join 
>>> orgunitgroupsetmembers ougsm on ougsm.orgunitgroupid = ougm.orgunitgroupid 
>>> and ougsm.orgunitgroupsetid = 2033 where ougm.organisationunitid = 
>>> ou.organisationunitid limit 1) as "Type", (select oug.uid from orgunitgroup 
>>> oug inner join orgunitgroupmembers ougm on ougm.orgunitgroupid = 
>>> oug.orgunitgroupid inner join orgunitgroupsetmembers ougsm on 
>>> ougsm.orgunitgroupid = ougm.orgunitgroupid and ougsm.orgunitgroupsetid = 
>>> 2033 where ougm.organisationunitid = ou.organisationunitid limit 1) as 
>>> "fguPo20Ggjj" from organisationunit ou (JdbcResourceTableStore.java 
>>> [taskScheduler-5])
>>> * INFO  2015-11-09 10:38:24,921 Organisation unit group set table generated 
>>> (DefaultResourceTableService.java [taskScheduler-5])
>>> * INFO  2015-11-09 10:38:24,926 Create category structure table SQL: CREATE 
>>> TABLE _categorystructure ( categoryoptioncomboid INTEGER NOT NULL, 
>>> categoryoptioncomboname VARCHAR (250), PRIMARY KEY ( categoryoptioncomboid 
>>> ) ) (JdbcResourceTableStore.java [taskScheduler-5])
>

Re: [Dhis2-users] Error in tracker capture

2015-11-11 Thread Hannan Khan 
Dear Abdul Karim

It seems that your role is not properly defined.The role should contain
proper authorities to support Tracker Capture. The usual roles are:
"F_TRACKED_ENTITY_COMMENT_DELETE"
"F_TRACKED_ENTITY_DATAVALUE_ADD"
"F_TRACKED_ENTITY_DATAVALUE_DELETE"
"F_TRACKED_ENTITY_INSTANCE_ADD"
"F_TRACKED_ENTITY_INSTANCE_DASHBOARD"
"F_TRACKED_ENTITY_INSTANCE_DELETE"
"F_TRACKED_ENTITY_INSTANCE_HISTORY"
"F_TRACKED_ENTITY_INSTANCE_LIST"
"F_TRACKED_ENTITY_INSTANCE_MANAGEMENT"
"F_TRACKED_ENTITY_INSTANCE_SEARCH"

and more. Please check your role definition properly and problem might be
solved. Let me know if you need further help.

Regards

Hannan Khan
HISP Bangladesh

On Tue, Nov 10, 2015 at 6:58 PM, Abdul karim Jaafar <
abdulkarim.jaafa...@gmail.com> wrote:

> Dears,
>
>
>
> When I make users and assign them user role,
>
>
>
> I try to register a new person in tracker capture it give me an error,
>
>
>
> Unless I give to user “all” Authorities
>
>
>
> When I see demo in Sierra Leone, I see Authorities not existing in my
> DHIS2 version,
>
>
>
> The Error here
>
>
>
> I user DHIS2 version 2.21
>
>
>
> Regards;
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] data elements for tracker

2015-11-11 Thread channara rin 
Hi all members,
do you know data elements  for tracker can set option set for user entry
individual records can choose multi-value?

thank you
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp