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

2016-09-07 Thread chevy 
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

2016-09-06 Thread Sergi Vladykin 
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 <chetan.v.ya...@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.prepa

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

2016-09-06 Thread chevy 
[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 topi

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

2016-09-06 Thread Sergi Vladykin 
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 <chetan.v.ya...@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=7554=0>>
> Date: Tuesday, September 6, 2016 at 9:30 PM
> To: "Chetan.V.Yadav" <[hidden email]
> <http:///user/SendEmail.jtp?type=node=7554=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=7553=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=7553=1>>
>> Reply-To: "[hidden email]
>> <http:///user/SendEmail.jtp?type=node=7553=2>" <[hidden email]
>> <http:///user/SendEmail.jtp?type=node=7553=3>>
>> Date: Tuesday, September 6, 2016 at 5:18 PM
>> To: "[hidden email] <http:///user/SendEmail.jtp?type=node=7553=4>"
>> <[hidden email] <http:///user/SendEmail.jtp?type=node=7553=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=7553=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). */
>>>

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

2016-09-06 Thread chevy 
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-node+s70518n7553...@n6.nabble.com<mailto:ml-node+s70518n7553...@n6.nabble.com>>
Date: Tuesday, September 6, 2016 at 9:30 PM
To: "Chetan.V.Yadav" 
<chetan.v.ya...@target.com<mailto:chetan.v.ya...@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]>:
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]>
Reply-To: "[hidden email]" 
<[hidden email]>
Date: Tuesday, September 6, 2016 at 5:18 PM
To: "[hidden email]" <[hidden 
email]>
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]>:
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. */

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

2016-09-06 Thread Sergi Vladykin 
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 <chetan.v.ya...@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 <sergi.vlady...@gmail.com>
> Reply-To: "user@ignite.apache.org" <user@ignite.apache.org>
> Date: Tuesday, September 6, 2016 at 5:18 PM
> To: "user@ignite.apache.org" <user@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 <chetan.v.ya...@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.setAtomicWrite

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

2016-09-06 Thread Chetan . V . Yadav 
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 <sergi.vlady...@gmail.com<mailto:sergi.vlady...@gmail.com>>
Reply-To: "user@ignite.apache.org<mailto:user@ignite.apache.org>" 
<user@ignite.apache.org<mailto:user@ignite.apache.org>>
Date: Tuesday, September 6, 2016 at 5:18 PM
To: "user@ignite.apache.org<mailto:user@ignite.apache.org>" 
<user@ignite.apache.org<mailto:user@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 
<chetan.v.ya...@target.com<mailto:chetan.v.ya...@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: class org.apache.ignite.IgniteCheckedException: Failed to register query type: TypeDescriptor

2016-09-06 Thread Sergi Vladykin 
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 :

> 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 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 cache =
> ignite.getOrCreateCache(cacheCfg)) {
> if (ignite.cluster().
> forDataNodes(cache.getName()).nodes().isEmpty()) {
> ...
> }
>
> // Put created data entries to cache.
> cache.putAll(finalMap);
>
> 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.
>

class org.apache.ignite.IgniteCheckedException: Failed to register query type: TypeDescriptor

2016-09-06 Thread chevy 
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 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 cache =
ignite.getOrCreateCache(cacheCfg)) {
if 
(ignite.cluster().forDataNodes(cache.getName()).nodes().isEmpty()) {
...
}

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

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.