You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@ignite.apache.org by "Chetan.V.Yadav" <Ch...@target.com> on 2016/09/06 13:19:52 UTC

Re: [EXTERNAL] Re: class org.apache.ignite.IgniteCheckedException: Failed to register query type: TypeDescriptor

Hi,

 I changed the variable to “todayData" from “today” in SalesModel but still getting same error.


/** TdyFeedModel: todayData (not-indexed). */

@QuerySqlField

public TdyFeedModel todayData;

--
Regards,
Chetan.

From: Sergi Vladykin <se...@gmail.com>>
Reply-To: "user@ignite.apache.org<ma...@ignite.apache.org>" <us...@ignite.apache.org>>
Date: Tuesday, September 6, 2016 at 5:18 PM
To: "user@ignite.apache.org<ma...@ignite.apache.org>" <us...@ignite.apache.org>>
Subject: [EXTERNAL] Re: class org.apache.ignite.IgniteCheckedException: Failed to register query type: TypeDescriptor

Hi!

The name `TODAY` is problematic because there is a function with the same name.

Sergi

2016-09-06 12:40 GMT+03:00 chevy <ch...@target.com>>:
Hi,

 I am getting "Caused by: org.h2.jdbc.JdbcSQLException: Syntax error in SQL
statement "CREATE TABLE ""salesCache"".SALESMODEL (_KEY INT NOT NULL,_VAL
OTHER,ID VARCHAR,STOREID INT,DATE VARCHAR,GOAL DOUBLE,FORECAST
DOUBLE,HOURLYSALES OTHER,SALESDATE VARCHAR,TODAY[*] OTHER,TYSALES
DOUBLE,LYSALES DOUBLE,TYTRANSACTIONCOUNT DOUBLE,LYTRANSACTIONCOUNT
DOUBLE,TYAVERAGEBASKETSIZE DOUBLE,LYAVERAGEBASKETSIZE DOUBLE,PREVIOUSDAY
OTHER,WEEKTODATE OTHER,MONTHTODATE OTHER) ENGINE "
"org.apache.ignite.internal.processors.query.h2.opt.GridH2Table$Engine"" ";
expected "identifier"; SQL statement:
CREATE TABLE "salesCache".SalesModel (_key INT NOT NULL,_val OTHER,id
VARCHAR,storeId INT,date VARCHAR,goal DOUBLE,forecast DOUBLE,hourlySales
OTHER,salesDate VARCHAR,today OTHER,tySales DOUBLE,lySales
DOUBLE,tyTransactionCount DOUBLE,lyTransactionCount
DOUBLE,tyAverageBasketSize DOUBLE,lyAverageBasketSize DOUBLE,previousDay
OTHER,weekToDate OTHER,monthToDate OTHER) engine
"org.apache.ignite.internal.processors.query.h2.opt.GridH2Table$Engine"
error.

I have attached complete log in this post. I am not able to understand how
my data is affecting creating of cache schema and table.

I am adding data to cache in below format -

"cache.putAll(finalMap)" and cache is of format "IgniteCache<Integer,
SalesModel> cache". "finalMap" looks like "finalMap.put(storeId,
salesModel)". SalesModel structure is shown below -

package com.ignite.model.sales;

import java.io.Serializable;
import java.sql.Date;

import org.apache.ignite.cache.query.annotations.QuerySqlField;

public class SalesModel implements Serializable {

        private static final long serialVersionUID = 1L;

        /** SalesModel: id (not-indexed). */
        @QuerySqlField
        public String id;

        /** SalesModel: storeId (not-indexed). */
        @QuerySqlField
        public int storeId;

        /** SalesModel: date (not-indexed). */
        @QuerySqlField
        public String date;

        /** TdyFeedModel: tdy (not-indexed). */
        @QuerySqlField
        public TdyFeedModel day;

        /** YstFeedModel: yst (not-indexed). */
        @QuerySqlField
        public WtdFeedModel previousDay;

        /** WtdFeedModel: wtd (not-indexed). */
        @QuerySqlField
        public WtdFeedModel weekToDate;

        /** MtdFeedModel: mtd (not-indexed). */
        @QuerySqlField
        public MtdFeedModel monthToDate;

        //setters and getters for all variables
}

Cache config is as shown below -
/* Initialize cache configuration */
                        cacheCfg.setName("salesCache");
                        cacheCfg.setCacheMode(CacheMode.REPLICATED);
                        cacheCfg.setSwapEnabled(false);
                        cacheCfg.setOffHeapMaxMemory(0);
                        cacheCfg.setCopyOnRead(false);

