Hi
My schema details are as follows
Control utility [ver. 2.16.0#20231215-sha1:7bde6a42]
2023 Copyright(C) Apache Software Foundation
User: root
Time: 2024-12-10T11:17:06.581
Command [SYSTEM-VIEW] started
Arguments: --host 127.0.0.1 --port 11211 --system-view TABLES
--------------------------------------------------------------------------------
Results from node with ID: 958566f3-ce53-4622-98a6-45966c5e0d3a
---
cacheGroupId cacheGroupName cacheId cacheName
schemaName tableName
affinityKeyColumn keyAlias valueAlias keyTypeName
valueTypeName isIndexRebuildInProgress
282242314 Test1Model 282242314 Test1Model
Test1Model TEST1SMODEL
null null null java.lang.String
Models.StaticCacheModels.Test1Model false
-374251535 Test2Model -374251535 Test2Model
Test2Model TEST2MODEL null null null
java.lang.String Models.StaticCacheModels.Test2Model false
---
Command [SYSTEM-VIEW] finished with code: 0
Control utility has completed execution at: 2024-12-10T11:17:07.248
Execution time: 667 ms
Is it an exact copy of the error?
Yesy its error text except modelname/ business model name replace by Test
Thanks & Regards,
Charlin
On Tue, 10 Dec 2024 at 22:26, Ilya Shishkov <shishkovi...@gmail.com> wrote:
> > Failed to parse query. Schema \"TEST1MODEL\" not found
>
> This tells that the schema was not found, but it is something strange
> in above error:
> > 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]
>
> Compare with this statement:
> > Caused by: javax.cache.CacheException: Failed to parse query. Schema
> \"TEST1MODEL\" not found; SQL statement:\nselect * from
> Test1Model.TEST2MODEL as t1, Test2Model.TEST2MODEL t2...
>
> Is it an exact copy of the error?
>
> Can you also attach output of SYS.TABLES for Test1Model and Test2Model?
>
> вт, 10 дек. 2024 г. в 18:51, Charlin S <charli...@hotelhub.com>:
> >
> > 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
> >> >> >>> >> >
> >> >> >>> >> >
> >> >> >>> >> >
>
