RE: failed to find sql table for type:

classic Classic list List threaded Threaded
1 message Options
Alexey Popov Alexey Popov
Reply | Threaded
Open this post in threaded view
|

RE: failed to find sql table for type:

Hi,

 

Do you still have this issue?

 

Can you share your code?

 

Ignite.NET solution has a QueryExample.cs, you can use it as a reference code.

 

Thank you,
Alexey

 

From: [hidden email]
Sent: Wednesday, January 10, 2018 5:56 PM
To: [hidden email]
Subject: failed to find sql table for type:

 

Ignite.NET 2.3.0

 

I'm pulling data from another DB and loading into Ignite node started under

.NET Core console app. After converting the datarows into binary objects and

putting them into the cache, I both do a count as well as debug and see the

objects in the cache with the correct data.

 

I try pulling the objects out of the cache using SqlQuery, and get the

exception. I'm not sure what to check, but at one point yesterday I was able

to do it successfully. I'm not sure what I changed and have been unable to

walk whatever change I thought I made back.

 

Where should I dig to get this resolved? This is all running on a vanilla

ignite node.

 

 

Exception has occurred: CLR/Apache.Ignite.Core.Common.IgniteException

An unhandled exception of type 'Apache.Ignite.Core.Common.IgniteException'

occurred in Apache.Ignite.Core.dll: 'Failed to find SQL table for type:

trebuchetsettings'

Inner exceptions found, see $exception in variables window for more

details.

Innermost exception      Apache.Ignite.Core.Common.JavaException : class

org.apache.ignite.IgniteCheckedException: Failed to find SQL table for type:

trebuchetsettings

                at

org.apache.ignite.internal.processors.platform.utils.PlatformUtils.unwrapQueryException(PlatformUtils.java:519)

                at

org.apache.ignite.internal.processors.platform.cache.PlatformCache.runQuery(PlatformCache.java:1220)

                at

org.apache.ignite.internal.processors.platform.cache.PlatformCache.processInStreamOutObject(PlatformCache.java:874)

                at

org.apache.ignite.internal.processors.platform.PlatformTargetProxyImpl.inStreamOutObject(PlatformTargetProxyImpl.java:79)

Caused by: javax.cache.CacheException: class

org.apache.ignite.internal.processors.query.IgniteSQLException: Failed to

find SQL table for type: trebuchetsettings

                at

org.apache.ignite.internal.processors.cache.IgniteCacheProxyImpl.query(IgniteCacheProxyImpl.java:597)

                at

org.apache.ignite.internal.processors.cache.GatewayProtectedCacheProxy.query(GatewayProtectedCacheProxy.java:368)

                at

org.apache.ignite.internal.processors.platform.cache.PlatformCache.runQuery(PlatformCache.java:1214)

                ... 2 more

Caused by: class

org.apache.ignite.internal.processors.query.IgniteSQLException: Failed to

find SQL table for type: trebuchetsettings

                at

org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.queryDistributedSql(IgniteH2Indexing.java:1248)

                at

org.apache.ignite.internal.processors.query.GridQueryProcessor$8.applyx(GridQueryProcessor.java:2068)

                at

org.apache.ignite.internal.processors.query.GridQueryProcessor$8.applyx(GridQueryProcessor.java:2066)

                at

org.apache.ignite.internal.util.lang.IgniteOutClosureX.apply(IgniteOutClosureX.java:36)

                at

org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:2445)

                at

org.apache.ignite.internal.processors.query.GridQueryProcessor.queryDistributedSql(GridQueryProcessor.java:2065)

                at

org.apache.ignite.internal.processors.query.GridQueryProcessor.querySql(GridQueryProcessor.java:2045)

                at

org.apache.ignite.internal.processors.cache.IgniteCacheProxyImpl.query(IgniteCacheProxyImpl.java:582)

                ... 4 more

 

 

 

--

Sent from: http://apache-ignite-users.70518.x6.nabble.com/