Error: 1070

[Scott Thompson]

Hi I am getting an error and I am not too sure what impact it is having (if any) and how I may resolve it if required. The error is “ERROR: 1070, Too many key parts specified; max 16 parts allowed” and seems to happen on most if not all tables. An example from the log is included below. I tried searching the forums but couldn't find anything so any assistance would be appreciated.

Thanks.

SQLyog Job Agent Version 8.61 Copyright(c) Webyog Softworks Pvt. Ltd. All Rights

Reserved.

Check C:Documents and SettingsScott Thompson.SCOTTApplication DataSQLyogsja

.log for complete error details.

Job started at Wed Mar 23 09:00:34 2011

DBMS Information: JADE

Importing table schema: ARCreditNote… Successful…

Importing table schema: ARInvoice… Successful…

Importing table schema: ARPeriodSummary… Successful…

Importing table schema: Branch… Successful…

Importing table schema: CRMCommunication… Successful…

Importing table schema: CRMContact… Successful…

Importing table schema: CRMContactTitle… Successful…

Importing table schema: CRMContact_allUserFields… Successful…

Importing table schema: CRMOrganisation… Successful…

Importing table schema: Customer… Successful…

Importing table schema: Customer_allUserFields… Successful…

Importing table schema: DeliveryAddress… Successful…

Importing table schema: INAPCustCodeAnalysisCode… Successful…

Importing table schema: INAPCustCodeStockCode… Successful…

Importing table schema: INARLineItem… Successful…

Importing table schema: INAnalysisCode… Successful…

Importing table schema: INTransType… Successful…

Importing table schema: LineItem… Successful…

Importing table schema: SOPSINLineItem… Successful…

Importing table schema: SOPSLineItem… Successful…

Importing table schema: SOPSNSLineItem… Successful…

Importing table schema: SOPackingSlip… Successful…

Importing table schema: SOSOLineItem… Successful…

Importing table schema: SOSalesOrder… Successful…

Importing table schema: SalesPerson… Successful…

Importing table schema: StockItem… Successful…

Importing table schema: UDFObject… Successful…

Importing table schema: UDFObjectDefn… Successful…

Importing table foreign keys: ARCreditNote…

ERROR: 1070, Too many key parts specified; max 16 parts allowed

Table:ARCreditNote

Sql: ALTER TABLE `ARCreditNote` ADD FOREIGN KEY(`myARControl`,`myARCreditNoteBat

ch`,`myAppliedToInvoice`,`myARPeriodSummary`,`myOutstandingPeriodSummary`,`myUna

ppliedTransaction`,`myBatch`,`myBranch`,`myCurrency`,`myCustomer`,`myRWCustomer`

,`myDeliveryAddress`,`myGenGLForcedBalanceTran`,`myGeneratedTaxJournal`,`myGenEx

chVarJournal`,`myGenDebtorsControlJournal`,`mySourceModule`,`myModule`,`myOutput

TaxPeriodSummary`,`myPeriodSummary`,`myReceipt`,`mySalesPerson`,`myRWSupplier`,`

myHoldCode`)REFERENCES `UTHoldCode`(`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`o

id`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid

`,`oid`,`oid`,`oid`)ON DELETE CASCADE ON UPDATE CASCADE

Check C:Documents and SettingsScott Thompson.SCOTTApplication DataSQLyogsja

.log for complete error details.

Successful…

Importing table foreign keys: ARInvoice…

ERROR: 1070, Too many key parts specified; max 16 parts allowed

Table:ARInvoice

Sql: ALTER TABLE `ARInvoice` ADD FOREIGN KEY(`myARControl`,`myARInvoiceBatch`,`m

yOpeningBalance`,`myOverdueInterestPeriodSummary`,`myOutstandingPeriodSummary`,`

myARPeriodSummary`,`myBatch`,`myBranch`,`myCurrency`,`myRWCustomer`,`myCustomer`

,`myDeliveryAddress`,`myGenGLForcedBalanceTran`,`myGeneratedTaxJournal`,`myGenDe

btorsControlJournal`,`mySourceModule`,`myModule`,`myOutputTaxPeriodSummary`,`myP

eriodSummary`,`mySalesPerson`,`myStandingInvoice`,`myReceiptType`,`myRWSupplier`

,`myHoldCode`,`myPaymentTerm`)REFERENCES `UTPaymentTerm`(`oid`,`oid`,`oid`,`oid`

,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`

oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`)ON DELETE CASCADE ON UPDATE CAS

