Wso2emm - App Management Never Returns List Of Users With App Installed/not Installed

I have wso2emm version 1.1.0 installed on a Linux CentOS 6.5 with a separate MySQL DB Server. Everything seems to work fine: I can create users, send invites, have android agent i

Solution 1:

This isn't a permanent solution, but it's a workaround that'll do the job until someone comes up with something better.

Back up the database files in EMM_HOME/repository/database on a regular basis; and then when the issue occurs, shut down the service and overwrite the WSO2EMM_DB.h2.db file with the latest backup made.

Something is causing the WSO2EMM_DB.h2.db file to get overinflated somehow. This happened to me tonight, and the bad file had a size of 49,016 KB, while the good file I backed up when the last changes were made has a size of 4,872 KB. That's a pretty significant difference.

EDIT: I've been running the server without making any changes to and keeping an eye on the WSO2EMM_DB.h2.db file. It seems to gain about 2 megabytes in size every hour. At first I thought it didn't gain size at a slow steady rate, rather all at once every hour, but after further experimentation I found it does in fact grow steadily.

Solution 2:

I remember there is an error in mysql script, you can verify by running h2 database. If it works, then it is an error caused by mysql script.

Solution 3:

This issue appears to be fixed with EMM 2.0, available here.