Fix is as following; The reason for the above error is, there is some Latin1 incompatible character in the following line, which is the *line 1008 of <APIM_HOME>/repository/conf/claim-config.xml*
<Description>End-User's birthday, represented as an ISO 8601:2004 *[ISO8601‑2004]* YYYY-MM-DD format. The year MAY be 0000, indicating that it is omitted. To represent only the year, YYYY format is allowed.</Description> The character which seems like a hyphen in the *[ISO8601‑2004] *part is not the normal hyphen (-) character. When I replaced that char with the normal hyphen, I could start the server, create an API, subscribe to the API and invoke it. On Thu, Jun 25, 2015 at 3:29 PM, Chamara Ariyarathne <[email protected]> wrote: > This instrcution seems wrong. I cannot startup Identity server with a > database created like this. I get the following exception trace; > > TID: [0] [IS] [2015-06-25 14:27:28,207] ERROR > {org.wso2.carbon.user.core.util.DatabaseUtil} - Database Error - Incorrect > string value: '\xE2\x80\x91200...' for column 'UM_DESCRIPTION' at row 1 > {org.wso2.carbon.user.core.util.DatabaseUtil} > java.sql.SQLException: Incorrect string value: '\xE2\x80\x91200...' for > column 'UM_DESCRIPTION' at row 1 > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1094) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4226) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4158) > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2615) > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2776) > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2840) > at > com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2082) > at > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2334) > at > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2262) > at > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2246) > at > org.wso2.carbon.user.core.claim.dao.ClaimDAO.addClaimMapping(ClaimDAO.java:227) > at > org.wso2.carbon.user.core.claim.dao.ClaimDAO.addCliamMappings(ClaimDAO.java:140) > at > org.wso2.carbon.user.core.common.DefaultRealm.populateProfileAndClaimMaps(DefaultRealm.java:420) > at > org.wso2.carbon.user.core.common.DefaultRealm.init(DefaultRealm.java:101) > at > org.wso2.carbon.user.core.common.DefaultRealmService.initializeRealm(DefaultRealmService.java:223) > at > org.wso2.carbon.user.core.common.DefaultRealmService.<init>(DefaultRealmService.java:101) > at > org.wso2.carbon.user.core.common.DefaultRealmService.<init>(DefaultRealmService.java:114) > at > org.wso2.carbon.user.core.internal.Activator.startDeploy(Activator.java:69) > 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] [IS] [2015-06-25 14:27:28,284] 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: Database Error - Incorrect > string value: '\xE2\x80\x91200...' for column 'UM_DESCRIPTION' at row 1 > at > org.wso2.carbon.user.core.claim.dao.ClaimDAO.addClaimMapping(ClaimDAO.java:261) > at > org.wso2.carbon.user.core.claim.dao.ClaimDAO.addCliamMappings(ClaimDAO.java:140) > at > org.wso2.carbon.user.core.common.DefaultRealm.populateProfileAndClaimMaps(DefaultRealm.java:420) > at > org.wso2.carbon.user.core.common.DefaultRealm.init(DefaultRealm.java:101) > at > org.wso2.carbon.user.core.common.DefaultRealmService.initializeRealm(DefaultRealmService.java:223) > at > org.wso2.carbon.user.core.common.DefaultRealmService.<init>(DefaultRealmService.java:101) > at > org.wso2.carbon.user.core.common.DefaultRealmService.<init>(DefaultRealmService.java:114) > at > org.wso2.carbon.user.core.internal.Activator.startDeploy(Activator.java:69) > 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: java.sql.SQLException: Incorrect string value: > '\xE2\x80\x91200...' for column 'UM_DESCRIPTION' at row 1 > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1094) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4226) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4158) > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2615) > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2776) > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2840) > at > com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2082) > at > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2334) > at > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2262) > at > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2246) > at > org.wso2.carbon.user.core.claim.dao.ClaimDAO.addClaimMapping(ClaimDAO.java:227) > ... 23 more > TID: [0] [IS] [2015-06-25 14:27:28,285] 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:231) > at > org.wso2.carbon.user.core.common.DefaultRealmService.<init>(DefaultRealmService.java:101) > at > org.wso2.carbon.user.core.common.DefaultRealmService.<init>(DefaultRealmService.java:114) > at > org.wso2.carbon.user.core.internal.Activator.startDeploy(Activator.java:69) > 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: Database Error - > Incorrect string value: '\xE2\x80\x91200...' for column 'UM_DESCRIPTION' at > row 1 > at > org.wso2.carbon.user.core.claim.dao.ClaimDAO.addClaimMapping(ClaimDAO.java:261) > at > org.wso2.carbon.user.core.claim.dao.ClaimDAO.addCliamMappings(ClaimDAO.java:140) > at > org.wso2.carbon.user.core.common.DefaultRealm.populateProfileAndClaimMaps(DefaultRealm.java:420) > at > org.wso2.carbon.user.core.common.DefaultRealm.init(DefaultRealm.java:101) > at > org.wso2.carbon.user.core.common.DefaultRealmService.initializeRealm(DefaultRealmService.java:223) > ... 19 more > Caused by: java.sql.SQLException: Incorrect string value: > '\xE2\x80\x91200...' for column 'UM_DESCRIPTION' at row 1 > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1094) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4226) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4158) > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2615) > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2776) > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2840) > at > com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2082) > at > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2334) > at > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2262) > at > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2246) > at > org.wso2.carbon.user.core.claim.dao.ClaimDAO.addClaimMapping(ClaimDAO.java:227) > ... 23 more > > > On Thu, Jun 25, 2015 at 1:05 PM, Chamara Ariyarathne <[email protected]> > wrote: > >> For the script api-manager 1.9.0 apimgt/mysql.sql. >> >> On Thu, Jun 25, 2015 at 1:02 PM, Chamara Ariyarathne <[email protected]> >> wrote: >> >>> I got this same error for apimanager table creation in following >>> environment. >>> mysql Ver 14.14 Distrib 5.1.73, for redhat-linux-gnu (x86_64) using >>> readline 5.1 >>> >>> ERROR 1071 (42000): Specified key was too long; max key length is 767 >>> bytes >>> ERROR 1146 (42S02): Table 'apimanager.IDN_OAUTH2_ACCESS_TOKEN' doesn't >>> exist >>> >>> What difference does it make when using "character set latin1" ? >>> >>> On Fri, Apr 17, 2015 at 10:32 AM, Vinod Kavinda <[email protected]> wrote: >>> >>>> Hi Godwin, >>>> It worked. thanks a lot. >>>> >>>> Regards, >>>> Vinod >>>> >>>> On Fri, Apr 17, 2015 at 2:47 PM, Godwin Amila Shrimal <[email protected]> >>>> wrote: >>>> >>>>> Hi, >>>>> >>>>> Use latin1 character set. >>>>> >>>>> >>>>> Thanks >>>>> Godwin >>>>> >>>>> >>>>> On Fri, Apr 17, 2015 at 2:40 PM, Vinod Kavinda <[email protected]> wrote: >>>>> >>>>>> Hi, >>>>>> I'm getting the following error while trying to setup a mysql >>>>>> datastore, when running the dbscript located at >>>>>> '<PRODUCT_HOME>/dbscripts/mysql.sql'. >>>>>> Error - *ERROR 1071 (42000) at line 31: Specified key was too long; >>>>>> max key length is 767 bytes* >>>>>> >>>>>> I tried reducing the REG_PATH_VALUE length to 100(mysql.sql >>>>>> attached), with no luck. >>>>>> There is a similar issue[1] that has already resolved. >>>>>> >>>>>> mysql version - mysql Ver 14.14 Distrib 5.6.22, for osx10.9 (x86_64) >>>>>> mysql command used - mysql -u root -p BAR < mysql.sql >>>>>> >>>>>> Any help is appreciated. >>>>>> >>>>>> [1] - https://wso2.org/jira/browse/CARBON-5917 >>>>>> >>>>>> Regards, >>>>>> Vinod Kavinda >>>>>> >>>>>> -- >>>>>> Vinod Kavinda >>>>>> Software Engineer, *WSO2, Inc <http://www.wso2.com>.* >>>>>> Mobile : +94 (0) 712 415544 >>>>>> [email protected] >>>>>> >>>>>> _______________________________________________ >>>>>> Dev mailing list >>>>>> [email protected] >>>>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>>>> >>>>>> >>>>> >>>>> >>>>> -- >>>>> *Godwin Amila Shrimal* >>>>> Senior Software Engineer >>>>> WSO2 Inc.; http://wso2.com >>>>> lean.enterprise.middleware >>>>> >>>>> mobile: *+94772264165* >>>>> linkedin: *http://lnkd.in/KUum6D <http://lnkd.in/KUum6D>* >>>>> twitter: https://twitter.com/godwinamila >>>>> >>>> >>>> >>>> >>>> -- >>>> Vinod Kavinda >>>> Software Engineer, *WSO2, Inc <http://www.wso2.com>.* >>>> Mobile : +94 (0) 712 415544 >>>> [email protected] >>>> >>>> _______________________________________________ >>>> Dev mailing list >>>> [email protected] >>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>> >>>> >>> >>> >>> -- >>> *Chamara Ariyarathne* >>> Associate Technical Lead - Quality Assurance >>> WSO2 Inc; http://www.wso2.com/ >>> Mobile; *+94772786766 <%2B94772786766>* >>> >> >> >> >> -- >> *Chamara Ariyarathne* >> Associate Technical Lead - Quality Assurance >> WSO2 Inc; http://www.wso2.com/ >> Mobile; *+94772786766 <%2B94772786766>* >> > > > > -- > *Chamara Ariyarathne* > Associate Technical Lead - Quality Assurance > WSO2 Inc; http://www.wso2.com/ > Mobile; *+94772786766 <%2B94772786766>* > -- *Chamara Ariyarathne* Associate Technical Lead - Quality Assurance WSO2 Inc; http://www.wso2.com/ Mobile; *+94772786766*
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