cacheCfg.setWriteSynchronizationMode(CacheWriteSynchronizationMode.FULL_SYNC);
                        cacheCfg.setAtomicWriteOrderMode(CacheAtomicWriteOrderMode.CLOCK);
                        cacheCfg.setIndexedTypes(Integer.class, SalesModel.class);

                        /* Start Ignite node. */
                        String path = "src/main/java/com/ignite/config/";
                        Ignite ignite = Ignition.start(path + "mpm-ignite.xml");

                        try (IgniteCache<Integer, SalesModel> cache =
ignite.getOrCreateCache(cacheCfg)) {
                                if (ignite.cluster().forDataNodes(cache.getName()).nodes().isEmpty()) {
                                        ...
                                }

                                // Put created data entries to cache.
                                cache.putAll(finalMap);

log.txt <http://apache-ignite-users.70518.x6.nabble.com/file/n7543/log.txt>



--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/class-org-apache-ignite-IgniteCheckedException-Failed-to-register-query-type-TypeDescriptor-tp7543.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: [EXTERNAL] Re: class org.apache.ignite.IgniteCheckedException: Failed to register query type: TypeDescriptor

Posted by chevy <ch...@target.com>.

Thanks for the help Sergi. I ran jps and found a thread hanging which had
skipped my exit criteria. Started working after I killed it.



--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/class-org-apache-ignite-IgniteCheckedException-Failed-to-register-query-type-TypeDescriptor-tp7543p7585.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: [EXTERNAL] Re: class org.apache.ignite.IgniteCheckedException: Failed to register query type: TypeDescriptor

Posted by Sergi Vladykin <se...@gmail.com>.

Yes, it still complains about TODAY field which must not exist anymore. You
need to make sure that Ignite picks up the latest code.
I'm not sure how to achieve that in your environment, never experienced
problems like this, but there are some ideas: run jps and check that no
Ignite nodes are alive, checkout and rebuild your project sources from
scratch, etc...

Sergi

2016-09-06 21:44 GMT+03:00 chevy <ch...@target.com>:

> [00:13:05,916][SEVERE][main][IgniteKernal] Got exception while starting
> (will rollback startup routine).
>
> class org.apache.ignite.IgniteCheckedException: Failed to register query
> type: TypeDescriptor [name=SalesModel, fields={id=class java.lang.String,
> storeId=class java.lang.Integer, date=class java.lang.String, goal=class
> java.lang.Double, forecast=class java.lang.Double, hourlySales=interface
> java.util.List, salesDate=class java.lang.String, today=class
> java.lang.Object, tySales=class java.lang.Double, lySales=class
> java.lang.Double, tyTransactionCount=class java.lang.Double,
> lyTransactionCount=class java.lang.Double, tyAverageBasketSize=class
> java.lang.Double, lyAverageBasketSize=class java.lang.Double,
> previousDay=class java.lang.Object, weekToDate=class java.lang.Object,
> monthToDate=class java.lang.Object}, indexes={storeId_idx=IndexDescriptor
> [type=SORTED], id_idx=IndexDescriptor [type=SORTED]}, fullTextIdx=null,
> keyCls=class java.lang.Integer, valCls=class java.lang.Object,
> valTextIdx=false, registered=false]
>
> at org.apache.ignite.internal.processors.query.h2.
> IgniteH2Indexing.registerType(IgniteH2Indexing.java:1213)
>
> at org.apache.ignite.internal.processors.query.GridQueryProcessor.
> initializeCache(GridQueryProcessor.java:291)
>
> at org.apache.ignite.internal.processors.query.GridQueryProcessor.
> onCacheStart(GridQueryProcessor.java:462)
>
> at org.apache.ignite.internal.processors.cache.
> GridCacheProcessor.startCache(GridCacheProcessor.java:1042)
>
> at org.apache.ignite.internal.processors.cache.GridCacheProcessor.
> onKernalStart(GridCacheProcessor.java:797)
>
> at org.apache.ignite.internal.IgniteKernal.start(IgniteKernal.java:926)
>
> at org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start0(
> IgnitionEx.java:1736)
>
> at org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start(
> IgnitionEx.java:1589)
>
> at org.apache.ignite.internal.IgnitionEx.start0(IgnitionEx.java:1042)
>
> at org.apache.ignite.internal.IgnitionEx.startConfigurations(
> IgnitionEx.java:964)
>
> at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:850)
>
> at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:749)
>
> at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:619)
>
> at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:589)
>
> at org.apache.ignite.Ignition.start(Ignition.java:347)
>
> at org.apache.ignite.startup.cmdline.CommandLineStartup.
> main(CommandLineStartup.java:302)
>
> Caused by: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement
> "CREATE TABLE ""salesCache"".SALESMODEL (_KEY INT NOT NULL,_VAL OTHER,ID
> VARCHAR,STOREID INT,DATE VARCHAR,GOAL DOUBLE,FORECAST DOUBLE,HOURLYSALES
> OTHER,SALESDATE VARCHAR,TODAY[*] OTHER,TYSALES DOUBLE,LYSALES
> DOUBLE,TYTRANSACTIONCOUNT DOUBLE,LYTRANSACTIONCOUNT
> DOUBLE,TYAVERAGEBASKETSIZE DOUBLE,LYAVERAGEBASKETSIZE DOUBLE,PREVIOUSDAY
> OTHER,WEEKTODATE OTHER,MONTHTODATE OTHER) ENGINE
> ""org.apache.ignite.internal.processors.query.h2.opt.GridH2Table$Engine""
> "; expected "identifier"; SQL statement:
>
> CREATE TABLE "salesCache".SalesModel (_key INT NOT NULL,_val OTHER,id
> VARCHAR,storeId INT,date VARCHAR,goal DOUBLE,forecast DOUBLE,hourlySales
> OTHER,salesDate VARCHAR,today OTHER,tySales DOUBLE,lySales
> DOUBLE,tyTransactionCount DOUBLE,lyTransactionCount
> DOUBLE,tyAverageBasketSize DOUBLE,lyAverageBasketSize DOUBLE,previousDay
> OTHER,weekToDate OTHER,monthToDate OTHER) engine
> "org.apache.ignite.internal.processors.query.h2.opt.GridH2Table$Engine"
> [42001-175]
>
> at org.h2.message.DbException.getJdbcSQLException(DbException.java:332)
>
> at org.h2.message.DbException.getSyntaxError(DbException.java:197)
>
> at org.h2.command.Parser.readColumnIdentifier(Parser.java:2967)
>
> at org.h2.command.Parser.parseCreateTable(Parser.java:5524)
>
> at org.h2.command.Parser.parseCreate(Parser.java:4003)
>
> at org.h2.command.Parser.parsePrepared(Parser.java:343)
>
> at org.h2.command.Parser.parse(Parser.java:298)
>
> at org.h2.command.Parser.parse(Parser.java:270)
>
> at org.h2.command.Parser.prepareCommand(Parser.java:235)
>
> at org.h2.engine.Session.prepareLocal(Session.java:436)
>
> at org.h2.engine.Session.prepareCommand(Session.java:379)
>
> at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1138)
>
> at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:168)
>
> at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:156)
>
> at org.apache.ignite.internal.processors.query.h2.opt.GridH2Table$Engine.
> createTable(GridH2Table.java:699)
>
> at org.apache.ignite.internal.processors.query.h2.
> IgniteH2Indexing.createTable(IgniteH2Indexing.java:1334)
>
> at org.apache.ignite.internal.processors.query.h2.
> IgniteH2Indexing.registerType(IgniteH2Indexing.java:1206)
>
> ... 15 more
>
> [00:13:05,921][INFO][main][GridTcpRestProtocol] Command protocol
> successfully stopped: TCP binary
>
> [00:13:05,923][WARNING][main][GridCacheIoManager] Failed to unregister
> ordered cache communication handler because it was not found for topic: T6
> [topic=TOPIC_CACHE, id1=83e8ca36-2305-3266-8e65-1463be879baa, id2=0]
>
> [00:13:05,923][SEVERE][main][IgniteKernal] Failed to pre-stop processor:
> GridProcessorAdapter []
>
> java.lang.NullPointerException
>
> at org.apache.ignite.internal.processors.cache.GridCacheAffinityManager.
> cancelFutures(GridCacheAffinityManager.java:95)
>
> at org.apache.ignite.internal.processors.cache.GridCacheProcessor.
> onKernalStop(GridCacheProcessor.java:891)
>
> at org.apache.ignite.internal.IgniteKernal.stop0(IgniteKernal.java:1874)
>
> at org.apache.ignite.internal.IgniteKernal.stop(IgniteKernal.java:1820)
>
> at org.apache.ignite.internal.IgniteKernal.start(IgniteKernal.java:949)
>
> at org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start0(
> IgnitionEx.java:1736)
>
> at org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start(
> IgnitionEx.java:1589)
>
> at org.apache.ignite.internal.IgnitionEx.start0(IgnitionEx.java:1042)
>
> at org.apache.ignite.internal.IgnitionEx.startConfigurations(
> IgnitionEx.java:964)
>
> at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:850)
>
> at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:749)
>
> at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:619)
>
> at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:589)
>
> at org.apache.ignite.Ignition.start(Ignition.java:347)
>
> at org.apache.ignite.startup.cmdline.CommandLineStartup.
> main(CommandLineStartup.java:302)
>
> [00:13:05,939][INFO][main][IgniteKernal]
>
>
> >>> Ignite ver. 1.6.0#20160518-sha1:0b22c45bb9b97692208fd0705ddf8045ff34a031
> stopped with ERRORS
>
> >>> +-----------------------------------------------------------
> -------------------------------+
>
> >>> Grid uptime: 00:00:05:442
>
> >>> See log above for detailed error message.
>
> >>> Note that some errors during stop can prevent grid from
>
> >>> maintaining correct topology since this node may have
>
> >>> not exited grid properly.
>
>
>
> class org.apache.ignite.IgniteException: Failed to register query type:
> TypeDescriptor [name=SalesModel, fields={id=class java.lang.String,
> storeId=class java.lang.Integer, date=class java.lang.String, goal=class
> java.lang.Double, forecast=class java.lang.Double, hourlySales=interface
> java.util.List, salesDate=class java.lang.String, today=class
> java.lang.Object, tySales=class java.lang.Double, lySales=class
> java.lang.Double, tyTransactionCount=class java.lang.Double,
> lyTransactionCount=class java.lang.Double, tyAverageBasketSize=class
> java.lang.Double, lyAverageBasketSize=class java.lang.Double,
> previousDay=class java.lang.Object, weekToDate=class java.lang.Object,
> monthToDate=class java.lang.Object}, indexes={storeId_idx=IndexDescriptor
> [type=SORTED], id_idx=IndexDescriptor [type=SORTED]}, fullTextIdx=null,
> keyCls=class java.lang.Integer, valCls=class java.lang.Object,
> valTextIdx=false, registered=false]
>
> at org.apache.ignite.internal.util.IgniteUtils.
> convertException(IgniteUtils.java:906)
>
> at org.apache.ignite.Ignition.start(Ignition.java:350)
>
> at org.apache.ignite.startup.cmdline.CommandLineStartup.
> main(CommandLineStartup.java:302)
>
> Caused by: class org.apache.ignite.IgniteCheckedException: Failed to
> register query type: TypeDescriptor [name=SalesModel, fields={id=class
> java.lang.String, storeId=class java.lang.Integer, date=class
> java.lang.String, goal=class java.lang.Double, forecast=class
> java.lang.Double, hourlySales=interface java.util.List, salesDate=class
> java.lang.String, today=class java.lang.Object, tySales=class
> java.lang.Double, lySales=class java.lang.Double, tyTransactionCount=class
> java.lang.Double, lyTransactionCount=class java.lang.Double,
> tyAverageBasketSize=class java.lang.Double, lyAverageBasketSize=class
> java.lang.Double, previousDay=class java.lang.Object, weekToDate=class
> java.lang.Object, monthToDate=class java.lang.Object}, indexes={storeId_idx=IndexDescriptor
> [type=SORTED], id_idx=IndexDescriptor [type=SORTED]}, fullTextIdx=null,
> keyCls=class java.lang.Integer, valCls=class java.lang.Object,
> valTextIdx=false, registered=false]
>
> at org.apache.ignite.internal.processors.query.h2.
> IgniteH2Indexing.registerType(IgniteH2Indexing.java:1213)
>
> at org.apache.ignite.internal.processors.query.GridQueryProcessor.
> initializeCache(GridQueryProcessor.java:291)
>
> at org.apache.ignite.internal.processors.query.GridQueryProcessor.
> onCacheStart(GridQueryProcessor.java:462)
>
> at org.apache.ignite.internal.processors.cache.
> GridCacheProcessor.startCache(GridCacheProcessor.java:1042)
>
> at org.apache.ignite.internal.processors.cache.GridCacheProcessor.
> onKernalStart(GridCacheProcessor.java:797)
>
> at org.apache.ignite.internal.IgniteKernal.start(IgniteKernal.java:926)
>
> at org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start0(
> IgnitionEx.java:1736)
>
> at org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start(
> IgnitionEx.java:1589)
>
> at org.apache.ignite.internal.IgnitionEx.start0(IgnitionEx.java:1042)
>
> at org.apache.ignite.internal.IgnitionEx.startConfigurations(
> IgnitionEx.java:964)
>
> at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:850)
>
> at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:749)
>
> at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:619)
>
> at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:589)
>
> at org.apache.ignite.Ignition.start(Ignition.java:347)
>
> ... 1 more
>
> Caused by: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement
> "CREATE TABLE ""salesCache"".SALESMODEL (_KEY INT NOT NULL,_VAL OTHER,ID
> VARCHAR,STOREID INT,DATE VARCHAR,GOAL DOUBLE,FORECAST DOUBLE,HOURLYSALES
> OTHER,SALESDATE VARCHAR,TODAY[*] OTHER,TYSALES DOUBLE,LYSALES
> DOUBLE,TYTRANSACTIONCOUNT DOUBLE,LYTRANSACTIONCOUNT
> DOUBLE,TYAVERAGEBASKETSIZE DOUBLE,LYAVERAGEBASKETSIZE DOUBLE,PREVIOUSDAY
> OTHER,WEEKTODATE OTHER,MONTHTODATE OTHER) ENGINE
> ""org.apache.ignite.internal.processors.query.h2.opt.GridH2Table$Engine""
> "; expected "identifier"; SQL statement:
>
> CREATE TABLE "salesCache".SalesModel (_key INT NOT NULL,_val OTHER,id
> VARCHAR,storeId INT,date VARCHAR,goal DOUBLE,forecast DOUBLE,hourlySales
> OTHER,salesDate VARCHAR,today OTHER,tySales DOUBLE,lySales
> DOUBLE,tyTransactionCount DOUBLE,lyTransactionCount
> DOUBLE,tyAverageBasketSize DOUBLE,lyAverageBasketSize DOUBLE,previousDay
> OTHER,weekToDate OTHER,monthToDate OTHER) engine
> "org.apache.ignite.internal.processors.query.h2.opt.GridH2Table$Engine"
> [42001-175]
>
> at org.h2.message.DbException.getJdbcSQLException(DbException.java:332)
>
> at org.h2.message.DbException.getSyntaxError(DbException.java:197)
>
> at org.h2.command.Parser.readColumnIdentifier(Parser.java:2967)
>
> at org.h2.command.Parser.parseCreateTable(Parser.java:5524)
>
> at org.h2.command.Parser.parseCreate(Parser.java:4003)
>
> at org.h2.command.Parser.parsePrepared(Parser.java:343)
>
> at org.h2.command.Parser.parse(Parser.java:298)
>
> at org.h2.command.Parser.parse(Parser.java:270)
>
> at org.h2.command.Parser.prepareCommand(Parser.java:235)
>
> at org.h2.engine.Session.prepareLocal(Session.java:436)
>
> at org.h2.engine.Session.prepareCommand(Session.java:379)
>
> at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1138)
>
> at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:168)
>
> at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:156)
>
> at org.apache.ignite.internal.processors.query.h2.opt.GridH2Table$Engine.
> createTable(GridH2Table.java:699)
>
> at org.apache.ignite.internal.processors.query.h2.
> IgniteH2Indexing.createTable(IgniteH2Indexing.java:1334)
>
> at org.apache.ignite.internal.processors.query.h2.
> IgniteH2Indexing.registerType(IgniteH2Indexing.java:1206)
>
> ... 15 more
>
> Failed to start grid: Failed to register query type: TypeDescriptor
> [name=SalesModel, fields={id=class java.lang.String, storeId=class
> java.lang.Integer, date=class java.lang.String, goal=class
> java.lang.Double, forecast=class java.lang.Double, hourlySales=interface
> java.util.List, salesDate=class java.lang.String, today=class
> java.lang.Object, tySales=class java.lang.Double, lySales=class
> java.lang.Double, tyTransactionCount=class java.lang.Double,
> lyTransactionCount=class java.lang.Double, tyAverageBasketSize=class
> java.lang.Double, lyAverageBasketSize=class java.lang.Double,
> previousDay=class java.lang.Object, weekToDate=class java.lang.Object,
> monthToDate=class java.lang.Object}, indexes={storeId_idx=IndexDescriptor
> [type=SORTED], id_idx=IndexDescriptor [type=SORTED]}, fullTextIdx=null,
> keyCls=class java.lang.Integer, valCls=class java.lang.Object,
> valTextIdx=false, registered=false]
>
> --
> Regards,
> Chetan.
>
> From: "Sergi Vladykin [via Apache Ignite Users]" <[hidden email]
> <http:///user/SendEmail.jtp?type=node&node=7556&i=0>>
> Date: Tuesday, September 6, 2016 at 11:46 PM
> To: "Chetan.V.Yadav" <[hidden email]
> <http:///user/SendEmail.jtp?type=node&node=7556&i=1>>
> Subject: Re: [EXTERNAL] Re: class org.apache.ignite.IgniteCheckedException:
> Failed to register query type: TypeDescriptor
>
> Please send the full stack trace of the error you are getting now, may be
> it is not really the same.
>
> Sergi
>
> 2016-09-06 20:56 GMT+03:00 chevy <[hidden email]
> <http:///user/SendEmail.jtp?type=node&node=7555&i=0>>:
>
>> Your point is true. But I did a maven clean build and also checked error
>> and its same error. Not sure why this is happening. Is there any other
>> place that maven saves class files? I am running using eclipse.
>> --
>> Regards,
>> Chetan.
>>
>> From: "Sergi Vladykin [via Apache Ignite Users]" <[hidden email]
>> <http:///user/SendEmail.jtp?type=node&node=7554&i=0>>
>> Date: Tuesday, September 6, 2016 at 9:30 PM
>> To: "Chetan.V.Yadav" <[hidden email]
>> <http:///user/SendEmail.jtp?type=node&node=7554&i=1>>
>> Subject: Re: [EXTERNAL] Re: class org.apache.ignite.IgniteCheckedException:
>> Failed to register query type: TypeDescriptor
>>
>> I guess it is either not the same error or you run the old code or
>> something like this.
>>
>> Please make sure that there is no mistake: restart clean cluster, rebuild
>> the code and run it again.
>>
>> Sergi
>>
>> 2016-09-06 16:19 GMT+03:00 Chetan.V.Yadav <[hidden email]
>> <http:///user/SendEmail.jtp?type=node&node=7553&i=0>>:
>>
>>> Hi,
>>>
>>>  I changed the variable to “todayData" from “today” in SalesModel but
>>> still getting same error.
>>>
>>> /** TdyFeedModel: todayData (not-indexed). */
>>>
>>> @QuerySqlField
>>>
>>> public TdyFeedModel todayData;
>>> --
>>> Regards,
>>> Chetan.
>>>
>>> From: Sergi Vladykin <[hidden email]
>>> <http:///user/SendEmail.jtp?type=node&node=7553&i=1>>
>>> Reply-To: "[hidden email]
>>> <http:///user/SendEmail.jtp?type=node&node=7553&i=2>" <[hidden email]
>>> <http:///user/SendEmail.jtp?type=node&node=7553&i=3>>
>>> Date: Tuesday, September 6, 2016 at 5:18 PM
>>> To: "[hidden email] <http:///user/SendEmail.jtp?type=node&node=7553&i=4>"
>>> <[hidden email] <http:///user/SendEmail.jtp?type=node&node=7553&i=5>>
>>> Subject: [EXTERNAL] Re: class org.apache.ignite.IgniteCheckedException:
>>> Failed to register query type: TypeDescriptor
>>>
>>> Hi!
>>>
>>> The name `TODAY` is problematic because there is a function with the
>>> same name.
>>>
>>> Sergi
>>>
>>> 2016-09-06 12:40 GMT+03:00 chevy <[hidden email]
>>> <http:///user/SendEmail.jtp?type=node&node=7553&i=6>>:
>>>
>>>> Hi,
>>>>
>>>>  I am getting "Caused by: org.h2.jdbc.JdbcSQLException: Syntax error in
>>>> SQL
>>>> statement "CREATE TABLE ""salesCache"".SALESMODEL (_KEY INT NOT
>>>> NULL,_VAL
>>>> OTHER,ID VARCHAR,STOREID INT,DATE VARCHAR,GOAL DOUBLE,FORECAST
>>>> DOUBLE,HOURLYSALES OTHER,SALESDATE VARCHAR,TODAY[*] OTHER,TYSALES
>>>> DOUBLE,LYSALES DOUBLE,TYTRANSACTIONCOUNT DOUBLE,LYTRANSACTIONCOUNT
>>>> DOUBLE,TYAVERAGEBASKETSIZE DOUBLE,LYAVERAGEBASKETSIZE DOUBLE,PREVIOUSDAY
>>>> OTHER,WEEKTODATE OTHER,MONTHTODATE OTHER) ENGINE "
>>>> "org.apache.ignite.internal.processors.query.h2.opt.GridH2Table$Engine""
>>>> ";
>>>> expected "identifier"; SQL statement:
>>>> CREATE TABLE "salesCache".SalesModel (_key INT NOT NULL,_val OTHER,id
>>>> VARCHAR,storeId INT,date VARCHAR,goal DOUBLE,forecast DOUBLE,hourlySales
>>>> OTHER,salesDate VARCHAR,today OTHER,tySales DOUBLE,lySales
>>>> DOUBLE,tyTransactionCount DOUBLE,lyTransactionCount
>>>> DOUBLE,tyAverageBasketSize DOUBLE,lyAverageBasketSize DOUBLE,previousDay
>>>> OTHER,weekToDate OTHER,monthToDate OTHER) engine
>>>> "org.apache.ignite.internal.processors.query.h2.opt.GridH2Table$Engine"
>>>> error.
>>>>
>>>> I have attached complete log in this post. I am not able to understand
>>>> how
>>>> my data is affecting creating of cache schema and table.
>>>>
>>>> I am adding data to cache in below format -
>>>>
>>>> "cache.putAll(finalMap)" and cache is of format "IgniteCache<Integer,
>>>> SalesModel> cache". "finalMap" looks like "finalMap.put(storeId,
>>>> salesModel)". SalesModel structure is shown below -
>>>>
>>>> package com.ignite.model.sales;
>>>>
>>>> import java.io.Serializable;
>>>> import java.sql.Date;
>>>>
>>>> import org.apache.ignite.cache.query.annotations.QuerySqlField;
>>>>
>>>> public class SalesModel implements Serializable {
>>>>
>>>>         private static final long serialVersionUID = 1L;
>>>>
>>>>         /** SalesModel: id (not-indexed). */
>>>>         @QuerySqlField
>>>>         public String id;
>>>>
>>>>         /** SalesModel: storeId (not-indexed). */
>>>>         @QuerySqlField
>>>>         public int storeId;
>>>>
>>>>         /** SalesModel: date (not-indexed). */
>>>>         @QuerySqlField
>>>>         public String date;
>>>>
>>>>         /** TdyFeedModel: tdy (not-indexed). */
>>>>         @QuerySqlField
>>>>         public TdyFeedModel day;
>>>>
>>>>         /** YstFeedModel: yst (not-indexed). */
>>>>         @QuerySqlField
>>>>         public WtdFeedModel previousDay;
>>>>
>>>>         /** WtdFeedModel: wtd (not-indexed). */
>>>>         @QuerySqlField
>>>>         public WtdFeedModel weekToDate;
>>>>
>>>>         /** MtdFeedModel: mtd (not-indexed). */
>>>>         @QuerySqlField
>>>>         public MtdFeedModel monthToDate;
>>>>
>>>>         //setters and getters for all variables
>>>> }
>>>>
>>>> Cache config is as shown below -
>>>> /* Initialize cache configuration */
>>>>                         cacheCfg.setName("salesCache");
>>>>                         cacheCfg.setCacheMode(CacheMode.REPLICATED);
>>>>                         cacheCfg.setSwapEnabled(false);
>>>>                         cacheCfg.setOffHeapMaxMemory(0);
>>>>                         cacheCfg.setCopyOnRead(false);
>>>>
>>>> cacheCfg.setWriteSynchronizationMode(CacheWriteSynchronizati
>>>> onMode.FULL_SYNC);
>>>>                         cacheCfg.setAtomicWriteOrderMo
>>>> de(CacheAtomicWriteOrderMode.CLOCK);
>>>>                         cacheCfg.setIndexedTypes(Integer.class,
>>>> SalesModel.class);
>>>>
>>>>                         /* Start Ignite node. */
>>>>                         String path = "src/main/java/com/ignite/conf
>>>> ig/";
>>>>                         Ignite ignite = Ignition.start(path +
>>>> "mpm-ignite.xml");
>>>>
>>>>                         try (IgniteCache<Integer, SalesModel> cache =
>>>> ignite.getOrCreateCache(cacheCfg)) {
>>>>                                 if (ignite.cluster().forDataNodes
>>>> (cache.getName()).nodes().isEmpty()) {
>>>>                                         ...
>>>>                                 }
>>>>
>>>>                                 // Put created data entries to cache.
>>>>                                 cache.putAll(finalMap);
>>>>
>>>> log.txt <http://apache-ignite-users.70518.x6.nabble.com/file/n7543/l
>>>> og.txt>
>>>>
>>>>
>>>>
>>>> --
>>>> View this message in context: http://apache-ignite-users.705
>>>> 18.x6.nabble.com/class-org-apache-ignite-IgniteCheckedExcept
>>>> ion-Failed-to-register-query-type-TypeDescriptor-tp7543.html
>>>> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>>>>
>>>
>>>
>>
>>
>> ------------------------------
>> If you reply to this email, your message will be added to the discussion
>> below:
>> http://apache-ignite-users.70518.x6.nabble.com/class-org-apa
>> che-ignite-IgniteCheckedException-Failed-to-register-query-
>> type-TypeDescriptor-tp7543p7553.html
>> To unsubscribe from class org.apache.ignite.IgniteCheckedException:
>> Failed to register query type: TypeDescriptor, click here.
>> NAML
>> <http://apache-ignite-users.70518.x6.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
>>
>> ------------------------------
>> View this message in context: Re: [EXTERNAL] Re: class
>> org.apache.ignite.IgniteCheckedException: Failed to register query type:
>> TypeDescriptor
>> <http://apache-ignite-users.70518.x6.nabble.com/class-org-apache-ignite-IgniteCheckedException-Failed-to-register-query-type-TypeDescriptor-tp7543p7554.html>
>>
>> Sent from the Apache Ignite Users mailing list archive
>> <http://apache-ignite-users.70518.x6.nabble.com/> at Nabble.com.
>>
>
>
>
> ------------------------------
> If you reply to this email, your message will be added to the discussion
> below:
> http://apache-ignite-users.70518.x6.nabble.com/class-org-apache-ignite-
> IgniteCheckedException-Failed-to-register-query-type-
> TypeDescriptor-tp7543p7555.html
> To unsubscribe from class org.apache.ignite.IgniteCheckedException:
> Failed to register query type: TypeDescriptor, click here.
> NAML
> <http://apache-ignite-users.70518.x6.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
>
> ------------------------------
> View this message in context: Re: [EXTERNAL] Re: class org.apache.ignite.IgniteCheckedException:
> Failed to register query type: TypeDescriptor
> <http://apache-ignite-users.70518.x6.nabble.com/class-org-apache-ignite-IgniteCheckedException-Failed-to-register-query-type-TypeDescriptor-tp7543p7556.html>
> Sent from the Apache Ignite Users mailing list archive
> <http://apache-ignite-users.70518.x6.nabble.com/> at Nabble.com.
>

Re: [EXTERNAL] Re: class org.apache.ignite.IgniteCheckedException: Failed to register query type: TypeDescriptor

Posted by chevy <ch...@target.com>.

[00:13:05,916][SEVERE][main][IgniteKernal] Got exception while starting (will rollback startup routine).

class org.apache.ignite.IgniteCheckedException: Failed to register query type: TypeDescriptor [name=SalesModel, fields={id=class java.lang.String, storeId=class java.lang.Integer, date=class java.lang.String, goal=class java.lang.Double, forecast=class java.lang.Double, hourlySales=interface java.util.List, salesDate=class java.lang.String, today=class java.lang.Object, tySales=class java.lang.Double, lySales=class java.lang.Double, tyTransactionCount=class java.lang.Double, lyTransactionCount=class java.lang.Double, tyAverageBasketSize=class java.lang.Double, lyAverageBasketSize=class java.lang.Double, previousDay=class java.lang.Object, weekToDate=class java.lang.Object, monthToDate=class java.lang.Object}, indexes={storeId_idx=IndexDescriptor [type=SORTED], id_idx=IndexDescriptor [type=SORTED]}, fullTextIdx=null, keyCls=class java.lang.Integer, valCls=class java.lang.Object, valTextIdx=false, registered=false]

at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.registerType(IgniteH2Indexing.java:1213)

at org.apache.ignite.internal.processors.query.GridQueryProcessor.initializeCache(GridQueryProcessor.java:291)

at org.apache.ignite.internal.processors.query.GridQueryProcessor.onCacheStart(GridQueryProcessor.java:462)

at org.apache.ignite.internal.processors.cache.GridCacheProcessor.startCache(GridCacheProcessor.java:1042)

at org.apache.ignite.internal.processors.cache.GridCacheProcessor.onKernalStart(GridCacheProcessor.java:797)

at org.apache.ignite.internal.IgniteKernal.start(IgniteKernal.java:926)

at org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start0(IgnitionEx.java:1736)

at org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start(IgnitionEx.java:1589)

at org.apache.ignite.internal.IgnitionEx.start0(IgnitionEx.java:1042)

at org.apache.ignite.internal.IgnitionEx.startConfigurations(IgnitionEx.java:964)

at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:850)

