Hi,
Thank you for your email. I have checked the schema name used before the
table name.
The error message as below
Failed to parse query. Schema \"TEST1MODEL\" not found; SQL
statement:\nselect * from Test1Model.TEST1MODEL as t1,
Test2Model.TEST2MODEL t2 where t1.Code = t2.Code WHERE
t1.CountryCode='IND' [90079-197]"
class org.apache.ignite.IgniteCheckedException: Failed to parse query.
Schema \"TEST1MODEL\" not found; SQL statement:\nselect * from
Test1Model.TEST1MODEL as t1, Test2Model.TEST2MODEL t2 where t1.Code =
t2.Code WHERE t1.CountryCode='IND' [90079-197]\r\n\tat
org.apache.ignite.internal.processors.platform.utils.PlatformUtils.unwrapQueryException(PlatformUtils.java:528)\r\n\tat
org.apache.ignite.internal.processors.platform.cache.PlatformCache.runFieldsQuery(PlatformCache.java:1418)\r\n\tat
org.apache.ignite.internal.processors.platform.cache.PlatformCache.processInStreamOutObject(PlatformCache.java:1006)\r\n\tat
org.apache.ignite.internal.processors.platform.PlatformTargetProxyImpl.inStreamOutObject(PlatformTargetProxyImpl.java:79)\r\nCaused
by: javax.cache.CacheException: Failed to parse query. Schema
\"TEST1MODEL\" not found; SQL statement:\nselect * from
Test1Model.TEST2MODEL as t1, Test2Model.TEST2MODEL t2...
at Apache.Ignite.Core.Impl.PlatformJniTarget.InStreamOutObject(Int32
type, Action`1 writeAction)
at Apache.Ignite.Core.Impl.PlatformTargetAdapter.DoOutOpObject(Int32
type, Action`1 action)
at
Apache.Ignite.Core.Impl.Cache.CacheImpl`2.QueryFieldsInternal(SqlFieldsQuery
qry)
at Apache.Ignite.Core.Impl.Cache.CacheImpl`2.Query(SqlFieldsQuery qry)
at IgniteRepository.IgniteSQLQuery(String countryCode)
Thanks & Regards,
Charlin
On Tue, 10 Dec 2024 at 20:07, Ilya Shishkov <shishkovi...@gmail.com> wrote:
> Have you checked the schema name and table name in the system view?
>
> Can you attach full error output?
>
> вт, 10 дек. 2024 г. в 14:22, Charlin S <charli...@hotelhub.com>:
> >
> > Hi,
> > Same issue even if I run the query with schema name Test2Model.TEST2MODEL
> >
> > Thanks & Regards,
> > Charlin
> >
> >
> >
> > On Tue, 10 Dec 2024 at 15:26, Ilya Shishkov <shishkovi...@gmail.com>
> wrote:
> >>
> >> You should explicitly add the schema name in the specified table
> >> names. By default schema is the same as cache name. You can chet it in
> >> the SYS.TABLES system view.
> >>
> >> вт, 10 дек. 2024 г. в 12:38, Charlin S <charli...@hotelhub.com>:
> >> >
> >> > Hi
> >> > var cacheCfgTest1Model = new CacheConfiguration("Test1Model", new
> QueryEntity(typeof(test1Model)));
> >> > var cacheCfgTest2Model = new CacheConfiguration("Test2Model",
> new QueryEntity(typeof(Test2Model)));
> >> > Test1Icache=_ignite.GetOrCreateCache<string,
> Test1Model>(cacheCfgTest1Model);
> >> > Test2Icache=_ignite.GetOrCreateCache<string,
> Test2Model>(cacheCfgTest2Model);
> >> >
> >> > var qry = Test1Icache.Query(new SqlFieldsQuery("select * from
> Test1Model as t1, Test2Model t2 where t1.Code = t2.Code WHERE
> t1.CountryCode='IND'")).GetAll();
> >> >
> >> > error while executing above line (Test1Icache.Query): Test2Model
> table not found
> >> >
> >> > Thanks
> >> > Charlin
> >> >
> >> >
> >> >
> >> > On Tue, 10 Dec 2024 at 14:53, Stephen Darlington <
> sdarling...@apache.org> wrote:
> >> >>
> >> >> Please share the code you use to create the cache and the code where
> you're getting "unknown cache" errors. As a general rule, we can't guess
> what's happening. We need to see logs and/or code.
> >> >>
> >> >> On Tue, 10 Dec 2024 at 07:06, Ilya Shishkov <shishkovi...@gmail.com>
> wrote:
> >> >>>
> >> >>> > table not found error
> >> >>>
> >> >>> When do you obtain this error?
> >> >>>
> >> >>> > I have created cache through cache api
> >> >>>
> >> >>> Have you specified query entities in the cache?
> >> >>>
> >> >>> пн, 9 дек. 2024 г. в 18:14, Charlin S <charli...@hotelhub.com>:
> >> >>> >
> >> >>> > Hi
> >> >>> > I have created cache through cache api
> >> >>> >
> >> >>> > Thank you
> >> >>> > Charlin
> >> >>> >
> >> >>> > On Mon, 9 Dec, 2024, 8:18 pm Ilya Shishkov, <
> shishkovi...@gmail.com> wrote:
> >> >>> >>
> >> >>> >> Hi Charlin,
> >> >>> >>
> >> >>> >> Did you create the tables via DDL or Cache API?
> >> >>> >>
> >> >>> >> пн, 9 дек. 2024 г. в 14:21, Charlin S <charli...@hotelhub.com>:
> >> >>> >> >
> >> >>> >> > Hi All,
> >> >>> >> > I am facing one problem with Ignite 2.16, which was not there
> in 2.10(my old Ignite version).
> >> >>> >> > Two cluster nodes(Linux server).,
> >> >>> >> > 1 client node C# application hosted on Windows machine for
> pushing data to cache and 1 more client node for C# application which is
> reading data from Ignite cache and this service having table not found
> error for some cache cache model but cache model exists in grid.
> >> >>> >> >
> >> >>> >> > Thanks & Regards,
> >> >>> >> > Charlin
> >> >>> >> >
> >> >>> >> >
> >> >>> >> >
>
