org.apache.ignite.IgniteCheckedException

Failed to register query type: TypeDescriptor [name=Hktvproduct, fields={hjmpts=class java.lang.Object, typepkstring=class java.lang.Object, ownerpkstring=class java.lang.Object, modifiedts=class java.sql.Timestamp, createdts=class java.sql.Timestamp, pk=class java.lang.Object, pThumbnail=class java.lang.Object, code=class java.lang.Object, unitpk=class java.lang.Object, pPicture=class java.lang.Object, pStartlinenumber=class java.lang.Object, pEan=class java.lang.Object, pOfflinedate=class java.sql.Timestamp, pSupplieralternativeaid=class java.lang.Object, pPricequantity=class java.lang.Object, pErpgroupsupplier=class java.lang.Object, pLogo=class java.lang.Object, pBuyerids=class java.lang.Object, pContentunit=class java.lang.Object, pOthers=class java.lang.Object, pErpgroupbuyer=class java.lang.Object, pEndlinenumber=class java.lang.Object, pOrderquantityinterval=class java.lang.Object, pNormal=class java.lang.Object, pManufactureraid=class java.lang.Object, pVarianttype=class java.lang.Object, pMaxorderquantity=class java.lang.Object, pManufacturername=class java.lang.Object, pCatalog=class java.lang.Object, pNumbercontentunits=class java.lang.Object, pThumbnails=class java.lang.Object, pSpecialtreatmentclasses=class java.lang.Object, pDeliverytime=class java.lang.Object, pDetail=class java.lang.Object, pCatalogversion=class java.lang.Object, pOrder=class java.lang.Object, pDataSheet=class java.lang.Object, pApprovalstatus=class java.lang.Object, pOnlinedate=class java.sql.Timestamp, pMinorderquantity=class java.lang.Object, pEurope1pricefactoryPpg=class java.lang.Object, pEurope1pricefactoryPdg=class java.lang.Object, pEurope1pricefactoryPtg=class java.lang.Object, pProductorderlimit=class java.lang.Object, pGalleryimages=class java.lang.Object, pSequenceid=class java.lang.Object, pWeightunit=class java.lang.Object, pPrimarysku=class java.lang.Object, pProductcode=class java.lang.Object, pReturndays=class java.lang.Object, pPenalty=class java.lang.Object, pPackingdepth=class java.lang.Object, pReadypickupdays=class java.lang.Object, pPickuptimeslot=class java.lang.Object, pProductvideo=class java.lang.Object, pCommissionpos=class java.lang.Object, pCreditpercent=class java.lang.Object, pLoyaltypoint=class java.lang.Object, pBarcode=class java.lang.Object, pMerchantproductid=class java.lang.Object, pManufactuercountry=class java.lang.Object, pDeposit=class java.lang.Object, pPackingboxtype=class java.lang.Object, pPackingheight=class java.lang.Object, pProductmodel=class java.lang.Object, pTemplatecode=class java.lang.Object, pPackinglength=class java.lang.Object, pCommission=class java.lang.Object, pPickupdays=class java.lang.Object, pWeight=class java.lang.Object, pPackingdimensionunit=class java.lang.Object, pHktvproductvideo=class java.lang.Object, pStore=class java.lang.Object, pHotpickstreetproduct=class java.lang.Object, pHotpickstoreproduct=class java.lang.Object, aclts=class java.lang.Object, propts=class java.lang.Object, pCommissiontype=class java.lang.Object, pHotpickrank=class java.lang.Object, pHotpickstreetrank=class java.lang.Object}, indexes={null=IndexDescriptor [type=FULLTEXT], PRIMARY=IndexDescriptor [type=SORTED], productorderlimitRelIDX_20005=IndexDescriptor [type=SORTED], commissionposPosIDX_20005=IndexDescriptor [type=SORTED], catalogIDX_20005=IndexDescriptor [type=SORTED], Product_Code_20005=IndexDescriptor [type=SORTED], commissionRelIDX_20005=IndexDescriptor [type=SORTED], versionIDX_20005=IndexDescriptor [type=SORTED]}, fullTextIdx=IndexDescriptor [type=FULLTEXT], keyCls=class java.lang.Object, valCls=class java.lang.Object, valTextIdx=false, registered=false]

Samebug tips1

Check if you're not creating unused SQL entities, as it might cause this exception.


rafaelrafael

Don't give up yet. Our experts can help. Paste your full stack trace to get a solution.

