← Back to team overview

dhis2-devs team mailing list archive

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

 

I would try to load the levels directly on postgres.
On May 22, 2015 6:04 AM, "Ngoc Thanh Nguyen" <thanh.hispvietnam@xxxxxxxxx>
wrote:

> 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
>>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>

References