Skip to content
July 25, 2013 / João Lobato Dias

ODI: reverse operation on XML model fails with exception from Jython

Problem:

While attempting to perform the reverse engineering of an XML data model from an XSD file, using the module “RQM SQL (JYTHON)”, the process may fail with the following error message:

    ODI-1217: Session testXMLv2 (6347003) fails with return code 7000.
    ODI-1226: Step testXMLv2 fails after 1 attempt(s).
    ODI-1229: An error occurred while performing a Reverse operation on model code TESTXMLV2.
    Caused By: org.apache.bsf.BSFException: exception from Jython:
    Traceback (most recent call last):
      File "", line 19, in 
      File "", line 68, in __init__
    AttributeError: 'NoneType' object has no attribute 'getMetaData'

Technical Explanation:

Regrettably, this is a generic, low-level error in the Jython code. This is an uncaught exception pertaining to the incorrect instantiation of auxiliary objects in the Jython runtime.

This is, in fact, a Jython error instead of an ODI one. This difficults the diagnosis of the problem as well as the search for information related to the error.

Solution:

In a nutshell, the most likely cause for this error is the inability for the ODI Agent to access the XSD file.

So far, we have successfully solved this problem using the following strategy:

  1. Check if the file path for the XSD file in the XML Data Store is correct (parameter “d” in the XML Driver URL).
  2. Check the permissions for the XSD file. Remember that the user of the ODI Agent must have read permissions for the file.
  3. Check if you are using the correct ODI Agent. If you are not using a local ODI Agent for the Model reverse engineering, it is possible that your physical agent and the XSD file are actually in a different machine! This might seem unlikely, but remember that the logical agent may link to different physical agents depending on the selected context.
  4. Assuming your ODI agent and XSD are in different machines, check the connection between the machines.
Advertisements

2 Comments

Leave a Comment
  1. spis serwisów www / Sep 9 2013 12:36 pm

    I’m not tat much of a online reader to be honest but your
    sites really nice, keep it up! I’ll go ahead and bookmark your site to come back later on.
    Many thanks

  2. arjun / May 30 2016 11:46 am

    very good Answers

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: