XSD name missing on the XML generated using load_to_XML

dataservices realtime
1

Hello,

Step1: We have a Batch job to load a Message Table and the Data is loaded into a column in a table XML format, we use load_to_XML Transform as given below.

varchar_to_long(f_TrimSchemaLocation(load_to_xml(QRY_Load_Details.NODE, ‘Known_Data’, 0, NULL, NULL, 1, 10000000)))

The data is getting loaded into the XML but path in XML where it refers to XSD I can see the path but XSD name is not seen at the end.

Eg: Known_Data.XSD at the end of path is missing

xmlns:ns1="http://www.hhhh.xxx/projname/v1/KnownData/ieKnownData.xsd

But I am getting the path only as:

xmlns:ns1="http://www.hhhh.xxx/projname/v1/KnownData/ie

Please advice why the XSD name is missing at the end.

Step2:

We are then sending the above XML onto a JMS Message Queue and since there is no XSD name found at the end of the path in XML Jms is appending some default shcema name and is shown as below:

xsi:schemaLocation="http://www.hhhh.xxx/projname/v1/KnownData/ieADAPTER_MESSAGE_SCHEMA.xsd>

Instead of :

xsi:schemaLocation="http://www.hhhh.xxx/projname/v1/KnownData/KnownData.xsd>

Please advice.

Regards
Jack

jack1703 (BOB member since 2009-09-29)

2

what is the version of DI ?

manoj_d (BOB member since 2009-01-02)

3

The version is 11.5.?

jack1703 (BOB member since 2009-09-29)

4

can you attach the XSD and sample XML file that you are using to convert to long using load_to_xml function ?

I tried with 11.5.3.8 and both namespace and schemalocation are populated correctly in my case

or use the attached XSD and XML create a job and reproduce the issue with that and send me the ATL file
sample.zip (0.0 KB)

manoj_d (BOB member since 2009-01-02)