Return-Path: X-Original-To: apmail-stratos-dev-archive@minotaur.apache.org Delivered-To: apmail-stratos-dev-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id C1F081754F for ; Tue, 31 Mar 2015 22:09:58 +0000 (UTC) Received: (qmail 44559 invoked by uid 500); 31 Mar 2015 22:09:58 -0000 Delivered-To: apmail-stratos-dev-archive@stratos.apache.org Received: (qmail 44510 invoked by uid 500); 31 Mar 2015 22:09:58 -0000 Mailing-List: contact dev-help@stratos.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@stratos.apache.org Delivered-To: mailing list dev@stratos.apache.org Received: (qmail 44498 invoked by uid 99); 31 Mar 2015 22:09:58 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 31 Mar 2015 22:09:58 +0000 X-ASF-Spam-Status: No, hits=-2.8 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_HI,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of meppel@cisco.com designates 173.37.86.76 as permitted sender) Received: from [173.37.86.76] (HELO rcdn-iport-5.cisco.com) (173.37.86.76) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 31 Mar 2015 22:09:52 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=cisco.com; i=@cisco.com; l=13259; q=dns/txt; s=iport; t=1427839792; x=1429049392; h=from:to:subject:date:message-id:mime-version; bh=rfU94IfUfv9VP54xx1yakoWY/bry/BxX7XbWZzJxqjk=; b=VB7JWn9OjRLP3vC2hxp84ToVjwpDgIhCx+0vsVDoKm03OtrtCpyOoMiy k7S3Cene4hkY1AsJ1fRk20uDIqwKEKEontK/DsdWkkT97rgTrUyPUZZtt pybkGEdcqhGnelMALbsd9kGLsSRBqfc5dsOLbirr6X+COIO7cvZBQnsw6 g=; X-Files: application.json, cartridge-group.json : 2966, 888 X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: A0ARBQDSGhtV/40NJK1TCYJDQ1JhySCCUgKBRUwBAQEBAQF9hBYBBC1eASomMCYBBBsGiCGlSqhzAQEBAQEBAQEBAQEBAQEBAQEBAQEBF49GBCYWgzmBFgWQYoFsgTKbEiKCAgMZgVCBckF/AQEB X-IronPort-AV: E=Sophos;i="5.11,503,1422921600"; d="json'?scan'208,217";a="408191639" Received: from alln-core-8.cisco.com ([173.36.13.141]) by rcdn-iport-5.cisco.com with ESMTP; 31 Mar 2015 22:09:18 +0000 Received: from xhc-aln-x05.cisco.com (xhc-aln-x05.cisco.com [173.36.12.79]) by alln-core-8.cisco.com (8.14.5/8.14.5) with ESMTP id t2VM9Ibs018416 (version=TLSv1/SSLv3 cipher=AES128-SHA bits=128 verify=FAIL) for ; Tue, 31 Mar 2015 22:09:18 GMT Received: from xmb-rcd-x12.cisco.com ([169.254.2.31]) by xhc-aln-x05.cisco.com ([173.36.12.79]) with mapi id 14.03.0195.001; Tue, 31 Mar 2015 17:09:18 -0500 From: "Martin Eppel (meppel)" To: "dev@stratos.apache.org" Subject: Question / Issue: Stratos 4.1.0: Data truncation: Data too long for column Thread-Topic: Question / Issue: Stratos 4.1.0: Data truncation: Data too long for column Thread-Index: AdBr/0rBOnIE7G5MRKmBhX8pB7cJhw== Date: Tue, 31 Mar 2015 22:09:17 +0000 Message-ID: <07110D8A7AC60C49AE2432100017A3F628981075@xmb-rcd-x12.cisco.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: yes X-MS-TNEF-Correlator: x-originating-ip: [10.155.32.110] Content-Type: multipart/mixed; boundary="_005_07110D8A7AC60C49AE2432100017A3F628981075xmbrcdx12ciscoc_" MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org --_005_07110D8A7AC60C49AE2432100017A3F628981075xmbrcdx12ciscoc_ Content-Type: multipart/alternative; boundary="_000_07110D8A7AC60C49AE2432100017A3F628981075xmbrcdx12ciscoc_" --_000_07110D8A7AC60C49AE2432100017A3F628981075xmbrcdx12ciscoc_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable 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.se= rvices.util.CarbonAuthenticationUtil} - 'admin@carbon.super [-1234]' logge= d 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.se= rvices.util.CarbonAuthenticationUtil} - 'admin@carbon.super [-1234]' logge= d in at [2015-03-31 22:00:11,701+0000] TID: [0] [STRATOS] [2015-03-31 22:00:12,521] ERROR {org.wso2.carbon.identit= y.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) VALUE= S (?,?,?,?,?,?,?,?,?) TID: [0] [STRATOS] [2015-03-31 22:00:12,522] ERROR {org.wso2.carbon.identit= y.oauth2.dao.TokenMgtDAO} - Data truncation: Data too long for column 'TOK= EN_SCOPE' at row 1 com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for colu= mn '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(PreparedStateme= nt.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) --_000_07110D8A7AC60C49AE2432100017A3F628981075xmbrcdx12ciscoc_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

