Welcome and thank you for joining our new OpenText forum. Your questions, responses, best practices, and tips shared with other members will help make this channel vibrant. We're glad you're joining us and look forward to collaborating with you online.

Check out the Getting Started With OpenText Forums for tips on personalizing your experience.

Problem with XML data source

crowt999crowt999 Junior Member
edited December 31, 1969 in Designing Analytics Reports
Hello all!

I am building an XML data source with the following structure, with the goal of returning the VALUE_DATE, NAV_ID from the INDEX section, and the NAV_ID and VALUE_DATE from the STUB section (renamed to STUB_NAV_ID and STUB_VALUE_DATE)

The XPATH expression is: /INDEX/STUB_set/STUB

<?xml version="1.0"?>

22984
TEST
TEST Name
Oct 18 2007 10:10:05:373PM
Oct 18 2007 10:10:05:380PM
5/31/07
6/30/07
NAV




6/30/07



6/11/07




This will return:
VALUE_DATE NAV_ID STUB_NAV_ID STUB_VALUE_DATE
6/30/07 310 309 6/30/07
6/30/07 310 308 6/11/07

In some cases, the XML will not have a stub set of data, and look like this:

<?xml version="1.0"?>

22984
TEST
TEST Name
Oct 19 2007 4:21:56:300PM
Oct 19 2007 4:21:56:303PM
8/31/07
9/30/07
NAV

USD



This used to return:

VALUE_DATE NAV_ID STUB_NAV_ID STUB_VALUE_DATE
6/30/07 310

My problem is that when I originally developed the report that uses this, it worked in the development tool. I was able to preview the data in the data source, and when running the report in Eclipse, it worked fine.
The report was released, and runs through our birt server with no problem.

Now ? all of the sudden, when the second sample XML is previewed in the data set, it returns nothing? The first file will return the proper 2 rows. I can no longer preview the report in the DEV environment, bu the strange thing is that the report still works when run through the server?

Does anyone have a clue as to why this would stop working in the Eclipse tool while developing the report? Could something have gotten corrupted?

I am using BIRT all in one, 2.1.2. (some of the plug-ins are ver 2.1.1)

Any help would be appreciated..
Dean

Comments

  • lpurbalpurba Junior Member
    edited December 31, 1969

    Hello all!



    --- deleted ---



    In some cases, the XML will not have a stub set of data, and look like this:



    <?xml version="1.0"?>



    22984

    TEST

    TEST Name

    Oct 19 2007 4:21:56:300PM

    Oct 19 2007 4:21:56:303PM

    8/31/07

    9/30/07

    NAV



    USD







    This used to return:



    VALUE_DATE NAV_ID STUB_NAV_ID STUB_VALUE_DATE

    6/30/07 310



    -- deleted ---



    Dean



    Hi,

    I just wonder, don't you think you have to handle non-existent stub set of data in your javascript with DOMParser? Just a thought.



    -Laurent
  • crowt999crowt999 Junior Member
    edited December 31, 1969
    Since this used to work fine, I would prefer to try & figure out why it stopped working, rather than change the data source. I could always try that as a last resort, but we are heavy into development now, and time is very short..
    Dean
Sign In or Register to comment.