Hi Chandana, After changing page size I could successfully create the table.
Since this doesn't work with default page size, should we include the step for increasing page size in related documentation [1]? Thank You! 1. https://docs.wso2.com/display/IS500/Setting+up+Informix On Thu, Jul 9, 2015 at 4:18 PM, Chandana Napagoda <[email protected]> wrote: > 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 > <%2B94718169299>* > > *Blog : http://cnapagoda.blogspot.com <http://cnapagoda.blogspot.com>* > > -- *Chamila Dilshan Wijayarathna,* Software Engineer Mobile:(+94)788193620 WSO2 Inc., http://wso2.com/
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