I run into the following exception  when deploy= ing the attached artefacts, which data is causing it and what is the max li= mit for it ?

 

Thanks

 

Martin

 

TID: [0] [STRATOS] [2015-03-31 22:00:11,630]  I= NFO {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]  I= NFO {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 executi= ng the SQL : INSERT INTO IDN_OAUTH2_ACCESS_TOKEN (ACCESS_TOKEN, REFRESH_TOK= EN, 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: D= ata 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.my= sql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4230)

        at com.my= sql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4164)

        at com.my= sql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2615)

        at com.my= sql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2776)

        at com.my= sql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2838)

        at com.my= sql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2082)

        at com.my= sql.jdbc.PreparedStatement.execute(PreparedStatement.java:1307)<= /p>

        at org.ws= o2.carbon.identity.oauth2.dao.TokenMgtDAO.storeAccessToken(TokenMgtDAO.java= :120)

        at org.ws= o2.carbon.identity.oauth2.dao.TokenMgtDAO.storeAccessToken(TokenMgtDAO.java= :137)

--_000_07110D8A7AC60C49AE2432100017A3F628981075xmbrcdx12ciscoc_-- --_005_07110D8A7AC60C49AE2432100017A3F628981075xmbrcdx12ciscoc_ Content-Type: application/octet-stream; name="application.json" Content-Description: application.json Content-Disposition: attachment; filename="application.json"; size=2966; creation-date="Tue, 31 Mar 2015 22:07:42 GMT"; modification-date="Tue, 31 Mar 2015 22:07:42 GMT" Content-Transfer-Encoding: base64 ew0KICAiYWxpYXMiOiAic3Vic2NyaXB0aW9uLW5lc3RlZC1ncm91cHMtc3RhcnR1cC1HMS1HMi1H MyIsDQogICJhcHBsaWNhdGlvbklkIjogInN1YnNjcmlwdGlvbi1uZXN0ZWQtZ3JvdXBzLXN0YXJ0 dXAtRzEtRzItRzMiLA0KICAiY29tcG9uZW50cyI6IHsNCiAgICAiY2FydHJpZGdlcyI6IFtdLA0K ICAgICJncm91cHMiOiBbDQogICAgICB7DQogICAgICAgICJuYW1lIjogInN1YnNjcmlwdGlvbi1u ZXN0ZWQtZ3JvdXBzLXN0YXJ0dXAtRzEtRzItRzMiLA0KICAgICAgICAiZ3JvdXBNYXhJbnN0YW5j ZXMiOiAxLA0KICAgICAgICAiZ3JvdXBNaW5JbnN0YW5jZXMiOiAxLA0KICAgICAgICAiYWxpYXMi OiAic3Vic2NyaXB0aW9uLW5lc3RlZC1ncm91cHMtc3RhcnR1cC1HMS1HMi1HMyIsDQogICAgICAg ICJjYXJ0cmlkZ2VzIjogWw0KICAgICAgICAgIHsNCiAgICAgICAgICAgICJjYXJ0cmlkZ2VNaW4i OiAxLA0KICAgICAgICAgICAgImNhcnRyaWRnZU1heCI6IDEwMDAwMDAwLA0KICAgICAgICAgICAg InR5cGUiOiAiYzEiLA0KICAgICAgICAgICAgInN1YnNjcmliYWJsZUluZm8iOiB7DQogICAgICAg ICAgICAgICJhbGlhcyI6ICJjMS0weDAiLA0KICAgICAgICAgICAgICAiZGVwbG95bWVudFBvbGlj eSI6ICJzdGF0aWMtMSIsDQogICAgICAgICAgICAgICJhcnRpZmFjdFJlcG9zaXRvcnkiOiB7DQog ICAgICAgICAgICAgICAgInJlcG9Vc2VybmFtZSI6ICJ1c2VyIiwNCiAgICAgICAgICAgICAgICAi cmVwb1VybCI6ICJodHRwOi8vb2N0bC5xbW9nLmNpc2NvLmNvbToxMDA4MC9naXQvZGVmYXVsdC5n aXQiLA0KICAgICAgICAgICAgICAgICJwcml2YXRlUmVwbyI6IHRydWUsDQogICAgICAgICAgICAg ICAgInJlcG9QYXNzd29yZCI6ICJjLXBvbGljeSINCiAgICAgICAgICAgICAgfSwNCiAgICAgICAg ICAgICAgImF1dG9zY2FsaW5nUG9saWN5IjogImVjb25vbXlQb2xpY3kiDQogICAgICAgICAgICB9 DQogICAgICAgICAgfQ0KICAgICAgICBdLA0KICAgICAgICAiZ3JvdXBzIjogWw0KICAgICAgICAg IHsNCiAgICAgICAgICAgICJuYW1lIjogIm5lc3RlZC1ncm91cHMtc3RhcnR1cC1HMiIsDQogICAg ICAgICAgICAiZ3JvdXBNYXhJbnN0YW5jZXMiOiAxLA0KICAgICAgICAgICAgImdyb3VwTWluSW5z dGFuY2VzIjogMSwNCiAgICAgICAgICAgICJhbGlhcyI6ICJuZXN0ZWQtZ3JvdXBzLXN0YXJ0dXAt RzIiLA0KICAgICAgICAgICAgImNhcnRyaWRnZXMiOiBbDQogICAgICAgICAgICAgIHsNCiAgICAg ICAgICAgICAgICAiY2FydHJpZGdlTWluIjogMSwNCiAgICAgICAgICAgICAgICAiY2FydHJpZGdl TWF4IjogMTAwMDAwMDAsDQogICAgICAgICAgICAgICAgInR5cGUiOiAiYzIiLA0KICAgICAgICAg ICAgICAgICJzdWJzY3JpYmFibGVJbmZvIjogew0KICAgICAgICAgICAgICAgICAgImFsaWFzIjog ImMyLTF4MCIsDQogICAgICAgICAgICAgICAgICAiZGVwbG95bWVudFBvbGljeSI6ICJzdGF0aWMt MSIsDQogICAgICAgICAgICAgICAgICAiYXJ0aWZhY3RSZXBvc2l0b3J5Ijogew0KICAgICAgICAg ICAgICAgICAgICAicmVwb1VzZXJuYW1lIjogInVzZXIiLA0KICAgICAgICAgICAgICAgICAgICAi cmVwb1VybCI6ICJodHRwOi8vb2N0bC5xbW9nLmNpc2NvLmNvbToxMDA4MC9naXQvZGVmYXVsdC5n aXQiLA0KICAgICAgICAgICAgICAgICAgICAicHJpdmF0ZVJlcG8iOiB0cnVlLA0KICAgICAgICAg ICAgICAgICAgICAicmVwb1Bhc3N3b3JkIjogImMtcG9saWN5Ig0KICAgICAgICAgICAgICAgICAg fSwNCiAgICAgICAgICAgICAgICAgICJhdXRvc2NhbGluZ1BvbGljeSI6ICJlY29ub215UG9saWN5 Ig0KICAgICAgICAgICAgICAgIH0NCiAgICAgICAgICAgICAgfQ0KICAgICAgICAgICAgXSwNCiAg ICAgICAgICAgICJncm91cHMiOiBbDQogICAgICAgICAgICAgIHsNCiAgICAgICAgICAgICAgICAi bmFtZSI6ICJuZXN0ZWQtZ3JvdXBzLXN0YXJ0dXAtRzMiLA0KICAgICAgICAgICAgICAgICJncm91 cE1heEluc3RhbmNlcyI6IDEsDQogICAgICAgICAgICAgICAgImdyb3VwTWluSW5zdGFuY2VzIjog MSwNCiAgICAgICAgICAgICAgICAiYWxpYXMiOiAibmVzdGVkLWdyb3Vwcy1zdGFydHVwLUczIiwN CiAgICAgICAgICAgICAgICAiY2FydHJpZGdlcyI6IFsNCiAgICAgICAgICAgICAgICAgIHsNCiAg ICAgICAgICAgICAgICAgICAgImNhcnRyaWRnZU1pbiI6IDEsDQogICAgICAgICAgICAgICAgICAg ICJjYXJ0cmlkZ2VNYXgiOiAxMDAwMDAwMCwNCiAgICAgICAgICAgICAgICAgICAgInR5cGUiOiAi YzMiLA0KICAgICAgICAgICAgICAgICAgICAic3Vic2NyaWJhYmxlSW5mbyI6IHsNCiAgICAgICAg ICAgICAgICAgICAgICAiYWxpYXMiOiAiYzMtMngwIiwNCiAgICAgICAgICAgICAgICAgICAgICAi ZGVwbG95bWVudFBvbGljeSI6ICJzdGF0aWMtMSIsDQogICAgICAgICAgICAgICAgICAgICAgImFy dGlmYWN0UmVwb3NpdG9yeSI6IHsNCiAgICAgICAgICAgICAgICAgICAgICAgICJyZXBvVXNlcm5h bWUiOiAidXNlciIsDQogICAgICAgICAgICAgICAgICAgICAgICAicmVwb1VybCI6ICJodHRwOi8v b2N0bC5xbW9nLmNpc2NvLmNvbToxMDA4MC9naXQvZGVmYXVsdC5naXQiLA0KICAgICAgICAgICAg ICAgICAgICAgICAgInByaXZhdGVSZXBvIjogdHJ1ZSwNCiAgICAgICAgICAgICAgICAgICAgICAg ICJyZXBvUGFzc3dvcmQiOiAiYy1wb2xpY3kiDQogICAgICAgICAgICAgICAgICAgICAgfSwNCiAg ICAgICAgICAgICAgICAgICAgICAiYXV0b3NjYWxpbmdQb2xpY3kiOiAiZWNvbm9teVBvbGljeSIN CiAgICAgICAgICAgICAgICAgICAgfQ0KICAgICAgICAgICAgICAgICAgfQ0KICAgICAgICAgICAg ICAgIF0sDQogICAgICAgICAgICAgICAgImdyb3VwcyI6IFtdDQogICAgICAgICAgICAgIH0NCiAg ICAgICAgICAgIF0NCiAgICAgICAgICB9DQogICAgICAgIF0NCiAgICAgIH0NCiAgICBdDQogIH0N Cn0= --_005_07110D8A7AC60C49AE2432100017A3F628981075xmbrcdx12ciscoc_ Content-Type: application/octet-stream; name="cartridge-group.json" Content-Description: cartridge-group.json Content-Disposition: attachment; filename="cartridge-group.json"; size=888; creation-date="Tue, 31 Mar 2015 22:08:23 GMT"; modification-date="Tue, 31 Mar 2015 22:08:23 GMT" Content-Transfer-Encoding: base64 ew0KICAibmFtZSI6ICJzdWJzY3JpcHRpb24tbmVzdGVkLWdyb3Vwcy1zdGFydHVwLUcxLUcyLUcz IiwNCiAgImRlcGVuZGVuY2llcyI6IHsNCiAgICAidGVybWluYXRpb25CZWhhdmlvdXIiOiAidGVy bWluYXRlLW5vbmUiLA0KICAgICJzdGFydHVwT3JkZXJzIjogWw0KICAgICAgImdyb3VwLm5lc3Rl ZC1ncm91cHMtc3RhcnR1cC1HMi0weDAsY2FydHJpZGdlLmMxLTB4MCINCiAgICBdDQogIH0sDQog ICJjYXJ0cmlkZ2VzIjogWw0KICAgICJjMSINCiAgXSwNCiAgImdyb3VwcyI6IFsNCiAgICB7DQog ICAgICAibmFtZSI6ICJuZXN0ZWQtZ3JvdXBzLXN0YXJ0dXAtRzIiLA0KICAgICAgImRlcGVuZGVu Y2llcyI6IHsNCiAgICAgICAgInRlcm1pbmF0aW9uQmVoYXZpb3VyIjogInRlcm1pbmF0ZS1ub25l IiwNCiAgICAgICAgInN0YXJ0dXBPcmRlcnMiOiBbDQogICAgICAgICAgImdyb3VwLm5lc3RlZC1n cm91cHMtc3RhcnR1cC1HMy0xeDAsY2FydHJpZGdlLmMyLTF4MCINCiAgICAgICAgXQ0KICAgICAg fSwNCiAgICAgICJjYXJ0cmlkZ2VzIjogWw0KICAgICAgICAiYzIiDQogICAgICBdLA0KICAgICAg Imdyb3VwcyI6IFsNCiAgICAgICAgew0KICAgICAgICAgICJuYW1lIjogIm5lc3RlZC1ncm91cHMt c3RhcnR1cC1HMyIsDQogICAgICAgICAgImRlcGVuZGVuY2llcyI6IHsNCiAgICAgICAgICAgICJ0 ZXJtaW5hdGlvbkJlaGF2aW91ciI6ICJ0ZXJtaW5hdGUtbm9uZSIsDQogICAgICAgICAgICAic3Rh cnR1cE9yZGVycyI6IFtdDQogICAgICAgICAgfSwNCiAgICAgICAgICAiY2FydHJpZGdlcyI6IFsN CiAgICAgICAgICAgICJjMyINCiAgICAgICAgICBdLA0KICAgICAgICAgICJncm91cHMiOiBbXQ0K ICAgICAgICB9DQogICAgICBdDQogICAgfQ0KICBdDQp9 --_005_07110D8A7AC60C49AE2432100017A3F628981075xmbrcdx12ciscoc_--