Domain Model with Oracle

9 posts, 1 answers
  1. Faris
    Faris avatar
    7 posts
    Member since:
    Jul 2010

    Posted 21 Jul 2010 Link to this post

    Dear Sir,

    But when I add new Domain Model item to connect Oracle database  ,and after entering connection string , it comes us with error message , said to me the following error with popup window:

    " Connection Error : ExceptionSystem , ArgumentNullException,
    Details: Value cannot be null.
     Parameter name : Key"

    Is this general error , or what ,,

    However , I create domain model with SQLExpress and its working fine ,, no problem with it ,

    I use VS 2010 .
    I need your help please ,,

    Faris
  2. Alexander
    Admin
    Alexander avatar
    727 posts

    Posted 21 Jul 2010 Link to this post

    Hi Faris,

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

    Regards,
    Alexander
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  3. DevCraft banner
  4. Alexander
    Admin
    Alexander avatar
    727 posts

    Posted 22 Jul 2010 Link to this post

    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
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  5. Faris
    Faris avatar
    7 posts
    Member since:
    Jul 2010

    Posted 22 Jul 2010 Link to this post

    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

  6. Faris
    Faris avatar
    7 posts
    Member since:
    Jul 2010

    Posted 26 Jul 2010 Link to this post

    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





  7. Ady
    Admin
    Ady avatar
    589 posts

    Posted 30 Jul 2010 Link to this post

    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
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  8. Faris
    Faris avatar
    7 posts
    Member since:
    Jul 2010

    Posted 30 Jul 2010 Link to this post

    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


  9. Answer
    Ady
    Admin
    Ady avatar
    589 posts

    Posted 05 Aug 2010 Link to this post

    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
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  10. Faris
    Faris avatar
    7 posts
    Member since:
    Jul 2010

    Posted 06 Aug 2010 Link to this post

    Thanks a lot,,

    I will try it ,
Back to Top
DevCraft banner