Re: [Dev] [EMM] Value too long for column "DEVICE_MODEL VARCHAR(45) DEFAULT NULL": "'Google Nexus 6 - 5.0.0 - API 21 - 1440x2560_1-2'

[Geeth Munasinghe]

Hi Dushan,

Thanks for reporting this. We will fix this in the upcoming release
(IOT-3.1.0).

Thanks
Geeth

On Sat, Apr 29, 2017 at 10:39 PM, Dushan Abeyruwan  wrote:

>
> [2017-04-29 10:08:16,113] [IoT-Core] ERROR - DeviceTypePluginDAO Error
> occurred while adding the device '000' to the AD_DEVICE db.
> org.h2.jdbc.JdbcSQLException: Value too long for column "DEVICE_MODEL
> VARCHAR(45) DEFAULT NULL": "'Google Nexus 6 - 5.0.0 - API 21 -
> 1440x2560_1-2' (47)"; SQL statement:
> INSERT INTO AD_DEVICE(DEVICE_ID , GCM_TOKEN, DEVICE_INFO, IMEI, IMSI,
> OS_VERSION, DEVICE_MODEL, VENDOR, LATITUDE, LONGITUDE, SERIAL, MAC_ADDRESS,
> DEVICE_NAME, OS_BUILD_DATE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
> ?) [22001-175]
> at org.h2.message.DbException.getJdbcSQLException(DbException.java:332)
> at org.h2.message.DbException.get(DbException.java:172)
> at org.h2.table.Column.validateConvertUpdateSequence(Column.java:317)
> at org.h2.table.Table.validateConvertUpdate
> --
> Dushan Abeyruwan | Senior Technical Lead
> Technical Support,MV
> PMC Member Apache Synpase
> WSO2 Inc. http://wso2.com/
> Blog:*http://www.dushantech.com/ *
> LinkedIn:*https://www.linkedin.com/in/dushanabeyruwan
> *
> Mobile:(001)408-791-9312
>
>
> ___
> Dev mailing list
> Dev@wso2.org
> http://wso2.org/cgi-bin/mailman/listinfo/dev
>
>


-- 
*Geeth Munasinghe*
*WSO2, Inc. http://wso2.com  *
*lean.enterprise.middleware.*

email: ge...@wso2.com
phone:(+94) 777911226


___
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev

[Dev] [EMM] Value too long for column "DEVICE_MODEL VARCHAR(45) DEFAULT NULL": "'Google Nexus 6 - 5.0.0 - API 21 - 1440x2560_1-2'

[Dushan Abeyruwan]

[2017-04-29 10:08:16,113] [IoT-Core] ERROR - DeviceTypePluginDAO Error
occurred while adding the device '000' to the AD_DEVICE db.
org.h2.jdbc.JdbcSQLException: Value too long for column "DEVICE_MODEL
VARCHAR(45) DEFAULT NULL": "'Google Nexus 6 - 5.0.0 - API 21 -
1440x2560_1-2' (47)"; SQL statement:
INSERT INTO AD_DEVICE(DEVICE_ID , GCM_TOKEN, DEVICE_INFO, IMEI, IMSI,
OS_VERSION, DEVICE_MODEL, VENDOR, LATITUDE, LONGITUDE, SERIAL, MAC_ADDRESS,
DEVICE_NAME, OS_BUILD_DATE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?) [22001-175]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:332)
at org.h2.message.DbException.get(DbException.java:172)
at org.h2.table.Column.validateConvertUpdateSequence(Column.java:317)
at org.h2.table.Table.validateConvertUpdate
-- 
Dushan Abeyruwan | Senior Technical Lead
Technical Support,MV
PMC Member Apache Synpase
WSO2 Inc. http://wso2.com/
Blog:*http://www.dushantech.com/ *
LinkedIn:*https://www.linkedin.com/in/dushanabeyruwan
*
Mobile:(001)408-791-9312
___
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev