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