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