CADE

Check C:Documents and SettingsScott Thompson.SCOTTApplication DataSQLyogsja

.log for complete error details.

Successful…

Importing table foreign keys: ARPeriodSummary… Successful…

Importing table foreign keys: Branch… Successful…

Importing table foreign keys: CRMCommunication…

ERROR: 1070, Too many key parts specified; max 16 parts allowed

Table:CRMCommunication

Sql: ALTER TABLE `CRMCommunication` ADD FOREIGN KEY(`myCampaign`,`myCampaignOpen

`,`myPriority`,`mySource`,`myCommunicationStage`,`myCRMCompanyOpen`,`myCRMCompan

y`,`myAssignedTeam`,`myAssignedUser`,`myCRMContact`,`myCRMContactOpen`,`myCRMLea

d`,`myCRMLeadOpen`,`myCRMOrganisationOpen`,`myCRMOrganisation`,`myPrimaryProduct

`,`myPrimaryProductOpen`,`myCRMQuote`,`myCRMQuoteOpen`,`myCRMSVRequestOpen`,`myC

RMSVRequest`)REFERENCES `CRMSVRequest`(`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`

,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`

oid`)ON DELETE CASCADE ON UPDATE CASCADE

Check C:Documents and SettingsScott Thompson.SCOTTApplication DataSQLyogsja

.log for complete error details.

Successful…

Importing table foreign keys: CRMContact…

ERROR: 1070, Too many key parts specified; max 16 parts allowed

Table:CRMContact

Sql: ALTER TABLE `CRMContact` ADD FOREIGN KEY(`myAssignedTeam`,`myAssignedUser`,

`myReportTo`,`myCRModule`,`myGTARCustomer`,`myOccupationCategory`,`myCRMOrganisa

tion`,`myCRMSalesPerson`,`myPersPostCRMUTCountry`,`myBusStrtCRMUTCountry`,`myBus

PostCRMUTCountry`,`myPersStrtCRMUTCountry`,`myGTCustomer`,`myStatus`,`myAddressP

hone`,`myAddressBusStrt`,`myAddressBusPost`,`myAddressPersPost`,`myAddressPersSt

rt`,`myProtectedAddressBusPost`,`myProtectedAddressBusStrt`,`myProtectedAddressP

ersPost`,`myProtectedAddressPersStrt`)REFERENCES `UTAddressCRMConPersStrt`(`oid`

,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`

oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`)ON DELETE CASCADE ON UPDAT

E CASCADE

Check C:Documents and SettingsScott Thompson.SCOTTApplication DataSQLyogsja

.log for complete error details.

Successful…

Importing table foreign keys: CRMContactTitle… Successful…

Importing table foreign keys: CRMContact_allUserFields…

ERROR: 1005, Can't create table '.greentree#sql-924_355.frm' (errno: 150)

Table:CRMContact_allUserFields

Sql: ALTER TABLE `CRMContact_allUserFields` ADD FOREIGN KEY(`cRMContact_oid`,`uD

FObject_oid`)REFERENCES `UDFObject`(`oid`,`oid`)ON DELETE CASCADE ON UPDATE CA

SCADE

Check C:Documents and SettingsScott Thompson.SCOTTApplication DataSQLyogsja

.log for complete error details.

Successful…

Importing table foreign keys: CRMOrganisation…

ERROR: 1070, Too many key parts specified; max 16 parts allowed

Table:CRMOrganisation

