While looking into this issue further, found the following
1) The issue on the demo server was that there were a few data tables registered (having an entry in x_registered_table) but the corresponding MySQL tables were absent.
Removing the orphan registries resolved the issue. However, I am unsure as to what caused the problem (deleting the datable from the API removes the registry)
2) Another reason for observing this issue could be changes made to "lower_case_table_names" in mysql. In systems like Ubuntu, the default would be 0 (table names are stored as specified and comparisons are case sensitive) . Updating this setting in a running Mifos X installation to another value, say "1" (table names are stored in lowercase on disk and comparisons are not case sensitive) would result in MifosX not being able to find data tables which were created earlier with uppercase.
|