Hi Chamil, Please refer Sumedh's blog[1] for increase page-size of informix DB.
[1]. http://sumedha.blogspot.com/2013/03/how-to-increase-informix-page-size.html Regards, Chandana On Thu, Jul 9, 2015 at 3:57 PM, Chamila Wijayarathna <[email protected]> wrote: > Hello all, > > When trying to startup a wso2server using informix as the primary data > source, server fails to startup due to following error. > > 517: The total size of the index is too large or too many parts in index. > Error in line 31 > Near character position 81 > > This occurs while creating 'REG_PATH' table which is in > <CARBON_HOME>/db_scripts/informix.sql. > > CREATE TABLE REG_PATH( > REG_PATH_ID SERIAL UNIQUE, > REG_PATH_VALUE LVARCHAR(750) NOT NULL, > REG_PATH_PARENT_ID INTEGER, > REG_TENANT_ID INTEGER DEFAULT 0, > PRIMARY KEY(REG_PATH_ID, REG_TENANT_ID) CONSTRAINT PK_REG_PATH > ); > > CREATE INDEX REG_PATH_IND_BY_PATH_VALUE ON REG_PATH(REG_PATH_VALUE, > REG_TENANT_ID); > > > The reason for this error is that sum of lengths of attributes in > 'REG_PATH_IND_BY_PATH_VALUE' index exceeds 390 which is the maximum length > that is allowed[1]. > > Is it possible to reduce the length of 'REG_PATH_VALUE' below 390 to fix this > value? > > If so what would be the ideal value? > > > Thanks > > > 1. http://www.oninit.com/errorcode/index.php?pageid=-517 > > -- > *Chamila Dilshan Wijayarathna,* > Software Engineer > Mobile:(+94)788193620 > WSO2 Inc., http://wso2.com/ > -- *Chandana Napagoda* Senior Software Engineer WSO2 Inc. - http://wso2.org *Email : [email protected] <[email protected]>**Mobile : +94718169299* *Blog : http://cnapagoda.blogspot.com <http://cnapagoda.blogspot.com>*
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