Sql: ALTER TABLE `CRMOrganisation` ADD FOREIGN KEY(`myAssignedTeam`,`myDefaultDC

CallTeam`,`myDefaultDCCallUser`,`myAssignedUser`,`myDebtCollectionContact`,`myPr

imaryContact`,`myRefContact`,`myCRModule`,`myGTARCustomer`,`myDefaultSVCallJob`,

`myDefaultSVRequestJob`,`myCRMOCModuleDefault`,`myParentOrg`,`myReseller`,`myCla

ssification`,`myImportance`,`myIndustry`,`myRelationship`,`mySIC`,`mySource`,`my

Type`,`mySalesManager`,`myCRMSalesPerson`,`myAPSupplier`,`myTerritory`,`myDefaul

tSVCallTeam`,`myDefaultSVRequestTeam`,`mySalesTeam`,`myBusStrtCRMUTCountry`,`myB

usPostCRMUTCountry`,`myGTCustomer`,`myStatus`,`myAddressBusPost`,`myAddressBusSt

rt`,`myAddressPhone`,`myProtectedAddressBusPost`,`myProtectedAddressBusStrt`)REF

ERENCES `UTAddressCRMOrgBusStrt`(`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`

,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`

oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oi

d`,`oid`,`oid`)ON DELETE CASCADE ON UPDATE CASCADE

Check C:Documents and SettingsScott Thompson.SCOTTApplication DataSQLyogsja

.log for complete error details.

Successful…

Importing table foreign keys: Customer…

ERROR: 1070, Too many key parts specified; max 16 parts allowed

Table:Customer

Sql: ALTER TABLE `Customer` ADD FOREIGN KEY(`myARControlBalanceForward`,`myARCon

trolOpenItem`,`myARControl`,`myGoodDebtorsARControl`,`myOpeningBalance`,`myCurre

ntPeriodSummary`,`myFirstOpenPeriodSummary`,`myMostFuturePeriodSummary`,`myBranc

h`,`myCalendar`,`myCBAnalysisCode`,`myCurrency`,`myParent`,`myPrimaryDeliveryAdd

ress`,`myWebCompany`,`myDefaultPriceLevel`,`myDefaultINInvoiceType`,`myDefaultIN

CreditNoteType`,`myOverdueInterest`,`myLastReceipt`,`mySalesPerson`,`myDefaultSt

opCreditSOStatus`,`mySODefaultHoldStatus`,`myReceiptType`,`mySOBackorderPriority

`,`myStatementDeliveryMethod`,`myStatus`,`myReceiptDeliveryMethod`,`myInvoiceDel

iveryMethod`,`myTaxMethod`,`myBalanceType`,`myAddress`,`myCountryCode`,`myDefaul

tPaymentTerm`,`myTaxCode`)REFERENCES `UTTaxCode`(`oid`,`oid`,`oid`,`oid`,`oid`,`

oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oi

d`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`

,`oid`,`oid`,`oid`)ON DELETE CASCADE ON UPDATE CASCADE

Check C:Documents and SettingsScott Thompson.SCOTTApplication DataSQLyogsja

.log for complete error details.

Successful…

Importing table foreign keys: Customer_allUserFields…

ERROR: 1005, Can't create table '.greentree#sql-924_355.frm' (errno: 150)

Table:Customer_allUserFields

Sql: ALTER TABLE `Customer_allUserFields` ADD FOREIGN KEY(`customer_oid`,`uDFObj

ect_oid`)REFERENCES `UDFObject`(`oid`,`oid`)ON DELETE CASCADE ON UPDATE CASCAD

E

Check C:Documents and SettingsScott Thompson.SCOTTApplication DataSQLyogsja

.log for complete error details.

Successful…

Importing table foreign keys: DeliveryAddress… Successful…

Importing table foreign keys: INAPCustCodeAnalysisCode… Successful…

Importing table foreign keys: INAPCustCodeStockCode… Successful…

Importing table foreign keys: INARLineItem…

ERROR: 1070, Too many key parts specified; max 16 parts allowed

Table:INARLineItem

Sql: ALTER TABLE `INARLineItem` ADD FOREIGN KEY(`myGeneratedFIFOStackItem`,`myGL

BankIn`,`myGLBankOut`,`myKitsetVarianceJournal`,`myKitsetParentJournal`,`myINTra

nsGLJournal`,`mySalesGLJournal`,`myGeneratedGLJournal`,`myINCostVarianceJournal`

,`myCostOfSalesGLJournal`,`getINTransferInLine`,`myParentLineItem`,`myLocation`,

`myMasterPeriodSummary`,`myLocationPeriodSummary`,`myPriceLevel`,`myTransType`,`

myUnitOfMeasure`,`mySourceModule`,`mySAAnalysisLine`,`mySourceSOPSINLineItem`,`m

yStockItem`,`myARStockItem`,`myInventoryText`,`myARStockLocation`,`myStockLocati

on`,`myTaxType`,`myTransaction`,`my1099TaxCode`,`myTaxCode`)REFERENCES `UTTaxCod

e`(`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`

,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`

oid`,`oid`,`oid`,`oid`)ON DELETE CASCADE ON UPDATE CASCADE

Check C:Documents and SettingsScott Thompson.SCOTTApplication DataSQLyogsja

.log for complete error details.

Successful…

Importing table foreign keys: INAnalysisCode… Successful…

Importing table foreign keys: INTransType…

ERROR: 1070, Too many key parts specified; max 16 parts allowed

Table:INTransType

Sql: ALTER TABLE `INTransType` ADD FOREIGN KEY(`myDefaultCreditAPControl`,`myDef

aultInvoiceAPControl`,`myDefaultInvoiceARControl`,`myDefaultCreditARControl`,`my

WriteOffBOMControl`,`myIssueBOMControl`,`myReturnBOMControl`,`myReceiptBOMContro

l`,`myECControl`,`myMultipleAdjIncINControl`,`myMultipleAdjDecINControl`,`myKits

etDebitStockINControl`,`myINControl`,`myKitsetCreditStockINControl`,`myDefaultLo

cation`,`myDefaultINPriceBook`,`myPOControl`,`mySOControl`,`myEffectType`,`myTra

nsferInUpdateOption`,`myTransferType`,`myUpdateOptions`,`myTaxCode`)REFERENCES `

UTTaxCode`(`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oi

d`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`,`oid`)ON DELETE

