I managed to overcome start-up problem by creating UM_CLAIM_BEHAVIOR table manually but I could not test functionality. This error occurred when I try to integrate BAM 2.3.0 and MB 2.1.0 with a Carbon 4.2.0 based WSO2 server cluster.
Thanks, Deependra. On Sat, Sep 7, 2013 at 8:23 AM, Asanka Vithanage <[email protected]> wrote: > Hi All, > > When trying to point BAM 2.3.0 to an UseStore (which already pointed to AS > 5.2.0), Observed following exception. > > > TID: [0] [BAM] [2013-09-06 23:43:06,035] INFO > {org.wso2.carbon.databridge.agent.thrift.internal.AgentDS} - Successfully > deployed Agent Client > {org.wso2.carbon.databridge.agent.thrift.internal.AgentDS} > TID: [0] [BAM] [2013-09-06 23:43:07,005] INFO > {org.wso2.carbon.user.core.common.DefaultRealmService} - Database already > exists. Not creating a new database. > {org.wso2.carbon.user.core.common.DefaultRealmService} > TID: [0] [BAM] [2013-09-06 23:43:07,060] ERROR > {org.wso2.carbon.user.core.util.DatabaseUtil} - Database Error - Table > 'WSO2CARBON_DB.UM_CLAIM_BEHAVIOR' doesn't exist > {org.wso2.carbon.user.core.util.DatabaseUtil} > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table > 'WSO2CARBON_DB.UM_CLAIM_BEHAVIOR' doesn't exist > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native > Method) > at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > at java.lang.reflect.Constructor.newInstance(Constructor.java:525) > at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) > at com.mysql.jdbc.Util.getInstance(Util.java:386) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541) > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002) > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163) > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2624) > at > com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2127) > at > com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2293) > at > org.wso2.carbon.user.core.profile.dao.ProfileConfigDAO.loadProfileConfigs(ProfileConfigDAO.java:127) > at > org.wso2.carbon.user.core.profile.builder.ProfileConfigurationBuilder.buildProfileConfigurationFromDatabase(ProfileConfigurationBuilder.java:84) > at > org.wso2.carbon.user.core.common.DefaultRealm.populateProfileAndClaimMaps(DefaultRealm.java:339) > at > org.wso2.carbon.user.core.common.DefaultRealm.init(DefaultRealm.java:109) > at > org.wso2.carbon.user.core.common.DefaultRealmService.initializeRealm(DefaultRealmService.java:223) > at > org.wso2.carbon.user.core.common.DefaultRealmService.<init>(DefaultRealmService.java:103) > at > org.wso2.carbon.user.core.common.DefaultRealmService.<init>(DefaultRealmService.java:116) > at > org.wso2.carbon.user.core.internal.Activator.startDeploy(Activator.java:67) > at > org.wso2.carbon.user.core.internal.BundleCheckActivator.start(BundleCheckActivator.java:61) > at > org.eclipse.osgi.framework.internal.core.BundleContextImpl$1.run(BundleContextImpl.java:711) > at java.security.AccessController.doPrivileged(Native Method) > at > org.eclipse.osgi.framework.internal.core.BundleContextImpl.startActivator(BundleContextImpl.java:702) > at > org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:683) > at > org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHost.java:381) > at > org.eclipse.osgi.framework.internal.core.AbstractBundle.resume(AbstractBundle.java:390) > at > org.eclipse.osgi.framework.internal.core.Framework.resumeBundle(Framework.java:1176) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManager.java:559) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManager.java:544) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.incFWSL(StartLevelManager.java:457) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.doSetStartLevel(StartLevelManager.java:243) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.dispatchEvent(StartLevelManager.java:438) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.dispatchEvent(StartLevelManager.java:1) > at > org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230) > at > org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(EventManager.java:340) > TID: [0] [BAM] [2013-09-06 23:43:07,063] ERROR > {org.wso2.carbon.user.core.profile.builder.ProfileConfigurationBuilder} - > Database Error - Table 'WSO2CARBON_DB.UM_CLAIM_BEHAVIOR' doesn't exist > {org.wso2.carbon.user.core.profile.builder.ProfileConfigurationBuilder} > org.wso2.carbon.user.core.UserStoreException: Database Error - Table > 'WSO2CARBON_DB.UM_CLAIM_BEHAVIOR' doesn't exist > at > org.wso2.carbon.user.core.profile.dao.ProfileConfigDAO.loadProfileConfigs(ProfileConfigDAO.java:152) > at > org.wso2.carbon.user.core.profile.builder.ProfileConfigurationBuilder.buildProfileConfigurationFromDatabase(ProfileConfigurationBuilder.java:84) > at > org.wso2.carbon.user.core.common.DefaultRealm.populateProfileAndClaimMaps(DefaultRealm.java:339) > at > org.wso2.carbon.user.core.common.DefaultRealm.init(DefaultRealm.java:109) > at > org.wso2.carbon.user.core.common.DefaultRealmService.initializeRealm(DefaultRealmService.java:223) > at > org.wso2.carbon.user.core.common.DefaultRealmService.<init>(DefaultRealmService.java:103) > at > org.wso2.carbon.user.core.common.DefaultRealmService.<init>(DefaultRealmService.java:116) > at > org.wso2.carbon.user.core.internal.Activator.startDeploy(Activator.java:67) > at > org.wso2.carbon.user.core.internal.BundleCheckActivator.start(BundleCheckActivator.java:61) > at > org.eclipse.osgi.framework.internal.core.BundleContextImpl$1.run(BundleContextImpl.java:711) > at java.security.AccessController.doPrivileged(Native Method) > at > org.eclipse.osgi.framework.internal.core.BundleContextImpl.startActivator(BundleContextImpl.java:702) > at > org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:683) > at > org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHost.java:381) > at > org.eclipse.osgi.framework.internal.core.AbstractBundle.resume(AbstractBundle.java:390) > at > org.eclipse.osgi.framework.internal.core.Framework.resumeBundle(Framework.java:1176) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManager.java:559) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManager.java:544) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.incFWSL(StartLevelManager.java:457) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.doSetStartLevel(StartLevelManager.java:243) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.dispatchEvent(StartLevelManager.java:438) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.dispatchEvent(StartLevelManager.java:1) > at > org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230) > at > org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(EventManager.java:340) > Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: > Table 'WSO2CARBON_DB.UM_CLAIM_BEHAVIOR' doesn't exist > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native > Method) > at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > at java.lang.reflect.Constructor.newInstance(Constructor.java:525) > at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) > at com.mysql.jdbc.Util.getInstance(Util.java:386) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541) > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002) > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163) > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2624) > at > com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2127) > at > com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2293) > at > org.wso2.carbon.user.core.profile.dao.ProfileConfigDAO.loadProfileConfigs(ProfileConfigDAO.java:127) > ... 23 more > TID: [0] [BAM] [2013-09-06 23:43:07,065] ERROR > {org.wso2.carbon.user.core.common.DefaultRealm} - Error in building the > profile. {org.wso2.carbon.user.core.common.DefaultRealm} > TID: [0] [BAM] [2013-09-06 23:43:07,065] ERROR > {org.wso2.carbon.user.core.common.DefaultRealmService} - Cannot initialize > the realm. {org.wso2.carbon.user.core.common.DefaultRealmService} > org.wso2.carbon.user.core.UserStoreException: Error in building the > profile. > at > org.wso2.carbon.user.core.common.DefaultRealm.populateProfileAndClaimMaps(DefaultRealm.java:344) > at > org.wso2.carbon.user.core.common.DefaultRealm.init(DefaultRealm.java:109) > at > org.wso2.carbon.user.core.common.DefaultRealmService.initializeRealm(DefaultRealmService.java:223) > at > org.wso2.carbon.user.core.common.DefaultRealmService.<init>(DefaultRealmService.java:103) > at > org.wso2.carbon.user.core.common.DefaultRealmService.<init>(DefaultRealmService.java:116) > at > org.wso2.carbon.user.core.internal.Activator.startDeploy(Activator.java:67) > at > org.wso2.carbon.user.core.internal.BundleCheckActivator.start(BundleCheckActivator.java:61) > at > org.eclipse.osgi.framework.internal.core.BundleContextImpl$1.run(BundleContextImpl.java:711) > at java.security.AccessController.doPrivileged(Native Method) > at > org.eclipse.osgi.framework.internal.core.BundleContextImpl.startActivator(BundleContextImpl.java:702) > at > org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:683) > at > org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHost.java:381) > at > org.eclipse.osgi.framework.internal.core.AbstractBundle.resume(AbstractBundle.java:390) > at > org.eclipse.osgi.framework.internal.core.Framework.resumeBundle(Framework.java:1176) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManager.java:559) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManager.java:544) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.incFWSL(StartLevelManager.java:457) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.doSetStartLevel(StartLevelManager.java:243) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.dispatchEvent(StartLevelManager.java:438) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.dispatchEvent(StartLevelManager.java:1) > at > org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230) > at > org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(EventManager.java:340) > Caused by: > org.wso2.carbon.user.core.profile.builder.ProfileBuilderException: Database > Error - Table 'WSO2CARBON_DB.UM_CLAIM_BEHAVIOR' doesn't exist > at > org.wso2.carbon.user.core.profile.builder.ProfileConfigurationBuilder.buildProfileConfigurationFromDatabase(ProfileConfigurationBuilder.java:88) > at > org.wso2.carbon.user.core.common.DefaultRealm.populateProfileAndClaimMaps(DefaultRealm.java:339) > ... 21 more > Caused by: org.wso2.carbon.user.core.UserStoreException: Database Error - > Table 'WSO2CARBON_DB.UM_CLAIM_BEHAVIOR' doesn't exist > at > org.wso2.carbon.user.core.profile.dao.ProfileConfigDAO.loadProfileConfigs(ProfileConfigDAO.java:152) > at > org.wso2.carbon.user.core.profile.builder.ProfileConfigurationBuilder.buildProfileConfigurationFromDatabase(ProfileConfigurationBuilder.java:84) > ... 22 more > Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: > Table 'WSO2CARBON_DB.UM_CLAIM_BEHAVIOR' doesn't exist > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native > Method) > at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > at java.lang.reflect.Constructor.newInstance(Constructor.java:525) > at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) > at com.mysql.jdbc.Util.getInstance(Util.java:386) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541) > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002) > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163) > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2624) > at > com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2127) > at > com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2293) > at > org.wso2.carbon.user.core.profile.dao.ProfileConfigDAO.loadProfileConfigs(ProfileConfigDAO.java:127) > ... 23 more > TID: [0] [BAM] [2013-09-06 23:43:07,067] ERROR > {org.wso2.carbon.user.core.internal.Activator} - Cannot start User Manager > Core bundle {org.wso2.carbon.user.core.internal.Activator} > org.wso2.carbon.user.core.UserStoreException: Cannot initialize the realm. > at > org.wso2.carbon.user.core.common.DefaultRealmService.initializeRealm(DefaultRealmService.java:227) > at > org.wso2.carbon.user.core.common.DefaultRealmService.<init>(DefaultRealmService.java:103) > at > org.wso2.carbon.user.core.common.DefaultRealmService.<init>(DefaultRealmService.java:116) > at > org.wso2.carbon.user.core.internal.Activator.startDeploy(Activator.java:67) > at > org.wso2.carbon.user.core.internal.BundleCheckActivator.start(BundleCheckActivator.java:61) > at > org.eclipse.osgi.framework.internal.core.BundleContextImpl$1.run(BundleContextImpl.java:711) > at java.security.AccessController.doPrivileged(Native Method) > at > org.eclipse.osgi.framework.internal.core.BundleContextImpl.startActivator(BundleContextImpl.java:702) > at > org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:683) > at > org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHost.java:381) > at > org.eclipse.osgi.framework.internal.core.AbstractBundle.resume(AbstractBundle.java:390) > at > org.eclipse.osgi.framework.internal.core.Framework.resumeBundle(Framework.java:1176) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManager.java:559) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManager.java:544) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.incFWSL(StartLevelManager.java:457) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.doSetStartLevel(StartLevelManager.java:243) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.dispatchEvent(StartLevelManager.java:438) > at > org.eclipse.osgi.framework.internal.core.StartLevelManager.dispatchEvent(StartLevelManager.java:1) > at > org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230) > at > org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(EventManager.java:340) > Caused by: org.wso2.carbon.user.core.UserStoreException: Error in building > the profile. > at > org.wso2.carbon.user.core.common.DefaultRealm.populateProfileAndClaimMaps(DefaultRealm.java:344) > at > org.wso2.carbon.user.core.common.DefaultRealm.init(DefaultRealm.java:109) > at > org.wso2.carbon.user.core.common.DefaultRealmService.initializeRealm(DefaultRealmService.java:223) > ... 19 more > Caused by: > org.wso2.carbon.user.core.profile.builder.ProfileBuilderException: Database > Error - Table 'WSO2CARBON_DB.UM_CLAIM_BEHAVIOR' doesn't exist > at > org.wso2.carbon.user.core.profile.builder.ProfileConfigurationBuilder.buildProfileConfigurationFromDatabase(ProfileConfigurationBuilder.java:88) > at > org.wso2.carbon.user.core.common.DefaultRealm.populateProfileAndClaimMaps(DefaultRealm.java:339) > ... 21 more > Caused by: org.wso2.carbon.user.core.UserStoreException: Database Error - > Table 'WSO2CARBON_DB.UM_CLAIM_BEHAVIOR' doesn't exist > at > org.wso2.carbon.user.core.profile.dao.ProfileConfigDAO.loadProfileConfigs(ProfileConfigDAO.java:152) > at > org.wso2.carbon.user.core.profile.builder.ProfileConfigurationBuilder.buildProfileConfigurationFromDatabase(ProfileConfigurationBuilder.java:84) > ... 22 more > Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: > Table 'WSO2CARBON_DB.UM_CLAIM_BEHAVIOR' doesn't exist > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native > Method) > at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > at java.lang.reflect.Constructor.newInstance(Constructor.java:525) > at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) > at com.mysql.jdbc.Util.getInstance(Util.java:386) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541) > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002) > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163) > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2624) > at > com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2127) > at > com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2293) > at > org.wso2.carbon.user.core.profile.dao.ProfileConfigDAO.loadProfileConfigs(ProfileConfigDAO.java:127) > ... 23 more > > Seems new userstore creation dbscript (AS 5.2.0) missing the > WSO2CARBON_DB.UM_CLAIM_ BEHAVIOR table creation steps? > > Please have a look? > > > -- Deependra Ariyadewa WSO2, Inc. http://wso2.com/ http://wso2.org email [email protected]; cell +94 71 403 5996 ; Blog http://risenfall.wordpress.com/ PGP info: KeyID: 'DC627E6F' *WSO2 - Lean . Enterprise . Middleware*
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
