Actually i have a WSO2 IS 5.7.0 hosted, now i'm migrating to WSO2 IS 7.0.0. In the Console i added as a Database User Store the one from 5.7.0, the connection is fine, the problem is when the new server tries to do any query, due to the different schemas the queries doesn't match at all. For example the most common trouble i'm facing is:
Caused by: .wso2.carbon.user.core.UserStoreException: Database error occurred while listing users for a property : uid & value : cfernadnez02546 & profile name : default
at .wso2.carbon.user.core.jdbc.UniqueIDJDBCUserStoreManager.doGetUserListFromPropertiesWithID(UniqueIDJDBCUserStoreManager.java:2558)
at .wso2.carbon.user.coremon.AbstractUserStoreManager.doGetUserListWithID(AbstractUserStoreManager.java:3349)
at .wso2.carbon.user.coremon.AbstractUserStoreManager.getUserListWithID(AbstractUserStoreManager.java:3277)
... 70 more
Caused by: java.sql.SQLSyntaxErrorException: Unknown column 'UM_USER.UM_USER_ID' in 'field list'
I need some advice of how to face this issue, i've got on my mind modifying the UserStore class, and extending it to a new one, but reading the source code from the default manager, UniqueJDBCUserStoreManager, it just uses the SQL queries already defined in the configurations xml, leading to the same exception.
Right now i'm trying to migrate the old DB to the newest schema with a script, but i don't know if that's the way.
Actually i have a WSO2 IS 5.7.0 hosted, now i'm migrating to WSO2 IS 7.0.0. In the Console i added as a Database User Store the one from 5.7.0, the connection is fine, the problem is when the new server tries to do any query, due to the different schemas the queries doesn't match at all. For example the most common trouble i'm facing is:
Caused by: .wso2.carbon.user.core.UserStoreException: Database error occurred while listing users for a property : uid & value : cfernadnez02546 & profile name : default
at .wso2.carbon.user.core.jdbc.UniqueIDJDBCUserStoreManager.doGetUserListFromPropertiesWithID(UniqueIDJDBCUserStoreManager.java:2558)
at .wso2.carbon.user.coremon.AbstractUserStoreManager.doGetUserListWithID(AbstractUserStoreManager.java:3349)
at .wso2.carbon.user.coremon.AbstractUserStoreManager.getUserListWithID(AbstractUserStoreManager.java:3277)
... 70 more
Caused by: java.sql.SQLSyntaxErrorException: Unknown column 'UM_USER.UM_USER_ID' in 'field list'
I need some advice of how to face this issue, i've got on my mind modifying the UserStore class, and extending it to a new one, but reading the source code from the default manager, UniqueJDBCUserStoreManager, it just uses the SQL queries already defined in the configurations xml, leading to the same exception.
Right now i'm trying to migrate the old DB to the newest schema with a script, but i don't know if that's the way.
Share Improve this question edited Mar 19 at 18:51 Shadow 34.3k10 gold badges65 silver badges75 bronze badges asked Mar 19 at 14:52 Carlos FernándezCarlos Fernández 314 bronze badges 1- If you migrated to a new version if this software, then why didn't you migrate its database as well? – Shadow Commented Mar 19 at 18:52
1 Answer
Reset to default 0If your goal is to migrate from WSO2 IS 5.7.0 to 7.0.0, and you're using the same user store, you will need to migrate the existing database schema from the old version (5.7.0) to the new schema used by 7.0.0.