Domain Model with Oracle

Hi Faris,

We are currently investigating the problem and will let you know once we have more information.

Regards,
Alexander
the Telerik team

Hi Faris,

We managed the reproduce the problem with the following setup - we had two schemas and a foreign key constraint between a table from the first schema and a table from the second. So far everything should work fine except if one of the schemas has name ending on "SYS". We are filtering the tables read from those schemas and thereby they cannot be found later. If this is not your case, please let us know so we can investigate further.
We will fix this for the next build which should be available in a few weeks. Unfortunately I am not able to give you an exact date.

Regards,
Alexander
the Telerik team

Hi Alexander 

Thanks for your reply ,,
No , its not my case ..

But today I solve this problem ,, Its working from machine ,, did you know why , 

I gave my oracle account the DBA permission from system account ,,
by this command : Grant dba to submissions
Its joke ,,

Anyway , the question is , as I am developer , not as Oracle DBA person , Which is the suitable/minimum permissions need to have to access my oracle db and build my domain model from the OpenAccess .. ???
Since I am working from my personal pc  , but when go to my work , I don't have any dba permission ,, 

Regards
Faris

Hi Alexander ,

Again , I want to ask regarding Domain model , the problem still exists when I connect to Oracle 9.2 at my work .
Same error message appear , But I have fresh copy from oracle 10g installed , in my machine , and every thing fine ,

But I want to tell you that , I have one schema called "Submission" ,and its not related to any other schamas ,
 but I see that there are some schemas found on the database ending with "sys" , but I don't know if had a foreign keys between this schema and another .

Attached pictures shows that there are two or three schema ending with "SYS" ,
So, what do you mean by "We are filtering the tables read from those schemas and thereby they cannot be found later" .
I need help how to fix this issue , and test where is exacly the problem , and find which schemas that causes ..??

Thanks for help ,,

Faris

Hello Faris,

Sorry for the delayed reply.

While obtaining information for an Oracle database, we filter out certain system schemas in order to avoid reading in unnecessary (in most cases) information. To do this we have a filter that filters out schemas ending in 'SYS'.
The error 'Value cannot be null', occurs when you have a FK constraint between 2 tables and we cannot read the information for the destination table. This might be because the existing credentials do not have rights to read information of this table (maybe because it is in another schema and there are no rights to read this schema).

Is this the situation in your case? Do you have references across schemas in your database or limited rights to certain tables?

Kind regards,
Ady
the Telerik team

Hello Ady ,

My case is as follow :

I create new schema and I put all the tables I need inside it , and its not have any relations to other schemas  , 
I already test this issue with system account to create new domain model item , but unfortunately ,its same error message ,, 
So the problem occurred again with system account ,
I appreciate your help ,

if you need any clarification in my case , please send it to me ,

Best Regards
Faris

Hi Faris,

 This problem has been fixed in the latest internal build, released yesterday. Can you please try and update to this build? This should fix the problem.

Do get back to us in case you need further assistance.

Kind regards,
Ady
the Telerik team

Thanks a lot,,

I will try it ,