> 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
>> >> >>> >> >
>> >> >>> >> >
>> >> >>> >> >
