XML schema import issue in 3.2

dataservices job design
1

Hello All,

We are using XML files from iTunes site and we had built our own XSD long time back and that is imported into the repository and the BODS 3.1 job is working fine till now.

We are supposed to move to a different server (which is version 3.2) and hence we moved the job as well. The problem now is that the job in the new server is not able to read the XML. We somehow do not have the actual XSD with us which was used earlier.

The XML is :
https://itunes.apple.com/us/rss/topalbums/limit=300/explicit=true/xml

I generated XSD over online using different websites, software tools and even in BODS->right click schema->Generate XML schema. But nothing worked.

Can anyone please suggest a reliable XSD generator that BODS 3.2 can use?
This might be very simple, but since I am new to XSD stuffs, I am finding it difficult.

I have attached the XSD in zip. It gets imported but the job simply crashes when executed. Also, I dont know why there are three files that gets generated when i try to create in software tools. Cant the XSD be in a single file?

Thanks in advance.

Thanks
Ramesh
oxygen3.zip (1.0 KB)

ramesh86 (BOB member since 2014-03-10)

2

xmlspy is one of the better tools on the market.

BODS 4.0 can generate a DTD from an xml file. Simply open the XML definition in BODS, click on the highest node, select “Generate DTD”.

Johannes Vink :netherlands: (BOB member since 2012-03-20)

3

I tried that, but that also does not work.

I dont have the XSD. But when I export the working job from 3.1 repository to another 3.1 repository, it works. But when the same working job in a 3.1 repository is upgraded to 3.2, the job does not work out. Any thoughts?

Thanks
Ramesh

ramesh86 (BOB member since 2014-03-10)

4

I’d start checking the patch level of BODS 3.2 and check if there SAP Notes with a similar problem.

Johannes Vink :netherlands: (BOB member since 2012-03-20)