Hi All,
This is regarding the issue https://wso2.org/jira/browse/BPS-212. The error
log is as follows.
TID: [0] [BPS] [2012-10-15 16:44:41,069] ERROR
{org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO} - Failed to add
properties to the resource
/_system/config/bpel/packages/ClaimsApprovalProcess/versions/ClaimsApprovalProcess-6.
Value too long for column "REG_NAME VARCHAR(100) NOT NULL":
"'bpel.process.events: {
http://www.wso2.org/humantask/claimsapprovalprocess.bpel}ClaimsApprovalProcess-6'
(102)"; SQL statement:
INSERT INTO REG_PROPERTY (REG_NAME, REG_VALUE, REG_TENANT_ID) VALUES (?, ?,
?) [90005-140] {org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO}
org.h2.jdbc.JdbcSQLException: Value too long for column "REG_NAME
VARCHAR(100) NOT NULL": "'bpel.process.events: {
http://www.wso2.org/humantask/claimsapprovalprocess.bpel}ClaimsApprovalProcess-6'
(102)"; SQL statement:
INSERT INTO REG_PROPERTY (REG_NAME, REG_VALUE, REG_TENANT_ID) VALUES (?, ?,
?) [90005-140]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
at org.h2.message.DbException.get(DbException.java:167)
at org.h2.table.Column.validateConvertUpdateSequence(Column.java:316)
at org.h2.table.Table.validateConvertUpdateSequence(Table.java:621)
at org.h2.command.dml.Insert.insertRows(Insert.java:116)
at org.h2.command.dml.Insert.update(Insert.java:82)
at org.h2.command.CommandContainer.update(CommandContainer.java:70)
at org.h2.command.Command.executeUpdate(Command.java:199)
at
org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:141)
at
org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:127)
at
org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.addProperties(JDBCResourceDAO.java:1626)
at
org.wso2.carbon.registry.core.jdbc.dao.JDBCResourceDAO.update(JDBCResourceDAO.java:597)
at
org.wso2.carbon.registry.core.jdbc.Repository.update(Repository.java:1140)
at org.wso2.carbon.registry.core.jdbc.Repository.put(Repository.java:313)
at
org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.put(EmbeddedRegistry.java:709)
at
org.wso2.carbon.registry.core.caching.CacheBackedRegistry.put(CacheBackedRegistry.java:465)
at
org.wso2.carbon.registry.core.session.UserRegistry.put(UserRegistry.java:658)
at
org.wso2.carbon.bpel.core.ode.integration.store.repository.BPELPackageRepository.createPropertiesForUpdatedDeploymentInfo(BPELPackageRepository.java:617)
at
org.wso2.carbon.bpel.core.ode.integration.mgt.services.ProcessManagementServiceSkeleton.updateDeployInfo(ProcessManagementServiceSkeleton.java:321)
at
It was discovered the reason is the existing size of the REG_NAME column in
REG_PROPERTY table is VARCHAR(100)
Once we update the size to VARCHAR(256) the issue got resolved.
It seems this issue is common to any module that tries to pass a string
longer than VARCHAR(100).
Is there any particular reason to stick to column size VARCHAR(100)? Is it
possible to increase the column size?
What is the suggested approach to solve this issue? Do we have to write
this data as any other type rather than as a reg_property?
Appreciate your thoughts.
Thanks & Best Regards,
*Amal Gunatilake*
Software Engineer
WSO2 Inc.; http://wso2.com
lean.enterprise.middleware
_______________________________________________
Dev mailing list
[email protected]
http://wso2.org/cgi-bin/mailman/listinfo/dev
