← Back to team overview

dhis2-users team mailing list archive

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

 

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*

Follow ups

References