Urgent problem with 'The total length of the fields in an index exceeds max key size'

raptor

New Member
Hello Experts

I habe a very urgent problem with a software developed and running on Progress 9.1d. It worked well for years. Last week, an import interface reports the following error-message and quits:
"The total length of the fields in an index exceeds max key size. (129)"

I can import the same datafile (csv) with the same r-code without any problems to another database. That means, the problem cannot be in the r-code and not in the csv-file. It seems that the problem is in the database.

How can I identify the table/field/index and how can I solve this problem?

Thank you very much for a fast help!


Best regards
Michael
 
Re: Urgent problem with 'The total length of the fields in an index exceeds max key s

Code page differences can effect the key length. So being able to load it in one db but not another does not really actually tell you much.

The message means exactly what it says. Somewhere in your import you have data that exceeds the allowable key length (188 bytes prior to 10.2). Character fields are the usual culprits. It *might* be that you have a badly formed input file that messed up quoting or left out a comma or something like that.

Surely you know what table (or tables) the data is being loaded in to? It could also possibly be a temp-table -- so you may need to look at the source code to your import process.)

You mention r-code. Do you have source?

Or you could upgrade to a current release and use large keys.
 
Re: Urgent problem with 'The total length of the fields in an index exceeds max key s

Thank you very much for your reply. It cannot be a problem of the csv-file. As I wrote, I'm able to import this file into a copy of this database (a few months old) without any problem. Sure I know in which tables the data are imported to. But how can I find the problem in the database? I have access to the source-code, but no idea where the problem can be in the code. If it would be a problem in the code, it wouldnt'be possible to run the import in the copy of this database, isn't it? How should I continue??
 
Re: Urgent problem with 'The total length of the fields in an index exceeds max key s

Perhaps your import isn't simple and straight-forward.

Does it calculate any values based on existing data? Perhaps it is building a key based on data that is already in the db combined with data from the CSV file. Perhaps something like the "company id" is provided by the database and it is longer in this case than it is in the others.

You have the source -- so insert sufficient logging to be able to narrow down the problem.
 
Re: Urgent problem with 'The total length of the fields in an index exceeds max key s

for buld loads.. i sometimes... break it into smaller chunks and load it to see which "chunk" failed the load....
 
Re: Urgent problem with 'The total length of the fields in an index exceeds max key s

I found the problem. The import has 2 steps. First the data are loaded to a temporary table (real table, no temp-table), in the second step the data are loaded to the final table. In this temporary table were bad records.Thank you for your help!
 
Back
Top