at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:749)

at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:619)

at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:589)

at org.apache.ignite.Ignition.start(Ignition.java:347)

at org.apache.ignite.startup.cmdline.CommandLineStartup.main(CommandLineStartup.java:302)

Caused by: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "CREATE TABLE ""salesCache"".SALESMODEL (_KEY INT NOT NULL,_VAL OTHER,ID VARCHAR,STOREID INT,DATE VARCHAR,GOAL DOUBLE,FORECAST DOUBLE,HOURLYSALES OTHER,SALESDATE VARCHAR,TODAY[*] OTHER,TYSALES DOUBLE,LYSALES DOUBLE,TYTRANSACTIONCOUNT DOUBLE,LYTRANSACTIONCOUNT DOUBLE,TYAVERAGEBASKETSIZE DOUBLE,LYAVERAGEBASKETSIZE DOUBLE,PREVIOUSDAY OTHER,WEEKTODATE OTHER,MONTHTODATE OTHER) ENGINE ""org.apache.ignite.internal.processors.query.h2.opt.GridH2Table$Engine"" "; expected "identifier"; SQL statement:

CREATE TABLE "salesCache".SalesModel (_key INT NOT NULL,_val OTHER,id VARCHAR,storeId INT,date VARCHAR,goal DOUBLE,forecast DOUBLE,hourlySales OTHER,salesDate VARCHAR,today OTHER,tySales DOUBLE,lySales DOUBLE,tyTransactionCount DOUBLE,lyTransactionCount DOUBLE,tyAverageBasketSize DOUBLE,lyAverageBasketSize DOUBLE,previousDay OTHER,weekToDate OTHER,monthToDate OTHER) engine "org.apache.ignite.internal.processors.query.h2.opt.GridH2Table$Engine" [42001-175]