CASCADE ON UPDATE CASCADE

Check C:Documents and SettingsScott Thompson.SCOTTApplication DataSQLyogsja

.log for complete error details.

Successful…

Importing table foreign keys: LineItem…

[peterlaursen]

The error is a server error – not a SQLyog error – and is listed here:

http://dev.mysql.com/doc/refman/5.0/en/error-messages-server.html#error_er_too_many_key_parts

What is server version? Do you use excessive Foreign Keys and other type of keys and indexes? The error you get you will get with any client – not only SQLyog.

But what is the particular operation you are performing when receiving this? During import? Do you import from one server version to another server version?

A google search:

http://www.google.dk/search?client=opera&rls=da&q=mysql+%2B+'Too+many+key+parts+specified%3B+max+16+parts+allowed'&sourceid=opera&ie=utf-8&oe=utf-8&channel=suggest

[Scott Thompson]

Yes it is during a data import from a Greentree database using ODBC, I cannot change the number of keys that Greentree uses and if it is a MySQL limit I cannot change that either. Not sure if it is going to have any real impact on the data, guess I will wait and see what happens.

Thanks for the reply.

'peterlaursen' wrote:

The error is a server error – not a SQLyog error – and is listed here:

http://dev.mysql.com/doc/refman/5.0/en/error-messages-server.html#error_er_too_many_key_parts

What is server version? Do you use excessive Foreign Keys and other type of keys and indexes? The error you get you will get with any client – not only SQLyog.

But what is the particular operation you are performing when receiving this? During import? Do you import from one server version to another server version?

A google search:

http://www.google.dk/search?client=opera&rls=da&q=mysql+%2B+'Too+many+key+parts+specified%3B+max+16+parts+allowed'&sourceid=opera&ie=utf-8&oe=utf-8&channel=suggest

[Author]

Posts