Topic
  • 5 replies
  • Latest Post - ‏2013-04-05T03:55:14Z by TulasiDas
OptimDev
OptimDev
54 Posts

Pinned topic Optim View error

‏2013-04-02T20:37:44Z |
Hello All,
I have created a view in a DB and trying to extract the same using Optim .Unfortunately the status of the view in optim is view error.Please let me know if there any limitations on Views accessibility in optim. If so please let me know the work around.
Thanks
Updated on 2013-04-05T03:55:14Z at 2013-04-05T03:55:14Z by TulasiDas
  • TulasiDas
    TulasiDas
    62 Posts

    Re: Optim View error

    ‏2013-04-02T22:53:15Z  
    Hi,

    Would it be possible for you to post the definition of the view?

    Thanks,
    Tulasi
  • OptimDev
    OptimDev
    54 Posts

    Re: Optim View error

    ‏2013-04-03T12:43:34Z  
    • TulasiDas
    • ‏2013-04-02T22:53:15Z
    Hi,

    Would it be possible for you to post the definition of the view?

    Thanks,
    Tulasi
    Select
    test_copy.test_copy_ID,test_copy.Payment_ID,test_copy.cousin_Role_ID,test_copy.Provider_ID,cousin.Last_Name,test_copy.Address,test_copy.City,test_copy.State_Code,test_copy.Country_Code,test_copy.Zip_Code,test_copy.Recipient_Ind
    from cousin_role,test_copy,cousin
    where test_copy.cousin_role_id=cousin_role.cousin_role_id
    and cousin.cousin_id=cousin_role.cousin_id
  • OptimDev
    OptimDev
    54 Posts

    Re: Optim View error

    ‏2013-04-03T12:47:41Z  
    • TulasiDas
    • ‏2013-04-02T22:53:15Z
    Hi,

    Would it be possible for you to post the definition of the view?

    Thanks,
    Tulasi
    Thanks for the quick response. I have used Inner join before and optim has thrown the same error.So i went ahead and changed the query to a where clause and it still did not work.Please let me know if there are any rules in creating a view so that optim can access it successfully.
  • OptimDev
    OptimDev
    54 Posts

    Re: Optim View error

    ‏2013-04-03T12:52:25Z  
    • OptimDev
    • ‏2013-04-03T12:47:41Z
    Thanks for the quick response. I have used Inner join before and optim has thrown the same error.So i went ahead and changed the query to a where clause and it still did not work.Please let me know if there are any rules in creating a view so that optim can access it successfully.
    Just to add on, these views are working fine in the DB level
  • TulasiDas
    TulasiDas
    62 Posts

    Re: Optim View error

    ‏2013-04-05T03:55:14Z  
    • OptimDev
    • ‏2013-04-03T12:52:25Z
    Just to add on, these views are working fine in the DB level
    Can give below details:

    1) Optim Version
    2) Which database and it's version

    If possible please attach Optim trace file