at org.h2.message.DbException.getJdbcSQLException(DbException.java:332)

at org.h2.message.DbException.getSyntaxError(DbException.java:197)

at org.h2.command.Parser.readColumnIdentifier(Parser.java:2967)

at org.h2.command.Parser.parseCreateTable(Parser.java:5524)

at org.h2.command.Parser.parseCreate(Parser.java:4003)

at org.h2.command.Parser.parsePrepared(Parser.java:343)

at org.h2.command.Parser.parse(Parser.java:298)

at org.h2.command.Parser.parse(Parser.java:270)

at org.h2.command.Parser.prepareCommand(Parser.java:235)

at org.h2.engine.Session.prepareLocal(Session.java:436)

at org.h2.engine.Session.prepareCommand(Session.java:379)

at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1138)

at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:168)

at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:156)

at org.apache.ignite.internal.processors.query.h2.opt.GridH2Table$Engine.createTable(GridH2Table.java:699)

at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.createTable(IgniteH2Indexing.java:1334)

at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.registerType(IgniteH2Indexing.java:1206)

... 15 more

[00:13:05,921][INFO][main][GridTcpRestProtocol] Command protocol successfully stopped: TCP binary

[00:13:05,923][WARNING][main][GridCacheIoManager] Failed to unregister ordered cache communication handler because it was not found for topic: T6 [topic=TOPIC_CACHE, id1=83e8ca36-2305-3266-8e65-1463be879baa, id2=0]

[00:13:05,923][SEVERE][main][IgniteKernal] Failed to pre-stop processor: GridProcessorAdapter []

java.lang.NullPointerException

at org.apache.ignite.internal.processors.cache.GridCacheAffinityManager.cancelFutures(GridCacheAffinityManager.java:95)

at org.apache.ignite.internal.processors.cache.GridCacheProcessor.onKernalStop(GridCacheProcessor.java:891)

at org.apache.ignite.internal.IgniteKernal.stop0(IgniteKernal.java:1874)

at org.apache.ignite.internal.IgniteKernal.stop(IgniteKernal.java:1820)

at org.apache.ignite.internal.IgniteKernal.start(IgniteKernal.java:949)

at org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start0(IgnitionEx.java:1736)

at org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start(IgnitionEx.java:1589)

at org.apache.ignite.internal.IgnitionEx.start0(IgnitionEx.java:1042)

at org.apache.ignite.internal.IgnitionEx.startConfigurations(IgnitionEx.java:964)

