SOLVED: element in the XML input doesn't exist in the source

dataservices job design
1

I’m facing some troubles importing an XML file based on a XML schema.

The job terminates because of a missing element in the XML Source:

4592	9060	XML-240108	12-2-2013 16:39:15	An element named <logical-test> present in the XML data input does not exist in the XML format used to set up this XML source

XML Notepad 2007 validates the XML and schema without any problem…

I’ve updated my BODS install to the latest 4.0 version, 14.0.3.451.

XML File: http://static.nvd.nist.gov/feeds/xml/cve/nvdcve-2.0-2013.xml
XML Schema: http://nvd.nist.gov/schema/nvd-cve-feed_2.0.xsd

When creating the XML Schema format i have used the following configuration:
Format: nvd_cve_feed_20
File name: C:\Temp\nvd-cve-feed_2.0.xsd
Namespace: http://scap.nist.gov/schema/feed/vulnerability/2.0
Root element: nvd
Circular level: 0
Default varchar: 1024

I’ve also downloaded the following XML schemas:
http://nvd.nist.gov/schema/cpe-language_2.1.xsd
http://nvd.nist.gov/schema/cce_0.1.xsd
http://nvd.nist.gov/schema/cve_0.1.xsd
http://nvd.nist.gov/schema/vulnerability_0.4.xsd
http://nvd.nist.gov/schema/scap-core_0.1.xsd
http://nvd.nist.gov/schema/patch_0.1.xsd
http://nvd.nist.gov/schema/cvss-v2_0.2.xsd

Thank you in advanced

bas_vdl :netherlands: (BOB member since 2012-11-08)

2

I found the problem in the http://nvd.nist.gov/schema/cpe-language_2.1.xsd. BODS didn’t recognize the recursive part where a logical-test element can be a child of the logical-test element itself.

I changed the circular level to 1 and that solved the problem.

bas_vdl :netherlands: (BOB member since 2012-11-08)