← Back to team overview

dhis2-users team mailing list archive

Re: [Dhis2-devs] How many records can Organization Unit hold up?

 

Knut and Muhammad,

I am quite sure that level is not the problem. Obviously, when moving from
level 9 to 10, the number of orgunits surges from 80 to 100,000 which is
more than 10 times. The number of orgunit matters here. I expected heap
memory problem here but the log did not say so.

Muhammad, could you try with level 10 but with little number of orgunit?


On Thu, May 21, 2015 at 5:40 PM, Knut Staring <knutst@xxxxxxxxx> wrote:

> I suppose it is not a very helpful comment, but I would seriously consider
> skipping some of those levels, if possible..though we should certainly
> still aim to understand what is causing your problem.
>
> On Thu, May 21, 2015 at 11:37 AM, Muhammad Tahir <mtagb09@xxxxxxxxx>
> wrote:
>
>> Hi Ngoc,
>>
>> Yes, I have loaded the table manually, but it works fine upto level 9, as
>> soon as the final level 10 orgunits are added, the app does start but on
>> browser I get 404 message.
>>
>> I have created another DB, loaded each level step by step and the app
>> works until level10 units are added.
>>
>> At present I have deployed only upto level 6 to check/configure other
>> options of DHIS2.
>>
>> *Level1*   *------ 1*
>> *Level2**   ------ **6*
>> *Level3*   *------ 9*
>> *Level4*  * ------  * *16*
>> *Level5**   ------ 130*
>> *Level6**  ------ 550*
>> * Level7**   ------ 900*
>> * Level8**   ------ 20000*
>> * Level9**   ------ 80,000*
>> * Level10 **------ 100,000*
>>
>> On Thu, May 21, 2015 at 12:46 PM, Ngoc Thanh Nguyen <
>> thanh.hispvietnam@xxxxxxxxx> wrote:
>>
>>> Hi Muhamad,
>>>
>>> Try with a blank db. If it works, then check with few orgunit, if it
>>> still works, switch to this current db. If the problem occurs, make sure
>>> your orgunit table is valid. As far as I get you used a manual tool to
>>> automatically insert to this orgunit table
>>>
>>> Thanh
>>> On Thu, May 21, 2015 at 11:10 AM, Muhammad Tahir <mtagb09@xxxxxxxxx>
>>> wrote:
>>>
>>>> Hi Knut,
>>>>
>>>> Yes, DHIS Live is being used at the moment. JAVA_OPTS was not set no my
>>>> machine but event I have added with value
>>>>
>>>> -Xms512M -Xmx1024M
>>>>
>>>> the problem remains the same(*HTTP ERROR: 404*).
>>>>
>>>>
>>>>
>>>> On Thu, May 21, 2015 at 12:19 AM, Knut Staring <knutst@xxxxxxxxx>
>>>> wrote:
>>>>
>>>>> Is that the whole log file? I see you are running this on your laptop
>>>>> as DHIS Live. Perhaps you could try allocating more memory to Java. What is
>>>>> your JAVA_OPTS?
>>>>>
>>>>> Knut
>>>>>
>>>>> On Wed, May 20, 2015 at 10:34 AM, Muhammad Tahir <mtagb09@xxxxxxxxx>
>>>>> wrote:
>>>>>
>>>>>> Hi Morten,
>>>>>>
>>>>>> Web page result:
>>>>>>
>>>>>> HTTP ERROR: 404
>>>>>>
>>>>>> Problem accessing /. Reason:
>>>>>>
>>>>>>     NOT_FOUND
>>>>>>
>>>>>> Powered by Jetty://
>>>>>>
>>>>>>
>>>>>>
>>>>>> Log file:
>>>>>> * INFO  15:31:27,201 Lifecycle: server stopped (TrayApp.java
>>>>>> [AWT-EventQueue-0])
>>>>>> * INFO  15:31:27,223 Exiting... (TrayApp.java [AWT-EventQueue-0])
>>>>>> * INFO  15:32:11,490 Environment variable DHIS2_HOME: null
>>>>>> (TrayApp.java [main])
>>>>>> * INFO  15:32:11,551 Initialising DHIS 2 Live... (TrayApp.java [main])
>>>>>> * INFO  15:32:11,623 Loading DHIS 2 on port: 8082 (WebAppServer.java
>>>>>> [main])
>>>>>> * INFO  15:32:11,658 Setting DHIS 2 web app context to:
>>>>>> /D:/DHIS2/Tools_Setup/dhis-live/webapps/dhis (WebAppServer.java [main])
>>>>>> * INFO  15:32:11,659 Lifecycle: server starting (TrayApp.java
>>>>>> [Thread-2])
>>>>>> * INFO  15:32:14,931 System property dhis2.home points to
>>>>>> /D:/DHIS2/Tools_Setup/dhis-live/conf (DefaultLocationManager.java
>>>>>> [Thread-2])
>>>>>> * INFO  15:32:15,631 Hibernate configuration loaded, using dialect:
>>>>>> org.hibernate.dialect.PostgreSQLDialect
>>>>>> (DefaultHibernateConfigurationProvider.java [Thread-2])
>>>>>> * INFO  15:32:30,340 Found the following message senders:
>>>>>> [org.hisp.dhis.message.EmailMessageSender@1ad234d,
>>>>>> org.hisp.dhis.sms.SmsMessageSender@ee212a]
>>>>>> (DefaultMessageService.java [Thread-2])
>>>>>> * INFO  15:32:39,016 Detected apps: [] (DefaultAppManager.java
>>>>>> [Thread-2])
>>>>>> * INFO  15:32:44,155 Executing startup routine [1 of 14, runlevel 1]:
>>>>>> InitTableAlteror (DefaultStartupRoutineExecutor.java [Thread-2])
>>>>>> * INFO  15:32:44,771 Executing startup routine [2 of 14, runlevel 2]:
>>>>>> PeriodTypePopulator (DefaultStartupRoutineExecutor.java [Thread-2])
>>>>>> * INFO  15:32:44,859 Executing startup routine [3 of 14, runlevel 2]:
>>>>>> DataElementDefaultDimensionPopulator (DefaultStartupRoutineExecutor.java
>>>>>> [Thread-2])
>>>>>> * INFO  15:32:45,093 Linked default category with default concept
>>>>>> (DataElementDefaultDimensionPopulator.java [Thread-2])
>>>>>> * INFO  15:32:45,170 Executing startup routine [4 of 14, runlevel 3]:
>>>>>> TrackerIdentityPopulator (DefaultStartupRoutineExecutor.java [Thread-2])
>>>>>> * INFO  15:33:18,812 Lifecycle: server started (TrayApp.java
>>>>>> [Thread-2])
>>>>>>
>>>>>> On Fri, May 15, 2015 at 3:03 PM, Morten Olav Hansen <
>>>>>> mortenoh@xxxxxxxxx> wrote:
>>>>>>
>>>>>>> Can you be a bit more specific? where does it "crash"? is it a
>>>>>>> browser issue? server issue? can you send us the relevant parts of the
>>>>>>> logs? (if any)
>>>>>>>
>>>>>>> If its the browser, can you open the developer tools (f12) and look
>>>>>>> in the javascript console and see if there is anything in red
>>>>>>>
>>>>>>> --
>>>>>>> Morten
>>>>>>>
>>>>>>> On Fri, May 15, 2015 at 4:39 PM, Muhammad Tahir <mtagb09@xxxxxxxxx>
>>>>>>> wrote:
>>>>>>>
>>>>>>>>
>>>>>>>> Hi,
>>>>>>>>
>>>>>>>> We have an organization level distribution as follows with number
>>>>>>>> of org units at each level.
>>>>>>>>
>>>>>>>> App crashes when the last level is uploaded into the system and we
>>>>>>>> try to browse the organization units. A new DB should be then used to use
>>>>>>>> the app.
>>>>>>>>
>>>>>>>> *Level1*   *------ 1*
>>>>>>>> *Level2**   ------ **6*
>>>>>>>> *Level3*   *------ 9*
>>>>>>>> *Level4*  * ------  * *16*
>>>>>>>> *Level5**   ------ 130*
>>>>>>>>  *Level6**  ------ 550*
>>>>>>>> * Level7**   ------ 900*
>>>>>>>> * Level8**   ------ 20000*
>>>>>>>> * Level9**   ------ 80,000*
>>>>>>>> * Level10 **------ 100,000*
>>>>>>>>
>>>>>>>> At present the app is deployed on a desktop machine with following
>>>>>>>> configuration.
>>>>>>>> Windows7, 4 Gb RAM, Intel Corei3 3.3 GHz.
>>>>>>>>
>>>>>>>>
>>>>>>>> --
>>>>>>>> *Regards,*
>>>>>>>> *Muhammad Tahir*
>>>>>>>>
>>>>>>>> _______________________________________________
>>>>>>>> Mailing list: https://launchpad.net/~dhis2-devs
>>>>>>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>>>>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> *Regards,*
>>>>>> *Muhammad Tahir*
>>>>>>
>>>>>> _______________________________________________
>>>>>> Mailing list: https://launchpad.net/~dhis2-devs
>>>>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Knut Staring
>>>>> Dept. of Informatics, University of Oslo
>>>>> Norway: +4791880522
>>>>> Skype: knutstar
>>>>> http://dhis2.org
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> *Regards,*
>>>> *Muhammad Tahir*
>>>>
>>>> _______________________________________________
>>>> Mailing list: https://launchpad.net/~dhis2-devs
>>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>> More help   : https://help.launchpad.net/ListHelp
>>>>
>>>>
>>>
>>
>>
>> --
>> *Regards,*
>> *Muhammad Tahir*
>>
>
>
>
> --
> Knut Staring
> Dept. of Informatics, University of Oslo
> Norway: +4791880522
> Skype: knutstar
> http://dhis2.org
>

Follow ups

References