at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:850)

at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:749)

at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:619)

at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:589)

at org.apache.ignite.Ignition.start(Ignition.java:347)

at org.apache.ignite.startup.cmdline.CommandLineStartup.main(CommandLineStartup.java:302)

[00:13:05,939][INFO][main][IgniteKernal]


>>> Ignite ver. 1.6.0#20160518-sha1:0b22c45bb9b97692208fd0705ddf8045ff34a031 stopped with ERRORS

>>> +------------------------------------------------------------------------------------------+

>>> Grid uptime: 00:00:05:442

>>> See log above for detailed error message.

>>> Note that some errors during stop can prevent grid from

>>> maintaining correct topology since this node may have

>>> not exited grid properly.



class org.apache.ignite.IgniteException: Failed to register query type: TypeDescriptor [name=SalesModel, fields={id=class java.lang.String, storeId=class java.lang.Integer, date=class java.lang.String, goal=class java.lang.Double, forecast=class java.lang.Double, hourlySales=interface java.util.List, salesDate=class java.lang.String, today=class java.lang.Object, tySales=class java.lang.Double, lySales=class java.lang.Double, tyTransactionCount=class java.lang.Double, lyTransactionCount=class java.lang.Double, tyAverageBasketSize=class java.lang.Double, lyAverageBasketSize=class java.lang.Double, previousDay=class java.lang.Object, weekToDate=class java.lang.Object, monthToDate=class java.lang.Object}, indexes={storeId_idx=IndexDescriptor [type=SORTED], id_idx=IndexDescriptor [type=SORTED]}, fullTextIdx=null, keyCls=class java.lang.Integer, valCls=class java.lang.Object, valTextIdx=false, registered=false]

at org.apache.ignite.internal.util.IgniteUtils.convertException(IgniteUtils.java:906)

at org.apache.ignite.Ignition.start(Ignition.java:350)

at org.apache.ignite.startup.cmdline.CommandLineStartup.main(CommandLineStartup.java:302)

Caused by: class org.apache.ignite.IgniteCheckedException: Failed to register query type: TypeDescriptor [name=SalesModel, fields={id=class java.lang.String, storeId=class java.lang.Integer, date=class java.lang.String, goal=class java.lang.Double, forecast=class java.lang.Double, hourlySales=interface java.util.List, salesDate=class java.lang.String, today=class java.lang.Object, tySales=class java.lang.Double, lySales=class java.lang.Double, tyTransactionCount=class java.lang.Double, lyTransactionCount=class java.lang.Double, tyAverageBasketSize=class java.lang.Double, lyAverageBasketSize=class java.lang.Double, previousDay=class java.lang.Object, weekToDate=class java.lang.Object, monthToDate=class java.lang.Object}, indexes={storeId_idx=IndexDescriptor [type=SORTED], id_idx=IndexDescriptor [type=SORTED]}, fullTextIdx=null, keyCls=class java.lang.Integer, valCls=class java.lang.Object, valTextIdx=false, registered=false]

at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.registerType(IgniteH2Indexing.java:1213)

at org.apache.ignite.internal.processors.query.GridQueryProcessor.initializeCache(GridQueryProcessor.java:291)

at org.apache.ignite.internal.processors.query.GridQueryProcessor.onCacheStart(GridQueryProcessor.java:462)

at org.apache.ignite.internal.processors.cache.GridCacheProcessor.startCache(GridCacheProcessor.java:1042)

at org.apache.ignite.internal.processors.cache.GridCacheProcessor.onKernalStart(GridCacheProcessor.java:797)

at org.apache.ignite.internal.IgniteKernal.start(IgniteKernal.java:926)

at org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start0(IgnitionEx.java:1736)

at org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start(IgnitionEx.java:1589)

at org.apache.ignite.internal.IgnitionEx.start0(IgnitionEx.java:1042)

at org.apache.ignite.internal.IgnitionEx.startConfigurations(IgnitionEx.java:964)

at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:850)

at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:749)

at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:619)

at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:589)

at org.apache.ignite.Ignition.start(Ignition.java:347)

... 1 more

Caused by: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "CREATE TABLE ""salesCache"".SALESMODEL (_KEY INT NOT NULL,_VAL OTHER,ID VARCHAR,STOREID INT,DATE VARCHAR,GOAL DOUBLE,FORECAST DOUBLE,HOURLYSALES OTHER,SALESDATE VARCHAR,TODAY[*] OTHER,TYSALES DOUBLE,LYSALES DOUBLE,TYTRANSACTIONCOUNT DOUBLE,LYTRANSACTIONCOUNT DOUBLE,TYAVERAGEBASKETSIZE DOUBLE,LYAVERAGEBASKETSIZE DOUBLE,PREVIOUSDAY OTHER,WEEKTODATE OTHER,MONTHTODATE OTHER) ENGINE ""org.apache.ignite.internal.processors.query.h2.opt.GridH2Table$Engine"" "; expected "identifier"; SQL statement:

CREATE TABLE "salesCache".SalesModel (_key INT NOT NULL,_val OTHER,id VARCHAR,storeId INT,date VARCHAR,goal DOUBLE,forecast DOUBLE,hourlySales OTHER,salesDate VARCHAR,today OTHER,tySales DOUBLE,lySales DOUBLE,tyTransactionCount DOUBLE,lyTransactionCount DOUBLE,tyAverageBasketSize DOUBLE,lyAverageBasketSize DOUBLE,previousDay OTHER,weekToDate OTHER,monthToDate OTHER) engine "org.apache.ignite.internal.processors.query.h2.opt.GridH2Table$Engine" [42001-175]

at org.h2.message.DbException.getJdbcSQLException(DbException.java:332)

at org.h2.message.DbException.getSyntaxError(DbException.java:197)

at org.h2.command.Parser.readColumnIdentifier(Parser.java:2967)

at org.h2.command.Parser.parseCreateTable(Parser.java:5524)

at org.h2.command.Parser.parseCreate(Parser.java:4003)

at org.h2.command.Parser.parsePrepared(Parser.java:343)

at org.h2.command.Parser.parse(Parser.java:298)

at org.h2.command.Parser.parse(Parser.java:270)

at org.h2.command.Parser.prepareCommand(Parser.java:235)

at org.h2.engine.Session.prepareLocal(Session.java:436)

at org.h2.engine.Session.prepareCommand(Session.java:379)

at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1138)

at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:168)

at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:156)

at org.apache.ignite.internal.processors.query.h2.opt.GridH2Table$Engine.createTable(GridH2Table.java:699)

at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.createTable(IgniteH2Indexing.java:1334)

at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.registerType(IgniteH2Indexing.java:1206)

... 15 more

Failed to start grid: Failed to register query type: TypeDescriptor [name=SalesModel, fields={id=class java.lang.String, storeId=class java.lang.Integer, date=class java.lang.String, goal=class java.lang.Double, forecast=class java.lang.Double, hourlySales=interface java.util.List, salesDate=class java.lang.String, today=class java.lang.Object, tySales=class java.lang.Double, lySales=class java.lang.Double, tyTransactionCount=class java.lang.Double, lyTransactionCount=class java.lang.Double, tyAverageBasketSize=class java.lang.Double, lyAverageBasketSize=class java.lang.Double, previousDay=class java.lang.Object, weekToDate=class java.lang.Object, monthToDate=class java.lang.Object}, indexes={storeId_idx=IndexDescriptor [type=SORTED], id_idx=IndexDescriptor [type=SORTED]}, fullTextIdx=null, keyCls=class java.lang.Integer, valCls=class java.lang.Object, valTextIdx=false, registered=false]

--
Regards,
Chetan.

From: "Sergi Vladykin [via Apache Ignite Users]" <ml...@n6.nabble.com>>
Date: Tuesday, September 6, 2016 at 11:46 PM
To: "Chetan.V.Yadav" <Ch...@target.com>>
Subject: Re: [EXTERNAL] Re: class org.apache.ignite.IgniteCheckedException: Failed to register query type: TypeDescriptor

Please send the full stack trace of the error you are getting now, may be it is not really the same.

Sergi

2016-09-06 20:56 GMT+03:00 chevy <[hidden email]</user/SendEmail.jtp?type=node&node=7555&i=0>>:
Your point is true. But I did a maven clean build and also checked error and its same error. Not sure why this is happening. Is there any other place that maven saves class files? I am running using eclipse.
--
Regards,
Chetan.

From: "Sergi Vladykin [via Apache Ignite Users]" <[hidden email]<http:///user/SendEmail.jtp?type=node&node=7554&i=0>>
Date: Tuesday, September 6, 2016 at 9:30 PM
To: "Chetan.V.Yadav" <[hidden email]<http:///user/SendEmail.jtp?type=node&node=7554&i=1>>
Subject: Re: [EXTERNAL] Re: class org.apache.ignite.IgniteCheckedException: Failed to register query type: TypeDescriptor

I guess it is either not the same error or you run the old code or something like this.

Please make sure that there is no mistake: restart clean cluster, rebuild the code and run it again.

Sergi

2016-09-06 16:19 GMT+03:00 Chetan.V.Yadav <[hidden email]<http:///user/SendEmail.jtp?type=node&node=7553&i=0>>:
Hi,

 I changed the variable to “todayData" from “today” in SalesModel but still getting same error.


/** TdyFeedModel: todayData (not-indexed). */

@QuerySqlField

public TdyFeedModel todayData;

--
Regards,
Chetan.

From: Sergi Vladykin <[hidden email]<http:///user/SendEmail.jtp?type=node&node=7553&i=1>>
Reply-To: "[hidden email]<http:///user/SendEmail.jtp?type=node&node=7553&i=2>" <[hidden email]<http:///user/SendEmail.jtp?type=node&node=7553&i=3>>
Date: Tuesday, September 6, 2016 at 5:18 PM
To: "[hidden email]<http:///user/SendEmail.jtp?type=node&node=7553&i=4>" <[hidden email]<http:///user/SendEmail.jtp?type=node&node=7553&i=5>>
Subject: [EXTERNAL] Re: class org.apache.ignite.IgniteCheckedException: Failed to register query type: TypeDescriptor

