You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@stratos.apache.org by "Martin Eppel (meppel)" <me...@cisco.com> on 2015/04/01 00:09:17 UTC

Question / Issue: Stratos 4.1.0: Data truncation: Data too long for column

I run into the following exception  when deploying the attached artefacts, which data is causing it and what is the max limit for it ?

Thanks

Martin

TID: [0] [STRATOS] [2015-03-31 22:00:11,630]  INFO {org.wso2.carbon.core.services.util.CarbonAuthenticationUtil} -  'admin@carbon.super [-1234]' logged in at [2015-03-31 22:00:11,630+0000]
TID: [0] [STRATOS] [2015-03-31 22:00:11,701]  INFO {org.wso2.carbon.core.services.util.CarbonAuthenticationUtil} -  'admin@carbon.super [-1234]' logged in at [2015-03-31 22:00:11,701+0000]
TID: [0] [STRATOS] [2015-03-31 22:00:12,521] ERROR {org.wso2.carbon.identity.oauth2.dao.TokenMgtDAO} -  Error when executing the SQL : INSERT INTO IDN_OAUTH2_ACCESS_TOKEN (ACCESS_TOKEN, REFRESH_TOKEN, CONSUMER_KEY, AUTHZ_USER, TIME_CREATED, VALIDITY_PERIOD, TOKEN_SCOPE, TOKEN_STATE, USER_TYPE) VALUES (?,?,?,?,?,?,?,?,?)
TID: [0] [STRATOS] [2015-03-31 22:00:12,522] ERROR {org.wso2.carbon.identity.oauth2.dao.TokenMgtDAO} -  Data truncation: Data too long for column 'TOKEN_SCOPE' at row 1
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'TOKEN_SCOPE' at row 1
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4230)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4164)
        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:2838)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2082)
        at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1307)
        at org.wso2.carbon.identity.oauth2.dao.TokenMgtDAO.storeAccessToken(TokenMgtDAO.java:120)
        at org.wso2.carbon.identity.oauth2.dao.TokenMgtDAO.storeAccessToken(TokenMgtDAO.java:137)