Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

What is the index record size limit on a Progress 10.0b database temp table?

Posted on 2009-04-15
2
Medium Priority
?
1,255 Views
Last Modified: 2013-12-25
I'm getting an error:

"The total length of the fields in an index exceeds max key size"

when trying to create a temp table record in my code.  I've tracked the error down to an index on the temp table that I'm creating a record for.  I found the exact record that's causing the issue and if I add up all of the characters in all of the fields in the index, if it's over 172, then I get this error, if it's 172 or less, it works just fine.  What is the character limit for an index record?  I've found 180 and I've found 200.  Can this be adjusted in my current version of Progress?  Or do I have to upgrade to 10.1b?
0
Comment
Question by:big_C
1 Comment
 
LVL 4

Accepted Solution

by:
progressor earned 2000 total points
ID: 24235659
Hi,

The maximum index size is 197 bytes for tables and temp-tables in your version. This can only be overcome by upgrading to at least 10.1B. Starting 10.1B the maximum index size is ~2000 bytes.
10.0B is  an old unsopported version, so if you have any chance to upgrade then upgrade to 10.2A. Virtually all database limits have been lifted in 10.1B and the latching mechanism has improved a lot in 10.1C.

HTH,

Casper
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, I’ll look at how you can use a backup to start a secondary instance for MongoDB.
Creating a Cordova application which allow user to save to/load from his Dropbox account the application database.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question