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/
_______________________________________________
Dev mailing list
[email protected]
http://wso2.org/cgi-bin/mailman/listinfo/dev
