← Back to team overview

dhis2-devs team mailing list archive

Re: How many records can Organization Unit hold up?

 

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