Hi Amal, Please find my comments inline. On Fri, Nov 1, 2013 at 11:43 AM, Amal Gunatilake <[email protected]> wrote:
> 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? > We use the value of 100 because we expect length of property name to be less than 100 which is a convenient value for a name. Additionally this helps to reduce the database size as well. If your registry properties are greater than 100, since this is not the case for others, please override the dbscripts using the bin.xml in the BPS distribution. thanks Eranda > Appreciate your thoughts. > > Thanks & Best Regards, > > *Amal Gunatilake* > Software Engineer > WSO2 Inc.; http://wso2.com > lean.enterprise.middleware > -- *Eranda Sooriyabandara *Senior Software Engineer; Integration Technologies Team; WSO2 Inc.; http://wso2.com Lean . Enterprise . Middleware E-mail: eranda AT wso2.com Mobile: +94 716 472 816 Linked-In: http://www.linkedin.com/in/erandasooriyabandara Blog: http://emsooriyabandara.blogspot.com/ * *
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
