Jump to content


Photo

Error: 1070


  • Please log in to reply
2 replies to this topic

#1 Scott Thompson

Scott Thompson

    Newbie

  • Members
  • Pip
  • 8 posts

Posted 22 March 2011 - 08:11 PM

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© Webyog Softworks Pvt. Ltd. All Rights
Reserved.


Check C:\Documents and Settings\Scott Thompson.SCOTT\Application Data\SQLyog\sja
.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 Settings\Scott Thompson.SCOTT\Application Data\SQLyog\sja
.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 Settings\Scott Thompson.SCOTT\Application Data\SQLyog\sja
.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 Settings\Scott Thompson.SCOTT\Application Data\SQLyog\sja
.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 Settings\Scott Thompson.SCOTT\Application Data\SQLyog\sja
.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 Settings\Scott Thompson.SCOTT\Application Data\SQLyog\sja
.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 Settings\Scott Thompson.SCOTT\Application Data\SQLyog\sja
.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 Settings\Scott Thompson.SCOTT\Application Data\SQLyog\sja
.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 Settings\Scott Thompson.SCOTT\Application Data\SQLyog\sja
.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 Settings\Scott Thompson.SCOTT\Application Data\SQLyog\sja
.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 Settings\Scott Thompson.SCOTT\Application Data\SQLyog\sja
.log for complete error details.
Successful...
Importing table foreign keys: LineItem...

#2 peterlaursen

peterlaursen

    Advanced Member

  • Admin
  • PipPipPip
  • 7,868 posts
  • Gender:Male
  • Location:Skagen, Denmark
  • Interests:well ... jazz/folk music, photography, chess, nature, ecology, history, bicycling, Highland Malts ... well, Lowland Malts and Cognac too actually :-) just wonder how I get the time to touch a computer! SQLyog and MONyog? no that's not interest, that's BASIC NEEDS simply!

Posted 22 March 2011 - 11:03 PM

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

http://dev.mysql.com..._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


Computers make your grey hair come off ....

Peter Laursen
Webyog

#3 Scott Thompson

Scott Thompson

    Newbie

  • Members
  • Pip
  • 8 posts

Posted 22 March 2011 - 11:24 PM

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.


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

http://dev.mysql.com..._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






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users