Load function though interactive interface

Roger · December 13, 2003, 1:16am

Listed below is my xml file I am loading to a collection.
<?xml version="1.0" encoding="utf-8" ?>
<ino:request xmlns:ino=“http://namespaces.softwareag.com/tamino/response2”>
<ino:object ino:docname=‘’>

<acct_info>
<levy_year>2003</levy_year>
x
</acct_info>

US BANK NATIONAL ASSN C O AMY HERNESMAN
<mailing_address>2800 E LAKE ST</mailing_address>
<city_state>MINNEAPOLIS, MN </city_state>
55406

<levy_misc>
<legal_desc>PLAT PAGE 396-13 NEIGHBORHOOD 6460</legal_desc>
</levy_misc>

WISCONSIN AV
777
MILWAUKEE
53202
E

<levy_info>
<city_due>3,565,186.25</city_due>
<city_paid>0.00</city_paid>
<county_due>1,082,589.00</county_due>
<county_paid>0.00</county_paid>
<special_assessments>260,348.58</special_assessments>
<special_charges>0.00</special_charges>
</levy_info>

</ino:object>
</ino:request>

This is the error I receive.

<?xml version="1.0" encoding="ISO-8859-1" ?>
- <ino:response xmlns:ino=“http://namespaces.softwareag.com/tamino/response2” xmlns:xql=“XQL FAQ (XML Query Language - Frequently Asked Questions)”>
- <ino:message ino:returnvalue=“0”>
ino:messagelinedocument processing started</ino:messageline>
</ino:message>
- <ino:message ino:returnvalue=“7722”>
<ino:messagetext ino:code=“INOXDE7722”>(cvc-particle.2.1): element content missing, minOccurs constraint violation in element declaration</ino:messagetext>
ino:messagelineLine 5, Column 14: Line 5, Column 14: [element “acct_info” in element “TaxInfo”]</ino:messageline>
</ino:message>
</ino:response>

How do I insert data into the collection?

Harald_Lemmin · December 15, 2003, 12:34pm

The error message says what it is:
“element content missing” - something is missing in the instance

“minOccurs constraint violation” - In the schema something has a minOccurs constraint = something is defined to occur at least for x times.

“element “acct_info” in element “TaxInfo””
==> some acct_info element is missing.

Check your schema against your instance.

Guest · December 15, 2003, 4:08pm

You haven’t shown us your schema, but the error message indicates that your instance document has been rejected because it is invalid against the schema.

Michael Kay

Roger · December 16, 2003, 7:52pm

<?xml version = "1.0" encoding = "UTF-8"?>

closed

4.1.4.1
2003-12-10T10:48:00.984-06:00
2003-12-10T10:48:00.984-06:00
TSD4

Roger · December 16, 2003, 9:24pm

Here is my latest XML I am attempting to load and the schema I have defined. I also included the latest message. I guess I am missing something here and just don’t see it.
Sincerely, Roger

encoding is set to windows-1252
<?xml version="1.0" encoding="utf-8" ?>
<ino:request xmlns:ino=“http://namespaces.softwareag.com/tamino/response2”>
<ino:object ino:docname=‘’>

<acct_info>
<levy_year>2003</levy_year>
x
</acct_info>
<levy_misc>
<legal_desc>PLAT PAGE 396-13 NEIGHBORHOOD 6460</legal_desc>
</levy_misc>

WISCONSIN AV
777
MILWAUKEE
53202
E

<levy_info>
<city_due>3,565,186.25</city_due>
<city_paid>0.00</city_paid>
<county_due>1,082,589.00</county_due>
<county_paid>0.00</county_paid>
<special_assessments>260,348.58</special_assessments>
<special_charges>0.00</special_charges>
</levy_info>

</ino:object>
</ino:request>

