I'm working on a database migration from Sybase Advantage to Elevate DB
I'm using the elevate code to make that migration
I have error Argument out of range on this sql statement

CREATE INDEX "SK_ACCESSLEVEL_UNIQUEPATH" ON "accesslevel" ("MASTERACCOUNT","ACCOUNT","CLUSTER","NTM","GSI","SITE","INFO1","INFO2","INFO3","INFO4","STATE")

I didn't saw any restriction on number of field into an index

On 6/4/2019 2:27 PM, Ozgur Aral wrote:
> I'm working on a database migration from Sybase Advantage to Elevate DB
> I'm using the elevate code to make that migration
> I have error Argument out of range on this sql statement
>
> CREATE INDEX "SK_ACCESSLEVEL_UNIQUEPATH" ON "accesslevel" ("MASTERACCOUNT","ACCOUNT","CLUSTER","NTM","GSI","SITE","INFO1","INFO2","INFO3","INFO4","STATE")
>
> I didn't saw any restriction on number of field into an index
>


Any limits should be listed under system capacities

https://www.elevatesoft.com/manual?action=topics&id=edb2&product=rsdelphiwin32&version=10R&section=appendix_system_cap

"Max Number of Columns in an Index" limit is "The maximum number of
columns in an index is limited by the table's defined index page size."

I'm not saying this is the source of the problem  but something worth
checking out.

Default index page is 8192 bytes so you could increase it for this table
to see if it changes anything

What are your data types for those columns ?


Raul

Ozgur,

<< I'm working on a database migration from Sybase Advantage to Elevate DB
I'm using the elevate code to make that migration
I have error Argument out of range on this sql statement

CREATE INDEX "SK_ACCESSLEVEL_UNIQUEPATH" ON "accesslevel" ("MASTERACCOUNT","ACCOUNT","CLUSTER","NTM","GSI","SITE","INFO1","INFO2","INFO3","INFO4","STATE")

I didn't saw any restriction on number of field into an index >>

Please email me the CREATE TABLE DDL for the table itself, and I will see what the issue is.

Thanks,

Tim Young
Elevate Software
www.elevatesoft.com