Invalid object name 'voa_keygen'.

[amir sherafatian]

hi
(i use multi database)

and my senario is fetch data from one data base by using reverse mapping, converting to new object in a intermediate windows application and add new object in another darabase by using forward mapping

first i get a scope of forward mapping classlibrary by this code :

ObjectScopeProvider1.AdjustForDynamicLoad();
_scope = Database.Get("DatabaseConnectionEEOptimizer").GetObjectScope();

 and then i try to get one instance of object scope of reverse mapping class library to fetch data by this code :

ObjectScopeProvider1.AdjustForDynamicLoad();
_scope = Database.Get("DatabaseConnectionISO").GetObjectScope(); 

but when i want to get scope by code mentioned above i have this exception :

Telerik.OpenAccess.RT.sql.SQLException: Invalid object name 'voa_keygen'.
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.StatementImp.executeQuery(String sql)
   at OpenAccessRuntime.Relational.sql.HighLowRelationalKeyGenerator.IsCached(Connection con, RelationalKeyGeneratorInfoCache infoCache, String tab, String kCol, String vCol, String key, Boolean& ret)
   at OpenAccessRuntime.Relational.sql.HighLowRelationalKeyGenerator.init(String className, RelationalTable theClassTable, Connection con, RelationalKeyGeneratorInfoCache relationalKeyGeneratorInfoCache)
   at OpenAccessRuntime.Relational.RelationalStorageManagerFactory.init(Boolean full)

i use reverse mapping class library for fetch data and after converting in a intermediate windows application, by using forward mapping i try to add data to another database

how can i solve my problem ?

[amir sherafatian]

can any body help me?

[Joebet]

Well lets just admit it Telerik Open Access ORM is a great tool. But there support team sucks. every ticket we post takes 2 - 3 days to be answered or replied. And for your topic its been 4 months without any answer.

[Serge]

Hello Joebet,

This post was in fact a double thread and we have answered in a timely fashion to Amir. I am sorry if you have felt that we are not fast enough but one has to note that we have been under a lot of pressure around the last release.

Be sure not to hold back any though you have on this matter. Thanks again for pointing this out, I can assure you that we will do our best to live up to your expectations.

Greetings,
Serge
the Telerik team

[Brad]

so where's the other "double" thread?

[Serge]

Hi amir sherafatian,

 Unfortunately the other thread is a Product Feedback one and thus cannot be exposed to the public. We will be more than happy to address any issues you might have, however please do open separate support tickets for them. 

Regards,
Serge
the Telerik team

[Behnam]

I downloaded you products and start testing that.
I am not your customer yet, but I have this problem. what should I do?

[Serge]

Hello Brad,

 Can you please explain you exact problem, what the exception states and when did it start occuring. Are you using the new designer or the old wizards approach. Usually this exception means that the lookup table for the internal identity generator could not be found. Can you please make sure that every class you have has its identity specified and also make sure that the view have identities as well. 

If you are using the designer you can also have a look at the validation framework and see if something pops up there. 

I am looking forward to resolving this issue with you.

Regards,
Serge
the Telerik team