Hi!

The name `TODAY` is problematic because there is a function with the same name.

Sergi

2016-09-06 12:40 GMT+03:00 chevy <[hidden email]<http:///user/SendEmail.jtp?type=node&node=7553&i=6>>:
Hi,

 I am getting "Caused by: org.h2.jdbc.JdbcSQLException: Syntax error in SQL
statement "CREATE TABLE ""salesCache"".SALESMODEL (_KEY INT NOT NULL,_VAL
OTHER,ID VARCHAR,STOREID INT,DATE VARCHAR,GOAL DOUBLE,FORECAST
DOUBLE,HOURLYSALES OTHER,SALESDATE VARCHAR,TODAY[*] OTHER,TYSALES
DOUBLE,LYSALES DOUBLE,TYTRANSACTIONCOUNT DOUBLE,LYTRANSACTIONCOUNT
DOUBLE,TYAVERAGEBASKETSIZE DOUBLE,LYAVERAGEBASKETSIZE DOUBLE,PREVIOUSDAY
OTHER,WEEKTODATE OTHER,MONTHTODATE OTHER) ENGINE "
"org.apache.ignite.internal.pr<http://org.apache.ignite.internal.pr>ocessors.query.h2.opt.GridH2Table$Engine"" ";
expected "identifier"; SQL statement:
CREATE TABLE "salesCache".SalesModel (_key INT NOT NULL,_val OTHER,id
VARCHAR,storeId INT,date VARCHAR,goal DOUBLE,forecast DOUBLE,hourlySales
OTHER,salesDate VARCHAR,today OTHER,tySales DOUBLE,lySales
DOUBLE,tyTransactionCount DOUBLE,lyTransactionCount
DOUBLE,tyAverageBasketSize DOUBLE,lyAverageBasketSize DOUBLE,previousDay
OTHER,weekToDate OTHER,monthToDate OTHER) engine
"org.apache.ignite.internal.pr<http://org.apache.ignite.internal.pr>ocessors.query.h2.opt.GridH2Table$Engine"
error.

I have attached complete log in this post. I am not able to understand how
my data is affecting creating of cache schema and table.

I am adding data to cache in below format -

"cache.putAll(finalMap)" and cache is of format "IgniteCache<Integer,
SalesModel> cache". "finalMap" looks like "finalMap.put(storeId,
salesModel)". SalesModel structure is shown below -

package com.ignite.model.sales;

import java.io.Serializable;
import java.sql.Date;

import org.apache.ignite.cache.query.annotations.QuerySqlField;

public class SalesModel implements Serializable {

        private static final long serialVersionUID = 1L;

        /** SalesModel: id (not-indexed). */
        @QuerySqlField
        public String id;

        /** SalesModel: storeId (not-indexed). */
        @QuerySqlField
        public int storeId;

        /** SalesModel: date (not-indexed). */
        @QuerySqlField
        public String date;

        /** TdyFeedModel: tdy (not-indexed). */
        @QuerySqlField
        public TdyFeedModel day;

        /** YstFeedModel: yst (not-indexed). */
        @QuerySqlField
        public WtdFeedModel previousDay;

        /** WtdFeedModel: wtd (not-indexed). */
        @QuerySqlField
        public WtdFeedModel weekToDate;

        /** MtdFeedModel: mtd (not-indexed). */
        @QuerySqlField
        public MtdFeedModel monthToDate;

        //setters and getters for all variables
}

Cache config is as shown below -
/* Initialize cache configuration */
                        cacheCfg.setName("salesCache");
                        cacheCfg.setCacheMode(CacheMode.REPLICATED);
                        cacheCfg.setSwapEnabled(false);
                        cacheCfg.setOffHeapMaxMemory(0);
                        cacheCfg.setCopyOnRead(false);

