Hello Roman, thank for the speedy and informative reply. I don't know how to implement solution a) so I steadily increased the following firebird.conf file setting using the KB to bytes conversion table at the bottom of: firebird.conf until I reached the max. The install.log snippet also follows. TIA and please advise, David.

******************************************************************

DefaultDbCachePages = 524288

******************************************************************

Aug 29, 2008 2:19:46 PM -- SchemaInstaller:161
Please look in the log file (located in the file: C:\Program Files\Xythos\Xythos Enterprise Document Manager Evaluation\wfs-7.0.42\install.log).
Aug 29, 2008 2:19:46 PM -- org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544351. unsuccessful metadata update
key size exceeds implementation restriction for index "XY_ROOT_DIRS_U1"
Reason: unsuccessful metadata update
key size exceeds implementation restriction for index "XY_ROOT_DIRS_U1"
at org.firebirdsql.jdbc.InternalTransactionCoordinator$LocalTransactionCoordinator.commit(InternalTransactionCoordinator.java:324)
at org.firebirdsql.jdbc.InternalTransactionCoordinator.commit(InternalTransactionCoordinator.java:80)
at org.firebirdsql.jdbc.AbstractConnection.commit(AbstractConnection.java:440)
at com.xythos.installer.engine.Installer.createTablesAndIndexes(Installer.java:198)
at com.xythos.installer.engine.CoreGlobalSchemaInstaller.install(CoreGlobalSchemaInstaller.java:402)
at com.xythos.installer.engine.CoreGlobalSchemaInstaller.install(CoreGlobalSchemaInstaller.java:206)
at com.xythos.installer.DatabaseInfoImpl.install(DatabaseInfoImpl.java:548)
at com.xythos.installer.application.XythosInstaller.doGlobalSchemaInstall(XythosInstaller.java:1076)
at com.xythos.installer.application.XythosInstaller.doFullInstall(XythosInstaller.java:981)
at com.xythos.installer.application.XythosInstaller.run(XythosInstaller.java:167)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.xythos.installer.application.InstallXythos.main(InstallXythos.java:231)
at org.firebirdsql.gds.GDSException: unsuccessful metadata update
key size exceeds implementation restriction for index "XY_ROOT_DIRS_U1"
at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.readStatusVector(AbstractJavaGDSImpl.java:2169)
at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.receiveResponse(AbstractJavaGDSImpl.java:2119)
at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.iscCommitTransaction(AbstractJavaGDSImpl.java:825)
at org.firebirdsql.gds.impl.GDSHelper.commitTransaction(GDSHelper.java:604)
at org.firebirdsql.jca.FBManagedConnection.internalCommit(FBManagedConnection.java:599)
at org.firebirdsql.jca.FBLocalTransaction.internalCommit(FBLocalTransaction.java:193)
at org.firebirdsql.jca.FBLocalTransaction.commit(FBLocalTransaction.java:167)
at org.firebirdsql.jdbc.InternalTransactionCoordinator$LocalTransactionCoordinator.commit(InternalTransactionCoordinator.java:322)
at org.firebirdsql.jdbc.InternalTransactionCoordinator.commit(InternalTransactionCoordinator.java:80)
at org.firebirdsql.jdbc.AbstractConnection.commit(AbstractConnection.java:440)
at com.xythos.installer.engine.Installer.createTablesAndIndexes(Installer.java:198)
at com.xythos.installer.engine.CoreGlobalSchemaInstaller.install(CoreGlobalSchemaInstaller.java:402)
at com.xythos.installer.engine.CoreGlobalSchemaInstaller.install(CoreGlobalSchemaInstaller.java:206)
at com.xythos.installer.DatabaseInfoImpl.install(DatabaseInfoImpl.java:548)
at com.xythos.installer.application.XythosInstaller.doGlobalSchemaInstall(XythosInstaller.java:1076)
at com.xythos.installer.application.XythosInstaller.doFullInstall(XythosInstaller.java:981)
at com.xythos.installer.application.XythosInstaller.run(XythosInstaller.java:167)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.xythos.installer.application.InstallXythos.main(InstallXythos.java:231)

Aug 29, 2008 2:19:46 PM -- Please Correct Problems Above And Run The Installer Again.



Roman Rokytskyy wrote ..

> Hi,
>
> > Aug 28, 2008 7:38:03 PM -- SchemaInstaller:161
> > Please look in the log file (located in the file: C:\Xythos\wfs-7.0.42\install.log).
> > Aug 28, 2008 7:38:03 PM -- org.firebirdsql.jdbc.FBSQLException: GDS Exception.
> 335544351. unsuccessful metadata update
> > key size exceeds implementation restriction for index "XY_ROOT_DIRS_U1"
> > Reason: unsuccessful metadata update
> > key size exceeds implementation restriction for index "XY_ROOT_DIRS_U1"
>
> It tries to create an index with a key that is longer than
> implementation restriction, which starting FB 2.0 (if I'm not mistaken)
> is 1/4-th of the database page size.
>
> Two solutions:
>
> a) change the column definitions to store less data
> b) create database with 16k page size and try again - maybe it will fit.
>
> Roman

Yet some, not wise, go to the other side of the globe, to barbarous and unhealthy regions, and devote ten or twenty years, in that they may live,-that is, keep comfortably warm,- and die in New England at last.

Henry David Thoreau - Walden - 1845