Re: [Dhis2-users] Favourites filtering intermittently refreshing
Hi Dan, I am not able to reproduce this by typing and waiting. However, it happens occasionally if I type very fast. I have added a 100 ms keyup event buffer which *seems* to solve the problem. Just commited to 2.13. Thanks for reporting. Please let me know if the issue is still there. Jan On Fri, Dec 13, 2013 at 1:19 PM, Lars Helge Ă˜verland larshe...@gmail.comwrote: Hi Dan, thank you. I have actually noticed this myself - we will check it out. cheers Lars On Fri, Dec 13, 2013 at 1:13 PM, Daniel Bridges dbrid...@akros.comwrote: Hi there, We have just recently migrated to the new 2.13 release and really enjoying the new features - thank you! However I have noticed some strange intermittent behaviour in both Firefox and Chrome (Linux OS) in the Data Visualiser. Basically if I open the Favourites menu and start typing, as expected the results are filtered. However quite often a few seconds after I finish typing, the list refreshes and is no longer filtered. It doesn't always happen, but more often than not, the filtering is lost.This obviously makes finding a chart quite a challenge. Is anyone else seeing this? Cheers Dan ___ 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 ___ 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] [Dhis2-devs] DHIS Import Log?
I would recommend looking at logs/catalina.out (assuming you are running tomcat) -- Morten On Mon, Dec 16, 2013 at 1:31 PM, Edwin Mulwa eddi...@gmail.com wrote: Hi, I am importing all metadata from one instance of DHIS2 to another. The import process seems to be hanging on the Importing Users section (see attached screenshot). Is there an import log that I can check to see what is happening? Edwin ___ 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-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] DHIS Import Log?
Ok, thanks. Yes I am... On Mon, Dec 16, 2013 at 3:37 PM, Morten Olav Hansen morte...@gmail.comwrote: I would recommend looking at logs/catalina.out (assuming you are running tomcat) -- Morten On Mon, Dec 16, 2013 at 1:31 PM, Edwin Mulwa eddi...@gmail.com wrote: Hi, I am importing all metadata from one instance of DHIS2 to another. The import process seems to be hanging on the Importing Users section (see attached screenshot). Is there an import log that I can check to see what is happening? Edwin ___ 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-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] DHIS Import Log?
Hi Morten, You pointed me in the right direction. Thanks. Taking a look at the log, it shows that there is a NULL value in surname field when its trying to insert a record in the userinfo table. I checked the source metadata.xml file and ensured that all surname entries have a value. I still get the same error. See attached log snippet. Any thoughts on why this is persisting even in the absence of NULL values? Edwin On Mon, Dec 16, 2013 at 4:59 AM, Edwin Mulwa eddi...@gmail.com wrote: Ok, thanks. Yes I am... On Mon, Dec 16, 2013 at 3:37 PM, Morten Olav Hansen morte...@gmail.comwrote: I would recommend looking at logs/catalina.out (assuming you are running tomcat) -- Morten On Mon, Dec 16, 2013 at 1:31 PM, Edwin Mulwa eddi...@gmail.com wrote: Hi, I am importing all metadata from one instance of DHIS2 to another. The import process seems to be hanging on the Importing Users section (see attached screenshot). Is there an import log that I can check to see what is happening? Edwin ___ 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 * INFO 2013-12-16 05:44:53,562 [Level: INFO, category: METADATA_IMPORT, time: Mon Dec 16 05:44:53 PST 2013, message: Importing 6303 Users] (InMemoryNotifier.java [taskScheduler-1]) * WARN 2013-12-16 05:44:53,969 SQL Error: 23502, SQLState: 23502 (SqlExceptionHelper.java [taskScheduler-1]) * ERROR 2013-12-16 05:44:53,969 NULL not allowed for column SURNAME; SQL statement: insert into userinfo (userinfoid, uid, code, lastUpdated, created, surname, firstName, email, phoneNumber, jobTitle, introduction, gender, birthday, nationality, employer, education, interests, languages, lastCheckedInterpretations) values (null, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [23502-173] (SqlExceptionHelper.java [taskScheduler-1]) * ERROR 2013-12-16 05:44:54,869 Unexpected error occurred in scheduled task. (TaskUtils.java [taskScheduler-1]) org.hibernate.exception.ConstraintViolationException: could not execute statement at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:128) at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:136) at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:96) at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:58) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2966) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3477) at org.hibernate.action.internal.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:81) at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:362) at org.hibernate.engine.spi.ActionQueue.addResolvedEntityInsertAction(ActionQueue.java:203) at org.hibernate.engine.spi.ActionQueue.addInsertAction(ActionQueue.java:183) at org.hibernate.engine.spi.ActionQueue.addAction(ActionQueue.java:167) at org.hibernate.event.internal.AbstractSaveEventListener.addInsertAction(AbstractSaveEventListener.java:321) at org.hibernate.event.internal.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:286) at org.hibernate.event.internal.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:192) at org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:125) at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:204) at org.hibernate.event.internal.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:55) at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:189) at org.hibernate.event.internal.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:49) at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:90) at org.hibernate.internal.SessionImpl.fireSave(SessionImpl.java:763) at org.hibernate.internal.SessionImpl.save(SessionImpl.java:755) at org.hibernate.internal.SessionImpl.save(SessionImpl.java:751) at org.hisp.dhis.hibernate.HibernateGenericStore.save(HibernateGenericStore.java:269) at
Re: [Dhis2-users] [Dhis2-devs] DHIS Import Log?
Hi Edwin, I'm not really sure.. if you know your way around a text-editor, you can try and remove all user but a few.. and see if it still fails, there might be a few users in there that have some errors -- Morten On Mon, Dec 16, 2013 at 2:52 PM, Edwin Mulwa eddi...@gmail.com wrote: Hi Morten, You pointed me in the right direction. Thanks. Taking a look at the log, it shows that there is a NULL value in surname field when its trying to insert a record in the userinfo table. I checked the source metadata.xml file and ensured that all surname entries have a value. I still get the same error. See attached log snippet. Any thoughts on why this is persisting even in the absence of NULL values? Edwin On Mon, Dec 16, 2013 at 4:59 AM, Edwin Mulwa eddi...@gmail.com wrote: Ok, thanks. Yes I am... On Mon, Dec 16, 2013 at 3:37 PM, Morten Olav Hansen morte...@gmail.comwrote: I would recommend looking at logs/catalina.out (assuming you are running tomcat) -- Morten On Mon, Dec 16, 2013 at 1:31 PM, Edwin Mulwa eddi...@gmail.com wrote: Hi, I am importing all metadata from one instance of DHIS2 to another. The import process seems to be hanging on the Importing Users section (see attached screenshot). Is there an import log that I can check to see what is happening? Edwin ___ 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-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp