ODIExperts.com

The blog for Oracle Data Integrator ( ODI )

Exception – getobjectname schema

This error occurs when you have multiple schemas but no default schema defined.

Go to Topology – > Physical Architecture – >  Technology – > Data Server .

Edit the physical server that you want to be the default and under the Definition, there is a  check box "Default" ,check mark it and rerun the Interface.

Mark the correct physical schema to default and rerun the Interface.

8 Comments

  1. Hi Cezar,

    “Thanks a Ton..” for the update.

    Can i get some answers for my other question (As requested earlier) :
    Regarding the “copy the XML in the agent server is located and accordingly configure the path in the topology ” . We have the agent installed on Linux system. Can you please help me in the complete(step by step) process of placing the xml files in agent server and configuring the path in topology.

    Thanks & Regards,
    Kalyan

  2. Hi Devendra,

    Regarding the “copy the XML in the agent server is located and accordingly configure the path in the topology ” . We have the agent installed on Linux system. Can you please help me in the complete(step by step) process of placing the xml files in agent server and configuring the path in topology. It will be extremely gratefull if i get this help ,as i am completely unaware of this process and also my customer is literally sitting on my head.

    Thanks in advance. Also looking forward for your comment on the other xml request raised.

    Regards,
    Kalyan

  3. Hi,

    I have my source as Oracle and the target as xml.
    I have a comment field in Oracle table. I want that comment field to get created dynamically on xml target table during the ODI integration.
    Is there any posibility to do this on ODI. Please provide the steps to perform this.

    This is a requirement for one of my customer and he needs immediate solution for this as they are having golive next week.
    Immediate response is appereciated.

    Thanks in advance.

    Kalyan

    • Hi Kalyan,

      Yes, once you can query the comment view from Oracle Metadata, make the integration to a temporary table, after that, query the metadata for the comment updating the correpondent column in the temp table and, then, build an interface from the temp table to xml.

      Make any sense?

  4. Hi Devendra,

    I think the remote agent had no access to the XML File. Can you please let me know ,How do we check this (or) How do we configure the agent to get access to the xml file.

    Thanks,
    Kalyan

  5. Hi All,

    I try to load a XML file automatically in Oracle Database via ODI :
    I created my database server in the Topology with the following URL :
    jdbc : snps: xml?f=/rep1/fichier.xml&ro=false&cs=false&s=FIC&ldoc=true&dp_driver=oracle.jdbc.driver.OracleDriver&dp_url=URL_BASE&dp_user=admin&dp_password=NHJLMMOCNCDDGEGHDFGGGM&dp_schema=TEST

    My Reverse worked and loaded the tables related to each datastore XML.

    In my Interface, I put a XML table as source and an Oracle table as target (KM : LKM SQL to SQL and IKM SQL Incremental Update).

    When executing with a local Agent from Designer, my Interface works fine.
    On a remote Agent from Designer, I get the following error:
    “0 : null : java.sql.SQLException: ORA-00933: SQL command not properly ended”
    At the step :”Load data”.
    The remote Agent is on a Linux server.
    I did the same test with the demo file GEO_DIM.xml and it works locally, but not on the server.
    The XML and Oracle drivers are the same locally and on the server.

    Please provide your inputs for this issue.

    Thanks,
    Kalyan

Leave a Reply

Required fields are marked *.