Configuring an xsd file to ignore any extra elements

dataservices job design
1

Hi,

I am trying to configure an xsd schema file to ignore any elements which are not defined in the xsd using xs:any/ or xs:anyAttribute/ but BODI Designer does not seem to be reading this as I keep getting an error:

196660 1029 XML-240108 5/27/2009 8:58:21 AM |Dataflow df_cpm_test|Reader READ MESSAGE CPM_CustX OUTPUT(CPM_CustX)
196660 1029 XML-240108 5/27/2009 8:58:21 AM An element named present in the XML data input does not exist in the XML format used to set up this XML source
196660 1029 XML-240108 5/27/2009 8:58:21 AM in data flow <df_cpm_test>. Please validate your XML data.
196660 1029 XML-240307 5/27/2009 8:58:21 AM |Dataflow df_cpm_test|Reader READ MESSAGE CPM_CustX OUTPUT(CPM_CustX)
196660 1029 XML-240307 5/27/2009 8:58:21 AM XML parser failed: See previously displayed error message.

Would anybody know how to solve this issue?

Thanks

Nilz07 (BOB member since 2007-05-22)

2

Hello - have you solved the xml-240108 error? I have it to…
Very respectfully,

shic1103 :us: (BOB member since 2003-10-31)

3

I have this problem as well. If you have found a solution, I would really appreciate your help.
Thanks.

joysarnelli (BOB member since 2008-07-28)

4

I also have this problem.

baylisstic (BOB member since 2010-03-31)

5

I don’t think ANY is supported, DI expects the schema to be defined before it can be used in DF, in case of ANY the schema will be dynamic

can you attach the XSD and sample XML ? I think it can work after modifying the xsd

not sure if it will be read as string (like unsupported datatype ), do you see impot unsupported datatype option whule importing the XSD ?

manoj_d (BOB member since 2009-01-02)

6

Been having a similar problem and used this in the XSD

<xs:element name=“payload” type=“xs:anyType” minOccurs=“0”/>

this then imports with a payload varchar(1024) .

when run in test all the XML between … is loaded into the varchar. Then use extract_from_xml

( anyattribute, anytype )

chris_strutt :uk: (BOB member since 2011-06-13)