Stack trace

  • org.apache.ignite.IgniteCheckedException: Failed to register query type: TypeDescriptor [name=Hktvproduct, fields={hjmpts=class java.lang.Object, typepkstring=class java.lang.Object, ownerpkstring=class java.lang.Object, modifiedts=class java.sql.Timestamp, createdts=class java.sql.Timestamp, pk=class java.lang.Object, pThumbnail=class java.lang.Object, code=class java.lang.Object, unitpk=class java.lang.Object, pPicture=class java.lang.Object, pStartlinenumber=class java.lang.Object, pEan=class java.lang.Object, pOfflinedate=class java.sql.Timestamp, pSupplieralternativeaid=class java.lang.Object, pPricequantity=class java.lang.Object, pErpgroupsupplier=class java.lang.Object, pLogo=class java.lang.Object, pBuyerids=class java.lang.Object, pContentunit=class java.lang.Object, pOthers=class java.lang.Object, pErpgroupbuyer=class java.lang.Object, pEndlinenumber=class java.lang.Object, pOrderquantityinterval=class java.lang.Object, pNormal=class java.lang.Object, pManufactureraid=class java.lang.Object, pVarianttype=class java.lang.Object, pMaxorderquantity=class java.lang.Object, pManufacturername=class java.lang.Object, pCatalog=class java.lang.Object, pNumbercontentunits=class java.lang.Object, pThumbnails=class java.lang.Object, pSpecialtreatmentclasses=class java.lang.Object, pDeliverytime=class java.lang.Object, pDetail=class java.lang.Object, pCatalogversion=class java.lang.Object, pOrder=class java.lang.Object, pDataSheet=class java.lang.Object, pApprovalstatus=class java.lang.Object, pOnlinedate=class java.sql.Timestamp, pMinorderquantity=class java.lang.Object, pEurope1pricefactoryPpg=class java.lang.Object, pEurope1pricefactoryPdg=class java.lang.Object, pEurope1pricefactoryPtg=class java.lang.Object, pProductorderlimit=class java.lang.Object, pGalleryimages=class java.lang.Object, pSequenceid=class java.lang.Object, pWeightunit=class java.lang.Object, pPrimarysku=class java.lang.Object, pProductcode=class java.lang.Object, pReturndays=class java.lang.Object, pPenalty=class java.lang.Object, pPackingdepth=class java.lang.Object, pReadypickupdays=class java.lang.Object, pPickuptimeslot=class java.lang.Object, pProductvideo=class java.lang.Object, pCommissionpos=class java.lang.Object, pCreditpercent=class java.lang.Object, pLoyaltypoint=class java.lang.Object, pBarcode=class java.lang.Object, pMerchantproductid=class java.lang.Object, pManufactuercountry=class java.lang.Object, pDeposit=class java.lang.Object, pPackingboxtype=class java.lang.Object, pPackingheight=class java.lang.Object, pProductmodel=class java.lang.Object, pTemplatecode=class java.lang.Object, pPackinglength=class java.lang.Object, pCommission=class java.lang.Object, pPickupdays=class java.lang.Object, pWeight=class java.lang.Object, pPackingdimensionunit=class java.lang.Object, pHktvproductvideo=class java.lang.Object, pStore=class java.lang.Object, pHotpickstreetproduct=class java.lang.Object, pHotpickstoreproduct=class java.lang.Object, aclts=class java.lang.Object, propts=class java.lang.Object, pCommissiontype=class java.lang.Object, pHotpickrank=class java.lang.Object, pHotpickstreetrank=class java.lang.Object}, indexes={null=IndexDescriptor [type=FULLTEXT], PRIMARY=IndexDescriptor [type=SORTED], productorderlimitRelIDX_20005=IndexDescriptor [type=SORTED], commissionposPosIDX_20005=IndexDescriptor [type=SORTED], catalogIDX_20005=IndexDescriptor [type=SORTED], Product_Code_20005=IndexDescriptor [type=SORTED], commissionRelIDX_20005=IndexDescriptor [type=SORTED], versionIDX_20005=IndexDescriptor [type=SORTED]}, fullTextIdx=IndexDescriptor [type=FULLTEXT], keyCls=class java.lang.Object, valCls=class java.lang.Object, valTextIdx=false, registered=false] at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.registerType(IgniteH2Indexing.java:1167) at org.apache.ignite.internal.processors.query.GridQueryProcessor.initializeCache(GridQueryProcessor.java:291) at org.apache.ignite.internal.processors.query.GridQueryProcessor.onCacheStart(GridQueryProcessor.java:457) at org.apache.ignite.internal.processors.cache.GridCacheProcessor.startCache(GridCacheProcessor.java:1038) at org.apache.ignite.internal.processors.cache.GridCacheProcessor.prepareCacheStart(GridCacheProcessor.java:1648) at org.apache.ignite.internal.processors.cache.GridCacheProcessor.prepareCachesStart(GridCacheProcessor.java:1563) at org.apache.ignite.internal.processors.cache.distributed.dht.preloader.GridDhtPartitionsExchangeFuture.startCaches(GridDhtPartitionsExchangeFuture.java:956) at org.apache.ignite.internal.processors.cache.distributed.dht.preloader.GridDhtPartitionsExchangeFuture.init(GridDhtPartitionsExchangeFuture.java:523) at org.apache.ignite.internal.processors.cache.GridCachePartitionExchangeManager$ExchangeWorker.body(GridCachePartitionExchangeManager.java:1297) at org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110) at java.lang.Thread.run(Thread.java:745) Caused by: org.h2.jdbc.JdbcSQLException: Column "P_PRODUCTORDERLIMIT" not found; SQL statement: CREATE TABLE "PersonCache".Hktvproduct (_key OTHER NOT NULL,_val OTHER,hjmpts OTHER,typepkstring OTHER,ownerpkstring OTHER,modifiedts TIMESTAMP,createdts TIMESTAMP,pk OTHER,pThumbnail OTHER,code OTHER,unitpk OTHER,pPicture OTHER,pStartlinenumber OTHER,pEan OTHER,pOfflinedate TIMESTAMP,pSupplieralternativeaid OTHER,pPricequantity OTHER,pErpgroupsupplier OTHER,pLogo OTHER,pBuyerids OTHER,pContentunit OTHER,pOthers OTHER,pErpgroupbuyer OTHER,pEndlinenumber OTHER,pOrderquantityinterval OTHER,pNormal OTHER,pManufactureraid OTHER,pVarianttype OTHER,pMaxorderquantity OTHER,pManufacturername OTHER,pCatalog OTHER,pNumbercontentunits OTHER,pThumbnails OTHER,pSpecialtreatmentclasses OTHER,pDeliverytime OTHER,pDetail OTHER,pCatalogversion OTHER,pOrder OTHER,pDataSheet OTHER,pApprovalstatus OTHER,pOnlinedate TIMESTAMP,pMinorderquantity OTHER,pEurope1pricefactoryPpg OTHER,pEurope1pricefactoryPdg OTHER,pEurope1pricefactoryPtg OTHER,pProductorderlimit OTHER,pGalleryimages OTHER,pSequenceid OTHER,pWeightunit OTHER,pPrimarysku OTHER,pProductcode OTHER,pReturndays OTHER,pPenalty OTHER,pPackingdepth OTHER,pReadypickupdays OTHER,pPickuptimeslot OTHER,pProductvideo OTHER,pCommissionpos OTHER,pCreditpercent OTHER,pLoyaltypoint OTHER,pBarcode OTHER,pMerchantproductid OTHER,pManufactuercountry OTHER,pDeposit OTHER,pPackingboxtype OTHER,pPackingheight OTHER,pProductmodel OTHER,pTemplatecode OTHER,pPackinglength OTHER,pCommission OTHER,pPickupdays OTHER,pWeight OTHER,pPackingdimensionunit OTHER,pHktvproductvideo OTHER,pStore OTHER,pHotpickstreetproduct OTHER,pHotpickstoreproduct OTHER,aclts OTHER,propts OTHER,pCommissiontype OTHER,pHotpickrank OTHER,pHotpickstreetrank OTHER) engine "org.apache.ignite.internal.processors.query.h2.opt.GridH2Table$Engine" [42122-175] at org.h2.message.DbException.getJdbcSQLException(DbException.java:332) at org.h2.message.DbException.get(DbException.java:172) at org.h2.message.DbException.get(DbException.java:149) at org.h2.table.Table.getColumn(Table.java:626) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing$TableDescriptor.createIndexes(IgniteH2Indexing.java:1984) at org.apache.ignite.internal.processors.query.h2.opt.GridH2Table.<init>(GridH2Table.java:106) at org.apache.ignite.internal.processors.query.h2.opt.GridH2Table$Engine.createTable(GridH2Table.java:675) at org.apache.ignite.internal.processors.query.h2.opt.GridH2Table$Engine.createTable(GridH2Table.java:659) at org.h2.schema.Schema.createTable(Schema.java:584) at org.h2.command.ddl.CreateTable.update(CreateTable.java:135) at org.h2.command.CommandContainer.update(CommandContainer.java:79) at org.h2.command.Command.executeUpdate(Command.java:253) at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:181) at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:156) at org.apache.ignite.internal.processors.query.h2.opt.GridH2Table$Engine.createTable(GridH2Table.java:700) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.createTable(IgniteH2Indexing.java:1288) at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.registerType(IgniteH2Indexing.java:1160) ... 10 more

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

tvrmsmithtvrmsmith
Once,
aidoanaidoan
6 times, last one
guizmaiiguizmaii
34 times, last one
batwalrus76batwalrus76
4 times, last one
Unknown visitor
Unknown visitorOnce,
143 more bugmates