cacheCfg.setWriteSynchronizationMode(CacheWriteSynchronizationMode.FULL_SYNC);
                        cacheCfg.setAtomicWriteOrderMode(CacheAtomicWriteOrderMode.CLOCK);
                        cacheCfg.setIndexedTypes(Integer.class, SalesModel.class);

                        /* Start Ignite node. */
                        String path = "src/main/java/com/ignite/config/";
                        Ignite ignite = Ignition.start(path + "mpm-ignite.xml");

                        try (IgniteCache<Integer, SalesModel> cache =
ignite.getOrCreateCache(cacheCfg)) {
                                if (ignite.cluster().forDataNodes(cache.getName()).nodes().isEmpty()) {
                                        ...
                                }

                                // Put created data entries to cache.
                                cache.putAll(finalMap);

log.txt <http://apache-ignite-users.70518.x6.nabble.com/file/n7543/log.txt>



--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/class-org-apache-ignite-IgniteCheckedException-Failed-to-register-query-type-TypeDescriptor-tp7543.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.




________________________________
If you reply to this email, your message will be added to the discussion below:
http://apache-ignite-users.70518.x6.nabble.com/class-org-apache-ignite-IgniteCheckedException-Failed-to-register-query-type-TypeDescriptor-tp7543p7553.html
To unsubscribe from class org.apache.ignite.IgniteCheckedException: Failed to register query type: TypeDescriptor, click here.
NAML<http://apache-ignite-users.70518.x6.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>

________________________________
View this message in context: Re: [EXTERNAL] Re: class org.apache.ignite.IgniteCheckedException: Failed to register query type: TypeDescriptor<http://apache-ignite-users.70518.x6.nabble.com/class-org-apache-ignite-IgniteCheckedException-Failed-to-register-query-type-TypeDescriptor-tp7543p7554.html>

Sent from the Apache Ignite Users mailing list archive<http://apache-ignite-users.70518.x6.nabble.com/> at Nabble.com.



________________________________
If you reply to this email, your message will be added to the discussion below:
http://apache-ignite-users.70518.x6.nabble.com/class-org-apache-ignite-IgniteCheckedException-Failed-to-register-query-type-TypeDescriptor-tp7543p7555.html
To unsubscribe from class org.apache.ignite.IgniteCheckedException: Failed to register query type: TypeDescriptor, click here<http://apache-ignite-users.70518.x6.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=7543&code=Y2hldGFuLnYueWFkYXZAdGFyZ2V0LmNvbXw3NTQzfC02OTIwMTYzODA=>.
NAML<http://apache-ignite-users.70518.x6.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>




--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/class-org-apache-ignite-IgniteCheckedException-Failed-to-register-query-type-TypeDescriptor-tp7543p7556.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: [EXTERNAL] Re: class org.apache.ignite.IgniteCheckedException: Failed to register query type: TypeDescriptor

Posted by Sergi Vladykin <se...@gmail.com>.

Please send the full stack trace of the error you are getting now, may be
it is not really the same.

Sergi

2016-09-06 20:56 GMT+03:00 chevy <ch...@target.com>:

> Your point is true. But I did a maven clean build and also checked error
> and its same error. Not sure why this is happening. Is there any other
> place that maven saves class files? I am running using eclipse.
> --
> Regards,
> Chetan.
>
> From: "Sergi Vladykin [via Apache Ignite Users]" <[hidden email]
> <http:///user/SendEmail.jtp?type=node&node=7554&i=0>>
> Date: Tuesday, September 6, 2016 at 9:30 PM
> To: "Chetan.V.Yadav" <[hidden email]
> <http:///user/SendEmail.jtp?type=node&node=7554&i=1>>
> Subject: Re: [EXTERNAL] Re: class org.apache.ignite.IgniteCheckedException:
> Failed to register query type: TypeDescriptor
>
> I guess it is either not the same error or you run the old code or
> something like this.
>
> Please make sure that there is no mistake: restart clean cluster, rebuild
> the code and run it again.
>
> Sergi
>
> 2016-09-06 16:19 GMT+03:00 Chetan.V.Yadav <[hidden email]
> <http:///user/SendEmail.jtp?type=node&node=7553&i=0>>:
>
>> Hi,
>>
>>  I changed the variable to “todayData" from “today” in SalesModel but
>> still getting same error.
>>
>> /** TdyFeedModel: todayData (not-indexed). */
>>
>> @QuerySqlField
>>
>> public TdyFeedModel todayData;
>> --
>> Regards,
>> Chetan.
>>
>> From: Sergi Vladykin <[hidden email]
>> <http:///user/SendEmail.jtp?type=node&node=7553&i=1>>
>> Reply-To: "[hidden email]
>> <http:///user/SendEmail.jtp?type=node&node=7553&i=2>" <[hidden email]
>> <http:///user/SendEmail.jtp?type=node&node=7553&i=3>>
>> Date: Tuesday, September 6, 2016 at 5:18 PM
>> To: "[hidden email] <http:///user/SendEmail.jtp?type=node&node=7553&i=4>"
>> <[hidden email] <http:///user/SendEmail.jtp?type=node&node=7553&i=5>>
>> Subject: [EXTERNAL] Re: class org.apache.ignite.IgniteCheckedException:
>> Failed to register query type: TypeDescriptor
>>
>> Hi!
>>
>> The name `TODAY` is problematic because there is a function with the same
>> name.
>>
>> Sergi
>>
>> 2016-09-06 12:40 GMT+03:00 chevy <[hidden email]
>> <http:///user/SendEmail.jtp?type=node&node=7553&i=6>>:
>>
>>> Hi,
>>>
>>>  I am getting "Caused by: org.h2.jdbc.JdbcSQLException: Syntax error in
>>> SQL
>>> statement "CREATE TABLE ""salesCache"".SALESMODEL (_KEY INT NOT NULL,_VAL
>>> OTHER,ID VARCHAR,STOREID INT,DATE VARCHAR,GOAL DOUBLE,FORECAST
>>> DOUBLE,HOURLYSALES OTHER,SALESDATE VARCHAR,TODAY[*] OTHER,TYSALES
>>> DOUBLE,LYSALES DOUBLE,TYTRANSACTIONCOUNT DOUBLE,LYTRANSACTIONCOUNT
>>> DOUBLE,TYAVERAGEBASKETSIZE DOUBLE,LYAVERAGEBASKETSIZE DOUBLE,PREVIOUSDAY
>>> OTHER,WEEKTODATE OTHER,MONTHTODATE OTHER) ENGINE "
>>> "org.apache.ignite.internal.processors.query.h2.opt.GridH2Table$Engine""
>>> ";
>>> expected "identifier"; SQL statement:
>>> CREATE TABLE "salesCache".SalesModel (_key INT NOT NULL,_val OTHER,id
>>> VARCHAR,storeId INT,date VARCHAR,goal DOUBLE,forecast DOUBLE,hourlySales
>>> OTHER,salesDate VARCHAR,today OTHER,tySales DOUBLE,lySales
>>> DOUBLE,tyTransactionCount DOUBLE,lyTransactionCount
>>> DOUBLE,tyAverageBasketSize DOUBLE,lyAverageBasketSize DOUBLE,previousDay
>>> OTHER,weekToDate OTHER,monthToDate OTHER) engine
>>> "org.apache.ignite.internal.processors.query.h2.opt.GridH2Table$Engine"
>>> error.
>>>
>>> I have attached complete log in this post. I am not able to understand
>>> how
>>> my data is affecting creating of cache schema and table.
>>>
>>> I am adding data to cache in below format -
>>>
>>> "cache.putAll(finalMap)" and cache is of format "IgniteCache<Integer,
>>> SalesModel> cache". "finalMap" looks like "finalMap.put(storeId,
>>> salesModel)". SalesModel structure is shown below -
>>>
>>> package com.ignite.model.sales;
>>>
>>> import java.io.Serializable;
>>> import java.sql.Date;
>>>
>>> import org.apache.ignite.cache.query.annotations.QuerySqlField;
>>>
>>> public class SalesModel implements Serializable {
>>>
>>>         private static final long serialVersionUID = 1L;
>>>
>>>         /** SalesModel: id (not-indexed). */
>>>         @QuerySqlField
>>>         public String id;
>>>
>>>         /** SalesModel: storeId (not-indexed). */
>>>         @QuerySqlField
>>>         public int storeId;
>>>
>>>         /** SalesModel: date (not-indexed). */
>>>         @QuerySqlField
>>>         public String date;
>>>
>>>         /** TdyFeedModel: tdy (not-indexed). */
>>>         @QuerySqlField
>>>         public TdyFeedModel day;
>>>
>>>         /** YstFeedModel: yst (not-indexed). */
>>>         @QuerySqlField
>>>         public WtdFeedModel previousDay;
>>>
>>>         /** WtdFeedModel: wtd (not-indexed). */
>>>         @QuerySqlField
>>>         public WtdFeedModel weekToDate;
>>>
>>>         /** MtdFeedModel: mtd (not-indexed). */
>>>         @QuerySqlField
>>>         public MtdFeedModel monthToDate;
>>>
>>>         //setters and getters for all variables
>>> }
>>>
>>> Cache config is as shown below -
>>> /* Initialize cache configuration */
>>>                         cacheCfg.setName("salesCache");
>>>                         cacheCfg.setCacheMode(CacheMode.REPLICATED);
>>>                         cacheCfg.setSwapEnabled(false);
>>>                         cacheCfg.setOffHeapMaxMemory(0);
>>>                         cacheCfg.setCopyOnRead(false);
>>>
>>> cacheCfg.setWriteSynchronizationMode(CacheWriteSynchronizati
>>> onMode.FULL_SYNC);
>>>                         cacheCfg.setAtomicWriteOrderMo
>>> de(CacheAtomicWriteOrderMode.CLOCK);
>>>                         cacheCfg.setIndexedTypes(Integer.class,
>>> SalesModel.class);
>>>
>>>                         /* Start Ignite node. */
>>>                         String path = "src/main/java/com/ignite/conf
>>> ig/";
>>>                         Ignite ignite = Ignition.start(path +
>>> "mpm-ignite.xml");
>>>
>>>                         try (IgniteCache<Integer, SalesModel> cache =
>>> ignite.getOrCreateCache(cacheCfg)) {
>>>                                 if (ignite.cluster().forDataNodes
>>> (cache.getName()).nodes().isEmpty()) {
>>>                                         ...
>>>                                 }
>>>
>>>                                 // Put created data entries to cache.
>>>                                 cache.putAll(finalMap);
>>>
>>> log.txt <http://apache-ignite-users.70518.x6.nabble.com/file/n7543/l
>>> og.txt>
>>>
>>>
>>>
>>> --
>>> View this message in context: http://apache-ignite-users.705
>>> 18.x6.nabble.com/class-org-apache-ignite-IgniteCheckedExcept
>>> ion-Failed-to-register-query-type-TypeDescriptor-tp7543.html
>>> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>>>
>>
>>
>
>
> ------------------------------
> If you reply to this email, your message will be added to the discussion
> below:
> http://apache-ignite-users.70518.x6.nabble.com/class-org-apache-ignite-
> IgniteCheckedException-Failed-to-register-query-type-
> TypeDescriptor-tp7543p7553.html
> To unsubscribe from class org.apache.ignite.IgniteCheckedException:
> Failed to register query type: TypeDescriptor, click here.
> NAML
> <http://apache-ignite-users.70518.x6.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
>
> ------------------------------
> View this message in context: Re: [EXTERNAL] Re: class org.apache.ignite.IgniteCheckedException:
> Failed to register query type: TypeDescriptor
> <http://apache-ignite-users.70518.x6.nabble.com/class-org-apache-ignite-IgniteCheckedException-Failed-to-register-query-type-TypeDescriptor-tp7543p7554.html>
>
> Sent from the Apache Ignite Users mailing list archive
> <http://apache-ignite-users.70518.x6.nabble.com/> at Nabble.com.
>

Re: [EXTERNAL] Re: class org.apache.ignite.IgniteCheckedException: Failed to register query type: TypeDescriptor

Posted by chevy <ch...@target.com>.

Your point is true. But I did a maven clean build and also checked error and its same error. Not sure why this is happening. Is there any other place that maven saves class files? I am running using eclipse.
--
Regards,
Chetan.

From: "Sergi Vladykin [via Apache Ignite Users]" <ml...@n6.nabble.com>>
Date: Tuesday, September 6, 2016 at 9:30 PM
To: "Chetan.V.Yadav" <Ch...@target.com>>
Subject: Re: [EXTERNAL] Re: class org.apache.ignite.IgniteCheckedException: Failed to register query type: TypeDescriptor

I guess it is either not the same error or you run the old code or something like this.

Please make sure that there is no mistake: restart clean cluster, rebuild the code and run it again.

Sergi

2016-09-06 16:19 GMT+03:00 Chetan.V.Yadav <[hidden email]</user/SendEmail.jtp?type=node&node=7553&i=0>>:
Hi,

 I changed the variable to “todayData" from “today” in SalesModel but still getting same error.

/** TdyFeedModel: todayData (not-indexed). */

@QuerySqlField

public TdyFeedModel todayData;

--
Regards,
Chetan.

From: Sergi Vladykin <[hidden email]</user/SendEmail.jtp?type=node&node=7553&i=1>>
Reply-To: "[hidden email]</user/SendEmail.jtp?type=node&node=7553&i=2>" <[hidden email]</user/SendEmail.jtp?type=node&node=7553&i=3>>
Date: Tuesday, September 6, 2016 at 5:18 PM
To: "[hidden email]</user/SendEmail.jtp?type=node&node=7553&i=4>" <[hidden email]</user/SendEmail.jtp?type=node&node=7553&i=5>>
Subject: [EXTERNAL] Re: class org.apache.ignite.IgniteCheckedException: Failed to register query type: TypeDescriptor

Hi!

The name `TODAY` is problematic because there is a function with the same name.

Sergi

2016-09-06 12:40 GMT+03:00 chevy <[hidden email]</user/SendEmail.jtp?type=node&node=7553&i=6>>:
Hi,

 I am getting "Caused by: org.h2.jdbc.JdbcSQLException: Syntax error in SQL
statement "CREATE TABLE ""salesCache"".SALESMODEL (_KEY INT NOT NULL,_VAL
OTHER,ID VARCHAR,STOREID INT,DATE VARCHAR,GOAL DOUBLE,FORECAST
DOUBLE,HOURLYSALES OTHER,SALESDATE VARCHAR,TODAY[*] OTHER,TYSALES
DOUBLE,LYSALES DOUBLE,TYTRANSACTIONCOUNT DOUBLE,LYTRANSACTIONCOUNT
DOUBLE,TYAVERAGEBASKETSIZE DOUBLE,LYAVERAGEBASKETSIZE DOUBLE,PREVIOUSDAY
OTHER,WEEKTODATE OTHER,MONTHTODATE OTHER) ENGINE "
"org.apache.ignite.internal.pr<http://org.apache.ignite.internal.pr>ocessors.query.h2.opt.GridH2Table$Engine"" ";
expected "identifier"; SQL statement:
CREATE TABLE "salesCache".SalesModel (_key INT NOT NULL,_val OTHER,id
VARCHAR,storeId INT,date VARCHAR,goal DOUBLE,forecast DOUBLE,hourlySales
OTHER,salesDate VARCHAR,today OTHER,tySales DOUBLE,lySales
DOUBLE,tyTransactionCount DOUBLE,lyTransactionCount
DOUBLE,tyAverageBasketSize DOUBLE,lyAverageBasketSize DOUBLE,previousDay
OTHER,weekToDate OTHER,monthToDate OTHER) engine
"org.apache.ignite.internal.pr<http://org.apache.ignite.internal.pr>ocessors.query.h2.opt.GridH2Table$Engine"
error.

