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]

nabble.com | 3 months ago
  1. 0

    Apache Ignite Users - org.apache.ignite.IgniteCheckedException: Failed to register query type: TypeDescriptor

    nabble.com | 3 months ago
    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]
  2. 0

    Exception while using primary key with "underscore" character in apache ignite

    Stack Overflow | 7 months ago | MicahelSeb
    org.apache.ignite.IgniteCheckedException: Failed to register query type: TypeDescriptor [name=Employees, fields={empNo=class java.lang.Object, birthDate=class java.sql.Date, firstName=class java.lang.Object, lastName=class java.lang.Object, gender=class java.lang.Object, hireDate=class java.sql.Date}, indexes={PRIMARY=IndexDescriptor [type=SORTED]}, fullTextIdx=null, keyCls=class java.lang.Object, valCls=class java.lang.Object, valTextIdx=false, registered=false]
  3. 0

    Apache Ignite Users - Exception while using primary key with “underscore” character in apache ignite

    nabble.com | 3 months ago
    org.apache.ignite.IgniteCheckedException: Failed to register query type: TypeDescriptor [name=Employees, fields={empNo=class java.lang.Object, birthDate=class java.sql.Date, firstName=class java.lang.Object, lastName=class java.lang.Object, gender=class java.lang.Object, hireDate=class java.sql.Date}, indexes={PRIMARY=IndexDescriptor [type=SORTED]}, fullTextIdx=null, keyCls=class java.lang.Object, valCls=class java.lang.Object, valTextIdx=false, registered=false]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    GitHub comment 321#233844005

    GitHub | 5 months ago | thomasmueller
    org.h2.jdbc.JdbcSQLException: Column "VALUE" must be in the GROUP BY list; SQL statement: select case when value >= ? then ? else 'Other' end, count(1) from my_data group by case when value >= ? then ? else 'Other' end [90016-192]
  6. 0

    Unable to use prepared statement + case + group By

    GitHub | 5 months ago | velo
    org.h2.jdbc.JdbcSQLException: Column "VALUE" must be in the GROUP BY list; SQL statement: select case when value >= ? then ? else 'Other' end, count(1) from my_data group by case when value >= ? then ? else 'Other' end [90016-192]

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. 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()
    2. H2 Database Engine
      Table.getColumn
      1. org.h2.message.DbException.getJdbcSQLException(DbException.java:332)
      2. org.h2.message.DbException.get(DbException.java:172)
      3. org.h2.message.DbException.get(DbException.java:149)
      4. org.h2.table.Table.getColumn(Table.java:626)
      4 frames
    3. org.apache.ignite
      GridH2Table$Engine.createTable
      1. org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing$TableDescriptor.createIndexes(IgniteH2Indexing.java:1984)
      2. org.apache.ignite.internal.processors.query.h2.opt.GridH2Table.<init>(GridH2Table.java:106)
      3. org.apache.ignite.internal.processors.query.h2.opt.GridH2Table$Engine.createTable(GridH2Table.java:675)
      4. org.apache.ignite.internal.processors.query.h2.opt.GridH2Table$Engine.createTable(GridH2Table.java:659)
      4 frames
    4. H2 Database Engine
      JdbcStatement.execute
      1. org.h2.schema.Schema.createTable(Schema.java:584)
      2. org.h2.command.ddl.CreateTable.update(CreateTable.java:135)
      3. org.h2.command.CommandContainer.update(CommandContainer.java:79)
      4. org.h2.command.Command.executeUpdate(Command.java:253)
      5. org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:181)
      6. org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:156)
      6 frames
    5. org.apache.ignite
      GridWorker.run
      1. org.apache.ignite.internal.processors.query.h2.opt.GridH2Table$Engine.createTable(GridH2Table.java:700)
      2. org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.createTable(IgniteH2Indexing.java:1288)
      3. org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.registerType(IgniteH2Indexing.java:1160)
      4. org.apache.ignite.internal.processors.query.GridQueryProcessor.initializeCache(GridQueryProcessor.java:291)
      5. org.apache.ignite.internal.processors.query.GridQueryProcessor.onCacheStart(GridQueryProcessor.java:457)
      6. org.apache.ignite.internal.processors.cache.GridCacheProcessor.startCache(GridCacheProcessor.java:1038)
      7. org.apache.ignite.internal.processors.cache.GridCacheProcessor.prepareCacheStart(GridCacheProcessor.java:1648)
      8. org.apache.ignite.internal.processors.cache.GridCacheProcessor.prepareCachesStart(GridCacheProcessor.java:1563)
      9. org.apache.ignite.internal.processors.cache.distributed.dht.preloader.GridDhtPartitionsExchangeFuture.startCaches(GridDhtPartitionsExchangeFuture.java:956)
      10. org.apache.ignite.internal.processors.cache.distributed.dht.preloader.GridDhtPartitionsExchangeFuture.init(GridDhtPartitionsExchangeFuture.java:523)
      11. org.apache.ignite.internal.processors.cache.GridCachePartitionExchangeManager$ExchangeWorker.body(GridCachePartitionExchangeManager.java:1297)
      12. org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110)
      12 frames
    6. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:745)
      1 frame