<?xml version = "1.0" encoding = "UTF-8"?>
<xs:schema xmlns:tsd = “http://namespaces.softwareag.com/tamino/TaminoSchemaDefinition” xmlns:xs = “XML Schema”>
xs:annotation
xs:appinfo
<tsd:schemaInfo name = “TaxInfoSchema”>
<tsd:collection name = “TaxInfo”></tsd:collection>
<tsd:doctype name = “TaxInfo”>
tsd:logical
tsd:contentclosed</tsd:content>
</tsd:logical>
</tsd:doctype>
tsd:adminInfo
tsd:server4.1.4.1</tsd:server>
tsd:modified2003-12-10T10:48:00.984-06:00</tsd:modified>
tsd:created2003-12-10T10:48:00.984-06:00</tsd:created>
tsd:versionTSD4</tsd:version>
</tsd:adminInfo>
</tsd:schemaInfo>
</xs:appinfo>
</xs:annotation>
<xs:element name = “TaxInfo”>
xs:complexType
xs:sequence
<xs:element ref = “Owner” minOccurs = “0” maxOccurs = “unbounded”></xs:element>
<xs:element ref = “address” minOccurs = “0”></xs:element>
<xs:element ref = “payment_dtl” minOccurs = “0” maxOccurs = “unbounded”></xs:element>
<xs:element ref = “bond” minOccurs = “0”></xs:element>
<xs:element ref = “acct_info” minOccurs = “0” maxOccurs = “unbounded”></xs:element>
<xs:element ref = “lottery” minOccurs = “0”></xs:element>
<xs:element ref = “levy_info” minOccurs = “0” maxOccurs = “unbounded”></xs:element>
<xs:element ref = “remarks” minOccurs = “0” maxOccurs = “unbounded”></xs:element>
<xs:element ref = “levy_misc” minOccurs = “0” maxOccurs = “unbounded”></xs:element>
</xs:sequence>
<xs:attribute name = “taxkey” type = “xs:string” use = “required”>
xs:annotation
xs:appinfo
tsd:attributeInfo
tsd:physical
tsd:native
tsd:index
tsd:standard</tsd:standard>
</tsd:index>
</tsd:native>
</tsd:physical>
</tsd:attributeInfo>
</xs:appinfo>
</xs:annotation>
</xs:attribute>
</xs:complexType>
</xs:element>
<xs:element name = “Owner”>
xs:complexType
<xs:sequence minOccurs = “0” maxOccurs = “unbounded”>
<xs:element ref = “name” minOccurs = “0” maxOccurs = “unbounded”></xs:element>
<xs:element ref = “mailing_address” minOccurs = “0”></xs:element>
<xs:element ref = “city_state” minOccurs = “0” maxOccurs = “unbounded”></xs:element>
<xs:element ref = “zip” minOccurs = “0”></xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name = “acct_info”>
xs:complexType
<xs:sequence minOccurs = “0”>
<xs:element ref = “levy_year” minOccurs = “0”></xs:element>
<xs:element ref = “subacct” minOccurs = “0” maxOccurs = “unbounded”></xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name = “address”>
xs:complexType
<xs:sequence minOccurs = “0”>
<xs:element ref = “street” minOccurs = “0”></xs:element>
<xs:element ref = “housenumber” minOccurs = “0”></xs:element>
<xs:element ref = “city” minOccurs = “0”></xs:element>
<xs:element ref = “postcode” minOccurs = “0”></xs:element>
<xs:element ref = “dir” minOccurs = “0”></xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name = “levy_misc”>
xs:complexType
<xs:sequence minOccurs = “0” maxOccurs = “unbounded”>
<xs:element name = “legal_desc” type = “xs:string” minOccurs = “0” maxOccurs = “unbounded”></xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name = “remarks” type = “xs:string”></xs:element>
<xs:element name = “name” type = “xs:string”></xs:element>
<xs:element name = “mailing_address” type = “xs:string”></xs:element>
<xs:element name = “city_state” type = “xs:string”></xs:element>
<xs:element name = “zip” type = “xs:string”></xs:element>
<xs:element name = “street” type = “xs:string”></xs:element>
<xs:element name = “housenumber” type = “xs:string”></xs:element>
<xs:element name = “city” type = “xs:string”></xs:element>
<xs:element name = “postcode” type = “xs:string”></xs:element>
<xs:element name = “payment_dtl” type = “xs:string”></xs:element>
<xs:element name = “fax” type = “xs:string”></xs:element>
<xs:element name = “legal_desc” type = “xs:string”></xs:element>
<xs:element name = “taxkey” type = “xs:string”></xs:element>
<xs:element name = “chk_digit” type = “xs:string”></xs:element>
<xs:element name = “subacct” type = “xs:string”></xs:element>
<xs:element name = “levy_year” type = “xs:string”></xs:element>
<xs:element name = “bond” type = “xs:string”></xs:element>
<xs:element name = “lottery” type = “xs:string”></xs:element>
<xs:element name = “levy_info”>
xs:complexType
<xs:sequence minOccurs = “0” maxOccurs = “unbounded”>
<xs:element ref = “city_due” minOccurs = “0”></xs:element>
<xs:element ref = “city_paid” minOccurs = “0”></xs:element>
<xs:element ref = “county_due” minOccurs = “0”></xs:element>
<xs:element ref = “county_paid” minOccurs = “0”></xs:element>
<xs:element ref = “special_charges” minOccurs = “0”></xs:element>
<xs:element ref = “special_assessments” minOccurs = “0”></xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name = “city_due” type = “xs:string”></xs:element>
<xs:element name = “city_paid” type = “xs:string”></xs:element>
<xs:element name = “county_due” type = “xs:string”></xs:element>
<xs:element name = “county_paid” type = “xs:string”></xs:element>
<xs:element name = “special_charges” type = “xs:string”></xs:element>
<xs:element name = “special_assessments” type = “xs:string”></xs:element>
<xs:element name = “dir” type = “xs:string”></xs:element>
</xs:schema>
<?xml version="1.0" encoding="windows-1252" ?>

- <ino:response xmlns:ino=“http://namespaces.softwareag.com/tamino/response2” xmlns:xql=“XQL FAQ (XML Query Language - Frequently Asked Questions)”>
- <ino:message ino:returnvalue=“0”>
ino:messagelinedocument processing started</ino:messageline>
</ino:message>
- <ino:message ino:returnvalue=“7730”>
<ino:messagetext ino:code=“INOXDE7730”>(cvc-model-group.1):invalid end of sequence</ino:messagetext>
ino:messagelineLine 12, Column 12: Line 12, Column 12: [element “address” in element “TaxInfo”]</ino:messageline>
</ino:message>
</ino:response>

Dr_Harald_Schoening · December 18, 2003, 3:24pm

Hi Roger,

according to your schema, TaxInfo must not contain a child element “address”. Also, levy_info should come before levy_misc.

Regards

Harald