I have attached complete log in this post. I am not able to understand how
my data is affecting creating of cache schema and table.

I am adding data to cache in below format -

"cache.putAll(finalMap)" and cache is of format "IgniteCache<Integer,
SalesModel> cache". "finalMap" looks like "finalMap.put(storeId,
salesModel)". SalesModel structure is shown below -

package com.ignite.model.sales;

import java.io.Serializable;
import java.sql.Date;

import org.apache.ignite.cache.query.annotations.QuerySqlField;

public class SalesModel implements Serializable {

        private static final long serialVersionUID = 1L;

        /** SalesModel: id (not-indexed). */
        @QuerySqlField
        public String id;

        /** SalesModel: storeId (not-indexed). */
        @QuerySqlField
        public int storeId;

        /** SalesModel: date (not-indexed). */
        @QuerySqlField
        public String date;

        /** TdyFeedModel: tdy (not-indexed). */
        @QuerySqlField
        public TdyFeedModel day;

        /** YstFeedModel: yst (not-indexed). */
        @QuerySqlField
        public WtdFeedModel previousDay;

        /** WtdFeedModel: wtd (not-indexed). */
        @QuerySqlField
        public WtdFeedModel weekToDate;

        /** MtdFeedModel: mtd (not-indexed). */
        @QuerySqlField
        public MtdFeedModel monthToDate;

        //setters and getters for all variables
}

Cache config is as shown below -
/* Initialize cache configuration */
                        cacheCfg.setName("salesCache");
                        cacheCfg.setCacheMode(CacheMode.REPLICATED);
                        cacheCfg.setSwapEnabled(false);
                        cacheCfg.setOffHeapMaxMemory(0);
                        cacheCfg.setCopyOnRead(false);

cacheCfg.setWriteSynchronizationMode(CacheWriteSynchronizationMode.FULL_SYNC);
                        cacheCfg.setAtomicWriteOrderMode(CacheAtomicWriteOrderMode.CLOCK);
                        cacheCfg.setIndexedTypes(Integer.class, SalesModel.class);

                        /* Start Ignite node. */
                        String path = "src/main/java/com/ignite/config/";
                        Ignite ignite = Ignition.start(path + "mpm-ignite.xml");

                        try (IgniteCache<Integer, SalesModel> cache =
ignite.getOrCreateCache(cacheCfg)) {
                                if (ignite.cluster().forDataNodes(cache.getName()).nodes().isEmpty()) {
                                        ...
                                }

                                // Put created data entries to cache.
                                cache.putAll(finalMap);

log.txt <http://apache-ignite-users.70518.x6.nabble.com/file/n7543/log.txt>

--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/class-org-apache-ignite-IgniteCheckedException-Failed-to-register-query-type-TypeDescriptor-tp7543.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

________________________________
If you reply to this email, your message will be added to the discussion below:
http://apache-ignite-users.70518.x6.nabble.com/class-org-apache-ignite-IgniteCheckedException-Failed-to-register-query-type-TypeDescriptor-tp7543p7553.html
To unsubscribe from class org.apache.ignite.IgniteCheckedException: Failed to register query type: TypeDescriptor, click here<http://apache-ignite-users.70518.x6.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=7543&code=Y2hldGFuLnYueWFkYXZAdGFyZ2V0LmNvbXw3NTQzfC02OTIwMTYzODA=>.
NAML<http://apache-ignite-users.70518.x6.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>

--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/class-org-apache-ignite-IgniteCheckedException-Failed-to-register-query-type-TypeDescriptor-tp7543p7554.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: [EXTERNAL] Re: class org.apache.ignite.IgniteCheckedException: Failed to register query type: TypeDescriptor

Posted by Sergi Vladykin <se...@gmail.com>.

I guess it is either not the same error or you run the old code or
something like this.

Please make sure that there is no mistake: restart clean cluster, rebuild
the code and run it again.

Sergi

2016-09-06 16:19 GMT+03:00 Chetan.V.Yadav <Ch...@target.com>:

> Hi,
>
>  I changed the variable to “todayData" from “today” in SalesModel but
> still getting same error.
>
> /** TdyFeedModel: todayData (not-indexed). */
>
> @QuerySqlField
>
> public TdyFeedModel todayData;
> --
> Regards,
> Chetan.
>
> From: Sergi Vladykin <se...@gmail.com>
> Reply-To: "user@ignite.apache.org" <us...@ignite.apache.org>
> Date: Tuesday, September 6, 2016 at 5:18 PM
> To: "user@ignite.apache.org" <us...@ignite.apache.org>
> Subject: [EXTERNAL] Re: class org.apache.ignite.IgniteCheckedException:
> Failed to register query type: TypeDescriptor
>
> Hi!
>
> The name `TODAY` is problematic because there is a function with the same
> name.
>
> Sergi
>
> 2016-09-06 12:40 GMT+03:00 chevy <ch...@target.com>:
>
>> Hi,
>>
>>  I am getting "Caused by: org.h2.jdbc.JdbcSQLException: Syntax error in
>> SQL
>> statement "CREATE TABLE ""salesCache"".SALESMODEL (_KEY INT NOT NULL,_VAL
>> OTHER,ID VARCHAR,STOREID INT,DATE VARCHAR,GOAL DOUBLE,FORECAST
>> DOUBLE,HOURLYSALES OTHER,SALESDATE VARCHAR,TODAY[*] OTHER,TYSALES
>> DOUBLE,LYSALES DOUBLE,TYTRANSACTIONCOUNT DOUBLE,LYTRANSACTIONCOUNT
>> DOUBLE,TYAVERAGEBASKETSIZE DOUBLE,LYAVERAGEBASKETSIZE DOUBLE,PREVIOUSDAY
>> OTHER,WEEKTODATE OTHER,MONTHTODATE OTHER) ENGINE "
>> "org.apache.ignite.internal.processors.query.h2.opt.GridH2Table$Engine""
>> ";
>> expected "identifier"; SQL statement:
>> CREATE TABLE "salesCache".SalesModel (_key INT NOT NULL,_val OTHER,id
>> VARCHAR,storeId INT,date VARCHAR,goal DOUBLE,forecast DOUBLE,hourlySales
>> OTHER,salesDate VARCHAR,today OTHER,tySales DOUBLE,lySales
>> DOUBLE,tyTransactionCount DOUBLE,lyTransactionCount
>> DOUBLE,tyAverageBasketSize DOUBLE,lyAverageBasketSize DOUBLE,previousDay
>> OTHER,weekToDate OTHER,monthToDate OTHER) engine
>> "org.apache.ignite.internal.processors.query.h2.opt.GridH2Table$Engine"
>> error.
>>
>> I have attached complete log in this post. I am not able to understand how
>> my data is affecting creating of cache schema and table.
>>
>> I am adding data to cache in below format -
>>
>> "cache.putAll(finalMap)" and cache is of format "IgniteCache<Integer,
>> SalesModel> cache". "finalMap" looks like "finalMap.put(storeId,
>> salesModel)". SalesModel structure is shown below -
>>
>> package com.ignite.model.sales;
>>
>> import java.io.Serializable;
>> import java.sql.Date;
>>
>> import org.apache.ignite.cache.query.annotations.QuerySqlField;
>>
>> public class SalesModel implements Serializable {
>>
>>         private static final long serialVersionUID = 1L;
>>
>>         /** SalesModel: id (not-indexed). */
>>         @QuerySqlField
>>         public String id;
>>
>>         /** SalesModel: storeId (not-indexed). */
>>         @QuerySqlField
>>         public int storeId;
>>
>>         /** SalesModel: date (not-indexed). */
>>         @QuerySqlField
>>         public String date;
>>
>>         /** TdyFeedModel: tdy (not-indexed). */
>>         @QuerySqlField
>>         public TdyFeedModel day;
>>
>>         /** YstFeedModel: yst (not-indexed). */
>>         @QuerySqlField
>>         public WtdFeedModel previousDay;
>>
>>         /** WtdFeedModel: wtd (not-indexed). */
>>         @QuerySqlField
>>         public WtdFeedModel weekToDate;
>>
>>         /** MtdFeedModel: mtd (not-indexed). */
>>         @QuerySqlField
>>         public MtdFeedModel monthToDate;
>>
>>         //setters and getters for all variables
>> }
>>
>> Cache config is as shown below -
>> /* Initialize cache configuration */
>>                         cacheCfg.setName("salesCache");
>>                         cacheCfg.setCacheMode(CacheMode.REPLICATED);
>>                         cacheCfg.setSwapEnabled(false);
>>                         cacheCfg.setOffHeapMaxMemory(0);
>>                         cacheCfg.setCopyOnRead(false);
>>
>> cacheCfg.setWriteSynchronizationMode(CacheWriteSynchronizati
>> onMode.FULL_SYNC);
>>                         cacheCfg.setAtomicWriteOrderMo
>> de(CacheAtomicWriteOrderMode.CLOCK);
>>                         cacheCfg.setIndexedTypes(Integer.class,
>> SalesModel.class);
>>
>>                         /* Start Ignite node. */
>>                         String path = "src/main/java/com/ignite/config/";
>>                         Ignite ignite = Ignition.start(path +
>> "mpm-ignite.xml");
>>
>>                         try (IgniteCache<Integer, SalesModel> cache =
>> ignite.getOrCreateCache(cacheCfg)) {
>>                                 if (ignite.cluster().forDataNodes
>> (cache.getName()).nodes().isEmpty()) {
>>                                         ...
>>                                 }
>>
>>                                 // Put created data entries to cache.
>>                                 cache.putAll(finalMap);
>>
>> log.txt <http://apache-ignite-users.70518.x6.nabble.com/file/n7543/
>> log.txt>
>>
>>
>>
>> --
>> View this message in context: http://apache-ignite-users.705
>> 18.x6.nabble.com/class-org-apache-ignite-IgniteCheckedExcept
>> ion-Failed-to-register-query-type-TypeDescriptor-tp7543.html
>> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>>
>
>